Crecto::Repo::Query
Last updated 2 months ago
Contents
The Query class provides building robust composable query builder for retrieving and manipulate data.
Generally (but not necessary), its easiest to define a shortcut variable at the top level of your application.
Query = Crecto::Repo::Query
The query object can be composed and manipulated before being used.
query = Query.newquery = query.where(is_admin: true) if role === "admin"query = query.where(is_user: true) if role === "user"Repo.all(User, query)
Query.where(name: "Aaliyah").where(is_admin: false)
Query.where(role: "admin").or_where(role: "user")
Query.select(["id", "name"])
Query.where(name: "Usher").limit(10)
Query.where(name: "Aretha").limit(10).offset(10)
Query.order_by("created_at DESC")
# SELECT * FROM users INNER JOIN user_tags ON user_tags.user_id = users.id# WHERE user_tags.tag_name = ?query = Query.join(:images).where("user_tags.tag_name = ?", "crystal")Repo.all(User, query)
Query.distinct("users.name")
Query.where(name: "Charlize").join(:posts).group_by("users.id")
Query.preload(:images)