node_modules/waterline-sql-builder/test/unit/sequelizer/sequelizer.where.not.null.test.js

var Sequelizer = require('../../../index')({ dialect: 'postgres' }).sequelizer;
var analyze = require('../../support/analyze');
var assert = require('assert');

describe('Sequelizer ::', function() {
  describe('WHERE NOT NULL statements', function() {
    it('should generate a query with a simple WHERE statement', function() {
      var tree = analyze({
        select: ['*'],
        from: 'users',
        where: {
          updatedAt: {
            not: null
          }
        }
      });

      var result = Sequelizer(tree);
      assert.equal(result.sql, 'select * from "users" where "updatedAt" is not null');
    });

    it('should generate a query with a simple WHERE statement (group clause)', function() {
      var tree = analyze({
        select: ['*'],
        from: 'users',
        where: {
          and: [
            {
              updatedAt: {
                not: null
              }
            }
          ]
        }
      });

      var result = Sequelizer(tree);
      assert.equal(result.sql, 'select * from "users" where "updatedAt" is not null');
    });
  });
});