sqlite3-tab - npm Package Compare versions

Comparing version 1.2.0 to 2.0.0

debug_output.txt

+(node:19716) [DEP0169] DeprecationWarning: `url.parse()` behavior is not standardized and prone to errors that have security implications. Use the WHATWG URL API instead. CVEs are not issued for `url.parse()` vulnerabilities.
+(Use `node --trace-deprecation ...` to show where the warning was created)
+DEBUG: this._caheTablas is: {}
+DEBUG: this._caheTablas is: {}
+DEBUG: this._caheTablas is: {}
+ÔûÂ Test de la clase sqlite3-tab :tabla
+  Ô£ö obtencion del objeto dbtabla (2.7158ms)
+  Ô£û obtencion del objeto dbtabla async (1.5459ms)
+  Ô£û dbTabla:insert (0.811ms)
+DEBUG: this._caheTablas is: {}
+  Ô£û dbTabla:select (8.1771ms)
+DEBUG: this._caheTablas is: {}
+  Ô£û dbTabla:update (1.9643ms)
+DEBUG: this._caheTablas is: {}
+DEBUG: this._caheTablas is: {}
+DEBUG: this._caheTablas is: {}
+DEBUG: this._caheTablas is: {}
+  Ô£û dbTabla:delete (2.6034ms)
+  Ô£û load model test3 (2.9902ms)
+  Ô£û load model test4 (0.6257ms)
+  Ô£û silumacion de AUTO_INCREMENT usando modelos (2.7956ms)
+Ô£û Test de la clase sqlite3-tab :tabla (26.451ms)
+Ôä╣ tests 9
+Ôä╣ suites 1
+Ôä╣ pass 1
+Ôä╣ fail 8
+Ôä╣ cancelled 0
+Ôä╣ skipped 0
+Ôä╣ todo 0
+Ôä╣ duration_ms 224.1749
+
+Ô£û failing tests:
+
+test at test\dbTabla.js:31:5
+Ô£û obtencion del objeto dbtabla async (1.5459ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at new dbTabla (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:31:18)
+      at new sqlite3Tabla (C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:9:1)
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:55:43)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:39:20
+      at new Promise (<anonymous>)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:35:17)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)
+
+test at test\dbTabla.js:48:5
+Ô£û dbTabla:insert (0.811ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:46:18
+      at new Promise (<anonymous>)
+      at sqlite3Tabla.insert (C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:44:16)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:53:22)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)
+      at Test.postRun (node:internal/test_runner/test:1247:19)
+      at Test.run (node:internal/test_runner/test:1175:12)
+
+test at test\dbTabla.js:60:5
+Ô£û dbTabla:select (8.1771ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:161:18
+      at new Promise (<anonymous>)
+      at sqlite3Tabla.select (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:159:16)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:65:23
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:18:35
+
+test at test\dbTabla.js:78:5
+Ô£û dbTabla:update (1.9643ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:114:18
+      at new Promise (<anonymous>)
+      at sqlite3Tabla.update (C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:112:16)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:83:36
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:18:35
+
+test at test\dbTabla.js:94:5
+Ô£û dbTabla:delete (2.6034ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:387:18
+      at new Promise (<anonymous>)
+      at sqlite3Tabla.delete (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:385:16)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:99:29
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:18:35
+
+test at test\dbTabla.js:106:5
+Ô£û load model test3 (2.9902ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at new dbTabla (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:31:18)
+      at new sqlite3Tabla (C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:9:1)
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:55:43)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:113:25
+      at new Promise (<anonymous>)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:108:17)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)
+
+test at test\dbTabla.js:128:5
+Ô£û load model test4 (0.6257ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at new dbTabla (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:31:18)
+      at new sqlite3Tabla (C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:9:1)
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:55:43)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:135:25
+      at new Promise (<anonymous>)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:130:17)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)
+
+test at test\dbTabla.js:149:5
+Ô£û silumacion de AUTO_INCREMENT usando modelos (2.7956ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:46:18
+      at new Promise (<anonymous>)
+      at sqlite3Tabla.insert (C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:44:16)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:156:25
+      at new Promise (<anonymous>)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:151:17)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)

