Expo-sqlite Storage

Expo SDK
1

Please provide the following:

  1. SDK Version: 37
  2. Platforms(Android/iOS/web/all): Android

I am using Sqlite for local storage in my app. I m facing to an issues when updating for a new version.
So my question is: Does Sqlite DB is removed when updating/uninstalling App designed from Expo? Thanks. Below is a piece of my code that works fine.

//================================================================
const DatabaseUser = 'databaseuser.db';
const TableDate = "tabledate";
const TableUser = "tableuser";
const sqliteDB = SQLite.openDatabase(DatabaseUser);

_CreateDatabaseAndTable = () => {
        sqliteDB.transaction( 
            tx => { 
                //tx.executeSql("DROP TABLE IF EXISTS " + TableUser, []);
                var query = "CREATE TABLE IF NOT EXISTS " + TableUser + " ( id INTEGER PRIMARY KEY AUTOINCREMENT, " + 
                "firstname VARCHAR(50), lastname VARCHAR(50), gender VARCHAR(1), username VARCHAR(50), birthdate VARCHAR(16), birthplace VARCHAR(50), email VARCHAR(50), " + 
                "phone VARCHAR(25), city VARCHAR(50), country VARCHAR(50), password VARCHAR(50), dateadd VARCHAR(50), is_deleted INTEGER(1), is_connected INTEGER(1) )"; 
                tx.executeSql(query);
                //--------------------
                //tx.executeSql("DROP TABLE IF EXISTS " + TableDate, []);
                var query1 = "CREATE TABLE IF NOT EXISTS " + TableDate + " ( id INTEGER PRIMARY KEY AUTOINCREMENT, datemenstrue VARCHAR(30), dateadd VARCHAR(50), " + 
                "is_deleted INTEGER(1), cycle REAL, cycle_mean REAL, cycle_median REAL, cycle_max REAL, cycle_min REAL, datemenstrue_next VARCHAR(30) )"; 
                tx.executeSql(query1);
            },
            error => { Alert.alert("Error occured " + error.message); },
            () => { },
        );
}
//================================================================
2

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.