AppDatabase.js

import SQLite from 'react-native-sqlite-storage';
SQLite.DEBUG(true);
SQLite.enablePromise(true);

const database_name = 'MyBmioffline.db';
const database_version = '1.0';
const database_displayname = 'MyBmi Offline Database';
const database_size = 200000;

export default class Database {
  initDB() {
    let db;
    return new Promise(resolve => {
      console.log('Plugin integrity check ...');
      SQLite.echoTest()
        .then(() => {
          console.log('Integrity check passed ...');
          console.log('Opening database ...');
          SQLite.openDatabase(
            database_name,
            database_version,
            database_displayname,
            database_size,
          )
            .then(DB => {
              db = DB;
              console.log('Database OPEN');
              db.executeSql('SELECT 1 FROM Reports LIMIT 1')
                .then(() => {
                  console.log('Database is ready ... executing query ...');
                })
                .catch(error => {
                  console.log('Received error: ', error);
                  console.log('Database not yet ready ... populating data');
                  db.transaction(tx => {
                    tx.executeSql(
                      'CREATE TABLE IF NOT EXISTS Reports( '
      + 'ReportId VARCHAR(100), '
      + 'Gender VARCHAR(20), '
      + 'Bmi FLOAT, '
      + 'Age VARCHAR(10), '
      + 'Weight FLOAT, '
      + 'CreatedDate VARCHAR(50) );',
                    );
                  })
                    .then(() => {
                      console.log('Table created successfully');
                    })
                    .catch(error => {
                      console.log(error);
                    });
                });
              resolve(db);
            })
            .catch(error => {
              console.log(error);
            });
        })
        .catch(error => {
          console.log('echoTest failed - plugin not functional', error);
        });
    });
  }

  closeDatabase(db) {
    if (db) {
      console.log('Closing DB');
      db.close()
        .then(status => {
          console.log('Database CLOSED');
        })
        .catch(error => {
          console.log("error in second catch", error)
        });
    } else {
      console.log('Database was not OPENED');
    }
  }

  listReport() {
    return new Promise(resolve => {
      const reportList = [];
      
      this.initDB()
        .then(db => {
          db.transaction(tx => {
            tx.executeSql(
              'SELECT r.ReportId, r.Gender, r.Bmi, r.Age, r.Weight, r.CreatedDate FROM Reports r',
              [],
            ).then(([tx, results]) => {
              console.log('Query completed');
              var len = results.rows.length;
              for (let i = 0; i < len; i++) {
                let row = results.rows.item(i);
                console.log(
                  `Report ID: ${row.ReportId}, Report Bmi: ${row.Bmi}`,
                );
                const {ReportId, Gender, Bmi, Age, Weight, CreatedDate} = row;
                reportList.push({
                  ReportId,
                  Gender,
                  Bmi,
                  Age,
                  Weight,
                  CreatedDate,
                });
              }
              console.log(reportList);
              resolve(reportList);
            });
          })
            .then(result => {
              // this.closeDatabase(db);
            })
            .catch(err => {
              console.log(err);
            });
        })
        .catch(err => {
          console.log(err);
        });
    });
  }

  reportById(id) {
    console.log(id);
    return new Promise(resolve => {
      this.initDB()
        .then(db => {
          db.transaction(tx => {
            tx.executeSql('SELECT * FROM Reports WHERE ReportId = ?', [id]).then(
              ([tx, results]) => {
                console.log(results);
                if (results.rows.length > 0) {
                  let row = results.rows.item(0);
                  resolve(row);
                }
              },
            );
          })
            .then(result => {
              this.closeDatabase(db);
            })
            .catch(err => {
              console.log(err);
            });
        })
        .catch(err => {
          console.log(err);
        });
    });
  }

  addReport(report) {
    return new Promise(resolve => {
      this.initDB()
        .then(db => {
          db.transaction(tx => {
            tx.executeSql('INSERT INTO Reports VALUES (?, ?, ?, ?, ?, ?)', [
              report.ReportId,
              report.Gender,
              report.Bmi,
              report.Age,
              report.Weight,
              report.CreatedDate
            ]).then(([tx, results]) => {
              resolve(results);
            });
          })
            .then(result => {
              // this.closeDatabase(db);
            })
            .catch(err => {
              console.log(err);
            });
        })
        .catch(err => {
          console.log(err);
        });
    });
  }



  deleteReport(id) {
    return new Promise(resolve => {
      this.initDB()
        .then(db => {
          db.transaction(tx => {
            tx.executeSql('DELETE FROM Reports WHERE reportId = ?', [id]).then(
              ([tx, results]) => {
                console.log(results);
                resolve(results);
              },
            );
          })
            .then(result => {
              this.closeDatabase(db);
            })
            .catch(err => {
              console.log(err);
            });
        })
        .catch(err => {
          console.log(err);
        });
    });
  }
}