Difference between revisions of "PostgreSQL Adapter Project - Extending SQLAdapter"
(→Tasks) |
|||
| (6 intermediate revisions by 2 users 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> | + | |<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 |
|- | |- | ||
|<code>appendLiteral</code> | |<code>appendLiteral</code> | ||
| Line 53: | Line 55: | ||
|- | |- | ||
|<code>appendPrefixHint</code> | |<code>appendPrefixHint</code> | ||
| − | | | + | | N/A |
| − | | | + | | N/A |
|- | |- | ||
|<code>appendStringLengthPrefix</code> | |<code>appendStringLengthPrefix</code> | ||
| Line 66: | Line 68: | ||
|<code>appendSuffixHint</code> | |<code>appendSuffixHint</code> | ||
| DONE | | DONE | ||
| − | | | + | | DONE |
|- | |- | ||
|<code>appendTableHint</code> | |<code>appendTableHint</code> | ||
| Line 77: | Line 79: | ||
|- | |- | ||
|<code>bindIdentity</code> | |<code>bindIdentity</code> | ||
| − | | | + | | DONE |
| − | | | + | | DONE |
|- | |- | ||
|<code>createSchemaManager</code> | |<code>createSchemaManager</code> | ||
| DONE | | DONE | ||
| − | | | + | | DONE |
|- | |- | ||
|<code>getDuplicateKeyName</code> | |<code>getDuplicateKeyName</code> | ||
| DONE | | DONE | ||
| − | | | + | | DONE |
|- | |- | ||
|<code>getIdentityValue</code> | |<code>getIdentityValue</code> | ||
| Line 93: | Line 95: | ||
|- | |- | ||
|<code>getMaxTime</code> | |<code>getMaxTime</code> | ||
| − | |DONE | + | | DONE |
| − | | | + | | DONE |
|- | |- | ||
|<code>getMinTime</code> | |<code>getMinTime</code> | ||
| − | |DONE | + | | DONE |
| − | | | + | | DONE |
|- | |- | ||
|<code>getTestSQL</code> | |<code>getTestSQL</code> | ||
| − | |DONE | + | | DONE |
| − | | | + | | DONE |
|- | |- | ||
|<code>indexNameMatches</code> | |<code>indexNameMatches</code> | ||
| − | |DONE | + | | DONE |
| − | |DONE | + | | DONE |
|- | |- | ||
|<code>isBatchSupported</code> | |<code>isBatchSupported</code> | ||
|DONE | |DONE | ||
| − | | | + | | DONE |
|- | |- | ||
|<code>isBatchUpdateCountSupported</code> | |<code>isBatchUpdateCountSupported</code> | ||
| − | |DONE | + | | DONE |
| − | | | + | | DONE |
|- | |- | ||
|<code>isBatchable</code> | |<code>isBatchable</code> | ||
| − | |DONE | + | | DONE |
| − | | | + | | DONE |
|- | |- | ||
|<code>isDateRangeException</code> | |<code>isDateRangeException</code> | ||
| − | |DONE | + | | DONE |
| − | | | + | | DONE |
|- | |- | ||
|<code>isDeadlockException</code> | |<code>isDeadlockException</code> | ||
| DONE ? | | DONE ? | ||
| − | | | + | | DONE |
|- | |- | ||
|<code>isDuplicateKeyException</code> | |<code>isDuplicateKeyException</code> | ||
| − | |DONE | + | | DONE |
| − | |DONE | + | | DONE |
|- | |- | ||
|<code>isLiteral</code> | |<code>isLiteral</code> | ||
| DONE | | DONE | ||
| − | | | + | | DONE |
|- | |- | ||
|<code>isLockTimeoutException</code> | |<code>isLockTimeoutException</code> | ||
| DONE ? | | DONE ? | ||
| − | | | + | | DONE |
|- | |- | ||
|<code>isQueryTimeoutException</code> | |<code>isQueryTimeoutException</code> | ||
| DONE | | DONE | ||
| − | | | + | | DONE |
|- | |- | ||
|<code>isUnicode</code> | |<code>isUnicode</code> | ||
| − | |DONE | + | | DONE |
| − | | | + | | DONE |
|- | |- | ||
| colspan="3" |'''Override''' | | colspan="3" |'''Override''' | ||
| Line 152: | Line 154: | ||
| <code>appendLiteral(StringBuffer buf, String sValue)</code> | | <code>appendLiteral(StringBuffer buf, String sValue)</code> | ||
|DONE | |DONE | ||
| − | | | + | | DONE |
|} | |} | ||
Latest revision as of 19:32, 26 January 2014
This page may be obsolete.
It contains historical information.
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 |
