Difference between revisions of "Nexjexpress/PostgreSQL Adapter/Adapter"

From CDOT Wiki
Jump to: navigation, search
(→‎PostgreSQLAdapter.java)
Line 10: Line 10:
 
! Method Type !! Method Name !! Tests Cases !! Status !!  ToDo
 
! Method Type !! Method Name !! Tests Cases !! Status !!  ToDo
 
|-
 
|-
−
| public abstract || String appendStringLengthPrefix(StringBuffer buf, FunctionOperator op) || not started ||  ---
+
| public abstract || String appendStringLengthPrefix(StringBuffer buf, FunctionOperator op) || --- || not started ||  ---
 
|-
 
|-
−
| public abstract || String appendSubstringPrefix(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 || boolean isLiteral(Primitive type, Object value) ||  --- || not started ||  ---
 
|-
 
|-
 
| public abstract ||  void appendLiteral(StringBuffer buf, Primitive type, Object value)|| testRead() || not started ||  ---
 
| public abstract ||  void appendLiteral(StringBuffer buf, Primitive type, Object value)|| testRead() || not started ||  ---
Line 20: Line 20:
 
| public abstract || void appendTypeConversion(StringBuffer buf, Object op,Primitive fromType, Primitive type, SQLGenerator gen) || not started ||  ---
 
| public abstract || void appendTypeConversion(StringBuffer buf, Object op,Primitive fromType, Primitive type, SQLGenerator gen) || not started ||  ---
 
|-
 
|-
−
| public abstract ||  void appendPrefixHint(StringBuffer buf, Query query) || not started ||  ---
+
| public abstract ||  void appendPrefixHint(StringBuffer buf, Query query) ||  --- || not started ||  ---
 
|-
 
|-
−
| public abstract ||  void appendInfixHint(StringBuffer buf, Query query) || not started ||  ---
+
| public abstract ||  void appendInfixHint(StringBuffer buf, Query query) ||  --- || not started ||  ---
 
|-
 
|-
−
| public abstract || void appendSuffixHint(StringBuffer buf, Query query)|| not started ||  ---
+
| public abstract || void appendSuffixHint(StringBuffer buf, Query query)||  --- || not started ||  ---
 
|-
 
|-
−
| public abstract || void appendTableHint(StringBuffer buf, SQLJoin join, Query query)|| not started ||  ---
+
| public abstract || void appendTableHint(StringBuffer buf, SQLJoin join, Query query)||  --- || not started ||  ---
 
|-
 
|-
−
| public abstract || void appendIdentityPrefix(StringBuffer buf, SQLInsert work)|| not started ||  ---
+
| public abstract || void appendIdentityPrefix(StringBuffer buf, SQLInsert work)||  --- || not started ||  ---
 
|-
 
|-
−
| public abstract || boolean appendIdentityColumn(StringBuffer buf, SQLInsert work)|| not started ||  ---
+
| public abstract || boolean appendIdentityColumn(StringBuffer buf, SQLInsert work)||  --- || not started ||  ---
 
|-
 
|-
−
| public abstract || boolean appendIdentityValue(StringBuffer buf, SQLInsert work)|| not started ||  ---
+
| public abstract || boolean appendIdentityValue(StringBuffer buf, SQLInsert work)||  --- || not started ||  ---
 
|-
 
|-
−
| public abstract || boolean appendIdentitySuffix(StringBuffer buf, SQLInsert work)|| not started ||  ---
+
| public abstract || boolean appendIdentitySuffix(StringBuffer buf, SQLInsert work)||  --- || not started ||  ---
 
|-
 
|-
−
| public abstract || void bindIdentity(PreparedStatement stmt, SQLInsert work) throws SQLException|| not started ||  ---
+
| public abstract || void bindIdentity(PreparedStatement stmt, SQLInsert work) throws SQLException||  --- || not started ||  ---
 
|-
 
|-
 
| public abstract || Object getIdentityValue(PreparedStatement stmt, Column column, SQLInsert work) throws SQLException|| not started ||  ---
 
| public abstract || Object getIdentityValue(PreparedStatement stmt, Column column, SQLInsert work) throws SQLException|| not started ||  ---
 
|-
 
|-
−
| public abstract || boolean appendNoRowsBlock(StringBuffer buf)|| not started ||  ---
+
| public abstract || boolean appendNoRowsBlock(StringBuffer buf)||  --- || not started ||  ---
 
|-
 
|-
−
| public abstract || void appendNoRowsStart(StringBuffer buf)|| not started ||  ---
+
| public abstract || void appendNoRowsStart(StringBuffer buf)||  --- || not started ||  ---
 
|-
 
|-
−
| public abstract || boolean isBatchSupported()|| not started ||  ---
+
| public abstract || boolean isBatchSupported()||  --- || not started ||  ---
 
|-
 
|-
−
| public abstract || boolean isBatchUpdateCountSupported()|| not started ||  ---
+
| public abstract || boolean isBatchUpdateCountSupported()||  --- || not started ||  ---
 
|-
 
|-
−
| public abstract || boolean isBatchable(SQLWork work)|| not started ||  ---
+
| public abstract || boolean isBatchable(SQLWork work)||  --- || not started ||  ---
 
|-
 
|-
−
| protected abstract || boolean isDateRangeException(SQLException e)|| not started ||  ---
+
| protected abstract || boolean isDateRangeException(SQLException e)||  --- || not started ||  ---
 
|-
 
|-
−
| protected abstract || boolean isQueryTimeoutException(SQLException e)|| not started ||  ---
+
| protected abstract || boolean isQueryTimeoutException(SQLException e)||  --- || not started ||  ---
 
|-
 
|-
−
| protected abstract || boolean isDuplicateKeyException(SQLException e)|| not started ||  ---
+
| protected abstract || boolean isDuplicateKeyException(SQLException e)||  --- || not started ||  ---
 
|-
 
|-
−
| protected abstract || String getDuplicateKeyName(SQLException e)|| not started ||  ---
+
| protected abstract || String getDuplicateKeyName(SQLException e)||  --- || not started ||  ---
 
|-
 
|-
−
| protected abstract || boolean indexNameMatches(Index index, String sPhysicalName)|| not started ||  ---
+
| protected abstract || boolean indexNameMatches(Index index, String sPhysicalName)||  --- || not started ||  ---
 
|-
 
|-
−
| protected abstract || boolean isDeadlockException(SQLException e)|| not started ||  ---
+
| protected abstract || boolean isDeadlockException(SQLException e)||  --- || not started ||  ---
 
|-
 
|-
 
| protected abstract || boolean isLockTimeoutException(SQLException e)|| not started ||  ---
 
| protected abstract || boolean isLockTimeoutException(SQLException e)|| not started ||  ---
 
|-
 
|-
−
| public abstract || SQLSchemaManager createSchemaManager()|| not started ||  ---
+
| public abstract || SQLSchemaManager createSchemaManager()||  --- || not started ||  ---
 
|-
 
|-
 
|}
 
