Difference between revisions of "SQLite Adapter StandUp Reports"

From CDOT Wiki
Jump to: navigation, search
 
(66 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
{{Admon/obsolete}}
 +
 
[[category: NexJ Express SQLite]]
 
[[category: NexJ Express SQLite]]
  
Line 5: Line 7:
  
 
<!--
 
<!--
=Week 1: Sept 26=
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
==Thursday==
+
|-
===Carlin===
+
!
What have I worked on since the last stand up?
+
! Carlin
*
+
! Grace
 
+
|-
What am I working on before the next stand up?
+
|What have I worked on since the last stand up?
*
+
|
 
+
|
What is blocking me?
+
|-
*
+
|What am I working on before the next stand up?
 
+
|
What am I blocking (or about to block)?
+
|
*
+
|-
 
+
|What is blocking me?
===Grace===
+
|n/a
What have I worked on since the last stand up?
+
|n/a
*
+
|-
 
+
|What am I blocking (or about to block)?
What am I working on before the next stand up?
+
|n/a
*
+
|n/a
 
+
|}
What is blocking me?
+
-->
*
+
=Week 15: Apr 16=
 
 
What am I blocking (or about to block)?
 
*
 
 
 
 
==Monday==
 
==Monday==
===Carlin===
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
What have I worked on since the last stand up?
+
|-
*
+
!
 
+
! Carlin
What am I working on before the next stand up?
+
! Grace
*
+
|-
 
+
|What have I worked on since the last stand up?
What is blocking me?
+
|
*
+
* Renaming tickets
 
+
|
What am I blocking (or about to block)?
+
|-
*
+
|What am I working on before the next stand up?
 
+
|
===Grace===
+
* Documentation, and makefile cleanup
What have I worked on since the last stand up?
+
|
*
+
|-
 
+
|What is blocking me?
What am I working on before the next stand up?
+
|n/a
*
+
|n/a
 
+
|-
What is blocking me?
+
|What am I blocking (or about to block)?
*
+
|n/a
 
+
|n/a
What am I blocking (or about to block)?
+
|}
*
+
=Week 14: Apr 9=
-->
 
=Week 7: Nov 8=
 
<--
 
 
==Thursday==
 
==Thursday==
===Carlin===
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
What have I worked on since the last stand up?
+
|-
*
+
!
 
+
! Carlin
What am I working on before the next stand up?
+
! Grace
*
+
|-
 
+
|What have I worked on since the last stand up?
What is blocking me?
+
|
*
+
* Design of multiple thread solution
 
+
|
What am I blocking (or about to block)?
+
* Testing with Studio Express
*
+
* Fixing bug when multiple threads try to write to the database file
 +
* Updated NexJ about progress on project
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* remaining tickets
 +
|
 +
* n/a
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|
 +
* Waiting on response as to whether it is fine to run SQLite in a transactionless way.
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|
 +
* Code review 1
 +
|}
  
===Grace===
 
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)?
 
*
 
-->
 
 
==Monday==
 
==Monday==
===Carlin===
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
What have I worked on since the last stand up?
+
|-
* Append Literal peer review
+
!
 
+
! Carlin
What am I working on before the next stand up?
+
! Grace
* SQLAdapter ticket peer review
+
|-
 
+
|What have I worked on since the last stand up?
What is blocking me?
+
|
 
* n/a
 
* n/a
 
+
|
What am I blocking (or about to block)?
+
* Testing with Studio Express
 +
* Fixing bug when multiple threads try to write to the database file
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 
* n/a
 
* n/a
 +
|
 +
* Testing with Studio Express
 +
* Patch review
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|}
  
===Grace===
+
=Week 13: Apr 2=
What have I worked on since the last stand up?
+
==Thursday==
* Fixed Debugging in studio
 
* SQLiteAdapter Drop Column
 
  
What am I working on before the next stand up?
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
* Creating SQL scripts
+
|-
* Full Text Search Support
+
!
 +
! Carlin
 +
! Grace
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
n/a
 +
|
 +
* Software Design Documentation
 +
* Adapter patch review
 +
* Testing with Studio Express
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* Software Design Documentation
 +
* Testing with Studio Express
 +
|
 +
* Testing with Studio Express
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|}
  
What is blocking me?
+
==Monday==
* n/a
 
  
What am I blocking (or about to block)?
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
* n/a
+
|-
 +
!
 +
! Carlin
 +
! Grace
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
n/a
 +
