Difference between revisions of "PostgreSQL Adapter"

From CDOT Wiki
Jump to: navigation, search
(→‎Current Status)
(→‎Project Repository)
Line 105: Line 105:
 
:: Enter this information:
 
:: Enter this information:
 
::: '''URL''': https://bitbucket.org/gbatumbya/postgresql_external
 
::: '''URL''': https://bitbucket.org/gbatumbya/postgresql_external
−
::: OR
+
<!--
−
::: '''URL''': http://liberia.proximity.on.ca:81/PostgreSQL%20Adapter
 
 
:3- The central repository's structure is:
 
:3- The central repository's structure is:
 
:: Main branch called 'default'  
 
:: 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:
 
: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)]''
 
:: First make sure the active branch is 'default'. Notice the top of the Package Explorer e.g. ''core[5:b8b2f102343@'''default'''(tip)]''
Line 122: Line 121:
 
* '''NOTE!''' To avoid any conflict, do the 'Pull' every day and before any push.
 
* '''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.
 
* '''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 ==
 
== Resources ==

Revision as of 07:48, 7 July 2011

PostgreSQL Adapter for NexJ

Project Goal

Develop an adapter to enable NexJ Express model to interact with PostgreSQL database

Contributors


Supported Versions

  • 8.4
  • 9.0

Current Status

  • Phase 11


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)

Phase 3: PostgreSQLSchemaManager (DONE)

Phase 4: PostgreSQLAdapter (DONE)

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)

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)

Phase 10: Code Review 2 (DONE)

  • Send code for review

Phase 11: Code Review 2 - Apply Changes

Project Repository

  • Steps to work with the repository
1- Follow the 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 this information:
URL: https://bitbucket.org/gbatumbya/postgresql_external

Resources

  • Downloads

Linux binaries http://www.openscg.org/se/postgresql/packages.jsp

  • Debugging
Unit Testing for non Default SQL Adapter
  • Intro
Concept of Adapter [1]
FOSSLC PostgreSQL

Summary of Applied Research

Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=PostgreSQL_Adapter&oldid=66887"