Working with Ecto: Difference between revisions

Latest revision as of 00:21, 7 October 2023

This page is in progress

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 referenced 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.

IEX Commands (with example data)

Get All

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

Insert

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

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

References

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

@@ Line 3: / Line 3: @@
+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 referenced 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.
+==IEX Commands (with example data)==
+===Get All ===
+<source>
+App.Testbeds.Testbed |> App.Repo.all
+</source>
+=== Insert ===
+<source>
+%App.Testbeds.Testbed{name: "some-item-name"} |> App.Repo.insert
+</source>
+==Update all tables that contain a field with a chosen value==
+<source>
+   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
+</source>
+==References==
 https://brooklinmyers.medium.com/ecto-with-phoenix-in-4-minutes-9b7c447055c6