import DB from 'react-native-sqlcipher';

errorCB(err) {
  console.log("SQL Error: " + err);
}

successCB() {
  console.log("SQL executed fine");
}

openCB() {
  console.log("Database OPENED");
}

let db = DB.openDatabase({"name": "test.db", "key": "password",createFromLocation:1}, openCB, errorCB);
db.transaction((tx) => {
  tx.executeSql('SELECT * FROM Employees a, Departments b WHERE a.department = b.department_id', [], (tx, results) => {
      console.log("Query completed");

      // Get rows with Web SQL Database spec compliance.

      var len = results.rows.length;
      for (let i = 0; i < len; i++) {
        let row = results.rows.item(i);
        console.log(`Employee name: ${row.name}, Dept Name: ${row.deptName}`);
      }

      // Alternatively, you can use the non-standard raw method.

      /*
        let rows = results.rows.raw(); // shallow copy of rows Array

        rows.map(row => console.log(`Employee name: ${row.name}, Dept Name: ${row.deptName}`));
      */
    });
});

// Manually overwrite the DB file
DB.copyDBFile({name : 'test.db',createFromLocation : 1},() => console.info('copy completed'))