1
edit
Changes
→Configurations
=== Configurations ===
The following will configure the unit tests to run for [DbName]SQLAdapter and [DbName]SQLSchemaManager
==== Environment/Connection Files ====
These files are located in the ''test'' source folder in the package <code>nexj</code>
#Edit the files: '''default.config, filestorage.connections, filestoragefragment.connections'''##In the <code>DataSourceConnections</code> elemement##Change all occurrences of <code>adapter="MySQL"</code> to <code>adapter="DbName"</code>##Change all occurrences of <code>port="3306"</code> to the port on which the new DbName is configured to accept connections:::##:For the PostgreSQL Adapter, the following configuration is used
<source lang="xml">
<DataSourceConnections>
</DataSourceConnections>
</source>
#Create a connections file for the new adapter
##Create the file '''[DbName].connections''' in the <code>nexj</code> package in the ''test'' source folder##Copy and paste the contents of '''mysql.connections''' into the new connections file##In the <code>DataSourceConnections</code> elemement##Change all occurrences of <code>adapter="MySQL"</code> to <code>adapter="DbName"</code>##Change all occurrences of <code>port="3306"</code> to the port on which the new DbName is configured to accept connections:::##:For the PostgreSQL Adapter, the following configuration is used
<source lang="xml">
<DataSourceConnections>
==== SQL Scripts ====
These scripts are used to:
* Initialize the database with test data before a unittest is run
* Drop test tables that the unit tests create
# Create the files in the package <code>nexj.core.persistence.sql.script</code> under the ''test'' source folder
## '''dbname_drop.sql'''
##* Copy and paste the contents of <code>mysql_drop.sql</code> into the new file
## '''dbname_insert.sql'''
##* Copy and paste the contents of <code>mysql_insert.sql</code> into the new file
##* Modify the sql script to conform to the sql syntax for the new database
##: For exampe, for the PostgreSQL Adapter (9.0), modify the values for binary literals into postgresql's binary literal by changing
##: <code>0x00000000000000000000000000000001</code> to <code>E'\\x00000000000000000000000000000001'</code>
## '''dbname_setup.sql'''
##:This script is used to:
###Create the <code>test</code> user with the following permissions:
####Full privileges for the test database
####Remote login
###Create the <code>test</code> database with the follow specifications:
####Name: test
####Encoding: utf-8 / unicode
####(*Optional) Schema Name: test
==== Unit Test Files ====