eslint.config.js

+const js = require("@eslint/js");
+const globals = require("globals");
+
+module.exports = [
+    js.configs.recommended,
+    {
+        languageOptions: {
+            ecmaVersion: 2024,
+            sourceType: "module",
+            globals: {
+                ...globals.node
+            }
+        },
+        rules: {
+            "indent": ["error", 4],
+            "quotes": ["error", "double"],
+            "semi": ["error", "never"]
+        }
+    }
+];

test_dbTabla_err.txt

+(node:8432) [DEP0169] DeprecationWarning: `url.parse()` behavior is not standardized and prone to errors that have security implications. Use the WHATWG URL API instead. CVEs are not issued for `url.parse()` vulnerabilities.
+(Use `node --trace-deprecation ...` to show where the warning was created)
+ÔûÂ Test de la clase sqlite3-tab :tabla
+  Ô£û obtencion del objeto dbtabla (2.0764ms)
+  Ô£û obtencion del objeto dbtabla async (0.8769ms)
+  Ô£û dbTabla:insert (0.4015ms)
+  Ô£û dbTabla:select (8.6738ms)
+  Ô£û dbTabla:update (1.8362ms)
+  Ô£û dbTabla:delete (1.7842ms)
+  Ô£û load model test3 (2.2726ms)
+  Ô£û load model test4 (0.7059ms)
+  Ô£û silumacion de AUTO_INCREMENT usando modelos (3.3276ms)
+Ô£û Test de la clase sqlite3-tab :tabla (23.8058ms)
+Ôä╣ tests 9
+Ôä╣ suites 1
+Ôä╣ pass 0
+Ôä╣ fail 9
+Ôä╣ cancelled 0
+Ôä╣ skipped 0
+Ôä╣ todo 0
+Ôä╣ duration_ms 225.6019
+
+Ô£û failing tests:
+
+test at test\dbTabla.js:24:5
+Ô£û obtencion del objeto dbtabla (2.0764ms)
+  TypeError: Cannot read properties of undefined (reading 'test1')
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:49:35)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:27:26)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Test.start (node:internal/test_runner/test:1015:17)
+      at node:internal/test_runner/test:1531:71
+      at node:internal/per_context/primordials:466:82
+      at new Promise (<anonymous>)
+      at new SafePromise (node:internal/per_context/primordials:435:3)
+      at node:internal/per_context/primordials:466:9
+
+test at test\dbTabla.js:31:5
+Ô£û obtencion del objeto dbtabla async (0.8769ms)
+  TypeError: Cannot read properties of undefined (reading 'test1')
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:49:35)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:39:20
+      at new Promise (<anonymous>)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:35:17)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)
+      at Test.postRun (node:internal/test_runner/test:1247:19)
+      at Test.run (node:internal/test_runner/test:1175:12)
+      at process.processTicksAndRejections (node:internal/process/task_queues:104:5)
+
+test at test\dbTabla.js:48:5
+Ô£û dbTabla:insert (0.4015ms)
+  TypeError: Cannot read properties of undefined (reading 'test1')
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:49:35)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:52:26)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)
+      at Test.postRun (node:internal/test_runner/test:1247:19)
+      at Test.run (node:internal/test_runner/test:1175:12)
+      at process.processTicksAndRejections (node:internal/process/task_queues:104:5)
+      at async Suite.processPendingSubtests (node:internal/test_runner/test:787:7)
+
+test at test\dbTabla.js:60:5
+Ô£û dbTabla:select (8.6738ms)
+  TypeError: Cannot read properties of undefined (reading 'test1')
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:49:35)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:64:34
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:18:35
+
+test at test\dbTabla.js:78:5
+Ô£û dbTabla:update (1.8362ms)
+  TypeError: Cannot read properties of undefined (reading 'test1')
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:49:35)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:82:34
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:18:35
+
+test at test\dbTabla.js:94:5
+Ô£û dbTabla:delete (1.7842ms)
+  TypeError: Cannot read properties of undefined (reading 'test1')
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:49:35)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:98:34
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:18:35
+
+test at test\dbTabla.js:106:5
+Ô£û load model test3 (2.2726ms)
+  TypeError: Cannot read properties of undefined (reading 'test3')
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:49:35)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:113:25
+      at new Promise (<anonymous>)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:108:17)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)
+      at Test.postRun (node:internal/test_runner/test:1247:19)
+      at Test.run (node:internal/test_runner/test:1175:12)
+      at async Suite.processPendingSubtests (node:internal/test_runner/test:787:7)
+
+test at test\dbTabla.js:128:5
+Ô£û load model test4 (0.7059ms)
+  TypeError: Cannot read properties of undefined (reading 'test4')
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:49:35)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:135:25
+      at new Promise (<anonymous>)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:130:17)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)
+      at Test.postRun (node:internal/test_runner/test:1247:19)
+      at Test.run (node:internal/test_runner/test:1175:12)
+      at async Suite.processPendingSubtests (node:internal/test_runner/test:787:7)
+
+test at test\dbTabla.js:149:5
+Ô£û silumacion de AUTO_INCREMENT usando modelos (3.3276ms)
+  TypeError: Cannot read properties of undefined (reading 'test4')
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:49:35)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:155:30
+      at new Promise (<anonymous>)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:151:17)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)
+      at Test.postRun (node:internal/test_runner/test:1247:19)
+      at Test.run (node:internal/test_runner/test:1175:12)
+      at async Suite.processPendingSubtests (node:internal/test_runner/test:787:7)

