Fix null type

porsager · porsager · commit f048b0f425e4 · 2019-11-29T12:44:55.000+01:00
diff --git a/cjs/package.json b/cjs/package.json
@@ -1,12 +1,12 @@
 {
   "name": "peegee",
-  "version": "0.0.8",
+  "version": "0.0.9",
   "description": "Fastest full featured PostgreSQL client for Node.js",
   "main": "lib/index.js",
   "type": "commonjs",
   "scripts": {
     "test": "node tests/index.js",
-    "prepublishOnly": "eslint lib && npm run build",
+    "prepublishOnly": "eslint lib && npm test && npm run build",
     "build": "node cjs/transpile.js"
   },
   "author": "Rasmus Porsager <rasmus@porsager.com",
diff --git a/lib/index.js b/lib/index.js
@@ -413,7 +413,7 @@ export default function Postgres(url, options) {
 
   function getType(x) {
     if (x == null)
-      return { type: types.string.to, value: x }
+      return { type: 0, value: x }
 
     const value = x.type ? x.value : x
         , type = x.array ? typeArrayMap[x.type || inferType(value)] : (x.type || inferType(value))
diff --git a/tests/index.js b/tests/index.js
@@ -112,6 +112,11 @@ t('Escape in arrays', async() =>
   ['Hello "you",c:\\windows', (await sql`select ${ sql.array(['Hello "you"', 'c:\\windows']) } as x`)[0].x.join(',')]
 )
 
+t('null for int', async() => {
+  await sql`create table test (x int)`
+  return [1, (await sql`insert into test values(${ null })`).count]
+}, () => sql`drop table test`)
+
 t('Transaction throws', async() => {
   await sql`create table test (a int)`
   return ['22P02', await sql.begin(async sql => {
@@ -243,7 +248,7 @@ t('Point type array', async() => {
 }, () => sql`drop table test`)
 
 t('sql file', async() =>
-  [1, (await sql.file('./select.sql'))[0].x]
+  [1, (await sql.file('./tests/select.sql'))[0].x]
 )
 /*
 t('select column vars', async() => {
@@ -254,7 +259,7 @@ t('select column vars', async() => {
 */
 t('sql file can stream', async() => {
   let result
-  await sql.file('./select.sql')
+  await sql.file('./tests/select.sql')
     .stream(({ x }) => result = x)
 
   return [1, result]
