WestKeys
Programming Phoenix 1.4, Writing Queries with Keyword Syntax
In Chapter 7 - Diving Deeper into Ecto Queries - Writing Queries with Keyword Syntax, we have:
Repo.one from u in User,
select: count(u.id),
where: ilike(u.username, "j%") or
ilike(u.username, "c%")
Is there any reason in particular we are using count(u.id) rather than count(u)?
First Post!
cenotaph
basically 1:1 translation from SQL
When you work with multiple tables you need to shorthand them to specify the table if you don’t want to write the full name every time.
select u.* from users u;
translated here with really useful scopes
edit: let me get into details count(u) would ask to count instances of users table in sql, such statement doesn’t exist in SQL of course.
Popular in Questions
Other popular topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Supporting innovation across the BEAM ecosystem.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"