Difference between revisions of "PostgreSQL Adapter Project - Extending SQLAdapter"

From CDOT Wiki
Jump to: navigation, search
(Task Summary)
(Task Summary)
Line 35: Line 35:
 
|<code>appendLiteral</code>
 
|<code>appendLiteral</code>
 
|DONE
 
|DONE
|
+
| DONE
 
|-
 
|-
 
|a<code>ppendMatchStatement</code> <br/> NOTE: PostreSQL has only prefix match (like test).<br/> test fails on last assert (didn't find solution in postgreSQL doc)
 
|a<code>ppendMatchStatement</code> <br/> NOTE: PostreSQL has only prefix match (like test).<br/> test fails on last assert (didn't find solution in postgreSQL doc)
Line 74: Line 74:
 
|-
 
|-
 
|<code>appendTypeConversion</code>
 
|<code>appendTypeConversion</code>
|
+
| DONE
|
+
| DONE
 
|-
 
|-
 
|<code>bindIdentity</code>
 
|<code>bindIdentity</code>

Revision as of 17:41, 18 February 2011

  • Extend SQLAdapter to support PostgreSQL.
  • SQLAdapter is used to manipulate data in existing schemas (DML)



Task Summary

Task Status Test Status
Implement
appendIdentityColumn
appendIdentityPrefix
appendIdentitySuffix
appendIdentityValue
appendInfixHint
appendLiteral DONE DONE
appendMatchStatement
NOTE: PostreSQL has only prefix match (like test).
test fails on last assert (didn't find solution in postgreSQL doc)
DONE DONE
appendNoRowsBlock
appendNoRowsEnd
appendNoRowsStart
appendPrefixHint
appendStringLengthPrefix DONE DONE
appendSubstringPrefix DONE DONE
appendSuffixHint
appendTableHint
appendTypeConversion DONE DONE
bindIdentity
createSchemaManager DONE
getDuplicateKeyName
getIdentityValue
getMaxTime DONE
getMinTime DONE
getTestSQL DONE
indexNameMatches
isBatchSupported DONE
isBatchUpdateCountSupported DONE
isBatchable DONE
isDateRangeException DONE
isDeadlockException DONE ?
isDuplicateKeyException DONE ?
isLiteral DONE
isLockTimeoutException DONE ?
isQueryTimeoutException DONE
isUnicode DONE
Override
appendLiteral(StringBuffer buf, String sValue) DONE

Resources

String Literals
Database Encoding
Error Codes