Difference between revisions of "PostgreSQL Adapter Project - Extending SQLAdapter"

From CDOT Wiki
Jump to: navigation, search
 
(9 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 13: Line 15:
 
|-
 
|-
 
|<code>appendIdentityColumn</code>
 
|<code>appendIdentityColumn</code>
−
|
+
| DONE
−
|
+
| DONE
 
|-
 
|-
 
|<code>appendIdentityPrefix</code>
 
|<code>appendIdentityPrefix</code>
−
|
+
| DONE
−
|
+
| DONE
 
|-
 
|-
 
|<code>appendIdentitySuffix</code>
 
|<code>appendIdentitySuffix</code>
−
|
+
| DONE
−
|
+
| DONE
 
|-
 
|-
 
|<code>appendIdentityValue</code>
 
|<code>appendIdentityValue</code>
−
|
+
| 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 41: Line 43:
 
|-
 
|-
 
|<code>appendNoRowsBlock</code> <br/> NOTE: Cannot use conditional statement outside<br/> stored procedure
 
|<code>appendNoRowsBlock</code> <br/> NOTE: Cannot use conditional statement outside<br/> stored procedure
−
| DONE
+
| N/A
−
|  
+
| N/A
 
|-
 
|-
 
|<code>appendNoRowsEnd</code> <br/>see note above
 
|<code>appendNoRowsEnd</code> <br/>see note above
−
| DONE
+
| N/A
−
|  
+
| N/A
 
|-
 
|-
 
|<code>appendNoRowsStart</code> <br/> see note above
 
|<code>appendNoRowsStart</code> <br/> see note above
−
| DONE
+
| N/A
−
|  
+
| N/A
 
|-
 
|-
 
|<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>
−
|
+
| N/A
−
|
+
| N/A
 
|-
 
|-
 
|<code>appendTypeConversion</code>
 
|<code>appendTypeConversion</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>
−
|
+
| DONE
−
|
+
| DONE
 
|-
 
|-
 
|<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

Important.png
This page may be obsolete.
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

Resources

String Literals
Database Encoding
Error Codes

Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=PostgreSQL_Adapter_Project_-_Extending_SQLAdapter&oldid=104075"