ecto_elixir_quickstart_repo_schema_insert_query.ex

1# 1. Define the Repository
2defmodule Friends.Repo do
3  use Ecto.Repo,
4    otp_app: :friends,
5    adapter: Ecto.Adapters.Postgres
6end
7
8# 2. Define the Schema
9defmodule Friends.Person do
10  use Ecto.Schema
11
12  schema "people" do
13    field :name, :string
14    field :age, :integer
15  end
16end
17
18# 3. Usage Example (Insert and Query)
19import Ecto.Query
20
21# Start the Repo (usually done in the application supervision tree)
22{:ok, _} = Friends.Repo.start_link(
23  database: "friends_repo",
24  username: "postgres",
25  password: "postgres",
26  hostname: "localhost"
27)
28
29# Create a struct and insert it
30person = %Friends.Person{name: "Ryan", age: 30}
31Friends.Repo.insert!(person)
32
33# Fetch all people from the database
34people = Friends.Repo.all(Friends.Person)
35
36# Query with conditions
37query = from p in Friends.Person, where: p.age > 25
38results = Friends.Repo.all(query)
39
40IO.inspect(results)