abstract class Jennifer::Adapter::BaseSQLGenerator
- Jennifer::Adapter::BaseSQLGenerator
- Reference
- Object
Extended Modules
Direct Known Subclasses
Defined in:
jennifer/adapter/base_sql_generator.crClass Method Summary
- .body_section(io : String::Builder, query)
- .bulk_insert(table : String, field_names : Array(String), rows : Int32)
- .bulk_insert(table : String, field_names : Array(String), rows : Array)
-
.cast_expression(expression, type : String)
Returns
CASTexpression. - .count(query)
- .delete(query)
- .exists(query)
- .explain(query)
-
.from_clause(io : String::Builder, from : String)
FROMclause for quoted table from -
.from_clause(io : String::Builder, query)
Generates
FROMquery clause. -
.group_clause(io : String::Builder, query)
Generates
GROUP BYquery clause. -
.having_clause(io : String::Builder, query)
Generates
HAVINGquery clause. -
.insert(table, hash)
Generates insert query
-
.join_clause(io : String::Builder, query)
Generates
JOINquery clause. -
.limit_clause(io : String::Builder, query)
Generates
LIMITclause. - .lock_clause(io : String::Builder, query)
- .modify(q, modifications : Hash)
-
.operator_to_sql(operator : Symbol)
Converts operator to SQL.
-
.order_clause(io : String::Builder, query)
Generates
ORDER BYclause. - .order_expression(expression : QueryBuilder::OrderExpression)
- .parse_query(query : String, args : Array(DBAny))
-
.select(query, exact_fields : Array = [] of String)
Generates common select SQL request
-
.select_clause(io : String::Builder, query, exact_fields : Array = [] of String)
Generates
SELECTquery clause. - .truncate(table : String)
- .union_clause(io : String::Builder, query)
- .update(query, options : Hash)
- .update(obj : Model::Base)
-
.where_clause(io : String::Builder, query : QueryBuilder::Query | QueryBuilder::ModelQuery)
Generates
WHEREquery clause. -
.where_clause(io : String::Builder, tree)
Generates
WHEREquery clause. -
.with_clause(io : String::Builder, query)
Generates
WITHclause.
Class Method Detail
Generates common select SQL request
Generates SELECT query clause.
def self.where_clause(io : String::Builder, query : QueryBuilder::Query | QueryBuilder::ModelQuery)
#
Generates WHERE query clause.