|
 +
* Software Design Documentation
 +
* Adapter patch review
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
n/a
 +
|
 +
* Software Design Documentation
 +
* Adapter patch review
 +
* Testing with Studio Express
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|}
  
=Week 6: Oct 31=
+
=Week 12: Mar 26=
 
==Thursday==
 
==Thursday==
===Carlin===
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
What have I worked on since the last stand up?
+
|-
* Review and wrap up of sprint 1 patch
+
!
 
+
! Carlin
What am I working on before the next stand up?
+
! Grace
* Peer review colleagues commits
+
|-
 
+
|What have I worked on since the last stand up?
What is blocking me?
+
|
* n/a
+
* Fixed SQLite open behaviour when a database does not exist
 
+
* Reviewed adapter patch
What am I blocking (or about to block)?
+
* Code styling
* n/a
+
* Software design document
 
+
|
===Grace===
+
* Reviewed locale work
What have I worked on since the last stand up?
+
* Reviewed open behaviour work
* Assigning Tickets
+
* Software design document
* Peer reviewing tickets
+
|-
 
+
|What am I working on before the next stand up?
What am I working on before the next stand up?
+
|
* Fixing running of unit tests.
+
* Documentation
 
+
* Adapter patch review
What is blocking me?
+
|
*
+
* Software Design Documentation
 
+
* Adapter patch review
What am I blocking (or about to block)?
+
|-
*
+
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|}
  
 
==Monday==
 
==Monday==
===Carlin===
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
What have I worked on since the last stand up?
+
|-
* Case Insensitivity in SQLiteSchemaManager
+
!
* Ticket review of commits last week
+
! Carlin
* Framework review of adapter integration
+
! Grace
 
+
|-
What am I working on before the next stand up?
+
|What have I worked on since the last stand up?
* Helping Grace with Sprint 1 completion
+
|
 
+
n/a
What is blocking me?
+
|
* n/a  
+
* Added custom build step to generate nexj_sqlite file in visual studio projects
 
+
* Added content to software design document
What am I blocking (or about to block)?
+
* Added keywords to adapter
* Sprint 1 completion
+
* Fixed creation of views
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* Code cleanup
 +
* SQLite open behaviour
 +
|
 +
* Testing adapter with studio
 +
* Finishing up software design document
 +
* Reviewing adapter patch
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|}
  
===Grace===
+
=Week 11: Mar 19=
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==
 
==Thursday==
===Grace===
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
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
+
! Carlin
 +
! Grace
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
* Fixed testNew, the setup scripts were wrong
 +
* Fixed testRanges, a bug with incrementing primary keys
 +
|
 +
* Reviewed locale code
 +
* Running Unit tests on upgraded core
 +
* Code cleanup
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* Code cleanup
 +
* SQLite open behaviour
 +
|
 
*Testing adapter with studio
 
*Testing adapter with studio
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|Code review
 +
|}
  
What am I working on before the next stand up?
+
==Monday==
*Reviewing code for sprint 1
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 +
|-
 +
!
 +
! Carlin
 +
! Grace
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
n/a
 +
|
 +
* Rebased adapter code to latest core
 +
* Implementing locale in SQLite
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* Fixing testNew
  
What is blocking me?
+
|
* n/a
+
* Running unit tests
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|}
  
What am I blocking (or about to block)?
+
=Week 10: Mar 12=
*
+
==Thursday==
 +
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 +
|-
 +
!
 +
! Carlin
 +
! Grace
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
* Investigated failing test, testQueryTimeout
 +
* Attempted a fix
 +
|
 +
* Fixed bug where BLOB values were not being correctly set on prepared statements
 +
* Fixed bug that was causing a column meta data mismatch when reading a schema from a database
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* Failing test, testQueryTimeout
 +
* Failing test, testNew
 +
|
 +
*Rebasing adapter code to latest core
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|}
  
 
==Monday==
 
==Monday==
===Grace===
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
What have I worked on since the last stand up?
+
|-
*Still Implementing PseudoXA for SQLite
+
!
 +
! Carlin
 +
! Grace
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
* Got windows build command for project makefile
 +
* Fixed and issued with the sqltie shell project not compiling
 +
|
 +
* Testing with new JDBC driver build
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* Investigating failing tests
 +
|
 +
* Fix reading of column meta data when reading a database schema
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|}
  
What am I working on before the next stand up?
+
=Week 9: Mar 5=
*Testing the adapter with Studio
+
<!--
 +