test_err.txt

+(node:7844) [DEP0169] DeprecationWarning: `url.parse()` behavior is not standardized and prone to errors that have security implications. Use the WHATWG URL API instead. CVEs are not issued for `url.parse()` vulnerabilities.
+(Use `node --trace-deprecation ...` to show where the warning was created)
+ÔûÂ Test de la clase sqlite3-tab
+  Ô£ö verificacion de metodos (2.3736ms)
+  Ô£ö metodo query (4.2767ms)
+Ô£ö Test de la clase sqlite3-tab (7.769ms)
+Ôä╣ tests 2
+Ôä╣ suites 1
+Ôä╣ pass 2
+Ôä╣ fail 0
+Ôä╣ cancelled 0
+Ôä╣ skipped 0
+Ôä╣ todo 0
+Ôä╣ duration_ms 206.5416

test_output.txt

+C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:93
+    }
+    ^
+
+SyntaxError: Identifier '#insert' has already been declared
+    at wrapSafe (node:internal/modules/cjs/loader:1743:18)
+    at Module._compile (node:internal/modules/cjs/loader:1786:20)
+    at Object..js (node:internal/modules/cjs/loader:1943:10)
+    at Module.load (node:internal/modules/cjs/loader:1533:32)
+    at Module._load (node:internal/modules/cjs/loader:1335:12)
+    at wrapModuleLoad (node:internal/modules/cjs/loader:255:19)
+    at Module.require (node:internal/modules/cjs/loader:1556:12)
+    at require (node:internal/modules/helpers:152:16)
+    at Object.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:2:20)
+    at Module._compile (node:internal/modules/cjs/loader:1812:14)
+
+Node.js v24.14.0
+Ô£û test\sqlite3Tab.js (257.3436ms)
+Ôä╣ tests 1
+Ôä╣ suites 0
+Ôä╣ pass 0
+Ôä╣ fail 1
+Ôä╣ cancelled 0
+Ôä╣ skipped 0
+Ôä╣ todo 0
+Ôä╣ duration_ms 269.5554
+
+Ô£û failing tests:
+
+test at test\sqlite3Tab.js:1:1
+Ô£û test\sqlite3Tab.js (257.3436ms)
+  'test failed'

test_results.txt

