Changes

Jump to: navigation, search

PostgreSQL Adapter Project - Extending SQLSchemaManager

909 bytes added, 13:30, 18 January 2011
no edit summary
| DONE
|-
| Research and add Maximum column PresisionPrecision
|
|
|
|}
 
== Task Details ==
=== Extend SQLSchemaManager to support PostgreSQL ===
Create a new class PostgreSQLSchemaManager by extending SQLSchemaManager and implementing all necessary abstract classes
 
=== Research and add Maximum column Precision ===
Following are the Maximum column precisions we might need to establish:
(All constants are defined in PostgreSQLAdapter class)
* DEFAULT_FETCH_SIZE
* MAX_CHAR_PRECISION
* MAX_VARCHAR_PRECISION
* MAX_BINARY_PRECISION
* MAX_VARBINARY_PRECISION
* MAX_REAL_PRECISION
* TIMESTAMP_FORMAT_SQL
* TIMESTAMP_FORMAT
 
=== Figure out Data Type Mapping ===
* Go over all data types offered in PostgreSQL
* Map types defined in <code>Primitive</code> class
 
=== Implement <code>appendColumnType()</code> method ===
This method appends a table column type declaration to a string buffer.
* use logic and mapping to append required column data types to incoming string.
* Test it
1
edit

Navigation menu