Difference between revisions of "SQLite Adapter StandUp Reports"

From CDOT Wiki
Jump to: navigation, search
Line 6: Line 6:
 
<!--
 
<!--
 
=Week 9: Nov 21=
 
=Week 9: Nov 21=
==Thursday==
+
'''Thursday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*
 
*
Line 20: Line 20:
 
*
 
*
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*
 
*
Line 33: Line 33:
 
*
 
*
  
==Monday==
+
'''Monday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*
 
*
Line 47: Line 47:
 
*
 
*
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*
 
*
Line 62: Line 62:
 
=Week 9: Nov 21=
 
=Week 9: Nov 21=
 
<!--
 
<!--
==Thursday==
+
'''Thursday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*
 
*
Line 76: Line 76:
 
*
 
*
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*
 
*
Line 89: Line 89:
 
*
 
*
 
-->
 
-->
==Monday==
+
'''Monday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*
 
*
Line 103: Line 103:
 
*
 
*
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
*
+
* Fixing table alterations
 +
 
  
 
What am I working on before the next stand up?
 
What am I working on before the next stand up?
*
+
* Reading of full-text search indexes
  
 
What is blocking me?
 
What is blocking me?
*
+
* n/a
  
 
What am I blocking (or about to block)?
 
What am I blocking (or about to block)?
*
+
* n/a
  
 
=Week 8: Nov 14=
 
=Week 8: Nov 14=
==Thursday==
+
'''Thursday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*
 
*
Line 131: Line 132:
 
*
 
*
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
*
+
* Running Scheme scripts
 +
* Updated sprint backlog
 +
* Assigning new tasks to the team
  
 
What am I working on before the next stand up?
 
What am I working on before the next stand up?
*
+
* Fixing table alterations
  
 
What is blocking me?
 
What is blocking me?
*
+
* n/a
  
 
What am I blocking (or about to block)?
 
What am I blocking (or about to block)?
*
+
* n/a
  
==Monday==
+
'''Monday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*
 
*
Line 158: Line 161:
 
*
 
*
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
*
+
* Syncing full-text search table with source table
 +
* Alter column
  
 
What am I working on before the next stand up?
 
What am I working on before the next stand up?
*
+
* Fixing alter column
 +
* Testing scheme commands to interact with db
 +
* Forcing connection isolation level to TRANSACTION_SERIALIZEABLE
  
 
What is blocking me?
 
What is blocking me?
*
+
* Waiting on scheme commands from NexJ
  
 
What am I blocking (or about to block)?
 
What am I blocking (or about to block)?
*
+
* n/a
  
 
=Week 7: Nov 8=
 
=Week 7: Nov 8=
==Thursday==
+
'''Thursday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* AlterColumn design
 
* AlterColumn design
Line 189: Line 195:
 
* n/a
 
* n/a
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 +
* Testing with Studio Express
 
* Maintenance of full-text search indexes
 
* Maintenance of full-text search indexes
  
Line 202: Line 209:
 
* n/a
 
* n/a
  
==Monday==
+
'''Monday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* Append Literal peer review
 
* Append Literal peer review
Line 216: Line 223:
 
* n/a
 
* n/a
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* Create Teee Debugging launcher
 
* Create Teee Debugging launcher
Line 232: Line 239:
  
 
=Week 6: Oct 31=
 
=Week 6: Oct 31=
==Thursday==
+
'''Thursday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* Review and wrap up of sprint 1 patch
 
* Review and wrap up of sprint 1 patch
Line 246: Line 253:
 
* n/a
 
* n/a
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* Assigning Tickets
 
* Assigning Tickets
Line 260: Line 267:
 
*
 
*
  
==Monday==
+
'''Monday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* Case Insensitivity in SQLiteSchemaManager
 
* Case Insensitivity in SQLiteSchemaManager
Line 276: Line 283:
 
* Sprint 1 completion
 
* Sprint 1 completion
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* Testing SQLite adapter with Studio express
 
* Testing SQLite adapter with Studio express
Line 290: Line 297:
  
 
=Week 5: Oct 24=
 
=Week 5: Oct 24=
==Thursday==
+
'''Thursday'''<br/>
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*Updated repo to latest version from mercurial.nexj.com
 
*Updated repo to latest version from mercurial.nexj.com
Line 306: Line 313:
 
*
 
*
  
==Monday==
+
'''Monday'''<br/>
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*Still Implementing PseudoXA for SQLite
 
*Still Implementing PseudoXA for SQLite
Line 321: Line 328:
  
 
=Week 4: Oct 17=
 
