Difference between revisions of "PostgreSQL Adapter Project - Extending SQLAdapter"
AnastasiaS (talk | contribs) (→Tasks) |
|||
(3 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
+ | {{Admon/obsolete}} | ||
+ | |||
[[category: NexJ Express PostgreSQL]][[category: NexJ Express Development]][[category: NexJ Express]] | [[category: NexJ Express PostgreSQL]][[category: NexJ Express Development]][[category: NexJ Express]] | ||
==Summary== | ==Summary== | ||
Line 28: | Line 30: | ||
| DONE | | DONE | ||
|- | |- | ||
− | |<code>appendInfixHint</code> <br/> PostgreSQL doesn't support HINTS | + | |<code>appendInfixHint</code> <br/> PostgreSQL doesn't support HINTS [http://xzilla.net/blog/2011/Feb/Why-the-F%25-Doesnt-Postgres-Have-Hints!!.html ] |
| N/A | | N/A | ||
| N/A | | N/A |
Latest revision as of 19:32, 26 January 2014
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 |