knex-schema-inspector - npm Package Compare versions

Comparing version 1.5.0 to 1.5.1

dist/dialects/mssql.js

@@ -291,3 +291,3 @@ "use strict";
                 switch (_a.label) {
-                    case 0: return [4 /*yield*/, this.knex.raw("\n      SELECT\n        OBJECT_NAME (fc.parent_object_id) AS \"table\",\n          COL_NAME (fc.parent_object_id, fc.parent_column_id) AS \"column\",\n          OBJECT_SCHEMA_NAME (f.referenced_object_id) AS foreign_key_schema,\n          OBJECT_NAME (f.referenced_object_id) AS foreign_key_table,\n          COL_NAME (fc.referenced_object_id, fc.referenced_column_id) AS foreign_key_column,\n          f.name AS constraint_name,\n          f.update_referential_action_desc AS on_update,\n          f.delete_referential_action_desc AS on_delete\n      FROM\n        sys.foreign_keys AS f\n        INNER JOIN sys.foreign_key_columns AS fc ON f.OBJECT_ID = fc.constraint_object_id\n      WHERE\n        OBJECT_SCHEMA_NAME (f.parent_object_id) = ?;\n    ", [this.schema])];
+                    case 0: return [4 /*yield*/, this.knex.raw("\n      SELECT\n        OBJECT_NAME (fc.parent_object_id) AS \"table\",\n          COL_NAME (fc.parent_object_id, fc.parent_column_id) AS \"column\",\n          OBJECT_SCHEMA_NAME (f.referenced_object_id) AS foreign_key_schema,\n          OBJECT_NAME (f.referenced_object_id) AS foreign_key_table,\n          COL_NAME (fc.referenced_object_id, fc.referenced_column_id) AS foreign_key_column,\n          f.name AS constraint_name,\n          REPLACE(f.update_referential_action_desc, '_', ' ') AS on_update,\n          REPLACE(f.delete_referential_action_desc, '_', ' ') AS on_delete\n      FROM\n        sys.foreign_keys AS f\n        INNER JOIN sys.foreign_key_columns AS fc ON f.OBJECT_ID = fc.constraint_object_id\n      WHERE\n        OBJECT_SCHEMA_NAME (f.parent_object_id) = ?;\n    ", [this.schema])];
                     case 1:
@@ -294,0 +294,0 @@ result = _a.sent();

lib/dialects/mssql.ts

@@ -328,4 +328,4 @@ import { Knex } from 'knex';
           f.name AS constraint_name,
-          f.update_referential_action_desc AS on_update,
-          f.delete_referential_action_desc AS on_delete
+          REPLACE(f.update_referential_action_desc, '_', ' ') AS on_update,
+          REPLACE(f.delete_referential_action_desc, '_', ' ') AS on_delete
       FROM
@@ -332,0 +332,0 @@ sys.foreign_keys AS f

package.json

 {
   "name": "knex-schema-inspector",
-  "version": "1.5.0",
+  "version": "1.5.1",
   "description": "Utility for extracting information about existing DB schema",
@@ -5,0 +5,0 @@ "main": "dist/index.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

285123

increased by0.03%

No dependency changes