const getExpenses = () => { return new Promise((resolve, reject) => { db.transaction((tx) => { tx.executeSql( GETEXPENSESSQL, [], (_, result) => resolve(result), (_, err) => reject(err), ); }); }); }
loadData(onDataLoaded) { this.db.transaction(transaction => { transaction.executeSql(` SELECT * FROM passport_form;`, [], (transaction, resultSet) => onDataLoaded(this.convertList(resultSet.rows._array)), (transaction, error) => console.log(error)); }); }
constructor() { this.db = SQLite.openDatabase('db.db'); }
deleteMany(passportForms, onDeleted) { let ids = []; let separator = ''; let placeholders = '('; for (let passportForm of passportForms) { placeholders += separator + '?'; separator = ', '; ids.push(passportForm.id); } placeholders += ');'; this.db.transaction(transaction => { transaction.executeSql(` DELETE FROM passport_form WHERE id IN ` + placeholders, ids, (transaction, resultSet) => onDeleted(), (transaction, error) => console.log(error)); }); }
clear(onCleared) { this.db.transaction(transaction => { transaction.executeSql(` DROP TABLE passport_form;`, [], () => onCleared(), (transaction, error) => console.log(error)); }); }
static updatePost(post) { return new Promise((resolve, reject) => { db.transaction((tx) => { tx.executeSql( 'UPDATE posts SET booked = ? WHERE id = ?', [post.booked ? 0 : 1, post.id], resolve, (_, error) => reject(error), ); }); }); }
static getPosts() { return new Promise((resolve, reject) => { db.transaction((tx) => { tx.executeSql( 'SELECT * FROM posts', [], (_, result) => resolve(result.rows._array), (_, error) => reject(error), ); }); }); }
static init() { return new Promise((resolve, reject) => { db.transaction((tx) => { tx.executeSql( 'CREATE TABLE IF NOT EXISTS posts (id INTEGER PRIMARY KEY NOT NULL, text TEXT NOT NULL, img TEXT, date TEXT, booked INT)', [], resolve, (_, error) => reject(error), ); }); }); }
static createPost({ text, date, booked, img }) { return new Promise((resolve, reject) => { db.transaction((tx) => { tx.executeSql( `INSERT INTO posts (text, date, booked, img) VALUES (?, ?, ?, ?)`, [text, date, 0, img], (_, result) => resolve(result.insertId), (_, error) => reject(error), ); }); }); }
const init = () => { return new Promise((resolve, reject) => { db.transaction((tx) => { tx.executeSql( INITDBSQL, [], () => resolve(), (_, err) => reject(err), ); }); }); }
const addExpense = (date, amount, description) => { return new Promise((resolve, reject) => { db.transaction((tx) => { tx.executeSql( ADDEXPENSESQL, [date, amount, description], (_, result) => resolve(result), (_, err) => reject(err), ); }); }); }
static removePost(id) { return new Promise((resolve, reject) => { db.transaction((tx) => { tx.executeSql( 'DELETE FROM posts WHERE id = ?', [id], resolve, (_, error) => reject(error), ); }); }); }
const init = () => { const promise = new Promise((resolve, reject) => { db.transaction(tx => { tx.executeSql( "CREATE TABLE IF NOT EXISTS places (id INTEGER PRIMARY KEY NOT NULL, title TEXT NOT NULL, imageUri TEXT NOT NULL, address TEXT NOT NULL, lat REAL NOT NULL, lng REAL NOT NULL);", [], () => { resolve(); }, (_, err) => { reject(err); } ); }); }); return promise; }
const insertPlace = (title, imageUri, address, lat, lng) => { const promise = new Promise((resolve, reject) => { db.transaction(tx => { tx.executeSql( `INSERT INTO places (title, imageUri, address, lat, lng) VALUES (?, ?, ?, ?, ?);`, [title, imageUri, address, lat, lng], (_, result) => { resolve(result); }, (_, err) => { reject(err); } ); }); }); return promise; }
const fetchPlaces = () => { const promise = new Promise((resolve, reject) => { db.transaction(tx => { tx.executeSql( "SELECT * FROM places", [], (_, result) => { resolve(result); }, (_, err) => { reject(err); } ); }); }); return promise; }