Changes

Jump to: navigation, search

SQLite Adapter StandUp Reports

7,853 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: Sept 26Apr 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 What am I working on before the next stand up?|What is blocking me?Testing with Studio ExpressWhat am I blocking (or about Fixing bug when multiple threads try to write to block)?the database file===Grace===What have I worked Updated NexJ about progress on since the last stand up?*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=Carlin=="2" style="border: 1px solid black;border-collapse:collapse;"What have I worked on since the last stand up?|-* What am I working on before the next stand up?* What is blocking me?*!! CarlinWhat 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 6: Oct 31===Thursday=====Carlin===|What have I worked on since the last stand up?* Review and wrap up of sprint 1 patch What am I working on before the next stand up?* Peer review colleagues commits 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 13: Apr 2==Grace=Thursday==What have I worked on since the last stand up?* Assigning Tickets* Peer reviewing tickets What am I working on before the next stand up?* Fixing running of unit tests. What is blocking me?*
{| 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==
===Carlin===
What have I worked on since the last stand up?
* Case Insensitivity in SQLiteSchemaManager
* Ticket review of commits last week
* Framework review of adapter integration
{| 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* Helping Grace Testing with Sprint 1 completionStudio 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 |}
What am I blocking (or about to block)?==Monday==* Sprint {| border="1 completion " 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 SQLite Added custom build step to generate nexj_sqlite file in visual studio projects* Added content to software design document* Added keywords to adapter with Studio express* Fixed creation of views|-|What am I working on before the next stand up?|* Code cleanup* SQLite open behaviour|* Testing adapter with studio* Preparing deliverable for sprint 1Finishing 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 511: Oct 24Mar 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?|*Updated repo to latest version from mercurial.nexj.comFixed testNew, the setup scripts were wrong*Fixed implementation of PseudoXA for 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* SQLiteopen 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?|*Reviewing code for sprint 1Fixing 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=={| 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?|*Still Implementing PseudoXA Got windows build command for SQLiteproject 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=<!--==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?*Testing the adapter with Studio||||-|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)?*completion of sprint 1|n/a|n/a|n/a|}
=Week 48: Oct 17Feb 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?|* Investigating an unsatisfied link error|* Built SQLite specific view implementationlibrary 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=={| 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|* Extension to enhance locale support in SQLite||-|What am I working on before the next stand up?|* Completing SQLite viewsImproving the build system|* Analyzing XADatasource commitsAllow 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* Testing within studio|n/a|}
What is blocking me?* Midterms=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)?* Sprint 1 completion|n/a|n/a|n/a|}
==Monday =Grace===What have I worked on since the last stand up?*Implementing PseudoXA for SQLiteN/A
What am I working on before the next stand up?*Testing the adapter with Studio=Week 6: Feb 13=
==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* 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 am I blocking (or about to block)?*completion of sprint 1 ==Monady=={| border=Abhishek"1" cellpadding="4" cellspacing="2" style=What have I worked on since the last stand up?* Updating and adding the following components to SQLiteSQLSchemaManager"border: 1px solid black;border-collapse:collapse;"** implement string concatenation|-** implement analyze table!** generate UUID! Carlin** get current time! Grace** print to output** general code cleanup! Abhishek|-|What am have I working worked on before since the next last 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 1Buidling SQLite with ICU enabled==Monday==|===Carlin===|-|What have am I worked working on since before the last 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
|}
What am I working on before the next stand up?* SQLiteSchemaManager timestamp handling* SQLite project software design document=Week 5: Feb 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* 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=={| 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)?* Sprint 1 completion|n/a|n/a|n/a|}
=Week 4: Jan 30===Thursday=={| border=Grace"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
==Monday=={| 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?|* Reviewed code*Update of driver make file|* Tested SQLiteAdapter with Teee* Passing the external repo testRead unit test* Research on SQLite multi-threading* Research on nmake for building SQLite components with PseduoXAvisual studio tools||-|What am I working on before the next stand up?|* classes.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||}
What am I blocking (or about to block)?
*Completion of sprint 1
===Abhishek===sick (n/a) =Week 3: Oct 10 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 full text search index support in SQLite schema managerfor missing type conversions cases* Fixed truncate tableRepository maintenance* SQLite adapter software design document||-|What am I working on before the next stand up?|* driver make file* sqlite source make file* SQlite Investigating failing adapter software design documenttests|* SQlite adapter time stamp supportAllow loading of user defined SQLite extensions||-|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===Grace===What have I worked on since the last stand up?*Creating and assigning tasks|n/a*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==
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?|* 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 a|n/a|n/a|-- public holiday|What am I blocking (or about to block)?|n/a|n/a|n/a|}
=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?|* Modifying our sqlite jdbc* Including the driver inside the project|* appendColumnType && SuffixDelegating tasks* methods required by Adding constraint names to error message for constraint violations|-|What am I working on before the sqliteSchemaManagerTestnext stand up?|* Completely integrate the driver and sqlite software 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|}
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 the last stand up?
* Researched and experimented with sqlite to gain a better understanding of it.
* Started working on user story 3.
 
What am I working on before the next stand up?
* Completing user story 3
 
What is blocking me?
* nobody
 
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==
{| 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?* Worked with Grace to get story 1 working What am I working on before the next stand up?|* changing the location of sqlite dbExtension loading, SQLiteDataSourceWrapper* starting database schema scripts What is blocking me?SQLiteDataSourceWrapper workflow* framework knowledge, graces directionTeam issues on BitBucket|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'sRecompiling SQLite JDBC 3.7.10* SQLite Adapter Software Design Document|* Follow up with Greg on architectural design Allow loading of the driver.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: 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?|* creating Identified the JDBC's ''Function'' limits* Demo of extension loading|* 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?|n/a|n/a|-|What am I blocking (or about to block)?|n/a|n/a|}
What is blocking me?
* Converting XADatasource dependency to Datasource
 
What am I blocking (or about to block)?
* Story 1 completion
 
===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