import knex, { Knex } from 'knex'; import request from 'supertest'; import { v4 as uuid } from 'uuid'; import config, { getUrl } from '../../config'; import vendors from '../../get-dbs-to-test'; import { createArtist, createGuest, createMany, seedTable } from '../../setup/utils/factories'; describe('/items', () => { const databases = new Map(); beforeAll(async () => { for (const vendor of vendors) { databases.set(vendor, knex(config.knexConfig[vendor]!)); } }); afterAll(async () => { for (const [_vendor, connection] of databases) { await connection.destroy(); } }); beforeEach(async () => { for (const [, connection] of databases) { await connection('guests').delete(); } }); describe('/:collection GET', () => { describe('Mathematical Operators', () => { describe('returns users with name _eq', () => { it.each(vendors)('%s', async (vendor) => { const name = 'users-with-eq@example.com'; const guests: any[] = createMany(createGuest, 10); for (const guest of guests) { guest.id = uuid(); guest.name = name; } await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_eq": "${name}"}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(guests.length); expect(response.body.data[0]).toMatchObject({ name: name, }); }); }); describe('returns users with name _neq', () => { it.each(vendors)('%s', async (vendor) => { const guests: any[] = createMany(createGuest, 10); await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_neq": "${guests[0].name}"}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.map((guest: any) => guest.name).includes(guests[0].name)).toBeFalsy(); }); }); describe('returns users with name _ieq', () => { it.each(vendors)('%s', async (vendor) => { const name = 'USERS-WITH-IEQ@example.com'; const guests: any[] = createMany(createGuest, 10); for (const guest of guests) { guest.id = uuid(); guest.name = name; } await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_ieq": "${name}"}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(guests.length); expect(response.body.data[0]).toMatchObject({ name: name, }); }); }); describe('returns users with name _nieq', () => { it.each(vendors)('%s', async (vendor) => { const guests: any[] = createMany(createGuest, 10); await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_nieq": "${guests[0].name.toUpperCase()}"}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.map((guest: any) => guest.name).includes(guests[0].name)).toBeFalsy(); }); }); describe('returns users with name _contains', () => { it.each(vendors)('%s', async (vendor) => { const query = 'contains'; const name0 = 'user0-with-contains@example.com'; const name1 = 'user1-with-contains@example.com'; const guests: any[] = createMany(createGuest, 10); guests[0].name = name0; guests[1].name = name1; await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_contains": "${query}"}}&sort=name`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(2); expect(response.body.data).toMatchObject([{ name: name0 }, { name: name1 }]); }); }); describe('returns users with name _ncontains', () => { it.each(vendors)('%s', async (vendor) => { const query = 'contains'; const name0 = 'user0-with-ncontains@example.com'; const name1 = 'user1-with-ncontains@example.com'; const guests: any[] = createMany(createGuest, 10); guests[0].name = name0; guests[1].name = name1; await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_ncontains": "${query}"}}&sort=name`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(8); expect( response.body.data.map((guest: any) => guest.name).every((name: any) => name.includes(query)) ).toBeFalsy(); }); }); describe('returns users with name _icontains', () => { it.each(vendors)('%s', async (vendor) => { const query = 'ICONTAINS'; const name0 = 'user0-with-icontains@example.com'; const name1 = 'user1-with-icontains@example.com'; const guests: any[] = createMany(createGuest, 10); guests[0].name = name0; guests[1].name = name1; await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_icontains": "${query}"}}&sort=name`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(2); expect(response.body.data).toMatchObject([{ name: name0 }, { name: name1 }]); }); }); describe('returns users with name _nicontains', () => { it.each(vendors)('%s', async (vendor) => { const query = 'NICONTAINS'; const name0 = 'user0-with-nicontains@example.com'; const name1 = 'user1-with-nicontains@example.com'; const guests: any[] = createMany(createGuest, 10); guests[0].name = name0; guests[1].name = name1; await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_nicontains": "${query}"}}&sort=name`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(8); expect( response.body.data.map((guest: any) => guest.name).every((name: any) => name.includes(query)) ).toBeFalsy(); }); }); describe('returns users with name _starts_with', () => { it.each(vendors)('%s', async (vendor) => { const query = 'user'; const name0 = 'user0-with-starts-with@example.com'; const name1 = 'user1-with-starts-with@example.com'; const guests: any[] = createMany(createGuest, 10); guests[0].name = name0; guests[1].name = name1; await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_starts_with": "${query}"}}&sort=name`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(2); expect(response.body.data).toMatchObject([{ name: name0 }, { name: name1 }]); }); }); describe('returns users with name _nstarts_with', () => { it.each(vendors)('%s', async (vendor) => { const query = 'user'; const name0 = 'user0-with-nstarts-with@example.com'; const name1 = 'user1-with-nstarts-with@example.com'; const guests: any[] = createMany(createGuest, 10); guests[0].name = name0; guests[1].name = name1; await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_nstarts_with": "${query}"}}&sort=name`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(8); expect( response.body.data.map((guest: any) => guest.name).every((name: any) => name.startsWith(query)) ).toBeFalsy(); }); }); describe('returns users with name _istarts_with', () => { it.each(vendors)('%s', async (vendor) => { const query = 'USER'; const name0 = 'user0-with-istarts-with@example.com'; const name1 = 'user1-with-istarts-with@example.com'; const guests: any[] = createMany(createGuest, 10); guests[0].name = name0; guests[1].name = name1; await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_istarts_with": "${query}"}}&sort=name`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(2); expect(response.body.data).toMatchObject([{ name: name0 }, { name: name1 }]); }); }); describe('returns users with name _nistarts_with', () => { it.each(vendors)('%s', async (vendor) => { const query = 'USER'; const name0 = 'user0-with-nistarts-with@example.com'; const name1 = 'user1-with-nistarts-with@example.com'; const guests: any[] = createMany(createGuest, 10); guests[0].name = name0; guests[1].name = name1; await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_nistarts_with": "${query}"}}&sort=name`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(8); expect( response.body.data.map((guest: any) => guest.name).every((name: any) => name.startsWith(query)) ).toBeFalsy(); }); }); describe('returns users with name _ends_with', () => { it.each(vendors)('%s', async (vendor) => { const query = 'com'; const name0 = 'user0-with-ends-with@example.com'; const name1 = 'user1-with-ends-with@example.com'; const guests: any[] = createMany(createGuest, 10); guests[0].name = name0; guests[1].name = name1; await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_ends_with": "${query}"}}&sort=name`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(2); expect(response.body.data).toMatchObject([{ name: name0 }, { name: name1 }]); }); }); describe('returns users with name _nends_with', () => { it.each(vendors)('%s', async (vendor) => { const query = 'com'; const name0 = 'user0-with-nends-with@example.com'; const name1 = 'user1-with-nends-with@example.com'; const guests: any[] = createMany(createGuest, 10); guests[0].name = name0; guests[1].name = name1; await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_nends_with": "${query}"}}&sort=name`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(8); expect( response.body.data.map((guest: any) => guest.name).every((name: any) => name.startsWith(query)) ).toBeFalsy(); }); }); describe('returns users with name _iends_with', () => { it.each(vendors)('%s', async (vendor) => { const query = 'COM'; const name0 = 'user0-with-iends-with@example.com'; const name1 = 'user1-with-iends-with@example.com'; const guests: any[] = createMany(createGuest, 10); guests[0].name = name0; guests[1].name = name1; await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_iends_with": "${query}"}}&sort=name`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(2); expect(response.body.data).toMatchObject([{ name: name0 }, { name: name1 }]); }); }); describe('returns users with name _niends_with', () => { it.each(vendors)('%s', async (vendor) => { const query = 'COM'; const name0 = 'user0-with-niends-with@example.com'; const name1 = 'user1-with-niends-with@example.com'; const guests: any[] = createMany(createGuest, 10); guests[0].name = name0; guests[1].name = name1; await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"name": {"_niends_with": "${query}"}}&sort=name`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(8); expect( response.body.data.map((guest: any) => guest.name).every((name: any) => name.startsWith(query)) ).toBeFalsy(); }); }); describe('returns users with shows_attended _gt', () => { it.each(vendors)('%s', async (vendor) => { const guests: any[] = createMany(createGuest, 10); for (let i = 0; i < guests.length; i++) { guests[i].shows_attended = i; } await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"shows_attended": {"_gt": 5}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(4); }); }); describe('returns users with shows_attended _gte', () => { it.each(vendors)('%s', async (vendor) => { const guests: any[] = createMany(createGuest, 10); for (let i = 0; i < guests.length; i++) { guests[i].shows_attended = i; } await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"shows_attended": {"_gte": 5}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(5); }); }); describe('returns users with shows_attended _lt', () => { it.each(vendors)('%s', async (vendor) => { const guests: any[] = createMany(createGuest, 10); for (let i = 0; i < guests.length; i++) { guests[i].shows_attended = i; } await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"shows_attended": {"_lt": 5}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(5); }); }); describe('returns users with shows_attended _lte', () => { it.each(vendors)('%s', async (vendor) => { const guests: any[] = createMany(createGuest, 10); for (let i = 0; i < guests.length; i++) { guests[i].shows_attended = i; } await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"shows_attended": {"_lte": 5}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(6); }); }); describe('returns users with shows_attended _in array of values', () => { it.each(vendors)('%s', async (vendor) => { const guests: any[] = createMany(createGuest, 10); for (let i = 0; i < guests.length; i++) { guests[i].shows_attended = i; } await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"shows_attended": {"_in": [0,1,2]}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(3); }); }); describe('returns users with shows_attended _in list of values', () => { it.each(vendors)('%s', async (vendor) => { const guests: any[] = createMany(createGuest, 10); for (let i = 0; i < guests.length; i++) { guests[i].shows_attended = i; } await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"shows_attended": {"_in": "0,1,2"}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(3); }); }); describe('returns users with shows_attended _nin list of values', () => { it.each(vendors)('%s', async (vendor) => { const guests: any[] = createMany(createGuest, 10); for (let i = 0; i < guests.length; i++) { guests[i].shows_attended = i; } await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"shows_attended": {"_nin": [0,1,2]}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(7); }); }); describe('returns users with shows_attended _nin list of values', () => { it.each(vendors)('%s', async (vendor) => { const guests: any[] = createMany(createGuest, 10); for (let i = 0; i < guests.length; i++) { guests[i].shows_attended = i; } await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"shows_attended": {"_nin": "0,1,2"}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(7); }); }); describe('returns users with shows_attended _between array of values', () => { it.each(vendors)('%s', async (vendor) => { const fromShowsAttended = 1; const toShowsAttended = 3; const guests: any[] = createMany(createGuest, 10); for (let i = 0; i < guests.length; i++) { guests[i].shows_attended = i; } await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"shows_attended": {"_between": [${fromShowsAttended},${toShowsAttended}]}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(3); }); }); describe('returns users with shows_attended _between list of values', () => { it.each(vendors)('%s', async (vendor) => { const fromShowsAttended = 1; const toShowsAttended = 3; const guests: any[] = createMany(createGuest, 10); for (let i = 0; i < guests.length; i++) { guests[i].shows_attended = i; } await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"shows_attended": {"_between": "${fromShowsAttended},${toShowsAttended}"}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(3); }); }); describe('returns users with shows_attended _nbetween array of values', () => { it.each(vendors)('%s', async (vendor) => { const fromShowsAttended = 1; const toShowsAttended = 3; const guests: any[] = createMany(createGuest, 10); for (let i = 0; i < guests.length; i++) { guests[i].shows_attended = i; } await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"shows_attended": {"_nbetween": [${fromShowsAttended},${toShowsAttended}]}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(7); }); }); describe('returns users with shows_attended _nbetween list of values', () => { it.each(vendors)('%s', async (vendor) => { const fromShowsAttended = 1; const toShowsAttended = 3; const guests: any[] = createMany(createGuest, 10); for (let i = 0; i < guests.length; i++) { guests[i].shows_attended = i; } await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get(`/items/guests?filter={"shows_attended": {"_nbetween": "${fromShowsAttended},${toShowsAttended}"}}`) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(7); }); }); }); describe('Logical Operators', () => { describe('returns users with name equality _AND favorite_artist equality', () => { it.each(vendors)('%s', async (vendor) => { const name = 'users-with-name-and-favorite-artist@example.com'; const guests: any[] = createMany(createGuest, 10, { name }); await seedTable(databases.get(vendor)!, 1, 'guests', guests); const artist = createArtist(); for (const guest of guests) { guest.id = uuid(); guest.name = name; guest.favorite_artist = artist.id; } await seedTable(databases.get(vendor)!, 1, 'artists', artist); await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get( `/items/guests?filter={"_and":[{"name": { "_eq": "${guests[0].name}" }},{"favorite_artist": { "_eq": "${guests[0].favorite_artist}" }}]}` ) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(guests.length); }); }); describe('returns users with name equality _OR favorite_artist equality', () => { it.each(vendors)('%s', async (vendor) => { const name = 'testing-name-equality@example.com'; const artist = createArtist(); const guests: any[] = createMany(createGuest, 10, { name }); await seedTable(databases.get(vendor)!, 1, 'guests', guests); for (const guest of guests) { guest.id = uuid(); guest.name = 'not-equal-test@example.com'; guest.favorite_artist = artist.id; } await seedTable(databases.get(vendor)!, 1, 'artists', artist); await seedTable(databases.get(vendor)!, 1, 'guests', guests); const response = await request(getUrl(vendor)) .get( `/items/guests?filter={"_or":[{"name": { "_eq": "${name}" }},{"favorite_artist": { "_eq": "${artist.id}" }}]}` ) .set('Authorization', 'Bearer AdminToken') .expect('Content-Type', /application\/json/) .expect(200); expect(response.body.data.length).toBe(20); }); }); }); }); describe('/:collection GraphQL Query', () => { describe('ignore undefined values when not passing variables used in query', () => { it.each(vendors)('%s', async (vendor) => { const guests: any[] = createMany(createGuest, 10); await seedTable(databases.get(vendor)!, 1, 'guests', guests); // we're intentionally not passing value for the variable $ids const query = ` query getGuests($ids: [String]) { guests(filter: { id: { _nin: $ids } }) { id name } }`; const response = await request(getUrl(vendor)) .post('/graphql') .set('Authorization', 'Bearer AdminToken') .set('Content-Type', 'application/json') .send({ query }) .expect('Content-Type', /application\/json/) .expect(200); const { data } = response.body; expect(data.guests.length).toBe(guests.length); }); }); }); });