SQLite Adapter StandUp Reports 2011

Week 9: Nov 21

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

• Discussion about upgrade step issues
• Review Grace's numerous commits

What am I working on before the next stand up?

• Finalizing upgrade step process
• Column Meta Data within SQLiteSchemaManager

What is blocking me?

• upgrade step preferred process

What am I blocking (or about to block)?

• upgrade step in Sprint 2

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

• AppendTypeConversion

What am I working on before the next stand up?

• ticket review

What is blocking me?

• n/a

What am I blocking (or about to block)?

• upgrade step

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