sql-source-control - npm Package Compare versions

Comparing version 1.7.1 to 1.8.0

CHANGELOG.md

@@ -5,2 +5,19 @@ # Change Log
 
+<a name="1.8.0"></a>
+# [1.8.0](https://github.com/justinlettau/sql-source-control/compare/v1.7.1...v1.8.0) (2018-06-11)
+
+
+### Bug Fixes
+
+* **deps:** update dependency fs-extra to v6 ([#24](https://github.com/justinlettau/sql-source-control/issues/24)) ([77cdbb1](https://github.com/justinlettau/sql-source-control/commit/77cdbb1))
+* **deps:** update dependency inquirer to v6 ([#25](https://github.com/justinlettau/sql-source-control/issues/25)) ([65b047e](https://github.com/justinlettau/sql-source-control/commit/65b047e))
+
+
+### Features
+
+* add config to exclude output ([9d6a21d](https://github.com/justinlettau/sql-source-control/commit/9d6a21d))
+* add data scripting to pull ([#26](https://github.com/justinlettau/sql-source-control/issues/26)) ([d874206](https://github.com/justinlettau/sql-source-control/commit/d874206))
+
+
+
 <a name="1.7.1"></a>
@@ -7,0 +24,0 @@ ## [1.7.1](https://github.com/justinlettau/sql-source-control/compare/v1.7.0...v1.7.1) (2018-04-04)

dist/commands/cat.js

@@ -16,4 +16,3 @@ "use strict";
     var files = util.getFilesOrdered(config);
-    for (var _i = 0, files_1 = files; _i < files_1.length; _i++) {
-        var file = files_1[_i];
+    files.forEach(function (file) {
         var content = fs.readFileSync(file).toString();
@@ -25,3 +24,3 @@ var end = content.substr(-2).toLowerCase();
         output += os_1.EOL + os_1.EOL;
-    }
+    });
     fs.outputFileSync(config.output.root + "/cat.sql", output);
@@ -28,0 +27,0 @@ var time = process.hrtime(start);

dist/commands/cat.js.map

@@ -1,1 +0,1 @@
-{"version":3,"file":"cat.js","sourceRoot":"","sources":["../../src/commands/cat.ts"],"names":[],"mappings":";;AAAA,+BAA0B;AAC1B,6BAA+B;AAE/B,yBAAyB;AAGzB,wCAA0C;AAE1C;;GAEG;AACH;IACE,IAAM,KAAK,GAAqB,OAAO,CAAC,MAAM,EAAE,CAAC;IACjD,IAAM,MAAM,GAAW,IAAI,CAAC,SAAS,EAAE,CAAC;IACxC,IAAI,MAAM,GAAW,EAAE,CAAC;IAExB,qBAAqB;IACrB,IAAM,KAAK,GAAa,IAAI,CAAC,eAAe,CAAC,MAAM,CAAC,CAAC;IAErD,GAAG,CAAC,CAAe,UAAK,EAAL,eAAK,EAAL,mBAAK,EAAL,IAAK;QAAnB,IAAM,IAAI,cAAA;QACb,IAAM,OAAO,GAAW,EAAE,CAAC,YAAY,CAAC,IAAI,CAAC,CAAC,QAAQ,EAAE,CAAC;QACzD,IAAM,GAAG,GAAW,OAAO,CAAC,MAAM,CAAC,CAAC,CAAC,CAAC,CAAC,WAAW,EAAE,CAAC;QAErD,MAAM,IAAI,OAAO,CAAC;QAClB,MAAM,IAAI,QAAG,CAAC;QACd,MAAM,IAAI,CAAC,GAAG,KAAK,IAAI,CAAC,CAAC,CAAC,IAAI,CAAC,CAAC,CAAC,EAAE,CAAC,CAAC;QACrC,MAAM,IAAI,QAAG,GAAG,QAAG,CAAC;KACrB;IAED,EAAE,CAAC,cAAc,CAAI,MAAM,CAAC,MAAM,CAAC,IAAI,aAAU,EAAE,MAAM,CAAC,CAAC;IAE3D,IAAM,IAAI,GAAqB,OAAO,CAAC,MAAM,CAAC,KAAK,CAAC,CAAC;IACrD,OAAO,CAAC,GAAG,CAAC,eAAK,CAAC,KAAK,CAAC,oBAAkB,IAAI,CAAC,CAAC,CAAC,OAAI,CAAC,CAAC,CAAC;AAC1D,CAAC;AAtBD,kBAsBC"}
+{"version":3,"file":"cat.js","sourceRoot":"","sources":["../../src/commands/cat.ts"],"names":[],"mappings":";;AAAA,+BAA0B;AAC1B,6BAA+B;AAC/B,yBAAyB;AAGzB,wCAA0C;AAE1C;;GAEG;AACH;IACE,IAAM,KAAK,GAAqB,OAAO,CAAC,MAAM,EAAE,CAAC;IACjD,IAAM,MAAM,GAAW,IAAI,CAAC,SAAS,EAAE,CAAC;IACxC,IAAI,MAAM,GAAW,EAAE,CAAC;IAExB,qBAAqB;IACrB,IAAM,KAAK,GAAa,IAAI,CAAC,eAAe,CAAC,MAAM,CAAC,CAAC;IAErD,KAAK,CAAC,OAAO,CAAC,UAAA,IAAI;QAChB,IAAM,OAAO,GAAW,EAAE,CAAC,YAAY,CAAC,IAAI,CAAC,CAAC,QAAQ,EAAE,CAAC;QACzD,IAAM,GAAG,GAAW,OAAO,CAAC,MAAM,CAAC,CAAC,CAAC,CAAC,CAAC,WAAW,EAAE,CAAC;QAErD,MAAM,IAAI,OAAO,CAAC;QAClB,MAAM,IAAI,QAAG,CAAC;QACd,MAAM,IAAI,CAAC,GAAG,KAAK,IAAI,CAAC,CAAC,CAAC,IAAI,CAAC,CAAC,CAAC,EAAE,CAAC,CAAC;QACrC,MAAM,IAAI,QAAG,GAAG,QAAG,CAAC;IACtB,CAAC,CAAC,CAAC;IAEH,EAAE,CAAC,cAAc,CAAI,MAAM,CAAC,MAAM,CAAC,IAAI,aAAU,EAAE,MAAM,CAAC,CAAC;IAE3D,IAAM,IAAI,GAAqB,OAAO,CAAC,MAAM,CAAC,KAAK,CAAC,CAAC;IACrD,OAAO,CAAC,GAAG,CAAC,eAAK,CAAC,KAAK,CAAC,oBAAkB,IAAI,CAAC,CAAC,CAAC,OAAI,CAAC,CAAC,CAAC;AAC1D,CAAC;AAtBD,kBAsBC"}

dist/commands/conns.js

@@ -15,4 +15,3 @@ "use strict";
     });
-    for (var _i = 0, connections_1 = connections; _i < connections_1.length; _i++) {
-        var conn = connections_1[_i];
+    connections.forEach(function (conn) {
         table.push([
@@ -26,3 +25,3 @@ conn.name || placeholder,
         ]);
-    }
+    });
     console.log(table.toString());
@@ -29,0 +28,0 @@ }

dist/commands/conns.js.map

@@ -1,1 +0,1 @@
-{"version":3,"file":"conns.js","sourceRoot":"","sources":["../../src/commands/conns.ts"],"names":[],"mappings":";;AAAA,iCAAmC;AAInC,wCAA0C;AAE1C;;GAEG;AACH;IACE,IAAM,MAAM,GAAW,IAAI,CAAC,SAAS,EAAE,CAAC;IACxC,IAAM,WAAW,GAAiB,IAAI,CAAC,QAAQ,CAAC,MAAM,CAAC,CAAC;IACxD,IAAM,WAAW,GAAW,KAAK,CAAC;IAElC,IAAM,KAAK,GAAU,IAAI,KAAK,CAAC;QAC7B,IAAI,EAAE,CAAC,MAAM,EAAE,QAAQ,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,EAAE,UAAU,CAAC;KACjE,CAAC,CAAC;IAEH,GAAG,CAAC,CAAe,UAAW,EAAX,2BAAW,EAAX,yBAAW,EAAX,IAAW;QAAzB,IAAM,IAAI,oBAAA;QACb,KAAK,CAAC,IAAI,CAAC;YACT,IAAI,CAAC,IAAI,IAAI,WAAW;YACxB,IAAI,CAAC,MAAM,IAAI,WAAW;YAC1B,IAAI,CAAC,IAAI,IAAI,WAAW;YACxB,IAAI,CAAC,QAAQ,IAAI,WAAW;YAC5B,IAAI,CAAC,IAAI,IAAI,WAAW;YACxB,IAAI,CAAC,QAAQ,IAAI,WAAW;SAC7B,CAAC,CAAC;KACJ;IAED,OAAO,CAAC,GAAG,CAAC,KAAK,CAAC,QAAQ,EAAE,CAAC,CAAC;AAChC,CAAC;AArBD,sBAqBC"}
+{"version":3,"file":"conns.js","sourceRoot":"","sources":["../../src/commands/conns.ts"],"names":[],"mappings":";;AAAA,iCAAmC;AAInC,wCAA0C;AAE1C;;GAEG;AACH;IACE,IAAM,MAAM,GAAW,IAAI,CAAC,SAAS,EAAE,CAAC;IACxC,IAAM,WAAW,GAAiB,IAAI,CAAC,QAAQ,CAAC,MAAM,CAAC,CAAC;IACxD,IAAM,WAAW,GAAW,KAAK,CAAC;IAElC,IAAM,KAAK,GAAU,IAAI,KAAK,CAAC;QAC7B,IAAI,EAAE,CAAC,MAAM,EAAE,QAAQ,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,EAAE,UAAU,CAAC;KACjE,CAAC,CAAC;IAEH,WAAW,CAAC,OAAO,CAAC,UAAA,IAAI;QACtB,KAAK,CAAC,IAAI,CAAC;YACT,IAAI,CAAC,IAAI,IAAI,WAAW;YACxB,IAAI,CAAC,MAAM,IAAI,WAAW;YAC1B,IAAI,CAAC,IAAI,IAAI,WAAW;YACxB,IAAI,CAAC,QAAQ,IAAI,WAAW;YAC5B,IAAI,CAAC,IAAI,IAAI,WAAW;YACxB,IAAI,CAAC,QAAQ,IAAI,WAAW;SAC7B,CAAC,CAAC;IACL,CAAC,CAAC,CAAC;IAEH,OAAO,CAAC,GAAG,CAAC,KAAK,CAAC,QAAQ,EAAE,CAAC,CAAC;AAChC,CAAC;AArBD,sBAqBC"}

dist/commands/pull.js

@@ -35,3 +35,7 @@ "use strict";
             pool.request().query(sys_1.tvpRead)
-        ]).then(function (results) {
+        ].concat(config.data.map(function (table) {
+            return pool.request()
+                .query("select * from " + table)
+                .then(function (result) { return ({ name: table, type: 'DATA', result: result }); });
+        }))).then(function (results) {
             pool.close();
@@ -65,2 +69,3 @@ return results;
     var tvps = results[6].recordset;
+    var data = results.slice(7);
     // get unique schema names
@@ -72,7 +77,6 @@ var schemas = tables
     // write files for schemas
-    for (var _i = 0, schemas_1 = schemas; _i < schemas_1.length; _i++) {
-        var item = schemas_1[_i];
+    schemas.forEach(function (item) {
         var file = util.safeFile(item.name + ".sql");
-        if (!include(config, file)) {
-            continue;
+        if (!include(config.files, file)) {
+            return;
         }
@@ -82,19 +86,17 @@ var content = script.schema(item);
         exclude(config, existing, dir);
-    }
+    });
     // write files for stored procedures, functions, ect.
-    for (var _a = 0, objects_1 = objects; _a < objects_1.length; _a++) {
-        var item = objects_1[_a];
+    objects.forEach(function (item) {
         var file = util.safeFile(item.schema + "." + item.name + ".sql");
-        if (!include(config, file)) {
-            continue;
+        if (!include(config.files, file)) {
+            return;
         }
         var dir = createFile(config, item, file, item.text);
         exclude(config, existing, dir);
-    }
+    });
     // write files for tables
-    for (var _b = 0, tables_1 = tables; _b < tables_1.length; _b++) {
-        var item = tables_1[_b];
+    tables.forEach(function (item) {
         var file = util.safeFile(item.schema + "." + item.name + ".sql");
-        if (!include(config, file)) {
-            continue;
+        if (!include(config.files, file)) {
+            return;
         }
@@ -104,9 +106,8 @@ var content = script.table(item, columns, primaryKeys, foreignKeys, indexes);
         exclude(config, existing, dir);
-    }
+    });
     // write files for user-defined table-valued parameter
-    for (var _c = 0, tvps_1 = tvps; _c < tvps_1.length; _c++) {
-        var item = tvps_1[_c];
+    tvps.forEach(function (item) {
         var file = util.safeFile(item.schema + "." + item.name + ".sql");
-        if (!include(config, file)) {
-            continue;
+        if (!include(config.files, file)) {
+            return;
         }
@@ -116,3 +117,13 @@ var content = script.tvp(item, columns);
         exclude(config, existing, dir);
-    }
+    });
+    // write files for data
+    data.forEach(function (item) {
+        var file = util.safeFile(item.name + ".sql");
+        if (!include(config.data, item.name)) {
+            return;
+        }
+        var content = script.data(item);
+        var dir = createFile(config, item, file, content);
+        exclude(config, existing, dir);
+    });
     // all remaining files in `existing` need deleted
@@ -138,2 +149,6 @@ removeFiles(existing);
             break;
+        case 'DATA':// not a real object type
+            output = config.output.data;
+            type = null;
+            break;
         case 'U':
@@ -171,19 +186,21 @@ output = config.output.tables;
     }
-    // get full output path
-    dir = path.join(config.output.root, output, file);
-    // idempotent prefix
-    content = script.idempotency(item, type) + content;
-    // create file
-    console.log("Creating " + chalk_1.default.cyan(dir) + " ...");
-    fs.outputFileSync(dir, content.trim());
+    if (output) {
+        // get full output path
+        dir = path.join(config.output.root, output, file);
+        // idempotent prefix
+        content = script.idempotency(item, type) + content;
+        // create file
+        console.log("Creating " + chalk_1.default.cyan(dir) + " ...");
+        fs.outputFileSync(dir, content.trim());
+    }
     return dir;
 }
 /**
- * Check if a file passes the `files` glob pattern.
+ * Check if a file passes the glob pattern.
  *
- * @param config Current configuration to use.
+ * @param files Glob pattern to check against.
  * @param file File path to check.
  */
-function include(config, file) {
-    if (!config.files || !config.files.length) {
+function include(files, file) {
+    if (!files || !files.length) {
         return true;
@@ -194,3 +211,3 @@ }
     }
-    var results = multimatch(file, config.files);
+    var results = multimatch(file, files);
     return !!results.length;
@@ -206,2 +223,5 @@ }
 function exclude(config, existing, dir) {
+    if (!dir) {
+        return;
+    }
     if (config.output.root.startsWith('./') && !dir.startsWith('./')) {
@@ -221,8 +241,7 @@ dir = "./" + dir;
 function removeFiles(files) {
-    for (var _i = 0, files_1 = files; _i < files_1.length; _i++) {
-        var file = files_1[_i];
+    files.forEach(function (file) {
         console.log("Removing " + chalk_1.default.cyan(file) + " ...");
         fs.removeSync(file);
-    }
+    });
 }
 //# sourceMappingURL=pull.js.map

dist/commands/pull.js.map

@@ -1,1 +0,1 @@
-{"version":3,"file":"pull.js","sourceRoot":"","sources":["../../src/commands/pull.ts"],"names":[],"mappings":";;AAAA,+BAA0B;AAC1B,6BAA+B;AAC/B,2BAA6B;AAC7B,2BAA6B;AAC7B,uCAAyC;AACzC,2BAA6B;AAC7B,yCAAqC;AAKrC,wCAA0C;AAW1C,sCAAwC;AACxC,kCAQsB;AAEtB;;;;GAIG;AACH,cAAqB,IAAY;IAC/B,IAAM,KAAK,GAAqB,OAAO,CAAC,MAAM,EAAE,CAAC;IACjD,IAAM,MAAM,GAAW,IAAI,CAAC,SAAS,EAAE,CAAC;IACxC,IAAM,IAAI,GAAe,IAAI,CAAC,OAAO,CAAC,MAAM,EAAE,IAAI,CAAC,CAAC;IAEpD,OAAO,CAAC,GAAG,CAAC,aAAW,eAAK,CAAC,OAAO,CAAC,IAAI,CAAC,QAAQ,CAAC,cAAS,eAAK,CAAC,OAAO,CAAC,IAAI,CAAC,MAAM,CAAC,SAAM,CAAC,CAAC;IAE9F,gBAAgB;IAChB,IAAI,GAAG,CAAC,cAAc,CAAC,IAAI,CAAC;SACzB,OAAO,EAAE;SACT,IAAI,CAAC,UAAC,IAAwB;QAC7B,MAAM,CAAC,OAAO,CAAC,GAAG,CAAC;YACjB,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,gBAAU,CAAC;YAChC,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,eAAS,CAAC;YAC/B,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,gBAAU,CAAC;YAChC,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,oBAAc,CAAC;YACpC,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,oBAAc,CAAC;YACpC,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,eAAS,CAAC;YAC/B,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,aAAO,CAAC;SAC9B,CAAC,CAAC,IAAI,CAAC,UAAA,OAAO;YACb,IAAI,CAAC,KAAK,EAAE,CAAC;YACb,MAAM,CAAC,OAAO,CAAC;QACjB,CAAC,CAAC,CAAC;IACL,CAAC,CAAC;SACD,IAAI,CAAC,UAAA,OAAO,IAAI,OAAA,WAAW,CAAC,MAAM,EAAE,OAAO,CAAC,EAA5B,CAA4B,CAAC;SAC7C,IAAI,CAAC;QACJ,IAAM,IAAI,GAAqB,OAAO,CAAC,MAAM,CAAC,KAAK,CAAC,CAAC;QACrD,OAAO,CAAC,GAAG,CAAC,eAAK,CAAC,KAAK,CAAC,oBAAkB,IAAI,CAAC,CAAC,CAAC,OAAI,CAAC,CAAC,CAAC;IAC1D,CAAC,CAAC;SACD,KAAK,CAAC,UAAA,GAAG,IAAI,OAAA,OAAO,CAAC,KAAK,CAAC,GAAG,CAAC,EAAlB,CAAkB,CAAC,CAAC;AACtC,CAAC;AA9BD,oBA8BC;AAED;;;;;GAKG;AACH,qBAAqB,MAAc,EAAE,OAA2B;IAC9D,IAAM,QAAQ,GAAa,IAAI,CAAC,IAAI,CAAI,MAAM,CAAC,MAAM,CAAC,IAAI,cAAW,CAAC,CAAC;IAEvE,mDAAmD;IACnD,IAAM,OAAO,GAAsB,OAAO,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC;IACxD,IAAM,MAAM,GAAqB,OAAO,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC;IACtD,IAAM,OAAO,GAAsB,OAAO,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC;IACxD,IAAM,WAAW,GAA0B,OAAO,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC;IAChE,IAAM,WAAW,GAA0B,OAAO,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC;IAChE,IAAM,OAAO,GAAqB,OAAO,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC;IACvD,IAAM,IAAI,GAAmB,OAAO,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC;IAElD,0BAA0B;IAC1B,IAAM,OAAO,GAAsB,MAAM;SACtC,GAAG,CAAC,UAAA,IAAI,IAAI,OAAA,IAAI,CAAC,MAAM,EAAX,CAAW,CAAC;SACxB,MAAM,CAAC,UAAC,KAAK,EAAE,KAAK,EAAE,KAAK,IAAK,OAAA,KAAK,CAAC,OAAO,CAAC,KAAK,CAAC,KAAK,KAAK,EAA9B,CAA8B,CAAC;SAC/D,GAAG,CAAC,UAAA,KAAK,IAAI,OAAA,CAAC,EAAE,IAAI,EAAE,KAAK,EAAE,IAAI,EAAE,QAAQ,EAAE,CAAC,EAAjC,CAAiC,CAAC,CAAC;IAEnD,0BAA0B;IAC1B,GAAG,CAAC,CAAe,UAAO,EAAP,mBAAO,EAAP,qBAAO,EAAP,IAAO;QAArB,IAAM,IAAI,gBAAA;QACb,IAAM,IAAI,GAAW,IAAI,CAAC,QAAQ,CAAI,IAAI,CAAC,IAAI,SAAM,CAAC,CAAC;QAEvD,EAAE,CAAC,CAAC,CAAC,OAAO,CAAC,MAAM,EAAE,IAAI,CAAC,CAAC,CAAC,CAAC;YAC3B,QAAQ,CAAC;QACX,CAAC;QAED,IAAM,OAAO,GAAW,MAAM,CAAC,MAAM,CAAC,IAAI,CAAC,CAAC;QAC5C,IAAM,GAAG,GAAW,UAAU,CAAC,MAAM,EAAE,IAAI,EAAE,IAAI,EAAE,OAAO,CAAC,CAAC;QAC5D,OAAO,CAAC,MAAM,EAAE,QAAQ,EAAE,GAAG,CAAC,CAAC;KAChC;IAED,qDAAqD;IACrD,GAAG,CAAC,CAAe,UAAO,EAAP,mBAAO,EAAP,qBAAO,EAAP,IAAO;QAArB,IAAM,IAAI,gBAAA;QACb,IAAM,IAAI,GAAW,IAAI,CAAC,QAAQ,CAAI,IAAI,CAAC,MAAM,SAAI,IAAI,CAAC,IAAI,SAAM,CAAC,CAAC;QAEtE,EAAE,CAAC,CAAC,CAAC,OAAO,CAAC,MAAM,EAAE,IAAI,CAAC,CAAC,CAAC,CAAC;YAC3B,QAAQ,CAAC;QACX,CAAC;QAED,IAAM,GAAG,GAAW,UAAU,CAAC,MAAM,EAAE,IAAI,EAAE,IAAI,EAAE,IAAI,CAAC,IAAI,CAAC,CAAC;QAC9D,OAAO,CAAC,MAAM,EAAE,QAAQ,EAAE,GAAG,CAAC,CAAC;KAChC;IAED,yBAAyB;IACzB,GAAG,CAAC,CAAe,UAAM,EAAN,iBAAM,EAAN,oBAAM,EAAN,IAAM;QAApB,IAAM,IAAI,eAAA;QACb,IAAM,IAAI,GAAW,IAAI,CAAC,QAAQ,CAAI,IAAI,CAAC,MAAM,SAAI,IAAI,CAAC,IAAI,SAAM,CAAC,CAAC;QAEtE,EAAE,CAAC,CAAC,CAAC,OAAO,CAAC,MAAM,EAAE,IAAI,CAAC,CAAC,CAAC,CAAC;YAC3B,QAAQ,CAAC;QACX,CAAC;QAED,IAAM,OAAO,GAAW,MAAM,CAAC,KAAK,CAAC,IAAI,EAAE,OAAO,EAAE,WAAW,EAAE,WAAW,EAAE,OAAO,CAAC,CAAC;QACvF,IAAM,GAAG,GAAW,UAAU,CAAC,MAAM,EAAE,IAAI,EAAE,IAAI,EAAE,OAAO,CAAC,CAAC;QAC5D,OAAO,CAAC,MAAM,EAAE,QAAQ,EAAE,GAAG,CAAC,CAAC;KAChC;IAED,sDAAsD;IACtD,GAAG,CAAC,CAAe,UAAI,EAAJ,aAAI,EAAJ,kBAAI,EAAJ,IAAI;QAAlB,IAAM,IAAI,aAAA;QACb,IAAM,IAAI,GAAW,IAAI,CAAC,QAAQ,CAAI,IAAI,CAAC,MAAM,SAAI,IAAI,CAAC,IAAI,SAAM,CAAC,CAAC;QAEtE,EAAE,CAAC,CAAC,CAAC,OAAO,CAAC,MAAM,EAAE,IAAI,CAAC,CAAC,CAAC,CAAC;YAC3B,QAAQ,CAAC;QACX,CAAC;QAED,IAAM,OAAO,GAAW,MAAM,CAAC,GAAG,CAAC,IAAI,EAAE,OAAO,CAAC,CAAC;QAClD,IAAM,GAAG,GAAW,UAAU,CAAC,MAAM,EAAE,IAAI,EAAE,IAAI,EAAE,OAAO,CAAC,CAAC;QAC5D,OAAO,CAAC,MAAM,EAAE,QAAQ,EAAE,GAAG,CAAC,CAAC;KAChC;IAED,iDAAiD;IACjD,WAAW,CAAC,QAAQ,CAAC,CAAC;AACxB,CAAC;AAED;;;;;;;GAOG;AACH,oBAAoB,MAAc,EAAE,IAAS,EAAE,IAAY,EAAE,OAAe;IAC1E,IAAI,GAAW,CAAC;IAChB,IAAI,MAAc,CAAC;IACnB,IAAI,IAAuB,CAAC;IAE5B,MAAM,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,IAAI,EAAE,CAAC,CAAC,CAAC;QACzB,KAAK,QAAQ,CAAE,yBAAyB;YACtC,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,OAAO,CAAC;YAC/B,IAAI,GAAG,IAAI,CAAC;YACZ,KAAK,CAAC;QACR,KAAK,GAAG;YACN,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,MAAM,CAAC;YAC9B,IAAI,GAAG,MAAM,CAAC,WAAW,CAAC,MAAM,CAAC;YACjC,KAAK,CAAC;QACR,KAAK,GAAG;YACN,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,KAAK,CAAC;YAC7B,IAAI,GAAG,MAAM,CAAC,WAAW,CAAC,KAAK,CAAC;YAChC,KAAK,CAAC;QACR,KAAK,GAAG;YACN,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,KAAK,CAAC;YAC7B,IAAI,GAAG,MAAM,CAAC,WAAW,CAAC,KAAK,CAAC;YAChC,KAAK,CAAC;QACR,KAAK,IAAI,CAAC;QACV,KAAK,IAAI;YACP,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,cAAc,CAAC,CAAC;YACvC,IAAI,GAAG,MAAM,CAAC,WAAW,CAAC,cAAc,CAAC,CAAC;YAC1C,KAAK,CAAC;QACR,KAAK,IAAI;YACP,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,eAAe,CAAC,CAAC;YACxC,IAAI,GAAG,MAAM,CAAC,WAAW,CAAC,eAAe,CAAC,CAAC;YAC3C,KAAK,CAAC;QACR,KAAK,IAAI;YACP,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,QAAQ,CAAC;YAChC,IAAI,GAAG,MAAM,CAAC,WAAW,CAAC,QAAQ,CAAC;YACnC,KAAK,CAAC;QACR,KAAK,IAAI;YACP,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,yBAAyB,CAAC,CAAC;YAClD,IAAI,GAAG,MAAM,CAAC,WAAW,CAAC,yBAAyB,CAAC,CAAC;YACrD,KAAK,CAAC;QACR;YACE,MAAM,GAAG,SAAS,CAAC;IACvB,CAAC;IAED,uBAAuB;IACvB,GAAG,GAAG,IAAI,CAAC,IAAI,CAAC,MAAM,CAAC,MAAM,CAAC,IAAI,EAAE,MAAM,EAAE,IAAI,CAAC,CAAC;IAElD,oBAAoB;IACpB,OAAO,GAAG,MAAM,CAAC,WAAW,CAAC,IAAI,EAAE,IAAI,CAAC,GAAG,OAAO,CAAC;IAEnD,cAAc;IACd,OAAO,CAAC,GAAG,CAAC,cAAY,eAAK,CAAC,IAAI,CAAC,GAAG,CAAC,SAAM,CAAC,CAAC;IAC/C,EAAE,CAAC,cAAc,CAAC,GAAG,EAAE,OAAO,CAAC,IAAI,EAAE,CAAC,CAAC;IAEvC,MAAM,CAAC,GAAG,CAAC;AACb,CAAC;AAED;;;;;GAKG;AACH,iBAAiB,MAAc,EAAE,IAAuB;IACtD,EAAE,CAAC,CAAC,CAAC,MAAM,CAAC,KAAK,IAAI,CAAC,MAAM,CAAC,KAAK,CAAC,MAAM,CAAC,CAAC,CAAC;QAC1C,MAAM,CAAC,IAAI,CAAC;IACd,CAAC;IAED,EAAE,CAAC,CAAC,CAAC,oBAAO,CAAC,IAAI,CAAC,CAAC,CAAC,CAAC;QACnB,IAAI,GAAG,CAAC,IAAI,CAAC,CAAC;IAChB,CAAC;IAED,IAAM,OAAO,GAAa,UAAU,CAAC,IAAI,EAAE,MAAM,CAAC,KAAK,CAAC,CAAC;IACzD,MAAM,CAAC,CAAC,CAAC,OAAO,CAAC,MAAM,CAAC;AAC1B,CAAC;AAED;;;;;;GAMG;AACH,iBAAiB,MAAc,EAAE,QAAkB,EAAE,GAAW;IAC9D,EAAE,CAAC,CAAC,MAAM,CAAC,MAAM,CAAC,IAAI,CAAC,UAAU,CAAC,IAAI,CAAC,IAAI,CAAC,GAAG,CAAC,UAAU,CAAC,IAAI,CAAC,CAAC,CAAC,CAAC;QACjE,GAAG,GAAG,OAAK,GAAK,CAAC;IACnB,CAAC;IAED,IAAM,KAAK,GAAW,QAAQ,CAAC,OAAO,CAAC,GAAG,CAAC,OAAO,CAAC,KAAK,EAAE,GAAG,CAAC,CAAC,CAAC;IAEhE,EAAE,CAAC,CAAC,KAAK,KAAK,CAAC,CAAC,CAAC,CAAC,CAAC;QACjB,QAAQ,CAAC,MAAM,CAAC,KAAK,EAAE,CAAC,CAAC,CAAC;IAC5B,CAAC;AACH,CAAC;AAED;;;;GAIG;AACH,qBAAqB,KAAe;IAClC,GAAG,CAAC,CAAe,UAAK,EAAL,eAAK,EAAL,mBAAK,EAAL,IAAK;QAAnB,IAAM,IAAI,cAAA;QACb,OAAO,CAAC,GAAG,CAAC,cAAY,eAAK,CAAC,IAAI,CAAC,IAAI,CAAC,SAAM,CAAC,CAAC;QAChD,EAAE,CAAC,UAAU,CAAC,IAAI,CAAC,CAAC;KACrB;AACH,CAAC"}
+{"version":3,"file":"pull.js","sourceRoot":"","sources":["../../src/commands/pull.ts"],"names":[],"mappings":";;AAAA,+BAA0B;AAC1B,6BAA+B;AAC/B,2BAA6B;AAC7B,2BAA6B;AAC7B,uCAAyC;AACzC,2BAA6B;AAC7B,yCAAqC;AAKrC,wCAA0C;AAY1C,sCAAwC;AACxC,kCAAmH;AAEnH;;;;GAIG;AACH,cAAqB,IAAY;IAC/B,IAAM,KAAK,GAAqB,OAAO,CAAC,MAAM,EAAE,CAAC;IACjD,IAAM,MAAM,GAAW,IAAI,CAAC,SAAS,EAAE,CAAC;IACxC,IAAM,IAAI,GAAe,IAAI,CAAC,OAAO,CAAC,MAAM,EAAE,IAAI,CAAC,CAAC;IAEpD,OAAO,CAAC,GAAG,CAAC,aAAW,eAAK,CAAC,OAAO,CAAC,IAAI,CAAC,QAAQ,CAAC,cAAS,eAAK,CAAC,OAAO,CAAC,IAAI,CAAC,MAAM,CAAC,SAAM,CAAC,CAAC;IAE9F,gBAAgB;IAChB,IAAI,GAAG,CAAC,cAAc,CAAC,IAAI,CAAC;SACzB,OAAO,EAAE;SACT,IAAI,CAAC,UAAA,IAAI;QACR,MAAM,CAAC,OAAO,CAAC,GAAG;YAChB,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,gBAAU,CAAC;YAChC,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,eAAS,CAAC;YAC/B,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,gBAAU,CAAC;YAChC,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,oBAAc,CAAC;YACpC,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,oBAAc,CAAC;YACpC,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,eAAS,CAAC;YAC/B,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,aAAO,CAAC;iBAC1B,MAAM,CAAC,IAAI,CAAC,GAAG,CAAC,UAAA,KAAK;YACtB,MAAM,CAAC,IAAI,CAAC,OAAO,EAAE;iBAClB,KAAK,CAAC,mBAAiB,KAAO,CAAC;iBAC/B,IAAI,CAAC,UAAA,MAAM,IAAI,OAAA,CAAC,EAAE,IAAI,EAAE,KAAK,EAAE,IAAI,EAAE,MAAM,EAAE,MAAM,QAAA,EAAE,CAAC,EAAvC,CAAuC,CAAC,CAAC;QAC7D,CAAC,CAAC,EACF,CAAC,IAAI,CAAC,UAAA,OAAO;YACb,IAAI,CAAC,KAAK,EAAE,CAAC;YACb,MAAM,CAAC,OAAO,CAAC;QACjB,CAAC,CAAC,CAAC;IACL,CAAC,CAAC;SACD,IAAI,CAAC,UAAA,OAAO,IAAI,OAAA,WAAW,CAAC,MAAM,EAAE,OAAO,CAAC,EAA5B,CAA4B,CAAC;SAC7C,IAAI,CAAC;QACJ,IAAM,IAAI,GAAqB,OAAO,CAAC,MAAM,CAAC,KAAK,CAAC,CAAC;QACrD,OAAO,CAAC,GAAG,CAAC,eAAK,CAAC,KAAK,CAAC,oBAAkB,IAAI,CAAC,CAAC,CAAC,OAAI,CAAC,CAAC,CAAC;IAC1D,CAAC,CAAC;SACD,KAAK,CAAC,UAAA,GAAG,IAAI,OAAA,OAAO,CAAC,KAAK,CAAC,GAAG,CAAC,EAAlB,CAAkB,CAAC,CAAC;AACtC,CAAC;AAnCD,oBAmCC;AAED;;;;;GAKG;AACH,qBAAqB,MAAc,EAAE,OAAc;IACjD,IAAM,QAAQ,GAAa,IAAI,CAAC,IAAI,CAAI,MAAM,CAAC,MAAM,CAAC,IAAI,cAAW,CAAC,CAAC;IAEvE,mDAAmD;IACnD,IAAM,OAAO,GAAsB,OAAO,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC;IACxD,IAAM,MAAM,GAAqB,OAAO,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC;IACtD,IAAM,OAAO,GAAsB,OAAO,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC;IACxD,IAAM,WAAW,GAA0B,OAAO,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC;IAChE,IAAM,WAAW,GAA0B,OAAO,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC;IAChE,IAAM,OAAO,GAAqB,OAAO,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC;IACvD,IAAM,IAAI,GAAmB,OAAO,CAAC,CAAC,CAAC,CAAC,SAAS,CAAC;IAClD,IAAM,IAAI,GAAoB,OAAO,CAAC,KAAK,CAAC,CAAC,CAAC,CAAC;IAE/C,0BAA0B;IAC1B,IAAM,OAAO,GAAsB,MAAM;SACtC,GAAG,CAAC,UAAA,IAAI,IAAI,OAAA,IAAI,CAAC,MAAM,EAAX,CAAW,CAAC;SACxB,MAAM,CAAC,UAAC,KAAK,EAAE,KAAK,EAAE,KAAK,IAAK,OAAA,KAAK,CAAC,OAAO,CAAC,KAAK,CAAC,KAAK,KAAK,EAA9B,CAA8B,CAAC;SAC/D,GAAG,CAAC,UAAA,KAAK,IAAI,OAAA,CAAC,EAAE,IAAI,EAAE,KAAK,EAAE,IAAI,EAAE,QAAQ,EAAE,CAAC,EAAjC,CAAiC,CAAC,CAAC;IAEnD,0BAA0B;IAC1B,OAAO,CAAC,OAAO,CAAC,UAAA,IAAI;QAClB,IAAM,IAAI,GAAW,IAAI,CAAC,QAAQ,CAAI,IAAI,CAAC,IAAI,SAAM,CAAC,CAAC;QAEvD,EAAE,CAAC,CAAC,CAAC,OAAO,CAAC,MAAM,CAAC,KAAK,EAAE,IAAI,CAAC,CAAC,CAAC,CAAC;YACjC,MAAM,CAAC;QACT,CAAC;QAED,IAAM,OAAO,GAAW,MAAM,CAAC,MAAM,CAAC,IAAI,CAAC,CAAC;QAC5C,IAAM,GAAG,GAAW,UAAU,CAAC,MAAM,EAAE,IAAI,EAAE,IAAI,EAAE,OAAO,CAAC,CAAC;QAC5D,OAAO,CAAC,MAAM,EAAE,QAAQ,EAAE,GAAG,CAAC,CAAC;IACjC,CAAC,CAAC,CAAC;IAEH,qDAAqD;IACrD,OAAO,CAAC,OAAO,CAAC,UAAA,IAAI;QAClB,IAAM,IAAI,GAAW,IAAI,CAAC,QAAQ,CAAI,IAAI,CAAC,MAAM,SAAI,IAAI,CAAC,IAAI,SAAM,CAAC,CAAC;QAEtE,EAAE,CAAC,CAAC,CAAC,OAAO,CAAC,MAAM,CAAC,KAAK,EAAE,IAAI,CAAC,CAAC,CAAC,CAAC;YACjC,MAAM,CAAC;QACT,CAAC;QAED,IAAM,GAAG,GAAW,UAAU,CAAC,MAAM,EAAE,IAAI,EAAE,IAAI,EAAE,IAAI,CAAC,IAAI,CAAC,CAAC;QAC9D,OAAO,CAAC,MAAM,EAAE,QAAQ,EAAE,GAAG,CAAC,CAAC;IACjC,CAAC,CAAC,CAAC;IAEH,yBAAyB;IACzB,MAAM,CAAC,OAAO,CAAC,UAAA,IAAI;QACjB,IAAM,IAAI,GAAW,IAAI,CAAC,QAAQ,CAAI,IAAI,CAAC,MAAM,SAAI,IAAI,CAAC,IAAI,SAAM,CAAC,CAAC;QAEtE,EAAE,CAAC,CAAC,CAAC,OAAO,CAAC,MAAM,CAAC,KAAK,EAAE,IAAI,CAAC,CAAC,CAAC,CAAC;YACjC,MAAM,CAAC;QACT,CAAC;QAED,IAAM,OAAO,GAAW,MAAM,CAAC,KAAK,CAAC,IAAI,EAAE,OAAO,EAAE,WAAW,EAAE,WAAW,EAAE,OAAO,CAAC,CAAC;QACvF,IAAM,GAAG,GAAW,UAAU,CAAC,MAAM,EAAE,IAAI,EAAE,IAAI,EAAE,OAAO,CAAC,CAAC;QAC5D,OAAO,CAAC,MAAM,EAAE,QAAQ,EAAE,GAAG,CAAC,CAAC;IACjC,CAAC,CAAC,CAAC;IAEH,sDAAsD;IACtD,IAAI,CAAC,OAAO,CAAC,UAAA,IAAI;QACf,IAAM,IAAI,GAAW,IAAI,CAAC,QAAQ,CAAI,IAAI,CAAC,MAAM,SAAI,IAAI,CAAC,IAAI,SAAM,CAAC,CAAC;QAEtE,EAAE,CAAC,CAAC,CAAC,OAAO,CAAC,MAAM,CAAC,KAAK,EAAE,IAAI,CAAC,CAAC,CAAC,CAAC;YACjC,MAAM,CAAC;QACT,CAAC;QAED,IAAM,OAAO,GAAW,MAAM,CAAC,GAAG,CAAC,IAAI,EAAE,OAAO,CAAC,CAAC;QAClD,IAAM,GAAG,GAAW,UAAU,CAAC,MAAM,EAAE,IAAI,EAAE,IAAI,EAAE,OAAO,CAAC,CAAC;QAC5D,OAAO,CAAC,MAAM,EAAE,QAAQ,EAAE,GAAG,CAAC,CAAC;IACjC,CAAC,CAAC,CAAC;IAEH,uBAAuB;IACvB,IAAI,CAAC,OAAO,CAAC,UAAA,IAAI;QACf,IAAM,IAAI,GAAW,IAAI,CAAC,QAAQ,CAAI,IAAI,CAAC,IAAI,SAAM,CAAC,CAAC;QAEvD,EAAE,CAAC,CAAC,CAAC,OAAO,CAAC,MAAM,CAAC,IAAI,EAAE,IAAI,CAAC,IAAI,CAAC,CAAC,CAAC,CAAC;YACrC,MAAM,CAAC;QACT,CAAC;QAED,IAAM,OAAO,GAAW,MAAM,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QAC1C,IAAM,GAAG,GAAW,UAAU,CAAC,MAAM,EAAE,IAAI,EAAE,IAAI,EAAE,OAAO,CAAC,CAAC;QAC5D,OAAO,CAAC,MAAM,EAAE,QAAQ,EAAE,GAAG,CAAC,CAAC;IACjC,CAAC,CAAC,CAAC;IAEH,iDAAiD;IACjD,WAAW,CAAC,QAAQ,CAAC,CAAC;AACxB,CAAC;AAED;;;;;;;GAOG;AACH,oBAAoB,MAAc,EAAE,IAAS,EAAE,IAAY,EAAE,OAAe;IAC1E,IAAI,GAAW,CAAC;IAChB,IAAI,MAAc,CAAC;IACnB,IAAI,IAAuB,CAAC;IAE5B,MAAM,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,IAAI,EAAE,CAAC,CAAC,CAAC;QACzB,KAAK,QAAQ,CAAE,yBAAyB;YACtC,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,OAAO,CAAC;YAC/B,IAAI,GAAG,IAAI,CAAC;YACZ,KAAK,CAAC;QACR,KAAK,MAAM,CAAE,yBAAyB;YACpC,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,IAAI,CAAC;YAC5B,IAAI,GAAG,IAAI,CAAC;YACZ,KAAK,CAAC;QACR,KAAK,GAAG;YACN,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,MAAM,CAAC;YAC9B,IAAI,GAAG,MAAM,CAAC,WAAW,CAAC,MAAM,CAAC;YACjC,KAAK,CAAC;QACR,KAAK,GAAG;YACN,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,KAAK,CAAC;YAC7B,IAAI,GAAG,MAAM,CAAC,WAAW,CAAC,KAAK,CAAC;YAChC,KAAK,CAAC;QACR,KAAK,GAAG;YACN,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,KAAK,CAAC;YAC7B,IAAI,GAAG,MAAM,CAAC,WAAW,CAAC,KAAK,CAAC;YAChC,KAAK,CAAC;QACR,KAAK,IAAI,CAAC;QACV,KAAK,IAAI;YACP,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,cAAc,CAAC,CAAC;YACvC,IAAI,GAAG,MAAM,CAAC,WAAW,CAAC,cAAc,CAAC,CAAC;YAC1C,KAAK,CAAC;QACR,KAAK,IAAI;YACP,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,eAAe,CAAC,CAAC;YACxC,IAAI,GAAG,MAAM,CAAC,WAAW,CAAC,eAAe,CAAC,CAAC;YAC3C,KAAK,CAAC;QACR,KAAK,IAAI;YACP,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,QAAQ,CAAC;YAChC,IAAI,GAAG,MAAM,CAAC,WAAW,CAAC,QAAQ,CAAC;YACnC,KAAK,CAAC;QACR,KAAK,IAAI;YACP,MAAM,GAAG,MAAM,CAAC,MAAM,CAAC,yBAAyB,CAAC,CAAC;YAClD,IAAI,GAAG,MAAM,CAAC,WAAW,CAAC,yBAAyB,CAAC,CAAC;YACrD,KAAK,CAAC;QACR;YACE,MAAM,GAAG,SAAS,CAAC;IACvB,CAAC;IAED,EAAE,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC;QAEX,uBAAuB;QACvB,GAAG,GAAG,IAAI,CAAC,IAAI,CAAC,MAAM,CAAC,MAAM,CAAC,IAAI,EAAE,MAAM,EAAE,IAAI,CAAC,CAAC;QAElD,oBAAoB;QACpB,OAAO,GAAG,MAAM,CAAC,WAAW,CAAC,IAAI,EAAE,IAAI,CAAC,GAAG,OAAO,CAAC;QAEnD,cAAc;QACd,OAAO,CAAC,GAAG,CAAC,cAAY,eAAK,CAAC,IAAI,CAAC,GAAG,CAAC,SAAM,CAAC,CAAC;QAC/C,EAAE,CAAC,cAAc,CAAC,GAAG,EAAE,OAAO,CAAC,IAAI,EAAE,CAAC,CAAC;IACzC,CAAC;IAED,MAAM,CAAC,GAAG,CAAC;AACb,CAAC;AAED;;;;;GAKG;AACH,iBAAiB,KAAe,EAAE,IAAuB;IACvD,EAAE,CAAC,CAAC,CAAC,KAAK,IAAI,CAAC,KAAK,CAAC,MAAM,CAAC,CAAC,CAAC;QAC5B,MAAM,CAAC,IAAI,CAAC;IACd,CAAC;IAED,EAAE,CAAC,CAAC,CAAC,oBAAO,CAAC,IAAI,CAAC,CAAC,CAAC,CAAC;QACnB,IAAI,GAAG,CAAC,IAAI,CAAC,CAAC;IAChB,CAAC;IAED,IAAM,OAAO,GAAa,UAAU,CAAC,IAAI,EAAE,KAAK,CAAC,CAAC;IAClD,MAAM,CAAC,CAAC,CAAC,OAAO,CAAC,MAAM,CAAC;AAC1B,CAAC;AAED;;;;;;GAMG;AACH,iBAAiB,MAAc,EAAE,QAAkB,EAAE,GAAW;IAC9D,EAAE,CAAC,CAAC,CAAC,GAAG,CAAC,CAAC,CAAC;QACT,MAAM,CAAC;IACT,CAAC;IAED,EAAE,CAAC,CAAC,MAAM,CAAC,MAAM,CAAC,IAAI,CAAC,UAAU,CAAC,IAAI,CAAC,IAAI,CAAC,GAAG,CAAC,UAAU,CAAC,IAAI,CAAC,CAAC,CAAC,CAAC;QACjE,GAAG,GAAG,OAAK,GAAK,CAAC;IACnB,CAAC;IAED,IAAM,KAAK,GAAW,QAAQ,CAAC,OAAO,CAAC,GAAG,CAAC,OAAO,CAAC,KAAK,EAAE,GAAG,CAAC,CAAC,CAAC;IAEhE,EAAE,CAAC,CAAC,KAAK,KAAK,CAAC,CAAC,CAAC,CAAC,CAAC;QACjB,QAAQ,CAAC,MAAM,CAAC,KAAK,EAAE,CAAC,CAAC,CAAC;IAC5B,CAAC;AACH,CAAC;AAED;;;;GAIG;AACH,qBAAqB,KAAe;IAClC,KAAK,CAAC,OAAO,CAAC,UAAA,IAAI;QAChB,OAAO,CAAC,GAAG,CAAC,cAAY,eAAK,CAAC,IAAI,CAAC,IAAI,CAAC,SAAM,CAAC,CAAC;QAChD,EAAE,CAAC,UAAU,CAAC,IAAI,CAAC,CAAC;IACtB,CAAC,CAAC,CAAC;AACL,CAAC"}

dist/commands/push.js

@@ -20,17 +20,12 @@ "use strict";
     var promise = new sql.ConnectionPool(conn).connect();
-    for (var _i = 0, files_1 = files; _i < files_1.length; _i++) {
-        var file = files_1[_i];
+    files.forEach(function (file) {
         console.log("Executing " + chalk_1.default.cyan(file) + " ...");
         var content = fs.readFileSync(file, 'utf8');
         var statements = content.split('go' + os_1.EOL);
-        var _loop_1 = function (statement) {
+        statements.forEach(function (statement) {
             promise = promise.then(function (pool) {
                 return pool.request().batch(statement).then(function (result) { return pool; });
             });
-        };
-        for (var _a = 0, statements_1 = statements; _a < statements_1.length; _a++) {
-            var statement = statements_1[_a];
-            _loop_1(statement);
-        }
-    }
+        });
+    });
     promise
@@ -37,0 +32,0 @@ .then(function () {

dist/commands/push.js.map

@@ -1,1 +0,1 @@
-{"version":3,"file":"push.js","sourceRoot":"","sources":["../../src/commands/push.ts"],"names":[],"mappings":";;AAAA,+BAA0B;AAC1B,6BAA+B;AAE/B,2BAA6B;AAC7B,yBAAyB;AAIzB,wCAA0C;AAE1C;;;;GAIG;AACH,cAAqB,IAAa;IAChC,IAAM,KAAK,GAAqB,OAAO,CAAC,MAAM,EAAE,CAAC;IACjD,IAAM,MAAM,GAAW,IAAI,CAAC,SAAS,EAAE,CAAC;IACxC,IAAM,IAAI,GAAe,IAAI,CAAC,OAAO,CAAC,MAAM,EAAE,IAAI,CAAC,CAAC;IAEpD,OAAO,CAAC,GAAG,CAAC,gBAAc,eAAK,CAAC,OAAO,CAAC,IAAI,CAAC,QAAQ,CAAC,YAAO,eAAK,CAAC,OAAO,CAAC,IAAI,CAAC,MAAM,CAAC,SAAM,CAAC,CAAC;IAE/F,IAAM,KAAK,GAAa,IAAI,CAAC,eAAe,CAAC,MAAM,CAAC,CAAC;IACrD,IAAI,OAAO,GAAgC,IAAI,GAAG,CAAC,cAAc,CAAC,IAAI,CAAC,CAAC,OAAO,EAAE,CAAC;IAElF,GAAG,CAAC,CAAe,UAAK,EAAL,eAAK,EAAL,mBAAK,EAAL,IAAK;QAAnB,IAAM,IAAI,cAAA;QACb,OAAO,CAAC,GAAG,CAAC,eAAa,eAAK,CAAC,IAAI,CAAC,IAAI,CAAC,SAAM,CAAC,CAAC;QAEjD,IAAM,OAAO,GAAW,EAAE,CAAC,YAAY,CAAC,IAAI,EAAE,MAAM,CAAC,CAAC;QACtD,IAAM,UAAU,GAAa,OAAO,CAAC,KAAK,CAAC,IAAI,GAAG,QAAG,CAAC,CAAC;gCAE5C,SAAS;YAClB,OAAO,GAAG,OAAO,CAAC,IAAI,CAAC,UAAA,IAAI;gBACzB,MAAM,CAAC,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,SAAS,CAAC,CAAC,IAAI,CAAC,UAAA,MAAM,IAAI,OAAA,IAAI,EAAJ,CAAI,CAAC,CAAC;YAC9D,CAAC,CAAC,CAAC;QACL,CAAC;QAJD,GAAG,CAAC,CAAoB,UAAU,EAAV,yBAAU,EAAV,wBAAU,EAAV,IAAU;YAA7B,IAAM,SAAS,mBAAA;oBAAT,SAAS;SAInB;KACF;IAED,OAAO;SACJ,IAAI,CAAC;QACJ,IAAM,IAAI,GAAqB,OAAO,CAAC,MAAM,CAAC,KAAK,CAAC,CAAC;QACrD,OAAO,CAAC,GAAG,CAAC,eAAK,CAAC,KAAK,CAAC,oBAAkB,IAAI,CAAC,CAAC,CAAC,OAAI,CAAC,CAAC,CAAC;IAC1D,CAAC,CAAC;SACD,KAAK,CAAC,UAAA,GAAG,IAAI,OAAA,OAAO,CAAC,KAAK,CAAC,GAAG,CAAC,EAAlB,CAAkB,CAAC,CAAC;AACtC,CAAC;AA7BD,oBA6BC"}
+{"version":3,"file":"push.js","sourceRoot":"","sources":["../../src/commands/push.ts"],"names":[],"mappings":";;AAAA,+BAA0B;AAC1B,6BAA+B;AAE/B,2BAA6B;AAC7B,yBAAyB;AAIzB,wCAA0C;AAE1C;;;;GAIG;AACH,cAAqB,IAAa;IAChC,IAAM,KAAK,GAAqB,OAAO,CAAC,MAAM,EAAE,CAAC;IACjD,IAAM,MAAM,GAAW,IAAI,CAAC,SAAS,EAAE,CAAC;IACxC,IAAM,IAAI,GAAe,IAAI,CAAC,OAAO,CAAC,MAAM,EAAE,IAAI,CAAC,CAAC;IAEpD,OAAO,CAAC,GAAG,CAAC,gBAAc,eAAK,CAAC,OAAO,CAAC,IAAI,CAAC,QAAQ,CAAC,YAAO,eAAK,CAAC,OAAO,CAAC,IAAI,CAAC,MAAM,CAAC,SAAM,CAAC,CAAC;IAE/F,IAAM,KAAK,GAAa,IAAI,CAAC,eAAe,CAAC,MAAM,CAAC,CAAC;IACrD,IAAI,OAAO,GAAgC,IAAI,GAAG,CAAC,cAAc,CAAC,IAAI,CAAC,CAAC,OAAO,EAAE,CAAC;IAElF,KAAK,CAAC,OAAO,CAAC,UAAA,IAAI;QAChB,OAAO,CAAC,GAAG,CAAC,eAAa,eAAK,CAAC,IAAI,CAAC,IAAI,CAAC,SAAM,CAAC,CAAC;QAEjD,IAAM,OAAO,GAAW,EAAE,CAAC,YAAY,CAAC,IAAI,EAAE,MAAM,CAAC,CAAC;QACtD,IAAM,UAAU,GAAa,OAAO,CAAC,KAAK,CAAC,IAAI,GAAG,QAAG,CAAC,CAAC;QAEvD,UAAU,CAAC,OAAO,CAAC,UAAA,SAAS;YAC1B,OAAO,GAAG,OAAO,CAAC,IAAI,CAAC,UAAA,IAAI;gBACzB,MAAM,CAAC,IAAI,CAAC,OAAO,EAAE,CAAC,KAAK,CAAC,SAAS,CAAC,CAAC,IAAI,CAAC,UAAA,MAAM,IAAI,OAAA,IAAI,EAAJ,CAAI,CAAC,CAAC;YAC9D,CAAC,CAAC,CAAC;QACL,CAAC,CAAC,CAAC;IACL,CAAC,CAAC,CAAC;IAEH,OAAO;SACJ,IAAI,CAAC;QACJ,IAAM,IAAI,GAAqB,OAAO,CAAC,MAAM,CAAC,KAAK,CAAC,CAAC;QACrD,OAAO,CAAC,GAAG,CAAC,eAAK,CAAC,KAAK,CAAC,oBAAkB,IAAI,CAAC,CAAC,CAAC,OAAI,CAAC,CAAC,CAAC;IAC1D,CAAC,CAAC;SACD,KAAK,CAAC,UAAA,GAAG,IAAI,OAAA,OAAO,CAAC,KAAK,CAAC,GAAG,CAAC,EAAlB,CAAkB,CAAC,CAAC;AACtC,CAAC;AA7BD,oBA6BC"}

dist/common/utility.js

@@ -25,12 +25,14 @@ "use strict";
     files: [],
+    data: [],
     output: {
         'root': './_sql-database',
+        'data': './data',
         'procs': './stored-procedures',
+        'scalar-valued': './functions/scalar-valued',
         'schemas': './schemas',
-        'scalar-valued': './functions/scalar-valued',
         'table-valued': './functions/table-valued',
+        'table-valued-parameters': './user-defined-types/table-valued-parameters',
         'tables': './tables',
         'triggers': './triggers',
-        'views': './views',
-        'table-valued-parameters': './user-defined-types/table-valued-parameters'
+        'views': './views'
     },
@@ -41,6 +43,6 @@ idempotency: {
         'table-valued': 'if-exists-drop',
+        'table-valued-parameters': 'if-not-exists',
         'tables': 'if-not-exists',
         'triggers': 'if-exists-drop',
-        'views': 'if-exists-drop',
-        'table-valued-parameters': 'if-not-exists'
+        'views': 'if-exists-drop'
     }
@@ -140,4 +142,4 @@ };
     var webConfig = file || exports.webConfigFile;
+    var conns = [];
     var content;
-    var conns = [];
     if (!fs.existsSync(webConfig)) {
@@ -157,6 +159,5 @@ // web config not found, use defaults
             var connStrings = result.configuration.connectionStrings[0].add;
-            for (var _i = 0, connStrings_1 = connStrings; _i < connStrings_1.length; _i++) {
-                var item = connStrings_1[_i];
+            connStrings.forEach(function (item) {
                 conns.push(parseConnString(item.$.name, item.$.connectionString));
-            }
+            });
         }
@@ -186,9 +187,9 @@ catch (err) {
         config.output.triggers,
-        config.output['table-valued-parameters']
+        config.output['table-valued-parameters'],
+        config.output.data
     ];
-    for (var _i = 0, directories_1 = directories; _i < directories_1.length; _i++) {
-        var dir = directories_1[_i];
+    directories.forEach(function (dir) {
         var files = glob.sync(config.output.root + "/" + dir + "/**/*.sql");
         output.push.apply(output, files);
-    }
+    });
     return output;
@@ -195,0 +196,0 @@ }

dist/common/utility.js.map

@@ -1,1 +0,1 @@
-{"version":3,"file":"utility.js","sourceRoot":"","sources":["../../src/common/utility.ts"],"names":[],"mappings":";;AAAA,+BAA0B;AAC1B,qCAAuC;AACvC,6BAA+B;AAC/B,2BAA6B;AAC7B,2BAA6B;AAC7B,yCAAsC;AACtC,+BAAiC;AAGjC,mDAAkD;AAElD;;GAEG;AACU,QAAA,UAAU,GAAW,IAAI,CAAC,IAAI,CAAC,OAAO,CAAC,GAAG,EAAE,EAAE,UAAU,CAAC,CAAC;AAEvE;;GAEG;AACU,QAAA,aAAa,GAAW,cAAc,CAAC;AAEpD;;GAEG;AACU,QAAA,cAAc,GAAW;IACpC,WAAW,EAAE,EAAE;IACf,KAAK,EAAE,EAAE;IACT,MAAM,EAAE;QACN,MAAM,EAAE,iBAAiB;QACzB,OAAO,EAAE,qBAAqB;QAC9B,SAAS,EAAE,WAAW;QACtB,eAAe,EAAE,2BAA2B;QAC5C,cAAc,EAAE,0BAA0B;QAC1C,QAAQ,EAAE,UAAU;QACpB,UAAU,EAAE,YAAY;QACxB,OAAO,EAAE,SAAS;QAClB,yBAAyB,EAAE,8CAA8C;KAC1E;IACD,WAAW,EAAE;QACX,OAAO,EAAE,gBAAgB;QACzB,eAAe,EAAE,gBAAgB;QACjC,cAAc,EAAE,gBAAgB;QAChC,QAAQ,EAAE,eAAe;QACzB,UAAU,EAAE,gBAAgB;QAC5B,OAAO,EAAE,gBAAgB;QACzB,yBAAyB,EAAE,eAAe;KAC3C;CACF,CAAC;AAEF;;;;GAIG;AACH,kBAAyB,IAAY;IACnC,MAAM,CAAC,IAAI,CAAC,OAAO,CAAC,KAAK,EAAE,GAAG,CAAC,CAAC;AAClC,CAAC;AAFD,4BAEC;AAED;;GAEG;AACH;IACE,IAAI,MAAc,CAAC;IAEnB,IAAI,CAAC;QACH,MAAM,GAAG,EAAE,CAAC,YAAY,CAAC,kBAAU,CAAC,CAAC;IACvC,CAAC;IAAC,KAAK,CAAC,CAAC,KAAK,CAAC,CAAC,CAAC;QACf,OAAO,CAAC,KAAK,CAAC,oFAAoF,CAAC,CAAC;QACpG,OAAO,CAAC,IAAI,EAAE,CAAC;IACjB,CAAC;IAED,MAAM,CAAC,SAAS,CAAC,sBAAc,EAAE,MAAM,CAAC,CAAC;AAC3C,CAAC;AAXD,8BAWC;AAED;;;;GAIG;AACH,mBAA0B,MAAc;IACtC,IAAM,OAAO,GAAW,IAAI,CAAC,SAAS,CAAC,MAAM,EAAE,IAAI,EAAE,CAAC,CAAC,CAAC;IAExD,YAAY;IACZ,EAAE,CAAC,UAAU,CAAC,kBAAU,EAAE,OAAO,EAAE,UAAC,KAAY;QAC9C,EAAE,CAAC,CAAC,KAAK,CAAC,CAAC,CAAC;YACV,MAAM,CAAC,OAAO,CAAC,KAAK,CAAC,KAAK,CAAC,CAAC;QAC9B,CAAC;QAED,OAAO,CAAC,GAAG,CAAC,sBAAsB,CAAC,CAAC;IACtC,CAAC,CAAC,CAAC;AACL,CAAC;AAXD,8BAWC;AAED;;;;GAIG;AACH,kBAAyB,MAAc;IACrC,EAAE,CAAC,CAAC,MAAM,CAAC,UAAU,CAAC,CAAC,CAAC;QACtB,sBAAsB;QACtB,OAAO,CAAC,IAAI,CAAC,eAAK,CAAC,MAAM,CAAC,mFAAmF,CAAC,CAAC,CAAC;QAEhH,IAAM,UAAU,GAAwB,MAAM,CAAC,UAAU,CAAC;QAC1D,MAAM,CAAC,WAAW,GAAG,CAAC,qBAAQ,CAAC,UAAU,CAAC,CAAC,CAAC,CAAC,UAAU,CAAC,CAAC,CAAC,CAAC,UAAU,CAAC,CAAC,CAAC;IAC1E,CAAC;IAED,EAAE,CAAC,CAAC,qBAAQ,CAAC,MAAM,CAAC,WAAW,CAAC,CAAC,CAAC,CAAC;QACjC,sBAAsB;QACtB,MAAM,CAAC,iBAAiB,CAAC,MAAM,CAAC,WAAW,CAAC,CAAC;IAC/C,CAAC;IAAC,IAAI,CAAC,CAAC;QACN,MAAM,CAAC,MAAM,CAAC,WAAW,CAAC;IAC5B,CAAC;AACH,CAAC;AAfD,4BAeC;AAED;;;;;GAKG;AACH,iBAAwB,MAAc,EAAE,IAAa;IACnD,IAAM,KAAK,GAAiB,QAAQ,CAAC,MAAM,CAAC,CAAC;IAC7C,IAAI,IAAgB,CAAC;IAErB,EAAE,CAAC,CAAC,IAAI,CAAC,CAAC,CAAC;QACT,IAAI,GAAG,KAAK,CAAC,IAAI,CAAC,UAAA,IAAI,IAAI,OAAA,IAAI,CAAC,IAAI,CAAC,iBAAiB,EAAE,KAAK,IAAI,CAAC,WAAW,EAAE,EAApD,CAAoD,CAAC,CAAC;IAClF,CAAC;IAAC,IAAI,CAAC,CAAC;QACN,mBAAmB;QACnB,IAAI,GAAG,KAAK,CAAC,CAAC,CAAC,CAAC;IAClB,CAAC;IAED,EAAE,CAAC,CAAC,CAAC,IAAI,CAAC,CAAC,CAAC;QACV,OAAO,CAAC,KAAK,CAAC,IAAI,CAAC,CAAC,CAAC,wCAAsC,IAAI,OAAI,CAAC,CAAC,CAAC,oCAAoC,CAAC,CAAC;QAC5G,OAAO,CAAC,IAAI,EAAE,CAAC;IACjB,CAAC;IAED,MAAM,CAAC,IAAI,CAAC;AACd,CAAC;AAjBD,0BAiBC;AAED;;;;GAIG;AACH,2BAAkC,IAAa;IAC7C,IAAM,MAAM,GAAkB,IAAI,MAAM,CAAC,MAAM,EAAE,CAAC;IAClD,IAAM,SAAS,GAAW,IAAI,IAAI,qBAAa,CAAC;IAChD,IAAI,OAAe,CAAC;IACpB,IAAM,KAAK,GAAiB,EAAE,CAAC;IAE/B,EAAE,CAAC,CAAC,CAAC,EAAE,CAAC,UAAU,CAAC,SAAS,CAAC,CAAC,CAAC,CAAC;QAC9B,qCAAqC;QACrC,MAAM,CAAC;IACT,CAAC;IAED,mBAAmB;IACnB,OAAO,GAAG,EAAE,CAAC,YAAY,CAAC,SAAS,EAAE,OAAO,CAAC,CAAC;IAE9C,oBAAoB;IACpB,MAAM,CAAC,WAAW,CAAC,OAAO,EAAE,UAAC,GAAG,EAAE,MAAM;QACtC,EAAE,CAAC,CAAC,GAAG,CAAC,CAAC,CAAC;YACR,OAAO,CAAC,KAAK,CAAC,GAAG,CAAC,CAAC;YACnB,OAAO,CAAC,IAAI,EAAE,CAAC;QACjB,CAAC;QAED,IAAI,CAAC;YACH,IAAM,WAAW,GAAU,MAAM,CAAC,aAAa,CAAC,iBAAiB,CAAC,CAAC,CAAC,CAAC,GAAG,CAAC;YAEzE,GAAG,CAAC,CAAe,UAAW,EAAX,2BAAW,EAAX,yBAAW,EAAX,IAAW;gBAAzB,IAAM,IAAI,oBAAA;gBACb,KAAK,CAAC,IAAI,CAAC,eAAe,CAAC,IAAI,CAAC,CAAC,CAAC,IAAI,EAAE,IAAI,CAAC,CAAC,CAAC,gBAAgB,CAAC,CAAC,CAAC;aACnE;QAEH,CAAC;QAAC,KAAK,CAAC,CAAC,GAAG,CAAC,CAAC,CAAC;YACb,OAAO,CAAC,KAAK,CAAC,0DAA0D,CAAC,CAAC;YAC1E,OAAO,CAAC,IAAI,EAAE,CAAC;QACjB,CAAC;IACH,CAAC,CAAC,CAAC;IAEH,MAAM,CAAC,CAAC,KAAK,CAAC,MAAM,CAAC,CAAC,CAAC,KAAK,CAAC,CAAC,CAAC,SAAS,CAAC,CAAC;AAC5C,CAAC;AAnCD,8CAmCC;AAED;;;;GAIG;AACH,yBAAgC,MAAc;IAC5C,IAAM,MAAM,GAAa,EAAE,CAAC;IAC5B,IAAM,WAAW,GAAa;QAC5B,MAAM,CAAC,MAAM,CAAC,OAAO;QACrB,MAAM,CAAC,MAAM,CAAC,MAAM;QACpB,MAAM,CAAC,MAAM,CAAC,KAAK;QACnB,MAAM,CAAC,MAAM,CAAC,eAAe,CAAC;QAC9B,MAAM,CAAC,MAAM,CAAC,cAAc,CAAC;QAC7B,MAAM,CAAC,MAAM,CAAC,KAAK;QACnB,MAAM,CAAC,MAAM,CAAC,QAAQ;QACtB,MAAM,CAAC,MAAM,CAAC,yBAAyB,CAAC;KACzC,CAAC;IAEF,GAAG,CAAC,CAAc,UAAW,EAAX,2BAAW,EAAX,yBAAW,EAAX,IAAW;QAAxB,IAAM,GAAG,oBAAA;QACZ,IAAM,KAAK,GAAa,IAAI,CAAC,IAAI,CAAI,MAAM,CAAC,MAAM,CAAC,IAAI,SAAI,GAAG,cAAW,CAAC,CAAC;QAC3E,MAAM,CAAC,IAAI,OAAX,MAAM,EAAS,KAAK,EAAE;KACvB;IAED,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC;AAnBD,0CAmBC;AAED;;;;;GAKG;AACH,yBAAyB,IAAY,EAAE,UAAkB;IACvD,IAAM,KAAK,GAAa,UAAU,CAAC,KAAK,CAAC,GAAG,CAAC,CAAC;IAE9C,yBAAyB;IACzB,IAAI,MAAM,GAAW,KAAK,CAAC,IAAI,CAAC,UAAA,CAAC,IAAI,OAAA,aAAa,CAAC,IAAI,CAAC,CAAC,CAAC,EAArB,CAAqB,CAAC,CAAC;IAC5D,IAAI,QAAQ,GAAW,KAAK,CAAC,IAAI,CAAC,UAAA,CAAC,IAAI,OAAA,eAAe,CAAC,IAAI,CAAC,CAAC,CAAC,EAAvB,CAAuB,CAAC,CAAC;IAChE,IAAI,IAAI,GAAW,KAAK,CAAC,IAAI,CAAC,UAAA,CAAC,IAAI,OAAA,UAAU,CAAC,IAAI,CAAC,CAAC,CAAC,EAAlB,CAAkB,CAAC,CAAC;IACvD,IAAI,QAAQ,GAAW,KAAK,CAAC,IAAI,CAAC,UAAA,CAAC,IAAI,OAAA,mBAAmB,CAAC,IAAI,CAAC,CAAC,CAAC,EAA3B,CAA2B,CAAC,CAAC;IACpE,IAAI,IAAY,CAAC;IAEjB,aAAa;IACb,MAAM,GAAG,CAAC,MAAM,IAAI,MAAM,CAAC,KAAK,CAAC,GAAG,CAAC,CAAC,CAAC,CAAC,CAAC,CAAC;IAC1C,QAAQ,GAAG,CAAC,QAAQ,IAAI,QAAQ,CAAC,KAAK,CAAC,GAAG,CAAC,CAAC,CAAC,CAAC,CAAC,CAAC;IAChD,IAAI,GAAG,CAAC,IAAI,IAAI,IAAI,CAAC,KAAK,CAAC,GAAG,CAAC,CAAC,CAAC,CAAC,CAAC,CAAC;IACpC,QAAQ,GAAG,CAAC,QAAQ,IAAI,QAAQ,CAAC,KAAK,CAAC,GAAG,CAAC,CAAC,CAAC,CAAC,CAAC,CAAC;IAEhD,2BAA2B;IAC3B,EAAE,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC;QACX,0CAA0C;QAC1C,IAAM,GAAG,GAAa,MAAM,CAAC,KAAK,CAAC,GAAG,CAAC,CAAC;QAExC,MAAM,GAAG,GAAG,CAAC,CAAC,CAAC,CAAC;QAChB,IAAI,GAAG,QAAQ,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,EAAE,CAAC,IAAI,SAAS,CAAC;IAC3C,CAAC;IAED,MAAM,CAAC,IAAI,uBAAU,CAAC;QACpB,IAAI,MAAA;QACJ,MAAM,QAAA;QACN,QAAQ,UAAA;QACR,IAAI,MAAA;QACJ,IAAI,MAAA;QACJ,QAAQ,UAAA;KACT,CAAC,CAAC;AACL,CAAC"}
+{"version":3,"file":"utility.js","sourceRoot":"","sources":["../../src/common/utility.ts"],"names":[],"mappings":";;AAAA,+BAA0B;AAC1B,qCAAuC;AACvC,6BAA+B;AAC/B,2BAA6B;AAC7B,2BAA6B;AAC7B,yCAAsC;AACtC,+BAAiC;AAGjC,mDAAkD;AAElD;;GAEG;AACU,QAAA,UAAU,GAAW,IAAI,CAAC,IAAI,CAAC,OAAO,CAAC,GAAG,EAAE,EAAE,UAAU,CAAC,CAAC;AAEvE;;GAEG;AACU,QAAA,aAAa,GAAW,cAAc,CAAC;AAEpD;;GAEG;AACU,QAAA,cAAc,GAAW;IACpC,WAAW,EAAE,EAAE;IACf,KAAK,EAAE,EAAE;IACT,IAAI,EAAE,EAAE;IACR,MAAM,EAAE;QACN,MAAM,EAAE,iBAAiB;QACzB,MAAM,EAAE,QAAQ;QAChB,OAAO,EAAE,qBAAqB;QAC9B,eAAe,EAAE,2BAA2B;QAC5C,SAAS,EAAE,WAAW;QACtB,cAAc,EAAE,0BAA0B;QAC1C,yBAAyB,EAAE,8CAA8C;QACzE,QAAQ,EAAE,UAAU;QACpB,UAAU,EAAE,YAAY;QACxB,OAAO,EAAE,SAAS;KACnB;IACD,WAAW,EAAE;QACX,OAAO,EAAE,gBAAgB;QACzB,eAAe,EAAE,gBAAgB;QACjC,cAAc,EAAE,gBAAgB;QAChC,yBAAyB,EAAE,eAAe;QAC1C,QAAQ,EAAE,eAAe;QACzB,UAAU,EAAE,gBAAgB;QAC5B,OAAO,EAAE,gBAAgB;KAC1B;CACF,CAAC;AAEF;;;;GAIG;AACH,kBAAyB,IAAY;IACnC,MAAM,CAAC,IAAI,CAAC,OAAO,CAAC,KAAK,EAAE,GAAG,CAAC,CAAC;AAClC,CAAC;AAFD,4BAEC;AAED;;GAEG;AACH;IACE,IAAI,MAAc,CAAC;IAEnB,IAAI,CAAC;QACH,MAAM,GAAG,EAAE,CAAC,YAAY,CAAC,kBAAU,CAAC,CAAC;IACvC,CAAC;IAAC,KAAK,CAAC,CAAC,KAAK,CAAC,CAAC,CAAC;QACf,OAAO,CAAC,KAAK,CAAC,oFAAoF,CAAC,CAAC;QACpG,OAAO,CAAC,IAAI,EAAE,CAAC;IACjB,CAAC;IAED,MAAM,CAAC,SAAS,CAAC,sBAAc,EAAE,MAAM,CAAC,CAAC;AAC3C,CAAC;AAXD,8BAWC;AAED;;;;GAIG;AACH,mBAA0B,MAAc;IACtC,IAAM,OAAO,GAAW,IAAI,CAAC,SAAS,CAAC,MAAM,EAAE,IAAI,EAAE,CAAC,CAAC,CAAC;IAExD,YAAY;IACZ,EAAE,CAAC,UAAU,CAAC,kBAAU,EAAE,OAAO,EAAE,UAAC,KAAY;QAC9C,EAAE,CAAC,CAAC,KAAK,CAAC,CAAC,CAAC;YACV,MAAM,CAAC,OAAO,CAAC,KAAK,CAAC,KAAK,CAAC,CAAC;QAC9B,CAAC;QAED,OAAO,CAAC,GAAG,CAAC,sBAAsB,CAAC,CAAC;IACtC,CAAC,CAAC,CAAC;AACL,CAAC;AAXD,8BAWC;AAED;;;;GAIG;AACH,kBAAyB,MAAc;IACrC,EAAE,CAAC,CAAC,MAAM,CAAC,UAAU,CAAC,CAAC,CAAC;QACtB,sBAAsB;QACtB,OAAO,CAAC,IAAI,CAAC,eAAK,CAAC,MAAM,CAAC,mFAAmF,CAAC,CAAC,CAAC;QAEhH,IAAM,UAAU,GAAwB,MAAM,CAAC,UAAU,CAAC;QAC1D,MAAM,CAAC,WAAW,GAAG,CAAC,qBAAQ,CAAC,UAAU,CAAC,CAAC,CAAC,CAAC,UAAU,CAAC,CAAC,CAAC,CAAC,UAAU,CAAC,CAAC,CAAC;IAC1E,CAAC;IAED,EAAE,CAAC,CAAC,qBAAQ,CAAC,MAAM,CAAC,WAAW,CAAC,CAAC,CAAC,CAAC;QACjC,sBAAsB;QACtB,MAAM,CAAC,iBAAiB,CAAC,MAAM,CAAC,WAAW,CAAC,CAAC;IAC/C,CAAC;IAAC,IAAI,CAAC,CAAC;QACN,MAAM,CAAC,MAAM,CAAC,WAAW,CAAC;IAC5B,CAAC;AACH,CAAC;AAfD,4BAeC;AAED;;;;;GAKG;AACH,iBAAwB,MAAc,EAAE,IAAa;IACnD,IAAM,KAAK,GAAiB,QAAQ,CAAC,MAAM,CAAC,CAAC;IAC7C,IAAI,IAAgB,CAAC;IAErB,EAAE,CAAC,CAAC,IAAI,CAAC,CAAC,CAAC;QACT,IAAI,GAAG,KAAK,CAAC,IAAI,CAAC,UAAA,IAAI,IAAI,OAAA,IAAI,CAAC,IAAI,CAAC,iBAAiB,EAAE,KAAK,IAAI,CAAC,WAAW,EAAE,EAApD,CAAoD,CAAC,CAAC;IAClF,CAAC;IAAC,IAAI,CAAC,CAAC;QACN,mBAAmB;QACnB,IAAI,GAAG,KAAK,CAAC,CAAC,CAAC,CAAC;IAClB,CAAC;IAED,EAAE,CAAC,CAAC,CAAC,IAAI,CAAC,CAAC,CAAC;QACV,OAAO,CAAC,KAAK,CAAC,IAAI,CAAC,CAAC,CAAC,wCAAsC,IAAI,OAAI,CAAC,CAAC,CAAC,oCAAoC,CAAC,CAAC;QAC5G,OAAO,CAAC,IAAI,EAAE,CAAC;IACjB,CAAC;IAED,MAAM,CAAC,IAAI,CAAC;AACd,CAAC;AAjBD,0BAiBC;AAED;;;;GAIG;AACH,2BAAkC,IAAa;IAC7C,IAAM,MAAM,GAAkB,IAAI,MAAM,CAAC,MAAM,EAAE,CAAC;IAClD,IAAM,SAAS,GAAW,IAAI,IAAI,qBAAa,CAAC;IAChD,IAAM,KAAK,GAAiB,EAAE,CAAC;IAC/B,IAAI,OAAe,CAAC;IAEpB,EAAE,CAAC,CAAC,CAAC,EAAE,CAAC,UAAU,CAAC,SAAS,CAAC,CAAC,CAAC,CAAC;QAC9B,qCAAqC;QACrC,MAAM,CAAC;IACT,CAAC;IAED,mBAAmB;IACnB,OAAO,GAAG,EAAE,CAAC,YAAY,CAAC,SAAS,EAAE,OAAO,CAAC,CAAC;IAE9C,oBAAoB;IACpB,MAAM,CAAC,WAAW,CAAC,OAAO,EAAE,UAAC,GAAG,EAAE,MAAM;QACtC,EAAE,CAAC,CAAC,GAAG,CAAC,CAAC,CAAC;YACR,OAAO,CAAC,KAAK,CAAC,GAAG,CAAC,CAAC;YACnB,OAAO,CAAC,IAAI,EAAE,CAAC;QACjB,CAAC;QAED,IAAI,CAAC;YACH,IAAM,WAAW,GAAU,MAAM,CAAC,aAAa,CAAC,iBAAiB,CAAC,CAAC,CAAC,CAAC,GAAG,CAAC;YAEzE,WAAW,CAAC,OAAO,CAAC,UAAA,IAAI;gBACtB,KAAK,CAAC,IAAI,CAAC,eAAe,CAAC,IAAI,CAAC,CAAC,CAAC,IAAI,EAAE,IAAI,CAAC,CAAC,CAAC,gBAAgB,CAAC,CAAC,CAAC;YACpE,CAAC,CAAC,CAAC;QAEL,CAAC;QAAC,KAAK,CAAC,CAAC,GAAG,CAAC,CAAC,CAAC;YACb,OAAO,CAAC,KAAK,CAAC,0DAA0D,CAAC,CAAC;YAC1E,OAAO,CAAC,IAAI,EAAE,CAAC;QACjB,CAAC;IACH,CAAC,CAAC,CAAC;IAEH,MAAM,CAAC,CAAC,KAAK,CAAC,MAAM,CAAC,CAAC,CAAC,KAAK,CAAC,CAAC,CAAC,SAAS,CAAC,CAAC;AAC5C,CAAC;AAnCD,8CAmCC;AAED;;;;GAIG;AACH,yBAAgC,MAAc;IAC5C,IAAM,MAAM,GAAa,EAAE,CAAC;IAC5B,IAAM,WAAW,GAAa;QAC5B,MAAM,CAAC,MAAM,CAAC,OAAO;QACrB,MAAM,CAAC,MAAM,CAAC,MAAM;QACpB,MAAM,CAAC,MAAM,CAAC,KAAK;QACnB,MAAM,CAAC,MAAM,CAAC,eAAe,CAAC;QAC9B,MAAM,CAAC,MAAM,CAAC,cAAc,CAAC;QAC7B,MAAM,CAAC,MAAM,CAAC,KAAK;QACnB,MAAM,CAAC,MAAM,CAAC,QAAQ;QACtB,MAAM,CAAC,MAAM,CAAC,yBAAyB,CAAC;QACxC,MAAM,CAAC,MAAM,CAAC,IAAI;KACnB,CAAC;IAEF,WAAW,CAAC,OAAO,CAAC,UAAA,GAAG;QACrB,IAAM,KAAK,GAAa,IAAI,CAAC,IAAI,CAAI,MAAM,CAAC,MAAM,CAAC,IAAI,SAAI,GAAG,cAAW,CAAC,CAAC;QAC3E,MAAM,CAAC,IAAI,OAAX,MAAM,EAAS,KAAK,EAAE;IACxB,CAAC,CAAC,CAAC;IAEH,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC;AApBD,0CAoBC;AAED;;;;;GAKG;AACH,yBAAyB,IAAY,EAAE,UAAkB;IACvD,IAAM,KAAK,GAAa,UAAU,CAAC,KAAK,CAAC,GAAG,CAAC,CAAC;IAE9C,yBAAyB;IACzB,IAAI,MAAM,GAAW,KAAK,CAAC,IAAI,CAAC,UAAA,CAAC,IAAI,OAAA,aAAa,CAAC,IAAI,CAAC,CAAC,CAAC,EAArB,CAAqB,CAAC,CAAC;IAC5D,IAAI,QAAQ,GAAW,KAAK,CAAC,IAAI,CAAC,UAAA,CAAC,IAAI,OAAA,eAAe,CAAC,IAAI,CAAC,CAAC,CAAC,EAAvB,CAAuB,CAAC,CAAC;IAChE,IAAI,IAAI,GAAW,KAAK,CAAC,IAAI,CAAC,UAAA,CAAC,IAAI,OAAA,UAAU,CAAC,IAAI,CAAC,CAAC,CAAC,EAAlB,CAAkB,CAAC,CAAC;IACvD,IAAI,QAAQ,GAAW,KAAK,CAAC,IAAI,CAAC,UAAA,CAAC,IAAI,OAAA,mBAAmB,CAAC,IAAI,CAAC,CAAC,CAAC,EAA3B,CAA2B,CAAC,CAAC;IACpE,IAAI,IAAY,CAAC;IAEjB,aAAa;IACb,MAAM,GAAG,CAAC,MAAM,IAAI,MAAM,CAAC,KAAK,CAAC,GAAG,CAAC,CAAC,CAAC,CAAC,CAAC,CAAC;IAC1C,QAAQ,GAAG,CAAC,QAAQ,IAAI,QAAQ,CAAC,KAAK,CAAC,GAAG,CAAC,CAAC,CAAC,CAAC,CAAC,CAAC;IAChD,IAAI,GAAG,CAAC,IAAI,IAAI,IAAI,CAAC,KAAK,CAAC,GAAG,CAAC,CAAC,CAAC,CAAC,CAAC,CAAC;IACpC,QAAQ,GAAG,CAAC,QAAQ,IAAI,QAAQ,CAAC,KAAK,CAAC,GAAG,CAAC,CAAC,CAAC,CAAC,CAAC,CAAC;IAEhD,2BAA2B;IAC3B,EAAE,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC;QACX,0CAA0C;QAC1C,IAAM,GAAG,GAAa,MAAM,CAAC,KAAK,CAAC,GAAG,CAAC,CAAC;QAExC,MAAM,GAAG,GAAG,CAAC,CAAC,CAAC,CAAC;QAChB,IAAI,GAAG,QAAQ,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,EAAE,CAAC,IAAI,SAAS,CAAC;IAC3C,CAAC;IAED,MAAM,CAAC,IAAI,uBAAU,CAAC;QACpB,IAAI,MAAA;QACJ,MAAM,QAAA;QACN,QAAQ,UAAA;QACR,IAAI,MAAA;QACJ,IAAI,MAAA;QACJ,QAAQ,UAAA;KACT,CAAC,CAAC;AACL,CAAC"}

dist/sql/script.js

 "use strict";
 Object.defineProperty(exports, "__esModule", { value: true });
 var os_1 = require("os");
+var ts_util_is_1 = require("ts-util-is");
 /**
@@ -113,19 +114,22 @@ * Get idempotency script prefix.
     // columns
-    for (var _i = 0, _a = columns.filter(function (x) { return x.object_id === item.object_id; }); _i < _a.length; _i++) {
-        var col = _a[_i];
+    columns
+        .filter(function (x) { return x.object_id === item.object_id; })
+        .forEach(function (col) {
         output += '    ' + column(col) + ',';
         output += os_1.EOL;
-    }
+    });
     // primary keys
-    for (var _b = 0, _c = primaryKeys.filter(function (x) { return x.object_id === item.object_id; }); _b < _c.length; _b++) {
-        var pk = _c[_b];
+    primaryKeys
+        .filter(function (x) { return x.object_id === item.object_id; })
+        .forEach(function (pk) {
         output += '    ' + primaryKey(pk);
         output += os_1.EOL;
-    }
+    });
     // foreign keys
-    for (var _d = 0, _e = foreignKeys.filter(function (x) { return x.object_id === item.object_id; }); _d < _e.length; _d++) {
-        var fk = _e[_d];
+    foreignKeys
+        .filter(function (x) { return x.object_id === item.object_id; })
+        .forEach(function (fk) {
         output += '    ' + foreignKey(fk);
         output += os_1.EOL;
-    }
+    });
     output += ')';
@@ -135,7 +139,8 @@ output += os_1.EOL;
     // indexes
-    for (var _f = 0, _g = indexes.filter(function (x) { return x.object_id === item.object_id; }); _f < _g.length; _f++) {
-        var ix = _g[_f];
+    indexes
+        .filter(function (x) { return x.object_id === item.object_id; })
+        .forEach(function (ix) {
         output += index(ix);
         output += os_1.EOL;
-    }
+    });
     return output;
@@ -173,2 +178,42 @@ }
 /**
+ * Get script for for table data.
+ *
+ * @param item Results from data query.
+ */
+function data(item) {
+    var output = '';
+    // idempotency
+    output += "truncate table " + item.name;
+    output += os_1.EOL;
+    item.result.recordset.forEach(function (row) {
+        var keys = Object.keys(row);
+        var columns = keys.join(', ');
+        var values = keys.map(function (key) { return safeValue(row[key]); }).join(', ');
+        output += "insert into " + item.name + " (" + columns + ") values (" + values + ")";
+        output += os_1.EOL;
+    });
+    output += os_1.EOL;
+    return output;
+}
+exports.data = data;
+/**
+ * Safely transform SQL value for scripting.
+ *
+ * @param value SQL data value.
+ */
+function safeValue(value) {
+    if (ts_util_is_1.isString(value)) {
+        value = value.replace("'", "''");
+        return "'" + value + "'";
+    }
+    if (ts_util_is_1.isDate(value)) {
+        value = value.toISOString();
+        return "'" + value + "'";
+    }
+    if (ts_util_is_1.isBoolean(value)) {
+        return value ? 1 : 0;
+    }
+    return value;
+}
+/**
  * Get script for table's column.
@@ -175,0 +220,0 @@ *

dist/sql/script.js.map

@@ -1,1 +0,1 @@
-{"version":3,"file":"script.js","sourceRoot":"","sources":["../../src/sql/script.ts"],"names":[],"mappings":";;AAAA,yBAAyB;AAczB;;;;;GAKG;AACH,qBAA4B,IAAuB,EAAE,IAAuB;IAC1E,IAAI,GAAW,CAAC;IAChB,IAAM,QAAQ,GAAc,IAAI,CAAC,MAAM,WAAM,IAAI,CAAC,IAAM,CAAC;IAEzD,IAAI,CAAC,IAAI,GAAG,IAAI,CAAC,IAAI,CAAC,IAAI,EAAE,CAAC;IAE7B,8CAA8C;IAC9C,MAAM,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC,CAAC;QAClB,KAAK,GAAG;YACN,GAAG,GAAG,OAAO,CAAC;YACd,KAAK,CAAC;QACR,KAAK,IAAI;YACP,GAAG,GAAG,OAAO,CAAC;YACd,KAAK,CAAC;QACR,KAAK,GAAG;YACN,GAAG,GAAG,WAAW,CAAC;YAClB,KAAK,CAAC;QACR,KAAK,GAAG;YACN,GAAG,GAAG,MAAM,CAAC;YACb,KAAK,CAAC;QACR,KAAK,IAAI,CAAC;QACV,KAAK,IAAI,CAAC;QACV,KAAK,IAAI;YACP,GAAG,GAAG,UAAU,CAAC;YACjB,KAAK,CAAC;QACR,KAAK,IAAI;YACP,GAAG,GAAG,SAAS,CAAC;YAChB,KAAK,CAAC;IACV,CAAC;IAED,EAAE,CAAC,CAAC,IAAI,KAAK,gBAAgB,CAAC,CAAC,CAAC;QAC9B,iBAAiB;QACjB,EAAE,CAAC,CAAC,IAAI,CAAC,IAAI,KAAK,IAAI,CAAC,CAAC,CAAC;YACvB,MAAM,CAAC;gBACL,aAAa;gBACb,wCAAwC;gBACxC,qDAAqD;gBACrD,yBAAuB,IAAI,CAAC,IAAI,wBAAmB,IAAI,CAAC,MAAM,MAAG;gBACjE,GAAG;gBACH,gBAAc,QAAQ,MAAG;gBACzB,IAAI;gBACJ,QAAG;aACJ,CAAC,IAAI,CAAC,QAAG,CAAC,CAAC;QACd,CAAC;QAAC,IAAI,CAAC,CAAC;YACN,MAAM,CAAC;gBACL,wEAAsE,QAAQ,wBAAmB,IAAI,CAAC,IAAI,OAAI;gBAC9G,UAAQ,GAAG,UAAK,QAAQ,MAAG;gBAC3B,IAAI;gBACJ,QAAG;aACJ,CAAC,IAAI,CAAC,QAAG,CAAC,CAAC;QACd,CAAC;IACH,CAAC;IAAC,IAAI,CAAC,EAAE,CAAC,CAAC,IAAI,KAAK,eAAe,CAAC,CAAC,CAAC;QACpC,gBAAgB;QAChB,EAAE,CAAC,CAAC,IAAI,CAAC,IAAI,KAAK,IAAI,CAAC,CAAC,CAAC;YACvB,MAAM,CAAC;gBACL,iBAAiB;gBACjB,wCAAwC;gBACxC,qDAAqD;gBACrD,yBAAuB,IAAI,CAAC,IAAI,wBAAmB,IAAI,CAAC,MAAM,MAAG;gBACjE,GAAG;gBACH,EAAE;aACH,CAAC,IAAI,CAAC,QAAG,CAAC,CAAC;QACd,CAAC;QAAC,IAAI,CAAC,CAAC;YACN,MAAM,CAAC;gBACL,2CAA2C;gBAC3C,4EAA0E,QAAQ,wBAAmB,IAAI,CAAC,IAAI,OAAI;gBAClH,EAAE;aACH,CAAC,IAAI,CAAC,QAAG,CAAC,CAAC;QACd,CAAC;IACH,CAAC;IAED,OAAO;IACP,MAAM,CAAC,EAAE,CAAC;AACZ,CAAC;AAzED,kCAyEC;AAED;;;;GAIG;AACH,gBAAuB,IAAqB;IAC1C,IAAI,MAAM,GAAW,EAAE,CAAC;IAExB,cAAc;IACd,MAAM,IAAI,4DAA0D,IAAI,CAAC,IAAI,OAAI,CAAC;IAClF,MAAM,IAAI,QAAG,CAAC;IAEd,MAAM,IAAI,yBAAuB,IAAI,CAAC,IAAI,OAAI,CAAC;IAC/C,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC;AATD,wBASC;AAED;;;;;;;;GAQG;AACH,eACE,IAAoB,EACpB,OAA0B,EAC1B,WAAkC,EAClC,WAAkC,EAClC,OAAyB;IAEzB,IAAI,MAAM,GAAW,mBAAiB,IAAI,CAAC,MAAM,WAAM,IAAI,CAAC,IAAI,MAAG,CAAC;IACpE,MAAM,IAAI,QAAG,CAAC;IACd,MAAM,IAAI,GAAG,CAAC;IACd,MAAM,IAAI,QAAG,CAAC;IAEd,UAAU;IACV,GAAG,CAAC,CAAc,UAAmD,EAAnD,KAAA,OAAO,CAAC,MAAM,CAAC,UAAA,CAAC,IAAI,OAAA,CAAC,CAAC,SAAS,KAAK,IAAI,CAAC,SAAS,EAA9B,CAA8B,CAAC,EAAnD,cAAmD,EAAnD,IAAmD;QAAhE,IAAM,GAAG,SAAA;QACZ,MAAM,IAAI,MAAM,GAAG,MAAM,CAAC,GAAG,CAAC,GAAG,GAAG,CAAC;QACrC,MAAM,IAAI,QAAG,CAAC;KACf;IAED,eAAe;IACf,GAAG,CAAC,CAAa,UAAuD,EAAvD,KAAA,WAAW,CAAC,MAAM,CAAC,UAAA,CAAC,IAAI,OAAA,CAAC,CAAC,SAAS,KAAK,IAAI,CAAC,SAAS,EAA9B,CAA8B,CAAC,EAAvD,cAAuD,EAAvD,IAAuD;QAAnE,IAAM,EAAE,SAAA;QACX,MAAM,IAAI,MAAM,GAAG,UAAU,CAAC,EAAE,CAAC,CAAC;QAClC,MAAM,IAAI,QAAG,CAAC;KACf;IAED,eAAe;IACf,GAAG,CAAC,CAAa,UAAuD,EAAvD,KAAA,WAAW,CAAC,MAAM,CAAC,UAAA,CAAC,IAAI,OAAA,CAAC,CAAC,SAAS,KAAK,IAAI,CAAC,SAAS,EAA9B,CAA8B,CAAC,EAAvD,cAAuD,EAAvD,IAAuD;QAAnE,IAAM,EAAE,SAAA;QACX,MAAM,IAAI,MAAM,GAAG,UAAU,CAAC,EAAE,CAAC,CAAC;QAClC,MAAM,IAAI,QAAG,CAAC;KACf;IAED,MAAM,IAAI,GAAG,CAAC;IACd,MAAM,IAAI,QAAG,CAAC;IACd,MAAM,IAAI,QAAG,CAAC;IAEd,UAAU;IACV,GAAG,CAAC,CAAa,UAAmD,EAAnD,KAAA,OAAO,CAAC,MAAM,CAAC,UAAA,CAAC,IAAI,OAAA,CAAC,CAAC,SAAS,KAAK,IAAI,CAAC,SAAS,EAA9B,CAA8B,CAAC,EAAnD,cAAmD,EAAnD,IAAmD;QAA/D,IAAM,EAAE,SAAA;QACX,MAAM,IAAI,KAAK,CAAC,EAAE,CAAC,CAAC;QACpB,MAAM,IAAI,QAAG,CAAC;KACf;IAED,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC;AAzCD,sBAyCC;AAED;;;;;GAKG;AACH,aACE,IAAoB,EACpB,OAA0B;IAE1B,IAAI,MAAM,GAAW,kBAAgB,IAAI,CAAC,MAAM,WAAM,IAAI,CAAC,IAAI,eAAY,CAAC;IAC5E,MAAM,IAAI,QAAG,CAAC;IACd,MAAM,IAAI,GAAG,CAAC;IACd,MAAM,IAAI,QAAG,CAAC;IAEd,UAAU;IACV,OAAO;SACJ,MAAM,CAAC,UAAA,CAAC,IAAI,OAAA,CAAC,CAAC,SAAS,KAAK,IAAI,CAAC,SAAS,EAA9B,CAA8B,CAAC;SAC3C,OAAO,CAAC,UAAC,GAAG,EAAE,GAAG,EAAE,KAAK;QACvB,MAAM,IAAI,MAAM,GAAG,MAAM,CAAC,GAAG,CAAC,CAAC;QAE/B,+BAA+B;QAC/B,EAAE,CAAC,CAAC,GAAG,KAAK,KAAK,CAAC,MAAM,GAAG,CAAC,CAAC,CAAC,CAAC;YAC7B,MAAM,IAAI,GAAG,CAAC;QAChB,CAAC;QAED,MAAM,IAAI,QAAG,CAAC;IAChB,CAAC,CAAC,CAAC;IAEL,MAAM,IAAI,GAAG,CAAC;IACd,MAAM,IAAI,QAAG,CAAC;IACd,MAAM,IAAI,QAAG,CAAC;IAEd,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC;AA5BD,kBA4BC;AAED;;;;GAIG;AACH,gBAAgB,IAAqB;IACnC,IAAI,MAAM,GAAW,MAAI,IAAI,CAAC,IAAI,MAAG,CAAC;IAEtC,EAAE,CAAC,CAAC,IAAI,CAAC,WAAW,CAAC,CAAC,CAAC;QACrB,MAAM,IAAI,SAAO,IAAI,CAAC,UAAY,CAAC;IACrC,CAAC;IAED,MAAM,IAAI,MAAI,IAAI,CAAC,QAAU,CAAC;IAE9B,MAAM,CAAC,CAAC,IAAI,CAAC,QAAQ,CAAC,CAAC,CAAC;QACtB,KAAK,SAAS,CAAC;QACf,KAAK,MAAM,CAAC;QACZ,KAAK,WAAW,CAAC;QACjB,KAAK,QAAQ,CAAC;QACd,KAAK,MAAM;YACT,MAAM,IAAI,GAAG,GAAG,CAAC,IAAI,CAAC,UAAU,KAAK,CAAC,CAAC,CAAC,CAAC,CAAC,KAAK,CAAC,CAAC,CAAC,IAAI,CAAC,UAAU,CAAC,GAAG,GAAG,CAAC;YACzE,KAAK,CAAC;QACR,KAAK,UAAU,CAAC;QAChB,KAAK,OAAO,CAAC;QACb,KAAK,OAAO;YACV,MAAM,IAAI,GAAG,GAAG,CAAC,IAAI,CAAC,UAAU,KAAK,CAAC,CAAC,CAAC,CAAC,CAAC,KAAK,CAAC,CAAC,CAAC,IAAI,CAAC,UAAU,GAAG,CAAC,CAAC,GAAG,GAAG,CAAC;YAC7E,KAAK,CAAC;QACR,KAAK,WAAW,CAAC;QACjB,KAAK,OAAO,CAAC;QACb,KAAK,gBAAgB;YACnB,MAAM,IAAI,GAAG,GAAG,IAAI,CAAC,KAAK,GAAG,GAAG,CAAC;YACjC,KAAK,CAAC;QACR,KAAK,SAAS;YACZ,MAAM,IAAI,GAAG,GAAG,IAAI,CAAC,SAAS,GAAG,IAAI,GAAG,IAAI,CAAC,KAAK,GAAG,GAAG,CAAC;YACzD,KAAK,CAAC;IACV,CAAC;IAED,EAAE,CAAC,CAAC,IAAI,CAAC,cAAc,CAAC,CAAC,CAAC;QACxB,MAAM,IAAI,cAAY,IAAI,CAAC,cAAgB,CAAC;IAC9C,CAAC;IAED,MAAM,IAAI,IAAI,CAAC,WAAW,CAAC,CAAC,CAAC,OAAO,CAAC,CAAC,CAAC,WAAW,CAAC;IAEnD,EAAE,CAAC,CAAC,IAAI,CAAC,UAAU,CAAC,CAAC,CAAC;QACpB,MAAM,IAAI,aAAW,IAAI,CAAC,UAAY,CAAC;IACzC,CAAC;IAED,EAAE,CAAC,CAAC,IAAI,CAAC,WAAW,CAAC,CAAC,CAAC;QACrB,MAAM,IAAI,gBAAa,IAAI,CAAC,UAAU,IAAI,CAAC,YAAK,IAAI,CAAC,eAAe,IAAI,CAAC,OAAG,CAAC;IAC/E,CAAC;IAED,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC;AAED;;;;GAIG;AACH,oBAAoB,IAAyB;IAC3C,MAAM,CAAC,iBAAe,IAAI,CAAC,IAAI,wBAAmB,IAAI,CAAC,MAAM,WAAK,IAAI,CAAC,iBAAiB,CAAC,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC,KAAK,OAAG,CAAC;AAC/G,CAAC;AAED;;;;GAIG;AACH,oBAAoB,IAAyB;IAC3C,IAAM,QAAQ,GAAc,IAAI,CAAC,MAAM,WAAM,IAAI,CAAC,KAAO,CAAC;IAE1D,IAAI,MAAM,GAAW,kBAAgB,QAAQ,gBAAU,IAAI,CAAC,cAAc,CAAC,CAAC,CAAC,SAAS,CAAC,CAAC,CAAC,OAAO,CAAE,CAAC;IACnG,MAAM,IAAI,sBAAoB,IAAI,CAAC,IAAI,uBAAkB,IAAI,CAAC,MAAM,OAAI,CAAC;IACzE,MAAM,IAAI,kBAAgB,QAAQ,YAAO,IAAI,CAAC,SAAS,OAAI,CAAC;IAE5D,MAAM,CAAC,CAAC,IAAI,CAAC,yBAAyB,CAAC,CAAC,CAAC;QACvC,KAAK,CAAC;YACJ,MAAM,IAAI,oBAAoB,CAAC;YAC/B,KAAK,CAAC;QACR,KAAK,CAAC;YACJ,MAAM,IAAI,qBAAqB,CAAC;YAChC,KAAK,CAAC;QACR,KAAK,CAAC;YACJ,MAAM,IAAI,wBAAwB,CAAC;YACnC,KAAK,CAAC;IACV,CAAC;IAED,MAAM,CAAC,CAAC,IAAI,CAAC,yBAAyB,CAAC,CAAC,CAAC;QACvC,KAAK,CAAC;YACJ,MAAM,IAAI,oBAAoB,CAAC;YAC/B,KAAK,CAAC;QACR,KAAK,CAAC;YACJ,MAAM,IAAI,qBAAqB,CAAC;YAChC,KAAK,CAAC;QACR,KAAK,CAAC;YACJ,MAAM,IAAI,wBAAwB,CAAC;YACnC,KAAK,CAAC;IACV,CAAC;IAED,MAAM,IAAI,mBAAiB,QAAQ,4BAAuB,IAAI,CAAC,IAAI,MAAG,CAAC;IACvE,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC;AAED;;;;GAIG;AACH,eAAe,IAAoB;IACjC,IAAM,QAAQ,GAAc,IAAI,CAAC,MAAM,WAAM,IAAI,CAAC,KAAO,CAAC;IAC1D,IAAI,MAAM,GAAW,EAAE,CAAC;IAExB,cAAc;IACd,2CAA2C;IAC3C,MAAM,IAAI,4EAA0E,QAAQ,wBAAmB,IAAI,CAAC,IAAI,OAAI,CAAC;IAC7H,MAAM,IAAI,QAAG,CAAC;IAEd,MAAM,IAAI,QAAQ,CAAC;IAEnB,EAAE,CAAC,CAAC,IAAI,CAAC,SAAS,CAAC,CAAC,CAAC;QACnB,MAAM,IAAI,SAAS,CAAC;IACtB,CAAC;IAED,MAAM,IAAI,0BAAwB,IAAI,CAAC,IAAI,cAAS,QAAQ,MAAG,CAAC;IAChE,MAAM,IAAI,OAAK,IAAI,CAAC,MAAM,WAAK,IAAI,CAAC,iBAAiB,CAAC,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC,KAAK,OAAG,CAAC;IAE1E,uBAAuB;IAEvB,MAAM,IAAI,QAAG,CAAC;IACd,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC"}
+{"version":3,"file":"script.js","sourceRoot":"","sources":["../../src/sql/script.ts"],"names":[],"mappings":";;AAAA,yBAAyB;AACzB,yCAAyD;AAczD;;;;;GAKG;AACH,qBAA4B,IAAuB,EAAE,IAAuB;IAC1E,IAAI,GAAW,CAAC;IAChB,IAAM,QAAQ,GAAc,IAAI,CAAC,MAAM,WAAM,IAAI,CAAC,IAAM,CAAC;IAEzD,IAAI,CAAC,IAAI,GAAG,IAAI,CAAC,IAAI,CAAC,IAAI,EAAE,CAAC;IAE7B,8CAA8C;IAC9C,MAAM,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC,CAAC;QAClB,KAAK,GAAG;YACN,GAAG,GAAG,OAAO,CAAC;YACd,KAAK,CAAC;QACR,KAAK,IAAI;YACP,GAAG,GAAG,OAAO,CAAC;YACd,KAAK,CAAC;QACR,KAAK,GAAG;YACN,GAAG,GAAG,WAAW,CAAC;YAClB,KAAK,CAAC;QACR,KAAK,GAAG;YACN,GAAG,GAAG,MAAM,CAAC;YACb,KAAK,CAAC;QACR,KAAK,IAAI,CAAC;QACV,KAAK,IAAI,CAAC;QACV,KAAK,IAAI;YACP,GAAG,GAAG,UAAU,CAAC;YACjB,KAAK,CAAC;QACR,KAAK,IAAI;YACP,GAAG,GAAG,SAAS,CAAC;YAChB,KAAK,CAAC;IACV,CAAC;IAED,EAAE,CAAC,CAAC,IAAI,KAAK,gBAAgB,CAAC,CAAC,CAAC;QAC9B,iBAAiB;QACjB,EAAE,CAAC,CAAC,IAAI,CAAC,IAAI,KAAK,IAAI,CAAC,CAAC,CAAC;YACvB,MAAM,CAAC;gBACL,aAAa;gBACb,wCAAwC;gBACxC,qDAAqD;gBACrD,yBAAuB,IAAI,CAAC,IAAI,wBAAmB,IAAI,CAAC,MAAM,MAAG;gBACjE,GAAG;gBACH,gBAAc,QAAQ,MAAG;gBACzB,IAAI;gBACJ,QAAG;aACJ,CAAC,IAAI,CAAC,QAAG,CAAC,CAAC;QACd,CAAC;QAAC,IAAI,CAAC,CAAC;YACN,MAAM,CAAC;gBACL,wEAAsE,QAAQ,wBAAmB,IAAI,CAAC,IAAI,OAAI;gBAC9G,UAAQ,GAAG,UAAK,QAAQ,MAAG;gBAC3B,IAAI;gBACJ,QAAG;aACJ,CAAC,IAAI,CAAC,QAAG,CAAC,CAAC;QACd,CAAC;IACH,CAAC;IAAC,IAAI,CAAC,EAAE,CAAC,CAAC,IAAI,KAAK,eAAe,CAAC,CAAC,CAAC;QACpC,gBAAgB;QAChB,EAAE,CAAC,CAAC,IAAI,CAAC,IAAI,KAAK,IAAI,CAAC,CAAC,CAAC;YACvB,MAAM,CAAC;gBACL,iBAAiB;gBACjB,wCAAwC;gBACxC,qDAAqD;gBACrD,yBAAuB,IAAI,CAAC,IAAI,wBAAmB,IAAI,CAAC,MAAM,MAAG;gBACjE,GAAG;gBACH,EAAE;aACH,CAAC,IAAI,CAAC,QAAG,CAAC,CAAC;QACd,CAAC;QAAC,IAAI,CAAC,CAAC;YACN,MAAM,CAAC;gBACL,2CAA2C;gBAC3C,4EAA0E,QAAQ,wBAAmB,IAAI,CAAC,IAAI,OAAI;gBAClH,EAAE;aACH,CAAC,IAAI,CAAC,QAAG,CAAC,CAAC;QACd,CAAC;IACH,CAAC;IAED,OAAO;IACP,MAAM,CAAC,EAAE,CAAC;AACZ,CAAC;AAzED,kCAyEC;AAED;;;;GAIG;AACH,gBAAuB,IAAqB;IAC1C,IAAI,MAAM,GAAW,EAAE,CAAC;IAExB,cAAc;IACd,MAAM,IAAI,4DAA0D,IAAI,CAAC,IAAI,OAAI,CAAC;IAClF,MAAM,IAAI,QAAG,CAAC;IAEd,MAAM,IAAI,yBAAuB,IAAI,CAAC,IAAI,OAAI,CAAC;IAC/C,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC;AATD,wBASC;AAED;;;;;;;;GAQG;AACH,eACE,IAAoB,EACpB,OAA0B,EAC1B,WAAkC,EAClC,WAAkC,EAClC,OAAyB;IAEzB,IAAI,MAAM,GAAW,mBAAiB,IAAI,CAAC,MAAM,WAAM,IAAI,CAAC,IAAI,MAAG,CAAC;IACpE,MAAM,IAAI,QAAG,CAAC;IACd,MAAM,IAAI,GAAG,CAAC;IACd,MAAM,IAAI,QAAG,CAAC;IAEd,UAAU;IACV,OAAO;SACJ,MAAM,CAAC,UAAA,CAAC,IAAI,OAAA,CAAC,CAAC,SAAS,KAAK,IAAI,CAAC,SAAS,EAA9B,CAA8B,CAAC;SAC3C,OAAO,CAAC,UAAA,GAAG;QACV,MAAM,IAAI,MAAM,GAAG,MAAM,CAAC,GAAG,CAAC,GAAG,GAAG,CAAC;QACrC,MAAM,IAAI,QAAG,CAAC;IAChB,CAAC,CAAC,CAAC;IAEL,eAAe;IACf,WAAW;SACR,MAAM,CAAC,UAAA,CAAC,IAAI,OAAA,CAAC,CAAC,SAAS,KAAK,IAAI,CAAC,SAAS,EAA9B,CAA8B,CAAC;SAC3C,OAAO,CAAC,UAAA,EAAE;QACT,MAAM,IAAI,MAAM,GAAG,UAAU,CAAC,EAAE,CAAC,CAAC;QAClC,MAAM,IAAI,QAAG,CAAC;IAChB,CAAC,CAAC,CAAC;IAEL,eAAe;IACf,WAAW;SACR,MAAM,CAAC,UAAA,CAAC,IAAI,OAAA,CAAC,CAAC,SAAS,KAAK,IAAI,CAAC,SAAS,EAA9B,CAA8B,CAAC;SAC3C,OAAO,CAAC,UAAA,EAAE;QACT,MAAM,IAAI,MAAM,GAAG,UAAU,CAAC,EAAE,CAAC,CAAC;QAClC,MAAM,IAAI,QAAG,CAAC;IAChB,CAAC,CAAC,CAAC;IAEL,MAAM,IAAI,GAAG,CAAC;IACd,MAAM,IAAI,QAAG,CAAC;IACd,MAAM,IAAI,QAAG,CAAC;IAEd,UAAU;IACV,OAAO;SACJ,MAAM,CAAC,UAAA,CAAC,IAAI,OAAA,CAAC,CAAC,SAAS,KAAK,IAAI,CAAC,SAAS,EAA9B,CAA8B,CAAC;SAC3C,OAAO,CAAC,UAAA,EAAE;QACT,MAAM,IAAI,KAAK,CAAC,EAAE,CAAC,CAAC;QACpB,MAAM,IAAI,QAAG,CAAC;IAChB,CAAC,CAAC,CAAC;IAEL,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC;AAjDD,sBAiDC;AAED;;;;;GAKG;AACH,aACE,IAAoB,EACpB,OAA0B;IAE1B,IAAI,MAAM,GAAW,kBAAgB,IAAI,CAAC,MAAM,WAAM,IAAI,CAAC,IAAI,eAAY,CAAC;IAC5E,MAAM,IAAI,QAAG,CAAC;IACd,MAAM,IAAI,GAAG,CAAC;IACd,MAAM,IAAI,QAAG,CAAC;IAEd,UAAU;IACV,OAAO;SACJ,MAAM,CAAC,UAAA,CAAC,IAAI,OAAA,CAAC,CAAC,SAAS,KAAK,IAAI,CAAC,SAAS,EAA9B,CAA8B,CAAC;SAC3C,OAAO,CAAC,UAAC,GAAG,EAAE,GAAG,EAAE,KAAK;QACvB,MAAM,IAAI,MAAM,GAAG,MAAM,CAAC,GAAG,CAAC,CAAC;QAE/B,+BAA+B;QAC/B,EAAE,CAAC,CAAC,GAAG,KAAK,KAAK,CAAC,MAAM,GAAG,CAAC,CAAC,CAAC,CAAC;YAC7B,MAAM,IAAI,GAAG,CAAC;QAChB,CAAC;QAED,MAAM,IAAI,QAAG,CAAC;IAChB,CAAC,CAAC,CAAC;IAEL,MAAM,IAAI,GAAG,CAAC;IACd,MAAM,IAAI,QAAG,CAAC;IACd,MAAM,IAAI,QAAG,CAAC;IAEd,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC;AA5BD,kBA4BC;AAED;;;;GAIG;AACH,cAAqB,IAAmB;IACtC,IAAI,MAAM,GAAW,EAAE,CAAC;IAExB,cAAc;IACd,MAAM,IAAI,oBAAkB,IAAI,CAAC,IAAM,CAAC;IACxC,MAAM,IAAI,QAAG,CAAC;IAEd,IAAI,CAAC,MAAM,CAAC,SAAS,CAAC,OAAO,CAAC,UAAA,GAAG;QAC/B,IAAM,IAAI,GAAa,MAAM,CAAC,IAAI,CAAC,GAAG,CAAC,CAAC;QACxC,IAAM,OAAO,GAAW,IAAI,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QACxC,IAAM,MAAM,GAAW,IAAI,CAAC,GAAG,CAAC,UAAA,GAAG,IAAI,OAAA,SAAS,CAAC,GAAG,CAAC,GAAG,CAAC,CAAC,EAAnB,CAAmB,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QAEvE,MAAM,IAAI,iBAAe,IAAI,CAAC,IAAI,UAAK,OAAO,kBAAa,MAAM,MAAG,CAAC;QACrE,MAAM,IAAI,QAAG,CAAC;IAChB,CAAC,CAAC,CAAC;IAEH,MAAM,IAAI,QAAG,CAAC;IACd,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC;AAlBD,oBAkBC;AAED;;;;GAIG;AACH,mBAAmB,KAAU;IAC3B,EAAE,CAAC,CAAC,qBAAQ,CAAC,KAAK,CAAC,CAAC,CAAC,CAAC;QACpB,KAAK,GAAG,KAAK,CAAC,OAAO,CAAC,GAAG,EAAE,IAAI,CAAC,CAAC;QACjC,MAAM,CAAC,MAAI,KAAK,MAAG,CAAC;IACtB,CAAC;IAED,EAAE,CAAC,CAAC,mBAAM,CAAC,KAAK,CAAC,CAAC,CAAC,CAAC;QAClB,KAAK,GAAG,KAAK,CAAC,WAAW,EAAE,CAAC;QAC5B,MAAM,CAAC,MAAI,KAAK,MAAG,CAAC;IACtB,CAAC;IAED,EAAE,CAAC,CAAC,sBAAS,CAAC,KAAK,CAAC,CAAC,CAAC,CAAC;QACrB,MAAM,CAAC,KAAK,CAAC,CAAC,CAAC,CAAC,CAAC,CAAC,CAAC,CAAC,CAAC;IACvB,CAAC;IAED,MAAM,CAAC,KAAK,CAAC;AACf,CAAC;AAED;;;;GAIG;AACH,gBAAgB,IAAqB;IACnC,IAAI,MAAM,GAAW,MAAI,IAAI,CAAC,IAAI,MAAG,CAAC;IAEtC,EAAE,CAAC,CAAC,IAAI,CAAC,WAAW,CAAC,CAAC,CAAC;QACrB,MAAM,IAAI,SAAO,IAAI,CAAC,UAAY,CAAC;IACrC,CAAC;IAED,MAAM,IAAI,MAAI,IAAI,CAAC,QAAU,CAAC;IAE9B,MAAM,CAAC,CAAC,IAAI,CAAC,QAAQ,CAAC,CAAC,CAAC;QACtB,KAAK,SAAS,CAAC;QACf,KAAK,MAAM,CAAC;QACZ,KAAK,WAAW,CAAC;QACjB,KAAK,QAAQ,CAAC;QACd,KAAK,MAAM;YACT,MAAM,IAAI,GAAG,GAAG,CAAC,IAAI,CAAC,UAAU,KAAK,CAAC,CAAC,CAAC,CAAC,CAAC,KAAK,CAAC,CAAC,CAAC,IAAI,CAAC,UAAU,CAAC,GAAG,GAAG,CAAC;YACzE,KAAK,CAAC;QACR,KAAK,UAAU,CAAC;QAChB,KAAK,OAAO,CAAC;QACb,KAAK,OAAO;YACV,MAAM,IAAI,GAAG,GAAG,CAAC,IAAI,CAAC,UAAU,KAAK,CAAC,CAAC,CAAC,CAAC,CAAC,KAAK,CAAC,CAAC,CAAC,IAAI,CAAC,UAAU,GAAG,CAAC,CAAC,GAAG,GAAG,CAAC;YAC7E,KAAK,CAAC;QACR,KAAK,WAAW,CAAC;QACjB,KAAK,OAAO,CAAC;QACb,KAAK,gBAAgB;YACnB,MAAM,IAAI,GAAG,GAAG,IAAI,CAAC,KAAK,GAAG,GAAG,CAAC;YACjC,KAAK,CAAC;QACR,KAAK,SAAS;YACZ,MAAM,IAAI,GAAG,GAAG,IAAI,CAAC,SAAS,GAAG,IAAI,GAAG,IAAI,CAAC,KAAK,GAAG,GAAG,CAAC;YACzD,KAAK,CAAC;IACV,CAAC;IAED,EAAE,CAAC,CAAC,IAAI,CAAC,cAAc,CAAC,CAAC,CAAC;QACxB,MAAM,IAAI,cAAY,IAAI,CAAC,cAAgB,CAAC;IAC9C,CAAC;IAED,MAAM,IAAI,IAAI,CAAC,WAAW,CAAC,CAAC,CAAC,OAAO,CAAC,CAAC,CAAC,WAAW,CAAC;IAEnD,EAAE,CAAC,CAAC,IAAI,CAAC,UAAU,CAAC,CAAC,CAAC;QACpB,MAAM,IAAI,aAAW,IAAI,CAAC,UAAY,CAAC;IACzC,CAAC;IAED,EAAE,CAAC,CAAC,IAAI,CAAC,WAAW,CAAC,CAAC,CAAC;QACrB,MAAM,IAAI,gBAAa,IAAI,CAAC,UAAU,IAAI,CAAC,YAAK,IAAI,CAAC,eAAe,IAAI,CAAC,OAAG,CAAC;IAC/E,CAAC;IAED,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC;AAED;;;;GAIG;AACH,oBAAoB,IAAyB;IAC3C,MAAM,CAAC,iBAAe,IAAI,CAAC,IAAI,wBAAmB,IAAI,CAAC,MAAM,WAAK,IAAI,CAAC,iBAAiB,CAAC,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC,KAAK,OAAG,CAAC;AAC/G,CAAC;AAED;;;;GAIG;AACH,oBAAoB,IAAyB;IAC3C,IAAM,QAAQ,GAAc,IAAI,CAAC,MAAM,WAAM,IAAI,CAAC,KAAO,CAAC;IAE1D,IAAI,MAAM,GAAW,kBAAgB,QAAQ,gBAAU,IAAI,CAAC,cAAc,CAAC,CAAC,CAAC,SAAS,CAAC,CAAC,CAAC,OAAO,CAAE,CAAC;IACnG,MAAM,IAAI,sBAAoB,IAAI,CAAC,IAAI,uBAAkB,IAAI,CAAC,MAAM,OAAI,CAAC;IACzE,MAAM,IAAI,kBAAgB,QAAQ,YAAO,IAAI,CAAC,SAAS,OAAI,CAAC;IAE5D,MAAM,CAAC,CAAC,IAAI,CAAC,yBAAyB,CAAC,CAAC,CAAC;QACvC,KAAK,CAAC;YACJ,MAAM,IAAI,oBAAoB,CAAC;YAC/B,KAAK,CAAC;QACR,KAAK,CAAC;YACJ,MAAM,IAAI,qBAAqB,CAAC;YAChC,KAAK,CAAC;QACR,KAAK,CAAC;YACJ,MAAM,IAAI,wBAAwB,CAAC;YACnC,KAAK,CAAC;IACV,CAAC;IAED,MAAM,CAAC,CAAC,IAAI,CAAC,yBAAyB,CAAC,CAAC,CAAC;QACvC,KAAK,CAAC;YACJ,MAAM,IAAI,oBAAoB,CAAC;YAC/B,KAAK,CAAC;QACR,KAAK,CAAC;YACJ,MAAM,IAAI,qBAAqB,CAAC;YAChC,KAAK,CAAC;QACR,KAAK,CAAC;YACJ,MAAM,IAAI,wBAAwB,CAAC;YACnC,KAAK,CAAC;IACV,CAAC;IAED,MAAM,IAAI,mBAAiB,QAAQ,4BAAuB,IAAI,CAAC,IAAI,MAAG,CAAC;IACvE,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC;AAED;;;;GAIG;AACH,eAAe,IAAoB;IACjC,IAAM,QAAQ,GAAc,IAAI,CAAC,MAAM,WAAM,IAAI,CAAC,KAAO,CAAC;IAC1D,IAAI,MAAM,GAAW,EAAE,CAAC;IAExB,cAAc;IACd,2CAA2C;IAC3C,MAAM,IAAI,4EAA0E,QAAQ,wBAAmB,IAAI,CAAC,IAAI,OAAI,CAAC;IAC7H,MAAM,IAAI,QAAG,CAAC;IAEd,MAAM,IAAI,QAAQ,CAAC;IAEnB,EAAE,CAAC,CAAC,IAAI,CAAC,SAAS,CAAC,CAAC,CAAC;QACnB,MAAM,IAAI,SAAS,CAAC;IACtB,CAAC;IAED,MAAM,IAAI,0BAAwB,IAAI,CAAC,IAAI,cAAS,QAAQ,MAAG,CAAC;IAChE,MAAM,IAAI,OAAK,IAAI,CAAC,MAAM,WAAK,IAAI,CAAC,iBAAiB,CAAC,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC,KAAK,OAAG,CAAC;IAE1E,uBAAuB;IAEvB,MAAM,IAAI,QAAG,CAAC;IACd,MAAM,CAAC,MAAM,CAAC;AAChB,CAAC"}

package.json

 {
   "name": "sql-source-control",
-  "version": "1.7.1",
+  "version": "1.8.0",
   "description": "Simple CLI for getting SQL into source control systems.",
@@ -46,5 +46,5 @@ "keywords": [
     "deepmerge": "^2.1.0",
-    "fs-extra": "^5.0.0",
+    "fs-extra": "^6.0.0",
     "glob": "^7.1.2",
-    "inquirer": "^5.0.0",
+    "inquirer": "^6.0.0",
     "mssql": "^4.1.0",
@@ -51,0 +51,0 @@ "multimatch": "^2.1.0",

README.md

@@ -66,2 +66,5 @@ [![NPM Version](https://badge.fury.io/js/sql-source-control.svg)](https://badge.fury.io/js/sql-source-control)
 ./_sql-database
+    ./data
+        dbo.easy-lookup.sql
+        ...
     ./functions/scalar-valued
@@ -82,11 +85,16 @@ dbo.complex-math.sql
         ...
+    ./user-defined-types/table-valued-parameters
+        dbo.insert-people-params.sql
+        ...
     ./views
         dbo.super-cool-view.sql
         ...
-    ./user-defined-types/table-valued-parameters
-        dbo.insert-people-params.sql
-        ...
 ```
 
-## Push (beta)
+Data can be included in the `pull` via the `data` glob in the configuration file. All tables included
+in the `data` glob will result in a file that truncates the table and inserts all rows. Because a truncate
+is issued, it is recommended to only include static data tables, like lookup tables, in the `data`
+configuration.
+
+## Push
 Execute all local scripts against the requested database.
@@ -135,2 +143,5 @@
 
+  // glob of tables to include / exclude for data scripting (example: ["dbo.LookupTable"])
+  "data": [],
+
   "output": {
@@ -141,25 +152,28 @@
 
-    // directory to script procs (relative to root)
+    // directory to script data (relative to root)
+    "data": "./data"
+
+    // directory to script procs (relative to root), or false
     "procs": "./stored-procedures",
 
-    // directory to script schemas (relative to root)
+    // directory to script scalar functions (relative to root), or false
+    "scalar-valued": "./functions/scalar-valued",
+
+    // directory to script schemas (relative to root), or false
     "schemas": "./schemas",
 
-    // directory to script scalar functions (relative to root)
-    "scalar-valued": "./functions/scalar-valued",
-
-    // directory to script table functions (relative to root)
+    // directory to script table functions (relative to root), or false
     "table-valued": "./functions/table-valued",
 
-    // directory to script tables (relative to root)
+    // directory to script table-valued parameters (relative to root), or false
+    "table-valued-parameters": "./user-defined-types/table-valued-parameters"
+
+    // directory to script tables (relative to root), or false
     "tables": "./tables",
 
-    // directory to script triggers (relative to root)
+    // directory to script triggers (relative to root), or false
     "triggers": "./triggers",
 
-    // directory to script views (relative to root)
+    // directory to script views (relative to root), or false
     "views": "./views"
-
-    // directory to script table-valued parameters (relative to root)
-    "table-valued-parameters": "./user-defined-types/table-valued-parameters"
   },
@@ -173,6 +187,6 @@
     "table-valued": "if-exists-drop",
+    "table-valued-parameters": "if-not-exists",
     "tables": "if-not-exists",
     "triggers": "if-exists-drop",
-    "views": "if-exists-drop",
-    "table-valued-parameters": "if-not-exists";
+    "views": "if-exists-drop"
   }
@@ -179,0 +193,0 @@ }

New alerts

Unpublished package

Supply chain risk

Package version was not found on the registry. It may exist on a different registry and need to be configured to pull from that registry.

Found 1 instance in 1 package

Filesystem access

Supply chain risk

Accesses the file system, and could potentially read sensitive data.

Found 1 instance in 1 package

Fixed alerts

Unpublished package

Supply chain risk

Package version was not found on the registry. It may exist on a different registry and need to be configured to pull from that registry.

Found 1 instance in 1 package

Filesystem access

Supply chain risk

Accesses the file system, and could potentially read sensitive data.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

83255

5.49%

Lines of code

1071

5.73%

Number of lines in readme file

199

7.57%

Dependency changes

• + Added

  ansi-regex@4.1.1
  (transitive)

• + Added

  chardet@0.7.0
  (transitive)

• + Added

  external-editor@3.1.0
  (transitive)

• + Added

  fs-extra@6.0.1
  (transitive)

• + Added

  inquirer@6.5.2
  (transitive)

• + Added

  rxjs@6.6.7
  (transitive)

• + Added

  strip-ansi@5.2.0
  (transitive)

• + Added

  tslib@1.14.1
  (transitive)

• - Removed

  chardet@0.4.2
  (transitive)

• - Removed

  external-editor@2.2.0
  (transitive)

• - Removed

  fs-extra@5.0.0
  (transitive)

• - Removed

  inquirer@5.2.0
  (transitive)

• - Removed

  rxjs@5.5.12
  (transitive)

• - Removed

  symbol-observable@1.0.1
  (transitive)

• Updated

  fs-extra@^6.0.0

• Updated

  inquirer@^6.0.0