import { FragmentToken } from "../../tokens.js";
import { createSqlTag } from "../createSqlTag.js";
import test from "ava";

const sql = createSqlTag();

test("binds a timestamp", (t) => {
  const query = sql.fragment`SELECT ${sql.timestamp(new Date("2022-08-19T03:27:24.951Z"))}`;

  t.deepEqual(query, {
    sql: "SELECT to_timestamp($slonik_1)",
    type: FragmentToken,
    values: ["1660879644.951"],
  });
});

test("throws if not instance of Date", (t) => {
  const error = t.throws(() => {
    // @ts-expect-error - intentional
    sql.fragment`SELECT ${sql.timestamp(1)}`;
  });

  t.is(error?.message, "Timestamp parameter value must be an instance of Date.");
});