Connect a web application to a local sqlite DB, using a MVVM architecture compatible with phonegap

We are developing an open source mobile app using phonegap. One part of this app is a view implemented as a static HTML5 file with some vanilla js, see index.html. We need to connect this view to a sqlite version 3 database that will be locally accessible to the app, using the MVVM architecture, via one of the available libraries (knockout, angularjs, you-name-it-js). The database schema is shown in persistency.sql. For details on what elements should be dynamically populated and the SQL queries to use, see the 1-page detailed specification. Basically it all boils down to write core in the change_node() and init() functions where you see the marker ".... your code goes here ....". We will take care of testing: - integration tests for sure (capybara ?) - ideally unit tests on the model-view (mocha ?): your code should be testable we can share the test scripts if you like. Additional requirements: - use the current, stable version of phonegap - although the app source code will end up on github, we prefer the deliverable for this job to be supplied by you as attachments via freelancer - we target Android 4.4, iOS 7 and WP 8; for your work just make sure it works with inside ripple ! - we plan to create the apps with phonegap build, so the communication with the sqlite database should happen using one of the two plugins for this purpose supported by phonegap build, i.e. com.millerjames01.sqlite-plugin ([login to view URL]) for Android / iOS or [login to view URL] ([login to view URL]) for WP 8. Use one of the two, preferably the 1st one. - plase avoid jQuery or jQuery mobile; try to stick to vanilla js As you will note, ATM not everything is ready (missing sample database, untested SQL queries, mismatches between fields and elements that should be dynamically filled, missing test scripts ...). We are working hard to finish our part in time, and confident that the required stuff to start the job will be available when we need to start. Anyway these adjustments should not significantly change the scope of the work. BTW, any suggestion / refactoring of the current HTML5/js design for the view is welcome !