==Thursday==
 +
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 +
|-
 +
!
 +
! Carlin
 +
! Grace
 +
! Abhishek
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
|
 +
|
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
|
 +
|
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|}
 +
-->
  
What is blocking me?
+
==Monday==
* n/a
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 +
|-
 +
!
 +
! Carlin
 +
! Grace
 +
! Abhishek
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
* Solved link error
 +
* added more code generation for nativedb.c & .h & .class
 +
|
 +
* Extension to enhance locale support in SQLite
 +
|
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* getting the windows binaries in a working state
 +
|
 +
* Extension to enhance locale support in SQLite
 +
* Allow user to set locale for database and or column
 +
|
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|}
  
What am I blocking (or about to block)?
+
=Week 8: Feb 27=
*completion of sprint 1
 
 
 
=Week 4: Oct 17=
 
 
==Thursday==
 
==Thursday==
===Carlin===
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
What have I worked on since the last stand up?
+
|-
* SQLite specific view implementation
+
!
 +
! Carlin
 +
! Grace
 +
! Abhishek
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
* Investigating an unsatisfied link error
 +
|
 +
* Built SQLite library on Linux with ICU statically linked
 +
* Started on extension to enhance locale support in SQLite
 +
|
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* Solving said error
 +
|
 +
* Extension to enhance locale support in SQLite
 +
* Allow user to set locale for database and or column
 +
|
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|}
  
What am I working on before the next stand up?
+
==Monday==
* Completing SQLite views
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
* Analyzing XADatasource commits
+
|-
* Testing within studio
+
!
 +
! Carlin
 +
! Grace
 +
! Abhishek
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
* Fixed the source builder
 +
|
 +
* Extension to enhance locale support in SQLite
 +
|
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* Improving the build system
 +
|
 +
*Allow user to set locale for database and or column
 +
|
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|}
  
What is blocking me?
+
=Week 7: Feb 20=
* Midterms
 
  
What am I blocking (or about to block)?
+
== Thursday==
* Sprint 1 completion
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 +
|-
 +
!
 +
! Carlin
 +
! Grace
 +
! Abhishek
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
*Implemented sqlite_nexj.c source building in the make file
 +
*Removed the xerial source, altering our make file
 +
|
 +
*Fixed building of SQLite libraries on Windows
 +
|
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
*Improving the build system
 +
|
 +
*Allow user to set locale for database and or column
 +
|
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|}
  
===Grace===
+
== Monday ==
What have I worked on since the last stand up?
+
N/A
*Implementing PseudoXA for SQLite
 
  
What am I working on before the next stand up?
+
=Week 6: Feb 13=
*Testing the adapter with Studio
 
  
What is blocking me?
+
==Thursday==
* n/a
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 
+
|-
What am I blocking (or about to block)?
+
!
*completion of sprint 1
+
! Carlin
 
+
! Grace
===Abhishek===
+
! Abhishek
What have I worked on since the last stand up?
+
|-
* Updating and adding the following components to SQLiteSQLSchemaManager:
+
|What have I worked on since the last stand up?
** implement string concatenation
+
|
** implement analyze table
+
* Extension selection logic
** generate UUID
+
* Project planning
** get current time
+
|
** print to output
+
* Buidling SQLite with ICU enabled
** general code cleanup
+
|
 
+
|-
What am I working on before the next stand up?
+
|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
+
|
 +
* Confirm linux behaviour of system properties
 +
* Alter driver pom.xml / makefile to our use prebuild binaries
 +
|
 +
*Building SQLite with ICU statically linked on Windows
 +
*Allow user to set locale for database and or column
 +
|
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|}
  
What is blocking me?
+
==Monady==
 +
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 +
|-
 +
!
 +
! Carlin
 +
! Grace
 +
! Abhishek
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 
* n/a
 
* n/a
 
+
|
What am I blocking (or about to block)?
+
* Buidling SQLite with ICU enabled
* completion of sprint 1
+
|
 
+
|-
==Monday==
+
|What am I working on before the next stand up?
===Carlin===
+
|
What have I worked on since the last stand up?
 
 
* n/a
 
* n/a
 +
|
 +
* Building SQLite with ICU enabled
 +
|
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|}
  
What am I working on before the next stand up?
+
=Week 5: Feb 6=
* SQLiteSchemaManager timestamp handling
 
* SQLite project software design document
 
  
What is blocking me?
+
==Thursday==
* n/a
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 +
|-
 +
