import * as sd from "type-mapping";
import * as tape from "tape";
import * as o from "../../../../dist/src/main";
import {pool} from "../../pool";

tape(__filename, async (t) => {
    const result = await pool.acquire(async (connection) => {
        await connection.rawQuery("DROP TEMPORARY TABLE IF EXISTS bigintTable");
        await connection.rawQuery(`
            CREATE TEMPORARY TABLE bigintTable (
                value BIGINT NOT NULL,
                other VARCHAR(255),
                other2 VARCHAR(255)
            )
        `);
        const bigintTable = o.table(
            "bigintTable",
            {
                value : sd.or(
                    sd.finiteNumberToFiniteNumberString(),
                    sd.string()
                ),
                other : sd.string(),
                other2 : sd.string(),
            }
        ).addCandidateKey(c => [c.value]);
        await bigintTable.insert(connection, { value : "32", other : "hello", other2 : "goodbye" });
        await bigintTable.insert(connection, { value : "33", other : "world", other2 : "all" });
        return bigintTable.fetchOneBySk(
            connection,
            { value : "33", other : "world" },
            c => [c.other2]
        );
    });
    t.deepEqual(result, { other2 : "all" });

    t.end();
});