Open main menu

CDOT Wiki β

PostgreSQL Adapter-nexj/SchemaManger

Revision as of 18:39, 14 December 2010 by Minooz (talk | contribs) (→‎Non-Abstract Methods)

Postgre Project - SQLSchemaManager Files

SQLSchemaManager.java

INITIAL SETUP OF SCHEMA

Abstract methods to work on
Modifier Method Tests Cases Status ToDo
protected abstract String getDefaultTablespace() --- not started ---
protected abstract String getDefaultIndexspace() --- not started ---
protected abstract String getDefaultLongspace() --- not started ---
protected abstract String getGUIDExpr() --- not started ---
protected abstract String getNowExpr() --- not started ---
public abstract void analyzeTable(Table table) runs when executing DatabaseSchemaTool.java (through deploying the model ?) not started ---
public abstract public abstract String getSeparator() --- not started ---
protected abstract void appendPrint(StringBuffer buf, String sMsg) --- not started ---
public abstract public abstract String getSeparator() --- not started ---
protected abstract String getCreateEtcScriptName() --- not started ---
protected abstract String getSetupEtcScriptName() --- not started ---
protected void appendIndexColumn(StringBuffer buf, IndexColumn indexColumn) not started ---
protected void appendTableSuffix(StringBuffer buf, Table table) --- not started ---
public String getDefaultRole() --- not started ---
protected String getFullTableName(String sSchemaName, String sTableName) --- not started ---
protected String getIndexName(Index index, boolean bConstraint, boolean bQuote) --- not started ---
public void setFragment(RelationalDatabaseFragment fragment) --- not started ---
protected abstract SQLAppender getDynamicSQLAppender(StringBuffer buf) --- not started ---

DROP SCHEMA

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

Abstract methods to work on
Modifier Method Tests Cases Status ToDo
protected abstract StringBuffer appendConcatenate(StringBuffer buf, CharSequence[] argArray) MySQLAdapterTest[testUpgrade(), testSchemaUnicodeValidation()] -MySQLSchemaManagerTest[testAppendConcatenate()] not started ---
protected abstract String getDefaultTablespace() --- not started ---
protected abstract String getDefaultIndexspace() --- not started ---
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. ---
protected abstract void appendPrint(StringBuffer buf, String sMsg) --- not started ---
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 appendColumnSuffix(StringBuffer buf, Column column) It's being used to add specific suffix- for postgre, SERIAL is added to the column name when an 'auto-increment' is needed need opt. ---
protected void appendIndexColumn(StringBuffer buf, IndexColumn indexColumn) 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

Abstract methods to work on
Modifier Method Tests Cases Status ToDo
protected abstract StringBuffer appendConcatenate(StringBuffer buf, CharSequence[] argArray) MySQLAdapterTest[testUpgrade(), testSchemaUnicodeValidation()] -MySQLSchemaManagerTest[testAppendConcatenate()] not started ---
protected abstract String getDefaultIndexspace() --- not started ---
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 DatabaseSchemaTool.java (through deploying the model ?) not started ---
protected abstract void appendUpgradeStepStart(StringBuffer buf, RelationalSchema schema, SchemaVersion version) --- not started ---
protected abstract void appendUpgradeStepEnd(StringBuffer buf, RelationalSchema schema, SchemaVersion version, SchemaVersion prev, String sFailMsg) --- not started ---
protected abstract void appendPrint(StringBuffer buf, String sMsg) --- not started ---
public abstract public abstract String getSeparator() --- not started ---
protected abstract String getDropEtcScriptName() --- not started ---
protected abstract SQLAppender getDynamicSQLAppender(StringBuffer buf) --- not started ---


| protected || void appendUpgradeInitialize(StringBuffer buf, RelationalSchema schema) || May not be needed for Postgre || comp. || --- |- | public || void dropTable(Table table) ||--- || not started || --- |- | protected || String getAlterColumnToken() ||--- || not started || --- |- | protected || Table getDropSuccessor(Table left, Table right) ||--- || not started || --- |- | protected || String getIndexName(Index index, boolean bConstraint, boolean bQuote) ||--- || not started || --- |- | protected || void renameColumn(Column newColumn, Column oldColumn) ||--- || not started || --- |- | protected || void renameTable(Table newTable, Table oldTable) ||--- || not started || --- |- | public || void setFragment(RelationalDatabaseFragment fragment) ||--- || not started || --- |- | public || void truncateTable(Table table) ||--- || not started || --- |- |}

MySQLSchemaManager.java

Methods specific to MySQL
Modifier Method Tests Cases Status ToDo
protected StringBuffer appendTSField(StringBuffer buf, byte nField) --- not started ---
protected void createTextTable(Table table) --- not started ---
protected void createTextTriggers(Table table, Index includeIndex, Index excludeIndex) --- not started ---
protected void dropTextTriggers(Table table) --- not started ---
protected void dropIndex(Index index) --- not started ---
protected static boolean hasTextTable(Table table) --- not started ---

PostgreSQLSchemaManager.java

Methods specific to PostgreSQL
Modifier Method Tests Cases Status ToDo
--- ---- --- --- ---
Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=PostgreSQL_Adapter-nexj/SchemaManger&oldid=52672"