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
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
|
| --- |
---- |
--- |
--- |
---
|
