Editing
Using Ecto for Database Interactions
(section)
Jump to navigation
Jump to search
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
== Querying the Database == With Ecto and the necessary modules set up, we can now perform database operations. Let's see some examples: * Fetch all users: ```elixir users = MyApp.Repo.all(MyApp.User) ``` * Find a user by ID: ```elixir user = MyApp.Repo.get(MyApp.User, 1) ``` * Create a new user: ```elixir changeset = MyApp.User.changeset(%MyApp.User{}, %{name: "John", age: 25}) MyApp.Repo.insert(changeset) ``` * Update a user: ```elixir user = MyApp.Repo.get(MyApp.User, 1) changeset = MyApp.User.changeset(user, %{age: 26}) MyApp.Repo.update(changeset) ``` * Delete a user: ```elixir user = MyApp.Repo.get(MyApp.User, 1) MyApp.Repo.delete(user) ``` These are just a few examples of what you can do with Ecto. Refer to the official Ecto documentation for more advanced queries and features.
Summary:
Please note that all contributions to Elixir Wiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see
Elixir Wiki:Copyrights
for details).
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)
Navigation menu
Personal tools
Not logged in
Talk
Contributions
Create account
Log in
Namespaces
Page
Discussion
English
Views
Read
Edit
View history
More
Navigation
Main page
Recent changes
Random page
Help about MediaWiki
Tools
What links here
Related changes
Special pages
Page information