expect(configEnv.gladys.calendar.destroy.args).to.have.deep.members([['calendar-1'], ['calendar-2']]); }); });
it('select function overrides the object', function(){ var serverVersion = '1201000000'; var serverType = 'ORACLE'; var qb = new QueryBuilder(serverType, serverVersion); qb.addSelect("BUS_ID"); qb.addSelect("COMPANY_ID"); qb.select("BRAND_ID"); expect(qb.queryObject.select).to.be.an('array'); expect(qb.queryObject.select).to.have.deep.members(['BRAND_ID']); expect(qb.queryObject.select).to.have.lengthOf(1); });
it('addOrderby function', function(){ var serverVersion = '1201000000'; var serverType = 'ORACLE'; var qb = new QueryBuilder(serverType, serverVersion); qb.orderBy("BUS_ID", "ASC"); qb.addOrderBy("COMPANY_ID", "DESC"); expect(qb.queryObject.orderBy).to.be.an('array'); expect(qb.queryObject.orderBy).to.have.deep.members([ { column : "BUS_ID", direction : "ASC" }, { column : "COMPANY_ID", direction : "DESC" }]); expect(qb.queryObject.orderBy).to.have.lengthOf(2); });
it('left join function', function(){ var serverVersion = '1201000000'; var serverType = 'ORACLE'; var qb = new QueryBuilder(serverType, serverVersion); qb.leftJoin("HQB_TEST_COMPANY", "b", "a.company_id = b.company_id"); expect(qb.queryObject.join).to.be.an('array'); expect(qb.queryObject.join).to.have.deep.members([ { type : "LEFT", tableName : "HQB_TEST_COMPANY", alias : "b", conditions : "a.company_id = b.company_id" }]); expect(qb.queryObject.join).to.have.lengthOf(1); });
it('where function overrides the object', function(){ var serverVersion = '1201000000'; var serverType = 'ORACLE'; var qb = new QueryBuilder(serverType, serverVersion); qb.where("BUS_ID = 101"); qb.andWhere("BRAND_ID = 1"); qb.orWhere("COMPANY_ID = 1"); qb.where("PLATE = 35DP346"); expect(qb.queryObject.where).to.be.an('array'); expect(qb.queryObject.where).to.have.deep.members([ { condition : "AND", filter : "PLATE = 35DP346" } ]); expect(qb.queryObject.where).to.have.lengthOf(1); });
it('groupBy function overrides the object', function(){ var serverVersion = '1201000000'; var serverType = 'ORACLE'; var qb = new QueryBuilder(serverType, serverVersion); qb.groupBy("COMPANY_ID"); qb.addGroupBy("BRAND_ID"); qb.groupBy("BUS_ID"); expect(qb.queryObject.groupBy).to.be.an('array'); expect(qb.queryObject.groupBy).to.have.deep.members([ 'BUS_ID' ]); expect(qb.queryObject.groupBy).to.have.lengthOf(1); });
it('andHaving function', function(){ var serverVersion = '1201000000'; var serverType = 'ORACLE'; var qb = new QueryBuilder(serverType, serverVersion); qb.having("COUNT(BUS_ID) > 1"); qb.andHaving("SUM(COMPANY_ID) < 2"); expect(qb.queryObject.having).to.be.an('array'); expect(qb.queryObject.having).to.have.deep.members([ { condition : "AND", filter : "COUNT(BUS_ID) > 1" }, { condition : "AND", filter : "SUM(COMPANY_ID) < 2" } ]); expect(qb.queryObject.having).to.have.lengthOf(2); });
it('select function with multiple column', function(){ var serverVersion = '1201000000'; var serverType = 'ORACLE'; var qb = new QueryBuilder(serverType, serverVersion); qb.select(["BUS_ID", "COMPANY_ID"]); expect(qb.queryObject.select).to.be.an('array'); expect(qb.queryObject.select).to.have.deep.members(['BUS_ID', 'COMPANY_ID']); expect(qb.queryObject.select).to.have.lengthOf(2); });
it('andWhere function', function(){ var serverVersion = '1201000000'; var serverType = 'ORACLE'; var qb = new QueryBuilder(serverType, serverVersion); qb.where("BUS_ID = 101"); qb.andWhere("COMPANY_ID = 1"); expect(qb.queryObject.where).to.be.an('array'); expect(qb.queryObject.where).to.have.deep.members([ { condition : "AND", filter : "BUS_ID = 101" }, { condition : "AND", filter : "COMPANY_ID = 1" } ]); expect(qb.queryObject.where).to.have.lengthOf(2); });
it('orderby function', function(){ var serverVersion = '1201000000'; var serverType = 'ORACLE'; var qb = new QueryBuilder(serverType, serverVersion); qb.orderBy("BUS_ID", "ASC"); expect(qb.queryObject.orderBy).to.be.an('array'); expect(qb.queryObject.orderBy).to.have.deep.members([ { column : "BUS_ID", direction : "ASC" } ]); expect(qb.queryObject.orderBy).to.have.lengthOf(1); });
it('addselect function', function(){ var serverVersion = '1201000000'; var serverType = 'ORACLE'; var qb = new QueryBuilder(serverType, serverVersion); qb.addSelect("BUS_ID"); qb.addSelect("COMPANY_ID"); expect(qb.queryObject.select).to.be.an('array'); expect(qb.queryObject.select).to.have.deep.members(['BUS_ID', 'COMPANY_ID']); expect(qb.queryObject.select).to.have.lengthOf(2); });
it('having function', function(){ var serverVersion = '1201000000'; var serverType = 'ORACLE'; var qb = new QueryBuilder(serverType, serverVersion); qb.having("COUNT(BUS_ID) > 1"); expect(qb.queryObject.having).to.be.an('array'); expect(qb.queryObject.having).to.have.deep.members([ { condition : "AND", filter : "COUNT(BUS_ID) > 1" } ]); expect(qb.queryObject.having).to.have.lengthOf(1); });
it('addGroupBy function', function(){ var serverVersion = '1201000000'; var serverType = 'ORACLE'; var qb = new QueryBuilder(serverType, serverVersion); qb.groupBy("COMPANY_ID"); qb.addGroupBy("BRAND_ID"); expect(qb.queryObject.groupBy).to.be.an('array'); expect(qb.queryObject.groupBy).to.have.deep.members([ 'COMPANY_ID', 'BRAND_ID' ]); expect(qb.queryObject.groupBy).to.have.lengthOf(2); });
it('where function with string parameter', function(){ var serverVersion = '1201000000'; var serverType = 'ORACLE'; var qb = new QueryBuilder(serverType, serverVersion); qb.where("BUS_ID = 101"); expect(qb.queryObject.where).to.be.an('array'); expect(qb.queryObject.where).to.have.deep.members([ { condition : "AND", filter : "BUS_ID = 101" } ]); expect(qb.queryObject.where).to.have.lengthOf(1); });
it('join function', function(){ var serverVersion = '1201000000'; var serverType = 'ORACLE'; var qb = new QueryBuilder(serverType, serverVersion); qb.join("HQB_TEST_COMPANY", "b", "a.company_id = b.company_id"); expect(qb.queryObject.join).to.be.an('array'); expect(qb.queryObject.join).to.have.deep.members([ { type : "INNER", tableName : "HQB_TEST_COMPANY", alias : "b", conditions : "a.company_id = b.company_id" }]); expect(qb.queryObject.join).to.have.lengthOf(1); });