Difference between revisions of "Nexjexpress/PostgreSQL Adapter"

From CDOT Wiki
Jump to: navigation, search
(Current Status)
 
(45 intermediate revisions by one other user not shown)
Line 1: Line 1:
 +
{{Admon/obsolete}}
 +
 +
<big><big> PostgreSQL Adapter for NexJ </big></big>
 +
 +
 
== Project Goal==
 
== Project Goal==
Develope an adapter to expose NexJ Express objects to PostgreSQL database
+
Develope an adapter to enable NexJ Express model to interact with PostgreSQL database
  
 
== Current Status==
 
== Current Status==
: Learning about Differences between PostgreSQL and MySQL
+
* Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts in NexJ Express code
: Walk through MySQL adapter.java code in NexJ Express code
+
* Going through NexJ MySQL database
: Going through NexJ MySQL database
+
* Learning about Differences between PostgreSQL and MySQL
  
 
==Project Phases==
 
==Project Phases==
=== Phase 1: Design Proposal ===
+
=== Phase 1: Design Requirements ===
* Get requirements from NexJ (Meeting on Thursday Sep 23rd)
+
* Get requirements from NexJ (Meeting on Friday Nov 5th)
* Incorporate requirements from NexJ into Design of PostgreSQL adapter
+
* Organize list of requirements and set the task list for each part needed to be done
* Prepare and send proposal for review, make changes as by NexJ until approved
 
  
 
===Phase 2: Coding ===
 
===Phase 2: Coding ===
 +
* '''List of Tasks'''
 +
# implementation of [[ PostgreSQL_Adapter-nexj/Adapter | PostgreSQLAdapter.java ]]
 +
# implementation of [[ PostgreSQL_Adapter-nexj/AdapterTest | PostgreSQLAdapterTest.java ]]
 +
# implementation of [[ PostgreSQL_Adapter-nexj/SchemaManger | PostgreSQLSchemaManager.java ]]
 +
# Setup [[ PostgreSQL_Adapter-nexj/Script | Scripts ]]
 +
# implementation of  [[ PostgreSQL_Adapter-nexj/Upgrade | main.upgrade ]]
 +
 +
== Resources ==
 +
Concept of Adapter [http://www.vogella.de/articles/DesignPatternAdapter/article.html]
 +
* [[PostgreSQL_Adapter-nexj/Resources#Java | Java ]]
 +
* [[PostgreSQL_Adapter-nexj/Resources#Database_.26_Persistence | Database & Persistence]]
 +
* [[PostgreSQL_Adapter-nexj/Resources#JDBC | JDBC]]
 +
*  [[PostgreSQL_Adapter-nexj/Resources#PostgreSQL_-_MySQL_Specifications | Postgre - MySQL Specifications]]
 +
*  [[PostgreSQL_Adapter-nexj/Resources#PostgreSQL_-_MySQL_Compare | Postgre - MySQL Compare]]

Latest revision as of 19:52, 26 January 2014

Important.png
This page may be obsolete.
It contains historical information.

PostgreSQL Adapter for NexJ


Project Goal

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

Current Status

  • Walk through parts of code related to SQLadapter, SqlSchemaManger and setup scripts in NexJ Express code
  • Going through NexJ MySQL database
  • Learning about Differences between PostgreSQL and MySQL

Project Phases

Phase 1: Design Requirements

  • Get requirements from NexJ (Meeting on Friday Nov 5th)
  • Organize list of requirements and set the task list for each part needed to be done

Phase 2: Coding

  • List of Tasks
  1. implementation of PostgreSQLAdapter.java
  2. implementation of PostgreSQLAdapterTest.java
  3. implementation of PostgreSQLSchemaManager.java
  4. Setup Scripts
  5. implementation of main.upgrade

Resources

Concept of Adapter [1]