SQLite

$ ionic plugin add cordova-sqlite-storage

Repo:https://github.com/litehelpers/Cordova-sqlite-storage

Access SQLite databases on the device.

Usage

import { SQLite } from 'ionic-native';

// OPTION A: Use static constructor
SQLite.openDatabase({
  name: 'data.db',
  location: 'default'
})
  .then((db: SQLite) => {

    db.executeSql('create table danceMoves(name VARCHAR(32))', []).then(() => {}).catch(() => {});

  })
  .catch(error => console.error('Error opening database', error));


// OPTION B: Create a new instance of SQLite
let db = new SQLite();
db.openDatabase({
  name: 'data.db',
  location: 'default' // the location field is required
}).then(() => {
  db.executeSql('create table danceMoves(name VARCHAR(32))', []).then(() => {

  }, (err) => {
    console.error('Unable to execute sql: ', err);
  });
}, (err) => {
  console.error('Unable to open database: ', err);
});

Static Members

openDatabase()

echoTest()

Returns:Promise<any>

deleteDatabase(first)

Returns:Promise<any>

Instance Members

databaseFeatures

openDatabase(config)

Open or create a SQLite database file.

See the plugin docs for an explanation of all options: https://github.com/litehelpers/Cordova-sqlite-storage#opening-a-database

addTransaction()

transaction(fn)

Returns:Promise<any>

readTransaction(fn)

Returns:Promise<any>

startNextTransaction()

close()

Returns:Promise<any>

start()

executeSql()

Execute SQL on the opened database. Note, you must callopenDatabasefirst, and ensure it resolved and successfully opened the database.

addStatement(sql, values)

Returns:Promise<any>

sqlBatch(sqlStatements)

Returns:Promise<any>

abortallPendingTransactions()

handleStatementSuccess(handler, response)

handleStatementFailure(handler, response)

run()

abort(txFailure)

finish()

abortFromQ(sqlerror)