PostgreSQL Adapter Project - Extending SQLAdapter
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 [[ http://xzilla.net/blog/2011/Feb/Why-the-F%25-Doesnt-Postgres-Have-Hints!!.html | 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 |
