PostgreSQL Adapter-nexj/SchemaManger

Postgre Project - SQLSchemaManager Files

SQLSchemaManager.java

Abstract Methods

Abstract methods to work on

Modifier	Method	Tests Cases	Status	ToDo
protected abstract	StringBuffer appendConcatenate(StringBuffer buf, CharSequence[] argArray)	---	not started	---
protected abstract	StringBuffer appendTSExtract(StringBuffer buf, CharSequence sTS, byte nField)	---	not started	---
protected abstract	StringBuffer appendTSIncrement(StringBuffer buf, CharSequence sTS, CharSequence sDelta, byte nField)	---	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)	---	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	---
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 getCreateEtcScriptName()	---	not started	---
protected abstract	String getDropEtcScriptName()	---	not started	---
protected abstract	String getSetupEtcScriptName()	---	not started	---
protected abstract	SQLAppender getDynamicSQLAppender(StringBuffer buf)	---	not started	---

Non-Abstract Methods

Non-Abstract methods to work on

Modifier	Method	Tests Cases	Status	ToDo
protected	void appendColumnSuffix(StringBuffer buf, Column column)	After main tests of SQLWriterConnectionTest.java are run(needed to be run first to setup tables)	not started	---
protected	void appendColumnType(StringBuffer buf, Column column)	After main tests of SQLWriterConnectionTest.java are run(needed to be run first to setup tables)	not started	---
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)	---	not started	---
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	---
public	String getDefaultRole()	---	not started	---
protected	Table getDropSuccessor(Table left, Table right)	---	not started	---
protected	String getFullTableName(String sSchemaName, String sTableName)	---	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

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