sequelize - npm Package Compare versions

Comparing version 6.23.0 to 6.23.1

lib/dialects/oracle/connection-manager.js

@@ -31,2 +31,3 @@ "use strict";
 const { logger } = require("../../utils/logger");
+const semver = require("semver");
 const debug = logger.debugContext("connection:oracle");
@@ -105,2 +106,3 @@ const DataTypes = require("../../data-types").oracle;
       const connection = await this.lib.getConnection(connectionConfig);
+      this.sequelize.options.databaseVersion = semver.coerce(connection.oracleServerVersionString).version;
       debug("connection acquired");
@@ -107,0 +109,0 @@ connection.on("error", (error) => {

lib/dialects/oracle/index.js

@@ -51,3 +51,3 @@ "use strict";
 });
-OracleDialect.prototype.defaultVersion = "18.4.0";
+OracleDialect.prototype.defaultVersion = "18.0.0";
 OracleDialect.prototype.Query = OracleQuery;
@@ -54,0 +54,0 @@ OracleDialect.prototype.queryGenerator = OracleQueryGenerator;

lib/dialects/oracle/query-generator.js

@@ -120,3 +120,3 @@ "use strict";
   versionQuery() {
-    return "SELECT VERSION FROM PRODUCT_COMPONENT_VERSION WHERE PRODUCT LIKE 'Oracle%'";
+    return "SELECT VERSION_FULL FROM PRODUCT_COMPONENT_VERSION WHERE PRODUCT LIKE 'Oracle%'";
   }
@@ -282,3 +282,3 @@ createTableQuery(tableName, attributes, options) {
       `AND (atc.TABLE_NAME = ${this.escape(currTableName)})`,
-      "ORDER BY atc.COLUMN_NAME"
+      "ORDER BY atc.COLUMN_NAME, CONSTRAINT_TYPE DESC"
     ].join("");
@@ -285,0 +285,0 @@ }

lib/dialects/oracle/query.js

@@ -333,3 +333,3 @@ "use strict";
     } else if (this.isVersionQuery()) {
-      const version = data.rows[0].VERSION;
+      const version = data.rows[0].VERSION_FULL;
       if (version) {
@@ -336,0 +336,0 @@ const versions = version.split(".");

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.23.0",
+  "version": "6.23.1",
   "funding": [
@@ -109,3 +109,3 @@ {
     "nyc": "^15.1.0",
-    "oracledb": "^5.4.0",
+    "oracledb": "^5.5.0",
     "p-map": "^4.0.0",
@@ -248,3 +248,4 @@ "p-props": "^4.0.0",
     "start-db2": "bash dev/db2/11.5/start.sh",
-    "start-oracle": "bash dev/oracle/21-slim/start.sh",
+    "start-oracle-oldest": "bash dev/oracle/18-slim/start.sh",
+    "start-oracle-latest": "bash dev/oracle/21-slim/start.sh",
     "stop-mariadb": "bash dev/mariadb/10.3/stop.sh",
@@ -256,3 +257,4 @@ "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",
+    "stop-oracle-oldest": "bash dev/oracle/18-slim/stop.sh",
+    "stop-oracle-latest": "bash dev/oracle/21-slim/stop.sh",
     "restart-mariadb": "npm run start-mariadb",
@@ -263,3 +265,4 @@ "restart-mysql": "npm run start-mysql",
     "restart-db2": "npm run start-db2",
-    "restart-oracle": "npm run start-oracle",
+    "restart-oracle-oldest": "npm run start-oracle-oldest",
+    "restart-oracle-latest": "npm run start-oracle-latest",
     "----------------------------------------- local tests ---------------------------------------------": "",
@@ -266,0 +269,0 @@ "test-unit-mariadb": "cross-env DIALECT=mariadb npm run test-unit",

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

2867035

increased by0.03%

Lines of code

32601

increased by0.01%

No dependency changes