Open main menu

CDOT Wiki β

Changes

PostgreSQL Adapter-nexj/SchemaManger

1,989 bytes removed, 20:48, 26 January 2014
no edit summary
{{Admon/obsolete}}
 
<big><big> Postgre Project - SQLSchemaManager Files</big></big>
{{NexJ_Express Index}}
==SQLSchemaManager.java==
=== INITIAL SETUP OF SCHEMA ===
{| class="wikitable sortable" border="1" cellpadding="5"
|+'''Abstract methods to work on'''
! Modifier !! Method !! Tests Cases !! Status !! ToDo
|-
|-
| protected abstract || SQLAppender getDynamicSQLAppender(StringBuffer buf) ||--- || not started || ---
|-
|}
 
=== DROP SCHEMA ===
{| class="wikitable sortable" border="1" cellpadding="5"
|+'''Abstract methods to work on'''
! Modifier !! Method !! Tests Cases !! Status !! ToDo
|-
| protected abstract || String getDropEtcScriptName() ||--- || not started || ---
|-
| protected abstract || String getSetupEtcScriptName() ||--- || not started || ---
|-
| protected || void appendTableSuffix(StringBuffer buf, Table table) ||--- || not started || ---
|-
| protected || void appendUpgradeInitialize(StringBuffer buf, RelationalSchema schema) || May not be needed for Postgre || comp. || ---
|-
| public || void dropTable(Table table) ||--- || not started || ---
|-
| protected || Table getDropSuccessor(Table left, Table right) ||--- || not started || ---
|-
| public || void truncateTable(Table table) ||--- || not started || ---
|-
|}
=== CREATE SCHEMA ===
{| class="wikitable sortable" border="1" cellpadding="5"
|+'''Abstract methods to work on'''
! Modifier !! Method !! Tests Cases !! Status !! ToDo
|-
|-
| protected abstract || String getCreateEtcScriptName() ||--- || not started || ---
|-
| protected abstract || String getDropEtcScriptName() ||--- || not started || ---
|-
| protected abstract || String getSetupEtcScriptName() ||--- || not started || ---
|-
| protected abstract || SQLAppender getDynamicSQLAppender(StringBuffer buf) ||--- || not started || ---
|-
| protected || void appendTableSuffix(StringBuffer buf, Table table) ||--- || not started || ---
|-
| protected || void appendUpgradeInitialize(StringBuffer buf, RelationalSchema schema) || May not be needed for Postgre || comp. || ---
|-
| protected || void createIndex(Index index) ||--- || not started || ---
|-
| protected || void createIndexes(Table table) ||--- || not started || ---
|-
| public || void dropTable(Table table) ||--- || not started || ---
|-
| protected || String getAlterColumnToken() ||--- || not started || ---
|-
| protected || String getFullTableName(String sSchemaName, String sTableName) ||--- || not started || ---
|-
| protected || String getIndexName(Index index, boolean bConstraint, boolean bQuote) ||--- || not started || ---
|-
|}
 
=== UPGRADE SCHEMA ===
{| class="wikitable sortable" border="1" cellpadding="5"
|+'''Abstract methods to work on'''
! Modifier !! Method !! Tests Cases !! Status !! ToDo
|-
|-
| protected abstract || String getDefaultLongspace() ||--- || not started || ---
|-
| protected abstract || void appendColumnType(StringBuffer buf, Column column) || it changes the syntax of creating table depends on the differences in data types || Need Opt. || ---
|-
| public abstract ||void analyzeTable(Table table) ||runs when executing <code> DatabaseSchemaTool.java</code> (through deploying the model ?)|| not started || ---
|-
| protected abstract || void appendUpgradeStepStart(StringBuffer buf, RelationalSchema schema, SchemaVersion version) ||--- || not started || ---
| protected abstract || SQLAppender getDynamicSQLAppender(StringBuffer buf) ||--- || not started || ---
|-
|}
 
 
| protected || void appendUpgradeInitialize(StringBuffer buf, RelationalSchema schema) || May not be needed for Postgre || comp. || ---
|-
|-
|}
 
==MySQLSchemaManager.java==
|-
|}
 
==PostgreSQLSchemaManager.java==
Retrieved from "https://wiki.cdot.senecapolytechnic.ca/wiki/Special:MobileDiff/52672...104101"