|}
Line 71: Line 71:
 
{| class="wikitable sortable" border="1" cellpadding="5"
 
{| class="wikitable sortable" border="1" cellpadding="5"
 
|+  '''Protected methods to work on'''
 
|+  '''Protected methods to work on'''
−
! Method Type !! Method Name !! Status !!  ToDo
+
! Method Type !! Method Name !! Tests Cases !! Status !!  ToDo
 
|-
 
|-
−
| protected ||  boolean isLikeReservedChar(char ch)|| not started ||  ---
+
| protected ||  boolean isLikeReservedChar(char ch)||  --- || not started ||  ---
 
|-
 
|-
−
| protected ||  void appendLiteral(StringBuffer buf, String sValue)|| not started ||  ---
+
| protected ||  void appendLiteral(StringBuffer buf, String sValue)||  --- || not started ||  ---
 
|-
 
|-
−
| protected ||  int roundUpListSize(int nSize, int nBindCount)|| not started ||  ---
+
| protected ||  int roundUpListSize(int nSize, int nBindCount)||  --- || not started ||  ---
 
|-
 
|-
−
| protected ||  int roundUpMaxCount(int nMaxCount)|| not started ||  ---
+
| protected ||  int roundUpMaxCount(int nMaxCount)||  --- || not started ||  ---
 
|-
 
|-
−
| protected ||  boolean indexNameMatches(String sMetadataName, int nMetaStart, String sPhysicalName, String sPrefix, boolean bCaseInsensitive)|| not started ||  ---
+
| protected ||  boolean indexNameMatches(String sMetadataName, int nMetaStart, String sPhysicalName, String sPrefix, boolean bCaseInsensitive)||  --- || not started ||  ---
 
|-
 
|-
 
|}
 
|}
  
 
==MySQLAdapter.java==
 
