jeep-sqlite - npm Package Compare versions

Comparing version 1.2.1 to 1.3.0

dist/cjs/jeep-sqlite.cjs.js

@@ -18,3 +18,3 @@ 'use strict';
 patchBrowser().then(options => {
-  return index.bootstrapLazy([["jeep-sqlite.cjs",[[1,"jeep-sqlite",{"echo":[64],"createConnection":[64],"closeConnection":[64],"open":[64],"close":[64],"getVersion":[64],"execute":[64],"executeSet":[64],"run":[64],"query":[64],"isDBExists":[64],"isDBOpen":[64],"deleteDatabase":[64],"isStoreOpen":[64],"copyFromAssets":[64],"isTableExists":[64],"createSyncTable":[64],"getSyncDate":[64],"setSyncDate":[64],"isJsonValid":[64],"importFromJson":[64],"exportToJson":[64],"addUpgradeStatement":[64],"isDatabase":[64],"getDatabaseList":[64],"checkConnectionsConsistency":[64]}]]]], options);
+  return index.bootstrapLazy([["jeep-sqlite.cjs",[[1,"jeep-sqlite",{"echo":[64],"createConnection":[64],"closeConnection":[64],"open":[64],"close":[64],"getVersion":[64],"execute":[64],"executeSet":[64],"run":[64],"query":[64],"isDBExists":[64],"isDBOpen":[64],"deleteDatabase":[64],"isStoreOpen":[64],"copyFromAssets":[64],"isTableExists":[64],"createSyncTable":[64],"getSyncDate":[64],"setSyncDate":[64],"isJsonValid":[64],"importFromJson":[64],"exportToJson":[64],"addUpgradeStatement":[64],"isDatabase":[64],"getDatabaseList":[64],"checkConnectionsConsistency":[64],"saveToStore":[64]}]]]], options);
 });

dist/cjs/loader.cjs.js

@@ -17,3 +17,3 @@ 'use strict';
   return patchEsm().then(() => {
-  return index.bootstrapLazy([["jeep-sqlite.cjs",[[1,"jeep-sqlite",{"echo":[64],"createConnection":[64],"closeConnection":[64],"open":[64],"close":[64],"getVersion":[64],"execute":[64],"executeSet":[64],"run":[64],"query":[64],"isDBExists":[64],"isDBOpen":[64],"deleteDatabase":[64],"isStoreOpen":[64],"copyFromAssets":[64],"isTableExists":[64],"createSyncTable":[64],"getSyncDate":[64],"setSyncDate":[64],"isJsonValid":[64],"importFromJson":[64],"exportToJson":[64],"addUpgradeStatement":[64],"isDatabase":[64],"getDatabaseList":[64],"checkConnectionsConsistency":[64]}]]]], options);
+  return index.bootstrapLazy([["jeep-sqlite.cjs",[[1,"jeep-sqlite",{"echo":[64],"createConnection":[64],"closeConnection":[64],"open":[64],"close":[64],"getVersion":[64],"execute":[64],"executeSet":[64],"run":[64],"query":[64],"isDBExists":[64],"isDBOpen":[64],"deleteDatabase":[64],"isStoreOpen":[64],"copyFromAssets":[64],"isTableExists":[64],"createSyncTable":[64],"getSyncDate":[64],"setSyncDate":[64],"isJsonValid":[64],"importFromJson":[64],"exportToJson":[64],"addUpgradeStatement":[64],"isDatabase":[64],"getDatabaseList":[64],"checkConnectionsConsistency":[64],"saveToStore":[64]}]]]], options);
   });
@@ -20,0 +20,0 @@ };

dist/collection/components/jeep-sqlite/jeep-sqlite.js

@@ -10,2 +10,3 @@ import { Component, Method, Event } from '@stencil/core';
     this._dbDict = {};
+    this.databaseList = {};
     this._versionUpgrades = {};
