node-json-database - npm Package Compare versions

Comparing version 0.0.14 to 0.0.15

index.ts

@@ -617,3 +617,3 @@ import * as fs from 'fs'
 					drop(colNames: string[]) {
-						if (!thisTable.exists) {
+						if (!thTable.exists) {
 							throw new Error(`Table ${ chalk.magenta(tableName) } does not exist in database ${ chalk.cyan(filePath) }.`)
@@ -719,6 +719,20 @@ }
 
+										const prevNumber = (rowNum == undefined)
+											? (table.rows.length > 0)
+												? table.rows[table.rows.length - 1][col.name]
+												: 0
+											: (rowNum > 0)
+												? table.rows[rowNum - 1][col.name]
+												: 0
+
 										const currentNumber = (rowNum == undefined) ? table.rows.length + 1 : rowNum + 1 // autoIncrement starts at 1
 
-										if (el != undefined && el != currentNumber) {
-											throw new Error(`Could not insert ${ chalk.red(el) } into column ${ chalk.yellow(col.name) } of table ${ chalk.magenta(tableName) } of database ${ chalk.cyan(filePath) }, because this column has the ${ chalk.grey('autoIncrement') } constraint. Leave this column empty.`)
+										const nextNumber = (rowNum == undefined)
+											? Infinity
+											: (rowNum < table.rows.length)
+												? table.rows[rowNum + 1][col.name]
+												: Infinity
+
+										if (el != undefined && (el <= prevNumber || el >= nextNumber)) {
+											throw new Error(`Could not insert ${ chalk.red(el) } into column ${ chalk.yellow(col.name) } of table ${ chalk.magenta(tableName) } of database ${ chalk.cyan(filePath) }, because this column has the ${ chalk.grey('autoIncrement') } constraint. Leave this column empty or insert a value bigger than ${ prevNumber } and smaller than ${ nextNumber }`)
 										}
@@ -725,0 +739,0 @@

package.json

 {
   "name": "node-json-database",
-  "version": "0.0.14",
+  "version": "0.0.15",
   "description": "JS Database Management System using JSON files",
@@ -5,0 +5,0 @@ "main": "index.js",

No alert changes

Improved metrics

Total package byte prevSize

75481

increased by0.71%

Lines of code

1640

increased by0.8%

No dependency changes