af-db-ts - npm Package Compare versions

Comparing version 3.0.4 to 3.0.5

dist/cjs/src/pg/get-sql/reset-sequence.js

@@ -12,3 +12,3 @@ "use strict";
         const sequenceName = `${table}_${incFName}_seq`;
-        return `SELECT setval('"${schema}"."${sequenceName}"', (SELECT MAX("${incFName}") FROM "${schema}"."${table}"));`;
+        return `SELECT setval('"${schema}"."${sequenceName}"', (SELECT COALESCE(MAX("${incFName}"), 1) FROM "${schema}"."${table}"));`;
     }).join('\n');
@@ -15,0 +15,0 @@ };

dist/esm/src/pg/get-sql/reset-sequence.js

@@ -9,5 +9,5 @@ import { getTableSchemaPg } from '../table-schema-pg';
         const sequenceName = `${table}_${incFName}_seq`;
-        return `SELECT setval('"${schema}"."${sequenceName}"', (SELECT MAX("${incFName}") FROM "${schema}"."${table}"));`;
+        return `SELECT setval('"${schema}"."${sequenceName}"', (SELECT COALESCE(MAX("${incFName}"), 1) FROM "${schema}"."${table}"));`;
     }).join('\n');
 };
 //# sourceMappingURL=reset-sequence.js.map

package.json

 {
   "name": "af-db-ts",
-  "version": "3.0.4",
+  "version": "3.0.5",
   "description": "A highly specialized function library",
@@ -5,0 +5,0 @@ "main": "./dist/cjs/src/index.js",

src/pg/get-sql/reset-sequence.ts

@@ -15,4 +15,4 @@ import { getTableSchemaPg } from '../table-schema-pg';
     const sequenceName = `${table}_${incFName}_seq`;
-    return `SELECT setval('"${schema}"."${sequenceName}"', (SELECT MAX("${incFName}") FROM "${schema}"."${table}"));`;
+    return `SELECT setval('"${schema}"."${sequenceName}"', (SELECT COALESCE(MAX("${incFName}"), 1) FROM "${schema}"."${table}"));`;
   }).join('\n');
 };

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

703741

increased by0.01%

Published versions last two months

1

increased byInfinity%

No dependency changes