Difference between revisions of "User:AnastasiaS"

From CDOT Wiki
Jump to: navigation, search
Line 36: Line 36:
  
 
=== Week 7 ===
 
=== Week 7 ===
* Working on
+
* Working on [[PostgreSQL_Adapter-nexj/extendingSQLAdapter | PostgreSQLAdapter ]] class
 +
* Research on <code>match</code> expressions
 +
* Research on <code>noRows</code> condition in update statement
 +
* Alter sort direction (always nulls first)
 +
 
 +
=== Week 8 ===
 +
* Research on identity values in PostgreSQL (<code>SERIAL</code> and <code>BIGSERIAL</code> data types)
 +
* Research on type conversion
 +
* Research on Exceptions
 +
* Research on table and query HINTS

Revision as of 11:57, 8 March 2011


My blog spot [1]

Week 1

  • Go over Eclipse Tutorials
  • Read the wiki page materials
  • Research on PostgreSQL

Week 2

  • Research on Design Patterns, Adapter Design Patterns and Query Design Patterns
  • Go over "Working with Nexj Express Source Code" documentation
  • Get core code and briefly go over it
  • Read Nexj Studio Fundamentals

Week 3


Week 4

Week 5

  • Overriding methods from SQLSchemaManager class
  • Research on ordering rules in PostgreSQL


Week 6

  • Finishing up PostgreSQLSchemaManager class
  • Research on full text search in PostgreSQL
  • Adding necessary drop methods (columns, trigger functions, indexes)
  • Running all tests for PostgreSQ:SchemaManager class

Week 7

  • Working on PostgreSQLAdapter class
  • Research on match expressions
  • Research on noRows condition in update statement
  • Alter sort direction (always nulls first)

Week 8

  • Research on identity values in PostgreSQL (SERIAL and BIGSERIAL data types)
  • Research on type conversion
  • Research on Exceptions
  • Research on table and query HINTS