nukak-sqlite - npm Package Compare versions

Comparing version 1.0.2 to 1.1.0

CHANGELOG.md

@@ -7,2 +7,6 @@ # Changelog
 
+## [1.2.0] - 2024-08-12
+
+- Add support for `raw` in values (previously, it was only supported by `$select` and `$where` operators). Allows safe use of any SQL query/clause as the value in an insert or update operation that shouldn't be automatically escaped by the ORM.
+
 ## [1.1.0] - 2024-08-11
@@ -9,0 +13,0 @@

package.json

@@ -6,3 +6,3 @@ {
   "license": "MIT",
-  "version": "1.0.2",
+  "version": "1.1.0",
   "type": "module",
@@ -19,4 +19,4 @@ "main": "./index.js",
   "peerDependencies": {
-    "nukak": "^1.0.0",
-    "better-sqlite3": "^11.1.2"
+    "better-sqlite3": "^11.1.2",
+    "nukak": "^1.0.0"
   },
@@ -28,4 +28,4 @@ "dependencies": {
     "@types/better-sqlite3": "^7.6.11",
+    "@types/node": "^22.2.0",
     "better-sqlite3": "^11.1.2",
-    "@types/node": "^22.2.0",
     "copyfiles": "^2.4.1",
@@ -32,0 +32,0 @@ "rimraf": "^6.0.1",

sqliteDialect.js

 import sqlstring from 'sqlstring-sqlite';
 import { getMeta } from 'nukak/entity';
+import { QueryRaw, } from 'nukak/type';
 import { AbstractSqlDialect } from 'nukak/dialect';
-import { clone, getKeys } from 'nukak/util';
+import { clone, getKeys, getRawValue } from 'nukak/util';
 export class SqliteDialect extends AbstractSqlDialect {
@@ -33,5 +34,8 @@ constructor() {
     escape(value) {
+        if (value instanceof QueryRaw) {
+            return getRawValue({ value, dialect: this });
+        }
         return sqlstring.escape(value);
     }
 }
-//# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJmaWxlIjoic3FsaXRlRGlhbGVjdC5qcyIsInNvdXJjZVJvb3QiOiIiLCJzb3VyY2VzIjpbIi4uL3NyYy9zcWxpdGVEaWFsZWN0LnRzIl0sIm5hbWVzIjpbXSwibWFwcGluZ3MiOiJBQUFBLE9BQU8sU0FBUyxNQUFNLGtCQUFrQixDQUFDO0FBQ3pDLE9BQU8sRUFBRSxPQUFPLEVBQUUsTUFBTSxjQUFjLENBQUM7QUFVdkMsT0FBTyxFQUFFLGtCQUFrQixFQUFFLE1BQU0sZUFBZSxDQUFDO0FBQ25ELE9BQU8sRUFBRSxLQUFLLEVBQUUsT0FBTyxFQUFFLE1BQU0sWUFBWSxDQUFDO0FBRTVDLE1BQU0sT0FBTyxhQUFjLFNBQVEsa0JBQWtCO0lBQ25EO1FBQ0UsS0FBSyxDQUFDLEdBQUcsRUFBRSxtQkFBbUIsQ0FBQyxDQUFDO0lBQ2xDLENBQUM7SUFFUSxPQUFPLENBQ2QsTUFBZSxFQUNmLEdBQU0sRUFDTixHQUF3QixFQUN4QixJQUE2QjtRQUU3QixJQUFJLEdBQUcsS0FBSyxPQUFPLEVBQUUsQ0FBQztZQUNwQixNQUFNLElBQUksR0FBRyxPQUFPLENBQUMsTUFBTSxDQUFDLENBQUM7WUFDN0IsTUFBTSxNQUFNLEdBQUcsR0FBZ0MsQ0FBQztZQUNoRCxNQUFNLE1BQU0sR0FBRyxNQUFNLENBQUMsT0FBTyxDQUFDLEdBQUcsQ0FBQyxDQUFDLEtBQUssRUFBRSxFQUFFLENBQUMsSUFBSSxDQUFDLFFBQVEsQ0FBQyxJQUFJLENBQUMsTUFBTSxDQUFDLEtBQUssQ0FBQyxFQUFFLElBQUksSUFBSSxLQUFLLENBQUMsQ0FBQyxDQUFDO1lBQy9GLE9BQU8sR0FBRyxJQUFJLENBQUMsUUFBUSxDQUFDLElBQUksQ0FBQyxJQUFJLENBQUMsV0FBVyxNQUFNLENBQUMsSUFBSSxDQUFDLEdBQUcsQ0FBQyxPQUFPLElBQUksQ0FBQyxNQUFNLENBQUMsTUFBTSxDQUFDLE1BQU0sQ0FBQyxFQUFFLENBQUM7UUFDbkcsQ0FBQztRQUNELE9BQU8sS0FBSyxDQUFDLE9BQU8sQ0FBQyxNQUFNLEVBQUUsR0FBRyxFQUFFLEdBQUcsRUFBRSxJQUFJLENBQUMsQ0FBQztJQUMvQyxDQUFDO0lBRVEsTUFBTSxDQUFJLE1BQWUsRUFBRSxhQUFvQyxFQUFFLE9BQVU7UUFDbEYsT0FBTyxHQUFHLEtBQUssQ0FBQyxPQUFPLENBQUMsQ0FBQztRQUN6QixNQUFNLE1BQU0sR0FBRyxJQUFJLENBQUMsTUFBTSxDQUFDLE1BQU0sRUFBRSxPQUFPLENBQUMsQ0FBQztRQUM1QyxNQUFNLGNBQWMsR0FBRyxNQUFNLENBQUMsT0FBTyxDQUFDLFdBQVcsRUFBRSxtQkFBbUIsQ0FBQyxDQUFDO1FBQ3hFLE1BQU0sTUFBTSxHQUFHLE9BQU8sQ0FBQyxhQUFhLENBQUMsQ0FBQyxNQUFNLENBQzFDLENBQUMsR0FBRyxFQUFFLEdBQUcsRUFBRSxFQUFFO1lBQ1gsR0FBRyxDQUFDLE1BQU0sQ0FBQyxHQUFHLENBQUMsR0FBRyxPQUFPLENBQUMsR0FBRyxDQUFDLENBQUM7WUFDL0IsT0FBTyxHQUFHLENBQUM7UUFDYixDQUFDLEVBQ0QsRUFBRSxNQUFNLEVBQUUsRUFBRSxFQUFvQixDQUNqQyxDQUFDO1FBQ0YsS0FBSyxNQUFNLElBQUksSUFBSSxhQUFhLEVBQUUsQ0FBQztZQUNqQyxPQUFPLE9BQU8sQ0FBQyxJQUFJLENBQUMsQ0FBQztRQUN2QixDQUFDO1FBQ0QsTUFBTSxNQUFNLEdBQUcsSUFBSSxDQUFDLE1BQU0sQ0FBQyxNQUFNLEVBQUUsTUFBTSxFQUFFLE9BQU8sQ0FBQyxDQUFDO1FBQ3BELE9BQU8sR0FBRyxjQUFjLEtBQUssTUFBTSxFQUFFLENBQUM7SUFDeEMsQ0FBQztJQUVRLE1BQU0sQ0FBQyxLQUFVO1FBQ3hCLE9BQU8sU0FBUyxDQUFDLE1BQU0sQ0FBQyxLQUFLLENBQUMsQ0FBQztJQUNqQyxDQUFDO0NBQ0YiLCJzb3VyY2VzQ29udGVudCI6WyJpbXBvcnQgc3Fsc3RyaW5nIGZyb20gJ3NxbHN0cmluZy1zcWxpdGUnO1xuaW1wb3J0IHsgZ2V0TWV0YSB9IGZyb20gJ251a2FrL2VudGl0eSc7XG5pbXBvcnQge1xuICBRdWVyeVdoZXJlTWFwLFxuICBRdWVyeVRleHRTZWFyY2hPcHRpb25zLFxuICBUeXBlLFxuICBRdWVyeUNvbXBhcmlzb25PcHRpb25zLFxuICBTY2FsYXIsXG4gIFF1ZXJ5Q29uZmxpY3RQYXRocyxcbiAgUXVlcnlTZWFyY2gsXG59IGZyb20gJ251a2FrL3R5cGUnO1xuaW1wb3J0IHsgQWJzdHJhY3RTcWxEaWFsZWN0IH0gZnJvbSAnbnVrYWsvZGlhbGVjdCc7XG5pbXBvcnQgeyBjbG9uZSwgZ2V0S2V5cyB9IGZyb20gJ251a2FrL3V0aWwnO1xuXG5leHBvcnQgY2xhc3MgU3FsaXRlRGlhbGVjdCBleHRlbmRzIEFic3RyYWN0U3FsRGlhbGVjdCB7XG4gIGNvbnN0cnVjdG9yKCkge1xuICAgIHN1cGVyKCdgJywgJ0JFR0lOIFRSQU5TQUNUSU9OJyk7XG4gIH1cblxuICBvdmVycmlkZSBjb21wYXJlPEUsIEsgZXh0ZW5kcyBrZXlvZiBRdWVyeVdoZXJlTWFwPEU+PihcbiAgICBlbnRpdHk6IFR5cGU8RT4sXG4gICAga2V5OiBLLFxuICAgIHZhbDogUXVlcnlXaGVyZU1hcDxFPltLXSxcbiAgICBvcHRzPzogUXVlcnlDb21wYXJpc29uT3B0aW9ucyxcbiAgKTogc3RyaW5nIHtcbiAgICBpZiAoa2V5ID09PSAnJHRleHQnKSB7XG4gICAgICBjb25zdCBtZXRhID0gZ2V0TWV0YShlbnRpdHkpO1xuICAgICAgY29uc3Qgc2VhcmNoID0gdmFsIGFzIFF1ZXJ5VGV4dFNlYXJjaE9wdGlvbnM8RT47XG4gICAgICBjb25zdCBmaWVsZHMgPSBzZWFyY2guJGZpZWxkcy5tYXAoKGZpZWxkKSA9PiB0aGlzLmVzY2FwZUlkKG1ldGEuZmllbGRzW2ZpZWxkXT8ubmFtZSA/PyBmaWVsZCkpO1xuICAgICAgcmV0dXJuIGAke3RoaXMuZXNjYXBlSWQobWV0YS5uYW1lKX0gTUFUQ0ggeyR7ZmllbGRzLmpvaW4oJyAnKX19IDogJHt0aGlzLmVzY2FwZShzZWFyY2guJHZhbHVlKX1gO1xuICAgIH1cbiAgICByZXR1cm4gc3VwZXIuY29tcGFyZShlbnRpdHksIGtleSwgdmFsLCBvcHRzKTtcbiAgfVxuXG4gIG92ZXJyaWRlIHVwc2VydDxFPihlbnRpdHk6IFR5cGU8RT4sIGNvbmZsaWN0UGF0aHM6IFF1ZXJ5Q29uZmxpY3RQYXRoczxFPiwgcGF5bG9hZDogRSk6IHN0cmluZyB7XG4gICAgcGF5bG9hZCA9IGNsb25lKHBheWxvYWQpO1xuICAgIGNvbnN0IGluc2VydCA9IHRoaXMuaW5zZXJ0KGVudGl0eSwgcGF5bG9hZCk7XG4gICAgY29uc3QgaW5zZXJ0T3JJZ25vcmUgPSBpbnNlcnQucmVwbGFjZSgvXklOU0VSVFxccy8sICdJTlNFUlQgT1IgSUdOT1JFICcpO1xuICAgIGNvbnN0IHNlYXJjaCA9IGdldEtleXMoY29uZmxpY3RQYXRocykucmVkdWNlKFxuICAgICAgKGFjYywga2V5KSA9PiB7XG4gICAgICAgIGFjYy4kd2hlcmVba2V5XSA9IHBheWxvYWRba2V5XTtcbiAgICAgICAgcmV0dXJuIGFjYztcbiAgICAgIH0sXG4gICAgICB7ICR3aGVyZToge30gfSBhcyBRdWVyeVNlYXJjaDxFPixcbiAgICApO1xuICAgIGZvciAoY29uc3QgcHJvcCBpbiBjb25mbGljdFBhdGhzKSB7XG4gICAgICBkZWxldGUgcGF5bG9hZFtwcm9wXTtcbiAgICB9XG4gICAgY29uc3QgdXBkYXRlID0gdGhpcy51cGRhdGUoZW50aXR5LCBzZWFyY2gsIHBheWxvYWQpO1xuICAgIHJldHVybiBgJHtpbnNlcnRPcklnbm9yZX07ICR7dXBkYXRlfWA7XG4gIH1cblxuICBvdmVycmlkZSBlc2NhcGUodmFsdWU6IGFueSk6IFNjYWxhciB7XG4gICAgcmV0dXJuIHNxbHN0cmluZy5lc2NhcGUodmFsdWUpO1xuICB9XG59XG4iXX0=
+//# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJmaWxlIjoic3FsaXRlRGlhbGVjdC5qcyIsInNvdXJjZVJvb3QiOiIiLCJzb3VyY2VzIjpbIi4uL3NyYy9zcWxpdGVEaWFsZWN0LnRzIl0sIm5hbWVzIjpbXSwibWFwcGluZ3MiOiJBQUFBLE9BQU8sU0FBUyxNQUFNLGtCQUFrQixDQUFDO0FBQ3pDLE9BQU8sRUFBRSxPQUFPLEVBQUUsTUFBTSxjQUFjLENBQUM7QUFDdkMsT0FBTyxFQVFMLFFBQVEsR0FDVCxNQUFNLFlBQVksQ0FBQztBQUNwQixPQUFPLEVBQUUsa0JBQWtCLEVBQUUsTUFBTSxlQUFlLENBQUM7QUFDbkQsT0FBTyxFQUFFLEtBQUssRUFBRSxPQUFPLEVBQUUsV0FBVyxFQUFFLE1BQU0sWUFBWSxDQUFDO0FBRXpELE1BQU0sT0FBTyxhQUFjLFNBQVEsa0JBQWtCO0lBQ25EO1FBQ0UsS0FBSyxDQUFDLEdBQUcsRUFBRSxtQkFBbUIsQ0FBQyxDQUFDO0lBQ2xDLENBQUM7SUFFUSxPQUFPLENBQ2QsTUFBZSxFQUNmLEdBQU0sRUFDTixHQUF3QixFQUN4QixJQUE2QjtRQUU3QixJQUFJLEdBQUcsS0FBSyxPQUFPLEVBQUUsQ0FBQztZQUNwQixNQUFNLElBQUksR0FBRyxPQUFPLENBQUMsTUFBTSxDQUFDLENBQUM7WUFDN0IsTUFBTSxNQUFNLEdBQUcsR0FBZ0MsQ0FBQztZQUNoRCxNQUFNLE1BQU0sR0FBRyxNQUFNLENBQUMsT0FBTyxDQUFDLEdBQUcsQ0FBQyxDQUFDLEtBQUssRUFBRSxFQUFFLENBQUMsSUFBSSxDQUFDLFFBQVEsQ0FBQyxJQUFJLENBQUMsTUFBTSxDQUFDLEtBQUssQ0FBQyxFQUFFLElBQUksSUFBSSxLQUFLLENBQUMsQ0FBQyxDQUFDO1lBQy9GLE9BQU8sR0FBRyxJQUFJLENBQUMsUUFBUSxDQUFDLElBQUksQ0FBQyxJQUFJLENBQUMsV0FBVyxNQUFNLENBQUMsSUFBSSxDQUFDLEdBQUcsQ0FBQyxPQUFPLElBQUksQ0FBQyxNQUFNLENBQUMsTUFBTSxDQUFDLE1BQU0sQ0FBQyxFQUFFLENBQUM7UUFDbkcsQ0FBQztRQUNELE9BQU8sS0FBSyxDQUFDLE9BQU8sQ0FBQyxNQUFNLEVBQUUsR0FBRyxFQUFFLEdBQUcsRUFBRSxJQUFJLENBQUMsQ0FBQztJQUMvQyxDQUFDO0lBRVEsTUFBTSxDQUFJLE1BQWUsRUFBRSxhQUFvQyxFQUFFLE9BQVU7UUFDbEYsT0FBTyxHQUFHLEtBQUssQ0FBQyxPQUFPLENBQUMsQ0FBQztRQUN6QixNQUFNLE1BQU0sR0FBRyxJQUFJLENBQUMsTUFBTSxDQUFDLE1BQU0sRUFBRSxPQUFPLENBQUMsQ0FBQztRQUM1QyxNQUFNLGNBQWMsR0FBRyxNQUFNLENBQUMsT0FBTyxDQUFDLFdBQVcsRUFBRSxtQkFBbUIsQ0FBQyxDQUFDO1FBQ3hFLE1BQU0sTUFBTSxHQUFHLE9BQU8sQ0FBQyxhQUFhLENBQUMsQ0FBQyxNQUFNLENBQzFDLENBQUMsR0FBRyxFQUFFLEdBQUcsRUFBRSxFQUFFO1lBQ1gsR0FBRyxDQUFDLE1BQU0sQ0FBQyxHQUFHLENBQUMsR0FBRyxPQUFPLENBQUMsR0FBRyxDQUFDLENBQUM7WUFDL0IsT0FBTyxHQUFHLENBQUM7UUFDYixDQUFDLEVBQ0QsRUFBRSxNQUFNLEVBQUUsRUFBRSxFQUFvQixDQUNqQyxDQUFDO1FBQ0YsS0FBSyxNQUFNLElBQUksSUFBSSxhQUFhLEVBQUUsQ0FBQztZQUNqQyxPQUFPLE9BQU8sQ0FBQyxJQUFJLENBQUMsQ0FBQztRQUN2QixDQUFDO1FBQ0QsTUFBTSxNQUFNLEdBQUcsSUFBSSxDQUFDLE1BQU0sQ0FBQyxNQUFNLEVBQUUsTUFBTSxFQUFFLE9BQU8sQ0FBQyxDQUFDO1FBQ3BELE9BQU8sR0FBRyxjQUFjLEtBQUssTUFBTSxFQUFFLENBQUM7SUFDeEMsQ0FBQztJQUVRLE1BQU0sQ0FBQyxLQUFVO1FBQ3hCLElBQUksS0FBSyxZQUFZLFFBQVEsRUFBRSxDQUFDO1lBQzlCLE9BQU8sV0FBVyxDQUFDLEVBQUUsS0FBSyxFQUFFLE9BQU8sRUFBRSxJQUFJLEVBQUUsQ0FBQyxDQUFDO1FBQy9DLENBQUM7UUFDRCxPQUFPLFNBQVMsQ0FBQyxNQUFNLENBQUMsS0FBSyxDQUFDLENBQUM7SUFDakMsQ0FBQztDQUNGIiwic291cmNlc0NvbnRlbnQiOlsiaW1wb3J0IHNxbHN0cmluZyBmcm9tICdzcWxzdHJpbmctc3FsaXRlJztcbmltcG9ydCB7IGdldE1ldGEgfSBmcm9tICdudWthay9lbnRpdHknO1xuaW1wb3J0IHtcbiAgUXVlcnlXaGVyZU1hcCxcbiAgUXVlcnlUZXh0U2VhcmNoT3B0aW9ucyxcbiAgVHlwZSxcbiAgUXVlcnlDb21wYXJpc29uT3B0aW9ucyxcbiAgU2NhbGFyLFxuICBRdWVyeUNvbmZsaWN0UGF0aHMsXG4gIFF1ZXJ5U2VhcmNoLFxuICBRdWVyeVJhdyxcbn0gZnJvbSAnbnVrYWsvdHlwZSc7XG5pbXBvcnQgeyBBYnN0cmFjdFNxbERpYWxlY3QgfSBmcm9tICdudWthay9kaWFsZWN0JztcbmltcG9ydCB7IGNsb25lLCBnZXRLZXlzLCBnZXRSYXdWYWx1ZSB9IGZyb20gJ251a2FrL3V0aWwnO1xuXG5leHBvcnQgY2xhc3MgU3FsaXRlRGlhbGVjdCBleHRlbmRzIEFic3RyYWN0U3FsRGlhbGVjdCB7XG4gIGNvbnN0cnVjdG9yKCkge1xuICAgIHN1cGVyKCdgJywgJ0JFR0lOIFRSQU5TQUNUSU9OJyk7XG4gIH1cblxuICBvdmVycmlkZSBjb21wYXJlPEUsIEsgZXh0ZW5kcyBrZXlvZiBRdWVyeVdoZXJlTWFwPEU+PihcbiAgICBlbnRpdHk6IFR5cGU8RT4sXG4gICAga2V5OiBLLFxuICAgIHZhbDogUXVlcnlXaGVyZU1hcDxFPltLXSxcbiAgICBvcHRzPzogUXVlcnlDb21wYXJpc29uT3B0aW9ucyxcbiAgKTogc3RyaW5nIHtcbiAgICBpZiAoa2V5ID09PSAnJHRleHQnKSB7XG4gICAgICBjb25zdCBtZXRhID0gZ2V0TWV0YShlbnRpdHkpO1xuICAgICAgY29uc3Qgc2VhcmNoID0gdmFsIGFzIFF1ZXJ5VGV4dFNlYXJjaE9wdGlvbnM8RT47XG4gICAgICBjb25zdCBmaWVsZHMgPSBzZWFyY2guJGZpZWxkcy5tYXAoKGZpZWxkKSA9PiB0aGlzLmVzY2FwZUlkKG1ldGEuZmllbGRzW2ZpZWxkXT8ubmFtZSA/PyBmaWVsZCkpO1xuICAgICAgcmV0dXJuIGAke3RoaXMuZXNjYXBlSWQobWV0YS5uYW1lKX0gTUFUQ0ggeyR7ZmllbGRzLmpvaW4oJyAnKX19IDogJHt0aGlzLmVzY2FwZShzZWFyY2guJHZhbHVlKX1gO1xuICAgIH1cbiAgICByZXR1cm4gc3VwZXIuY29tcGFyZShlbnRpdHksIGtleSwgdmFsLCBvcHRzKTtcbiAgfVxuXG4gIG92ZXJyaWRlIHVwc2VydDxFPihlbnRpdHk6IFR5cGU8RT4sIGNvbmZsaWN0UGF0aHM6IFF1ZXJ5Q29uZmxpY3RQYXRoczxFPiwgcGF5bG9hZDogRSk6IHN0cmluZyB7XG4gICAgcGF5bG9hZCA9IGNsb25lKHBheWxvYWQpO1xuICAgIGNvbnN0IGluc2VydCA9IHRoaXMuaW5zZXJ0KGVudGl0eSwgcGF5bG9hZCk7XG4gICAgY29uc3QgaW5zZXJ0T3JJZ25vcmUgPSBpbnNlcnQucmVwbGFjZSgvXklOU0VSVFxccy8sICdJTlNFUlQgT1IgSUdOT1JFICcpO1xuICAgIGNvbnN0IHNlYXJjaCA9IGdldEtleXMoY29uZmxpY3RQYXRocykucmVkdWNlKFxuICAgICAgKGFjYywga2V5KSA9PiB7XG4gICAgICAgIGFjYy4kd2hlcmVba2V5XSA9IHBheWxvYWRba2V5XTtcbiAgICAgICAgcmV0dXJuIGFjYztcbiAgICAgIH0sXG4gICAgICB7ICR3aGVyZToge30gfSBhcyBRdWVyeVNlYXJjaDxFPixcbiAgICApO1xuICAgIGZvciAoY29uc3QgcHJvcCBpbiBjb25mbGljdFBhdGhzKSB7XG4gICAgICBkZWxldGUgcGF5bG9hZFtwcm9wXTtcbiAgICB9XG4gICAgY29uc3QgdXBkYXRlID0gdGhpcy51cGRhdGUoZW50aXR5LCBzZWFyY2gsIHBheWxvYWQpO1xuICAgIHJldHVybiBgJHtpbnNlcnRPcklnbm9yZX07ICR7dXBkYXRlfWA7XG4gIH1cblxuICBvdmVycmlkZSBlc2NhcGUodmFsdWU6IGFueSk6IFNjYWxhciB7XG4gICAgaWYgKHZhbHVlIGluc3RhbmNlb2YgUXVlcnlSYXcpIHtcbiAgICAgIHJldHVybiBnZXRSYXdWYWx1ZSh7IHZhbHVlLCBkaWFsZWN0OiB0aGlzIH0pO1xuICAgIH1cbiAgICByZXR1cm4gc3Fsc3RyaW5nLmVzY2FwZSh2YWx1ZSk7XG4gIH1cbn1cbiJdfQ==

No alert changes

Improved metrics

Total package byte prevSize

28820

increased by2.92%

Lines of code

144

increased by2.86%

No dependency changes