Skip to content

Ecto fragment() with named or inline params instead of just ?'s

License

Notifications You must be signed in to change notification settings

tessi/ecto_fragment_extras

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

EctoFragmentExtras

EctoFragmentExtras is a collection of extensions to enhance Ecto's fragment() macro.

It adds the following fragment variants which are all macros compiling into regular ecto fragments:

  • named_fragment("coalesce(#{:name}, #{:default})", name: user.name, default: ^default_name)
  • inline_fragment("coalesce(#{user.name}, #{^default_name})")

Installation

Add ecto_fragment_extras to your list of dependencies in mix.exs:

def deps do
  [{:ecto_fragment_extras, "~> 0.3.0"}]
end

Usage

Fragments with named params

Instead of using Ectos fragment with ?-based interpolation, named_fragment allows you to use named params in your fragments.

named_fragment is implemented as a macro on top of Ecto's fragment macro.

So named_fragment("coalesce(#{:a}, #{:b}, #{:a})", a: 1, b: 2) will be converted to fragment("coalesce(?, ?, ?)", 1, 2, 1) at compile-time.

defmodule TestQuery do
  import Ecto.Query
  import EctoFragmentExtras

  def test_query do
    query = from u in "users",
            select: named_fragment("coalesce(#{:left}, #{:right})", left: "example", right: "input")

    Repo.all(query)
  end
end

TODO (removed before release)

  • ~FRAG("FOO(?{table.a}, ?{^other})") alias ~FRAGMENT
  • remove old hex package, publish new one
  • docs, readme, changelog

License

The entire project is under the MIT License. Please read the LICENSE file.

Licensing

Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in the work by you, shall be licensed as above, without any additional terms or conditions.

About

Ecto fragment() with named or inline params instead of just ?'s

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages