replace-enum-postgresql - npm Package Compare versions

Comparing version 1.0.0 to 1.1.0

build/index.js

@@ -116,3 +116,3 @@ 'use strict';
 function getQueryToCreateEnum(name, values) {
-  return 'CREATE TYPE ' + name + ' AS ENUM (\'' + values.join('\', \'') + '\')';
+  return 'CREATE TYPE "' + name + '" AS ENUM (\'' + values.join('\', \'') + '\')';
 }
@@ -144,3 +144,3 @@
 function getQueryToRemoveDefaultFromColumn(tableName, columnName) {
-  return 'ALTER TABLE ' + tableName + ' ALTER COLUMN ' + columnName + ' DROP DEFAULT';
+  return 'ALTER TABLE "' + tableName + '" ALTER COLUMN "' + columnName + '" DROP DEFAULT';
 }
@@ -173,3 +173,3 @@
 function getQueryToSetEnumType(tableName, columnName, enumName) {
-  return '\n    ALTER TABLE ' + tableName + '\n      ALTER COLUMN ' + columnName + '\n        TYPE ' + enumName + '\n        USING (' + columnName + '::text::' + enumName + ')\n  ';
+  return '\n    ALTER TABLE "' + tableName + '"\n      ALTER COLUMN "' + columnName + '"\n        TYPE "' + enumName + '"\n        USING ("' + columnName + '"::text::"' + enumName + '")\n  ';
 }
@@ -199,3 +199,3 @@
 function getQueryToDropEnum(enumName) {
-  return 'DROP TYPE ' + enumName;
+  return 'DROP TYPE "' + enumName + '"';
 }
@@ -227,3 +227,3 @@
 function getQueryToRenameEnum(oldEnumName, newEnumName) {
-  return 'ALTER TYPE ' + oldEnumName + ' RENAME TO ' + newEnumName + ' ';
+  return 'ALTER TYPE "' + oldEnumName + '" RENAME TO "' + newEnumName + '"';
 }
@@ -259,4 +259,4 @@
 function getQueryToSetColumnDefault(tableName, columnName, defaultValue, defaultValueType) {
-  return '\n    ALTER TABLE ' + tableName + '\n      ALTER COLUMN ' + columnName + '\n        SET DEFAULT \'' + defaultValue + '\'::' + defaultValueType + '\n  ';
+  return '\n    ALTER TABLE "' + tableName + '"\n      ALTER COLUMN "' + columnName + '"\n        SET DEFAULT \'' + defaultValue + '\'::' + defaultValueType + '\n  ';
 }
 //# sourceMappingURL=index.js.map

package.json

 {
   "name": "replace-enum-postgresql",
-  "version": "1.0.0",
+  "version": "1.1.0",
   "description": "This package provides the methods needed to replace a PostgreSQL ENUM (ie., in migrations).",
@@ -9,3 +9,3 @@ "main": "build/index.js",
     "build": "babel src -D -s -d build",
-    "prepublish": "npm run build"
+    "prepublishOnly": "npm run build"
   },
@@ -12,0 +12,0 @@ "repository": {

src/index.js

@@ -94,3 +94,3 @@ /**
 export function getQueryToCreateEnum(name, values) {
-  return `CREATE TYPE ${name} AS ENUM ('${values.join('\', \'')}')`;
+  return `CREATE TYPE "${name}" AS ENUM ('${values.join('\', \'')}')`;
 }
@@ -125,3 +125,3 @@
 export function getQueryToRemoveDefaultFromColumn(tableName, columnName) {
-  return `ALTER TABLE ${tableName} ALTER COLUMN ${columnName} DROP DEFAULT`;
+  return `ALTER TABLE "${tableName}" ALTER COLUMN "${columnName}" DROP DEFAULT`;
 }
@@ -158,6 +158,6 @@
   return `
-    ALTER TABLE ${tableName}
-      ALTER COLUMN ${columnName}
-        TYPE ${enumName}
-        USING (${columnName}::text::${enumName})
+    ALTER TABLE "${tableName}"
+      ALTER COLUMN "${columnName}"
+        TYPE "${enumName}"
+        USING ("${columnName}"::text::"${enumName}")
   `;
@@ -191,3 +191,3 @@ }
 export function getQueryToDropEnum(enumName) {
-  return `DROP TYPE ${enumName}`;
+  return `DROP TYPE "${enumName}"`;
 }
@@ -222,3 +222,3 @@
 export function getQueryToRenameEnum(oldEnumName, newEnumName) {
-  return `ALTER TYPE ${oldEnumName} RENAME TO ${newEnumName} `;
+  return `ALTER TYPE "${oldEnumName}" RENAME TO "${newEnumName}"`;
 }
@@ -263,6 +263,6 @@
   return `
-    ALTER TABLE ${tableName}
-      ALTER COLUMN ${columnName}
+    ALTER TABLE "${tableName}"
+      ALTER COLUMN "${columnName}"
         SET DEFAULT '${defaultValue}'::${defaultValueType}
   `;
 }

No alert changes

Improved metrics

Total package byte prevSize

25393

increased by0.44%

No dependency changes