@@ -20,2 +21,5 @@ }
   async createConnection(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     const keys = Object.keys(options);
@@ -36,2 +40,5 @@ if (!keys.includes('database')) {
   async closeConnection(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     const keys = Object.keys(options);
@@ -51,2 +58,5 @@ if (!keys.includes('database')) {
   async open(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     const keys = Object.keys(options);
@@ -66,2 +76,5 @@ if (!keys.includes('database')) {
   async close(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     const keys = Object.keys(options);
@@ -81,2 +94,5 @@ if (!keys.includes('database')) {
   async getVersion(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     const keys = Object.keys(options);
@@ -96,2 +112,5 @@ if (!keys.includes('database')) {
   async execute(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     let keys = Object.keys(options);
@@ -118,2 +137,5 @@ if (!keys.includes('database')) {
   async executeSet(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     let keys = Object.keys(options);
@@ -140,2 +162,5 @@ if (!keys.includes('database')) {
   async run(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     let keys = Object.keys(options);
@@ -166,2 +191,5 @@ if (!keys.includes('database')) {
   async query(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     let keys = Object.keys(options);
@@ -189,2 +217,5 @@ if (!keys.includes('database')) {
   async isDBExists(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     const keys = Object.keys(options);
@@ -204,2 +235,5 @@ if (!keys.includes('database')) {
   async isDBOpen(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     const keys = Object.keys(options);
@@ -219,2 +253,5 @@ if (!keys.includes('database')) {
   async deleteDatabase(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     const keys = Object.keys(options);
@@ -236,2 +273,5 @@ if (!keys.includes('database')) {
   async copyFromAssets() {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     try {
@@ -246,2 +286,5 @@ await this._copyFromAssets();
   async isTableExists(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     const keys = Object.keys(options);
@@ -265,2 +308,5 @@ if (!keys.includes('database')) {
   async createSyncTable(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     let keys = Object.keys(options);
@@ -280,2 +326,5 @@ if (!keys.includes('database')) {
   async getSyncDate(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     let keys = Object.keys(options);
@@ -295,2 +344,5 @@ if (!keys.includes('database')) {
   async setSyncDate(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     let keys = Object.keys(options);
@@ -328,2 +380,5 @@ if (!keys.includes('database')) {
   async importFromJson(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     const keys = Object.keys(options);
@@ -343,2 +398,5 @@ if (!keys.includes('jsonstring')) {
   async exportToJson(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     const keys = Object.keys(options);
@@ -362,2 +420,5 @@ if (!keys.includes('database')) {
   async addUpgradeStatement(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     let keys = Object.keys(options);
@@ -387,2 +448,5 @@ if (!keys.includes('database')) {
   async isDatabase(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     const keys = Object.keys(options);
@@ -402,2 +466,5 @@ if (!keys.includes('database')) {
   async getDatabaseList() {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     try {
@@ -412,2 +479,5 @@ const ret = await this._getDatabaseList();
   async checkConnectionsConsistency(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
     const keys = Object.keys(options);
@@ -426,2 +496,19 @@ if (!keys.includes('dbNames')) {
   }
+  async saveToStore(options) {
+    if (!this.isStore) {
+      return Promise.reject(`>>> jeep-sqlite StoreName: ${this.storeName} is not opened`);
+    }
+    const keys = Object.keys(options);
+    if (!keys.includes('database')) {
+      return Promise.reject('Must provide a database name');
+    }
+    const dbName = options.database;
+    try {
+      await this._saveToStore(dbName);
+      return Promise.resolve();
+    }
+    catch (err) {
+      return Promise.reject(err);
+    }
+  }
   //*******************************
@@ -432,7 +519,10 @@ //* Component Lifecycle Methods *
     this.isStore = await this.openStore("jeepSqliteStore", "databases");
-    const res = await this.loadJSON('assets/databases/databases.json');
-    this.databaseList = JSON.parse(res).databaseList;
   }
   componentDidLoad() {
-    console.log(`StoreName: ${this.storeName}`);
+    if (this.isStore) {
+      console.log(`>>> jeep-sqlite StoreName: ${this.storeName}`);
+    }
+    else {
+      console.log('>>> jeep-sqlite isStore = false');
+    }
   }
@@ -509,2 +599,16 @@ //******************************
   }
+  async _saveToStore(database) {
+    const keys = Object.keys(this._dbDict);
+    if (!keys.includes(database)) {
+      return Promise.reject(`SaveToStore: No available connection for ${database}`);
+    }
+    const mDB = this._dbDict[database];
+    try {
+      await mDB.saveToStore();
+      return Promise.resolve();
+    }
+    catch (err) {
+      return Promise.reject(`SaveToStore: ${err.message}`);
+    }
+  }
   async _getVersion(database) {
@@ -753,10 +857,23 @@ const keys = Object.keys(this._dbDict);
   async _copyFromAssets() {
-    try {
-      for (const dbName of this.databaseList) {
-        await this.copyDatabase(`assets/databases/${dbName}`);
+    const res = await this.loadJSON('assets/databases/databases.json');
+    if (res != null) {
+      this.databaseList = JSON.parse(res);
+      const keys = Object.keys(this.databaseList);
+      if (keys.includes("databaseList")) {
+        try {
+          for (const dbName of this.databaseList.databaseList) {
+            await this.copyDatabase(`assets/databases/${dbName}`);
+          }
+          return Promise.resolve();
+        }
+        catch (err) {
+          return Promise.reject(`CopyFromAssets: ${err.message}`);
+        }
       }
-      return Promise.resolve();
+      else {
+        return Promise.reject(`CopyFromAssets: no key databaseList in databases.json`);
+      }
     }
-    catch (err) {
-      return Promise.reject(`CopyFromAssets: ${err.message}`);
+    else {
+      return Promise.reject(`CopyFromAssets: no databases.json file in assets/databases folder`);
     }
@@ -877,2 +994,4 @@ }
       xobj.onreadystatechange = function () {
+        if (xobj.status == 404)
+          resolve(null);
         if (xobj.readyState == 4 && xobj.status == 200) {
@@ -1627,4 +1746,27 @@ // Required use of an anonymous callback as .open will NOT return a value but simply returns undefined in asynchronous mode
       }
+    },
+    "saveToStore": {
+      "complexType": {
+        "signature": "(options: SQLiteOptions) => Promise<void>",
+        "parameters": [{
+            "tags": [],
+            "text": ""
+          }],
+        "references": {
+          "Promise": {
+            "location": "global"
+          },
+          "SQLiteOptions": {
+            "location": "import",
+            "path": "../../interfaces/interfaces"
+          }
+        },
+        "return": "Promise<void>"
+      },
+      "docs": {
+        "text": "",
+        "tags": []
+      }
     }
   }; }
 }

dist/collection/utils/database.js

@@ -104,2 +104,14 @@ import initSqlJs from 'sql.js';
   }
+  async saveToStore() {
+    if (this.mDb != null && this._isDBOpen) {
+      try {
+        // save the database to store
+        await setDBToStore(this.mDb, this.dbName, this.store);
+      }
+      catch (err) {
+        return Promise.reject(`in saveToStore ${err}`);
+      }
+    }
+    return Promise.resolve();
+  }
   async getVersion() {
@@ -106,0 +118,0 @@ if (this.mDb != null && this._isDBOpen) {

dist/esm/jeep-sqlite.js

@@ -16,3 +16,3 @@ import { p as promiseResolve, b as bootstrapLazy } from './index-29e16b98.js';
 patchBrowser().then(options => {
-  return bootstrapLazy([["jeep-sqlite",[[1,"jeep-sqlite",{"echo":[64],"createConnection":[64],"closeConnection":[64],"open":[64],"close":[64],"getVersion":[64],"execute":[64],"executeSet":[64],"run":[64],"query":[64],"isDBExists":[64],"isDBOpen":[64],"deleteDatabase":[64],"isStoreOpen":[64],"copyFromAssets":[64],"isTableExists":[64],"createSyncTable":[64],"getSyncDate":[64],"setSyncDate":[64],"isJsonValid":[64],"importFromJson":[64],"exportToJson":[64],"addUpgradeStatement":[64],"isDatabase":[64],"getDatabaseList":[64],"checkConnectionsConsistency":[64]}]]]], options);
+  return bootstrapLazy([["jeep-sqlite",[[1,"jeep-sqlite",{"echo":[64],"createConnection":[64],"closeConnection":[64],"open":[64],"close":[64],"getVersion":[64],"execute":[64],"executeSet":[64],"run":[64],"query":[64],"isDBExists":[64],"isDBOpen":[64],"deleteDatabase":[64],"isStoreOpen":[64],"copyFromAssets":[64],"isTableExists":[64],"createSyncTable":[64],"getSyncDate":[64],"setSyncDate":[64],"isJsonValid":[64],"importFromJson":[64],"exportToJson":[64],"addUpgradeStatement":[64],"isDatabase":[64],"getDatabaseList":[64],"checkConnectionsConsistency":[64],"saveToStore":[64]}]]]], options);
 });

dist/esm/loader.js

@@ -13,3 +13,3 @@ import { p as promiseResolve, b as bootstrapLazy } from './index-29e16b98.js';
   return patchEsm().then(() => {
-  return bootstrapLazy([["jeep-sqlite",[[1,"jeep-sqlite",{"echo":[64],"createConnection":[64],"closeConnection":[64],"open":[64],"close":[64],"getVersion":[64],"execute":[64],"executeSet":[64],"run":[64],"query":[64],"isDBExists":[64],"isDBOpen":[64],"deleteDatabase":[64],"isStoreOpen":[64],"copyFromAssets":[64],"isTableExists":[64],"createSyncTable":[64],"getSyncDate":[64],"setSyncDate":[64],"isJsonValid":[64],"importFromJson":[64],"exportToJson":[64],"addUpgradeStatement":[64],"isDatabase":[64],"getDatabaseList":[64],"checkConnectionsConsistency":[64]}]]]], options);
+  return bootstrapLazy([["jeep-sqlite",[[1,"jeep-sqlite",{"echo":[64],"createConnection":[64],"closeConnection":[64],"open":[64],"close":[64],"getVersion":[64],"execute":[64],"executeSet":[64],"run":[64],"query":[64],"isDBExists":[64],"isDBOpen":[64],"deleteDatabase":[64],"isStoreOpen":[64],"copyFromAssets":[64],"isTableExists":[64],"createSyncTable":[64],"getSyncDate":[64],"setSyncDate":[64],"isJsonValid":[64],"importFromJson":[64],"exportToJson":[64],"addUpgradeStatement":[64],"isDatabase":[64],"getDatabaseList":[64],"checkConnectionsConsistency":[64],"saveToStore":[64]}]]]], options);
   });
@@ -16,0 +16,0 @@ };

dist/jeep-sqlite/jeep-sqlite.esm.js

@@ -1,1 +0,1 @@
-import{p as e,b as t}from"./p-6f7210ce.js";(()=>{const t=import.meta.url,s={};return""!==t&&(s.resourcesUrl=new URL(".",t).href),e(s)})().then((e=>t([["p-65bbac75",[[1,"jeep-sqlite",{echo:[64],createConnection:[64],closeConnection:[64],open:[64],close:[64],getVersion:[64],execute:[64],executeSet:[64],run:[64],query:[64],isDBExists:[64],isDBOpen:[64],deleteDatabase:[64],isStoreOpen:[64],copyFromAssets:[64],isTableExists:[64],createSyncTable:[64],getSyncDate:[64],setSyncDate:[64],isJsonValid:[64],importFromJson:[64],exportToJson:[64],addUpgradeStatement:[64],isDatabase:[64],getDatabaseList:[64],checkConnectionsConsistency:[64]}]]]],e)));
+import{p as e,b as t}from"./p-6f7210ce.js";(()=>{const t=import.meta.url,s={};return""!==t&&(s.resourcesUrl=new URL(".",t).href),e(s)})().then((e=>t([["p-2e9621e1",[[1,"jeep-sqlite",{echo:[64],createConnection:[64],closeConnection:[64],open:[64],close:[64],getVersion:[64],execute:[64],executeSet:[64],run:[64],query:[64],isDBExists:[64],isDBOpen:[64],deleteDatabase:[64],isStoreOpen:[64],copyFromAssets:[64],isTableExists:[64],createSyncTable:[64],getSyncDate:[64],setSyncDate:[64],isJsonValid:[64],importFromJson:[64],exportToJson:[64],addUpgradeStatement:[64],isDatabase:[64],getDatabaseList:[64],checkConnectionsConsistency:[64],saveToStore:[64]}]]]],e)));

dist/types/components.d.ts

@@ -36,2 +36,3 @@ /* eslint-disable */
         "run": (options: SQLiteRunOptions) => Promise<SQLiteChanges>;
+        "saveToStore": (options: SQLiteOptions) => Promise<void>;
         "setSyncDate": (options: SQLiteSyncDateOptions) => Promise<void>;
@@ -38,0 +39,0 @@ }

dist/types/components/jeep-sqlite/jeep-sqlite.d.ts

@@ -32,2 +32,3 @@ import { EventEmitter } from '../../stencil-public-runtime';
   checkConnectionsConsistency(options: AllConnectionsOptions): Promise<SQLiteResult>;
+  saveToStore(options: SQLiteOptions): Promise<void>;
   private store;
@@ -45,2 +46,3 @@ private storeName;
   private _close;
+  private _saveToStore;
   private _getVersion;
@@ -47,0 +49,0 @@ private _execute;

dist/types/utils/database.d.ts

@@ -14,2 +14,3 @@ import { EventEmitter } from '../stencil-public-runtime';
   close(): Promise<void>;
+  saveToStore(): Promise<void>;
   getVersion(): Promise<number>;
@@ -16,0 +17,0 @@ isDBExists(database: string): Promise<boolean>;

package.json

 {
   "name": "jeep-sqlite",
-  "version": "1.2.1",
+  "version": "1.3.0",
   "description": "Browser SQLite Stencil Component",
@@ -5,0 +5,0 @@ "main": "dist/index.cjs.js",

readme.md

@@ -73,2 +73,3 @@ ![Built With Stencil](https://img.shields.io/badge/-Built%20With%20Stencil-16161d.svg?logo=data%3Aimage%2Fsvg%2Bxml%3Bbase64%2CPD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0idXRmLTgiPz4KPCEtLSBHZW5lcmF0b3I6IEFkb2JlIElsbHVzdHJhdG9yIDE5LjIuMSwgU1ZHIEV4cG9ydCBQbHVnLUluIC4gU1ZHIFZlcnNpb246IDYuMDAgQnVpbGQgMCkgIC0tPgo8c3ZnIHZlcnNpb249IjEuMSIgaWQ9IkxheWVyXzEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgeG1sbnM6eGxpbms9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkveGxpbmsiIHg9IjBweCIgeT0iMHB4IgoJIHZpZXdCb3g9IjAgMCA1MTIgNTEyIiBzdHlsZT0iZW5hYmxlLWJhY2tncm91bmQ6bmV3IDAgMCA1MTIgNTEyOyIgeG1sOnNwYWNlPSJwcmVzZXJ2ZSI%2BCjxzdHlsZSB0eXBlPSJ0ZXh0L2NzcyI%2BCgkuc3Qwe2ZpbGw6I0ZGRkZGRjt9Cjwvc3R5bGU%2BCjxwYXRoIGNsYXNzPSJzdDAiIGQ9Ik00MjQuNywzNzMuOWMwLDM3LjYtNTUuMSw2OC42LTkyLjcsNjguNkgxODAuNGMtMzcuOSwwLTkyLjctMzAuNy05Mi43LTY4LjZ2LTMuNmgzMzYuOVYzNzMuOXoiLz4KPHBhdGggY2xhc3M9InN0MCIgZD0iTTQyNC43LDI5Mi4xSDE4MC40Yy0zNy42LDAtOTIuNy0zMS05Mi43LTY4LjZ2LTMuNkgzMzJjMzcuNiwwLDkyLjcsMzEsOTIuNyw2OC42VjI5Mi4xeiIvPgo8cGF0aCBjbGFzcz0ic3QwIiBkPSJNNDI0LjcsMTQxLjdIODcuN3YtMy42YzAtMzcuNiw1NC44LTY4LjYsOTIuNy02OC42SDMzMmMzNy45LDAsOTIuNywzMC43LDkyLjcsNjguNlYxNDEuN3oiLz4KPC9zdmc%2BCg%3D%3D&colorA=16161d&style=flat-square)
 | checkConnectionsConsistency | ✅      |
+| saveToStore                 | ✅      |
 
@@ -163,2 +164,4 @@
               }
+              // Save Database to store
+              await jeepSqlite.saveToStore({database: "testNew"});
               // Select all users
@@ -165,0 +168,0 @@ ret = await jeepSqlite.query({database: "testNew",

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

1530257

increased by1.52%

Lines of code

32917

increased by1.71%

Number of lines in readme file

674

increased by0.45%

No dependency changes