=Week 4: Oct 17=
==Thursday==
+
'''Thursday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* SQLite specific view implementation
 
* SQLite specific view implementation
Line 337: Line 344:
 
* Sprint 1 completion
 
* Sprint 1 completion
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*Implementing PseudoXA for SQLite
 
*Implementing PseudoXA for SQLite
Line 350: Line 357:
 
*completion of sprint 1
 
*completion of sprint 1
  
===Abhishek===
+
'''Abhishek'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* Updating and adding the following components to SQLiteSQLSchemaManager:
 
* Updating and adding the following components to SQLiteSQLSchemaManager:
Line 369: Line 376:
 
* completion of sprint 1
 
* completion of sprint 1
  
==Monday==
+
'''Monday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* n/a
 
* n/a
Line 384: Line 391:
 
* Sprint 1 completion
 
* Sprint 1 completion
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*n/a
 
*n/a
Line 397: Line 404:
 
*Completion of sprint 1
 
*Completion of sprint 1
  
===Abhishek===
+
'''Abhishek'''<br/>
 
sick (n/a)
 
sick (n/a)
  
 
=Week 3: Oct 10 =
 
=Week 3: Oct 10 =
==Thursday==
+
'''Thursday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* Added full text search index support in SQLite schema manager
 
* Added full text search index support in SQLite schema manager
Line 419: Line 426:
 
*Completion of sprint 1
 
*Completion of sprint 1
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*Creating and assigning tasks
 
*Creating and assigning tasks
Line 434: Line 441:
 
*Completion of sprint 1
 
*Completion of sprint 1
  
===Abhishek===
+
'''Abhishek'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* Finished reproducing unit test sql scripts in SQLite format from the existing MySQL scripts
 
* Finished reproducing unit test sql scripts in SQLite format from the existing MySQL scripts
Line 455: Line 462:
 
* Completion of sprint 1
 
* Completion of sprint 1
  
==Monday==
+
'''Monday'''<br/>
 
N/A -- public holiday
 
N/A -- public holiday
  
  
 
=Week 2: Oct 3=
 
=Week 2: Oct 3=
==Thursday==
+
'''Thursday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* appendColumnType && Suffix
 
* appendColumnType && Suffix
Line 478: Line 485:
 
* unit test setup
 
* unit test setup
  
===Abhishek===
+
'''Abhishek'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* Researched and experimented with sqlite to gain a better understanding of it.
 
* Researched and experimented with sqlite to gain a better understanding of it.
Line 492: Line 499:
 
* I am creating test input data for some of the unit tests. I am perhaps blocking anyone/thing interested in seeing a fully working test of the adapter.
 
* I am creating test input data for some of the unit tests. I am perhaps blocking anyone/thing interested in seeing a fully working test of the adapter.
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* Followed up on architectural design with NexJ.
 
* Followed up on architectural design with NexJ.
Line 506: Line 513:
 
* n/a
 
* n/a
  
==Monday==
+
'''Monday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* Worked with Grace to get story 1 working
 
* Worked with Grace to get story 1 working
Line 521: Line 528:
 
* n/a
 
* n/a
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* Got user story 1 working (may be changed in future depending on architectural design).
 
* Got user story 1 working (may be changed in future depending on architectural design).
Line 538: Line 545:
 
=Week 1: Sept 26=
 
=Week 1: Sept 26=
  
==Thursday==
+
'''Thursday==
===Carlin===
+
'''Carlin===
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* creating SQLite: dataSourceWrapper, AdapterTest, SchemaManagerTest, SQLManagedConnection, SQLAdapter, SQLSchemaManager
 
* creating SQLite: dataSourceWrapper, AdapterTest, SchemaManagerTest, SQLManagedConnection, SQLAdapter, SQLSchemaManager
Line 552: Line 559:
 
* Story 1 completion
 
* Story 1 completion
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* Gave Carl code walk through
 
* Gave Carl code walk through
Line 566: Line 573:
 
* User story 1,2,3
 
* User story 1,2,3
  
