Changes

PostgreSQL Adapter Project - Extending SQLSchemaManager

909 bytes added, 12:30, 18 January 2011

no edit summary

| DONE

|-

| Research and add Maximum column ~~Presision~~Precision

|

|}

== 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