Cordova sqlite test app

Template to demonstrate reproducible issues with Cordova sqlite plugin (using JQuery and Bootstrap 3). May be used as a starter project.

AUTHOR: @brodybits (Christopher J. Brody aka Chris Brody)

LICENSE: CC0 1.0 (public domain)

NOTE: This project includes JQuery (3.3.1) and Bootstrap 3 (3.3.7) under the MIT license. Otherwise there is no code copied from other sources.

IMPORTANT: Whitelist and intent items are omitted from this test app.

Dependencies

• Bootstrap (3.3.7) - included (MIT license)
• JQuery (3.3.1) - included (MIT license)
• cordova-plugin-dialogs - specified in config.xml
• Cordova sqlite plugin - please add the desired version from the Cordova CLI as described below

IMPORTANT NOTE: cordova-plugin-dialogs was added using the --save flag to ensure that this plugin would be tracked in config.xml for automatic installation. It is recommended to use the --save flag on Cordova pre-7.0 to track any other plugins added in config.xml (this is automatic starting with Cordova 7.0). It is NOT recommended to commit plugins or platforms directories to git or any other form of source code control.

Additional note: cordova-plugin-dialogs does not currently support macOS ("osx"). As a workaround this project automatically uses window.alert if necessary.

To add another plugin

cordova plugin add my-plugin-id --save

How to run

1. Add the desired Cordova sqlite plugin version, for example:

cordova plugin add cordova-sqlite-storage --save

NOTE: --save flag is automatic and not needed in Cordova 7.0 and greater

2. Add the desired platform(s), for example:

cordova platform add android

3. Do cordova prepare (may not always be necessary but good to be on the safe side):

cordova prepare

4. Run it on your mobile emulator or device, for example:

cordova run android

Functionality

• Upon startup: open a database and CREATE the test table
• Alert dialog test (native alert if possible)
• Echo test
• Self test
• Location reload
• String test 1
• String test 2 (string as a SQL parameter)
• Show record
• Add record
• Add 100 records from JavaScript object after delay
• Delete all records
• Follow link to page 2
• Change window.location to page 2

Multi-page test

It is possible to switch between two pages using "follow link" buttons. The main page also has a button to go to page 2 by changing window.location. There is also a button on both pages to try location.reload().

The sqlite plugin should continue to work after the user changes to another page or triggers location.reload().