==MySQLAdapter.java==

Revision as of 14:15, 12 November 2010

SQLAdapter.java

Questions:
protected interface BindFactory
protected interface Bind

PostgreSQLAdapter.java

Abstract methods to work on
Method Type Method Name Tests Cases Status ToDo
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) testRead() not started ---
public abstract void appendTypeConversion(StringBuffer buf, Object op,Primitive fromType, Primitive type, SQLGenerator gen) not started ---
public abstract void appendPrefixHint(StringBuffer buf, Query query) --- not started ---
public abstract void appendInfixHint(StringBuffer buf, Query query) --- not started ---
public abstract void appendSuffixHint(StringBuffer buf, Query query) --- not started ---
public abstract void appendTableHint(StringBuffer buf, SQLJoin join, Query query) --- not started ---
public abstract void appendIdentityPrefix(StringBuffer buf, SQLInsert work) --- not started ---
public abstract boolean appendIdentityColumn(StringBuffer buf, SQLInsert work) --- not started ---
public abstract boolean appendIdentityValue(StringBuffer buf, SQLInsert work) --- not started ---
public abstract boolean appendIdentitySuffix(StringBuffer buf, SQLInsert work) --- not started ---
public abstract void bindIdentity(PreparedStatement stmt, SQLInsert work) throws SQLException --- not started ---
public abstract Object getIdentityValue(PreparedStatement stmt, Column column, SQLInsert work) throws SQLException not started ---
public abstract boolean appendNoRowsBlock(StringBuffer buf) --- not started ---
public abstract void appendNoRowsStart(StringBuffer buf) --- not started ---
public abstract boolean isBatchSupported() --- not started ---
public abstract boolean isBatchUpdateCountSupported() --- not started ---
public abstract boolean isBatchable(SQLWork work) --- not started ---
protected abstract boolean isDateRangeException(SQLException e) --- not started ---
protected abstract boolean isQueryTimeoutException(SQLException e) --- not started ---
protected abstract boolean isDuplicateKeyException(SQLException e) --- not started ---
protected abstract String getDuplicateKeyName(SQLException e) --- not started ---
protected abstract boolean indexNameMatches(Index index, String sPhysicalName) --- not started ---
protected abstract boolean isDeadlockException(SQLException e) --- not started ---
protected abstract boolean isLockTimeoutException(SQLException e) not started ---
public abstract SQLSchemaManager createSchemaManager() --- not started ---


Protected methods to work on
Method Type Method Name Tests Cases Status ToDo
protected boolean isLikeReservedChar(char ch) --- not started ---
protected void appendLiteral(StringBuffer buf, String sValue) --- not started ---
protected int roundUpListSize(int nSize, int nBindCount) --- not started ---
protected int roundUpMaxCount(int nMaxCount) --- not started ---
protected boolean indexNameMatches(String sMetadataName, int nMetaStart, String sPhysicalName, String sPrefix, boolean bCaseInsensitive) --- not started ---

MySQLAdapter.java

Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=Nexjexpress/PostgreSQL_Adapter/Adapter&oldid=49542"