Changes

Jump to: navigation, search

SQLite Adapter StandUp Reports

11,228 bytes added, 22:48, 26 January 2014
no edit summary
{{Admon/obsolete}}
 
[[category: NexJ Express SQLite]]
Stand up reports will be posted each Monday and Thursday by 12pm.
<!--{| 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?|||-|What am I working on before the next stand up?|||-|What is blocking me?|n/a|n/a|-|What am I blocking (or about to block)?|n/a|n/a|}-->=Week 15: Apr 16===Monday=={| 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?|* 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: Oct 17Apr 9=
==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?|*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=={| 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|* 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|}
What is blocking me?=Week 13: Apr 2=*==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?|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=Grace===What have I worked on since the last stand up?*n/a
{| 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|* Software Design Documentation* Adapter patch review|-|What am I working on before the next stand up?|n/a|* Software Design Documentation*Implementing PseudoXA for SQLiteAdapter 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=={| 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?|* 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?*Update of the external repo with PseduoXA* classes.|n/a|n/a|-|What am I blocking (or about to block)?*Completion of sprint 1|n/a|n/a|}
==Monday==
{| 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|* 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=={| 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?|* 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=={| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"|-!! Carlin! Grace|-|What is blocking mehave 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=Grace={| 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=={| 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?|* 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 is blocking me?* What am I blocking (or about to block)?*  =Week 39: Oct 10 Mar 5=<!--
==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?* 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|n/a|n/a|n/a*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|n/a*Fixed creation of primary keys with autoincrement|n/a|n/aWhat 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->
==Monday==
N{| 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 a|n/a|n/a|-- public holiday|What am I blocking (or about to block)?|n/a|n/a|n/a|}
=Week 28: Oct 3Feb 27=
==Thursday==
{| border="1" cellpadding="4" cellspacing=Carlin=="2" style="border: 1px solid black;border-collapse:collapse;"|-What have I worked on since the last stand up?!* appendColumnType && Suffix! Carlin* methods required by the sqliteSchemaManagerTest! Grace* sqlite software design document! Abhishek|-|What am have I working worked on before since the next last stand up?* continue advancing on required methods for sqliteSchemaManagerTest* researching indexing within sqlite|* createIndex methods in schemaManager What is blocking me?* n/aInvestigating an unsatisfied link error What am I blocking (or about to block)?|* unit test setup ===Abhishek===What have I worked Built SQLite library on since the last stand up?* Researched and experimented Linux with sqlite to gain a better understanding of it.ICU statically linked* Started working on user story 3.extension to enhance locale support in SQLite||-|What am I working on before the next stand up?|* Completing user story 3Solving said error What is blocking me?|* nobody What am I blocking (or about Extension to block)?* I am creating test input data for some of the unit tests. I am perhaps blocking anyone/thing interested enhance locale support 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.SQLite* Breaking down Allow user stories into tasks to set locale for database and creating tickets. What am I working on before the next stand up?or column * Breaking down user stories into tasks and creating tickets.||-|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==
{| 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?|* Fixed the source builder|* Worked with Grace Extension to get story 1 enhance locale support in SQLite||-|What am I workingon 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 am I working on before the next stand up?* changing the location of sqlite db* starting database schema scripts=Week 7: Feb 20=
== 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?|*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?* framework knowledge, graces direction|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 ==* nN/aA
=Week 6: Feb 13==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).
==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?|* 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* Assigning work Alter driver pom.xml / makefile to Carl that is not related to XA's.our use prebuild binaries|* Follow up Building SQLite with Greg ICU statically linked on architectural design of the driver.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=={| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"|-!! Carlin! Grace! Abhishek|-|What is blocking mehave I worked on since the last stand up?|
* n/a
|* Buidling SQLite with ICU enabled||-|What am I blocking (or about to block)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 15: Sept 26Feb 6=
==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?|* Nexj SQlite extension, binary functions* C code clean up|* Fixed bug related to connecting to the same data source concurrently* Modified rank extension* creating Added error handling to extensions* Building SQLite: dataSourceWrapper, AdapterTest, SchemaManagerTest, SQLManagedConnection, SQLAdapter, SQLSchemaManagerwith 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=={| 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* Obtaining a Asking the Community about our multiple attach issue|* Investigate UNICODE support in SQLite database lock in * Research on SQLite junit suitemulti-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=={| 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?* Converting XADatasource dependency |n/a|n/a|n/a|-|What am I blocking (or about to Datasourceblock)?|n/a|n/a|n/a|}
What am I blocking (or about to block)?
* Story 1 completion
==Monday=Grace={| 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?|* Gave Carl Reviewed code walk through* Worked driver make file|* Tested SQLiteAdapter with Carl Teee* Passing the testRead unit test* Research on SQLite multi-threading* Research on nmake for building SQLite components with initial code visual studio tools||-|What am I working on before the next stand up?|* Driver make file* Source make file* Rebuilding the sqlite library for User Story 1multi-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||}
What am I working on before the next stand up?
* Find out what direction to take since SQLite JDBC driver does not have XADatasource
=Week 3: Jan 23===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?|* 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?* Waiting for email from framework architects|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)?
* User story 1,2,3
==Monday==
{| 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* NGetting 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/Aa|}
What am I working on before the next stand up?
* Getting the framework to load and run an SQLite adapter
=Week 2: Jan 16===Thursday=={| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"|-!! Carlin! Grace|-|What is blocking mehave 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?|* XAdatasource knowledge within Completely integrate the framework driver and sqlitesource 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|}
What am I blocking (or about to block)?
* N/A
==Monday=Grace={| 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?|*NExtension loading, SQLiteDataSourceWrapper* SQLiteDataSourceWrapper workflow* Team issues on BitBucket|n/Aa|-|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|}
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 [http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html Android's SQLite package] can be useful
What is blocking me?* nothing What am I blocking (or about to block)?* nothing <!--=Week 1: Sept 26Jan 9=
==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?|* 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|}
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?
*
 
What am I working on before the next stand up?
*
 
What is blocking me?
*
 
What am I blocking (or about to block)?
*
==Monday==
{| 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| 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===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)?=Archive=*-->[http://zenit.senecac.on.ca/wiki/index.php/SQLite_Adapter_StandUp_Reports_2011 2011 Reports]

Navigation menu