如何处理Ionic 2和SQLite上的事务和从属记录？

ionic cordova plugin add cordova-sqlite-storage
npm install --save @ionic-native/sqlite

import { SQLite, SQLiteObject } from '@ionic-native/sqlite';

constructor(private sqlite: SQLite) { }

...

this.sqlite.create({
  name: 'mydatabase.db',
  location: 'default'
})
.then((db: SQLiteObject) => {
  // 在这里执行数据库操作
})
.catch(e => console.log(e));

db.transaction((tx: SQLiteTransaction) => {
  // 在这里执行数据库操作
})

tx.executeSql('INSERT INTO table_name (column1, column2) VALUES (?, ?)', [value1, value2])
  .then(() => console.log('插入成功'))
  .catch(e => console.log(e));

tx.executeSql('UPDATE table_name SET column1 = ? WHERE id = ?', [newValue, id])
  .then(() => console.log('更新成功'))
  .catch(e => console.log(e));

tx.executeSql('DELETE FROM table_name WHERE id = ?', [id])
  .then(() => console.log('删除成功'))
  .catch(e => console.log(e));

tx.commit()
  .then(() => console.log('事务提交成功'))
  .catch(e => console.log(e));

tx.rollback()
  .then(() => console.log('事务回滚成功'))
  .catch(e => console.log(e));

tx.executeSql('CREATE TABLE IF NOT EXISTS table_name (id INTEGER PRIMARY KEY, column1 TEXT, column2 INTEGER, FOREIGN KEY (column2) REFERENCES other_table(id))', [])
  .then(() => console.log('表创建成功'))
  .catch(e => console.log(e));

tx.executeSql('INSERT INTO table_name (column1, column2) VALUES (?, ?)', [value1, masterRecordId])
  .then(() => console.log('插入从属记录成功'))
  .catch(e => console.log(e));