Difference between revisions of "PostgreSQL Adapter-nexj/SchemaManger"
(→UPGRADE SCHEMA) |
(→Non-Abstract Methods) |
||
Line 144: | Line 144: | ||
|} | |} | ||
− | + | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
| protected || void appendUpgradeInitialize(StringBuffer buf, RelationalSchema schema) || May not be needed for Postgre || comp. || --- | | protected || void appendUpgradeInitialize(StringBuffer buf, RelationalSchema schema) || May not be needed for Postgre || comp. || --- | ||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
| public || void dropTable(Table table) ||--- || not started || --- | | public || void dropTable(Table table) ||--- || not started || --- | ||
|- | |- | ||
| protected || String getAlterColumnToken() ||--- || not started || --- | | protected || String getAlterColumnToken() ||--- || not started || --- | ||
− | |||
− | |||
|- | |- | ||
| protected || Table getDropSuccessor(Table left, Table right) ||--- || not started || --- | | protected || Table getDropSuccessor(Table left, Table right) ||--- || not started || --- | ||
− | |||
− | |||
|- | |- | ||
| protected || String getIndexName(Index index, boolean bConstraint, boolean bQuote) ||--- || not started || --- | | protected || String getIndexName(Index index, boolean bConstraint, boolean bQuote) ||--- || not started || --- |
Revision as of 18:39, 14 December 2010
Postgre Project - SQLSchemaManager Files
Contents
SQLSchemaManager.java
INITIAL SETUP OF SCHEMA
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
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
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
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
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
Modifier | Method | Tests Cases | Status | ToDo |
---|---|---|---|---|
--- | ---- | --- | --- | --- |