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

From CDOT Wiki
Jump to: navigation, search
(Tasks)
Line 13: Line 13:
 
|-
 
|-
 
|<code>appendIdentityColumn</code>
 
|<code>appendIdentityColumn</code>
|
+
| DONE
|
+
| DONE
 
|-
 
|-
 
|<code>appendIdentityPrefix</code>
 
|<code>appendIdentityPrefix</code>
|
+
| DONE
|
+
| DONE
 
|-
 
|-
 
|<code>appendIdentitySuffix</code>
 
|<code>appendIdentitySuffix</code>
|
+
| DONE
|
+
| DONE
 
|-
 
|-
 
|<code>appendIdentityValue</code>
 
|<code>appendIdentityValue</code>
|
+
| DONE
|
+
| DONE
 
|-
 
|-
 
|<code>appendInfixHint</code>
 
|<code>appendInfixHint</code>
Line 89: Line 89:
 
|-
 
|-
 
|<code>getIdentityValue</code>
 
|<code>getIdentityValue</code>
|
+
| DONE
|
+
| DONE
 
|-
 
|-
 
|<code>getMaxTime</code>
 
|<code>getMaxTime</code>

Revision as of 13:30, 3 March 2011

Summary

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

Tasks

Task Status Test Status
Implement
appendIdentityColumn DONE DONE
appendIdentityPrefix DONE DONE
appendIdentitySuffix DONE DONE
appendIdentityValue DONE DONE
appendInfixHint
appendLiteral DONE DONE
appendMatchStatement DONE DONE
appendNoRowsBlock
NOTE: Cannot use conditional statement outside
stored procedure
DONE
appendNoRowsEnd
see note above
DONE
appendNoRowsStart
see note above
DONE
appendPrefixHint
appendStringLengthPrefix DONE DONE
appendSubstringPrefix DONE DONE
appendSuffixHint DONE
appendTableHint
appendTypeConversion DONE DONE
bindIdentity
createSchemaManager DONE
getDuplicateKeyName DONE
getIdentityValue DONE DONE
getMaxTime DONE
getMinTime DONE
getTestSQL DONE
indexNameMatches DONE DONE
isBatchSupported DONE
isBatchUpdateCountSupported DONE
isBatchable DONE
isDateRangeException DONE
isDeadlockException DONE ?
isDuplicateKeyException DONE DONE
isLiteral DONE
isLockTimeoutException DONE ?
isQueryTimeoutException DONE
isUnicode DONE
Override
appendLiteral(StringBuffer buf, String sValue) DONE

Resources

String Literals
Database Encoding
Error Codes