ParseQueryTest.js

'use strict';

const assert = require('assert');
const Parse = require('../../node');

describe('Parse Query', () => {
  beforeEach(async () => {
    const numbers = [];
    for (let i = 0; i < 10; i++) {
      numbers[i] = new Parse.Object({
        className: 'BoxedNumber',
        number: i,
      });
    }
    await Parse.Object.saveAll(numbers);
  });

  it('can do basic queries', done => {
    const baz = new TestObject({ foo: 'baz' });
    const qux = new TestObject({ foo: 'qux' });
    Parse.Object.saveAll([baz, qux])
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.equalTo('foo', 'baz');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        assert.equal(results[0].get('foo'), 'baz');
        done();
      });
  });

  it('can do a query with a limit', done => {
    const baz = new TestObject({ foo: 'baz' });
    const qux = new TestObject({ foo: 'qux' });
    Parse.Object.saveAll([baz, qux])
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.limit(1);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        assert.equal(['baz', 'qux'].includes(results[0].get('foo')), true);
        done();
      })
      .catch(done.fail);
  });

  it('can return raw json from queries', async () => {
    const object = new TestObject({ foo: 'bar' });
    await object.save();

    const query = new Parse.Query(TestObject);
    const results = await query.find({ json: true });
    assert.strictEqual(results[0] instanceof Parse.Object, false);
    assert.strictEqual(results[0].foo, 'bar');
    assert.strictEqual(results[0].className, 'TestObject');
    assert.strictEqual(results[0].objectId, object.id);

    let result = await query.first({ json: true });
    assert.strictEqual(result instanceof Parse.Object, false);
    assert.strictEqual(result.foo, 'bar');
    assert.strictEqual(result.className, 'TestObject');
    assert.strictEqual(result.objectId, object.id);

    result = await query.get(object.id, { json: true });
    assert.strictEqual(result instanceof Parse.Object, false);
    assert.strictEqual(result.foo, 'bar');
    assert.strictEqual(result.className, 'TestObject');
    assert.strictEqual(result.objectId, object.id);

    await query.each(
      obj => {
        assert.strictEqual(obj instanceof Parse.Object, false);
        assert.strictEqual(obj.foo, 'bar');
        assert.strictEqual(obj.className, 'TestObject');
        assert.strictEqual(obj.objectId, object.id);
      },
      { json: true }
    );
  });

  it('can do query with count', async () => {
    const items = [];
    for (let i = 0; i < 4; i++) {
      items.push(new TestObject({ countMe: true }));
    }
    await Parse.Object.saveAll(items);

    const query = new Parse.Query(TestObject);
    query.withCount(true);
    const { results, count } = await query.find();

    assert(typeof count === 'number');
    assert.equal(results.length, 4);
    assert.equal(count, 4);
    for (let i = 0; i < 4; i++) {
      assert.equal(results[i].className, 'TestObject');
    }
  });

  it('can do query withCount set to false', async () => {
    const items = [];
    for (let i = 0; i < 4; i++) {
      items.push(new TestObject({ countMe: true }));
    }
    await Parse.Object.saveAll(items);

    const query = new Parse.Query(TestObject);
    query.withCount(false);
    const results = await query.find();

    assert.equal(results.length, 4);
    for (let i = 0; i < 4; i++) {
      assert.equal(results[i].className, 'TestObject');
    }
  });

  it('can do query with count on empty collection', async () => {
    const query = new Parse.Query(TestObject);
    query.withCount(true);
    const { results, count } = await query.find();

    assert(typeof count == 'number');
    assert.equal(results.length, 0);
    assert.equal(count, 0);
  });

  it('can do query with count and limit', async () => {
    const items = [];
    for (let i = 0; i < 4; i++) {
      items.push(new TestObject({ countMe: 2 }));
    }
    await Parse.Object.saveAll(items);
    const query = new Parse.Query(TestObject);
    query.withCount(true);
    query.limit(2);

    const { results, count } = await query.find();

    assert(typeof count == 'number');
    assert.equal(results.length, 2);
    assert.equal(count, 4);
  });

  it('can do query withCount and skip', async () => {
    const items = [];
    for (let i = 0; i < 4; i++) {
      items.push(new TestObject({ countMe: 2 }));
    }
    await Parse.Object.saveAll(items);
    const query = new Parse.Query(TestObject);
    query.withCount(true);
    query.skip(3);

    const { results, count } = await query.find();

    assert(typeof count == 'number');
    assert.equal(results.length, 1);
    assert.equal(count, 4);
  });

  it('can do query when withCount set without arguments', async () => {
    const items = [];
    for (let i = 0; i < 4; i++) {
      items.push(new TestObject({ countMe: 2 }));
    }
    await Parse.Object.saveAll(items);
    const query = new Parse.Query(TestObject);
    query.withCount();

    const { results, count } = await query.find();

    assert(typeof count == 'number');
    assert.equal(results.length, 4);
    assert.equal(count, 4);
  });

  it('can do query when withCount undefined', async () => {
    const items = [];
    for (let i = 0; i < 4; i++) {
      items.push(new TestObject({ countMe: 2 }));
    }
    await Parse.Object.saveAll(items);
    const query = new Parse.Query(TestObject);
    let foo;
    query.withCount(foo);

    const { results, count } = await query.find();

    assert(typeof count == 'number');
    assert.equal(results.length, 4);
    assert.equal(count, 4);
  });

  it('can do containedIn queries with arrays', done => {
    const messageList = [];
    for (let i = 0; i < 4; i++) {
      const message = new Parse.Object('Message');
      if (i > 0) {
        message.set('prior', messageList[i - 1]);
      }
      messageList.push(message);
    }

    Parse.Object.saveAll(messageList)
      .then(() => {
        assert.equal(messageList.length, 4);

        const inList = [];
        inList.push(messageList[0]);
        inList.push(messageList[2]);

        const query = new Parse.Query('Message');
        query.containedIn('prior', inList);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 2);
        done();
      });
  });

  it('can do containsAll queries with numbers', done => {
    const NumberSet = Parse.Object.extend('NumberSet');
    const objectsList = [];
    objectsList.push(new NumberSet({ numbers: [1, 2, 3, 4, 5] }));
    objectsList.push(new NumberSet({ numbers: [1, 3, 4, 5] }));
    Parse.Object.saveAll(objectsList)
      .then(() => {
        const query = new Parse.Query(NumberSet);
        query.containsAll('numbers', [1, 2, 3]);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        done();
      });
  });

  it('can do containsAll queries with strings', done => {
    const StringSet = Parse.Object.extend('StringSet');
    const objectsList = [];
    objectsList.push(new StringSet({ strings: ['a', 'b', 'c', 'd', 'e'] }));
    objectsList.push(new StringSet({ strings: ['a', 'c', 'd'] }));
    Parse.Object.saveAll(objectsList)
      .then(() => {
        const query = new Parse.Query(StringSet);
        query.containsAll('strings', ['a', 'b', 'c']);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        done();
      });
  });

  it('can do containsAll queries with dates', done => {
    const DateSet = Parse.Object.extend('DateSet');

    function parseDate(iso) {
      const regexp = new RegExp(
        '^([0-9]{1,4})-([0-9]{1,2})-([0-9]{1,2})' +
          'T' +
          '([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})' +
          '(.([0-9]+))?' +
          'Z$'
      );
      const match = regexp.exec(iso);
      if (!match) {
        return null;
      }

      const year = match[1] || 0;
      const month = (match[2] || 1) - 1;
      const day = match[3] || 0;
      const hour = match[4] || 0;
      const minute = match[5] || 0;
      const second = match[6] || 0;
      const milli = match[8] || 0;

      return new Date(Date.UTC(year, month, day, hour, minute, second, milli));
    }

    function makeDates(stringArray) {
      return stringArray.map(date => {
        return parseDate(date + 'T00:00:00Z');
      });
    }

    const objectsList = [];
    objectsList.push(
      new DateSet({
        dates: makeDates(['2013-02-01', '2013-02-02', '2013-02-03']),
      })
    );
    objectsList.push(
      new DateSet({
        dates: makeDates(['2013-02-01', '2013-02-03', '2013-02-04']),
      })
    );

    Parse.Object.saveAll(objectsList)
      .then(() => {
        const query = new Parse.Query(DateSet);
        query.containsAll('dates', makeDates(['2013-02-01', '2013-02-02', '2013-02-03']));
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        done();
      })
      .catch(e => console.log(e));
  });

  it('can do containsAll queries with objects', done => {
    const MessageSet = Parse.Object.extend('MessageSet');

    const messageList = [];
    for (let i = 0; i < 4; i++) {
      messageList.push(new TestObject({ i: i }));
    }

    Parse.Object.saveAll(messageList)
      .then(() => {
        assert.equal(messageList.length, 4);

        const messageSetList = [];
        messageSetList.push(new MessageSet({ messages: messageList }));

        const someList = [];
        someList.push(messageList[0]);
        someList.push(messageList[1]);
        someList.push(messageList[3]);
        messageSetList.push(new MessageSet({ messages: someList }));

        return Parse.Object.saveAll(messageSetList);
      })
      .then(() => {
        const inList = [];
        inList.push(messageList[0]);
        inList.push(messageList[2]);

        const query = new Parse.Query(MessageSet);
        query.containsAll('messages', inList);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        done();
      });
  });

  it('can do containedBy queries with numbers', async () => {
    const NumberSet = Parse.Object.extend('NumberSet');
    const objectsList = [];
    objectsList.push(new NumberSet({ numbers: [0, 1, 2] }));
    objectsList.push(new NumberSet({ numbers: [2, 0] }));
    objectsList.push(new NumberSet({ numbers: [1, 2, 3, 4] }));

    await Parse.Object.saveAll(objectsList);

    const query = new Parse.Query(NumberSet);
    query.containedBy('numbers', [1, 2, 3, 4, 5]);
    const results = await query.find();
    assert.equal(results.length, 1);
  });

  it('can do containedBy queries with pointer', async () => {
    const objects = Array.from(Array(10).keys()).map(idx => {
      const obj = new Parse.Object('Object');
      obj.set('key', idx);
      return obj;
    });

    const parent1 = new Parse.Object('Parent');
    const parent2 = new Parse.Object('Parent');
    const parent3 = new Parse.Object('Parent');

    await Parse.Object.saveAll(objects);

    // [0, 1, 2]
    parent1.set('objects', objects.slice(0, 3));

    const shift = objects.shift();
    // [2, 0]
    parent2.set('objects', [objects[1], shift]);

    // [1, 2, 3, 4]
    parent3.set('objects', objects.slice(1, 4));

    await Parse.Object.saveAll([parent1, parent2, parent3]);
    const query = new Parse.Query('Parent');
    query.containedBy('objects', objects);
    const results = await query.find();

    assert.equal(results.length, 1);
    assert.equal(results[0].id, parent3.id);
  });

  it('can do equalTo queries', done => {
    const query = new Parse.Query('BoxedNumber');
    query.equalTo('number', 3);
    query.find().then(results => {
      assert.equal(results.length, 1);
      done();
    });
  });

  it('can do equalTo queries with object', done => {
    const query = new Parse.Query('BoxedNumber');
    query.equalTo({ number: 3 });
    query.find().then(results => {
      assert.equal(results.length, 1);
      done();
    });
  });

  it('can test equality with undefined', done => {
    const query = new Parse.Query('BoxedNumber');
    query.equalTo('number', undefined);
    query.find().then(results => {
      assert.equal(results.length, 0);
      done();
    });
  });

  it('can perform lessThan queries', done => {
    const query = new Parse.Query('BoxedNumber');
    query.lessThan('number', 7);
    query.find().then(results => {
      assert.equal(results.length, 7);
      done();
    });
  });

  it('can perform lessThanOrEqualTo queries', done => {
    const query = new Parse.Query('BoxedNumber');
    query.lessThanOrEqualTo('number', 7);
    query.find().then(results => {
      assert.equal(results.length, 8);
      done();
    });
  });

  it('can perform greaterThan queries', done => {
    const query = new Parse.Query('BoxedNumber');
    query.greaterThan('number', 7);
    query.find().then(results => {
      assert.equal(results.length, 2);
      done();
    });
  });

  it('can perform greaterThanOrEqualTo queries', done => {
    const query = new Parse.Query('BoxedNumber');
    query.greaterThanOrEqualTo('number', 7);
    query.find().then(results => {
      assert.equal(results.length, 3);
      done();
    });
  });

  it('can combine lessThanOrEqualTo and greaterThanOrEqualTo queries', done => {
    const query = new Parse.Query('BoxedNumber');
    query.lessThanOrEqualTo('number', 7);
    query.greaterThanOrEqualTo('number', 7);
    query.find().then(results => {
      assert.equal(results.length, 1);
      done();
    });
  });

  it('can combine lessThan and greaterThan queries', done => {
    const query = new Parse.Query('BoxedNumber');
    query.lessThan('number', 9);
    query.greaterThan('number', 3);
    query.find().then(results => {
      assert.equal(results.length, 5);
      done();
    });
  });

  it('can perform notEqualTo queries', done => {
    const query = new Parse.Query('BoxedNumber');
    query.notEqualTo('number', 5);
    query.find().then(results => {
      assert.equal(results.length, 9);
      done();
    });
  });

  it('can perform notEqualTo queries with object', done => {
    const query = new Parse.Query('BoxedNumber');
    query.notEqualTo({ number: 5 });
    query.find().then(results => {
      assert.equal(results.length, 9);
      done();
    });
  });

  it('can perform containedIn queries', done => {
    const query = new Parse.Query('BoxedNumber');
    query.containedIn('number', [3, 5, 7, 9, 11]);
    query.find().then(results => {
      assert.equal(results.length, 4);
      done();
    });
  });

  it('can perform notContainedIn queries', done => {
    const query = new Parse.Query('BoxedNumber');
    query.notContainedIn('number', [3, 5, 7, 9, 11]);
    query.find().then(results => {
      assert.equal(results.length, 6);
      done();
    });
  });

  it('can test objectId in containedIn queries', done => {
    new Parse.Query('BoxedNumber')
      .ascending('number')
      .find()
      .then(numbers => {
        const ids = [numbers[2].id, numbers[3].id, 'nonsense'];
        const query = new Parse.Query('BoxedNumber');
        query.containedIn('objectId', ids);
        query.ascending('number');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 2);
        assert.equal(results[0].get('number'), 2);
        assert.equal(results[1].get('number'), 3);
        done();
      });
  });

  it('can test objectId in equalTo queries', done => {
    new Parse.Query('BoxedNumber')
      .ascending('number')
      .find()
      .then(numbers => {
        const id = numbers[5].id;
        const query = new Parse.Query('BoxedNumber');
        query.equalTo('objectId', id);
        query.ascending('number');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        assert.equal(results[0].get('number'), 5);
        done();
      });
  });

  it('can find no elements', done => {
    const query = new Parse.Query('BoxedNumber');
    query.equalTo('number', 15);
    query.find().then(results => {
      assert.equal(results.length, 0);
      done();
    });
  });

  it('handles when find throws errors', done => {
    const query = new Parse.Query('BoxedNumber');
    query.equalTo('$foo', 'bar');
    query.find().catch(e => {
      assert.equal(e.code, Parse.Error.INVALID_KEY_NAME);
      done();
    });
  });

  it('can get by objectId', done => {
    const object = new TestObject();
    object
      .save()
      .then(() => {
        const query = new Parse.Query(TestObject);
        return query.get(object.id);
      })
      .then(result => {
        assert.equal(result.id, object.id);
        assert(result.createdAt);
        assert(result.updatedAt);
        done();
      });
  });

  it('handles get with undefined id', done => {
    const object = new TestObject();
    object
      .save()
      .then(() => {
        const query = new Parse.Query(TestObject);
        return query.get(undefined);
      })
      .catch(e => {
        assert.equal(e.code, Parse.Error.OBJECT_NOT_FOUND);
        done();
      });
  });

  it('handles get with invalid id', done => {
    const object = new TestObject();
    object
      .save()
      .then(() => {
        const query = new Parse.Query(TestObject);
        return query.get(undefined);
      })
      .catch(e => {
        assert.equal(e.code, Parse.Error.OBJECT_NOT_FOUND);
        done();
      });
  });

  it('can query for the first result', done => {
    const query = new Parse.Query('BoxedNumber');
    query.ascending('number');
    query.first().then(result => {
      assert.equal(result.get('number'), 0);
      done();
    });
  });

  it('can query for the first with no results', done => {
    const query = new Parse.Query('BoxedNumber');
    query.equalTo('number', 20);
    query.first().then(result => {
      assert.equal(result, undefined);
      done();
    });
  });

  it('can query for the first with two results', done => {
    Parse.Object.saveAll([new TestObject({ x: 44 }), new TestObject({ x: 44 })])
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.equalTo('x', 44);
        return query.first();
      })
      .then(result => {
        assert.equal(result.get('x'), 44);
        done();
      });
  });

  it('handles when first throws errors', done => {
    const query = new Parse.Query('BoxedNumber');
    query.equalTo('$foo', 'bar');
    query.first().catch(e => {
      assert.equal(e.code, Parse.Error.INVALID_KEY_NAME);
      done();
    });
  });

  it('can test object inequality', done => {
    const item1 = new TestObject();
    const item2 = new TestObject();
    const container1 = new Parse.Object({
      className: 'CoolContainer',
      item: item1,
    });
    const container2 = new Parse.Object({
      className: 'CoolContainer',
      item: item2,
    });
    Parse.Object.saveAll([item1, item2, container1, container2])
      .then(() => {
        const query = new Parse.Query('CoolContainer');
        query.notEqualTo('item', item1);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        done();
      });
  });

  it('can skip', done => {
    Parse.Object.saveAll([
      new TestObject({ canSkip: true }),
      new TestObject({ canSkip: true }),
      new TestObject({ canSkip: true }),
    ])
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.equalTo('canSkip', true);
        query.skip(1);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 2);
        const query = new Parse.Query(TestObject);
        query.equalTo('canSkip', true);
        query.skip(3);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 0);
        done();
      });
  });

  it('does not consider skip in count queries', done => {
    Parse.Object.saveAll([
      new TestObject({ skipCount: true }),
      new TestObject({ skipCount: true }),
      new TestObject({ skipCount: true }),
    ])
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.equalTo('skipCount', true);
        return query.count();
      })
      .then(count => {
        assert.equal(count, 3);
        const query = new Parse.Query(TestObject);
        query.equalTo('skipCount', true);
        query.skip(1);
        return query.count();
      })
      .then(count => {
        assert.equal(count, 3);
        const query = new Parse.Query(TestObject);
        query.equalTo('skipCount', true);
        query.skip(2);
        return query.count();
      })
      .then(count => {
        assert.equal(count, 3);
        done();
      });
  });

  it('can perform count queries', done => {
    const query = new Parse.Query('BoxedNumber');
    query.greaterThan('number', 1);
    query.count().then(count => {
      assert.equal(count, 8);
      done();
    });
  });

  it('can order by ascending numbers', done => {
    const query = new Parse.Query('BoxedNumber');
    query.ascending('number');
    query.find().then(results => {
      assert.equal(results[0].get('number'), 0);
      assert.equal(results[9].get('number'), 9);
      done();
    });
  });

  it('can order by descending numbers', done => {
    const query = new Parse.Query('BoxedNumber');
    query.descending('number');
    query.find().then(results => {
      assert.equal(results[0].get('number'), 9);
      assert.equal(results[9].get('number'), 0);
      done();
    });
  });

  it('can order by asecending number then descending string', done => {
    Parse.Object.saveAll([
      new TestObject({ doubleOrder: true, number: 3, string: 'a' }),
      new TestObject({ doubleOrder: true, number: 1, string: 'b' }),
      new TestObject({ doubleOrder: true, number: 3, string: 'c' }),
      new TestObject({ doubleOrder: true, number: 2, string: 'd' }),
    ])
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.equalTo('doubleOrder', true);
        query.ascending('number').addDescending('string');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 4);
        assert.equal(results[0].get('number'), 1);
        assert.equal(results[0].get('string'), 'b');
        assert.equal(results[1].get('number'), 2);
        assert.equal(results[1].get('string'), 'd');
        assert.equal(results[2].get('number'), 3);
        assert.equal(results[2].get('string'), 'c');
        assert.equal(results[3].get('number'), 3);
        assert.equal(results[3].get('string'), 'a');
        done();
      });
  });

  it('can order by descending number then ascending string', done => {
    Parse.Object.saveAll([
      new TestObject({ otherDoubleOrder: true, number: 3, string: 'a' }),
      new TestObject({ otherDoubleOrder: true, number: 1, string: 'b' }),
      new TestObject({ otherDoubleOrder: true, number: 3, string: 'c' }),
      new TestObject({ otherDoubleOrder: true, number: 2, string: 'd' }),
    ])
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.equalTo('otherDoubleOrder', true);
        query.descending('number').addAscending('string');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 4);
        assert.equal(results[0].get('number'), 3);
        assert.equal(results[0].get('string'), 'a');
        assert.equal(results[1].get('number'), 3);
        assert.equal(results[1].get('string'), 'c');
        assert.equal(results[2].get('number'), 2);
        assert.equal(results[2].get('string'), 'd');
        assert.equal(results[3].get('number'), 1);
        assert.equal(results[3].get('string'), 'b');
        done();
      });
  });

  it('can order by descending number and string', done => {
    Parse.Object.saveAll([
      new TestObject({ doubleDescending: true, number: 3, string: 'a' }),
      new TestObject({ doubleDescending: true, number: 1, string: 'b' }),
      new TestObject({ doubleDescending: true, number: 3, string: 'c' }),
      new TestObject({ doubleDescending: true, number: 2, string: 'd' }),
    ])
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.equalTo('doubleDescending', true);
        query.descending('number,string');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 4);
        assert.equal(results[0].get('number'), 3);
        assert.equal(results[0].get('string'), 'c');
        assert.equal(results[1].get('number'), 3);
        assert.equal(results[1].get('string'), 'a');
        assert.equal(results[2].get('number'), 2);
        assert.equal(results[2].get('string'), 'd');
        assert.equal(results[3].get('number'), 1);
        assert.equal(results[3].get('string'), 'b');

        const query = new Parse.Query(TestObject);
        query.equalTo('doubleDescending', true);
        query.descending('number, string');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 4);
        assert.equal(results[0].get('number'), 3);
        assert.equal(results[0].get('string'), 'c');
        assert.equal(results[1].get('number'), 3);
        assert.equal(results[1].get('string'), 'a');
        assert.equal(results[2].get('number'), 2);
        assert.equal(results[2].get('string'), 'd');
        assert.equal(results[3].get('number'), 1);
        assert.equal(results[3].get('string'), 'b');

        const query = new Parse.Query(TestObject);
        query.equalTo('doubleDescending', true);
        query.descending(['number', 'string']);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 4);
        assert.equal(results[0].get('number'), 3);
        assert.equal(results[0].get('string'), 'c');
        assert.equal(results[1].get('number'), 3);
        assert.equal(results[1].get('string'), 'a');
        assert.equal(results[2].get('number'), 2);
        assert.equal(results[2].get('string'), 'd');
        assert.equal(results[3].get('number'), 1);
        assert.equal(results[3].get('string'), 'b');

        const query = new Parse.Query(TestObject);
        query.equalTo('doubleDescending', true);
        query.descending('number', 'string');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 4);
        assert.equal(results[0].get('number'), 3);
        assert.equal(results[0].get('string'), 'c');
        assert.equal(results[1].get('number'), 3);
        assert.equal(results[1].get('string'), 'a');
        assert.equal(results[2].get('number'), 2);
        assert.equal(results[2].get('string'), 'd');
        assert.equal(results[3].get('number'), 1);
        assert.equal(results[3].get('string'), 'b');

        done();
      });
  });

  it('can not order by password', done => {
    const query = new Parse.Query('BoxedNumber');
    query.ascending('_password');
    query.find().catch(e => {
      assert.equal(e.code, Parse.Error.INVALID_KEY_NAME);
      done();
    });
  });

  it('can order by _created_at', done => {
    new Parse.Object({ className: 'TestObject', orderedDate: true })
      .save()
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          orderedDate: true,
        }).save();
      })
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          orderedDate: true,
        }).save();
      })
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          orderedDate: true,
        }).save();
      })
      .then(() => {
        const query = new Parse.Query('TestObject');
        query.equalTo('orderedDate', true);
        query.ascending('_created_at');
        return query.find();
      })
      .then(results => {
        assert(results[0].createdAt < results[1].createdAt);
        assert(results[1].createdAt < results[2].createdAt);
        assert(results[2].createdAt < results[3].createdAt);
        done();
      });
  });

  it('can order by createdAt', done => {
    new Parse.Object({ className: 'TestObject', orderedDate2: true })
      .save()
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          orderedDate2: true,
        }).save();
      })
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          orderedDate2: true,
        }).save();
      })
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          orderedDate2: true,
        }).save();
      })
      .then(() => {
        const query = new Parse.Query('TestObject');
        query.equalTo('orderedDate2', true);
        query.descending('createdAt');
        return query.find();
      })
      .then(results => {
        assert(results[0].createdAt > results[1].createdAt);
        assert(results[1].createdAt > results[2].createdAt);
        assert(results[2].createdAt > results[3].createdAt);
        done();
      });
  });

  it('can order by _updated_at', done => {
    new Parse.Object({ className: 'TestObject', orderedDate3: true })
      .save()
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          orderedDate3: true,
        }).save();
      })
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          orderedDate3: true,
        }).save();
      })
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          orderedDate3: true,
        }).save();
      })
      .then(() => {
        const query = new Parse.Query('TestObject');
        query.equalTo('orderedDate3', true);
        query.ascending('_updated_at');
        return query.find();
      })
      .then(results => {
        assert(results[0].updatedAt < results[1].updatedAt);
        assert(results[1].updatedAt < results[2].updatedAt);
        assert(results[2].updatedAt < results[3].updatedAt);
        done();
      });
  });

  it('can order by updatedAt', done => {
    new Parse.Object({ className: 'TestObject', orderedDate4: true })
      .save()
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          orderedDate4: true,
        }).save();
      })
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          orderedDate4: true,
        }).save();
      })
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          orderedDate4: true,
        }).save();
      })
      .then(() => {
        const query = new Parse.Query('TestObject');
        query.equalTo('orderedDate4', true);
        query.descending('updatedAt');
        return query.find();
      })
      .then(results => {
        assert(results[0].updatedAt > results[1].updatedAt);
        assert(results[1].updatedAt > results[2].updatedAt);
        assert(results[2].updatedAt > results[3].updatedAt);
        done();
      });
  });

  it('can test time equality', done => {
    new Parse.Object({ className: 'TestObject', timed: true, name: 'item1' })
      .save()
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          timed: true,
          name: 'item2',
        }).save();
      })
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          timed: true,
          name: 'item3',
        }).save();
      })
      .then(() => {
        return new Parse.Object({
          className: 'TestObject',
          timed: true,
          name: 'item4',
        }).save();
      })
      .then(last => {
        const query = new Parse.Query('TestObject');
        query.equalTo('timed', true);
        query.equalTo('createdAt', last.createdAt);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        assert.equal(results[0].get('name'), 'item4');
        done();
      });
  });

  it('can test time inequality', done => {
    const objects = [
      new Parse.Object({
        className: 'TestObject',
        timed2: true,
        name: 'item1',
      }),
      new Parse.Object({
        className: 'TestObject',
        timed2: true,
        name: 'item2',
      }),
      new Parse.Object({
        className: 'TestObject',
        timed2: true,
        name: 'item3',
      }),
      new Parse.Object({
        className: 'TestObject',
        timed2: true,
        name: 'item4',
      }),
    ];

    objects[0]
      .save()
      .then(() => {
        return objects[1].save();
      })
      .then(() => {
        return objects[2].save();
      })
      .then(() => {
        return objects[3].save();
      })
      .then(() => {
        const query = new Parse.Query('TestObject');
        query.equalTo('timed2', true);
        query.lessThan('createdAt', objects[2].createdAt);
        query.ascending('createdAt');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 2);
        assert.equal(results[0].id, objects[0].id);
        assert.equal(results[1].id, objects[1].id);

        const query = new Parse.Query('TestObject');
        query.equalTo('timed2', true);
        query.greaterThan('createdAt', objects[2].createdAt);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        assert.equal(results[0].id, objects[3].id);
        done();
      })
      .catch(done.fail);
  });

  it('can test string matching', done => {
    const obj1 = new TestObject();
    obj1.set('myString', 'football');
    const obj2 = new TestObject();
    obj2.set('myString', 'soccer');
    Parse.Object.saveAll([obj1, obj2])
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.matches('myString', '^fo*\\wb[^o]l+$');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        assert.equal(results[0].get('myString'), 'football');

        const query = new Parse.Query(TestObject);
        query.matches('myString', /^fo*\wb[^o]l+$/);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        assert.equal(results[0].get('myString'), 'football');
        done();
      });
  });

  it('can test case insensitive matches', done => {
    const obj = new TestObject();
    obj.set('myString', 'hockey');
    obj
      .save()
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.matches('myString', 'Hockey', 'i');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        assert.equal(results[0].get('myString'), 'hockey');
        done();
      });
  });

  it('can test case insensitive startsWith', async () => {
    const obj = new TestObject();
    obj.set('myString', 'basketball');
    await obj.save();

    const query = new Parse.Query(TestObject);
    query.startsWith('myString', 'baSKet', 'i');
    const results = await query.find();

    assert.strictEqual(results.length, 1);
    assert.strictEqual(results[0].get('myString'), 'basketball');
  });

  it('can test case insensitive endsWith', async () => {
    const obj = new TestObject();
    obj.set('myString', 'basketball');
    await obj.save();

    const query = new Parse.Query(TestObject);
    query.endsWith('myString', 'tBAll', 'i');
    const results = await query.find();

    assert.strictEqual(results.length, 1);
    assert.strictEqual(results[0].get('myString'), 'basketball');
  });

  it('fails for invalid regex options', done => {
    const query = new Parse.Query(TestObject);
    query.matches('myString', 'football', 'some invalid thing');
    query.find().catch(e => {
      assert.equal(e.code, Parse.Error.INVALID_QUERY);
      done();
    });
  });

  it('can use a regex with all modifiers', done => {
    const obj = new TestObject();
    obj.set('website', 'PArSe\nCom');
    obj
      .save()
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.matches(
          'website',
          "parse # First fragment. We'll write this in one case but match " +
            'insensitively\n.com  # Second fragment. This can be separated by any ' +
            'character, including newline\n',
          'mixs'
        );
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        done();
      });
  });

  it('can include regexp modifiers in the constructor', done => {
    const obj = new TestObject();
    obj.set('website', '\n\nbuffer\n\nparse.COM');
    obj
      .save()
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.matches('website', /parse\.com/im);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        done();
      });
  });

  it('can test contains', done => {
    const someAscii =
      "\\E' !\"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTU" +
      "VWXYZ[\\]^_`abcdefghijklmnopqrstuvwxyz{|}~'";
    Parse.Object.saveAll([
      new TestObject({ contains: true, myString: 'zax' + someAscii + 'qub' }),
      new TestObject({ contains: true, myString: 'start' + someAscii }),
      new TestObject({ contains: true, myString: someAscii + 'end' }),
      new TestObject({ contains: true, myString: someAscii }),
    ])
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.equalTo('contains', true);
        query.startsWith('myString', someAscii);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 2);
        const query = new Parse.Query(TestObject);
        query.equalTo('contains', true);
        query.startsWith('myString', someAscii);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 2);
        done();
      });
  });

  it('can test if a key exists', done => {
    const objects = [];
    for (let i = 0; i < 10; i++) {
      const item = new TestObject();
      if (i % 2) {
        item.set('y', i + 1);
      } else {
        item.set('z', i + 1);
      }
      objects.push(item);
    }
    Parse.Object.saveAll(objects)
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.exists('y');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 5);
        for (let i = 0; i < results.length; i++) {
          assert(results[i].has('y'));
        }
        done();
      })
      .catch(e => console.log(e));
  });

  it('can test if a key does not exist', done => {
    const objects = [];
    for (let i = 0; i < 10; i++) {
      const item = new TestObject({ dne: true });
      if (i % 2) {
        item.set('y', i + 1);
      } else {
        item.set('z', i + 1);
      }
      objects.push(item);
    }
    Parse.Object.saveAll(objects)
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.equalTo('dne', true);
        query.doesNotExist('y');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 5);
        for (let i = 0; i < results.length; i++) {
          assert(results[i].has('z'));
        }
        done();
      });
  });

  it('can test if a relation exists', done => {
    const objects = [];
    for (let i = 0; i < 10; i++) {
      const container = new Parse.Object('Container', {
        relation_exists: true,
      });
      if (i % 2) {
        container.set('y', i);
      } else {
        const item = new TestObject();
        item.set('x', i);
        container.set('x', item);
        objects.push(item);
      }
      objects.push(container);
    }
    Parse.Object.saveAll(objects)
      .then(() => {
        const query = new Parse.Query('Container');
        query.equalTo('relation_exists', true);
        query.exists('x');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 5);
        for (let i = 0; i < results.length; i++) {
          assert(results[i].has('x'));
        }
        done();
      });
  });

  it('can test if a relation does not exist', done => {
    const objects = [];
    for (let i = 0; i < 10; i++) {
      const container = new Parse.Object('Container', { relation_dne: true });
      if (i % 2) {
        container.set('y', i);
      } else {
        const item = new TestObject();
        item.set('x', i);
        container.set('x', item);
        objects.push(item);
      }
      objects.push(container);
    }
    Parse.Object.saveAll(objects)
      .then(() => {
        const query = new Parse.Query('Container');
        query.equalTo('relation_dne', true);
        query.doesNotExist('x');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 5);
        for (let i = 0; i < results.length; i++) {
          assert(results[i].has('y'));
        }
        done();
      });
  });

  it('does not include by default', done => {
    const child = new TestObject();
    const parent = new Parse.Object('Container');
    child.set('foo', 'bar');
    parent.set('child', child);
    Parse.Object.saveAll([child, parent])
      .then(() => {
        const query = new Parse.Query('Container');
        query.equalTo('objectId', parent.id);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        const parentAgain = results[0];
        assert(parentAgain.get('child'));
        assert(parentAgain.get('child').id);
        assert(!parentAgain.get('child').get('foo'));
        done();
      })
      .catch(e => console.log(e));
  });

  it('can include nested objects', done => {
    const child = new TestObject();
    const parent = new Parse.Object('Container');
    child.set('foo', 'bar');
    parent.set('child', child);
    Parse.Object.saveAll([child, parent])
      .then(() => {
        const query = new Parse.Query('Container');
        query.equalTo('objectId', parent.id);
        query.include('child');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        const parentAgain = results[0];
        assert(parentAgain.get('child'));
        assert(parentAgain.get('child').id);
        assert.equal(parentAgain.get('child').get('foo'), 'bar');
        done();
      });
  });

  it('can includeAll nested objects', async () => {
    const child1 = new TestObject({ foo: 'bar' });
    const child2 = new TestObject({ foo: 'baz' });
    const child3 = new TestObject({ foo: 'bin' });
    const parent = new Parse.Object('Container');
    parent.set('child1', child1);
    parent.set('child2', child2);
    parent.set('child3', child3);
    await Parse.Object.saveAll([child1, child2, child3, parent]);

    const query = new Parse.Query('Container');
    query.equalTo('objectId', parent.id);
    query.includeAll();

    const results = await query.find();

    assert.equal(results.length, 1);
    const parentAgain = results[0];
    assert.equal(parentAgain.get('child1').get('foo'), 'bar');
    assert.equal(parentAgain.get('child2').get('foo'), 'baz');
    assert.equal(parentAgain.get('child3').get('foo'), 'bin');
  });

  it('can includeAll nested objects in .each', async () => {
    const child1 = new TestObject({ foo: 'bar' });
    const child2 = new TestObject({ foo: 'baz' });
    const child3 = new TestObject({ foo: 'bin' });
    const parent = new Parse.Object('Container');
    parent.set('child1', child1);
    parent.set('child2', child2);
    parent.set('child3', child3);
    await Parse.Object.saveAll([child1, child2, child3, parent]);

    const query = new Parse.Query('Container');
    query.equalTo('objectId', parent.id);
    query.includeAll();

    await query.each(obj => {
      assert.equal(obj.get('child1').get('foo'), 'bar');
      assert.equal(obj.get('child2').get('foo'), 'baz');
      assert.equal(obj.get('child3').get('foo'), 'bin');
    });
  });

  it('can return all objects with findAll', async () => {
    const objs = [...Array(101)].map(() => new Parse.Object('Container'));

    await Parse.Object.saveAll(objs);

    const query = new Parse.Query('Container');

    const result = await query.findAll();

    assert.equal(result.length, 101);
  });

  it('can include nested objects via array', done => {
    const child = new TestObject();
    const parent = new Parse.Object('Container');
    child.set('foo', 'bar');
    parent.set('child', child);
    Parse.Object.saveAll([child, parent])
      .then(() => {
        const query = new Parse.Query('Container');
        query.equalTo('objectId', parent.id);
        query.include(['child']);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        const parentAgain = results[0];
        assert(parentAgain.get('child'));
        assert(parentAgain.get('child').id);
        assert.equal(parentAgain.get('child').get('foo'), 'bar');
        done();
      });
  });

  it('can do a nested include', done => {
    const Child = Parse.Object.extend('Child');
    const Parent = Parse.Object.extend('Parent');
    const Grandparent = Parse.Object.extend('Grandparent');

    const objects = [];
    for (let i = 0; i < 5; i++) {
      const grandparent = new Grandparent({
        nested: true,
        z: i,
        parent: new Parent({
          y: i,
          child: new Child({
            x: i,
          }),
        }),
      });

      objects.push(grandparent);
    }

    Parse.Object.saveAll(objects)
      .then(() => {
        const q = new Parse.Query('Grandparent');
        q.equalTo('nested', true);
        q.include('parent.child');
        return q.find();
      })
      .then(results => {
        assert.equal(results.length, 5);
        results.forEach(o => {
          assert.equal(o.get('z'), o.get('parent').get('y'));
          assert.equal(o.get('z'), o.get('parent').get('child').get('x'));
        });
        done();
      });
  });

  it('can include without changing dirty', done => {
    const parent = new Parse.Object('ParentObject');
    const child = new Parse.Object('ChildObject');
    parent.set('child', child);
    child.set('foo', 'bar');

    Parse.Object.saveAll([child, parent])
      .then(() => {
        const query = new Parse.Query('ParentObject');
        query.include('child');
        query.equalTo('objectId', parent.id);
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        const parentAgain = results[0];
        const childAgain = parentAgain.get('child');
        assert.equal(child.id, childAgain.id);
        assert.equal(parent.id, parentAgain.id);
        assert.equal(childAgain.get('foo'), 'bar');
        assert(!parentAgain.dirty());
        assert(!childAgain.dirty());
        done();
      });
  });

  it('can exclude keys', async () => {
    const object = new TestObject({
      hello: 'world',
      foo: 'bar',
      slice: 'pizza',
    });
    await object.save();

    const query = new Parse.Query(TestObject);
    query.exclude('foo');
    const result = await query.get(object.id);
    assert.equal(result.get('foo'), undefined);
    assert.equal(result.get('hello'), 'world');
    assert.equal(result.get('slice'), 'pizza');
  });

  it('can exclude multiple keys', async () => {
    const object = new TestObject({
      hello: 'world',
      foo: 'bar',
      slice: 'pizza',
    });
    await object.save();

    const query = new Parse.Query(TestObject);
    query.exclude(['foo', 'hello']);
    const result = await query.get(object.id);
    assert.equal(result.get('foo'), undefined);
    assert.equal(result.get('hello'), undefined);
    assert.equal(result.get('slice'), 'pizza');
  });

  it('uses subclasses when creating objects', done => {
    const ParentObject = Parse.Object.extend({ className: 'ParentObject' });
    let ChildObject = Parse.Object.extend('ChildObject', {
      foo() {
        return 'foo';
      },
    });

    const parent = new ParentObject();
    const child = new ChildObject();
    parent.set('child', child);
    Parse.Object.saveAll([child, parent])
      .then(() => {
        ChildObject = Parse.Object.extend('ChildObject', {
          bar() {
            return 'bar';
          },
        });

        const query = new Parse.Query(ParentObject);
        query.equalTo('objectId', parent.id);
        query.include('child');
        return query.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        const parentAgain = results[0];
        const childAgain = parentAgain.get('child');
        assert.equal(childAgain.foo(), 'foo');
        assert.equal(childAgain.bar(), 'bar');
        done();
      });
  });

  it('can match the results of another query', done => {
    const ParentObject = Parse.Object.extend('ParentObject');
    const ChildObject = Parse.Object.extend('ChildObject');
    const objects = [];
    for (let i = 0; i < 10; i++) {
      objects.push(
        new ParentObject({
          child: new ChildObject({ x: i, qtest: true }),
          x: 10 + i,
        })
      );
    }
    Parse.Object.saveAll(objects)
      .then(() => {
        const subQuery = new Parse.Query(ChildObject);
        subQuery.equalTo('qtest', true);
        subQuery.greaterThan('x', 5);
        const q = new Parse.Query(ParentObject);
        q.matchesQuery('child', subQuery);
        return q.find();
      })
      .then(results => {
        assert.equal(results.length, 4);
        results.forEach(o => {
          assert(o.get('x') > 15);
        });
        done();
      });
  });

  it('can not match the results of another query', done => {
    const ParentObject = Parse.Object.extend('ParentObject');
    const ChildObject = Parse.Object.extend('ChildObject');
    const objects = [];
    for (let i = 0; i < 10; i++) {
      objects.push(
        new ParentObject({
          child: new ChildObject({ x: i, dneqtest: true }),
          dneqtest: true,
          x: 10 + i,
        })
      );
    }
    Parse.Object.saveAll(objects)
      .then(() => {
        const subQuery = new Parse.Query(ChildObject);
        subQuery.equalTo('dneqtest', true);
        subQuery.greaterThan('x', 5);
        const q = new Parse.Query(ParentObject);
        q.equalTo('dneqtest', true);
        q.doesNotMatchQuery('child', subQuery);
        return q.find();
      })
      .then(results => {
        assert.equal(results.length, 6);
        results.forEach(o => {
          assert(o.get('x') >= 10);
          assert(o.get('x') <= 15);
        });
        done();
      })
      .catch(err => {
        console.dir(err);
        done.fail();
      });
  });

  it('can select keys from a matched query', done => {
    const Restaurant = Parse.Object.extend('Restaurant');
    const Person = Parse.Object.extend('Person');
    const objects = [
      new Restaurant({ rating: 5, location: 'Djibouti' }),
      new Restaurant({ rating: 3, location: 'Ouagadougou' }),
      new Person({ name: 'Bob', hometown: 'Djibouti' }),
      new Person({ name: 'Tom', hometown: 'Ouagadougou' }),
      new Person({ name: 'Billy', hometown: 'Detroit' }),
    ];

    Parse.Object.saveAll(objects)
      .then(() => {
        const query = new Parse.Query(Restaurant);
        query.greaterThan('rating', 4);
        const mainQuery = new Parse.Query(Person);
        mainQuery.matchesKeyInQuery('hometown', 'location', query);
        return mainQuery.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        assert.equal(results[0].get('name'), 'Bob');

        const query = new Parse.Query(Restaurant);
        query.greaterThan('rating', 4);
        const mainQuery = new Parse.Query(Person);
        mainQuery.doesNotMatchKeyInQuery('hometown', 'location', query);
        mainQuery.ascending('name');
        return mainQuery.find();
      })
      .then(results => {
        assert.equal(results.length, 2);
        assert.equal(results[0].get('name'), 'Billy');
        assert.equal(results[1].get('name'), 'Tom');

        done();
      });
  });

  it('supports objects with length', async () => {
    const obj = new TestObject();
    obj.set('length', 5);
    assert.equal(obj.get('length'), 5);
    await expectAsync(obj.save()).toBeRejectedWithError('Invalid field name: length.');
  });

  it('can include User fields', async () => {
    const user = new Parse.User();
    user.set('username', 'bob');
    user.set('password', 'password');
    user.set('age', 21);
    const acl = new Parse.ACL();
    acl.setPublicReadAccess(true);
    user.setACL(acl);
    await user.signUp();
    const obj = new TestObject();
    await obj.save({ owner: user });
    const query = new Parse.Query(TestObject);
    query.include('owner');
    const objAgain = await query.get(obj.id);
    assert(objAgain.get('owner') instanceof Parse.User);
    assert.equal(objAgain.get('owner').get('age'), 21);
  });

  it('can build OR queries', done => {
    const objects = [];
    for (let i = 0; i < 10; i++) {
      const obj = new Parse.Object('BoxedNumber');
      obj.set({ x: i, orquery: true });
      objects.push(obj);
    }
    Parse.Object.saveAll(objects)
      .then(() => {
        const q1 = new Parse.Query('BoxedNumber');
        q1.equalTo('orquery', true);
        q1.lessThan('x', 2);
        const q2 = new Parse.Query('BoxedNumber');
        q2.equalTo('orquery', true);
        q2.greaterThan('x', 5);
        const orQuery = Parse.Query.or(q1, q2);
        return orQuery.find();
      })
      .then(results => {
        assert.equal(results.length, 6);
        results.forEach(number => {
          assert(number.get('x') < 2 || number.get('x') > 5);
        });
        done();
      });
  });

  it('can build complex OR queries', done => {
    const objects = [];
    for (let i = 0; i < 10; i++) {
      const child = new Parse.Object('Child');
      child.set('x', i);
      child.set('complexor', true);
      const parent = new Parse.Object('Parent');
      parent.set('child', child);
      parent.set('complexor', true);
      parent.set('y', i);
      objects.push(parent);
    }
    Parse.Object.saveAll(objects)
      .then(() => {
        const subQuery = new Parse.Query('Child');
        subQuery.equalTo('x', 4);
        subQuery.equalTo('complexor', true);
        const q1 = new Parse.Query('Parent');
        q1.matchesQuery('child', subQuery);
        const q2 = new Parse.Query('Parent');
        q2.equalTo('complexor', true);
        q2.lessThan('y', 2);
        const orQuery = Parse.Query.or(q1, q2);
        return orQuery.find();
      })
      .then(results => {
        assert.equal(results.length, 3);
        done();
      })
      .catch(done.fail);
  });

  it('can build AND queries', done => {
    const objects = [];
    for (let i = 0; i < 10; i++) {
      const obj = new Parse.Object('BoxedNumber');
      obj.set({ x: i, and: true });
      objects.push(obj);
    }
    Parse.Object.saveAll(objects)
      .then(() => {
        const q1 = new Parse.Query('BoxedNumber');
        q1.equalTo('and', true);
        q1.greaterThan('x', 2);
        const q2 = new Parse.Query('BoxedNumber');
        q2.equalTo('and', true);
        q2.lessThan('x', 5);
        const andQuery = Parse.Query.and(q1, q2);
        return andQuery.find();
      })
      .then(results => {
        assert.equal(results.length, 2);
        results.forEach(number => {
          assert(number.get('x') > 2 && number.get('x') < 5);
        });
        done();
      })
      .catch(e => console.log(e));
  });

  it('can build complex AND queries', done => {
    const objects = [];
    for (let i = 0; i < 10; i++) {
      const child = new Parse.Object('Child');
      child.set('x', i);
      child.set('and', true);
      const parent = new Parse.Object('Parent');
      parent.set('child', child);
      parent.set('and', true);
      parent.set('y', i);
      objects.push(parent);
    }
    Parse.Object.saveAll(objects)
      .then(() => {
        const subQuery = new Parse.Query('Child');
        subQuery.equalTo('x', 4);
        subQuery.equalTo('and', true);
        const q1 = new Parse.Query('Parent');
        q1.matchesQuery('child', subQuery);
        const q2 = new Parse.Query('Parent');
        q2.equalTo('and', true);
        q2.equalTo('y', 4);
        const andQuery = Parse.Query.and(q1, q2);
        return andQuery.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        done();
      })
      .catch(done.fail);
  });

  it('can build NOR queries', async () => {
    const objects = [];
    for (let i = 0; i < 10; i += 1) {
      const obj = new Parse.Object('NORTest');
      obj.set({ x: i });
      objects.push(obj);
    }
    await Parse.Object.saveAll(objects);

    const q1 = new Parse.Query('NORTest');
    q1.greaterThan('x', 5);
    const q2 = new Parse.Query('NORTest');
    q2.lessThan('x', 3);
    const norQuery = Parse.Query.nor(q1, q2);
    const results = await norQuery.find();

    assert.equal(results.length, 3);
    results.forEach(number => {
      assert(number.get('x') >= 3 && number.get('x') <= 5);
    });
  });

  it('can build complex NOR queries', async () => {
    const objects = [];
    for (let i = 0; i < 10; i += 1) {
      const child = new Parse.Object('Child');
      child.set('x', i);
      const parent = new Parse.Object('Parent');
      parent.set('child', child);
      parent.set('y', i);
      objects.push(parent);
    }
    await Parse.Object.saveAll(objects);

    const subQuery = new Parse.Query('Child');
    subQuery.equalTo('x', 4);
    const q1 = new Parse.Query('Parent');
    q1.matchesQuery('child', subQuery);
    const q2 = new Parse.Query('Parent');
    q2.equalTo('y', 5);
    const norQuery = Parse.Query.nor(q1, q2);
    const results = await norQuery.find();

    assert.equal(results.length, 8);
    results.forEach(number => {
      assert(number.get('x') !== 4 || number.get('x') !== 5);
    });
  });

  it('can iterate over results with each', done => {
    const items = [];
    for (let i = 0; i < 50; i++) {
      items.push(new TestObject({ x: i, eachtest: true }));
    }
    const seen = [];
    Parse.Object.saveAll(items)
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.equalTo('eachtest', true);
        query.lessThan('x', 25);

        return query.each(obj => {
          seen[obj.get('x')] = (seen[obj.get('x')] || 0) + 1;
        });
      })
      .then(() => {
        assert.equal(seen.length, 25);
        for (let i = 0; i < seen.length; i++) {
          assert.equal(seen[i], 1);
        }
        done();
      });
  });

  it('fails query.each with order', done => {
    const items = [];
    for (let i = 0; i < 50; i++) {
      items.push(new TestObject({ x: i, eachtest: true }));
    }
    const seen = [];
    Parse.Object.saveAll(items)
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.equalTo('eachtest', true);
        query.lessThan('x', 25);
        query.ascending('x');

        return query.each(obj => {
          seen[obj.get('x')] = (seen[obj.get('x')] || 0) + 1;
        });
      })
      .then(null, () => {
        done();
      });
  });

  it('fails query.each with limit', done => {
    const items = [];
    for (let i = 0; i < 50; i++) {
      items.push(new TestObject({ x: i, eachtest: true }));
    }
    const seen = [];
    Parse.Object.saveAll(items)
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.equalTo('eachtest', true);
        query.lessThan('x', 25);
        query.limit(20);

        return query.each(obj => {
          seen[obj.get('x')] = (seen[obj.get('x')] || 0) + 1;
        });
      })
      .then(null, () => {
        done();
      });
  });

  it('fails query.each with skip', done => {
    const items = [];
    for (let i = 0; i < 50; i++) {
      items.push(new TestObject({ x: i, eachtest: true }));
    }
    const seen = [];
    Parse.Object.saveAll(items)
      .then(() => {
        const query = new Parse.Query(TestObject);
        query.equalTo('eachtest', true);
        query.lessThan('x', 25);
        query.skip(20);

        return query.each(obj => {
          seen[obj.get('x')] = (seen[obj.get('x')] || 0) + 1;
        });
      })
      .then(null, () => {
        done();
      });
  });

  it('can select specific keys', done => {
    const obj = new TestObject({ foo: 'baz', bar: 1 });
    obj
      .save()
      .then(() => {
        const q = new Parse.Query(TestObject);
        q.equalTo('objectId', obj.id);
        q.select('foo');
        return q.first();
      })
      .then(result => {
        assert(result.id);
        assert(result.createdAt);
        assert(result.updatedAt);
        assert(!result.dirty());
        assert.equal(result.get('foo'), 'baz');
        assert.equal(result.get('bar'), undefined);
        done();
      });
  });

  it('can select specific keys with each', done => {
    const obj = new TestObject({ foo: 'baz', bar: 1 });
    obj
      .save()
      .then(() => {
        const q = new Parse.Query(TestObject);
        q.equalTo('objectId', obj.id);
        q.select('foo');
        return q.each(o => {
          assert(o.id);
          assert.equal(o.get('foo'), 'baz');
          assert.equal(o.get('bar'), undefined);
        });
      })
      .then(() => {
        done();
      });
  });

  it('can perform a full text search', () => {
    const subjects = [
      'coffee',
      'Coffee Shopping',
      'Baking a cake',
      'baking',
      'Café Con Leche',
      'Сырники',
      'coffee and cream',
      'Cafe con Leche',
    ];
    const objects = [];
    for (const i in subjects) {
      const obj = new TestObject({ subject: subjects[i] });
      objects.push(obj);
    }
    return Parse.Object.saveAll(objects)
      .then(() => {
        const q = new Parse.Query(TestObject);
        q.fullText('subject', 'coffee');
        return q.find();
      })
      .then(results => {
        assert.equal(results.length, 3);
      });
  });

  it('can perform a full text search sort', () => {
    const subjects = [
      'coffee',
      'Coffee Shopping',
      'Baking a cake',
      'baking',
      'Café Con Leche',
      'Сырники',
      'coffee and cream',
      'Cafe con Leche',
    ];
    const objects = [];
    for (const i in subjects) {
      const obj = new TestObject({ subject: subjects[i] });
      objects.push(obj);
    }
    return Parse.Object.saveAll(objects)
      .then(() => {
        const q = new Parse.Query(TestObject);
        q.fullText('subject', 'coffee');
        q.ascending('$score');
        q.select('$score');
        return q.find();
      })
      .then(results => {
        assert.equal(results.length, 3);
        assert.equal(results[0].get('score'), 1);
        assert.equal(results[1].get('score'), 0.75);
        assert.equal(results[2].get('score'), 0.75);
      });
  });

  it('can perform a full text search with language options', () => {
    const subjects = [
      'café',
      'loja de café',
      'preparando um café',
      'preparar',
      'café com leite',
      'Сырники',
      'prepare café e creme',
      'preparação de cafe com leite',
    ];
    const TestLanguageOption = Parse.Object.extend('TestLanguageOption');
    const objects = [];
    for (const i in subjects) {
      const obj = new TestLanguageOption({ language_comment: subjects[i] });
      objects.push(obj);
    }
    return Parse.Object.saveAll(objects)
      .then(() => {
        const q = new Parse.Query(TestLanguageOption);
        q.fullText('language_comment', 'preparar', { language: 'portuguese' });
        return q.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
      });
  });

  it('can perform a full text search with case sensitive options', () => {
    const subjects = [
      'café',
      'loja de café',
      'Preparando um café',
      'preparar',
      'café com leite',
      'Сырники',
      'Preparar café e creme',
      'preparação de cafe com leite',
    ];
    const TestCaseOption = Parse.Object.extend('TestCaseOption');
    const objects = [];
    for (const i in subjects) {
      const obj = new TestCaseOption({ casesensitive_comment: subjects[i] });
      objects.push(obj);
    }
    return Parse.Object.saveAll(objects)
      .then(() => {
        const q = new Parse.Query(TestCaseOption);
        q.fullText('casesensitive_comment', 'Preparar', {
          caseSensitive: true,
        });
        return q.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
      });
  });

  it('can perform a full text search with diacritic sensitive options', () => {
    const subjects = [
      'café',
      'loja de café',
      'preparando um café',
      'Preparar',
      'café com leite',
      'Сырники',
      'preparar café e creme',
      'preparação de cafe com leite',
    ];
    const TestDiacriticOption = Parse.Object.extend('TestDiacriticOption');
    const objects = [];
    for (const i in subjects) {
      const obj = new TestDiacriticOption({ diacritic_comment: subjects[i] });
      objects.push(obj);
    }
    return Parse.Object.saveAll(objects)
      .then(() => {
        const q = new Parse.Query(TestDiacriticOption);
        q.fullText('diacritic_comment', 'cafe', { diacriticSensitive: true });
        return q.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
      });
  });

  it('can perform a full text search with case and diacritic sensitive options', () => {
    const subjects = ['Café', 'café', 'preparar Cafe e creme', 'preparação de cafe com leite'];
    const TestCaseDiacriticOption = Parse.Object.extend('TestCaseDiacriticOption');
    const objects = [];
    for (const i in subjects) {
      const obj = new TestCaseDiacriticOption({
        diacritic_comment: subjects[i],
      });
      objects.push(obj);
    }
    return Parse.Object.saveAll(objects)
      .then(() => {
        const q = new Parse.Query(TestCaseDiacriticOption);
        q.fullText('diacritic_comment', 'cafe', {
          caseSensitive: true,
          diacriticSensitive: true,
        });
        return q.find();
      })
      .then(results => {
        assert.equal(results.length, 1);
        assert.equal(results[0].get('diacritic_comment'), 'preparação de cafe com leite');
      });
  });

  it('fails to perform a full text search with unknown options', done => {
    const subjects = [
      'café',
      'loja de café',
      'preparando um café',
      'preparar',
      'café com leite',
      'Сырники',
      'prepare café e creme',
      'preparação de cafe com leite',
    ];
    const objects = [];
    for (const i in subjects) {
      const obj = new TestObject({ comment: subjects[i] });
      objects.push(obj);
    }
    Parse.Object.saveAll(objects)
      .then(() => {
        const q = new Parse.Query(TestObject);
        q.fullText('comment', 'preparar', {
          language: 'portuguese',
          notAnOption: true,
        });
        return q.find();
      })
      .catch(() => {
        done();
      });
  });

  it('can return results in map', async () => {
    const obj1 = new TestObject({ foo: 'bar' });
    const obj2 = new TestObject({ foo: 'baz' });
    const obj3 = new TestObject({ foo: 'bin' });
    await Parse.Object.saveAll([obj1, obj2, obj3]);
    let i = 0;
    const mapQuery = new Parse.Query(TestObject);
    const results = await mapQuery.map((object, index, query) => {
      assert.equal(index, i);
      assert.equal(query, mapQuery);
      i += 1;
      return object.get('foo');
    });
    assert.equal(results.includes('bar'), true);
    assert.equal(results.includes('baz'), true);
    assert.equal(results.includes('bin'), true);
    assert.equal(results.length, 3);
  });

  it('can return results in filter', async () => {
    const obj1 = new TestObject({ foo: 'bar' });
    const obj2 = new TestObject({ foo: 'baz' });
    const obj3 = new TestObject({ foo: 'bin' });
    await Parse.Object.saveAll([obj1, obj2, obj3]);
    let i = 0;
    const filterQuery = new Parse.Query(TestObject);
    const results = await filterQuery.filter((object, index, query) => {
      assert.equal(index, i);
      assert.equal(query, filterQuery);
      i += 1;
      return object.get('foo') === 'bar';
    });
    assert.equal(results[0].get('foo'), 'bar');
    assert.equal(results.length, 1);
  });

  it('can return results in reduce', async () => {
    const obj1 = new TestObject({ number: 1 });
    const obj2 = new TestObject({ number: 2 });
    const obj3 = new TestObject({ number: 3 });
    await Parse.Object.saveAll([obj1, obj2, obj3]);
    let i = 0;
    const reduceQuery = new Parse.Query(TestObject);
    const result = await reduceQuery.reduce((accumulator, object, index) => {
      assert.equal(index, i);
      i += 1;
      return accumulator + object.get('number');
    }, 0);
    assert.equal(result, 6);
  });

  it('can cancel query', async () => {
    const obj1 = new TestObject({ number: 1 });
    const obj2 = new TestObject({ number: 2 });
    const obj3 = new TestObject({ number: 3 });
    await Parse.Object.saveAll([obj1, obj2, obj3]);

    const query = new Parse.Query(TestObject);
    query.find().then(results => {
      assert.equal(results.length, 0);
    });
    query.cancel();
  });

  it('can query with hint', async () => {
    const obj1 = new TestObject({ number: 1 });
    const obj2 = new TestObject({ number: 2 });
    const obj3 = new TestObject({ number: 3 });
    await Parse.Object.saveAll([obj1, obj2, obj3]);

    const query = new Parse.Query(TestObject);
    query.hint('_id_');
    query.explain();
    const explain = await query.find();
    let indexName = '';
    // https://www.mongodb.com/docs/manual/reference/explain-results/#std-label-queryPlanner
    const plan = explain[0].queryPlanner.winningPlan;
    if (plan.inputStage) {
      indexName = plan.inputStage.inputStage.indexName;
    } else {
      indexName = plan.queryPlan.inputStage.inputStage.indexName;
    }
    assert.equal(indexName, '_id_');

    const explainFirst = await query.first();
    assert.equal(explainFirst.queryPlanner.winningPlan.inputStage.inputStage.indexName, '_id_');
  });

  it('can query with select on null field', async () => {
    const obj1 = new TestObject({ number: 1, arrayField: [] });
    const obj2 = new TestObject({ number: 2, arrayField: [{ subfield: 1 }] });
    const obj3 = new TestObject({ number: 3, arrayField: null });
    await Parse.Object.saveAll([obj1, obj2, obj3]);

    const query = new Parse.Query(TestObject);
    query.select(['arrayField.subfield']);
    query.ascending('number');
    const results = await query.find();
    expect(results[0].get('arrayField')).toEqual([]);
    expect(results[1].get('arrayField')).toEqual([{ subfield: 1 }]);
    expect(results[2].get('arrayField')).toEqual(null);
  });
});