Open main menu

CDOT Wiki β

Changes

SQLite Adapter StandUp Reports

8,375 bytes added, 22:48, 26 January 2014
no edit summary
{{Admon/obsolete}}
 
[[category: NexJ Express SQLite]]
=Overview=
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 615: Oct 31Apr 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: Apr 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|* Case Insensitivity Waiting on response as to whether it is fine to run SQLite in SQLiteSchemaManagera transactionless way.|-|What am I blocking (or about to block)?|n/a|* Ticket Code review of commits last week1* Framework review of adapter integration|}
What am I working on before the next stand up?==Monday==* Helping Grace with Sprint {| border="1 completion What is blocking me?" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"* n/a |-!What am I blocking (or about to block)?! Carlin* Sprint 1 completion! Grace|-===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
|* Testing with Studio Express* Fixing bug when multiple threads try to write to the database file|-|What am I blocking (or about to block)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 513: Oct 24Apr 2=
==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
{| 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?
*Still Implementing PseudoXA for SQLite
{| 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* Adapter patch review*Testing the adapter with StudioExpress|-|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?* |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?|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)?*completion of sprint 1|n/a|n/a|}
=Week 411: Oct 17Mar 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 specific view implementationopen 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 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?* Completing SQLite views* Analyzing XADatasource commits|* Testing within studioFixing testNew
|* Running unit tests|-|What is blocking me?* Midterms|n/a|n/a|-|What am I blocking (or about to block)?|n/a|n/a|}
What am I blocking (or about to block)?* Sprint 1 completion=Week 10: Mar 12===Thursday=={| border=Grace"1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"What have I worked on since the last stand up?*Implementing PseudoXA for SQLite|-!What am I working on before the next stand up?! Carlin*Testing the adapter with Studio! Grace|-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 concatenationInvestigated failing test, testQueryTimeout** implement analyze tableAttempted a fix** generate UUID|** get current timeFixed bug where BLOB values were not being correctly set on prepared statements** print to output** general code cleanupFixed 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* Implemeting a method in the SQLiteSQLSchemaManager Failing test, testNew|*Rebasing adapter code to append to the buffer SQLite specific literal representationlatest core|-|What is blocking me?* |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?|* 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?* 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 39: Oct 10 Mar 5=<!--
==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?|-* Added full text search index support in SQLite schema manager!* Fixed truncate table! Carlin* SQLite adapter software design document! Grace! AbhishekWhat 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|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|n/a|n/a===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{| 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?|* Extension loading, SQLiteDataSourceWrapper* SQLiteDataSourceWrapper workflow*NTeam issues on BitBucket|n/Aa|-|What am I working on before the next stand up?|* Give Carl a code walk throughRecompiling SQLite JDBC 3.7.10* Search for a suitable JDBC driverSQLite Adapter Software Design Document|* Investigate if features Allow loading of [http:user defined SQLite extensions|-|What is blocking me?|n/a|n/developer.android.coma|-|What am I blocking (or about to block)?|n/referencea|n/android/database/sqlite/SQLiteDatabase.html Android's SQLite package] can be usefula|}
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===Grace===|n/aWhat 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)?* ===Grace===|n/aWhat have I worked on since the last stand up?|n/a*|}
What am I working on before the next stand up?
*
What is blocking me?=Archive=What am I blocking (or about to block)?*-->[http://zenit.senecac.on.ca/wiki/index.php/SQLite_Adapter_StandUp_Reports_2011 2011 Reports]