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)); }); }
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), ); }); }); }
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 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), ); }); }); }
const getExpenses = () => { return new Promise((resolve, reject) => { db.transaction((tx) => { tx.executeSql( GETEXPENSESSQL, [], (_, result) => resolve(result), (_, err) => reject(err), ); }); }); }
initialize(onDatabaseInitialized) { this.db.transaction(transaction => { transaction.executeSql(` CREATE TABLE IF NOT EXISTS passport_form ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, date TEXT, name TEXT, surname TEXT, pesel TEXT, sex TEXT, is_male INTEGER, email TEXT, phone TEXT, birth_day INTEGER, birth_month INTEGER, birth_year INTEGER, rodo INTEGER, file TEXT );`, [], () => onDatabaseInitialized(), (transaction, error) => console.log(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; }