topic Re: How to use BaseAlfrescoSpringTest in Alfresco Archive

How to use BaseAlfrescoSpringTest

legolas — Tue, 22 May 2007 14:45:40 GMT

Hi All,I am developing a custom action and would like to add a Unit test to it especially to ease the devlopment cycle.As a starting point I used the SDK custom aspect project, which contains a Unit test, but that unit test won't run.Can someone please shed some light on this?I started the org.alfre

Re: How to use BaseAlfrescoSpringTest

legolas — Thu, 24 May 2007 06:36:12 GMT

Is there nobody out there who can shed some light on this problem or did I post in the wrong forum?

Hope someone can help, it really eases the development cycle of custom actions if they can be tested outside of a running appserver that needs to be restarted each time the code has changed.

Re: How to use BaseAlfrescoSpringTest

frederick — Thu, 24 May 2007 07:30:16 GMT

When those unit tests are run, they launch an embedded Alfresco repository using the 'custom-repository.properties' config file.
There, you can specify a db schema and data folder for the embedded repository.
You can use your existing repository to run your tests in, or you can create a new repository exclusively for unit tests.
However, if you use an existing db schema, you must ensure that the 'dir.root' property in custom-repository.properties points to the folder that matches your existing schema.

E.g. in an out-of-the-box Alfresco installation on windows, dir.root is set to the absolute path '<installation-path>/alf_data'.
But the custom-repository.properties file of the SDK CustomAspect unit test defines dir.root as the relative path './alf-data' (that is relative to your execution path, e.g. your eclipse project folder).

The error you get is caused by a mismatch between your db schema and your alf_data folder. To solve it, you must change the dir.root property in your unit test to point to the folder that matches your db schema.

Regards,

Re: How to use BaseAlfrescoSpringTest

avro — Thu, 24 May 2007 08:27:49 GMT

However, if you use an existing db schema, you must ensure that the 'dir.root' property in custom-repository.properties points to the folder that matches your existing schema.

In my case the dir.root property points to ./alf_data

How do I see if it matches my existing db schema?

Re: How to use BaseAlfrescoSpringTest

legolas — Fri, 25 May 2007 06:48:25 GMT

Thank you for your clarification Frederick.
I have changed the custom-repository.properties to reflect the following, and now the unit test runs fine.

#
# Sample custom content and index data location
#

dir.root=./alf_data


#db.username=alfresco
#db.password=alfresco

#
# MySQL connection (This is default and requires mysql-connector-java-3.1.12-bin.jar, which ships with the Alfresco server)
#
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco_test‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Next thing is to make the unit tests independent of any existing environment, meaning building the database before starting the actual test and destroying it again afterwards.

Thanks again,
Marcel