Ecto: Support fragments in update

[mspanc]

Environment

• Elixir version (elixir -v): 1.2.1
• Database and version (PostgreSQL 9.4, MongoDB 3.2, etc.): 9.4.5
• Ecto version (mix deps): 1.1.8
• Database adapter and version (mix deps): postgrex 0.11.1
• Operating system: ubuntu 14.04
  

  Current behavior

There's no way to do the use more sophisticated DB features because there's no way to do the following

from(f in File, where: f.id == ^record.id)
  |> MyApp.Repo.update_all(set: [search_vector: fragment("to_tsvector('simple', coalesce(unaccent(?), ''))", keywords)])

Expected behavior

There's a way to pass fragment to the update.

[josevalim]

Which error do you get?

[mspanc]

AFAIR undefined function fragment

[michalmuskala]

That is because update_all is not a macro and does not allow for query syntax.

You can use that, though with update: keyword for from:

query =
  from f in File, where: f.id == ^record_id, update: [set: [foo: fragment("...")]]

Repo.update_all(query, [])

An example in the docs for that would be great!

[omidbachari]

I can handle this issue, if y'all give the go ahead. :-)

[josevalim]

Please go ahead :D

[omidbachari]

Ready for review, friends!

[josevalim]

:heart: :green_heart: :blue_heart: :yellow_heart: :purple_heart: