sequelize-promises

sequalize-promises-log

Executing (default): INSERT INTO "forum_topic" ("title","id","createdAt","updatedAt") VALUES ('a',DEFAULT,'2014-07-11 08:06:10.130 +00:00','2014-07-11 08:06:10.130 +00:00'),('b',DEFAULT,'2014-07-11 08:06:10.130 +00:00','2014-07-11 08:06:10.130 +00:00'),('c',DEFAULT,'2014-07-11 08:06:10.130 +00:00','2014-07-11 08:06:10.130 +00:00'),('d',DEFAULT,'2014-07-11 08:06:10.130 +00:00','2014-07-11 08:06:10.130 +00:00') RETURNING *;
Executing (default): SELECT * FROM "forum_topic";
[ '{"id":1,"title":"a","createdAt":"2014-07-11T08:06:10.130Z","updatedAt":"2014-07-11T08:06:10.130Z"}',
  '{"id":2,"title":"b","createdAt":"2014-07-11T08:06:10.130Z","updatedAt":"2014-07-11T08:06:10.130Z"}',
  '{"id":3,"title":"c","createdAt":"2014-07-11T08:06:10.130Z","updatedAt":"2014-07-11T08:06:10.130Z"}',
  '{"id":4,"title":"d","createdAt":"2014-07-11T08:06:10.130Z","updatedAt":"2014-07-11T08:06:10.130Z"}' ]
Executing (default): SELECT * FROM "forum_topic" WHERE title <> 'a';
[ '{"id":2,"title":"b","createdAt":"2014-07-11T08:06:10.130Z","updatedAt":"2014-07-11T08:06:10.130Z"}',
  '{"id":3,"title":"c","createdAt":"2014-07-11T08:06:10.130Z","updatedAt":"2014-07-11T08:06:10.130Z"}',
  '{"id":4,"title":"d","createdAt":"2014-07-11T08:06:10.130Z","updatedAt":"2014-07-11T08:06:10.130Z"}' ]
done

sequelize-promises.js

'use strict';

var SEQUELIZE = require('sequelize');
var sequelize = new SEQUELIZE('postgres://test:@localhost:5432/test', { logging  : console.log.bind(console) });
var chainer = new SEQUELIZE.Utils.QueryChainer();

var Topic = sequelize.define('ForumTopic', {
  title : SEQUELIZE.STRING
}, { tableName: 'forum_topic' });

sequelize.sync({force : true})
  .then(function () {
    return Topic.bulkCreate([
      {title: 'a'},
      {title: 'b'},
      {title: 'c'},
      {title: 'd'}
    ]);
  })
  .then(function () {
    return Topic.findAll();
  })
  .then(function (data) {
    console.log(data.map(function (topic) { return JSON.stringify(topic.dataValues); }));
    return sequelize.query('SELECT * FROM "forum_topic" WHERE title <> ?;', null, {raw: true}, ['a']);
  })
  .then(function (data) {
    console.log(data.map(function (topic) { return JSON.stringify(topic); }));
  })
  .error(function (err) {
    console.error(err)
  })
  .done(function () {
    console.log('done');
  });

Gist for sequelize/sequelize#416