knex-schema-inspector
Advanced tools
Comparing version 1.6.0 to 1.6.1
@@ -142,5 +142,6 @@ "use strict"; | ||
.select('TABLE_NAME as table', 'COLUMN_NAME as column') | ||
.from('USER_TAB_COLS'); | ||
.from('USER_TAB_COLS') | ||
.where({ HIDDEN_COLUMN: 'NO' }); | ||
if (table) { | ||
query.where({ TABLE_NAME: table }); | ||
query.andWhere({ TABLE_NAME: table }); | ||
} | ||
@@ -171,5 +172,6 @@ return [4 /*yield*/, query]; | ||
}) | ||
.leftJoin('uc as fk', 'ct.R_CONSTRAINT_NAME', 'fk.CONSTRAINT_NAME'); | ||
.leftJoin('uc as fk', 'ct.R_CONSTRAINT_NAME', 'fk.CONSTRAINT_NAME') | ||
.where({ 'c.HIDDEN_COLUMN': 'NO' }); | ||
if (table) { | ||
query.where({ 'c.TABLE_NAME': table }); | ||
query.andWhere({ 'c.TABLE_NAME': table }); | ||
} | ||
@@ -208,2 +210,3 @@ if (!column) return [3 /*break*/, 2]; | ||
COLUMN_NAME: column, | ||
HIDDEN_COLUMN: 'NO', | ||
}) | ||
@@ -210,0 +213,0 @@ .first()]; |
@@ -110,6 +110,7 @@ import { Knex } from 'knex'; | ||
) | ||
.from('USER_TAB_COLS'); | ||
.from('USER_TAB_COLS') | ||
.where({ HIDDEN_COLUMN: 'NO' }); | ||
if (table) { | ||
query.where({ TABLE_NAME: table }); | ||
query.andWhere({ TABLE_NAME: table }); | ||
} | ||
@@ -167,6 +168,7 @@ | ||
}) | ||
.leftJoin('uc as fk', 'ct.R_CONSTRAINT_NAME', 'fk.CONSTRAINT_NAME'); | ||
.leftJoin('uc as fk', 'ct.R_CONSTRAINT_NAME', 'fk.CONSTRAINT_NAME') | ||
.where({ 'c.HIDDEN_COLUMN': 'NO' }); | ||
if (table) { | ||
query.where({ 'c.TABLE_NAME': table }); | ||
query.andWhere({ 'c.TABLE_NAME': table }); | ||
} | ||
@@ -200,2 +202,3 @@ | ||
COLUMN_NAME: column, | ||
HIDDEN_COLUMN: 'NO', | ||
}) | ||
@@ -202,0 +205,0 @@ .first(); |
{ | ||
"name": "knex-schema-inspector", | ||
"version": "1.6.0", | ||
"version": "1.6.1", | ||
"description": "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
306359
6724