1,234
edits
Changes
no edit summary
{{Admon/obsolete}} [[category: NexJ Express PostgreSQL]][[category: NexJ Express Development]][[category: NexJ Express]]==Summary==
* Extend SQLAdapter to support PostgreSQL.<br/>
* SQLAdapter is used to manipulate data in existing schemas (DML)<br/>
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
|-
|-
|<code>appendIdentityColumn</code>
|DONE|DONE
|-
|<code>appendIdentityPrefix</code>
|DONE|DONE
|-
|<code>appendIdentitySuffix</code>
|DONE|DONE
|-
|<code>appendIdentityValue</code>
|DONE|DONE
|-
|<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>
| DONE
|-
|a<code>ppendMatchStatement</code> <br/> NOTE: PostreSQL doesn't have weight option.<br/> test fails on last assert (didn't find solution in postgreSQL doc)| DONE ?
| DONE
|-
|<code>appendNoRowsBlock</code><br/> NOTE: Cannot use conditional statement outside<br/> stored procedure|N/A|N/A
|-
|<code>appendNoRowsEnd</code><br/>see note above|N/A|N/A
|-
|<code>appendNoRowsStart</code><br/> see note above|N/A|N/A
|-
|<code>appendPrefixHint</code>
|N/A|N/A
|-
|<code>appendStringLengthPrefix</code>
|-
|<code>appendSuffixHint</code>
|DONE|DONE
|-
|<code>appendTableHint</code>
|N/A|N/A
|-
|<code>appendTypeConversion</code>
|-
|<code>bindIdentity</code>
|DONE|DONE
|-
|<code>createSchemaManager</code>
| DONE
| DONE
|-
|<code>getDuplicateKeyName</code>
|DONE|DONE
|-
|<code>getIdentityValue</code>
|DONE|DONE
|-
|<code>getMaxTime</code>
|DONE|DONE
|-
|<code>getMinTime</code>
|DONE|DONE
|-
|<code>getTestSQL</code>
|DONE|DONE
|-
|<code>indexNameMatches</code>
|DONE|DONE
|-
|<code>isBatchSupported</code>
|DONE
|DONE
|-
|<code>isBatchUpdateCountSupported</code>
|DONE|DONE
|-
|<code>isBatchable</code>
|DONE|DONE
|-
|<code>isDateRangeException</code>
|DONE|DONE
|-
|<code>isDeadlockException</code>
| DONE ?
|DONE
|-
|<code>isDuplicateKeyException</code>
|DONE ?|DONE
|-
|<code>isLiteral</code>
| DONE
|DONE
|-
|<code>isLockTimeoutException</code>
| DONE ?
|DONE
|-
|<code>isQueryTimeoutException</code>
| DONE
|DONE
|-
|<code>isUnicode</code>
|DONE|DONE
|-
| colspan="3" |'''Override'''
| <code>appendLiteral(StringBuffer buf, String sValue)</code>
|DONE
|DONE
|}