/* * This is the spec file for testing the query functions */ import { cb, platformUrl } from "./utils"; describe("single query operators", function() { it("equal to", function() { var query = cb.Query(); query.equalTo("name", "john"); var expectedQuery = [[{ EQ: [{ name: "john" }] }]]; expect(query.query.FILTERS).toEqual(expectedQuery); }); it("greater than", function() { var query = cb.Query(); query.greaterThan("age", 23); var expectedQuery = [[{ GT: [{ age: 23 }] }]]; expect(query.query.FILTERS).toEqual(expectedQuery); }); it("less than", function() { var query = cb.Query(); query.lessThan("age", 44); var expectedQuery = [[{ LT: [{ age: 44 }] }]]; expect(query.query.FILTERS).toEqual(expectedQuery); }); it("greater than or equal to", function() { var query = cb.Query(); query.greaterThanEqualTo("age", 18); var expectedQuery = [[{ GTE: [{ age: 18 }] }]]; expect(query.query.FILTERS).toEqual(expectedQuery); }); it("less than or equal to", function() { var query = cb.Query(); query.lessThanEqualTo("age", 18); var expectedQuery = [[{ LTE: [{ age: 18 }] }]]; expect(query.query.FILTERS).toEqual(expectedQuery); }); it("not equal to", function() { var query = cb.Query(); query.notEqualTo("name", "john"); var expectedQuery = [[{ NEQ: [{ name: "john" }] }]]; expect(query.query.FILTERS).toEqual(expectedQuery); }); it("regex match", function() { var query = cb.Query(); query.matches("name", "Smith$"); var expectedQuery = [[{ RE: [{ name: "Smith$" }] }]]; expect(query.query.FILTERS).toEqual(expectedQuery); }); }); describe("More complex queries", function() { it("A few equality clauses ANDed together", function() { var query = cb.Query(); query.equalTo("name", "john"); query.equalTo("age", 23); query.equalTo("email", "[email protected]"); var expectedQuery = [ [{ EQ: [{ name: "john" }, { age: 23 }, { email: "[email protected]" }] }] ]; expect(query.query.FILTERS).toEqual(expectedQuery); }); it("Multiple Operators joined by ANDs", function() { var query = cb.Query(); query.equalTo("name", "john"); query.greaterThan("age", 23); query.lessThan("weight", 200); query.matches("email", "@fake.com$"); var expectedQuery = [ [ { EQ: [{ name: "john" }] }, { GT: [{ age: 23 }] }, { LT: [{ weight: 200 }] }, { RE: [{ email: "@fake.com$" }] } ] ]; expect(query.query.FILTERS).toEqual(expectedQuery); }); it("Multiple queries with an OR", function() { var query1 = cb.Query(), query2 = cb.Query(), query3 = cb.Query(); query1.equalTo("name", "john"); query2.equalTo("age", 23); query3.equalTo("email", "[email protected]"); query1.or(query2).or(query3); var expectedQuery = [ [{ EQ: [{ name: "john" }] }], [{ EQ: [{ age: 23 }] }], [{ EQ: [{ email: "[email protected]" }] }] ]; expect(query1.query.FILTERS).toEqual(expectedQuery); }); }); describe("query calls", function() { it("fetch with a simple equality query", function() { var query = cb.Query({ collectionID: "fakeCollectionID" }); query.equalTo("name", "john"); var callNum = ClearBlade.request.mock.calls.length; // we get the call count so we can grab the right call later var expectedData = { method: "GET", endpoint: "api/v/1/data/fakeCollectionID", URI: platformUrl, qs: "query=%7B%22FILTERS%22%3A%5B%5B%7B%22EQ%22%3A%5B%7B%22name%22%3A%22john%22%7D%5D%7D%5D%5D%7D", user: { email: "[email protected]", authToken: "testUserToken" } }; query.fetch(function(err, data) { expect(err).toBeNull(); expect(ClearBlade.request.mock.calls[callNum][0]).toEqual(expectedData); }); }); it("update with a simple equality query", function() { var query = cb.Query({ collectionID: "fakeCollectionID" }); query.equalTo("name", "john"); var callNum = ClearBlade.request.mock.calls.length; // we get the call count so we can grab the right call later var expectedData = { method: "PUT", endpoint: "api/v/1/data/fakeCollectionID", URI: platformUrl, body: { query: [[{ EQ: [{ name: "john" }] }]], $set: { name: "Bill" } }, user: { email: "[email protected]", authToken: "testUserToken" } }; query.update({ name: "Bill" }, function(err, data) { expect(err).toBeNull(); expect(ClearBlade.request.mock.calls[callNum][0]).toEqual(expectedData); }); }); it("remove with a simple equality query", function() { var query = cb.Query({ collectionID: "fakeCollectionID" }); query.equalTo("name", "john"); var callNum = ClearBlade.request.mock.calls.length; // we get the call count so we can grab the right call later var expectedData = { method: "DELETE", endpoint: "api/v/1/data/fakeCollectionID", URI: platformUrl, qs: "query=%7B%22FILTERS%22%3A%5B%5B%7B%22EQ%22%3A%5B%7B%22name%22%3A%22john%22%7D%5D%7D%5D%5D%7D", user: { email: "[email protected]", authToken: "testUserToken" } }; query.remove(function(err, data) { expect(err).toBeNull(); expect(ClearBlade.request.mock.calls[callNum][0]).toEqual(expectedData); }); }); });