defmodule Moebius.SQLFileTest do
  use ExUnit.Case
  import Moebius.Query

  test "a single file is loaded" do
    cmd = sql_file_command(:simple, 1)
    assert cmd.sql == "select * from users where id=$1;"
    assert length(cmd.params) == 1
  end

  test "a cte can be loaded and run" do
    assert {:ok, %{email: "blurgg@test.com", id: _id}} =
             sql_file(:cte, "blurgg@test.com")
             |> TestDb.first()
  end
end