==Monday==
+
'''Monday'''<br/>
===Carlin===
+
'''Carlin'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
* N/A
 
* N/A
Line 580: Line 587:
 
* N/A
 
* N/A
  
===Grace===
+
'''Grace'''<br/>
 
What have I worked on since the last stand up?
 
What have I worked on since the last stand up?
 
*N/A
 
*N/A

Revision as of 12:25, 21 November 2011


Overview

Stand up reports will be posted each Monday and Thursday by 12pm.

Week 9: Nov 21

Monday
Carlin
What have I worked on since the last stand up?

What am I working on before the next stand up?

What is blocking me?

What am I blocking (or about to block)?

Grace
What have I worked on since the last stand up?

  • Fixing table alterations


What am I working on before the next stand up?

  • Reading of full-text search indexes

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • n/a

Week 8: Nov 14

Thursday
Carlin
What have I worked on since the last stand up?

What am I working on before the next stand up?

What is blocking me?

What am I blocking (or about to block)?

Grace
What have I worked on since the last stand up?

  • Running Scheme scripts
  • Updated sprint backlog
  • Assigning new tasks to the team

What am I working on before the next stand up?

  • Fixing table alterations

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • n/a

Monday
Carlin
What have I worked on since the last stand up?

What am I working on before the next stand up?

What is blocking me?

What am I blocking (or about to block)?

Grace
What have I worked on since the last stand up?

  • Syncing full-text search table with source table
  • Alter column

What am I working on before the next stand up?

  • Fixing alter column
  • Testing scheme commands to interact with db
  • Forcing connection isolation level to TRANSACTION_SERIALIZEABLE

What is blocking me?

  • Waiting on scheme commands from NexJ

What am I blocking (or about to block)?

  • n/a

Week 7: Nov 8

Thursday
Carlin
What have I worked on since the last stand up?

  • AlterColumn design
  • Generate UUID bug fix

What am I working on before the next stand up?

  • AlterColum review
  • isConversion issue
  • Sprint 2 meeting

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • n/a

Grace
What have I worked on since the last stand up?

  • Testing with Studio Express
  • Maintenance of full-text search indexes

What am I working on before the next stand up?

  • Creating of SQLite sql scripts

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • n/a

Monday
Carlin
What have I worked on since the last stand up?

  • Append Literal peer review

What am I working on before the next stand up?

  • SQLAdapter ticket peer review

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • n/a

Grace
What have I worked on since the last stand up?

  • Create Teee Debugging launcher
  • SQLiteAdapter Drop Column

What am I working on before the next stand up?

  • Creating SQL scripts
  • Full Text Search Support

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • n/a

Week 6: Oct 31

Thursday
Carlin
What have I worked on since the last stand up?

  • Review and wrap up of sprint 1 patch

What am I working on before the next stand up?

  • Peer review colleagues commits

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • n/a

Grace
What have I worked on since the last stand up?

  • Assigning Tickets
  • Peer reviewing tickets

What am I working on before the next stand up?

  • Fixing running of unit tests.

What is blocking me?

What am I blocking (or about to block)?

Monday
Carlin
What have I worked on since the last stand up?

  • Case Insensitivity in SQLiteSchemaManager
  • Ticket review of commits last week
  • Framework review of adapter integration

What am I working on before the next stand up?

  • Helping Grace with Sprint 1 completion

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • Sprint 1 completion

Grace
What have I worked on since the last stand up?

  • Testing SQLite adapter with Studio express

What am I working on before the next stand up?

  • Preparing deliverable for sprint 1

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • n/a

Week 5: Oct 24

Thursday
Grace
What have I worked on since the last stand up?

  • Updated repo to latest version from mercurial.nexj.com
  • Fixed implementation of PseudoXA for SQLite
  • Testing adapter with studio

What am I working on before the next stand up?

  • Reviewing code for sprint 1

What is blocking me?

  • n/a

What am I blocking (or about to block)?

Monday
Grace
What have I worked on since the last stand up?

  • Still Implementing PseudoXA for SQLite

What am I working on before the next stand up?

  • Testing the adapter with Studio

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • completion of sprint 1

Week 4: Oct 17

Thursday
Carlin
What have I worked on since the last stand up?

  • SQLite specific view implementation

What am I working on before the next stand up?

  • Completing SQLite views
  • Analyzing XADatasource commits
  • Testing within studio

What is blocking me?

  • Midterms

What am I blocking (or about to block)?

  • Sprint 1 completion

Grace
What have I worked on since the last stand up?

  • Implementing PseudoXA for SQLite

What am I working on before the next stand up?

  • Testing the adapter with Studio

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • completion of sprint 1

Abhishek
What have I worked on since the last stand up?

  • Updating and adding the following components to SQLiteSQLSchemaManager:
    • implement string concatenation
    • implement analyze table
    • generate UUID
    • get current time
    • print to output
    • general code cleanup

What am I working on before the next stand up?

  • Implemeting a method in the SQLiteSQLSchemaManager to append to the buffer SQLite specific literal representation

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • completion of sprint 1

Monday
Carlin
What have I worked on since the last stand up?

  • n/a

What am I working on before the next stand up?

  • SQLiteSchemaManager timestamp handling
  • SQLite project software design document

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • Sprint 1 completion

Grace
What have I worked on since the last stand up?

  • n/a

What am I working on before the next stand up?

  • Implementing PseudoXA for SQLite

What is blocking me?

  • Update of the external repo with PseduoXA* classes.

What am I blocking (or about to block)?

  • Completion of sprint 1

Abhishek
sick (n/a)

Week 3: Oct 10

Thursday
Carlin
What have I worked on since the last stand up?

  • Added full text search index support in SQLite schema manager
  • Fixed truncate table
  • SQLite adapter software design document

What am I working on before the next stand up?

  • SQlite adapter software design document
  • SQlite adapter time stamp support

What is blocking me?

  • Waiting on PseudoXA* code to be uploaded to the repo
  • Waiting on Studio Express 8 update on OHT-AIP site

What am I blocking (or about to block)?

  • Completion of sprint 1

Grace
What have I worked on since the last stand up?

  • Creating and assigning tasks
  • Fixed creation of primary keys with autoincrement

What am I working on before the next stand up?

  • Testing SQLite adapter with Studio

What is blocking me?

  • Waiting on PseudoXA* code to be uploaded to the repo
  • Waiting on Studio Express 8 update on OHT-AIP site

What am I blocking (or about to block)?

  • Completion of sprint 1

Abhishek
What have I worked on since the last stand up?

  • Finished reproducing unit test sql scripts in SQLite format from the existing MySQL scripts
  • Finished researching various SQLite components: sequences, procedures, and triggers

What am I working on before the next stand up?

  • Testing SQLite adapter with Studio
  • Updating and adding the following components to SQLiteSQLSchemaManager:
    • implement string concatenation
    • implement analyze table
    • generate UUID
    • get current time
    • print to output
    • general code cleanup

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • Completion of sprint 1

Monday
N/A -- public holiday


Week 2: Oct 3

Thursday
Carlin
What have I worked on since the last stand up?

  • appendColumnType && Suffix
  • methods required by the sqliteSchemaManagerTest
  • sqlite software design document

What am I working on before the next stand up?

  • continue advancing on required methods for sqliteSchemaManagerTest
  • researching indexing within sqlite
  • createIndex methods in schemaManager

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • unit test setup

Abhishek
What have I worked on since the last stand up?

  • Researched and experimented with sqlite to gain a better understanding of it.
  • Started working on user story 3.

What am I working on before the next stand up?

  • Completing user story 3

What is blocking me?

  • nobody

What am I blocking (or about to block)?

  • I am creating test input data for some of the unit tests. I am perhaps blocking anyone/thing interested in seeing a fully working test of the adapter.

Grace
What have I worked on since the last stand up?

  • Followed up on architectural design with NexJ.
  • Breaking down user stories into tasks and creating tickets.

What am I working on before the next stand up?

  • Breaking down user stories into tasks and creating tickets.

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • n/a

Monday
Carlin
What have I worked on since the last stand up?

  • Worked with Grace to get story 1 working

What am I working on before the next stand up?

  • changing the location of sqlite db
  • starting database schema scripts

What is blocking me?

  • framework knowledge, graces direction

What am I blocking (or about to block)?

  • n/a

Grace
What have I worked on since the last stand up?

  • Got user story 1 working (may be changed in future depending on architectural design).

What am I working on before the next stand up?

  • Assigning work to Carl that is not related to XA's.
  • Follow up with Greg on architectural design of the driver.

What is blocking me?

  • n/a

What am I blocking (or about to block)?

  • n/a


Week 1: Sept 26

Thursday== Carlin=== What have I worked on since the last stand up?

  • creating SQLite: dataSourceWrapper, AdapterTest, SchemaManagerTest, SQLManagedConnection, SQLAdapter, SQLSchemaManager

What am I working on before the next stand up?

  • Obtaining a SQLite database lock in SQLite junit suite

What is blocking me?

  • Converting XADatasource dependency to Datasource

What am I blocking (or about to block)?

  • Story 1 completion

Grace
What have I worked on since the last stand up?

  • Gave Carl code walk through
  • Worked with Carl with initial code for User Story 1

What am I working on before the next stand up?

  • Find out what direction to take since SQLite JDBC driver does not have XADatasource

What is blocking me?

  • Waiting for email from framework architects

What am I blocking (or about to block)?

  • User story 1,2,3

Monday
Carlin
What have I worked on since the last stand up?

  • N/A

What am I working on before the next stand up?

  • Getting the framework to load and run an SQLite adapter

What is blocking me?

  • XAdatasource knowledge within the framework and sqlite

What am I blocking (or about to block)?

  • N/A

Grace
What have I worked on since the last stand up?

  • N/A

What am I working on before the next stand up?

  • Give Carl a code walk through
  • Search for a suitable JDBC driver
  • Investigate if features of Android's SQLite package can be useful

What is blocking me?

  • nothing

What am I blocking (or about to block)?

  • nothing