Search⌘ K
AI Features
Home
Courses
Building Database Applications in Elixir with Ecto

Exercise: Use Ecto's Upsert Feature

Explore how to implement Ecto's upsert functionality to manage user data in your database. Learn to insert new records or update existing ones based on unique fields, ensuring your data upload scripts can be safely rerun without errors.

We'll cover the following...

Problem statement

In an earlier quiz, we defined a schema for a users table in our app.

Elixir
defmodule MusicDB.User do
  use Ecto.Schema
  schema "users" do
    field :username, :string
    field :first_name, :string
    field :last_name, :string
    field :email, :string
    field :password, :string
  end
end

We’d like to seed our database with a large CSV file with user data that was exported from another ...