Changes

Jump to: navigation, search

SQLite Adapter StandUp Reports

9,383 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 515: Oct 24Apr 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?|*Still Implementing PseudoXA for SQLiteRenaming tickets||-|What am I working on before the next stand up?|*Testing the adapter with StudioDocumentation, and makefile cleanup||-|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 414: Oct 17Apr 9=
==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?|-* SQLite specific view implementation!! CarlinWhat am I working on before the next stand up?! Grace* 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 SQLiteDesign of multiple thread solution What am I working on before the next stand up?|*Testing the adapter with Studio What is blocking me?Express* n/a What am I blocking (or about Fixing bug when multiple threads try to write to block)?the database file*completion of sprint 1 ===Abhishek===What have I worked Updated NexJ about progress 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 cleanupproject|-|What am I working on before the next stand up?|* Implemeting a method in the SQLiteSQLSchemaManager to append to the buffer SQLite specific literal representationremaining ticketsWhat is blocking me?|
* 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|* completion of sprint 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?* SQLiteSchemaManager timestamp handling* SQLite project software design document What is blocking me?|
* 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 am I blocking (or about to block)?=Week 13: Apr 2=* Sprint 1 completion==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|}
What am I working on before the next stand up?*Implementing PseudoXA for SQLite==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|* 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?*Update of the external repo with PseduoXA* classes.|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)?*Completion of sprint 1|n/a|n/a|}
==Monday=Abhishek={| 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?|sick * 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 311: Oct 10 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?|* Added full text search index support in SQLite schema managerFixed testNew, the setup scripts were wrong* Fixed truncate tabletestRanges, 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 software design documentwith 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?* SQlite adapter software design document|* SQlite adapter time stamp supportFixing testNew
|* Running unit tests|-|What is blocking me?*Waiting on PseudoXA* code |n/a|n/a|-|What am I blocking (or about to be uploaded to the repoblock)?|n/a|n/a*Waiting on Studio Express 8 update on OHT-AIP site|}
=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)?*Completion of sprint 1|n/a|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?|*Creating Got windows build command for project makefile* Fixed and assigning tasksissued with the sqltie shell project not compiling|*Fixed creation Testing with new JDBC driver build|-|What am I working on before the next stand up?|* Investigating failing tests|* Fix reading of primary keys with autoincrementcolumn 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 SQLite adapter with Studio<!--==Thursday==What is blocking me?*Waiting on PseudoXA* code to be uploaded to the repo{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"*Waiting on Studio Express 8 update on OHT|-AIP site 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?* 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|n/a|n/a|-|What am I blocking (or about to block)?* Completion of sprint 1|n/a|n/a|n/a|}-->
==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|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)?
*
==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|}
What am I blocking (or about to block)?
*
=Archive==Grace===What have I worked on since the last stand up?What am I working [http://zenit.senecac.on before the next stand up?* What is blocking me?* What am I blocking (or about to block)?*-->.ca/wiki/index.php/SQLite_Adapter_StandUp_Reports_2011 2011 Reports]

Navigation menu