Has anyone had success with getting Ecto to use externally generated migration files? I have a directory of SQL files that I would like to migrate for my unit tests but loading each migration and executing it is causing problems with Postgres prepared statements due to multiple commands being in each SQL migration. My code to load the migrations is:

  def up do
    Path.wildcard("priv/repo/migrations/hasura/**/up.sql")
    |> Enum.each(fn sql_file ->
      sql = File.read!(sql_file)
      execute("BEGIN; #{sql} COMMIT;")
    end)
  end

However, this gives me the error: cannot insert multiple commands into a prepared statement.

I’ve played around with the Ecto config (setting prepare: :unnamed) and wrapping each of the migration files in a BEGIN / COMMIT block (i.e. a transaction) without any luck.

I’ve resorted to using Mox to mock my Repo which works ok but I would like to test against the actual database.