Difference between revisions of "SQLite Adapter"
| Line 3: | Line 3: | ||
<big><big> SQLite Adapter for NexJ </big></big> | <big><big> SQLite Adapter for NexJ </big></big> | ||
| + | |||
== Project Goal == | == Project Goal == | ||
| Line 13: | Line 14: | ||
=== Supported Versions === | === Supported Versions === | ||
| − | |||
| − | |||
| − | == Project | + | == Project Status== |
| − | === Phase 1: Investigation === | + | * [[SQLite_Adapter_StandUp_Reports | Stand Up Reports]] |
| + | * Current Sprint : [[SQLite_Adapter#Sprint_1 | 1]] | ||
| + | |||
| + | |||
| + | == Project Backlog == | ||
| + | === Phase 1: Investigation (DONE) === | ||
* Get requirements from NexJ (Meeting Friday Sept 23rd) | * Get requirements from NexJ (Meeting Friday Sept 23rd) | ||
* Walk-through the code | * Walk-through the code | ||
* Familiarization with SQLite | * Familiarization with SQLite | ||
* [[SQLite_Adapter_Research | Research Summary]] | * [[SQLite_Adapter_Research | Research Summary]] | ||
| + | |||
=== Sprint 1 === | === Sprint 1 === | ||
| − | + | {| border="1" cellpadding="4" cellspacing="2" style="border: 1px solid black;border-collapse:collapse;" | |
| − | + | |- | |
| − | + | ! User Story | |
| + | ! Score | ||
| + | ! Details | ||
| + | |- | ||
| + | |Initial skeleton of the SQLite adapter | ||
| + | |2 | ||
| + | |Running the jUnit test shows in the console that the adapter is loaded an running. | ||
| + | |- | ||
| + | |Use database schema tool to generate the SQL to setup the database | ||
| + | |1 | ||
| + | |Running the DB Schema Tool's "setup" command, appropriate artifacts are created (e.g. sql or bat script) for generating the SQLite database. | ||
| + | |- | ||
| + | |Use database schema tool to generate the SQL to create the Core datasource's tables | ||
| + | |5 | ||
| + | |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. | ||
| + | |} | ||
== Project Repository == | == Project Repository == | ||
* Central: https://bitbucket.org/cwdesautels/nexj-express-sqlite-adapter | * Central: https://bitbucket.org/cwdesautels/nexj-express-sqlite-adapter | ||
| + | |||
== Resources == | == Resources == | ||
Revision as of 08:31, 26 September 2011
SQLite Adapter for NexJ
Contents
Project Goal
Develop an adapter to enable NexJ Express's model interaction with SQLite databases.
Contributors
Supported Versions
Project Status
- Stand Up Reports
- Current Sprint : 1
Project Backlog
Phase 1: Investigation (DONE)
- Get requirements from NexJ (Meeting Friday Sept 23rd)
- Walk-through the code
- Familiarization with SQLite
- Research Summary
Sprint 1
| User Story | Score | Details |
|---|---|---|
| Initial skeleton of the SQLite adapter | 2 | Running the jUnit test shows in the console that the adapter is loaded an running. |
| Use database schema tool to generate the SQL to setup the database | 1 | Running the DB Schema Tool's "setup" command, appropriate artifacts are created (e.g. sql or bat script) for generating the SQLite database. |
| Use database schema tool to generate the SQL to create the Core datasource's tables | 5 | 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. |
Project Repository
Resources
- Dowloads:
- Documentation:
- Root - http://www.sqlite.org/docs.html
- About - http://www.sqlite.org/about.html
- Types - http://www.sqlite.org/datatype3.html
- Limits - http://www.sqlite.org/limits.html
- Null Handling - http://www.sqlite.org/nulls.html
- Omitted Features - http://www.sqlite.org/omitted.html
- SQL to SQLite - http://www.sqlite.org/lang_expr.html
- API - http://www.sqlite.org/c3ref/intro.html
- QuickStart:
- Usage - http://www.sqlite.org/cintro.html
- C Interface - http://www.sqlite.org/cintro.html
- SQLite JDBC Driver:
- (Unoffical) http://www.zentus.com/sqlitejdbc/
