Test adapter that records every executed query and returns configurable responses. No running Sphinx/Manticore instance is required.

Setup

Start the sandbox in test/test_helper.exs:

Giza.QueryAdapter.Sandbox.start_link()
ExUnit.start()

And configure it in config/test.exs:

config :giza_sphinxsearch, :query_adapter, Giza.QueryAdapter.Sandbox

Usage in tests

setup do
  Giza.QueryAdapter.Sandbox.reset()
  :ok
end

test "my query" do
  # default response is {:ok, %{columns: [], rows: [], num_rows: 0}}
  {:ok, _} = SearchTables.create_table("t", "title text")

  assert Sandbox.last_query() == "CREATE TABLE t (title text)"
  assert length(Sandbox.queries()) == 1
end

Custom responses

# Static response for all queries
Sandbox.set_response({:ok, %{columns: ["id"], rows: [[1]], num_rows: 1}})

# Function response — inspect the SQL to decide what to return
Sandbox.set_response({:fn, fn
  "DESCRIBE" <> _ -> {:ok, %{columns: ["Field", "Type"], rows: [["title", "text"]], num_rows: 1}}
  _ -> {:ok, %{columns: [], rows: [], num_rows: 0}}
end})

# Simulate an error
Sandbox.set_response({:error, %{mariadb: %{message: "table not found"}}})