Changes

Jump to: navigation, search

SQLite Adapter StandUp Reports

5,211 bytes added, 22:48, 26 January 2014
no edit summary
{{Admon/obsolete}}
 
[[category: NexJ Express 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?|||-|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: Apr 9: Nov 21=
==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?*
{| 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?|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)?|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|}
What is blocking me?==Monday=={| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"|-!! Carlin*! Grace|-|What am have I blocking (or about to block)worked on since the last stand up?|n/a|*Rebased adapter code to latest core* Implementing locale in SQLite===Grace===|-|What have am I worked working on since before the last next stand up?|*Fixing testNew
|* Running unit tests|-|What is blocking me?|n/a|n/a|-|What am I working on before the next stand upblocking (or about to block)?*|n/a|n/a|}
What is blocking me?* What am I blocking (or about to block)?*-->=Week 910: Nov 21Mar 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?* What am I working on before the next stand up?|What is blocking me?Investigated failing test, testQueryTimeout*Attempted a fix What am I blocking (or about to block)?|===Grace===What have I worked Fixed bug where BLOB values were not being correctly set on since the last stand up?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 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)?* =Week 89: Nov 14Mar 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?|-*!! CarlinWhat am I working on before the next stand up?! Grace*! Abhishek|-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?*|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?|*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)?* ===Grace===What have I worked on since the last stand up?*|n/a|n/aWhat am I working on before the next stand up?|n/a*|}
What is blocking me?* What am I blocking (or about to block)?* =Week 78: Nov 8Feb 27=
==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?|* AlterColumn designInvestigating an unsatisfied link error|* Built SQLite library on Linux with ICU statically linked* Generate UUID bug fixStarted on extension to enhance locale support in SQLite||-|What am I working on before the next stand up?|* AlterColum reviewSolving said error|* isConversion issueExtension to enhance locale support in SQLite* Sprint 2 meetingAllow 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 ===Grace===What have I worked on since the last stand up?* Maintenance of full-text search indexes What am I working on before the next stand up?* Creating of SQLite sql scripts What is blocking me?* |n/a What am I blocking (or about to block)?* |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|* Append Literal peer reviewExtension to enhance locale support in SQLite||-|What am I working on before the next stand up?|* SQLAdapter ticket peer reviewImproving 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?* n/a=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?|n/a|n/a|n/a|-|What am I blocking (or about to block)?* |n/a|n/a|n/a|}
==Monday =Grace===What have I worked on since the last stand up?* Create Teee Debugging launcher* SQLiteAdapter Drop Column What am I working on before the next stand up?* Creating SQL scripts* Full Text Search Support What is blocking me?* nN/aA
What am I blocking (or about to block)?* n/a=Week 6: Feb 13=
=Week 6: Oct 31=
==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?|* Review and wrap Extension selection logic* Project planning|* Buidling SQLite with ICU enabled||-|What am I working on before the next stand up ?|* Confirm linux behaviour of sprint 1 patchsystem 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=={| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"|-!! Carlin! Grace! Abhishek|-|What am have I working worked on before since the next last stand up?* Peer review colleagues commits What is blocking me?|
* 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 5: Feb 6==Grace===What have I worked on since the last stand up?* Assigning Tickets* Peer reviewing tickets
==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* Added error handling to extensions* Building SQLite with ICU enabled* Implemented appendMatchExpression||-|What am I working on before the next stand up?|* Fixing running of unit tests.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?|* Case Insensitivity in SQLiteSchemaManagerNexj sqlite extension, and the binary() conversion function|* Ticket review of commits last weekUpdated software design document* Framework review of adapter integration||-|What am I working on before the next stand up?* Helping Grace with Sprint 1 completion What is blocking me?|* n/a  What am I blocking Proper error handling in the binary(or about to block)?extension* Sprint 1 completionUnicode library extension for sqlite* Updating wiki with project milestones===Grace===* Asking the Community about our multiple attach issueWhat have I worked on since the last stand up?|* Testing Investigate UNICODE support in SQLite adapter with Studio express What am I working * Research on before the next stand up?SQLite multi-threading * Preparing deliverable for sprint 1||-|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 54: Oct 24Jan 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*Updated repo to latest version from mercurial.nexj.comReview 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*Fixed implementation of PseudoXA Prepping for NexJ meeting* completing and compiling NexJFunctions extension|* Investigate UNICODE support in SQLite*Testing adapter with studioResearch 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?
*Reviewing code for sprint 1
 
What is blocking me?
* n/a
 
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===! Abhishek|-|What have I worked on since the last stand up?|*Still Implementing PseudoXA Reviewed code* driver make file|* Tested SQLiteAdapter with Teee* Passing the testRead unit test* Research on SQLite multi-threading* Research on nmake for building SQLitecomponents with visual studio tools||-|What am I working on before the next stand up?|* Driver make file* Source make file*Testing Rebuilding the adapter with Studiosqlite 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||}
What am I blocking (or about to block)?
*completion of sprint 1
=Week 43: Oct 17Jan 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?|* SQLite specific view implementation What am I working on before the next stand Code clean up?* Completing SQLite viewsExploring attach database issue* Analyzing XADatasource commits|* Testing within studio What is blocking me?Fixed binding of Decimal values* Midterms What am I blocking (or about to block)?Added support for missing type conversions cases* Sprint 1 completionRepository maintenance|===Grace===What have I worked on since the last stand up?*Implementing PseudoXA for SQLite|-|What am I working on before the next stand up?|* driver make file* sqlite source make file*Testing the Investigating failing adapter with Studiotests|* 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)?*completion of sprint 1|n/a|n/a===Abhishek===What have I worked on since the last stand up?* Updating and adding the following components to SQLiteSQLSchemaManager:** implement string concatenation** implement analyze table|n/a** generate UUID** get current time** print to output** general code cleanup|}
What am I working on before the next stand up?
* Implemeting a method in the SQLiteSQLSchemaManager to append to the buffer SQLite specific literal representation
 
