hykw/tiny_ecto_helper_mysql

Tiny Ecto Helper for MySQL

TinyEctoHelperMySQL

This is Tiny Ecto Helper for MySQL. At the moment, this module has the following functions.

1. get columns lists in queryable
2. Issue query to MySQL with queryable AND SELECT SQL_CALC_FOUND_ROWS, then return the result and the count returned from SELECT FOUND_ROWS() like following:

SELECT id, title FROM foo LIMIT 10 OFFSET 5;
   |
   |
   |
SELECT SQL_CALC_FOUND_ROWS id1, title FROM foo LIMIT 10 OFFSET 5;
SELECT FOUND_ROWS()

Usage

• get columns lists in queryable

from(
  q in Question,
  select: {q.id, q.title, q.body}
) |> TinyEctoHelperMySQL.get_select_keys()
   |
   |
   |
[:id, :title, :body]

• Issue query to MySQL with queryable AND SELECT SQL_CALC_FOUND_ROWS, then return the result and the count returned from SELECT FOUND_ROWS() like following:

  query =
    from(
      q in Question,
      select: {q.id, q.title, q.body, q.user_id, q.inserted_at, q.updated_at},
      order_by: [asc: q.id]
    )

 {:ok, select_keys} = TinyEctoHelperMySQL.get_select_keys(query)
 TinyEctoHelperMySQL.query_and_found_rows(query, select_keys, [Repo, %Question{}, Question])
   |
   |
   |
{:ok, %{results: results, count: count}}

Installation

As available in Hex, the package can be installed by adding tiny_ecto_helper_mysql to your list of dependencies in mix.exs:

def deps do
  [
    {:tiny_ecto_helper_mysql, "~> 1.0.0"}
  ]
end

LICENSE

This software is released under the MIT License, see LICENSE.