New Research: Supply Chain Attack on Axios Pulls Malicious Dependency from npm.Details → →
Socket
Book a DemoSign in
Socket
Book a DemoSign in

pg-diff-api

Package Overview
Dependencies
Maintainers
2
Versions
42
Alerts
File Explorer

Advanced tools

License
Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

pg-diff-api - npm Package Compare versions

Comparing version
1.4.3
 to
1.4.4
+2
-2
package.json
{
"name": "pg-diff-api",
"version": "1.4.3",
"version": "1.4.4",
"description": "PostgreSQL migration strategy for NodeJS",

@@ -12,3 +12,3 @@ "pgver": "9.6+",

"test-compare": "node ./test/compareTest.js",
"test-migration": "node ./test/migrationTest.js"
"test-migration": "node ./test/migrateTest.js"
},

@@ -15,0 +15,0 @@ "repository": {

+1
-1
src/api/CatalogApi.js

@@ -108,3 +108,3 @@ const core = require("../core");

LEFT JOIN pg_description d ON d.objoid = idx."oid" AND d.objsubid = 0
WHERE tbln.nspname = '${schemaName}' AND tbl.relname='${tableName}' AND i.indisprimary = false`;
WHERE tbln.nspname = '${schemaName}' AND tbl.relname='${tableName}' AND i.indisprimary = false AND i.indisunique = FALSE`;
},

@@ -111,0 +111,0 @@ /**

+7
-3
test/compareTest.js

@@ -7,5 +7,8 @@ const PgDiff = require("../src/index").PgDiff;

Config.sourceClient.database = "pg_diff_test1";
Config.sourceClient.port = 5437;
Config.targetClient.port = 5437;
Config.targetClient.password = "postgres";
Config.sourceClient.password = "postgres";
Config.compareOptions.outputDirectory = 1;
Config.compareOptions.outputDirectory = ".\\test\\patches";
// Config.compareOptions.schemaCompare.roles = ["postgres", "huko"];

@@ -18,7 +21,8 @@ Config.compareOptions.schemaCompare.namespaces = []; //["public", "schema_one"];

Config.compareOptions.dataCompare.enable = true;
Config.compareOptions.dataCompare.tables.push(new TableDefinition("test_generic", ["id","a_camelCaseField","a_string_array2"]));
Config.compareOptions.dataCompare.enable = false;
Config.compareOptions.dataCompare.tables.push(new TableDefinition("test_generic", ["id", "a_camelCaseField", "a_string_array2"]));
Config.compareOptions.dataCompare.tables.push(new TableDefinition("test_columnd_def_value", ["id"]));
Config.compareOptions.dataCompare.tables.push(new TableDefinition("diff_test", ["id"]));
Config.migrationOptions.historyTableName = "test_migrations";

@@ -25,0 +29,0 @@ var pgDiff = new PgDiff(Config);

+8
-2
test/migrateTest.js
const PgDiff = require("../src/index").PgDiff;
const Config = require("../src/index").Config;
Config.targetClient.database = "pg_diff_test2";
Config.sourceClient.database = "pg_diff_test1";
Config.sourceClient.port = 5437;
Config.targetClient.port = 5437;
Config.targetClient.password = "postgres";
Config.sourceClient.password = "postgres";
Config.migrationOptions.historyTableName = "test_migrations";
Config.targetClient.database = "pgdiff_test";
Config.targetClient.password = "postgres";
Config.migrationOptions.patchesDirectory = ".\\test\\patches";

@@ -8,0 +14,0 @@