module

Granite::Querying::ClassMethods

Instance methods

all(clause = "", params = [] of Granite::Columns::Type, use_primary_adapter = true)

All will return all rows in the database. The clause allows you to specify a WHERE, JOIN, GROUP BY, ORDER BY and any other SQL92 compatible query to your table. The result will be a Collection(Model) object which lazy loads an array of instantiated instances of your Model class. This allows you to take full advantage of the database that you are using so you are not restricted or dummied down to support a DSL. Lazy load prevent running unnecessary queries from unused variables.

count

count returns a count of all the records

exec(clause = "")

exists?(id : Number | String | Nil) : Bool

Returns true if a records exists with a PK of id, otherwise false.

exists?(criteria : Granite::ModelArgs) : Bool

Returns true if a records exists that matches criteria, otherwise false.

exists?

Returns true if a records exists that matches criteria, otherwise false.

find(value)

find returns the row with the primary key specified. Otherwise nil.

find!(value)

find returns the row with the primary key specified. Otherwise raises an exception.

find_by(criteria : Granite::ModelArgs)

Returns the first row found that matches criteria. Otherwise nil.

find_by

Returns the first row found that matches criteria. Otherwise nil.

find_by!(criteria : Granite::ModelArgs)

Returns the first row found that matches criteria. Otherwise raises a NotFound exception.

find_by!

Returns the first row found that matches criteria. Otherwise raises a NotFound exception.

find_each(clause = "", params = [] of Granite::Columns::Type, batch_size limit = 100, offset = 0, &)

find_in_batches(clause = "", params = [] of Granite::Columns::Type, batch_size limit = 100, offset = 0, &)

first(clause = "", params = [] of Granite::Columns::Type)

First adds a LIMIT 1 clause to the query and returns the first result

first!(clause = "", params = [] of Granite::Columns::Type)

from_rs(result : DB::ResultSet) : self

Entrypoint for creating a new object from a result set.

query(clause = "", params = [] of Granite::Columns::Type, &)

raw_all(clause = "", params = [] of Granite::Columns::Type)

scalar(clause = "", &)