PostgreSQL Adapter Project - Extending SQLAdapter

From CDOT Wiki
Jump to: navigation, search
Important.png
This page may be obsolete.
It contains historical information.

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
PostgreSQL doesn't support HINTS [1]
N/A N/A
appendLiteral DONE DONE
appendMatchStatement DONE DONE
appendNoRowsBlock
NOTE: Cannot use conditional statement outside
stored procedure
N/A N/A
appendNoRowsEnd
see note above
N/A N/A
appendNoRowsStart
see note above
N/A N/A
appendPrefixHint N/A N/A
appendStringLengthPrefix DONE DONE
appendSubstringPrefix DONE DONE
appendSuffixHint DONE DONE
appendTableHint N/A N/A
appendTypeConversion DONE DONE
bindIdentity DONE DONE
createSchemaManager DONE DONE
getDuplicateKeyName DONE DONE
getIdentityValue DONE DONE
getMaxTime DONE DONE
getMinTime DONE DONE
getTestSQL DONE DONE
indexNameMatches DONE DONE
isBatchSupported DONE DONE
isBatchUpdateCountSupported DONE DONE
isBatchable DONE DONE
isDateRangeException DONE DONE
isDeadlockException DONE ? DONE
isDuplicateKeyException DONE DONE
isLiteral DONE DONE
isLockTimeoutException DONE ? DONE
isQueryTimeoutException DONE DONE
isUnicode DONE DONE
Override
appendLiteral(StringBuffer buf, String sValue) DONE DONE

Resources

String Literals
Database Encoding
Error Codes