johan-- · August 20, 2024 07:35 · Sep 29, 2016
diff --git a/find_or_create.exs b/find_or_create.exs
@@ -0,0 +1,21 @@
+# two different ways to implement a find_or_create for Ecto
+
+find_or_create_user = fn user ->
+  case Repo.all(from u in users, where: u.id == ^user.id and u.email == ^user.email) do
+    [] ->
+      %User{}
+      |> User.changeset(user)
+      |> Repo.insert!()
+    _ ->
+      IO.puts "Already inserted"
+  end
+end
+
+def find_or_create(user) do
+  query = from u in users,
+          where: u.uid == ^user.uid
+  if !Repo.one(query)  do
+    Repo.insert(user)
+  end
+  Repo.one(query)
+end