sequelize - npm Package Compare versions

Comparing version 6.21.6 to 6.22.0

lib/data-types.js

@@ -654,2 +654,3 @@ "use strict";
 dialectMap.snowflake = require("./dialects/snowflake/data-types")(DataTypes);
+dialectMap.oracle = require("./dialects/oracle/data-types")(DataTypes);
 const dialectList = Object.values(dialectMap);
@@ -656,0 +657,0 @@ for (const dataTypes of dialectList) {

lib/sequelize.js

@@ -175,2 +175,5 @@ "use strict";
         break;
+      case "oracle":
+        Dialect = require("./dialects/oracle");
+        break;
       case "postgres":
@@ -189,3 +192,3 @@ Dialect = require("./dialects/postgres");
       default:
-        throw new Error(`The dialect ${this.getDialect()} is not supported. Supported dialects: mssql, mariadb, mysql, postgres, db2 and sqlite.`);
+        throw new Error(`The dialect ${this.getDialect()} is not supported. Supported dialects: mssql, mariadb, mysql, oracle, postgres, db2 and sqlite.`);
     }
@@ -455,3 +458,3 @@ this.dialect = new Dialect(this);
     }, options);
-    await this.query("SELECT 1+1 AS result", options);
+    await this.query(this.dialect.queryGenerator.authTestQuery(), options);
     return;
@@ -458,0 +461,0 @@ }

lib/sql-string.js

@@ -25,3 +25,3 @@ "use strict";
     case "boolean":
-      if (["sqlite", "mssql"].includes(dialect)) {
+      if (["sqlite", "mssql", "oracle"].includes(dialect)) {
         return +!!val;
@@ -60,2 +60,7 @@ }
     }
+  } else if (dialect === "oracle" && typeof val === "string") {
+    if (val.startsWith("TO_TIMESTAMP") || val.startsWith("TO_DATE")) {
+      return val;
+    }
+    val = val.replace(/'/g, "''");
   } else {
@@ -62,0 +67,0 @@ val = val.replace(/[\0\n\r\b\t\\'"\x1a]/g, (s) => {

lib/utils.js

@@ -263,3 +263,3 @@ "use strict";
 exports.removeNullValuesFromHash = removeNullValuesFromHash;
-const dialects = /* @__PURE__ */ new Set(["mariadb", "mysql", "postgres", "sqlite", "mssql", "db2"]);
+const dialects = /* @__PURE__ */ new Set(["mariadb", "mysql", "postgres", "sqlite", "mssql", "db2", "oracle"]);
 function now(dialect) {
@@ -266,0 +266,0 @@ const d = new Date();

package.json

 {
   "name": "sequelize",
   "description": "Sequelize is a promise-based Node.js ORM tool for Postgres, MySQL, MariaDB, SQLite, Microsoft SQL Server, Amazon Redshift and Snowflake’s Data Cloud. It features solid transaction support, relations, eager and lazy loading, read replication and more.",
-  "version": "6.21.6",
+  "version": "6.22.0",
   "funding": [
@@ -109,2 +109,3 @@ {
     "nyc": "^15.1.0",
+    "oracledb": "^5.4.0",
     "p-map": "^4.0.0",
@@ -151,2 +152,5 @@ "p-props": "^4.0.0",
       "optional": true
+    },
+    "oracledb": {
+      "optional": true
     }
@@ -165,2 +169,3 @@ },
     "sql",
+    "oracledb",
     "sqlserver",
@@ -245,2 +250,3 @@ "snowflake",
     "start-db2": "bash dev/db2/11.5/start.sh",
+    "start-oracle": "bash dev/oracle/21-slim/start.sh",
     "stop-mariadb": "bash dev/mariadb/10.3/stop.sh",
@@ -252,2 +258,3 @@ "stop-mysql": "bash dev/mysql/5.7/stop.sh",
     "stop-db2": "bash dev/db2/11.5/stop.sh",
+    "stop-oracle": "bash dev/oracle/21-slim/stop.sh",
     "restart-mariadb": "npm run start-mariadb",
@@ -258,2 +265,3 @@ "restart-mysql": "npm run start-mysql",
     "restart-db2": "npm run start-db2",
+    "restart-oracle": "npm run start-oracle",
     "----------------------------------------- local tests ---------------------------------------------": "",
@@ -268,3 +276,4 @@ "test-unit-mariadb": "cross-env DIALECT=mariadb npm run test-unit",
     "test-unit-snowflake": "cross-env DIALECT=snowflake npm run test-unit",
-    "test-unit-all": "npm run test-unit-mariadb && npm run test-unit-mysql && npm run test-unit-postgres && npm run test-unit-postgres-native && npm run test-unit-mssql && npm run test-unit-sqlite && npm run test-unit-snowflake && npm run test-unit-db2",
+    "test-unit-oracle": "cross-env DIALECT=oracle npm run test-unit",
+    "test-unit-all": "npm run test-unit-mariadb && npm run test-unit-mysql && npm run test-unit-postgres && npm run test-unit-postgres-native && npm run test-unit-mssql && npm run test-unit-sqlite && npm run test-unit-snowflake && npm run test-unit-db2 && npm run test-unit-oracle",
     "test-integration-mariadb": "cross-env DIALECT=mariadb npm run test-integration",
@@ -278,2 +287,3 @@ "test-integration-mysql": "cross-env DIALECT=mysql npm run test-integration",
     "test-integration-snowflake": "cross-env DIALECT=snowflake npm run test-integration",
+    "test-integration-oracle": "cross-env LD_LIBRARY_PATH=\"$PWD/.oracle/instantclient/\" DIALECT=oracle UV_THREADPOOL_SIZE=128 npm run test-integration",
     "test-mariadb": "cross-env DIALECT=mariadb npm test",
@@ -286,2 +296,3 @@ "test-mysql": "cross-env DIALECT=mysql npm test",
     "test-db2": "cross-env DIALECT=db2 npm test",
+    "test-oracle": "cross-env LD_LIBRARY_PATH=\"$PWD/.oracle/instantclient/\" DIALECT=oracle UV_THREADPOOL_SIZE=128 npm test",
     "----------------------------------------- development ---------------------------------------------": "",
@@ -296,2 +307,3 @@ "sscce": "node sscce.js",
     "sscce-db2": "cross-env DIALECT=db2 node sscce.js",
+    "sscce-oracle": "cross-env LD_LIBRARY_PATH=\"$PWD/.oracle/instantclient/\" DIALECT=oracle UV_THREADPOOL_SIZE=128 node sscce.js",
     "prepare": "npm run build && husky install",
@@ -298,0 +310,0 @@ "build": "node ./build.js",

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

2866203

increased by7.98%

Number of package files

300

increased by4.17%

Lines of code

32599

increased by6.87%

Worsened metrics

Dev dependency count

60

increased by1.69%

No dependency changes