SQLite Adapter StandUp Reports

Overview

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

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