uk.co.workingedge.cordova.plugin.sqliteporter

import { sqlitePorter } from 'uk.co.workingedge.cordova.plugin.sqliteporter'; import { SQLite } from 'cordova-sqlite-storage'; // Wait for deviceready document.addEventListener('deviceready', async () => { try { const db = await SQLite.openDatabase({ name: 'test.db', location: 'default' }); // Import SQL const sql = 'CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT);\nINSERT INTO users VALUES (1, \'Alice\');'; await sqlitePorter.importSqlToDb(db, sql); // Export to SQL const exported = await sqlitePorter.exportDbToSql(db); console.log(exported); // Export to JSON const json = await sqlitePorter.exportDbToJson(db); console.log(json); // Import JSON const jsonData = { 'users': [{ 'id': 2, 'name': 'Bob' }] }; await sqlitePorter.importJsonToDb(db, jsonData); } catch (error) { console.error('SQLite Porter error:', error); } });