!
 +
! Carlin
 +
! Grace
 +
! Abhishek
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
* Nexj SQlite extension, binary functions
 +
* C code clean up
 +
|
 +
* Fixed bug related to connecting to the same data source concurrently
 +
* Modified rank extension
 +
* Added error handling to extensions
 +
* Building SQLite with ICU enabled
 +
* Implemented appendMatchExpression
 +
|
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* Cleaning up the wiki
 +
* Unicode extension library for sqlite
 +
* Logic to determine which binary to load
 +
|
 +
* Building SQLite with ICU enabled
 +
|
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|}
  
What am I blocking (or about to block)?
+
==Monday==
* Sprint 1 completion
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 +
|-
 +
!
 +
! Carlin
 +
! Grace
 +
! Abhishek
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
* Nexj sqlite extension, and the binary() conversion function
 +
|
 +
* Updated software design document
 +
|
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* Proper error handling in the binary() extension
 +
* Unicode library extension for sqlite
 +
* Updating wiki with project milestones
 +
* Asking the Community about our multiple attach issue
 +
|
 +
* Investigate UNICODE support in SQLite
 +
* Research on SQLite multi-threading
 +
|
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|}
  
===Grace===
+
=Week 4: Jan 30=
What have I worked on since the last stand up?
+
==Thursday==
*n/a
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 +
|-
 +
!
 +
! Carlin
 +
! Grace
 +
! Abhishek
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
* Implementing toBinary sqlite c function
 +
* Review debugging with Teee in studio
 +
|
 +
* Gave Carlin tutorial on debugging with Teee
 +
|
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* OS architecture and platform extension loading
 +
* Prepping for NexJ meeting
 +
* completing and compiling NexJFunctions extension
 +
|
 +
* Investigate UNICODE support in SQLite
 +
* Research on SQLite multi-threading
 +
|
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|}
  
What am I working on before the next stand up?
 
*Implementing PseudoXA for SQLite
 
  
What is blocking me?
+
==Monday==
*Update of the external repo with PseduoXA* classes.
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 
+
|-
What am I blocking (or about to block)?
+
!
*Completion of sprint 1
+
! Carlin
 +
! Grace
 +
! Abhishek
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
* Reviewed code
 +
* driver make file
 +
|
 +
* Tested SQLiteAdapter with Teee
 +
* Passing the testRead unit test
 +
* Research on SQLite multi-threading
 +
* Research on nmake for building SQLite components with visual studio tools
 +
|
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* Driver make file
 +
* Source make file
 +
* Rebuilding the sqlite library for multi-thread mode
 +
|
 +
* Research on SQLite multi-threading
 +
|
 +
|-
 +
|What is blocking me?
 +
|
 +
n/a
 +
|
 +
n/a
 +
|
 +
|-
 +
|What am I blocking (or about to block)?
 +
|
 +
n/a
 +
|
 +
n/a
 +
|
 +
|}
  
===Abhishek===
 
sick (n/a)
 
  
=Week 3: Oct 10 =
+
=Week 3: Jan 23=
 
==Thursday==
 
==Thursday==
===Carlin===
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
What have I worked on since the last stand up?
+
|-
* Added full text search index support in SQLite schema manager
+
!
* Fixed truncate table
+
! Carlin
* SQLite adapter software design document
+
! Grace
 +
! Abhishek
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
* Code clean up
 +
* Exploring attach database issue
 +
|
 +
* Fixed binding of Decimal values
 +
* Added support for missing type conversions cases
 +
* Repository maintenance
 +
|
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* driver make file
 +
* sqlite source make file
 +
* Investigating failing adapter tests
 +
|
 +
* Allow loading of user defined SQLite extensions
 +
|
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|}
  
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==
 
==Monday==
N/A -- public holiday
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
 +
|-
 +
!
 +
! Carlin
 +
! Grace
 +
! Abhishek
 +
|-
 +
|What have I worked on since the last stand up?
 +
|
 +
* Driver make file
 +
|
 +
* Refactoring SQLiteDataSourceWrapper
 +
* Getting the adapter to load an external datasource
 +
|
 +
* Converting SQLite Rank DLL to VS project
 +
* Working on appendMatchStatement in SQLite Adapter
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* Driver make file
 +
* SQLite adapter software design document
 +
|
 +
* Allow loading of user defined SQLite extensions
 +
|
 +
