1,234
edits
Changes
no edit summary
{{Admon/obsolete}}
<big><big> Postgre Project - SQLSchemaManager Files</big></big>
==SQLSchemaManager.java==
==PostgreSQLSchemaManager.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 || StringBuffer appendConcatenateString 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 <code> DatabaseSchemaTool.java</code> (through deploying the model ?)|| not started || ---|-| public abstract ||public abstract String getSeparator() ||--- || not started || ---|-| protected abstract || void appendPrint(StringBuffer buf, CharSequence[] argArrayString sMsg) ||--- || not started || ---|-| public abstract || public abstract String getSeparator() ||--- || not started || ---|-| protected abstract || String getCreateEtcScriptName() || --- || not started || ---
|-
| protected abstract || StringBuffer appendTSExtractString getSetupEtcScriptName(StringBuffer buf, CharSequence sTS, byte nField) || --- || not started || ---
|-
| protected abstract || void appendIndexColumn(StringBuffer appendTSIncrementbuf, IndexColumn indexColumn) || || not started || ---|-| protected || void appendTableSuffix(StringBuffer buf, CharSequence sTSTable table) ||--- || not started || ---|-| public || String getDefaultRole() ||--- || not started || ---|-| protected || String getFullTableName(String sSchemaName, String sTableName) ||--- || not started || ---|-| protected || String getIndexName(Index index, CharSequence sDeltaboolean bConstraint, byte nFieldboolean bQuote) ||--- || not started || ---|-| public || void setFragment(RelationalDatabaseFragment fragment) ||--- || not started || ---|-| protected abstract || SQLAppender getDynamicSQLAppender(StringBuffer buf) ||--- || not started || ---|-|} === CREATE SCHEMA ==={| class="wikitable sortable" border="1" cellpadding="5"|+! 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 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 || not started Need Opt. || ---
|-
| public protected abstract ||void analyzeTableappendPrint(Table tableStringBuffer buf, String sMsg) ||--- || not started || ---
|-
| public protected abstract || String getGUIDExprgetCreateEtcScriptName() ||--- || 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 createIndex(Index index) ||--- || not started || ---
|-
| protected || void createIndexes(Table table) ||--- || not started || ---
|-
|}
=== UPGRADE SCHEMA ===
{| class="wikitable sortable" border="1" cellpadding="5"
|+
! 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 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==
{| class="wikitable sortable" border="1" cellpadding="5"
|+'''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==
{| class="wikitable sortable" border="1" cellpadding="5"
|+'''Methods specific to PostgreSQL'''
! Modifier !! Method !! Tests Cases !! Status !! ToDo
|-
| --- || ---- || --- || --- || ---
|-
|}
