Difference between revisions of "User:Minooz/PostgreSQL Adapter-nexj"

From CDOT Wiki
Jump to: navigation, search
(Created page with '<big><big> PostgreSQL Adapter for NexJ </big></big> {{MinNexJ_Express Index}} == Project Goal== Develope an adapter to enable NexJ Express model to interact with PostgreSQL data…')
 
(Project Phases)
 
(5 intermediate revisions by the same user not shown)
Line 39: Line 39:
  
 
=== Phase 2: Connect to PostgreSQL===
 
=== Phase 2: Connect to PostgreSQL===
* [[PostgreSQL_Adapter-nexj/test-env | Create Test Environment]]
+
* [[User:Minooz/PostgreSQL_Adapter-nexj/test-env | Create Test Environment]]
  
 
=== Phase 3: Test first design ===
 
=== Phase 3: Test first design ===
* 1- [[PostgreSQL_Adapter-nexj/scripts | Create a PostgreSQL database through some scripts]]
+
Running [[User:Minooz/PostgreSQL_Adapter-nexj/alltests | AllTests.java]]
 
+
* 1- [[User:Minooz/PostgreSQL_Adapter-nexj/scripts | Create a PostgreSQL database through some scripts]]
* 2- [[PostgreSQL_Adapter-nexj/schema-test |  Working inside Schema 'test']]
+
* 2- [[User:Minooz/PostgreSQL_Adapter-nexj/schema-test |  Working inside Schema 'test']]
 +
: 2.a- [[ User:Minooz/PostgreSQL_Adapter-nexj/schema-init | Initilizaing the SQL Environment]]
 +
: 2.b- [[ User:Minooz/PostgreSQL_Adapter-nexj/schema-ddl  | Working with Database Structure - DDL ]]
 +
: 2.c- [[ User:Minooz/PostgreSQL_Adapter-nexj/schema-dml | Working with Data in a Table - DML ]]
  
 
===Phase 4: Test properties specific to PostgreSQL ===
 
===Phase 4: Test properties specific to PostgreSQL ===
Line 58: Line 61:
 
:Concept of Adapter [http://www.vogella.de/articles/DesignPatternAdapter/article.html]
 
:Concept of Adapter [http://www.vogella.de/articles/DesignPatternAdapter/article.html]
 
:FOSSLC [http://www.fosslc.org/drupal/category/community/databases/postgresql PostgreSQL]
 
:FOSSLC [http://www.fosslc.org/drupal/category/community/databases/postgresql PostgreSQL]
* [[PostgreSQL_Adapter-nexj/Resources#Java | Java ]]
+
* [[User:Minooz/PostgreSQL_Adapter-nexj/Resources#Java | Java ]]
* [[PostgreSQL_Adapter-nexj/Resources#Database_.26_Persistence | Database & Persistence]]
+
* [[User:Minooz/PostgreSQL_Adapter-nexj/Resources#Database_.26_Persistence | Database & Persistence]]
* [[PostgreSQL_Adapter-nexj/Resources#JDBC | JDBC]]
+
* [[User:Minooz/PostgreSQL_Adapter-nexj/Resources#JDBC | JDBC]]
* [[PostgreSQL_Adapter-nexj/Resources#PostgreSQL Specifications | PostgreSQL Specifications]]
+
* [[User:Minooz/PostgreSQL_Adapter-nexj/Resources#PostgreSQL Specifications | PostgreSQL Specifications]]
* [[PostgreSQL_Adapter-nexj/Resources#MySQL_Specifications | MySQL Specifications]]
+
* [[User:Minooz/PostgreSQL_Adapter-nexj/Resources#MySQL_Specifications | MySQL Specifications]]
* [[PostgreSQL_Adapter-nexj/Resources#PostgreSQL_-_MySQL_Compare | Postgre - MySQL Compare]]
+
* [[User:Minooz/PostgreSQL_Adapter-nexj/Resources#PostgreSQL_-_MySQL_Compare | Postgre - MySQL Compare]]

Latest revision as of 14:44, 15 December 2010

PostgreSQL Adapter for NexJ

Min NexJ Express | JSON_Adapter | Continuous Integration for NexJ Express Code | REST Server | PostgreSQL Adapter

Project Goal

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

Current Status

Project Phases

Phase 1: Investigation

  • Get requirements from NexJ (Meeting on Friday Nov 5th)
  • Walk-through the code
  • Familiarization with PostgreSQL

Phase 2: Connect to PostgreSQL

Phase 3: Test first design

Running AllTests.java

2.a- Initilizaing the SQL Environment
2.b- Working with Database Structure - DDL
2.c- Working with Data in a Table - DML

Phase 4: Test properties specific to PostgreSQL

  • Add test cases that are specific to PostgreSQL database

Phase 5: Optimization

  • After implementation is done, optimizing the modified files.

Resources

  • Intro
Concept of Adapter [1]
FOSSLC PostgreSQL