abstract class Focus::SelectStatement

Direct Known Subclasses

Defined in:

focus/statements/select_statement.cr

Constructors

Instance Method Summary

Instance methods inherited from class Focus::Statement

accept(visitor : Focus::SqlVisitor) : Nil accept, dialect : Focus::Dialect dialect, ordered_clauses : Array(Focus::Clause) ordered_clauses, statement_type : Focus::SqlFormatter::StatementType statement_type, to_sql to_sql, to_sql_with_args : Tuple(String, Array(DB::Any)) to_sql_with_args

Instance methods inherited from module Focus::Queryable

exec(database : Focus::DBConn) : DB::ExecResult exec, query(database : Focus::DBConn) : DB::ResultSet query, query_all(database : Focus::DBConn, as types : Tuple)
query_all(database : Focus::DBConn, as types : NamedTuple)
query_all(database : Focus::DBConn, as types : Class) query_all, query_one(database : Focus::DBConn, as types : Tuple)
query_one(database : Focus::DBConn, as type : NamedTuple)
query_one(database : Focus::DBConn, as : T.class) : T forall T query_one, query_one?(database : Focus::DBConn, as type : Tuple)
query_one?(database : Focus::DBConn, as type : NamedTuple)
query_one?(database : Focus::DBConn, as : T.class) : T | Nil forall T query_one?, to_sql_with_args : Tuple(String, Array(DB::Any)) to_sql_with_args

Constructor Detail

def self.new(select_clause : Focus::SelectClause) #

[View source]

Instance Method Detail

def aliased(label : String) : Focus::SelectTable #

[View source]
def as_cte(label : String) : Focus::CommonTableExpression #

[View source]
def distinct : self #

[View source]
def from(table : Focus::ReadableTable) : self #

[View source]
def from_clause : Focus::FromClause | Nil #

[View source]
def from_clause=(from_clause : Focus::FromClause | Nil) #

[View source]
def group_by(*columns : Focus::Column) : self #

[View source]
def group_by_clause : Focus::GroupByClause | Nil #

[View source]
def group_by_clause=(group_by_clause : Focus::GroupByClause | Nil) #

[View source]
def having(expression : Focus::BoolExpression) : self #

[View source]
def having_clause : Focus::HavingClause | Nil #

[View source]
def having_clause=(having_clause : Focus::HavingClause | Nil) #

[View source]
def limit(limit : Int32) : self #

[View source]
def limit_clause : Focus::LimitClause | Nil #

[View source]
def limit_clause=(limit_clause : Focus::LimitClause | Nil) #

[View source]
def offset(offset : Int32) : self #

[View source]
def offset_clause : Focus::OffsetClause | Nil #

[View source]
def offset_clause=(offset_clause : Focus::OffsetClause | Nil) #

[View source]
def order_by(*clauses : Focus::OrderByClause) : self #

[View source]
def order_by_clauses : Focus::OrderByListClause | Nil #

[View source]
def order_by_clauses=(order_by_clauses : Focus::OrderByListClause | Nil) #

[View source]
def ordered_clauses : Array(Focus::Clause) #

[View source]
def select_clause : Focus::SelectClause #

[View source]
def statement_type : Focus::SqlFormatter::StatementType #

[View source]
def where(expression : Focus::BoolExpression) : self #

[View source]
def where_clause : Focus::WhereClause | Nil #

[View source]
def where_clause=(where_clause : Focus::WhereClause | Nil) #

[View source]