Class Database

Since

1.0

See

• https://hiddentao.com/squel/
• https://sqlite.org/docs.html

Database is query friendly persisted data interface for perfoming database operations using SQLite. You can open database from assets or create/open database from file system. Also you can create in-memory database too. We recommend to use Squel.js library for creating SQL Queries.

Example

import File from '@smartface/native/io/file';
    import Database from '@smartface/native/data'.Database;

    var database = new Database({
        file: new File({path: 'assets://database.sqlite'})
    });

    // Creating person table
    database.execute("CREATE TABLE 'person' ( 'id' INTEGER, 'name' TEXT DEFAULT 'Smartface', 'age' INTEGER DEFAULT 5, 'isWorker' INTEGER DEFAULT 0, 'rate' REAL DEFAULT 2.5, PRIMARY KEY('id') )");

    // Inserting values into person
    database.execute("INSERT INTO person (name, age, isWorker, rate) VALUES ('George', 47, 0, 1.2)");
    database.execute("INSERT INTO person (name, age, isWorker, rate) VALUES ('James', 40, 1, 3.4)");
    database.execute("INSERT INTO person (name, age, isWorker, rate) VALUES ('Alex', 25, 1, 1.7)");

    // Getting workers count
    var queryResult = database.query("SELECT * FROM person WHERE(isWorker = 1)");
    console.log("Worker count is: " + queryResult.count());