Difference between revisions of "Run Junit Tests For Non Default SQL Adapter"

From CDOT Wiki
Jump to: navigation, search
(→‎Debugging a Non-Default SQL Adapter)
Line 27: Line 27:
 
==== Environment/Connection Files ====
 
==== Environment/Connection Files ====
 
These files are located in the ''test'' source folder in the package <code>nexj</code>
 
These files are located in the ''test'' source folder in the package <code>nexj</code>
−
#Default.config
+
#Edit the files: '''default.config, filestorage.connections, filestoragefragment.connections'''
−
#*In the <code>DataSourceConnections</code> elemement
+
##In the <code>DataSourceConnections</code> elemement
−
#*Change all occurrences of <code>adapter="MySQL"</code> to <code>adapter="DbName"</code>
+
##Change all occurrences of <code>adapter="MySQL"</code> to <code>adapter="DbName"</code>
−
#*Edit all occurrences of <code>port="3306"</code> to the port on which the new DbName is configured to accept connections
+
##Change all occurrences of <code>port="3306"</code> to the port on which the new DbName is configured to accept connections<br>For the PostgreSQL Adapter, the following configuration is used<source lang="xml">
 +
<DataSourceConnections>
 +
  <RelationalDatabaseConnection adapter="PostgreSQL" dataSource="DefaultRelationalDatabase" database="test"
 +
      host="localhost" password="test" port="5432" unicode="true" user="test"/>
 +
  <RelationalDatabaseConnection adapter="PostgreSQL" dataSource="ExternalRelationalDatabase" database="test"
 +
      host="localhost" password="test" port="5432" unicode="true" user="test"/>
 +
  ...
 +
</DataSourceConnections>
 +
</source>
 +
#Create a connections file for the new adapter
 +
##Create the file '''[DbName].connections'''
 +
##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
 
<br>For the PostgreSQL Adapter, the following configuration is used
 
<br>For the PostgreSQL Adapter, the following configuration is used
 
<source lang="xml">
 
<source lang="xml">
Line 38: Line 52:
 
   <RelationalDatabaseConnection adapter="PostgreSQL" dataSource="ExternalRelationalDatabase" database="test"
 
   <RelationalDatabaseConnection adapter="PostgreSQL" dataSource="ExternalRelationalDatabase" database="test"
 
       host="localhost" password="test" port="5432" unicode="true" user="test"/>
 
       host="localhost" password="test" port="5432" unicode="true" user="test"/>
−
  ...
 
 
  </DataSourceConnections>
 
  </DataSourceConnections>
 
</source>
 
</source>
 
==== SQL Scripts ====
 
==== SQL Scripts ====
 
==== Unit Test Files ====
 
==== Unit Test Files ====

Revision as of 12:19, 26 February 2011

Debugging a Non-Default SQL Adapter

Summary

By default, NexJ Express Unit tests are configured to test the MySQL Adapter.
The instructions that follow outline instructions for configuring Unit tests to be run for other SQL Adapters.
For this manual, reference will be made to the PostgreSQL Adapter but it will work the same for other adapters

Prerequisites

The following files must exist for the new SQL Adapter:
src
nexj.core.persistence.sql.[DbName]SQLAdapter.java extending nexj.core.persistence.sql.SQLAdapter
nexj.core.persistence.sql.[DbName]SQLSchemaManager.java extending nexj.core.persistence.sql.SQLSchemaManager
test
nexj.core.persistence.sql.[DbName]SQLAdapterTest.java extending nexj.core.persistence.sql.SQLAdapterTest
nexj.core.persistence.sql.[DbName]SQLSchemaManagerTest.java extending nexj.core.persistence.sql.SQLSchemaManagerTest

The following files should be edited and entries for the new SQL Adapter added:
nexj.core.meta.persistence.sql.RelationalDatabase.java
nexj.core.meta.peristence.sql.RelationalDatabaseFragment.java
nexj.core.meta.sys.system.dstypes
nexj.core.persistence.sql.SQLSchemaManagerFactory.java
nexj.core.util.JDBCInfo.java

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 nexj

  1. Edit the files: default.config, filestorage.connections, filestoragefragment.connections
    1. In the DataSourceConnections elemement
    2. Change all occurrences of adapter="MySQL" to adapter="DbName"
    3. Change all occurrences of port="3306" to the port on which the new DbName is configured to accept connections
      For the PostgreSQL Adapter, the following configuration is used
      <DataSourceConnections>
  <RelationalDatabaseConnection adapter="PostgreSQL" dataSource="DefaultRelationalDatabase" database="test"
      host="localhost" password="test" port="5432" unicode="true" user="test"/>
  <RelationalDatabaseConnection adapter="PostgreSQL" dataSource="ExternalRelationalDatabase" database="test"
      host="localhost" password="test" port="5432" unicode="true" user="test"/>
  ...
 </DataSourceConnections>
  2. Create a connections file for the new adapter
    1. Create the file [DbName].connections
    2. Copy and paste the contents of mysql.connections into the new connections file
    3. In the DataSourceConnections elemement
    4. Change all occurrences of adapter="MySQL" to adapter="DbName"
    5. Change all occurrences of port="3306" to the port on which the new DbName is configured to accept connections


For the PostgreSQL Adapter, the following configuration is used 

<DataSourceConnections>
  <RelationalDatabaseConnection adapter="PostgreSQL" dataSource="DefaultRelationalDatabase" database="test"
      host="localhost" password="test" port="5432" unicode="true" user="test"/>
  <RelationalDatabaseConnection adapter="PostgreSQL" dataSource="ExternalRelationalDatabase" database="test"
      host="localhost" password="test" port="5432" unicode="true" user="test"/>
 </DataSourceConnections>

SQL Scripts

Unit Test Files

Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=Run_Junit_Tests_For_Non_Default_SQL_Adapter&oldid=58856"