Changes

Jump to: navigation, search

SQLite Adapter StandUp Reports

6,837 bytes added, 22:48, 26 January 2014
no edit summary
{{Admon/obsolete}}
 
[[category: NexJ Express SQLite]]
<!--
{| border=Week "1: Sept 26" cellpadding===Thursday"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==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=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* What is blocking me?* What am I blocking (or about to block)?* ===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 714: Nov 8Apr 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 Express* What 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* 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/aremaining tickets What am I blocking (or about to block)?|
* 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?* Append Literal peer review What am I working on before the next stand up?* SQLAdapter ticket peer review 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?* Create Teee Debugging launcher* SQLiteAdapter Drop Column
{| 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?|* Creating SQL scriptsSoftware Design Documentation* Full Text Search SupportTesting 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 is blocking me?* 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|* 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 612: Oct 31Mar 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?|* Review and wrap up of sprint 1 Fixed SQLite open behaviour when a database does not exist* Reviewed adapter patch What am I working on before the next stand up?* Code styling* Peer review colleagues commitsSoftware design document|What is blocking me?* Reviewed locale work* n/a What am I blocking (or about to block)?Reviewed open behaviour work* n/aSoftware design document|-===Grace===|What have am I worked working on since before the last next stand up?|* Assigning TicketsDocumentation* Peer reviewing ticketsAdapter patch review|What am I working on before the next stand up?* Software Design Documentation* Fixing running of unit tests.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|* Case Insensitivity Added custom build step to generate nexj_sqlite file in SQLiteSchemaManagervisual studio projects* Added content to software design document* Ticket review of commits last weekAdded keywords to adapter* Framework review Fixed creation of adapter integrationviews|-|What am I working on before the next stand up?|* Code cleanup* SQLite open behaviour|* Helping Grace Testing adapter with Sprint 1 completionstudio* Finishing up software design document* Reviewing adapter patch|-|What is blocking me?* |n/a|n/a |-|What am I blocking (or about to block)?* Sprint 1 completion|n/a|n/a|}
===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 What am I blocking (or about to block)?* 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)?|n/a|n/a|n/a|}
What am I blocking (or about to block)?*completion of sprint 1 =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=
What is blocking me?==Thursday==* n/a{| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"|-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?* Updating and adding the following components to SQLiteSQLSchemaManager:** implement string concatenation|** implement analyze tableExtension selection logic** generate UUIDProject planning** get current time|** print to outputBuidling SQLite with ICU enabled** general code cleanup||-|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* Implemeting Allow user to set locale for database and or column ||-|What is blocking me?|n/a method in the SQLiteSQLSchemaManager |n/a|n/a|-|What am I blocking (or about to append to the buffer SQLite specific literal representationblock)?|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
 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?|* Driver make file* Source make file* Rebuilding the sqlite library for multi-thread mode|* classes.Research on SQLite multi-threading||-|What is blocking me?|n/a|n/a||-|What am I blocking (or about to block)?*Completion of sprint 1|n/a|n/a||}
===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* Repository maintenance||-|What am I working on before the next stand up?|* driver make file* sqlite source make file* Fixed truncate tableInvestigating failing adapter tests|* Allow loading of user defined SQLite adapter software design documentextensions||-|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?
* 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
*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?|* appendColumnType && SuffixModifying our sqlite jdbc* methods required by Including the sqliteSchemaManagerTestdriver inside the project|* Delegating tasks* sqlite software design documentAdding 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 document What 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. ===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?|* changing the location of sqlite dbRecompiling SQLite JDBC 3.7.10* SQLite 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|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* creating 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?* 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]
Retrieved from "https://wiki.cdot.senecapolytechnic.ca/wiki/Special:MobileDiff/73792...104150"

Navigation menu