1,234
edits
Changes
no edit summary
{{Admon/obsolete}}
<big><big> PostgreSQL Adapter for NexJ </big></big>
{{NexJ_Express Index}}
[[category: NexJ Past Projects]]
[[category: NexJ Express PostgreSQL]]
== Project Goal==
== Current Status==
* '''Completed''' (October 21, 2011)* Get the last PostgreSQL adapter source code from http://mercurial.nexj.com/express.cgi/core <!--{|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;"| Dec 2010
|-
* Application is now connected to the Postgre database.
|}
-->
==Project Phases==
=== Phase 1: Investigation (DONE) ===
* Get requirements from NexJ (Meeting on Friday Nov 5th)
* Walk-through the code
* Familiarization with PostgreSQL
=== Phase 2: Connect to PostgreSQLserver (DONE) ===* [[PostgreSQL_Adapter-nexj/test-env NexJ_Express_Connecting_to_PostgreSQL| Create Test EnvironmentConnect to PostgreSQL server]]
=== Phase 3: Test first design PostgreSQLSchemaManager (DONE) ===* 1Estimated Duration: 3 weeks (Jan 17 - Create a PostgreSQL database through some scripts: Through the process in postgresql_setup.sqlFeb 11, the database was created, initialized and tested:2011):: A database called 'test is created in * [[PostgreSQL : <code> CREATE DATABASE test </code>:: To create a <code>user</code> along with <code>password</code>: <code> CREATE USER test WITH PASSWORD 'test'; </code>:: Login to the database 'test' with username 'test': <code> psql Adapter-U test test </code>:: Create a <code> Schema </code> called 'test' inside the database 'test' with particular owner 'test': <code> CREATE SCHEMA test AUTHORIZATION test;</code>:: Create a <code>table</code> called 'Mutex' with primary key: <code> CREATE TABLE test.Mutex(id INT PRIMARY KEY); </code>:: Insert a value into the primary key: <code> INSERT INTO test.Mutex(id) VALUES (1); <nexj/code>extendingSchemaManager | Extending SQLSchemaManager ]]
=== Phase 4: PostgreSQLAdapter (DONE)===* Estimated Duration: 3weeks (Feb 14 - Working inside Schema '25, 2011)* [[PostgreSQL_Adapter-nexj/extendingSQLAdapter | Extending SQLAdapter ]] ===Phase 5: PostgreSQL UnitTests and Optimization (DONE) ===* Estimated Duration: 2 weeks (Feb 28 - Mar 11, 2016)* Add database specific tests fostr PostgreSQL*:test for required contrib scripts*:test'for custom blob read & write functions* Add PostgreSQL specific optimization ===Phase 6: Megre Code with Latest Revision (DONE) ===* Merge code with lastest revision from http://mercurial.nexj.com/express ===Phase 7: Test with NexJ Express Studio (DONE) ===* Estimated duration: Mar 7- Apr 14, 2011* Run model in Express studio using the postgresql adapter* create scripts for database initialization, creation and dumping* create scripts for JBoss* Deploy to JBoss === Phase 8: Code Review 1 - Meeting (DONE) ===* Date: Apr 20,2011 * Meet with NexJ Developer to review code === Phase 9: Code Review 1 - Apply Changes (DONE) ===* Estimated Duration: Apr 20, 2011 - July 1, 2011* [[PostgreSQL_Adapter_Project_-_Code_Review_1_Changes | Changes to be made]] === Phase 10: Code Review 2 (DONE) ===* Send code for review* === Phase 11: Code Review 2 - Apply Changes (DONE) ===* Estimated Duration: July 7, 2011 - July 15, 2011* [[PostgreSQL_Adapter_Project_-_Code_Review_2_Changes | Changes to be made]] === Phase 12: Code Review 3 (DONE) ===* Sent code for code review 3* https://bitbucket.org/gbatumbya/postgresql_external/src/08cdedb9d071/ === Phase 13: Code Review 3 - Apply Changes (DONE) ===* Upgrade to lastest 7.1 branch* Create Statement and PreparedStatementProxy* Create PostgreSQLPreparedStatementProxy:** implement set/getQueryTimeout** move custom timeout code into this proxy* Override prepareStatement in PostgreSQL to return PostgreSQLPreparedStatementProxy* Implement implicit save points for statements within a transaction block* Modify readSchema to use addColumn for reading columns from the database** Remove MSSQL and Oracle specific code from addColumn** Override addColumn in PostgreSQL for text, bytea and lo types === Phase 14: Integration Tests (DONE) ===* Run Integration tests against the Adapter === Phase 15: Code Review 4 (DONE)===* Code review with framework architect* https://bitbucket.org/gbatumbya/postgresql_external/src/6c9a7380c8fe === Phase 16: Code Review 4 - Apply Changes (DONE) ===* Estimated Duration: Sep 9 - Sep 12* [[PostgreSQL_Adapter_Project_-_Code_Review_4_Changes | Changes to be made]] === Phase 17: Code Review 5 (DONE) ===* Submitted code for review on Sep 20.* https://bitbucket.org/gbatumbya/postgresql_external/src/a0d10ef7cdbe/ === Phase 18: Code Review 5 - Apply Changes (DONE) === === Phase 19: Code Review 6 ===* Date: Oct 13* Submitted for code review* https://bitbucket.org/gbatumbya/postgresql_external/src/153aec847d54/
== Resources ==
* Downloads
Linux binaries http://www.openscg.org/se/postgresql/packages.jsp
* Debugging
:[[Run_Junit_Tests_For_Non_Default_SQL_Adapter | Unit Testing for non Default SQL Adapter]]
:
* Intro
:Concept of Adapter [http://www.vogella.de/articles/DesignPatternAdapter/article.html]
* [[PostgreSQL_Adapter-nexj/Resources#MySQL_Specifications | MySQL Specifications]]
* [[PostgreSQL_Adapter-nexj/Resources#PostgreSQL_-_MySQL_Compare | Postgre - MySQL Compare]]
== Summary of Applied Research ==
* [[Research Findings - PostgreSQLAdapter]]
* [[Research Notes - PostgreSQLAdapter]]