Changes

Jump to: navigation, search

SQLite Adapter

2,325 bytes added, 17:47, 9 February 2012
Sprint: 1
|Running the DB Schema Tool's "create" command, appropriate artifacts are created (e.g. a sql file) for creating the tables in an existing SQLite database.
|}
=== Sprint 2 ==={| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"|-! User Story! Score! Details|-| Use data schema tool to generate the SQL to insert the data from a dump file| 0| Running the DB schema Tool's 'insert' command, appropriate artifacts are created in the database|-| Use the scheme console to insert into and read from the database| 0| Running the schema console, perform multi-transactional inserts with commits and rollbacks. Reading from the database to confirm updates|-| Use the data load tool to extract information in a SQLite database and persist it to a dump file| 0| Running the data load tool, read information from the database and export it to a dump file|-| Use the database schema tool to create an insert script for all the instances in in a SQLite database| 0| Running the data load tool, read in information from a dump file|-| Add an attribute to the User class, add the column to the datasource and Main.upgrade. Use the data load tool to upgrade the SQLite database. The database now has the new column add to the User Table| 3| Running the database schema tool alter the user class and perform an upgrade|-| Run each of the data load tool commands to validate their use| 5| Running all of the data load tool's commands, checking for expected results|-| Run each of the database schema tool commands to validate their use| 5| Running all of the database schema tools commands, checking for expected results|}=== Sprint 3 ==={| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;"|-! User Story! Score! Details|-| Retrieve a record using fulltext search in the where clause| 0| Using the SQlite Adapter perform a query to verify the full test search options have been configured properly|-| Demonstrate unicode support in sqlite functions| 5| Using the SQlite Adapter perform a query to verify unicode support is as expected in sqlite functions|-| Run all SQLiteSchemaManager unit tests, to validate correctness| 2| Using studio perform all the tests as Junit tests, ensuring no failures.|-| Run all the SQLiteAdapter unit tests, to validate correctness| 7| Using studio perform all the tests as Junit tests, ensuring no failures.|}
== Project Repository ==

Navigation menu