Sphinxex

Usage

Add Sphinxex as a dependency in your mix.exs file.

def deps do
  [{:sphinxex, "~> 0.7.3"} ]
end

After you are done, run mix deps.get in your shell to fetch and compile Sphinxex. Start an interactive Elixir shell with iex -S mix.

  iex(1)> {:ok, p} = Sphinxex.start_link(username: "ecto", database: "ecto_test")
  {:ok, #PID<0.108.0>}

  iex(2)> Sphinxex.query(p, "CREATE TABLE test1 (id serial, title text)")
  {:ok, %Sphinxex.Result{columns: [], command: :create, num_rows: 0, rows: []}}

  iex(3)> Sphinxex.query(p, "INSERT INTO test1 VALUES(1, 'test')")
  {:ok, %Sphinxex.Result{columns: [], command: :insert, num_rows: 1, rows: []}}

  iex(4)> Sphinxex.query(p, "INSERT INTO test1 VALUES(2, 'test2')")
  {:ok, %Sphinxex.Result{columns: [], command: :insert, num_rows: 1, rows: []}}

  iex(5)> Sphinxex.query(p, "SELECT id, title FROM test1")
  {:ok,
   %Sphinxex.Result{columns: ["id", "title"], command: :select, num_rows: 2,
    rows: [{1, "test"}, {2, "test2"}]}}

Configuration

Important configuration, which depends on used charset for support unicode chars, see :binary_as in Sphinxex.start_link/1