PostgreSQL Adapter
PostgreSQL Adapter for NexJ
Contents
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
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
- List of Tasks
- implementation of PostgreSQLAdapter.java
- implementation of PostgreSQLAdapterTest.java
- implementation of PostgreSQLSchemaManager.java
- Setup Scripts
- implementation of main.upgrade
Resources
Concept of Adapter [1] FOSSLC PostgreSQL
