Changeset: 28883be78b39 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=28883be78b39
Modified Files:
        clients/nodejs/monetdb/mapiclient.js
        clients/nodejs/monetdb/package.json
Branch: default
Log Message:

Extend the prepared statement handling to support json and timestamptz


diffs (38 lines):

diff --git a/clients/nodejs/monetdb/mapiclient.js 
b/clients/nodejs/monetdb/mapiclient.js
--- a/clients/nodejs/monetdb/mapiclient.js
+++ b/clients/nodejs/monetdb/mapiclient.js
@@ -137,13 +137,21 @@ MonetDBConnection.prototype.prepare = fu
                                                /* escape single quotes except 
if they are already escaped */
                                                        s = "'" + 
param.replace(/([^\\])'/g,"$1\\'") + "'";
                                                        break
+                                               case 'object':
+                                               case 'array':
+                                                       s = "json '" + 
JSON.stringify(param).replace(/([^\\])'/g,"$1\\'") + "'";
+                                                       break;
                                                default:
                                                        s = param;
                                                        break;
                                        }
                                        var colData = 
resp.data[resp.rows-bindparams.length+paramIndex];
-                                       if(colData && colData[0] == 
"timestamp") {
-                                               s = "timestamp "+s;
+                                       if(colData) {
+                                               if(colData[0] == "timestamp") {
+                                                       s = "timestamp "+s;
+                                               } else if(colData[0] == 
"timestamptz") {
+                                                       s = "timestamptz "+s
+                                               }
                                        }
                                        return s;
                                }).join(', ');
diff --git a/clients/nodejs/monetdb/package.json 
b/clients/nodejs/monetdb/package.json
--- a/clients/nodejs/monetdb/package.json
+++ b/clients/nodejs/monetdb/package.json
@@ -1,6 +1,6 @@
 {
   "name": "monetdb",
-  "version": "0.2.6",
+  "version": "0.2.7",
   "description": "Connect MonetDB and node.js",
   "main": "mapiclient.js",
   "author": "Hannes Mühleisen <han...@cwi.nl>",
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to