Difference between revisions of "PostgreSQL Adapter Project - Extending SQLAdapter"
| Line 3: | Line 3: | ||
* Extend SQLAdapter to support PostgreSQL.<br/> | * Extend SQLAdapter to support PostgreSQL.<br/> | ||
* SQLAdapter is used to manipulate data in existing schemas (DML)<br/> | * SQLAdapter is used to manipulate data in existing schemas (DML)<br/> | ||
| − | |||
| − | |||
==Task Summary== | ==Task Summary== | ||
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;" | {| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;" | ||
Revision as of 15:55, 26 February 2011
Summary
- 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 doesn't have weight option. test fails on last assert (didn't find solution in postgreSQL doc) |
DONE ? | DONE |
appendNoRowsBlock NOTE: Cannot use conditional statement outside stored procedure |
N/A | ? |
appendNoRowsEnd
|
N/A | ? |
appendNoRowsStart
|
N/A | ? |
appendPrefixHint
|
||
appendStringLengthPrefix
|
DONE | DONE |
appendSubstringPrefix
|
DONE | DONE |
appendSuffixHint
|
||
appendTableHint
|
||
appendTypeConversion
|
DONE | DONE |
bindIdentity
|
||
createSchemaManager
|
DONE | |
getDuplicateKeyName
|
DONE | |
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 | |
