Instance methods inherited from class DBX::QueryBuilder

add_arg(value) : String add_arg, add_args_and_fields_from_data(data : NamedTuple | Hash, sep = ", ") : String
add_args_and_fields_from_data(data : Array, sep = ", ") : String add_args_and_fields_from_data, add_args_and_kv_from_data(data : NamedTuple | Hash, sep = ", ") : String add_args_and_kv_from_data, alter(table : OneOrMoreFieldsType, command : String, field : String, data_type = "") : QueryBuilder
alter(command : String, field : String, data_type = "") : QueryBuilder alter, analyze(table : OneOrMoreFieldsType) : QueryBuilder
analyze : QueryBuilder analyze, avg(field : FieldType, name = nil) : QueryBuilder avg, between(field : FieldType, value1, value2, type = "", and_or = "AND") : QueryBuilder between, build : SQLandArgsType build, check : QueryBuilder
check(table : OneOrMoreFieldsType) : QueryBuilder check, checksum : QueryBuilder
checksum(table : OneOrMoreFieldsType) : QueryBuilder checksum, count(field : FieldType, name = nil) : QueryBuilder count, delete : QueryBuilder
delete(table : OneOrMoreFieldsType) : QueryBuilder
delete(pk_name, pk_value) : QueryBuilder delete, drop(table : OneOrMoreFieldsType, check_exists = true) : QueryBuilder
drop(check_exists = true) : QueryBuilder drop, find(pk_name, pk_value) : QueryBuilder
find : QueryBuilder
find(&) : QueryBuilder
find(table_name : OneOrMoreFieldsType) : QueryBuilder find, full_join(table : FieldType, field1 : FieldType, field2 : FieldType? = nil) : QueryBuilder full_join, full_outer_join(table : FieldType, field1 : FieldType, field2 : FieldType? = nil) : QueryBuilder full_outer_join, group_by(field : OneOrMoreFieldsType) : QueryBuilder group_by, having(&) : QueryBuilder
having(field : FieldType, op_or_val, value = nil) : QueryBuilder having, in(field : FieldType, values : Array | Tuple, type = "", and_or = "AND") : QueryBuilder in, inner_join(table : FieldType, field1 : FieldType, field2 : FieldType? = nil) : QueryBuilder inner_join, insert(data : Hash | NamedTuple) : QueryBuilder
insert(table : OneOrMoreFieldsType, data : Hash | NamedTuple) : QueryBuilder insert, join(table : FieldType, field1 : FieldType, field2 : FieldType? = nil, type = "") : QueryBuilder
join(&) : QueryBuilder
join : String join, last_query : String last_query, last_query_method : Symbol? last_query_method, left_join(table : FieldType, field1 : FieldType, field2 : FieldType? = nil) : QueryBuilder left_join, left_outer_join(table : FieldType, field1 : FieldType, field2 : FieldType? = nil) : QueryBuilder left_outer_join, like(field : FieldType, value, type = "", and_or = "AND") : QueryBuilder like, limit : String
limit(limit, limit_end = nil) : QueryBuilder limit, max(field : FieldType, name = nil) : QueryBuilder max, min(field : FieldType, name = nil) : QueryBuilder min, not_between(field : FieldType, value1, value2) : QueryBuilder not_between, not_in(field : FieldType, values : Array | Tuple) : QueryBuilder not_in, not_like(field : FieldType, value) : QueryBuilder not_like, not_where(field : FieldType, op_or_val, value = nil) : QueryBuilder not_where, offset(offset) : QueryBuilder
offset : String offset, optimize(table : OneOrMoreFieldsType) : QueryBuilder
optimize : QueryBuilder optimize, or_between(field : FieldType, value1, value2) : QueryBuilder or_between, or_in(field : FieldType, values : Array | Tuple) : QueryBuilder or_in, or_like(field : FieldType, value) : QueryBuilder or_like, or_not_between(field : FieldType, value1, value2) : QueryBuilder or_not_between, or_not_in(field : FieldType, values : Array | Tuple) : QueryBuilder or_not_in, or_not_like(field : FieldType, value) : QueryBuilder or_not_like, or_not_where(field : FieldType, op_or_val, value = nil) : QueryBuilder or_not_where, or_where(field : FieldType, op_or_val, value = nil) : QueryBuilder or_where, order_by(field : FieldType, dir = nil) : QueryBuilder order_by, paginate(per_page, page) : QueryBuilder paginate, ph(position : Int) : String ph, query(&) : QueryBuilder query, query_count : Int query_count, query_method : Symbol? query_method, quote(field : FieldType) : String quote, repair : QueryBuilder
repair(table : OneOrMoreFieldsType) : QueryBuilder repair, reset_query reset_query, returning(*name : FieldType) : QueryBuilder
returning : String?
returning(fields : OneOrMoreFieldsType) : QueryBuilder returning, right_join(table : FieldType, field1 : FieldType, field2 : FieldType? = nil) : QueryBuilder right_join, right_outer_join(table : FieldType, field1 : FieldType, field2 : FieldType? = nil) : QueryBuilder right_outer_join, select(fields : OneOrMoreFieldsType) : QueryBuilder
select : String
select(*name : FieldType) : QueryBuilder select, sum(field : FieldType, name = nil) : QueryBuilder sum, table(&) : QueryBuilder
table(*name : FieldType) : QueryBuilder
table : String
table(name : OneOrMoreFieldsType) : QueryBuilder table, to_data_h(data : Hash | NamedTuple) : DataHashType to_data_h, update(data : Hash | NamedTuple) : QueryBuilder
update(table : OneOrMoreFieldsType, data : Hash | NamedTuple) : QueryBuilder
update(pk_name, pk_value, data : Hash | NamedTuple) : QueryBuilder update, where(field : FieldType, op_or_val, value = nil, type = "", and_or = "AND") : QueryBuilder
where(&) : QueryBuilder where

Constructor methods inherited from class DBX::QueryBuilder

new new