Open main menu

CDOT Wiki β

Changes

PostgreSQL Adapter Project - Extending SQLSchemaManager

495 bytes added, 16:00, 21 January 2011
no edit summary
* use logic and mapping to append required column data types to incoming string.
* Test it
 
=== Implement appendTSExtract() method ===
This method extracts a field from a timestamp. It uses <code>SQLSubstReaser</code>'s enums.
* Researc the extract function in the PostgreSQL
* Implement it in Adapter
* Test it
 
*NOTE: The logic to implement the extract function is similar to the one in MySQL Adapter. It could be a good idea to suggest to NexJ to add the <code>appendTSField</code> method to the super class, so we are not repeating the code. (Can be done in the Optimization stage)
==References==
[http://www.postgresql.org/docs/8.0/static/sql-commands.html#AEN36282 SQL Commands supported by PostgreSQL]
1
edit