Open main menu

CDOT Wiki β

Changes

PostgreSQL Adapter-nexj/schema-ddl

457 bytes removed, 20:55, 26 January 2014
no edit summary
{{Admon/obsolete}}
 
<big><big> PostgreSQL Adapter for NexJ - Working Inside Schema 'test' </big></big>
{{NexJ_Express Index}}
== Working with Database Structure - DDL ==
=== CREATING SCHEMA ===
- List of files need to be modified
:src- [[ PostgreSQL_Adapter-nexj/SchemaManger | PostgreSQLSchemaManager.java ]] --- ([[SchemaBackup]]) // Extends SQLSchemaManager.java - class for reading, creating and upgrading the database schema
: test- [[ PostgreSQL_Adapter-nexj/SchemaMangerTest | PostgreSQLSchemaManagerTest.java]] // Extends SQLSchemaManagerTest.java
: Script - scripts are being processed through SQLDataTest.java
=== CREATING SCHEMA ===
* <u><code> CREATE TABLE </code></u>
: 1- DATA TYPE: data types are changed in '''''<code> appendColumnType() </code>''''' based on each jdbc type's equivalent in PostgreSQL.
===UPDGRADING SCHEMA===
* List of Files needed to be modified
:src - [[ PostgreSQL_Adapter-nexj/SchemaManger | PostgreSQLSchemaManager.java ]] --- ([[SchemaBackup]]) // Extends SQLSchemaManager.java - class for reading, creating and upgrading the database schema
: [[ PostgreSQL_Adapter-nexj/Upgrade | main.upgrade ]]
: test- [[ PostgreSQL_Adapter-nexj/SchemaMangerTest | PostgreSQLSchemaManagerTest.java]] // Extends SQLSchemaManagerTest.java
: Script - postgresql_drop.sql
 
* <u><code> DROP TABLE </code></u>