knex-schema-inspector
Advanced tools
Comparing version 0.0.3 to 0.0.4
@@ -168,4 +168,4 @@ "use strict"; | ||
.select('c.TABLE_NAME', 'c.COLUMN_NAME', 'c.COLUMN_DEFAULT', 'c.DATA_TYPE', 'c.CHARACTER_MAXIMUM_LENGTH', 'c.IS_NULLABLE', 'c.COLUMN_KEY', 'c.EXTRA', 'c.COLLATION_NAME', 'c.COLUMN_COMMENT', 'fk.REFERENCED_TABLE_NAME', 'fk.REFERENCED_COLUMN_NAME', 'fk.CONSTRAINT_NAME', 'rc.UPDATE_RULE', 'rc.DELETE_RULE', 'rc.MATCH_OPTION') | ||
.from('information_schema.columns c') | ||
.leftJoin('INFORMATION_SCHEMA.KEY_COLUMN_USAGE fk', function () { | ||
.from('INFORMATION_SCHEMA.COLUMNS as c') | ||
.leftJoin('INFORMATION_SCHEMA.KEY_COLUMN_USAGE as fk', function () { | ||
this.on('fk.TABLE_NAME', '=', 'fk.TABLE_NAME') | ||
@@ -175,3 +175,3 @@ .andOn('fk.COLUMN_NAME', '=', 'c.COLUMN_NAME') | ||
}) | ||
.leftJoin('INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc', function () { | ||
.leftJoin('INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS as rc', function () { | ||
this.on('rc.TABLE_NAME', '=', 'fk.TABLE_NAME') | ||
@@ -185,3 +185,3 @@ .andOn('rc.CONSTRAINT_NAME', '=', 'fk.CONSTRAINT_NAME') | ||
if (table) { | ||
query.andWhere({ TABLE_NAME: table }); | ||
query.andWhere({ 'c.TABLE_NAME': table }); | ||
} | ||
@@ -188,0 +188,0 @@ if (!column) return [3 /*break*/, 2]; |
@@ -173,4 +173,4 @@ import Knex from 'knex'; | ||
) | ||
.from('information_schema.columns c') | ||
.leftJoin('INFORMATION_SCHEMA.KEY_COLUMN_USAGE fk', function () { | ||
.from('INFORMATION_SCHEMA.COLUMNS as c') | ||
.leftJoin('INFORMATION_SCHEMA.KEY_COLUMN_USAGE as fk', function () { | ||
this.on('fk.TABLE_NAME', '=', 'fk.TABLE_NAME') | ||
@@ -180,7 +180,10 @@ .andOn('fk.COLUMN_NAME', '=', 'c.COLUMN_NAME') | ||
}) | ||
.leftJoin('INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc', function () { | ||
this.on('rc.TABLE_NAME', '=', 'fk.TABLE_NAME') | ||
.andOn('rc.CONSTRAINT_NAME', '=', 'fk.CONSTRAINT_NAME') | ||
.andOn('rc.CONSTRAINT_SCHEMA', '=', 'fk.CONSTRAINT_SCHEMA'); | ||
}) | ||
.leftJoin( | ||
'INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS as rc', | ||
function () { | ||
this.on('rc.TABLE_NAME', '=', 'fk.TABLE_NAME') | ||
.andOn('rc.CONSTRAINT_NAME', '=', 'fk.CONSTRAINT_NAME') | ||
.andOn('rc.CONSTRAINT_SCHEMA', '=', 'fk.CONSTRAINT_SCHEMA'); | ||
} | ||
) | ||
.where({ | ||
@@ -191,3 +194,3 @@ 'c.TABLE_SCHEMA': this.knex.client.database(), | ||
if (table) { | ||
query.andWhere({ TABLE_NAME: table }); | ||
query.andWhere({ 'c.TABLE_NAME': table }); | ||
} | ||
@@ -194,0 +197,0 @@ |
{ | ||
"name": "knex-schema-inspector", | ||
"version": "0.0.3", | ||
"version": "0.0.4", | ||
"description": "[WIP] Utility for extracting information about existing DB schema", | ||
@@ -5,0 +5,0 @@ "main": "dist/index.js", |
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
85955
1890