feat: adds raw property to error and debug parameters (porsager#167)

stalniy · web-flow · commit 9e83e7f176e3 · 2021-04-05T10:44:39.000+02:00
* feat: adds `raw` property to error and debug parameters Fixes porsager#140 * fix(types): adds `null` as additional type to `Parameter.raw` and `Parameter.value`
diff --git a/lib/index.js b/lib/index.js
@@ -525,14 +525,15 @@ function Postgres(a, b) {
 
   function getType(x) {
     if (x == null)
-      return { type: 0, value: x }
+      return { type: 0, value: x, raw: x }
 
     const value = x.type ? x.value : x
         , type = x.type || inferType(value)
 
     return {
       type,
-      value: (options.serializers[type] || types.string.serialize)(value)
+      value: (options.serializers[type] || types.string.serialize)(value),
+      raw: x
     }
   }
 }
diff --git a/tests/index.js b/tests/index.js
@@ -1075,11 +1075,16 @@ t('Error contains query string', async() => [
   (await sql`selec 1`.catch(err => err.query))
 ])
 
-t('Error contains query parameters', async() => [
+t('Error contains query serialized parameters', async() => [
   '1',
   (await sql`selec ${ 1 }`.catch(err => err.parameters[0].value))
 ])
 
+t('Error contains query raw parameters', async() => [
+  1,
+  (await sql`selec ${ 1 }`.catch(err => err.parameters[0].raw))
+])
+
 t('Query string is not enumerable', async() => {
   const sql = postgres({ ...options, debug: false })
   return [
diff --git a/types/index.d.ts b/types/index.d.ts
@@ -175,9 +175,13 @@ declare namespace postgres {
      */
     type: number;
     /**
-     * Value to serialize
+     * Serialized value
      */
-    value: T;
+    value: string | null;
+    /**
+     * Raw value to serialize
+     */
+    raw: T | null;
   }
 
   interface ArrayParameter<T extends SerializableParameter[] = SerializableParameter[]> extends Parameter<T | T[]> {

Original file line number	Diff line number	Diff line change
`@@ -525,14 +525,15 @@ function Postgres(a, b) {`
`525`	`525`
`526`	`526`	`function getType(x) {`
`527`	`527`	`if (x == null)`
`528`		`- return { type: 0, value: x }`
	`528`	`+ return { type: 0, value: x, raw: x }`
`529`	`529`
`530`	`530`	`const value = x.type ? x.value : x`
`531`	`531`	`, type = x.type \|\| inferType(value)`
`532`	`532`
`533`	`533`	`return {`
`534`	`534`	`type,`
`535`		`- value: (options.serializers[type] \|\| types.string.serialize)(value)`
	`535`	`+ value: (options.serializers[type] \|\| types.string.serialize)(value),`
	`536`	`+ raw: x`
`536`	`537`	`}`
`537`	`538`	`}`
`538`	`539`	`}`