react-native-ppr-database

Require:

• "react-native": "*",
• "react-native-sqlite-storage": "*"

BaseDatabase

Inside the class's methods, this.database is initialized and used to exectutel SQL actions. You should use this field too.

We have already table KeyValue to manage database version. You should read the source code to reference.

Method

| Method|Parameter|Description | | -- | -- | -- | | constructor | name: string, currentDBVersion: number| Initialize the database informations includes database name and database version | | openDatabase | void | Open the database and validate the database version, re-create all tables in database if the database version changed | | createTables | tx: SQLitePluginTransaction | Create all tables in the database | | dropTables | tx: SQLitePluginTransaction | Drop all tables in the database | | initializeDatabase | void | Call dropTables, then call createTables. This method is called if openDatabase detect the database version changed |

Usage

import BaseDatabase, { SQLQueryCreator } from "react-native-ppr-database";

// * table schema template *
// you should use this template if you want to use SQLQueryCreator
const Animal = {
  name: "Animal",
  primaryKey: "id",
  properties: {
    "id": "text",
    "name": "text"
  }
};

// inherit from Database to modify
class DerivedDatabase extends BaseDatabase {
  // create more tables in `createTables` method.
  createTables(tx) {
    super.createTables(tx);
    tx.executeSql(SQLQueryCreator.createTable(Animal));
  }

  // drop more tables in `dropTables` method.
  dropTables(tx) {
    super.dropTables(tx);
    tx.executeSql(SQLQueryCreator.dropTable(Animal));
  }
}