Postgres JSON type doesn't like buffer values #600

Activity

1. twolfson commented on Jan 9, 2015

   

   twolfson

   on Jan 9, 2015

   Author

   More actions

   I have added the datatype via defineType and it looks like it's working great:

   // Add in the JSON data type (`object` works with binary/string columns)
   // https://github.com/dresende/node-orm2/wiki/Model-Properties#custom-types
   db.defineType('json', {
     datastoreType: function (prop) {
       return 'JSON';
     },
   
     // https://github.com/dresende/node-orm2/blob/v2.1.20/lib/Drivers/DML/postgres.js#L247-L256
     valueToProperty: function (value, prop) {
       if (typeof value !== 'object') {
         try {
           value = JSON.parse(value);
         } catch (err) {
           value = null;
         }
       }
       return value;
     },
   
     // https://github.com/dresende/node-orm2/blob/v2.1.20/lib/Drivers/DML/postgres.js#L317-L321
     propertyToValue: function (value, prop) {
       if (value !== null) {
         value = JSON.stringify(value);
       }
       return value;
     }
   });

   👍React with 👍1Reacted by Oops