+(node:12360) [DEP0169] DeprecationWarning: `url.parse()` behavior is not standardized and prone to errors that have security implications. Use the WHATWG URL API instead. CVEs are not issued for `url.parse()` vulnerabilities.
+(Use `node --trace-deprecation ...` to show where the warning was created)
+DEBUG: this._caheTablas is: {}
+DEBUG: this._caheTablas is: {}
+DEBUG: this._caheTablas is: {}
+ÔûÂ Test de la clase sqlite3-tab :tabla
+  Ô£ö obtencion del objeto dbtabla (2.5525ms)
+  Ô£û obtencion del objeto dbtabla async (0.9541ms)
+  Ô£û dbTabla:insert (0.7161ms)
+DEBUG: this._caheTablas is: {}
+  Ô£û dbTabla:select (8.0682ms)
+DEBUG: this._caheTablas is: {}
+  Ô£û dbTabla:update (2.2288ms)
+DEBUG: this._caheTablas is: {}
+DEBUG: this._caheTablas is: {}
+DEBUG: this._caheTablas is: {}
+DEBUG: this._caheTablas is: {}
+  Ô£û dbTabla:delete (2.044ms)
+  Ô£û load model test3 (2.4251ms)
+  Ô£û load model test4 (0.703ms)
+  Ô£û silumacion de AUTO_INCREMENT usando modelos (2.8793ms)
+Ô£û Test de la clase sqlite3-tab :tabla (24.3952ms)
+Ôä╣ tests 9
+Ôä╣ suites 1
+Ôä╣ pass 1
+Ôä╣ fail 8
+Ôä╣ cancelled 0
+Ôä╣ skipped 0
+Ôä╣ todo 0
+Ôä╣ duration_ms 356.9476
+
+Ô£û failing tests:
+
+test at test\dbTabla.js:31:5
+Ô£û obtencion del objeto dbtabla async (0.9541ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at new dbTabla (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:31:18)
+      at new sqlite3Tabla (C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:9:1)
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:54:43)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:39:20
+      at new Promise (<anonymous>)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:35:17)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)
+
+test at test\dbTabla.js:48:5
+Ô£û dbTabla:insert (0.7161ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:46:18
+      at new Promise (<anonymous>)
+      at sqlite3Tabla.insert (C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:44:16)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:53:22)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)
+      at Test.postRun (node:internal/test_runner/test:1247:19)
+      at Test.run (node:internal/test_runner/test:1175:12)
+
+test at test\dbTabla.js:60:5
+Ô£û dbTabla:select (8.0682ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:161:18
+      at new Promise (<anonymous>)
+      at sqlite3Tabla.select (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:159:16)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:65:23
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:18:35
+
+test at test\dbTabla.js:78:5
+Ô£û dbTabla:update (2.2288ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:114:18
+      at new Promise (<anonymous>)
+      at sqlite3Tabla.update (C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:112:16)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:83:36
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:18:35
+
+test at test\dbTabla.js:94:5
+Ô£û dbTabla:delete (2.044ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:387:18
+      at new Promise (<anonymous>)
+      at sqlite3Tabla.delete (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:385:16)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:99:29
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:18:35
+
+test at test\dbTabla.js:106:5
+Ô£û load model test3 (2.4251ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at new dbTabla (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:31:18)
+      at new sqlite3Tabla (C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:9:1)
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:54:43)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:113:25
+      at new Promise (<anonymous>)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:108:17)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)
+
+test at test\dbTabla.js:128:5
+Ô£û load model test4 (0.703ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at new dbTabla (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:31:18)
+      at new sqlite3Tabla (C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:9:1)
+      at sqlite3Tab.tabla (C:\programacion\dbtabla\sqlite3-tab\sqlite3-tab.js:54:43)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:135:25
+      at new Promise (<anonymous>)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:130:17)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)
+
+test at test\dbTabla.js:149:5
+Ô£û silumacion de AUTO_INCREMENT usando modelos (2.8793ms)
+  TypeError: this._connection.__keysInTable is not a function
+      at sqlite3Tabla._verifyKeys (C:\programacion\dbtabla\sqlite3-tab\node_modules\dbtabla\lib\dbTabla.js:57:30)
+      at C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:46:18
+      at new Promise (<anonymous>)
+      at sqlite3Tabla.insert (C:\programacion\dbtabla\sqlite3-tab\lib\sqlite3Tabla.js:44:16)
+      at C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:156:25
+      at new Promise (<anonymous>)
+      at TestContext.<anonymous> (C:\programacion\dbtabla\sqlite3-tab\test\dbTabla.js:151:17)
+      at Test.runInAsyncScope (node:async_hooks:228:14)
+      at Test.run (node:internal/test_runner/test:1118:25)
+      at Suite.processPendingSubtests (node:internal/test_runner/test:787:18)

