knex-schema-inspector - npm Package Compare versions

Comparing version 1.5.15 to 1.6.0

dist/dialects/mssql.js

@@ -56,4 +56,3 @@ "use strict";
 function rawColumnToColumn(rawColumn) {
-    return __assign(__assign({}, rawColumn), { default_value: parseDefaultValue(rawColumn.default_value) ||
-            parseDefaultValue(rawColumn.generation_expression), is_generated: !!rawColumn.is_generated, is_unique: rawColumn.is_unique === true, is_primary_key: rawColumn.is_primary_key === true, is_nullable: rawColumn.is_nullable === 'YES', has_auto_increment: rawColumn.has_auto_increment === 'YES', numeric_precision: rawColumn.numeric_precision || null, numeric_scale: rawColumn.numeric_scale || null, max_length: parseMaxLength(rawColumn) });
+    return __assign(__assign({}, rawColumn), { default_value: parseDefaultValue(rawColumn.default_value), generation_expression: rawColumn.generation_expression || null, is_generated: !!rawColumn.is_generated, is_unique: rawColumn.is_unique === true, is_primary_key: rawColumn.is_primary_key === true, is_nullable: rawColumn.is_nullable === 'YES', has_auto_increment: rawColumn.has_auto_increment === 'YES', numeric_precision: rawColumn.numeric_precision || null, numeric_scale: rawColumn.numeric_scale || null, max_length: parseMaxLength(rawColumn) });
     function parseMaxLength(rawColumn) {
@@ -244,3 +243,3 @@ if (Number.isNaN(Number(rawColumn.max_length)) ||
                         query = this.knex
-                            .select(this.knex.raw("\n        [o].[name] AS [table],\n        [c].[name] AS [name],\n        [t].[name] AS [data_type],\n        [c].[max_length] AS [max_length],\n        [c].[precision] AS [numeric_precision],\n        [c].[scale] AS [numeric_scale],\n        CASE WHEN [c].[is_nullable] = 0 THEN\n          'NO'\n        ELSE\n          'YES'\n        END AS [is_nullable],\n        COALESCE(\n          object_definition ([c].[default_object_id]),\n          [cc].[definition]\n        ) AS [default_value],\n        [i].[is_primary_key],\n        [i].[is_unique],\n        CASE [c].[is_identity]\n        WHEN 1 THEN\n          'YES'\n        ELSE\n          'NO'\n        END AS [has_auto_increment],\n        OBJECT_NAME ([fk].[referenced_object_id]) AS [foreign_key_table],\n        COL_NAME ([fk].[referenced_object_id],\n          [fk].[referenced_column_id]) AS [foreign_key_column],\n        [cc].[is_computed] as [is_generated]"))
+                            .select(this.knex.raw("\n        [o].[name] AS [table],\n        [c].[name] AS [name],\n        [t].[name] AS [data_type],\n        [c].[max_length] AS [max_length],\n        [c].[precision] AS [numeric_precision],\n        [c].[scale] AS [numeric_scale],\n        CASE WHEN [c].[is_nullable] = 0 THEN\n          'NO'\n        ELSE\n          'YES'\n        END AS [is_nullable],\n        object_definition ([c].[default_object_id]) AS [default_value],\n        [i].[is_primary_key],\n        [i].[is_unique],\n        CASE [c].[is_identity]\n        WHEN 1 THEN\n          'YES'\n        ELSE\n          'NO'\n        END AS [has_auto_increment],\n        OBJECT_NAME ([fk].[referenced_object_id]) AS [foreign_key_table],\n        COL_NAME ([fk].[referenced_object_id],\n          [fk].[referenced_column_id]) AS [foreign_key_column],\n        [cc].[is_computed] as [is_generated],\n        [cc].[definition] as [generation_expression]"))
                             .from(this.knex.raw("??.[sys].[columns] [c]", [dbName]))
@@ -247,0 +246,0 @@ .joinRaw("JOIN [sys].[types] [t] ON [c].[user_type_id] = [t].[user_type_id]")

dist/dialects/mysql.js

@@ -52,3 +52,3 @@ "use strict";
 function rawColumnToColumn(rawColumn) {
-    var _a, _b;
+    var _a;
     var dataType = rawColumn.COLUMN_TYPE.split('(')[0];
@@ -68,7 +68,8 @@ /**
         data_type: dataType,
-        default_value: (_a = parseDefaultValue(rawColumn.COLUMN_DEFAULT)) !== null && _a !== void 0 ? _a : parseDefaultValue(rawColumn.GENERATION_EXPRESSION || null),
+        default_value: parseDefaultValue(rawColumn.COLUMN_DEFAULT),
+        generation_expression: rawColumn.GENERATION_EXPRESSION || null,
         max_length: rawColumn.CHARACTER_MAXIMUM_LENGTH,
         numeric_precision: rawColumn.NUMERIC_PRECISION,
         numeric_scale: rawColumn.NUMERIC_SCALE,
-        is_generated: !!((_b = rawColumn.EXTRA) === null || _b === void 0 ? void 0 : _b.endsWith('GENERATED')),
+        is_generated: !!((_a = rawColumn.EXTRA) === null || _a === void 0 ? void 0 : _a.endsWith('GENERATED')),
         is_nullable: rawColumn.IS_NULLABLE === 'YES',
@@ -75,0 +76,0 @@ is_unique: rawColumn.COLUMN_KEY === 'UNI',

dist/dialects/oracledb.js

@@ -42,2 +42,4 @@ "use strict";
 function rawColumnToColumn(rawColumn) {
+    var is_generated = rawColumn.VIRTUAL_COLUMN === 'YES';
+    var default_value = strip_quotes_1.stripQuotes(rawColumn.DATA_DEFAULT);
     return {
@@ -47,3 +49,4 @@ name: rawColumn.COLUMN_NAME,
         data_type: rawColumn.DATA_TYPE,
-        default_value: strip_quotes_1.stripQuotes(rawColumn.DATA_DEFAULT),
+        default_value: !is_generated ? default_value : null,
+        generation_expression: is_generated ? default_value : null,
         max_length: rawColumn.DATA_LENGTH,
@@ -50,0 +53,0 @@ numeric_precision: rawColumn.DATA_PRECISION,

dist/dialects/postgres.js

@@ -50,4 +50,4 @@ "use strict";
         data_type: rawColumn.data_type,
-        default_value: parseDefaultValue(rawColumn.column_default) ||
-            parseDefaultValue(rawColumn.generation_expression),
+        default_value: parseDefaultValue(rawColumn.column_default),
+        generation_expression: rawColumn.generation_expression || null,
         max_length: rawColumn.character_maximum_length,
@@ -54,0 +54,0 @@ numeric_precision: rawColumn.numeric_precision,

dist/dialects/sqlite.js

@@ -200,2 +200,3 @@ "use strict";
                                                     is_generated: raw.hidden !== 0,
+                                                    generation_expression: null,
                                                     is_nullable: raw.notnull === 0,
@@ -202,0 +203,0 @@ is_unique: !!(index === null || index === void 0 ? void 0 : index.unique),

dist/types/column.d.ts

@@ -13,2 +13,3 @@ export interface Column {
     is_generated: boolean;
+    generation_expression?: string | null;
     has_auto_increment: boolean;
@@ -15,0 +16,0 @@ foreign_key_table: string | null;

lib/dialects/mssql.ts

@@ -35,5 +35,4 @@ import { Knex } from 'knex';
     ...rawColumn,
-    default_value:
-      parseDefaultValue(rawColumn.default_value) ||
-      parseDefaultValue(rawColumn.generation_expression),
+    default_value: parseDefaultValue(rawColumn.default_value),
+    generation_expression: rawColumn.generation_expression || null,
     is_generated: !!rawColumn.is_generated,
@@ -236,6 +235,3 @@ is_unique: rawColumn.is_unique === true,
         END AS [is_nullable],
-        COALESCE(
-          object_definition ([c].[default_object_id]),
-          [cc].[definition]
-        ) AS [default_value],
+        object_definition ([c].[default_object_id]) AS [default_value],
         [i].[is_primary_key],
@@ -252,3 +248,4 @@ [i].[is_unique],
           [fk].[referenced_column_id]) AS [foreign_key_column],
-        [cc].[is_computed] as [is_generated]`)
+        [cc].[is_computed] as [is_generated],
+        [cc].[definition] as [generation_expression]`)
       )
@@ -255,0 +252,0 @@ .from(this.knex.raw(`??.[sys].[columns] [c]`, [dbName]))

lib/dialects/mysql.ts

@@ -55,5 +55,4 @@ import { Knex } from 'knex';
     data_type: dataType,
-    default_value:
-      parseDefaultValue(rawColumn.COLUMN_DEFAULT) ??
-      parseDefaultValue(rawColumn.GENERATION_EXPRESSION || null),
+    default_value: parseDefaultValue(rawColumn.COLUMN_DEFAULT),
+    generation_expression: rawColumn.GENERATION_EXPRESSION || null,
     max_length: rawColumn.CHARACTER_MAXIMUM_LENGTH,
@@ -60,0 +59,0 @@ numeric_precision: rawColumn.NUMERIC_PRECISION,

lib/dialects/oracledb.ts

@@ -26,2 +26,4 @@ import { Knex } from 'knex';
 export function rawColumnToColumn(rawColumn: RawColumn): Column {
+  const is_generated = rawColumn.VIRTUAL_COLUMN === 'YES';
+  const default_value = stripQuotes(rawColumn.DATA_DEFAULT);
   return {
@@ -31,3 +33,4 @@ name: rawColumn.COLUMN_NAME,
     data_type: rawColumn.DATA_TYPE,
-    default_value: stripQuotes(rawColumn.DATA_DEFAULT),
+    default_value: !is_generated ? default_value : null,
+    generation_expression: is_generated ? default_value : null,
     max_length: rawColumn.DATA_LENGTH,
@@ -34,0 +37,0 @@ numeric_precision: rawColumn.DATA_PRECISION,

lib/dialects/postgres.ts

@@ -42,5 +42,4 @@ import { Knex } from 'knex';
     data_type: rawColumn.data_type,
-    default_value:
-      parseDefaultValue(rawColumn.column_default) ||
-      parseDefaultValue(rawColumn.generation_expression),
+    default_value: parseDefaultValue(rawColumn.column_default),
+    generation_expression: rawColumn.generation_expression || null,
     max_length: rawColumn.character_maximum_length,
@@ -47,0 +46,0 @@ numeric_precision: rawColumn.numeric_precision,

lib/dialects/sqlite.ts

@@ -163,2 +163,3 @@ import { Knex } from 'knex';
           is_generated: raw.hidden !== 0,
+          generation_expression: null,
           is_nullable: raw.notnull === 0,
@@ -165,0 +166,0 @@ is_unique: !!index?.unique,

lib/types/column.ts

@@ -14,2 +14,3 @@ export interface Column {
   is_generated: boolean;
+  generation_expression?: string | null;
   has_auto_increment: boolean;
@@ -16,0 +17,0 @@ foreign_key_table: string | null;

package.json

 {
   "name": "knex-schema-inspector",
-  "version": "1.5.15",
+  "version": "1.6.0",
   "description": "Utility for extracting information about existing DB schema",
@@ -5,0 +5,0 @@ "main": "dist/index.js",

test/mssql.spec.ts

@@ -85,2 +85,3 @@ import knex, { Knex } from 'knex';
         { table: 'teams', column: 'name' },
+        { table: 'teams', column: 'name_upper' },
         { table: 'teams', column: 'uuid' },
@@ -103,2 +104,3 @@ { table: 'users', column: 'email' },
         { column: 'name', table: 'teams' },
+        { column: 'name_upper', table: 'teams' },
         { column: 'description', table: 'teams' },
@@ -124,2 +126,3 @@ { column: 'credits', table: 'teams' },
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -141,2 +144,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -158,2 +162,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -167,2 +172,19 @@ is_unique: false,
         {
+          name: 'name_upper',
+          table: 'teams',
+          data_type: 'nvarchar',
+          default_value: null,
+          max_length: 100,
+          numeric_precision: null,
+          numeric_scale: null,
+          is_generated: true,
+          generation_expression: '(upper([name]))',
+          is_nullable: true,
+          is_unique: false,
+          is_primary_key: false,
+          has_auto_increment: false,
+          foreign_key_column: null,
+          foreign_key_table: null,
+        },
+        {
           name: 'description',
@@ -176,2 +198,3 @@ table: 'teams',
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -193,2 +216,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -210,2 +234,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -227,2 +252,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -244,2 +270,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -261,2 +288,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -278,2 +306,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -295,2 +324,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -312,2 +342,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -329,2 +360,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -346,2 +378,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -363,2 +396,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -384,2 +418,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -401,2 +436,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -418,2 +454,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -427,2 +464,19 @@ is_unique: false,
         {
+          name: 'name_upper',
+          table: 'teams',
+          data_type: 'nvarchar',
+          default_value: null,
+          max_length: 100,
+          numeric_precision: null,
+          numeric_scale: null,
+          is_generated: true,
+          generation_expression: '(upper([name]))',
+          is_nullable: true,
+          is_unique: false,
+          is_primary_key: false,
+          has_auto_increment: false,
+          foreign_key_column: null,
+          foreign_key_table: null,
+        },
+        {
           name: 'description',
@@ -436,2 +490,3 @@ table: 'teams',
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -453,2 +508,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -470,2 +526,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -487,2 +544,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -507,2 +565,3 @@ is_unique: false,
         is_generated: false,
+        generation_expression: null,
         is_nullable: false,
@@ -509,0 +568,0 @@ is_unique: true,

test/mysql.spec.ts

@@ -93,2 +93,3 @@ import knex, { Knex } from 'knex';
         { table: 'teams', column: 'name' },
+        { table: 'teams', column: 'name_upper' },
         { table: 'teams', column: 'description' },
@@ -111,2 +112,3 @@ { table: 'teams', column: 'credits' },
         { column: 'name', table: 'teams' },
+        { column: 'name_upper', table: 'teams' },
         { column: 'description', table: 'teams' },
@@ -132,2 +134,3 @@ { column: 'credits', table: 'teams' },
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -150,2 +153,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -168,2 +172,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -186,2 +191,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -204,2 +210,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -222,2 +229,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -240,2 +248,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -258,2 +267,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -268,2 +278,20 @@ is_unique: false,
         {
+          name: 'name_upper',
+          table: 'teams',
+          data_type: 'varchar',
+          default_value: null,
+          max_length: 100,
+          numeric_precision: null,
+          numeric_scale: null,
+          is_generated: true,
+          generation_expression: 'upper(`name`)',
+          is_nullable: true,
+          is_unique: false,
+          is_primary_key: false,
+          has_auto_increment: false,
+          foreign_key_column: null,
+          foreign_key_table: null,
+          comment: '',
+        },
+        {
           name: 'description',
@@ -277,2 +305,3 @@ table: 'teams',
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -295,2 +324,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -313,2 +343,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -331,2 +362,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -349,2 +381,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -367,2 +400,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -385,2 +419,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -408,2 +443,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -426,2 +462,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -444,2 +481,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -454,2 +492,20 @@ is_unique: false,
         {
+          name: 'name_upper',
+          table: 'teams',
+          data_type: 'varchar',
+          default_value: null,
+          max_length: 100,
+          numeric_precision: null,
+          numeric_scale: null,
+          is_generated: true,
+          generation_expression: 'upper(`name`)',
+          is_nullable: true,
+          is_unique: false,
+          is_primary_key: false,
+          has_auto_increment: false,
+          foreign_key_column: null,
+          foreign_key_table: null,
+          comment: '',
+        },
+        {
           name: 'description',
@@ -463,2 +519,3 @@ table: 'teams',
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -481,2 +538,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -499,2 +557,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -517,2 +576,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -539,2 +599,3 @@ is_unique: false,
         is_generated: false,
+        generation_expression: null,
         is_nullable: false,
@@ -541,0 +602,0 @@ is_unique: true,

test/oracle.spec.ts

@@ -68,2 +68,3 @@ import knex, { Knex } from 'knex';
         { table: 'TEAMS', column: 'NAME' },
+        { table: 'TEAMS', column: 'NAME_UPPER' },
         { table: 'TEAMS', column: 'DESCRIPTION' },
@@ -89,2 +90,3 @@ { table: 'TEAMS', column: 'CREDITS' },
         { column: 'NAME', table: 'TEAMS' },
+        { column: 'NAME_UPPER', table: 'TEAMS' },
         { column: 'DESCRIPTION', table: 'TEAMS' },
@@ -110,2 +112,3 @@ { column: 'CREDITS', table: 'TEAMS' },
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -128,2 +131,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -146,2 +150,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -164,2 +169,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -182,2 +188,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -200,2 +207,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -210,2 +218,20 @@ is_unique: false,
         {
+          name: 'NAME_UPPER',
+          table: 'TEAMS',
+          data_type: 'VARCHAR2',
+          default_value: null,
+          max_length: 100,
+          numeric_precision: null,
+          numeric_scale: null,
+          is_generated: true,
+          generation_expression: 'UPPER("NAME")',
+          is_nullable: true,
+          is_unique: false,
+          is_primary_key: false,
+          has_auto_increment: false,
+          foreign_key_column: null,
+          foreign_key_table: null,
+          comment: null,
+        },
+        {
           name: 'UUID',
@@ -219,2 +245,3 @@ table: 'TEAMS',
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -237,2 +264,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -255,2 +283,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -273,2 +302,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -291,2 +321,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -309,2 +340,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -327,2 +359,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -345,2 +378,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -363,2 +397,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -386,2 +421,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -404,2 +440,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -422,2 +459,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -440,2 +478,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -458,2 +497,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -476,2 +516,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -486,2 +527,20 @@ is_unique: false,
         {
+          name: 'NAME_UPPER',
+          table: 'TEAMS',
+          data_type: 'VARCHAR2',
+          default_value: null,
+          max_length: 100,
+          numeric_precision: null,
+          numeric_scale: null,
+          is_generated: true,
+          generation_expression: 'UPPER("NAME")',
+          is_nullable: true,
+          is_unique: false,
+          is_primary_key: false,
+          has_auto_increment: false,
+          foreign_key_column: null,
+          foreign_key_table: null,
+          comment: null,
+        },
+        {
           name: 'UUID',
@@ -495,2 +554,3 @@ table: 'TEAMS',
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -517,2 +577,3 @@ is_unique: true,
         is_generated: false,
+        generation_expression: null,
         is_nullable: false,
@@ -519,0 +580,0 @@ is_unique: true,

test/postgres.spec.ts

@@ -85,2 +85,3 @@ import knex, { Knex } from 'knex';
           { table: 'teams', column: 'name' },
+          { table: 'teams', column: 'name_upper' },
           { table: 'teams', column: 'activated_at' },
@@ -106,2 +107,3 @@ ]);
         { table: 'teams', column: 'name' },
+        { table: 'teams', column: 'name_upper' },
         { table: 'teams', column: 'activated_at' },
@@ -116,2 +118,3 @@ ]);
         { table: 'teams', column: 'name' },
+        { table: 'teams', column: 'name_upper' },
         { table: 'teams', column: 'description' },
@@ -137,2 +140,3 @@ { table: 'teams', column: 'credits' },
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -157,2 +161,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -177,2 +182,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -197,2 +203,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -217,2 +224,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -237,2 +245,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -257,2 +266,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -269,2 +279,22 @@ is_unique: false,
         {
+          name: 'name_upper',
+          table: 'teams',
+          data_type: 'character varying',
+          default_value: null,
+          max_length: 100,
+          numeric_precision: null,
+          numeric_scale: null,
+          is_generated: true,
+          generation_expression: 'upper((name)::text)',
+          is_nullable: true,
+          is_unique: false,
+          is_primary_key: false,
+          has_auto_increment: false,
+          foreign_key_column: null,
+          foreign_key_table: null,
+          comment: null,
+          schema: 'public',
+          foreign_key_schema: null,
+        },
+        {
           name: 'description',
@@ -278,2 +308,3 @@ table: 'teams',
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -298,2 +329,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -318,2 +350,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -338,2 +371,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -358,2 +392,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -378,2 +413,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -398,2 +434,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -418,2 +455,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -438,2 +476,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -463,2 +502,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -483,2 +523,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -503,2 +544,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -515,2 +557,22 @@ is_unique: false,
         {
+          name: 'name_upper',
+          table: 'teams',
+          data_type: 'character varying',
+          default_value: null,
+          max_length: 100,
+          numeric_precision: null,
+          numeric_scale: null,
+          is_generated: true,
+          generation_expression: 'upper((name)::text)',
+          is_nullable: true,
+          is_unique: false,
+          is_primary_key: false,
+          has_auto_increment: false,
+          foreign_key_column: null,
+          foreign_key_table: null,
+          comment: null,
+          schema: 'public',
+          foreign_key_schema: null,
+        },
+        {
           name: 'description',
@@ -524,2 +586,3 @@ table: 'teams',
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -544,2 +607,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -564,2 +628,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -584,2 +649,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -609,2 +675,3 @@ is_unique: false,
         is_generated: false,
+        generation_expression: null,
         is_nullable: false,
@@ -611,0 +678,0 @@ is_unique: true,

test/sqlite.spec.ts

@@ -148,2 +148,3 @@ import knex, { Knex } from 'knex';
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -165,2 +166,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -182,2 +184,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -199,2 +202,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -216,2 +220,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -233,2 +238,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -250,2 +256,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -267,2 +274,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -284,2 +292,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -301,2 +310,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -318,2 +328,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -335,2 +346,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -352,2 +364,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -369,2 +382,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -386,2 +400,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -408,2 +423,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -425,2 +441,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: false,
@@ -442,2 +459,3 @@ is_unique: true,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -459,2 +477,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -476,2 +495,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -493,2 +513,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -510,2 +531,3 @@ is_unique: false,
           is_generated: false,
+          generation_expression: null,
           is_nullable: true,
@@ -531,2 +553,3 @@ is_unique: false,
         is_generated: false,
+        generation_expression: null,
         is_nullable: false,
@@ -533,0 +556,0 @@ is_unique: true,

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

306065

increased by3.42%

Lines of code

6718

increased by4.28%

No dependency changes