2024-11-12 21:28:13.336 25636-25765 Capacitor               com.hellolulo.lulo                   D  Sending plugin error: {"save":false,"callbackId":"111910333","pluginId":"CapacitorSQLite","methodName":"addUpgradeStatement","success":false,"error":{"message":"CapacitorSQLitePlugin: null"}}
2024-11-12 21:28:13.392 25636-25636 Capacitor/Plugin        com.hellolulo.lulo                   V  To native (Capacitor plugin): callbackId: 111910335, pluginId: CapacitorSQLite, methodName: addUpgradeStatement
2024-11-12 21:28:13.392 25636-25636 Capacitor               com.hellolulo.lulo                   V  callback: 111910335, pluginId: CapacitorSQLite, methodName: addUpgradeStatement, methodData: {"database":"productdb","upgrade":[{"toVersion":1,"statements":["CREATE TABLE IF NOT EXISTS products (\n                id INTEGER PRIMARY KEY AUTOINCREMENT,\n                upc TEXT NOT NULL,\n                size REAL NOT NULL,\n                unit TEXT NOT NULL,\n                name TEXT NOT NULL,\n                brand TEXT NOT NULL,\n                category_description TEXT NOT NULL,\n                sub_category_description TEXT NOT NULL,\n                when_created DATETIME DEFAULT (CURRENT_TIMESTAMP) \n            );","CREATE INDEX IF NOT EXISTS idx_products_upc ON products (upc);"]},{"toVersion":2,"statements":["ALTER TABLE products ADD COLUMN usda_codes;"]}]}
2024-11-12 21:28:13.393 25636-25765 com.getcap...RetHandler com.hellolulo.lulo                   V  *** ERROR CapacitorSQLitePlugin: null

/* Adapted from https://github.com/jepiqueau/blog-tutorials-apps/tree/main/SQLite/Part-2/ionic7-react-sqlite-app*/

import { CapacitorSQLite, SQLiteConnection, SQLiteDBConnection, capSQLiteUpgradeOptions } from '@capacitor-community/sqlite';
import { Capacitor } from '@capacitor/core';

export interface ISQLiteService {
    getPlatform(): string
    addUpgradeStatement(options: capSQLiteUpgradeOptions): Promise<void> 
    openDatabase(dbName: string, loadToVersion: number, readOnly: boolean): Promise<SQLiteDBConnection> 
    closeDatabase(dbName: string, readOnly: boolean): Promise<void>
    isConnection(dbName: string, readOnly: boolean): Promise<boolean>
};

class SQLiteService implements ISQLiteService {
    platform = Capacitor.getPlatform();
    sqlitePlugin = CapacitorSQLite;
    sqliteConnection = new SQLiteConnection(CapacitorSQLite);
    dbNameVersionDict: Map<string, number> = new Map();

    getPlatform(): string {
        return this.platform;
    }
    async addUpgradeStatement(options: capSQLiteUpgradeOptions): Promise<void> {
        try {
            await this.sqlitePlugin.addUpgradeStatement(options);
        } catch(error: any) {
            const msg = error.message ? error.message : error;
            throw new Error(`sqliteService.addUpgradeStatement: ${msg}`);
        }
        return;
    }
    async openDatabase(dbName:string, loadToVersion: number,
                readOnly: boolean): Promise<SQLiteDBConnection>  {
        this.dbNameVersionDict.set(dbName, loadToVersion);
        let encrypted = false;
        const mode = encrypted ? "secret" : "no-encryption";
        try {
            let db: SQLiteDBConnection;
            const retCC = (await this.sqliteConnection.checkConnectionsConsistency()).result;
            let isConn = (await this.sqliteConnection.isConnection(dbName, readOnly)).result;
            if(retCC && isConn) {
              db = await this.sqliteConnection.retrieveConnection(dbName, readOnly);
            } else {
                db = await this.sqliteConnection
                        .createConnection(dbName, encrypted, mode, loadToVersion, readOnly);
            }
            const jeepSQlEL = document.querySelector("jeep-sqlite")
      
            await db.open();
            const res = await db.isDBOpen();
            return db;
          
        } catch(error: any) {
            const msg = error.message ? error.message : error;
            throw new Error(`sqliteService.openDatabase: ${msg}`);
        }

    }
    async isConnection(dbName:string, readOnly: boolean): Promise<boolean> {
        try {
            const isConn = (await this.sqliteConnection.isConnection(dbName, readOnly)).result;
            if (isConn != undefined) {
                return isConn
            } else {
                throw new Error(`sqliteService.isConnection undefined`);
            }
        
        } catch(error: any) {
            const msg = error.message ? error.message : error;
            throw new Error(`sqliteService.isConnection: ${msg}`);
        }
    }
    async closeDatabase(dbName:string, readOnly: boolean):Promise<void> {
        try {
            const isConn = (await this.sqliteConnection.isConnection(dbName, readOnly)).result;
            if(isConn) {
                await this.sqliteConnection.closeConnection(dbName, readOnly);
            }
            return;
        } catch(error: any) {
            const msg = error.message ? error.message : error;
            throw new Error(`sqliteService.closeDatabase: ${msg}`);
        }
    }
}
export default new SQLiteService();

    minSdkVersion = 22
    compileSdkVersion = 34
    targetSdkVersion = 34

    <application
        android:allowBackup="false"
        android:fullBackupContent="false"
        android:dataExtractionRules="@xml/data_extraction_rules"

<?xml version="1.0" encoding="utf-8"?>
<data-extraction-rules>
    <cloud-backup>
      <exclude domain="root" />
      <exclude domain="database" />
      <exclude domain="sharedpref" />
      <exclude domain="external" />
    </cloud-backup>
    <device-transfer>
      <exclude domain="root" />
      <exclude domain="database" />
      <exclude domain="sharedpref" />
      <exclude domain="external" />
    </device-transfer>
</data-extraction-rules>