1,234
edits
Changes
no edit summary
{{Admon/obsolete}}
<big><big> Postgre Project - SQLSchemaManager Files</big></big>
==SQLSchemaManager.java==
=== INITIAL SETUP OF SCHEMA ===
{| class="wikitable sortable" border="1" cellpadding="5"
|+'''Abstract methods to work on'''
! Modifier !! Method !! Tests Cases !! Status !! ToDo
|-
|}
=== DROP CREATE SCHEMA ===
{| class="wikitable sortable" border="1" cellpadding="5"
|+'''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 getDropEtcScriptNamegetDefaultTablespace() ||--- || 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 getSetupEtcScriptNameSQLAppender getDynamicSQLAppender(StringBuffer buf) ||--- || not started || ---
|-
| protected || void appendTableSuffixappendColumnSuffix(StringBuffer buf, Table tableColumn column) ||It's being used to add specific suffix-for postgre, SERIAL is added to the column name when an 'auto-- increment' is needed || not started need opt. || ---
|-
| protected || void appendUpgradeInitializeappendIndexColumn(StringBuffer buf, RelationalSchema schemaIndexColumn indexColumn) || May not be needed for Postgre || comp. not started || ---
|-
| public protected || void dropTableappendTableSuffix(StringBuffer buf, Table table) ||--- || not started || ---
|-
| protected || Table getDropSuccessorvoid createIndex(Table left, Table rightIndex index) ||--- || not started || ---
|-
| public protected || void truncateTablecreateIndexes(Table table) ||--- || not started || ---
|-
|}
=== CREATE UPGRADE SCHEMA ===
{| class="wikitable sortable" border="1" cellpadding="5"
|+'''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 appendColumnTypeappendUpgradeStepStart(StringBuffer buf, Column columnRelationalSchema schema, SchemaVersion version) ||--- || not started || ---|-| protected abstract ||void appendUpgradeStepEnd(StringBuffer buf, RelationalSchema schema, SchemaVersion version, SchemaVersion prev, String sFailMsg) || it changes the syntax of creating table depends on the differences in data types --- || Need Opt. not started || ---
|-
| protected abstract || void appendPrint(StringBuffer buf, String sMsg) ||--- || not started || ---
|-
| protected public abstract || public abstract String getCreateEtcScriptNamegetSeparator() ||--- || not started || ---
|-
| protected abstract || String getDropEtcScriptName() ||--- || not started || ---
|-
| protected abstract || SQLAppender getDynamicSQLAppender(StringBuffer buf) ||--- || not started || ---
|-
| protected || void appendColumnSuffixappendUpgradeInitialize(StringBuffer buf, Column columnRelationalSchema schema) || It's being used to add specific suffix- May not be needed for postgre, SERIAL is added to the column name when an 'auto-increment' is needed Postgre || need optcomp. || ---
|-
| protected public || void appendIndexColumndropTable(StringBuffer buf, IndexColumn indexColumnTable table) || --- || not started || ---
|-
| protected || void appendTableSuffixString getAlterColumnToken(StringBuffer buf, Table table) ||--- || not started || ---
|-
| protected || void appendUpgradeInitializeTable getDropSuccessor(StringBuffer bufTable left, RelationalSchema schemaTable right) || May not be needed for Postgre --- || comp. not started || ---
|-
| protected || void createIndexString getIndexName(Index index, boolean bConstraint, boolean bQuote) ||--- || not started || ---
|-
| protected || void createIndexesrenameColumn(Table tableColumn newColumn, Column oldColumn) ||--- || not started || ---
|-
| public protected || void dropTablerenameTable(Table tablenewTable, Table oldTable) ||--- || not started || ---
|-
| protected public || String getAlterColumnTokenvoid setFragment(RelationalDatabaseFragment fragment) ||--- || not started || ---
|-
| protected public || String getFullTableNamevoid truncateTable(String sSchemaName, String sTableName) ||--- || not started || ---|-| protected || String getIndexName(Index index, boolean bConstraint, boolean bQuoteTable table) ||--- || not started || ---
|-
|}
==MySQLSchemaManager.java==
|-
|}
==PostgreSQLSchemaManager.java==