What is blocking me?
* n/a
 
What am I blocking (or about to block)?
* completion of sprint 1
==Monday==
{| 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?|-* n/a!! CarlinWhat am I working on before the next stand up?! Grace* SQLiteSchemaManager timestamp handling! Abhishek* 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/aDriver make fileWhat am I working on before the next stand up?|*Implementing PseudoXA for SQLite What is blocking me?Refactoring SQLiteDataSourceWrapper*Update of Getting the adapter to load an external repo with PseduoXA* classes.datasource|What am I blocking (or about * Converting SQLite Rank DLL to block)?VS project*Completion of sprint 1Working on appendMatchStatement in SQLite Adapter|-===Abhishek===sick (n/a) =Week 3: Oct 10 ===Thursday=====Carlin===|What have am I worked working on since before the last next stand up?* Added full text search index support in SQLite schema manager|* Fixed truncate tableDriver make file
* SQLite adapter software design document
 What am I working on before the next stand up?* SQlite adapter software design document* SQlite adapter time stamp support What is blocking me?|*Waiting on PseudoXA* code to be uploaded to the repo*Waiting on Studio Express 8 update on OHT-AIP site What am I blocking (or about to block)?*Completion Allow loading of sprint 1 ===Grace===What have I worked on since the last stand up?user defined SQLite extensions*Creating and assigning tasks|*Fixed creation of primary keys with autoincrement What am I working on before the next stand Finishing up?*Testing appendMatchStatement in SQLite adapter with StudioAdapter|-|What is blocking me?*Waiting on PseudoXA* code to be uploaded to the repo|n/a*Waiting on Studio Express 8 update on OHT-AIP site|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?* 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|n/a|n/a==Monday==|n/aN/A -- public holiday|}
=Week 2: Oct 3Jan 16=
==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?|* appendColumnType && SuffixModifying our sqlite jdbc* methods required by Including the sqliteSchemaManagerTestdriver inside the project|* sqlite software design documentDelegating tasks* Adding constraint names to error message for constraint violations|-|What am I working on before the next stand up?* continue advancing on required methods for sqliteSchemaManagerTest* researching indexing within sqlite* createIndex methods in schemaManager What is blocking me?* n/a What am I blocking (or about to block)?|* unit test setup ===Abhishek===What have I worked on since Completely integrate the last stand up?* Researched driver and experimented with sqlite to gain a better understanding of it.source into the project* Started working on user story 3.Software design documentWhat am I working on before the next stand up?|* Completing Allow loading of user story 3defined SQLite extensions|-|What is blocking me?* 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|n/thing interested in seeing a fully working test of the adapter.|n/a===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==
{| 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* Worked with Grace to get story 1 workingTeam issues on BitBucket|n/a|-|What am I working on before the next stand up?|* Recompiling SQLite JDBC 3.7.10* changing the location of sqlite dbSQLite Adapter Software Design Document|* starting database schema scriptsAllow loading of user defined SQLite extensions|-|What is blocking me?* framework knowledge, graces direction|n/a|n/a|-|What am I blocking (or about to block)?* |n/a ===Grace===What have I worked on since the last stand up?* Got user story 1 working (may be changed in future depending on architectural design). What am I working on before the next stand up?* Assigning work to Carl that is not related to XA's.* Follow up with Greg on architectural design of the driver. What is blocking me?* |n/a|}
What am I blocking (or about to block)?
* n/a
 
 
=Week 1: Sept 26=
=Week 1: Jan 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|* creating Researched on adding functionality to SQLite: dataSourceWrapper, AdapterTest, SchemaManagerTest, SQLManagedConnection, SQLAdapter, SQLSchemaManager* Discussed design for adding functionality with NexJ|-|What am I working on before the next stand up?|* Obtaining a SQLite database lock in Adapter software design document|* Allow loading of user defined SQLite junit suiteextensions|-|What is blocking me?* Converting XADatasource dependency to Datasource|n/a|n/a|-|What am I blocking (or about to block)?* Story 1 completion|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==
{| 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| n/a| n/Aa|-|What am I working on before the next stand up?|* Research on adding functionality to SQLite* Discuss design for adding functionality with NexJ|* Getting the framework Research on adding functionality to load and run an SQLite adapter* Discuss design for adding functionality with NexJ|-|What is blocking me?* XAdatasource knowledge within the framework and sqlite|n/a|n/a|-|What am I blocking (or about to block)?* N|n/A ===Grace===aWhat have I worked on since the last stand up?*N|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)?=Archive=* nothing[http://zenit.senecac.on.ca/wiki/index.php/SQLite_Adapter_StandUp_Reports_2011 2011 Reports]

Navigation menu