|
|
| Line 44: |
Line 44: |
| | * 1- [[PostgreSQL_Adapter-nexj/scripts | Create a PostgreSQL database through some scripts]] | | * 1- [[PostgreSQL_Adapter-nexj/scripts | Create a PostgreSQL database through some scripts]] |
| | | | |
| − | * 3- Working inside Schema 'test' | + | * 2- [[PostgreSQL_Adapter-nexj/schema-test | 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 ]] // Extends SQLSchemaManagerTest.java
| |
| − | : Script - scripts are being processed through SQLDataTest.java
| |
| − | :: postgresql_setup.sql
| |
| − | :: TO be cond'
| |
| − | |}
| |
| | | | |
| | ===Phase 4: Test properties specific to PostgreSQL === | | ===Phase 4: Test properties specific to PostgreSQL === |
