import { Sql } from "../../Sql";
import { Select } from "../Select";

describe("Select.fromSubQuery.spec.ts: select ... from (...)", () => {

    it("valid inputs", () => {

        Sql.assertNode(Select, {
            input: "select id from (select 1 as id) as tmp",
            shouldBe: {
                json: {
                    select: [
                        {expression: {
                            column: [
                                {name: "id"}
                            ]
                        }}
                    ],
                    from: [{
                        subQuery: {
                            select: [
                                {
                                    expression: {number: "1"},
                                    as: {name: "id"}
                                }
                            ],
                            from: []
                        },
                        as: {name: "tmp"}
                    }]
                },
                pretty: [
                    "select",
                    "    id",
                    "from (",
                    "    select",
                    "        1 as id",
                    ") as tmp"
                ].join("\n"),
                minify: "select id from(select 1 as id)as tmp"
            }
        });

        Sql.assertNode(Select, {
            input: "select from (select) tmp",
            shouldBe: {
                json: {
                    select: [],
                    from: [{
                        subQuery: {
                            select: [],
                            from: []
                        },
                        as: {name: "tmp"}
                    }]
                },
                pretty: [
                    "select",
                    "from (",
                    "    select",
                    ") as tmp"
                ].join("\n"),
                minify: "select from(select)as tmp"
            }
        });

        Sql.assertNode(Select, {
            input: "select from (select) tmp right join users on true",
            shouldBe: {
                json: {
                    select: [],
                    from: [{
                        subQuery: {
                            select: [],
                            from: []
                        },
                        as: {name: "tmp"},
                        joins: [{
                            type: "right join",
                            from: {table: {
                                name: {name: "users"}
                            }},
                            on: {boolean: true}
                        }]
                    }]
                },
                pretty: [
                    "select",
                    "from (",
                    "    select",
                    ") as tmp",
                    "",
                    "right join users on",
                    "    true"
                ].join("\n"),
                minify: "select from(select)as tmp right join users on true"
            }
        });

        Sql.assertNode(Select, {
            input: "select from lateral (select)tmp",
            shouldBe: {
                json: {
                    select: [],
                    from: [{
                        lateral: true,
                        subQuery: {
                            select: [],
                            from: []
                        },
                        as: {name: "tmp"}
                    }]
                },
                pretty: [
                    "select",
                    "from lateral (",
                    "    select",
                    ") as tmp"
                ].join("\n"),
                minify: "select from lateral(select)as tmp"
            }
        });

        Sql.assertNode(Select, {
            input: "select from lateral (select 1)tmp(y)",
            shouldBe: {
                json: {
                    select: [],
                    from: [{
                        lateral: true,
                        subQuery: {
                            select: [{
                                expression: {number: "1"}
                            }],
                            from: []
                        },
                        as: {name: "tmp"},
                        columnAliases: [
                            {name: "y"}
                        ]
                    }]
                },
                pretty: [
                    "select",
                    "from lateral (",
                    "    select",
                    "        1",
                    ") as tmp(y)"
                ].join("\n"),
                minify: "select from lateral(select 1)as tmp(y)"
            }
        });

        Sql.assertNode(Select, {
            input: "select from ( ( ( select ) ) ) tmp",
            shouldBe: {
                json: {
                    select: [],
                    from: [{
                        subQuery: {
                            select: [],
                            from: []
                        },
                        as: {name: "tmp"}
                    }]
                },
                pretty: [
                    "select",
                    "from (",
                    "    select",
                    ") as tmp"
                ].join("\n"),
                minify: "select from(select)as tmp"
            }
        });

    });

    it("invalid inputs", () => {

        Sql.assertNode(Select, {
            input: "select from (select)",
            throws: /subquery in FROM must have an alias/
        });

    });

});