PostgreSQL Adapter-nexj/Adapter

Postgre Project - SQLAdapter Files

SQLAdapter.java

1. Questions

protected interface BindFactory

protected interface Bind

Abstract methods to work on

Modifier	Method	Tests Cases	Status	ToDo
public abstract	boolean appendIdentityColumn(StringBuffer buf, SQLInsert work)	testNew(), testRanges()	not started	---
public abstract	void appendLiteral(StringBuffer buf, Primitive type, Object value)	testMatch(), testRead(), testLoad(), testNew(),testUpdate(), testDelete(), testSHaredLocking(), testSchemaUnicodeValidation()	not started	---
public abstract	void appendMatchStatement(StringBuffer buf, String sAlias, Column column, SQLJoin join, Pair expression)	testMatch()	not started	---
public abstract	void appendTypeConversion(StringBuffer buf, Object op,Primitive fromType, Primitive type, SQLGenerator gen)	testRead()	not started	---
public abstract	void appendPrefixHint(StringBuffer buf, Query query)	no implementation in MySQLAdapter	not started	---
public abstract	void appendSuffixHint(StringBuffer buf, Query query)	at the setup time?	not started	---
public abstract	void appendIndexHint(StringBuffer buf, Query query)	testMatch()	not started	---
public abstract	void appendTableHint(StringBuffer buf, SQLJoin join, Query query)	no implementation in MySQLAdapter (Look at the Note in the method body)	not started	---
public abstract	void appendIdentityPrefix(StringBuffer buf, SQLInsert work)	no implementation in MySQLAdapter	not started	---
public abstract	boolean appendIdentityValue(StringBuffer buf, SQLInsert work)	testNew(), testRanges()	not started	---
public abstract	boolean appendIdentitySuffix(StringBuffer buf, SQLInsert work)	testNew(), testRanges()	not started	---
public abstract	void appendInfixHint(StringBuffer buf, Query query)	no implementation in MySQLAdapter	not started	---
public abstract	void bindIdentity(PreparedStatement stmt, SQLInsert work) throws SQLException	no implementation in MySQLAdapter	not started	---
public abstract	Object getIdentityValue(PreparedStatement stmt, Column column, SQLInsert work) throws SQLException	testNew(), testRanges()	not started	---
public abstract	boolean appendNoRowsBlock(StringBuffer buf)	testNew(), testSQLUpdateDenorm()	not started	---
public abstract	void appendNoRowsStart(StringBuffer buf)	no implementation in MySQLAdapter	not started	---
public abstract	void appendNoRowsEnd(StringBuffer buf)	no implementation in MySQLAdapter	not started	---
public abstract	boolean isBatchSupported()	testNew(), testRanges(), testInvalidation(), testUpdate(), testSQLUpdateDenorm(), testDelete() & All testWorkflows	not started	---
public abstract	boolean isBatchUpdateCountSupported()	same Test Cases as isBatchSupported()	not started	---
public abstract	boolean isBatchable(SQLWork work)	same Test Cases as isBatchSupported()	not started	---
protected abstract	boolean isDateRangeException(SQLException e)	---	not started	---
protected abstract	boolean isDuplicateKeyException(SQLException e)	testNew()	not started	---
protected abstract	String getDuplicateKeyName(SQLException e)	testNew()	not started	---
protected abstract	boolean indexNameMatches(Index index, String sPhysicalName)	testNew()	not started	---
protected abstract	boolean isDeadlockException(SQLException e)	---	not started	---
protected abstract	boolean isLockTimeoutException(SQLException e)	---	not started	---
public abstract	String appendStringLengthPrefix(StringBuffer buf, FunctionOperator op)	testRead()	not started	---
public abstract	String appendSubstringPrefix(StringBuffer buf, FunctionOperator op)	testRead()	not started	---
public abstract	boolean isLiteral(Primitive type, Object value)	testMatch(), testRead(), testLoad(), testNew(), testDelete(), testSharedLocking()	not started	---
protected abstract	long getMaxTime() & long getMinTime()	testUpdate(), testRanges(), testInvalidation() & All testWorkflows	not started	---
public abstract	SQLSchemaManager createSchemaManager()	All the tests (Through SQLDataTest)	not started	---
public abstract	String getTestSQL()	Before any test and during testMatch() (Gets SQL statement to execute to test that the connection is still valid)	not started	---
protected abstract	boolean isQueryTimeoutException(SQLException e)	testQueryTimeoutException(), testNew()	not started	---
protected abstract	Boolean isUnicode(RelationalSchema schema, ResultSet rs, int nColumn) throws SQLException	no implementation in MySQLAdapter	not started	---

Protected methods to work on

Modifier	Method Name	Tests Cases	Status	ToDo
protected	boolean isLikeReservedChar(char ch)	no implementation in MySQLAdapter	not started	---
protected	void appendLiteral(StringBuffer buf, String sValue)	testMatch(), testRead(), testLoad(), testNew(),testUpdate(), testDelete(), testSHaredLocking(), testSchemaUnicodeValidation(),	not started	---
protected	int roundUpListSize(int nSize, int nBindCount)	no implementation in MySQLAdapter	not started	---
protected	int roundUpMaxCount(int nMaxCount)	no implementation in MySQLAdapter	not started	---
protected	boolean indexNameMatches(String sMetadataName, int nMetaStart, String sPhysicalName, String sPrefix, boolean bCaseInsensitive)	testNew(), no implementation in MySQL, but it's called from indexNameMatches (Index, String)	not started	---

Public methods to work on

Modifier	Method Name	Tests Cases	after parsing	before parsing	Status	ToDo
public	void appendLikeEscape(StringBuffer buf)	testRead(), testUnicodeCharset()	where A.first_name like ? escape '\\' /* 1 */	parse("(and (like? firstName \"J*\")	not started	---
public	void close(Connection connection)	All the tests (After commit, closes the conncetion)	---	---	not started	---
public	SQLConnection getConnection(Query query) throws SQLException	All the tests	---	---	not started	---
public	String getInitialSQL()	Before any test and during testMatch() (Gets SQL statement to execute when a connection is first established)	---	---	not started	---
public	Table getMatchJoin(Column column, Pair expression)	testMatch() (see the comment for appendMatchStatement() in SQLAdapter)	---	---	not started	---
public	void setFetchSize(PreparedStatement stmt, Query query) throws SQLException	All the tests EXCEPT testUpgrade(), testSQLUpdateDenorm()	---	---	not started	---

PostgreSQLAdapter.java

Methods specific to PostgreSQL

Modifier	Method	Tests Cases	Status	ToDo
---	----	---	---	---

mthodes just added to MySQLAdapter.java

protected void appendMatchLiteral(StringBuffer buf, String sValue);

protected void appendMatchExpression(StringBuffer buf, Object expression, boolean bMax); testMatch()

protected String getIndexName(Table table, int nId); testNew() --- see comments for boolean indexNameMatches in SQLAdapter.java