Difference between revisions of "PostgreSQL Adapter Project - Extending SQLAdapter"
| Line 1: | Line 1: | ||
| − | [[category: NexJ Express PostgreSQL]][[category: NexJ Express Development]] | + | [[category: NexJ Express PostgreSQL]][[category: NexJ Express Development]][[category: NexJ Express]] |
==Summary== | ==Summary== | ||
* Extend SQLAdapter to support PostgreSQL.<br/> | * Extend SQLAdapter to support PostgreSQL.<br/> | ||
Revision as of 15:02, 26 February 2011
Summary
- Extend SQLAdapter to support PostgreSQL.
- SQLAdapter is used to manipulate data in existing schemas (DML)
Tasks
| 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 | |
