Working with Ecto

This page is in progress

Update all tables that contain a field with a chosen value

   def reset_testbeds do
    items = from t in TestBed, where: t.status == "Taken"
    Repo.update_all(items, set: [status: "Available", developer: "None"])
    |> broadcast_change([:testbed, :reset])
  end

IEX Commands (with example data)

Working with ECTO in IEX can be confusing. These examples below are performed with a table named Testbeds created using the Phoenix Generator. The functions references are in app/testbeds.ex where app is the name of your application and testbeds.ex is the name of your table.

Make sure you are aware of camel casing.

Get All

App.Testbeds.Testbed |> App.Repo.all

Insert

%App.Testbeds.Testbed{name: "some-item-name"} |> App.Repo.insert

References

https://brooklinmyers.medium.com/ecto-with-phoenix-in-4-minutes-9b7c447055c6