ytnobody/ecto-select-count-groupby.exs

Created December 2, 2019 06:12

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ytnobody/abac5a34fa533e9185208e82c0dfb039.js"></script>
Save ytnobody/abac5a34fa533e9185208e82c0dfb039 to your computer and use it in GitHub Desktop.

Download ZIP

Revisions

ytnobody created this gist Dec 2, 2019.

ecto-select-count-groupby.exs

-Original file line number
+Diff line change
@@ -0,0 +1,5 @@
+    from(bookshelf in Bookshelf,
+      join: book in Book, on bookshelf.id == book.bookshelf_id,
+      group_by: bookshelf.id,
+      select: %{bookshelf_id: bookshelf.id, books_count: count(book.id)}
+    ) |> Repo.all()