@capacitor-community/sqlite - npm Package Compare versions

Comparing version 2.9.10 to 2.9.11

CHANGELOG.md

@@ -0,1 +1,7 @@
+# 2.9.11 (2021-02-15) REFACTOR
+
+### Added Features
+
+- isDBOpen method
+
 # 2.9.10 (2021-02-14) REFACTOR
@@ -2,0 +8,0 @@

dist/esm/definitions.d.ts

@@ -82,2 +82,9 @@ declare module '@capacitor/core' {
     /**
+     * Check if a SQLite database is opened
+     * @param options: capSQLiteOptions
+     * @returns Promise<capSQLiteResult>
+     * @since 2.9.11
+     */
+    isDBOpen(options: capSQLiteOptions): Promise<capSQLiteResult>;
+    /**
      * Check if a SQLite database exists without connection
@@ -699,2 +706,9 @@ * @param options: capSQLiteOptions
     /**
+     * Check if a SQLite database is opened
+     * @param options: capSQLiteOptions
+     * @returns Promise<capSQLiteResult>
+     * @since 2.9.11
+     */
+    isDBOpen(options: capSQLiteOptions): Promise<capSQLiteResult>;
+    /**
      * Delete a SQLite DB Connection
@@ -748,2 +762,3 @@ * @returns Promise<capSQLiteResult>
     isTable(table: string): Promise<capSQLiteResult>;
+    isDBOpen(): Promise<capSQLiteResult>;
     delete(): Promise<capSQLiteResult>;
@@ -750,0 +765,0 @@ createSyncTable(): Promise<capSQLiteChanges>;

dist/esm/definitions.js

@@ -238,2 +238,10 @@ var __awaiter = (this && this.__awaiter) || function (thisArg, _arguments, P, generator) {
     }
+    isDBOpen() {
+        return __awaiter(this, void 0, void 0, function* () {
+            const res = yield this.sqlite.isDBOpen({
+                database: this.dbName,
+            });
+            return res;
+        });
+    }
     delete() {
@@ -240,0 +248,0 @@ return __awaiter(this, void 0, void 0, function* () {

dist/esm/web.d.ts

@@ -15,2 +15,3 @@ import { WebPlugin } from '@capacitor/core';
     isDBExists(options: capSQLiteOptions): Promise<capSQLiteResult>;
+    isDBOpen(options: capSQLiteOptions): Promise<capSQLiteResult>;
     isDatabase(options: capSQLiteOptions): Promise<capSQLiteResult>;
@@ -17,0 +18,0 @@ isTableExists(options: capSQLiteTableOptions): Promise<capSQLiteResult>;

dist/esm/web.js

@@ -105,2 +105,11 @@ var __awaiter = (this && this.__awaiter) || function (thisArg, _arguments, P, generator) {
     }
+    isDBOpen(options) {
+        return __awaiter(this, void 0, void 0, function* () {
+            console.log('in Web isDBOpen', options);
+            return Promise.resolve({
+                result: false,
+                message: `Not implemented on Web Platform`,
+            });
+        });
+    }
     isDatabase(options) {
@@ -107,0 +116,0 @@ return __awaiter(this, void 0, void 0, function* () {

dist/plugin.js

@@ -241,2 +241,10 @@ var capacitorPlugin = (function (exports, core) {
         }
+        isDBOpen() {
+            return __awaiter(this, void 0, void 0, function* () {
+                const res = yield this.sqlite.isDBOpen({
+                    database: this.dbName,
+                });
+                return res;
+            });
+        }
         delete() {
@@ -389,2 +397,11 @@ return __awaiter(this, void 0, void 0, function* () {
         }
+        isDBOpen(options) {
+            return __awaiter$1(this, void 0, void 0, function* () {
+                console.log('in Web isDBOpen', options);
+                return Promise.resolve({
+                    result: false,
+                    message: `Not implemented on Web Platform`,
+                });
+            });
+        }
         isDatabase(options) {
@@ -391,0 +408,0 @@ return __awaiter$1(this, void 0, void 0, function* () {

electron/dist/esm/electron/src/plugin.d.ts

@@ -22,2 +22,3 @@ import { WebPlugin } from '@capacitor/core';
     isDBExists(options: capSQLiteOptions): Promise<capSQLiteResult>;
+    isDBOpen(options: capSQLiteOptions): Promise<capSQLiteResult>;
     isDatabase(options: capSQLiteOptions): Promise<capSQLiteResult>;
@@ -24,0 +25,0 @@ isTableExists(options: capSQLiteTableOptions): Promise<capSQLiteResult>;

electron/dist/esm/electron/src/plugin.js

@@ -370,2 +370,24 @@ import { __awaiter } from "tslib";
     }
+    isDBOpen(options) {
+        return __awaiter(this, void 0, void 0, function* () {
+            let keys = Object.keys(options);
+            if (!keys.includes('database')) {
+                return Promise.resolve({
+                    result: false,
+                    message: 'Must provide a database name',
+                });
+            }
+            const dbName = options.database;
+            keys = Object.keys(this._dbDict);
+            if (!keys.includes(dbName)) {
+                return Promise.resolve({
+                    result: false,
+                    message: `isDBOpen: No available connection for ${dbName}`,
+                });
+            }
+            const mDB = this._dbDict[dbName];
+            const isOpen = yield mDB.isDBOpen();
+            return Promise.resolve({ result: isOpen });
+        });
+    }
     isDatabase(options) {
@@ -372,0 +394,0 @@ return __awaiter(this, void 0, void 0, function* () {

electron/dist/esm/src/definitions.d.ts

@@ -82,2 +82,9 @@ declare module '@capacitor/core' {
     /**
+     * Check if a SQLite database is opened
+     * @param options: capSQLiteOptions
+     * @returns Promise<capSQLiteResult>
+     * @since 2.9.11
+     */
+    isDBOpen(options: capSQLiteOptions): Promise<capSQLiteResult>;
+    /**
      * Check if a SQLite database exists without connection
@@ -699,2 +706,9 @@ * @param options: capSQLiteOptions
     /**
+     * Check if a SQLite database is opened
+     * @param options: capSQLiteOptions
+     * @returns Promise<capSQLiteResult>
+     * @since 2.9.11
+     */
+    isDBOpen(options: capSQLiteOptions): Promise<capSQLiteResult>;
+    /**
      * Delete a SQLite DB Connection
@@ -748,2 +762,3 @@ * @returns Promise<capSQLiteResult>
     isTable(table: string): Promise<capSQLiteResult>;
+    isDBOpen(): Promise<capSQLiteResult>;
     delete(): Promise<capSQLiteResult>;
@@ -750,0 +765,0 @@ createSyncTable(): Promise<capSQLiteChanges>;

electron/dist/esm/src/definitions.js

@@ -230,2 +230,10 @@ import { __awaiter } from "tslib";
     }
+    isDBOpen() {
+        return __awaiter(this, void 0, void 0, function* () {
+            const res = yield this.sqlite.isDBOpen({
+                database: this.dbName,
+            });
+            return res;
+        });
+    }
     delete() {
@@ -232,0 +240,0 @@ return __awaiter(this, void 0, void 0, function* () {

electron/src/plugin.ts

@@ -395,2 +395,23 @@ import { WebPlugin } from '@capacitor/core';
   }
+  async isDBOpen(options: capSQLiteOptions): Promise<capSQLiteResult> {
+    let keys = Object.keys(options);
+    if (!keys.includes('database')) {
+      return Promise.resolve({
+        result: false,
+        message: 'Must provide a database name',
+      });
+    }
+    const dbName: string = options.database!;
+    keys = Object.keys(this._dbDict);
+    if (!keys.includes(dbName)) {
+      return Promise.resolve({
+        result: false,
+        message: `isDBOpen: No available connection for ${dbName}`,
+      });
+    }
+    const mDB = this._dbDict[dbName];
+    const isOpen: boolean = await mDB.isDBOpen();
+    return Promise.resolve({ result: isOpen });
+  }
+
   async isDatabase(options: capSQLiteOptions): Promise<capSQLiteResult> {
@@ -397,0 +418,0 @@ let keys = Object.keys(options);

package.json

 {
   "name": "@capacitor-community/sqlite",
-  "version": "2.9.10",
+  "version": "2.9.11",
   "description": "Capacitor SQLite Plugin",
@@ -5,0 +5,0 @@ "homepage": "https://github.com/capacitor-community/sqlite",

README.md

@@ -230,2 +230,3 @@ <p align="center"><br><img src="https://user-images.githubusercontent.com/236501/85893648-1c92e880-b7a8-11ea-926d-95355b8175c7.png" width="128" height="128" /></p>
 | copyFromAssets          | ✅      | ✅  | ✅           | ✅               | ❌  |
+| isDBOpen                | ✅      | ✅  | ✅           | ✅               | ❌  |
 | isDatabase              | ✅      | ✅  | ✅           | ✅               | ❌  |
@@ -232,0 +233,0 @@ | isTableExists           | ✅      | ✅  | ✅           | ✅               | ❌  |

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

2968022

increased by0.39%

Lines of code

18060

increased by0.82%

Number of lines in readme file

310

increased by0.32%

No dependency changes