Open main menu

CDOT Wiki β

Changes

Nexjexpress/PostgreSQL Adapter/Adapter

1,078 bytes added, 12:38, 17 November 2010
no edit summary
<big><big> Postgre Project - SQLAdapter Files</big></big>
 
 
==SQLAdapter.java==
#'''Questions'''
|-
| public abstract || boolean appendIdentityColumn(StringBuffer buf, SQLInsert work)|| testNew(), testRanges() || not started || ---
|-
| public abstract || String appendStringLengthPrefix(StringBuffer buf, FunctionOperator op) || --- || not started || ---
|-
| public abstract || String appendSubstringPrefix(StringBuffer buf, FunctionOperator op) || --- || not started || ---
|-
| public abstract || boolean isLiteral(Primitive type, Object value) || --- || 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 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 isQueryTimeoutExceptionisDuplicateKeyException(SQLException e)|| --- || not started || ---|-| protected abstract || boolean isDuplicateKeyExceptiontestNew(SQLException e)|| --- || 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 || 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 || ---
|-
|}
! 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 <code> indexNameMatches (Index, String) </code> || 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 || ---
|-
|}
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 <code>boolean indexNameMatches</code> in SQLAdapter.java
1
edit