hstore-tests.js

'use strict';

var Harness = require('./support');
var customer = Harness.defineCustomerTable();
var Sql = require('../../lib');
var sql = new Sql();
sql.setDialect('postgres');

Harness.test({
  query: customer.update({
    metadata: customer.metadata.concat(sql.functions.HSTORE('age', 20))
  }),
  pg: {
    text  : 'UPDATE "customer" SET "metadata" = ("customer"."metadata" || HSTORE($1, $2))',
    string: 'UPDATE "customer" SET "metadata" = ("customer"."metadata" || HSTORE(\'age\', 20))'
  },
  params: ['age', 20]
});

Harness.test({
  query: customer.select(customer.metadata.key('age')),
  pg: {
    text  : 'SELECT ("customer"."metadata" -> $1) FROM "customer"',
    string: 'SELECT ("customer"."metadata" -> \'age\') FROM "customer"'
  },
  params: ['age']
});