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

pg-diff-cli

Package Overview
Dependencies
Maintainers
1
Versions
47
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

pg-diff-cli - npm Package Compare versions

Comparing version
1.1.0
to
1.1.1
+4
-0
CHANGELOG.md
# 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 @@

@@ -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 @@ }