Difference between revisions of "PostgreSQL Adapter-nexj/SchemaManger"
(→SQLSchemaManager.java) |
(→MySQLSchemaManager.java) |
||
Line 135: | Line 135: | ||
|- | |- | ||
|} | |} | ||
− | |||
==PostgreSQLSchemaManager.java== | ==PostgreSQLSchemaManager.java== |
Revision as of 18:32, 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
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 |
---|---|---|---|---|
--- | ---- | --- | --- | --- |