* Finishing up appendMatchStatement in SQLite Adapter
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|n/a
 +
|}
  
  
=Week 2: Oct 3=
+
=Week 2: Jan 16=
 
==Thursday==
 
==Thursday==
===Carlin===
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
What have I worked on since the last stand up?
+
|-
* appendColumnType && Suffix
+
!
* methods required by the sqliteSchemaManagerTest
+
! Carlin
* sqlite software design document
+
! Grace
 
+
|-
What am I working on before the next stand up?
+
|What have I worked on since the last stand up?
* continue advancing on required methods for sqliteSchemaManagerTest
+
|
* researching indexing within sqlite
+
* Modifying our sqlite jdbc
* createIndex methods in schemaManager
+
* Including the driver inside the project
 
+
|
What is blocking me?
+
* Delegating tasks
* n/a
+
* Adding constraint names to error message for constraint violations
 
+
|-
What am I blocking (or about to block)?
+
|What am I working on before the next stand up?
* unit test setup
+
|
 
+
* Completely integrate the driver and sqlite source into the project
===Abhishek===
+
* Software design document
What have I worked on since the last stand up?
+
|
* Researched and experimented with sqlite to gain a better understanding of it.
+
* Allow loading of user defined SQLite extensions
* Started working on user story 3.
+
|-
 
+
|What is blocking me?
What am I working on before the next stand up?
+
|n/a
* Completing user story 3
+
|n/a
 
+
|-
What is blocking me?
+
|What am I blocking (or about to block)?
* nobody
+
|n/a
 
+
|n/a
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==
 
==Monday==
===Carlin===
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
What have I worked on since the last stand up?
+
|-
* Worked with Grace to get story 1 working
+
!
 
+
! Carlin
What am I working on before the next stand up?
+
! Grace
* changing the location of sqlite db
+
|-
* starting database schema scripts
+
|What have I worked on since the last stand up?
 
+
|
What is blocking me?
+
* Extension loading, SQLiteDataSourceWrapper
* framework knowledge, graces direction
+
* SQLiteDataSourceWrapper workflow
 
+
* Team issues on BitBucket
What am I blocking (or about to block)?
+
|
* n/a
+
n/a
 
+
|-
===Grace===
+
|What am I working on before the next 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).
+
* Recompiling SQLite JDBC 3.7.10
 
+
* SQLite Adapter Software Design Document
What am I working on before the next stand up?
+
|
* Assigning work to Carl that is not related to XA's.
+
* Allow loading of user defined SQLite extensions
* Follow up with Greg on architectural design of the driver.
+
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|}
  
What is blocking me?
 
* n/a
 
 
What am I blocking (or about to block)?
 
* n/a
 
 
 
=Week 1: Sept 26=
 
  
 +
=Week 1: Jan 9=
 
==Thursday==
 
==Thursday==
===Carlin===
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
What have I worked on since the last stand up?
+
|-
* creating SQLite: dataSourceWrapper, AdapterTest, SchemaManagerTest, SQLManagedConnection, SQLAdapter, SQLSchemaManager
+
!
 
+
! Carlin
What am I working on before the next stand up?
+
! Grace
* Obtaining a SQLite database lock in SQLite junit suite
+
|-
 
+
|What have I worked on since the last stand up?
What is blocking me?
+
|
* Converting XADatasource dependency to Datasource
+
* Identified the JDBC's ''Function'' limits
 
+
* Demo of extension loading
What am I blocking (or about to block)?
+
|
* Story 1 completion
+
* Researched on adding functionality to SQLite
 +
* Discussed design for adding functionality with NexJ
 +
|-
 +
|What am I working on before the next stand up?
 +
|
 +
* SQLite Adapter software design document
 +
|
 +
* Allow loading of user defined SQLite extensions
 +
|-
 +
|What is blocking me?
 +
|n/a
 +
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|}
  
===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==
 
