1
edit
Changes
→Phase 3: Test first design
* 1- [[PostgreSQL_Adapter-nexj/scripts | Create a PostgreSQL database through some scripts]]
* 32- Working inside Schema 'test' : <code> CREATE TABLE test.xxx </code>:: data types are changed in <code> appendColumnType() </code> in ''PostgreSQLSchemaManager.java'' based on each jdbc type's equivalent in PostgreSQL.:: The implementation in <code> crateTextTable </code> in file ''PostgreSQLSchemaManager.java'' is removed for now (base class's version is being called).: <code>CREATE INDEX test.xxx </code> : <code> CREATE Trigger test.xxx // if it's needed for PostgreSQL as well as MySQL</code> * Modifications{|class="collapsible collapsed" style="border-style:solid;border-width:thin;border-color:black"!align="left" style="background-color:SteelBlue; font-weight:bold;border-style:solid;border-width:thin;padding: 2px 2px 2px 2px;"| '''Changes Done to MySQL adapter''' |- |: When a connection is first established, this initial SQL statement should execute in MySQL, which is not the case for PostgreSQL, so it was commented out:::<source lang=java>/* MySQLAdapter.java */ public String getInitialSQL() { StringBuffer buf = new StringBuffer(); buf.append("set sql_mode = concat(@@sql_mode, ',ANSI_QUOTES')"); // allow using doublequote when quoting column names in "CREATE TABLE" statements buf.append(";set optimizer_search_depth = 0"); // let DB automatically decide on how long it takes to examine plans, improves long planning sessions buf.append(";set max_sort_length = ").append (Math.max(MAX_VARCHAR_PRECISION, MAX_VARBINARY_PRECISION)); // set TEXT/BLOB minimum sorting length to be same as cutoff between varchar/text return buf.toString(); }</source>: Also the same line should be commented out in postgresql_create.sql script, which is being used to create tables in the database 'test':::<source lang=java>/* nexj/core/persistence/sql/etc/postgresql_create.sql */set sql_mode = concat(@@sql_mode, ',ANSI_QUOTES');</source>: After activating the connection, the database is locked.: In MySQL, the storage engine is set to a transactional safe engine such as [http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL#MySQL:InnoDB InnoDB], whereas PostgreSQL has a single built in engine. So, changes needed to be done to this script:::<source lang=java>create table test.Account( id binary(16) not null, contactId binary(16) not null, account Type varchar(16) character set utf8 not null, funds double null, constraint Account_PK primary key(id) )engine=innoDB;</source> |}{|class="collapsible collapsed" style="border-style:solid;border-width:thin;border-color:black"!align="left" style="background-color:SteelBlue; font-weight:bold;border-style:solid;border-width:thin;padding: 2px 2px 2px 2px;"| '''Files to Configure''' |- |:src:: [[ PostgreSQL_Adapter-nexj/Adapter | PostgreSQLAdapter.java ]] // Extends SQLAdapter.java - SQL Persistence adapter, responsible for regular data queries (insert, select, delete):: [[ PostgreSQL_Adapter-nexj/SchemaManger | PostgreSQLSchemaManager.java ]] // Extends SQLSchemaManager.java - class for reading, creating and upgrading the database schema:: [[ PostgreSQL_Adapter-nexj/Upgrade | main.upgrade ]]: test:: [[ PostgreSQL_Adapter-nexj/AdapterTest | PostgreSQLAdapterTest.java ]]] // Extends SQLAdapterTest.java:: [[ PostgreSQL_Adapter-nexj/SchemaMangerTest | PostgreSQLSchemaManagerTest.java Working inside Schema 'test']] // Extends SQLSchemaManagerTest.java: Script - scripts are being processed through SQLDataTest.java:: postgresql_setup.sql:: TO be cond'|}
===Phase 4: Test properties specific to PostgreSQL ===