.eslintrc.js

@@ -9,3 +9,3 @@ module.exports = {
     "parserOptions": {
-        "ecmaVersion": 2018,
+        "ecmaVersion": 2024,
         "sourceType": "module"
@@ -12,0 +12,0 @@ },

lib/sqlite3Ok.js

@@ -13,5 +13,5 @@ /**
     {
-        this.$sql=dbtabla.__lastSql
+        this.$sql=dbtabla._lastSql
     }
 }
 module.exports=sqlite3Ok

lib/sqlite3Result.js

@@ -1,2 +0,2 @@
-const dbResult= require("dbtabla/lib/dbResult")
+const { dbResult } = require("dbtabla")
 
@@ -3,0 +3,0 @@ /**

lib/sqlite3Tabla.js

 const dbTabla=require("dbtabla")
 const sqlite3Result=require("./sqlite3Result")
 const sqlite3Ok=require("./sqlite3Ok")
-const dbTablaError=require("dbTabla/lib/dbTablaError")
+const { dbTablaError } = require("dbtabla")
 /**
@@ -9,4 +9,3 @@ * sqlite3Tabla
 */
-class sqlite3Tabla extends dbTabla
-{
+class sqlite3Tabla extends dbTabla {
     /**
@@ -17,3 +16,3 @@ * construlle el objeto de resultado para consultas select
     */
-    __formatResult(result)
+    _formatResult(result)
     {
@@ -27,3 +26,3 @@ return new sqlite3Result(this,result)
     */
-    __PropertyOk(ok)
+    _PropertyOk(ok)
     {
@@ -50,3 +49,3 @@ let retOk=new sqlite3Ok(this,ok)
         {
-            this.__verifyKeys(e=> 
+            this._verifyKeys(e=> 
             {
@@ -64,9 +63,9 @@ if(e)
                 {
-                    this.__connection.get(`SELECT max(${this.sql.autoincrement}) as autoincrement_value FROM ${this.tabla}`)
+                    this._connection.get(`SELECT max(${this.sql.autoincrement}) as autoincrement_value FROM ${this.tabla}`)
                         .then(row=>
                         {
                             this.sql.nextAutoincrementValue=Number(row.autoincrement_value)+1
-                            this.__insert(params).then(d=>{
+                            this.#insert(params).then(d=>{
                                 this.sql.nextAutoincrementValue=undefined
-                                res(this.__PropertyOk(d))
+                                res(this._PropertyOk(d))
                             }).catch(e=>
@@ -80,3 +79,3 @@ {
                 {
-                    this.__insert(params).then(d=>res(this.__PropertyOk(d))).catch(e=>rej(e))
+                    this.#insert(params).then(d=>res(this._PropertyOk(d))).catch(e=>rej(e))
                 }
@@ -86,3 +85,3 @@ })
     }
-    __insert(params)
+    #insert(params)
     {
@@ -92,5 +91,5 @@ this.sql.activeSmt(true)
         {
-            this.__lastSql=this.sql.insert(params[0])
+            this._lastSql=this.sql.insert(params[0])
         }else{
-            this.__lastSql=this.sql.insert(params)
+            this._lastSql=this.sql.insert(params)
         }
@@ -100,3 +99,3 @@ let data = this.sql.getDataSmt()
         this.sql.activeSmt(false)
-        return this.__connection.query(this.__lastSql,data)
+        return this._connection.query(this._lastSql,data)
     }
@@ -124,3 +123,3 @@ /**
         {
-            this.__verifyKeys(e=>
+            this._verifyKeys(e=>
             {
@@ -132,10 +131,10 @@ if(e)
                 this.sql.activeSmt(true)
-                this.__lastSql =this.sql.update(sets,where,reject)
+                this._lastSql =this.sql.update(sets,where,reject)
                 let data = this.sql.getDataSmt()
                 this.sql.resetDataSmt()
                 this.sql.activeSmt(false)
-                if(this.__lastSql)
+                if(this._lastSql)
                 {
-                    this.__connection.query(this.__lastSql,data).then(d=>{
-                        resolve(this.__PropertyOk(d))
+                    this._connection.query(this._lastSql,data).then(d=>{
+                        resolve(this._PropertyOk(d))
                     }).catch(e=>reject(e))
@@ -142,0 +141,0 @@ }

package.json

 {
   "name": "sqlite3-tab",
-  "version": "1.2.0",
+  "version": "2.0.0",
   "description": "interface de alto nivel para consultas sqlite3",
@@ -11,4 +11,4 @@ "main": "sqlite3-tab.js",
   "scripts": {
-    "test": "mocha ./test/index.js ",
-    "lint": "eslint ./sqlite3-tab.js ./lib"
+    "test": "node --test ./test/index.js",
+    "lint": "eslint ."
   },
@@ -21,7 +21,14 @@ "keywords": [
   "license": "MIT",
-  "devDependencies": {},
+  "devDependencies": {
+    "@eslint/js": "^10.0.1",
+    "eslint": "^10.1.0",
+    "globals": "^17.4.0"
+  },
   "dependencies": {
-    "dbtabla": "^0.8.8",
-    "sqlite3": "^5.0.2"
+    "dbtabla": "^2.1.2",
+    "sqlite3": "^6.0.1"
+  },
+  "engines": {
+    "node": ">=18.0.0"
   }
 }

sqlite3-tab.js

@@ -26,5 +26,4 @@ const sqlite3=require("sqlite3").verbose()
         }
-        this.__escapeChar="`"
-        this.__information_schema = "select sqlite_master.* from sqlite_master where  name="
-        sqlite3Tab.__caheTablas={}
+        this._escapeChar="`"
+        this._information_schema = "select sqlite_master.* from sqlite_master where  name="
     }
@@ -50,8 +49,9 @@ serialize(call)
             verify=callback
-        if(typeof this.__caheTablas[tabla]!=="undefined")
+        console.log('DEBUG: this._caheTablas is:', this._caheTablas);
+        if(typeof this._caheTablas[tabla]!=="undefined")
         {
-            typeof callback==="function"?callback(this.__caheTablas[tabla]):null
-            return this.__caheTablas[tabla]
+            typeof callback==="function"?callback(this._caheTablas[tabla]):null
+            return this._caheTablas[tabla]
         }
-        return  this.__caheTablas[tabla] = new sqlite3Tabla({
+        return  this._caheTablas[tabla] = new sqlite3Tabla({
             tabla:tabla,
@@ -170,7 +170,7 @@ connection:this,
     */
-    __keysInTable(table)
+    _keysInTable(table)
     {
         return new Promise((res,rej)=>
         {
-            this.query(`${this.__information_schema}'${table}'`)
+            this.query(`${this._information_schema}'${table}'`)
                 .then(result=>{
@@ -185,3 +185,3 @@ this.inModel(table,result.length==0)
                                 else
-                                    res((new model(result[0].sql,this.__escapeChar)).getData())
+                                    res((new model(result[0].sql,this._escapeChar)).getData())
                             }else
@@ -188,0 +188,0 @@ {

New alerts

Long strings

Supply chain risk

Contains long string literals, which may be a sign of obfuscated or packed code.

Found 1 instance in 1 package

Fixed alerts

Long strings

Supply chain risk

Contains long string literals, which may be a sign of obfuscated or packed code.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

6549472

0.37%

Number of package files

16

60%

Lines of code

406

4.64%

Worsened metrics

Dev dependency count

3

Infinity%

Dependency changes

• + Added

  @gar/promise-retry@1.0.3
  (transitive)

• + Added

  @isaacs/fs-minipass@4.0.1
  (transitive)

• + Added

  @npmcli/agent@4.0.0
  (transitive)

• + Added

  @npmcli/fs@5.0.0
  (transitive)

• + Added

  @npmcli/redact@4.0.0
  (transitive)

• + Added

  abbrev@4.0.0
  (transitive)

• + Added

  agent-base@7.1.4
  (transitive)

• + Added

  balanced-match@4.0.4
  (transitive)

• + Added

  brace-expansion@5.0.5
  (transitive)

• + Added

  cacache@20.0.4
  (transitive)

• + Added

  chownr@3.0.0
  (transitive)

• + Added

  dbtabla@2.2.2
  (transitive)

• + Added

  exponential-backoff@3.1.3
  (transitive)

• + Added

  fdir@6.5.0
  (transitive)

• + Added

  fs-minipass@3.0.3
  (transitive)

• + Added

  glob@13.0.6
  (transitive)

• + Added

  http-proxy-agent@7.0.2
  (transitive)

• + Added

  https-proxy-agent@7.0.6
  (transitive)

• + Added

  iconv-lite@0.7.2
  (transitive)

• + Added

  isexe@4.0.0
  (transitive)

• + Added

  lru-cache@11.3.5
  (transitive)

• + Added

  make-fetch-happen@15.0.5
  (transitive)

• + Added

  minimatch@10.2.5
  (transitive)

• + Added

  minipass@7.1.3
  (transitive)

• + Added

  minipass-collect@2.0.1
  (transitive)

• + Added

  minipass-fetch@5.0.2
  (transitive)

• + Added

  minipass-sized@2.0.0
  (transitive)

• + Added

  minizlib@3.1.0
  (transitive)

• + Added

  negotiator@1.0.0
  (transitive)

• + Added

  node-addon-api@8.7.0
  (transitive)

• + Added

  node-gyp@12.2.0
  (transitive)

• + Added

  nopt@9.0.0
  (transitive)

• + Added

  p-map@7.0.4
  (transitive)

• + Added

  path-scurry@2.0.2
  (transitive)

• + Added

  picomatch@4.0.4
  (transitive)

• + Added

  proc-log@6.1.0
  (transitive)

• + Added

  socks-proxy-agent@8.0.5
  (transitive)

• + Added

  sqlite3@6.0.1
  (transitive)

• + Added

  ssri@13.0.1
  (transitive)

• + Added

  tabla-model@2.0.0
  (transitive)

• + Added

  tar@7.5.13
  (transitive)

• + Added

  tinyglobby@0.2.16
  (transitive)

• + Added

  which@6.0.1
  (transitive)

• + Added

  yallist@5.0.0
  (transitive)

• - Removed

  @gar/promisify@1.1.3
  (transitive)

• - Removed

  @npmcli/fs@1.1.1
  (transitive)

• - Removed

  @npmcli/move-file@1.1.2
  (transitive)

• - Removed

  @tootallnate/once@1.1.2
  (transitive)

• - Removed

  abbrev@1.1.1
  (transitive)

• - Removed

  agent-base@6.0.2
  (transitive)

• - Removed

  agentkeepalive@4.6.0
  (transitive)

• - Removed

  aggregate-error@3.1.0
  (transitive)

• - Removed

  ansi-regex@5.0.1
  (transitive)

• - Removed

  aproba@2.1.0
  (transitive)

• - Removed

  are-we-there-yet@3.0.1
  (transitive)

• - Removed

  balanced-match@1.0.2
  (transitive)

• - Removed

  brace-expansion@1.1.14
  (transitive)

• - Removed

  cacache@15.3.0
  (transitive)

• - Removed

  chownr@2.0.0
  (transitive)

• - Removed

  clean-stack@2.2.0
  (transitive)

• - Removed

  color-support@1.1.3
  (transitive)

• - Removed

  concat-map@0.0.1
  (transitive)

• - Removed

  console-control-strings@1.1.0
  (transitive)

• - Removed

  dbtabla@0.8.8
  (transitive)

• - Removed

  delegates@1.0.0
  (transitive)

• - Removed

  emoji-regex@8.0.0
  (transitive)

• - Removed

  encoding@0.1.13
  (transitive)

• - Removed

  err-code@2.0.3
  (transitive)

• - Removed

  fs-minipass@2.1.0
  (transitive)

• - Removed

  fs.realpath@1.0.0
  (transitive)

• - Removed

  gauge@4.0.4
  (transitive)

• - Removed

  glob@7.2.3
  (transitive)

• - Removed

  has-unicode@2.0.1
  (transitive)

• - Removed

  http-proxy-agent@4.0.1
  (transitive)

• - Removed

  https-proxy-agent@5.0.1
  (transitive)

• - Removed

  humanize-ms@1.2.1
  (transitive)

• - Removed

  iconv-lite@0.6.3
  (transitive)

• - Removed

  imurmurhash@0.1.4
  (transitive)

• - Removed

  indent-string@4.0.0
  (transitive)

• - Removed

  infer-owner@1.0.4
  (transitive)

• - Removed

  inflight@1.0.6
  (transitive)

• - Removed

  is-fullwidth-code-point@3.0.0
  (transitive)

• - Removed

  is-lambda@1.0.1
  (transitive)

• - Removed

  isexe@2.0.0
  (transitive)

• - Removed

  lru-cache@6.0.0
  (transitive)

• - Removed

  make-fetch-happen@9.1.0
  (transitive)

• - Removed

  minimatch@3.1.5
  (transitive)

• - Removed

  minipass@5.0.0
  (transitive)

• - Removed

  minipass-collect@1.0.2
  (transitive)

• - Removed

  minipass-fetch@1.4.1
  (transitive)

• - Removed

  minipass-sized@1.0.3
  (transitive)

• - Removed

  minizlib@2.1.2
  (transitive)

• - Removed

  mkdirp@1.0.4
  (transitive)

• - Removed

  negotiator@0.6.4
  (transitive)

• - Removed

  node-addon-api@7.1.1
  (transitive)

• - Removed

  node-gyp@8.4.1
  (transitive)

• - Removed

  nopt@5.0.0
  (transitive)

• - Removed

  npmlog@6.0.2
  (transitive)

• - Removed

  p-map@4.0.0
  (transitive)

• - Removed

  path-is-absolute@1.0.1
  (transitive)

• - Removed

  promise-inflight@1.0.1
  (transitive)

• - Removed

  promise-retry@2.0.1
  (transitive)

• - Removed

  retry@0.12.0
  (transitive)

• - Removed

  rimraf@3.0.2
  (transitive)

• - Removed

  set-blocking@2.0.0
  (transitive)

• - Removed

  signal-exit@3.0.7
  (transitive)

• - Removed

  socks-proxy-agent@6.2.1
  (transitive)

• - Removed

  sqlite3@5.1.7
  (transitive)

• - Removed

  ssri@8.0.1
  (transitive)

• - Removed

  string-width@4.2.3
  (transitive)

• - Removed

  strip-ansi@6.0.1
  (transitive)

• - Removed

  tabla-model@1.4.0
  (transitive)

• - Removed

  tar@6.2.1
  (transitive)

• - Removed

  unique-filename@1.1.1
  (transitive)

• - Removed

  unique-slug@2.0.2
  (transitive)

• - Removed

  which@2.0.2
  (transitive)

• - Removed

  wide-align@1.1.5
  (transitive)

• Updated

  dbtabla@^2.1.2

• Updated

  sqlite3@^6.0.1