==Monday==
===Carlin===
+
{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"
What have I worked on since the last stand up?
+
|-
* N/A
+
!
 
+
! Carlin
What am I working on before the next stand up?
+
! Grace
* Getting the framework to load and run an SQLite adapter
+
|-
 
+
|What have I worked on since the last stand up?
What is blocking me?
+
| n/a
* XAdatasource knowledge within the framework and sqlite
+
| n/a
 
+
|-
What am I blocking (or about to block)?
+
|What am I working on before the next stand up?
* N/A
+
|
 
+
* Research on adding functionality to SQLite
===Grace===
+
* Discuss design for adding functionality with NexJ
What have I worked on since the last stand up?
+
|
*N/A
+
* Research on adding functionality to SQLite
 
+
* Discuss design for adding functionality with NexJ
What am I working on before the next stand up?
+
|-
* Give Carl a code walk through
+
|What is blocking me?
* Search for a suitable JDBC driver
+
|n/a
* Investigate if features of [http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html Android's SQLite package] can be useful
+
|n/a
 +
|-
 +
|What am I blocking (or about to block)?
 +
|n/a
 +
|n/a
 +
|}
  
What is blocking me?
 
* nothing
 
  
What am I blocking (or about to block)?
+
=Archive=
* nothing
+
* [http://zenit.senecac.on.ca/wiki/index.php/SQLite_Adapter_StandUp_Reports_2011 2011 Reports]

Latest revision as of 21:48, 26 January 2014

Important.png
This page may be obsolete.
It contains historical information.

Overview

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

Week 15: Apr 16

Monday

Carlin Grace
What have I worked on since the last stand up?
  • Renaming tickets
What am I working on before the next stand up?
  • Documentation, and makefile cleanup
What is blocking me? n/a n/a
What am I blocking (or about to block)? n/a n/a

Week 14: Apr 9

Thursday

Carlin Grace
What have I worked on since the last stand up?
  • Design of multiple thread solution
  • Testing with Studio Express
  • Fixing bug when multiple threads try to write to the database file
  • Updated NexJ about progress on project
What am I working on before the next stand up?
  • remaining tickets
  • n/a
What is blocking me? n/a
  • Waiting on response as to whether it is fine to run SQLite in a transactionless way.
What am I blocking (or about to block)? n/a
  • Code review 1

Monday

Carlin Grace
What have I worked on since the last stand up?
  • n/a
  • Testing with Studio Express
  • Fixing bug when multiple threads try to write to the database file
What am I working on before the next stand up?
  • n/a
  • Testing with Studio Express
  • Patch review
What is blocking me? n/a n/a
What am I blocking (or about to block)? n/a n/a

Week 13: Apr 2

Thursday

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

n/a

  • Software Design Documentation
  • Adapter patch review
  • Testing with Studio Express
What am I working on before the next stand up?
  • Software Design Documentation
  • Testing with Studio Express
  • Testing with Studio Express
What is blocking me? n/a n/a
What am I blocking (or about to block)? n/a n/a

Monday

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

n/a

  • Software Design Documentation
  • Adapter patch review
What am I working on before the next stand up?

n/a

  • Software Design Documentation
  • Adapter patch review
  • Testing with Studio Express
What is blocking me? n/a n/a
What am I blocking (or about to block)? n/a n/a

Week 12: Mar 26

Thursday

Carlin Grace
What have I worked on since the last stand up?
  • Fixed SQLite open behaviour when a database does not exist
  • Reviewed adapter patch
  • Code styling
  • Software design document
  • Reviewed locale work
  • Reviewed open behaviour work
  • Software design document
What am I working on before the next stand up?
  • Documentation
  • Adapter patch review
  • Software Design Documentation
  • Adapter patch review
What is blocking me? n/a n/a
What am I blocking (or about to block)? n/a n/a

Monday

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

n/a

  • Added custom build step to generate nexj_sqlite file in visual studio projects
  • Added content to software design document
  • Added keywords to adapter
  • Fixed creation of views
What am I working on before the next stand up?
  • Code cleanup
  • SQLite open behaviour
  • Testing adapter with studio
  • Finishing up software design document
  • Reviewing adapter patch
What is blocking me? n/a n/a
What am I blocking (or about to block)? n/a n/a

Week 11: Mar 19

Thursday

Carlin Grace
What have I worked on since the last stand up?
  • Fixed testNew, the setup scripts were wrong
  • Fixed testRanges, a bug with incrementing primary keys
  • Reviewed locale code
  • Running Unit tests on upgraded core
  • Code cleanup
What am I working on before the next stand up?
  • Code cleanup
  • SQLite open behaviour
  • Testing adapter with studio
What is blocking me? n/a n/a
What am I blocking (or about to block)? n/a Code review

Monday

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

n/a

  • Rebased adapter code to latest core
  • Implementing locale in SQLite
What am I working on before the next stand up?
  • Fixing testNew
  • Running unit tests
What is blocking me? n/a n/a
What am I blocking (or about to block)? n/a n/a

Week 10: Mar 12

Thursday

Carlin Grace
What have I worked on since the last stand up?
  • Investigated failing test, testQueryTimeout
  • Attempted a fix
  • Fixed bug where BLOB values were not being correctly set on prepared statements
  • Fixed bug that was causing a column meta data mismatch when reading a schema from a database
What am I working on before the next stand up?
  • Failing test, testQueryTimeout
  • Failing test, testNew
  • Rebasing adapter code to latest core
What is blocking me? n/a n/a
What am I blocking (or about to block)? n/a n/a

Monday

Carlin Grace
What have I worked on since the last stand up?
  • Got windows build command for project makefile
  • Fixed and issued with the sqltie shell project not compiling
  • Testing with new JDBC driver build
What am I working on before the next stand up?
  • Investigating failing tests
  • Fix reading of column meta data when reading a database schema
What is blocking me? n/a n/a
What am I blocking (or about to block)? n/a n/a

Week 9: Mar 5

Monday

Carlin Grace Abhishek
What have I worked on since the last stand up?
  • Solved link error
  • added more code generation for nativedb.c & .h & .class
  • Extension to enhance locale support in SQLite
What am I working on before the next stand up?
  • getting the windows binaries in a working state
  • Extension to enhance locale support in SQLite
  • Allow user to set locale for database and or column
What is blocking me? n/a n/a n/a
What am I blocking (or about to block)? n/a n/a n/a

Week 8: Feb 27

Thursday

Carlin Grace Abhishek
What have I worked on since the last stand up?
  • Investigating an unsatisfied link error
  • Built SQLite library on Linux with ICU statically linked
  • Started on extension to enhance locale support in SQLite
What am I working on before the next stand up?
  • Solving said error
  • Extension to enhance locale support in SQLite
  • Allow user to set locale for database and or column
What is blocking me? n/a n/a n/a
What am I blocking (or about to block)? n/a n/a n/a

Monday

Carlin Grace Abhishek
What have I worked on since the last stand up?
  • Fixed the source builder
  • Extension to enhance locale support in SQLite
What am I working on before the next stand up?
  • Improving the build system
  • Allow user to set locale for database and or column
What is blocking me? n/a n/a n/a
What am I blocking (or about to block)? n/a n/a n/a

Week 7: Feb 20

Thursday

Carlin Grace Abhishek
What have I worked on since the last stand up?
  • Implemented sqlite_nexj.c source building in the make file
  • Removed the xerial source, altering our make file
  • Fixed building of SQLite libraries on Windows
What am I working on before the next stand up?
  • Improving the build system
  • Allow user to set locale for database and or column
What is blocking me? n/a n/a n/a
What am I blocking (or about to block)? n/a n/a n/a

Monday

N/A

Week 6: Feb 13

Thursday

Carlin Grace Abhishek
What have I worked on since the last stand up?
  • Extension selection logic
  • Project planning
  • Buidling SQLite with ICU enabled
What am I working on before the next stand up?
  • Confirm linux behaviour of system properties
  • Alter driver pom.xml / makefile to our use prebuild binaries
  • Building SQLite with ICU statically linked on Windows
  • Allow user to set locale for database and or column
What is blocking me? n/a n/a n/a
What am I blocking (or about to block)? n/a n/a n/a

Monady

Carlin Grace Abhishek
What have I worked on since the last stand up?
  • n/a
  • Buidling SQLite with ICU enabled
What am I working on before the next stand up?
  • n/a
  • Building SQLite with ICU enabled
What is blocking me? n/a n/a n/a
What am I blocking (or about to block)? n/a n/a n/a

Week 5: Feb 6

Thursday

Carlin Grace Abhishek
What have I worked on since the last stand up?
  • Nexj SQlite extension, binary functions
  • C code clean up
  • Fixed bug related to connecting to the same data source concurrently
  • Modified rank extension
  • Added error handling to extensions
  • Building SQLite with ICU enabled
  • Implemented appendMatchExpression
What am I working on before the next stand up?
  • Cleaning up the wiki
  • Unicode extension library for sqlite
  • Logic to determine which binary to load
  • Building SQLite with ICU enabled
What is blocking me? n/a n/a n/a
What am I blocking (or about to block)? n/a n/a n/a

Monday

Carlin Grace Abhishek
What have I worked on since the last stand up?
  • Nexj sqlite extension, and the binary() conversion function
  • Updated software design document
What am I working on before the next stand up?
  • Proper error handling in the binary() extension
  • Unicode library extension for sqlite
  • Updating wiki with project milestones
  • Asking the Community about our multiple attach issue
  • Investigate UNICODE support in SQLite
  • Research on SQLite multi-threading
What is blocking me? n/a n/a n/a
What am I blocking (or about to block)? n/a n/a n/a

Week 4: Jan 30

Thursday

Carlin Grace Abhishek
What have I worked on since the last stand up?
  • Implementing toBinary sqlite c function
  • Review debugging with Teee in studio
  • Gave Carlin tutorial on debugging with Teee
What am I working on before the next stand up?
  • OS architecture and platform extension loading
  • Prepping for NexJ meeting
  • completing and compiling NexJFunctions extension
  • Investigate UNICODE support in SQLite
  • Research on SQLite multi-threading
What is blocking me? n/a n/a n/a
What am I blocking (or about to block)? n/a n/a n/a


Monday

Carlin Grace Abhishek
What have I worked on since the last stand up?
  • Reviewed code
  • driver make file
  • Tested SQLiteAdapter with Teee
  • Passing the testRead unit test
  • Research on SQLite multi-threading
  • Research on nmake for building SQLite components with visual studio tools
What am I working on before the next stand up?
  • Driver make file
  • Source make file
  • Rebuilding the sqlite library for multi-thread mode
  • Research on SQLite multi-threading
What is blocking me?

n/a

n/a

What am I blocking (or about to block)?

n/a

n/a


Week 3: Jan 23

Thursday

Carlin Grace Abhishek
What have I worked on since the last stand up?
  • Code clean up
  • Exploring attach database issue
  • Fixed binding of Decimal values
  • Added support for missing type conversions cases
  • Repository maintenance
What am I working on before the next stand up?
  • driver make file
  • sqlite source make file
  • Investigating failing adapter tests
  • Allow loading of user defined SQLite extensions
What is blocking me? n/a n/a n/a
What am I blocking (or about to block)? n/a n/a n/a


Monday

Carlin Grace Abhishek
What have I worked on since the last stand up?
  • Driver make file
  • Refactoring SQLiteDataSourceWrapper
  • Getting the adapter to load an external datasource
  • Converting SQLite Rank DLL to VS project
  • Working on appendMatchStatement in SQLite Adapter
What am I working on before the next stand up?
  • Driver make file
  • SQLite adapter software design document
  • Allow loading of user defined SQLite extensions
  • Finishing up appendMatchStatement in SQLite Adapter
What is blocking me? n/a n/a n/a
What am I blocking (or about to block)? n/a n/a n/a


Week 2: Jan 16

Thursday

Carlin Grace
What have I worked on since the last stand up?
  • Modifying our sqlite jdbc
  • Including the driver inside the project
  • Delegating tasks
  • Adding constraint names to error message for constraint violations
What am I working on before the next stand up?
  • Completely integrate the driver and sqlite source into the project
  • Software design document
  • Allow loading of user defined SQLite extensions
What is blocking me? n/a n/a
What am I blocking (or about to block)? n/a n/a


Monday

Carlin Grace
What have I worked on since the last stand up?
  • Extension loading, SQLiteDataSourceWrapper
  • SQLiteDataSourceWrapper workflow
  • Team issues on BitBucket

n/a

What am I working on before the next stand up?
  • Recompiling SQLite JDBC 3.7.10
  • SQLite Adapter Software Design Document
  • Allow loading of user defined SQLite extensions
What is blocking me? n/a n/a
What am I blocking (or about to block)? n/a n/a


Week 1: Jan 9

Thursday

Carlin Grace
What have I worked on since the last stand up?
  • Identified the JDBC's Function limits
  • Demo of extension loading
  • Researched on adding functionality to SQLite
  • Discussed design for adding functionality with NexJ
What am I working on before the next stand up?
  • SQLite Adapter software design document
  • Allow loading of user defined SQLite extensions
What is blocking me? n/a n/a
What am I blocking (or about to block)? n/a n/a


Monday

Carlin Grace
What have I worked on since the last stand up? n/a n/a
What am I working on before the next stand up?
  • Research on adding functionality to SQLite
  • Discuss design for adding functionality with NexJ
  • Research on adding functionality to SQLite
  • Discuss design for adding functionality with NexJ
What is blocking me? n/a n/a
What am I blocking (or about to block)? n/a n/a


Archive