How to use raw sql with ecto Repo
I have an upsert requirement, so I need to call a postgres stored procedure or use a common table expression. I also use the pgcrypto exgtension for passwords and would like to use postgres functions (such as "crypt" to encode/decode passwords). But I can not find a way to get Ecto to play with raw sql in part or whole, is it intended that ecto will only support the elixir dsl and not allow shelli
elixir on phoenix ectoを使っていろいろなSELECT文 - Qiita
# = name = "TEST" User |> where([u], u.name == ^name) |> Repo.all() # SELECT u0.`id`, u0.`name`, u0.`age`, u0.`inserted_at`, u0.`updated_at` FROM `users` AS u0 WHERE (u0.`name` = ?) # ["TEST"] # != name = "TEST" User |> where([u], u.name != ^name) |> Repo.all() # SELECT u0.`id`, u0.`name`, u0.`age`, u0.`inserted_at`, u0.`updated_at` FROM `users` AS u0 WHERE (u0.`name` != ?) # ["TEST"] # > age = 20
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
処理を実行中です
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
EctoAutoslugField: Added Ecto 2 support
Ecto.Rut v1.2.0 Released - Ecto Shortcuts to make your Life easier!
Scoped Finds with Ecto in Phoenix
