siddhant3030
Hi,
I have to write a raw query for one of my project. But till now I have used ecto queries and don’t have much experience writing raw queries in phoenix. So to understand
I have created a user schema that inserts an email in a database table.
So created the changeset the like this
def changeset(user, attrs) do
user
|> cast(attrs, [:email, :password])
end
Now I have a create function that I’m using in my model. So the model will basically talk to db.
def create_user(attrs \\ %{}) do
%User{}
|> User.changeset(attrs)
|> Repo.insert()
end
I have inserted an email in my database. using this
iex(1) > user = User.changeset(%User{}, %{email: “”, password: “”})
Now what I want is to find that user by his email address.
Also If I wanted to fetch through id. I would just do this
def get_user!(id), do: Repo.get!(User, id)
But what if I want to write a raw query? How do I do that?
Where Next?
Trending in Questions
Other Trending Topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Phoenix, LiveView, multimedia pipelines, distributed systems. 400 engineers, Elixir since 2017. Available for hire.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #blog-post
- #phoenix_html
- #iex
- #graphql
- #genstage
- #ai
- #elixirconf-us
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #hex
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
Enabling companies to succeed by building software people love.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
First 10 of 20 Posts
benwilson512
The best place to start is always the docs. Hint: it’s a function inside this module Ecto.Repo — Ecto v3.14.0
kokolegorille
You might also have a look at…
…for raw queries
benwilson512
Ah yeah, I’m realizing my post wasn’t super helpful because
, it’s just added inside repos that actually use SQL adapters. That’s unfortunate.
query!isn’t actually in the Repo docssiddhant3030
Thanks. This is helpful
al2o3cr
FWIW, you can do this with
Repo.get_by(User, email: email_to_find).lucaong
In case you are exercising raw SQL for learning, you can also directly use the
psqlcommand line client for Postgres (assuming that is your database of choice), and directly type SQL in the console.siddhant3030
Thanks
siddhant3030
Can anyone show me some project where sql raw
query is being used heavily. Not ecto queries
siddhant3030
Hi @kokolegorille
I’m confused about this. Because the database I’m querying is in postgres. But I want to write a raw sql query. Now phoenix comes with Postgres by default. So should I move my table to SQL Database in order to use raw queries ?
sribe
That makes no sense–if your table is not in a SQL database you can’t query with raw queries. I suspect you mean something else, but I can’t figure out what you’re asking…