1,234
edits
Changes
no edit summary
{{Admon/obsolete}}
<big><big> PostgreSQL Adapter for NexJ </big></big>
{{NexJ_Express Index}}
[[category: NexJ Current 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 PostgreSQL server (DONE) ===* [[NexJ_Express_Connecting_to_PostgreSQL| Connect to PostgreSQL server]]
=== Phase 23: Connect to PostgreSQL server PostgreSQLSchemaManager (DONE) ===Install the driver and get NexJ Express Server to communicate to the server* Estimated Duration: 3 weeks (Jan 17 - Feb 11, 2011)* [[PostgreSQL_AdapterPostgreSQL Adapter-nexj/test-env extendingSchemaManager | Connect to PostgreSQL serverExtending SQLSchemaManager ]]
=== Phase 34: PostgreSQLSchemaManager PostgreSQLAdapter (DONE)====== Phase 4* Estimated Duration: PostgreSQLAdapter ===3 weeks (Feb 14 - 25, 2011)* [[PostgreSQL_Adapter-nexj/extendingSQLAdapter | Extending SQLAdapter ]]
===Phase 18: Code Review 5: Test properties specific to PostgreSQL - Apply Changes (DONE) ===
=== Phase 19: Code Review 6 ===* Add test cases that are specific to PostgreSQL databaseDate: Oct 13* Submitted for code review* https://bitbucket.org/gbatumbya/postgresql_external/src/153aec847d54/
== Project Repository ==
* URL for central repository of the project is: httphttps://liberiabitbucket.proximity.on.ca:81org/gbatumbya/nexjexpress-postgresqladapter
* Steps to work with the repository
:1- Follow the [https://www.projects.openhealthtools.org/sf/docman/do/downloadDocument/projects.oht_aip/docman.root.nexj_studio_express_v7_1_113_0/doc1783/1 instructions to create the NexJ Express workspace from the manual].:2- After creating 'ws' directory, ::open Eclipse and ::click on '''File -> Import -> Mercurial -> Clone Existing Mercurial Repository -> ''':: Enter these this information to clone from repository:::: '''URL''': sshhttps://liberia.proximity.onbitbucket.caorg/mercurialgbatumbya/postgreSQL/core nexjexpress-postgresqladapter:: '''Username''': developer:: '''Clone directory name''': core<!--
:3- The central repository's structure is:
:: Main branch called 'default'
:: New branch or branches with this naming convention: 'wsComitter' e.g. 'wsMinoo'Branches for
:4- After cloning the project, follow these steps to add a new branch with your user name:
:: First make sure the active branch is 'default'. Notice the top of the Package Explorer e.g. ''core[5:b8b2f102343@'''default'''(tip)]''
* '''NOTE!''' To avoid any conflict, do the 'Pull' every day and before any push.
* '''NOTE!''' First just 'Commit' changesets and do not 'Push' them until the end of the day or the time you are confident by latest changes to the code, then 'Push' them all at once and 'Merge' them with the 'default' branch in central repository.
-->
== 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]]