Native persistance for HTML5 iOS apps with Trigger.IO. Creates an sqlite3 database and provides abstract CUD methods to be called via JS.
;
at the end of your sqlite queries.Takes an array of sqlite queries to construct the database schema.
forge.internal.call('sqlite.createTables', {
schema: "CREATE TABLE sample(x INTEGER PRIMARY KEY ASC, y, z)"
}, success, error);
Takes an array of objects. Each object contains a string "query"
, and array containing a string ["arg"]
. If the write was successfully executed, this call will return the id's affected within an array.
forge.internal.call('sqlite.writeAll', {
queries: [
{
query: 'UPDATE...',
args: ['arg']
},
{
query: 'UPDATE...',
args: ['arg']
}
]
}, success, error);
Takes an array of queries and returns the resulting id's in an array.
forge.internal.call('sqlite.multiQuery', {
queries: ["SELECT...","SELECT..."]
}, success, error);
Returns the JSON array of objects that match the passed in sqlite query.
forge.internal.call('sqlite.query', {
query: "SELECT..."
}, success, error);
Deletes entire database.
forge.internal.call('sqlite.removeDatabase', success, error);
Copyright (c) 2014, Fetchnotes Inc. All rights reserved.
Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
The views and conclusions contained in the software and documentation are those of the authors and should not be interpreted as representing official policies, either expressed or implied, of the FreeBSD Project.