pg-diff-cli
Advanced tools
+4
-0
| # Changelog | ||
| #### ver 1.1.1 | ||
| - Fixed datatime issue between PGSQL timestamp data type and NodeJS Date object | ||
| - Fixed an issue when rebasing sequences | ||
| #### ver 1.1.0 | ||
@@ -4,0 +8,0 @@ |
+3
-0
@@ -14,4 +14,7 @@ #!/usr/bin/env node | ||
| const { Client } = require('pg'); | ||
| const pgTypes = require('pg').types; | ||
| const log = console.log; | ||
| pgTypes.setTypeParser(1114, (value) => new Date(Date.parse(`${value}+0000`))); | ||
| global.configName = ''; | ||
@@ -18,0 +21,0 @@ global.scriptName = ''; |
+1
-1
| { | ||
| "name": "pg-diff-cli", | ||
| "version": "1.1.0", | ||
| "version": "1.1.1", | ||
| "description": "PostgreSQL schema and data comparing tool", | ||
@@ -5,0 +5,0 @@ "pgver": "9.6+", |
@@ -228,3 +228,3 @@ const sql = require('./sqlScriptGenerator') | ||
| "script": script.replace(/'/g, "''"), | ||
| "applied_on": new Date().toUTCString() | ||
| "applied_on": new Date() | ||
| } | ||
@@ -231,0 +231,0 @@ |
@@ -347,4 +347,5 @@ const hints = { | ||
| switch (dataTypeCategory) { | ||
| case 'D': //DATE TIME | ||
| return `'${value.toISOString()}'`; | ||
| case 'A': //ARRAY | ||
| case 'D': //DATE TIME | ||
| case 'R': //RANGE | ||
@@ -391,3 +392,3 @@ case 'S': //STRING | ||
| generateSetSequenceValueScript(tableName, sequence) { | ||
| let script = `\nSELECT setval('${sequence.seqname}', max("${sequence.attname}"), true) FROM ${tableName};\n`; | ||
| let script = `\nSELECT setval(pg_get_serial_sequence('${tableName}', '${sequence.attname}'), max("${sequence.attname}"), true) FROM ${tableName};\n`; | ||
| return script; | ||
@@ -394,0 +395,0 @@ } |
Dynamic require
Supply chain riskDynamic require can indicate the package is performing dangerous or unsafe dynamic code execution.
Found 1 instance in 1 package
Filesystem access
Supply chain riskAccesses the file system, and could potentially read sensitive data.
Found 1 instance in 1 package
Dynamic require
Supply chain riskDynamic require can indicate the package is performing dangerous or unsafe dynamic code execution.
Found 1 instance in 1 package
Filesystem access
Supply chain riskAccesses the file system, and could potentially read sensitive data.
Found 1 instance in 1 package
105763
0.33%1838
0.16%