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

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

Latest revision as of 10:16, 12 November 2010

SQLAdapter.java

Questions:
protected interface BindFactory
protected interface Bind

PostgreSQLAdapter.java

Abstract methods to work on
Method Type Method Name 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) 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 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/process&oldid=49526"