sqlbuilder.dialect.sqlite

Undocumented in source.

Members

Aliases

Blob
alias Blob = const(ubyte)[]
Undocumented in source.
UntypedQuery
alias UntypedQuery = typeof(select())
Undocumented in source.
_impl
alias _impl = SQLImpl!(PType, param, true)
Undocumented in source.

Enums

dropTableSql
eponymoustemplate dropTableSql(T)
Undocumented in source.

Functions

as (from sqlbuilder.dialect.common)
ConcatDef as(ConcatDef col, string newName) via public import sqlbuilder.dialect.common : where, changed, limit, orderBy, groupBy, exprCol, as, withoutAs, concat, count, ascend, descend, Parameter, simplifyConditions;
Undocumented in source.
ascend (from sqlbuilder.dialect.common)
C ascend(C col) via public import sqlbuilder.dialect.common : where, changed, limit, orderBy, groupBy, exprCol, as, withoutAs, concat, count, ascend, descend, Parameter, simplifyConditions;
Undocumented in source.
changed (from sqlbuilder.dialect.common)
auto changed(DS ds) via public import sqlbuilder.dialect.common : where, changed, limit, orderBy, groupBy, exprCol, as, withoutAs, concat, count, ascend, descend, Parameter, simplifyConditions;
Undocumented in source.
concat (from sqlbuilder.dialect.common)
ConcatDef concat(Args args) via public import sqlbuilder.dialect.common : where, changed, limit, orderBy, groupBy, exprCol, as, withoutAs, concat, count, ascend, descend, Parameter, simplifyConditions;
Undocumented in source.
count (from sqlbuilder.dialect.common)
ColumnDef!long count(ColumnDef!T col) via public import sqlbuilder.dialect.common : where, changed, limit, orderBy, groupBy, exprCol, as, withoutAs, concat, count, ascend, descend, Parameter, simplifyConditions;
Undocumented in source.
create
T create(Database conn, T blueprint)
Undocumented in source. Be warned that the author may not have intended to support it.
descend (from sqlbuilder.dialect.common)
C descend(C col) via public import sqlbuilder.dialect.common : where, changed, limit, orderBy, groupBy, exprCol, as, withoutAs, concat, count, ascend, descend, Parameter, simplifyConditions;
Undocumented in source.
erase
bool erase(Database conn, T item)
Undocumented in source. Be warned that the author may not have intended to support it.
exprCol (from sqlbuilder.dialect.common)
ColumnDef!T exprCol(Args args) via public import sqlbuilder.dialect.common : where, changed, limit, orderBy, groupBy, exprCol, as, withoutAs, concat, count, ascend, descend, Parameter, simplifyConditions;
Undocumented in source.
fetch
auto fetch(Database conn, Query!(QD) q)
Undocumented in source. Be warned that the author may not have intended to support it.
fetchOne
auto fetchOne(Database conn, Query!(QD) q)
Undocumented in source. Be warned that the author may not have intended to support it.
fetchOne
auto fetchOne(Database conn, Query!(QD) q, T defaultValue)
Undocumented in source. Be warned that the author may not have intended to support it.
fetchTotal
long fetchTotal(Database conn, Query!(QP) q)
Undocumented in source. Be warned that the author may not have intended to support it.
fetchUsingKey
auto fetchUsingKey(Database conn, T defaultValue, Args args)
Undocumented in source. Be warned that the author may not have intended to support it.
getPType
PType getPType(Row r, size_t idx)
Undocumented in source. Be warned that the author may not have intended to support it.
groupBy (from sqlbuilder.dialect.common)
Q groupBy(Q query, Cols cols) via public import sqlbuilder.dialect.common : where, changed, limit, orderBy, groupBy, exprCol, as, withoutAs, concat, count, ascend, descend, Parameter, simplifyConditions;
Undocumented in source.
limit (from sqlbuilder.dialect.common)
Q limit(Q query, size_t numItems, size_t offset) via public import sqlbuilder.dialect.common : where, changed, limit, orderBy, groupBy, exprCol, as, withoutAs, concat, count, ascend, descend, Parameter, simplifyConditions;
Undocumented in source.
optional
auto optional(T val, bool isValid)
Undocumented in source. Be warned that the author may not have intended to support it.
orderBy (from sqlbuilder.dialect.common)
Q orderBy(Q query, Expr expressions) via public import sqlbuilder.dialect.common : where, changed, limit, orderBy, groupBy, exprCol, as, withoutAs, concat, count, ascend, descend, Parameter, simplifyConditions;
Undocumented in source.
param
auto param(T val)
Undocumented in source. Be warned that the author may not have intended to support it.
params
auto params(T t)
Undocumented in source. Be warned that the author may not have intended to support it.
perform
long perform(Database conn, Q stmt)
Undocumented in source. Be warned that the author may not have intended to support it.
save
bool save(Database conn, T item)
Undocumented in source. Be warned that the author may not have intended to support it.
simplifyConditions (from sqlbuilder.dialect.common)
Q simplifyConditions(Q query) via public import sqlbuilder.dialect.common : where, changed, limit, orderBy, groupBy, exprCol, as, withoutAs, concat, count, ascend, descend, Parameter, simplifyConditions;
Undocumented in source.
sql
string sql(Query!(QP) q)
Undocumented in source. Be warned that the author may not have intended to support it.
sql
string sql(Insert!Item ins)
Undocumented in source. Be warned that the author may not have intended to support it.
sql
string sql(Update!Item upd)
Undocumented in source. Be warned that the author may not have intended to support it.
sql
string sql(Delete!Item del)
Undocumented in source. Be warned that the author may not have intended to support it.
where (from sqlbuilder.dialect.common)
Q where(Q query, Spec spec) via public import sqlbuilder.dialect.common : where, changed, limit, orderBy, groupBy, exprCol, as, withoutAs, concat, count, ascend, descend, Parameter, simplifyConditions;
Undocumented in source.
withoutAs (from sqlbuilder.dialect.common)
T withoutAs(T col) via public import sqlbuilder.dialect.common : where, changed, limit, orderBy, groupBy, exprCol, as, withoutAs, concat, count, ascend, descend, Parameter, simplifyConditions;
Undocumented in source.

Structs

ChangeDeserializer
struct ChangeDeserializer(T)
Undocumented in source.
DefaultObjectDeserializer
struct DefaultObjectDeserializer(T)
Undocumented in source.
NonObjectDeserializer
struct NonObjectDeserializer(T)
Undocumented in source.
PType
struct PType
Undocumented in source.
Parameter (from sqlbuilder.dialect.common)
struct Parameter(T, bool hasValidation = false) via public import sqlbuilder.dialect.common : where, changed, limit, orderBy, groupBy, exprCol, as, withoutAs, concat, count, ascend, descend, Parameter, simplifyConditions;
Undocumented in source.

Templates

createTableSql
template createTableSql(T, bool doForeignKeys = false, bool ifNotExists = false)
Undocumented in source.
fetchUsingKey
template fetchUsingKey(T, bool throwOnExtraColumns = false)
Undocumented in source.

Meta