Difference between revisions of "PostgreSQL Adapter"

From CDOT Wiki
Jump to: navigation, search
(Phase 1: Design Requirements)
(Phase 1: Design Requirements)
Line 15: Line 15:
 
* Organize list of requirements and set the task list for each part needed to be done
 
* Organize list of requirements and set the task list for each part needed to be done
 
* [[PostgreSQL_Adapter-nexj/test-env | Create Test Environment]]
 
* [[PostgreSQL_Adapter-nexj/test-env | Create Test Environment]]
Create the JUnit test environment for PostgreSQL
 
: 1- Setup the postgresql-connection
 
:: Configure the work/ws/core/bin/nexj/default.config
 
:: Configure the work/ws/core/test/nexj/default.config
 
 
:: Configure the work/ws/core/bin/nexj/postgresql.connection
 
:: Configure the work/ws/core/test/nexj/postgresql.connection
 
: 2- Add PostgreSQL database to related java files
 
:: SQLSchemaMangerFactory.java
 
: 3- Create the extended PostgreSQL source files
 
:: PostgreSQLAdapter.java
 
:: PostgreSQLSchemaManger.java
 
: 4- Create the extended PostgreSQL test files
 
 
:: PostgreSQLAdapterTest.java
 
:: PostgreSQLSchemaMangerTest.java
 
  
 
===Phase 2: Coding ===
 
===Phase 2: Coding ===

Revision as of 12:01, 22 November 2010

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
  • Create Test Environment

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] FOSSLC PostgreSQL