PostgreSQL Adapter-nexj/SchemaManger

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	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 createIndex(Index index)	---	not started	---
protected	void createIndexes(Table table)	---	not started	---

UPGRADE 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 getDefaultIndexspace()	---	not started	---
protected abstract	String getDefaultLongspace()	---	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

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