Difference between revisions of "PostgreSQL Adapter-nexj/test-env/todo"
Line 10: | Line 10: | ||
:6 - <s>Copied the entire methode <code>readSchema)</code> from SQLSchemaManagaer to PostgreSQLSchemaManager, to change schema properties from binary to bytea. Check later for optimization. I needed to import more packages</s>. -- NO NEED FOR THIS | :6 - <s>Copied the entire methode <code>readSchema)</code> from SQLSchemaManagaer to PostgreSQLSchemaManager, to change schema properties from binary to bytea. Check later for optimization. I needed to import more packages</s>. -- NO NEED FOR THIS | ||
:7- <s>data mapping needs to be done for BINARY primary keys for all the tables</s> | :7- <s>data mapping needs to be done for BINARY primary keys for all the tables</s> | ||
+ | :8- Find out how to work around creating triggers and indexes in Postgre without using "." in the syntax (e.g. create index test.Account$2) | ||
+ | :9- Move all the implementation for abstract methods to new extended PostgreSQLSchemaManager.java |
Revision as of 19:30, 9 December 2010
PostgreSQL Adapter for NexJ - ToDO for Create Test Environment
- 1- Create and Configure the work/ws/core/test/nexj/postgresql.config
- for now, the contents of default.config is changed to postgresql specifications instead of mysql
2- walk-through lines from 214-218 in SQLManagementConnectionFactory.java3-Walk-through properties and see what exactly is needed to be authorized to connect to 'test' database>4- Make sure the model connects to the PostgreSQL using user 'test' - Break @ SQLManagerFactory.java Line:1225- Figure out why there is the exception (unable to lock the PostgreSQL store for the adapter - Break @ SQLDataTest.java Line:443- 6 -
Copied the entire methode. -- NO NEED FOR THISreadSchema)
from SQLSchemaManagaer to PostgreSQLSchemaManager, to change schema properties from binary to bytea. Check later for optimization. I needed to import more packages - 7-
data mapping needs to be done for BINARY primary keys for all the tables - 8- Find out how to work around creating triggers and indexes in Postgre without using "." in the syntax (e.g. create index test.Account$2)
- 9- Move all the implementation for abstract methods to new extended PostgreSQLSchemaManager.java