import { BOOK } from '../tables/book';
import { ORDER } from '../tables/order';
import { sync } from "../utils/utils";
import { QuerySource } from "../../dist";
import { TestLog } from "../utils/logger";

export default (db: QuerySource, log: TestLog) => {

    describe('ORDER BY', () => {

        it('single column', sync(async () => {
            await db.from(BOOK).orderBy(BOOK.title).select();
            expect(log.sql).toEqual('SELECT * FROM "Book" ORDER BY "Book"."title"');
            await db.from(BOOK).orderBy(BOOK.title.asc()).select();
            expect(log.sql).toEqual('SELECT * FROM "Book" ORDER BY "Book"."title" ASC');
            await db.from(BOOK).orderBy(BOOK.title.desc()).select();
            expect(log.sql).toEqual('SELECT * FROM "Book" ORDER BY "Book"."title" DESC');
            await db.from(BOOK).orderBy(BOOK.title.asc().nullsFirst()).select();
            expect(log.sql).toEqual('SELECT * FROM "Book" ORDER BY "Book"."title" IS NULL DESC, "Book"."title" ASC');
            await db.from(BOOK).orderBy(BOOK.title.asc().nullsLast()).select();
            expect(log.sql).toEqual('SELECT * FROM "Book" ORDER BY "Book"."title" IS NULL ASC, "Book"."title" ASC');
            await db.from(BOOK).orderBy(BOOK.title.desc().nullsFirst()).select();
            expect(log.sql).toEqual('SELECT * FROM "Book" ORDER BY "Book"."title" IS NULL DESC, "Book"."title" DESC');
            await db.from(BOOK).orderBy(BOOK.title.desc().nullsLast()).select();
            expect(log.sql).toEqual('SELECT * FROM "Book" ORDER BY "Book"."title" IS NULL ASC, "Book"."title" DESC');
        }));

        it('multiple columns', sync(async () => {
            await db.from(BOOK).orderBy(BOOK.title, BOOK.author).select();
            expect(log.sql).toEqual('SELECT * FROM "Book" ORDER BY "Book"."title", "Book"."author"');
            await db.from(BOOK).orderBy(BOOK.title.asc().nullsFirst(), BOOK.author).select();
            expect(log.sql).toEqual('SELECT * FROM "Book" ORDER BY "Book"."title" IS NULL DESC, "Book"."title" ASC, "Book"."author"');
            await db.from(BOOK).orderBy(BOOK.title, BOOK.author.desc()).select();
            expect(log.sql).toEqual('SELECT * FROM "Book" ORDER BY "Book"."title", "Book"."author" DESC');
            await db.from(BOOK).orderBy(BOOK.title.asc().nullsFirst(), BOOK.author.desc().nullsLast()).select();
            expect(log.sql).toEqual('SELECT * FROM "Book" ORDER BY "Book"."title" IS NULL DESC, "Book"."title" ASC, "Book"."author" IS NULL ASC, "Book"."author" DESC');
        }));

        it('using modified columns', sync(async () => {
            await db.from(BOOK).orderBy(BOOK.title.lower()).select();
            expect(log.sql).toEqual('SELECT * FROM "Book" ORDER BY LOWER("Book"."title")');
            await db.from(BOOK).orderBy(BOOK.title.lower().desc().nullsFirst()).select();
            expect(log.sql).toEqual('SELECT * FROM "Book" ORDER BY LOWER("Book"."title") IS NULL DESC, LOWER("Book"."title") DESC');
            await db.from(BOOK).orderBy(BOOK.title.upper().asc(), BOOK.author).select();
            expect(log.sql).toEqual('SELECT * FROM "Book" ORDER BY UPPER("Book"."title") ASC, "Book"."author"');
        }));

        it('multiple tables', sync(async () => {
            await db.from(BOOK, ORDER).orderBy(BOOK.title, ORDER.quantity).select();
            expect(log.sql).toEqual('SELECT * FROM "Book", "Order" ORDER BY "Book"."title", "Order"."quantity"');
            await db.from(BOOK, ORDER).orderBy(BOOK.title.upper(), ORDER.quantity.asc(), BOOK.id.desc()).select();
            expect(log.sql).toEqual('SELECT * FROM "Book", "Order" ORDER BY UPPER("Book"."title"), "Order"."quantity" ASC, "Book"."id" DESC');
        }));
    });

}