|
|
template<typename T > |
| int | readColumn (bool strict, int i, T &&value) |
| |
|
int | readColumn (bool strict, int i, qint8 &value) |
| |
|
int | readColumn (bool strict, int i, quint8 &value) |
| |
|
int | readColumn (bool strict, int i, qint16 &value) |
| |
|
int | readColumn (bool strict, int i, quint16 &value) |
| |
|
int | readColumn (bool strict, int i, qint32 &value) |
| |
|
int | readColumn (bool strict, int i, quint32 &value) |
| |
|
int | readColumn (bool strict, int i, qint64 &value) |
| |
|
int | readColumn (bool strict, int i, quint64 &value) |
| |
|
int | readColumn (bool strict, int i, double &value) |
| |
|
int | readColumn (bool strict, int i, float &value) |
| |
|
int | readColumn (bool strict, int i, QString &value) |
| |
|
int | readColumn (bool strict, int i, Blob &value) |
| |
|
int | readColumn (bool strict, int i, QByteArray &value) |
| |
|
int | readColumn (bool, int i, Value &result) |
| |
|
template<class T > |
| int | readColumn (bool strict, int i, std::optional< T > &result) |
| |
|
template<class ... T> |
| int | readColumn (bool strict, int i, Call< T... > &call) |
| |
|
template<class ... T> |
| int | readColumn (bool strict, int i, Call< T... > &&call) |
| |
|
template<class ... T> |
| int | readColumn (bool strict, int i, const Call< T... > &call) |
| |
|
template<unsigned I> |
| constexpr int | readColumn (bool, int, const Helper::UnusedColumns< I > &) |
| |
|
template<unsigned I> |
| constexpr int | readColumn (bool, int, Helper::UnusedColumns< I > &) |
| |
|
template<unsigned I> |
| constexpr int | readColumn (bool, int, Helper::UnusedColumns< I > &&) |
| |
|
template<class ... Args> |
| int | readColumn (bool strict, int i, const std::tuple< Args... > &values) |
| |
|
template<class ... Args> |
| int | readColumn (bool strict, int i, std::tuple< Args... > &values) |
| |
|
template<class ... Args> |
| int | readColumn (bool strict, int i, std::tuple< Args... > &&values) |
| |
|
template<class ... Args, int ... Index> |
| int | readColumnHelper (bool strict, int i, std::tuple< Args... > &&values, Helper::int_sequence< Index... > seq) |
| |
|
template<class ... Args, int ... Index> |
| int | readColumnHelper (bool strict, int i, const std::tuple< Args... > &values, Helper::int_sequence< Index... >) |
| |
|
template<class ... Args, int ... Index> |
| int | readColumnHelper (bool strict, int i, std::tuple< Args... > &values, Helper::int_sequence< Index... > seq) |
| |
|
int | readColumnInternal (int i, Blob &value, bool strict) |
| |
|
int | clearBindingInternal () |
| |
|
template<typename T > |
| bool | bindTemporary (int i, const T &v) |
| |
|
template<typename T , typename... Args> |
| bool | bindTemporary (int i, const T &v, const Args &...args) |
| |
|
void | resetInternalError () |
| |
|
void | setInternalError (int code, const char *explicitMessag=nullptr) |
| |
|
| | Query (Db *db, const char *query, bool persistent=false, bool storeErrorMsg=false, const char **tail=nullptr) |
| | Construct a query prepared from a string. More...
|
| |
| | Query (Db *db, const QString &query, bool persistent=false, bool storeErrorMsg=false, QString *tail=nullptr) |
| | Construct a query from a QString. More...
|
| |
| | Query (Db *db=nullptr, bool storeErrorMsg=true) |
| | Construct a non prepared query. More...
|
| |
|
| Query (const Query &)=delete |
| |
|
| bool | prepare (const QString &query, bool persistent=true, QString *tail=nullptr) |
| | Prepares a query. More...
|
| |
| bool | prepare (const char *query, bool persistent=true, const char **tail=nullptr) |
| | Prepares a query. More...
|
| |
| bool | stepNoFetch () |
| | Move to next row in a query but do not fetch any data. More...
|
| |
| bool | reset () |
| | Resets the query. More...
|
| |
| bool | clearBindings () |
| | Clear the bounded values of a query. More...
|
| |
| bool | finalize () |
| | Finalizes a query. Query will have to be prepared again before being able to execute it again. More...
|
| |
| int | error (QString *errorMsg=nullptr) |
| | Returns the SQLite error code of last function. More...
|
| |
| bool | isOk () |
| | Checks if last function call was sucessfull. More...
|
| |
| bool | isDone () |
| | Checks if last function call was the last step of a query. More...
|
| |
| QString | errorMsg () const |
| | Gets the error message string. More...
|
| |
| bool | isPrepared () |
| | Check if the query contains a valid prepared statement. More...
|
| |
| bool | isDbValid () |
| | Check if the query is associated with a valid and open database. More...
|
| |
| void | setKeepErrorMsg (bool newKeepErrorMsg) |
| | Changes the mode of retrival of error string. If keep error message is true the exact error string returned by sqlite is fetches, otherwise the error message returned will be a generic one depending on the error code. More...
|
| |
| bool | keepErrorMsg () const |
| | Gets the keep error message status. More...
|
| |
|
All the function in this group advances the query to the next row and if this operation is successfull fetches some or all of its data. They are approximately equivalent to calling:
bool stepNoFetch() Move to next row in a query but do not fetch any data. Definition: HFSQtLi.cpp:221
|
| template<typename... Args> |
| int | stepPartial (int index, Args &&... args) |
| | Performs a step on a query and fetches data after the step. More...
|
| |
| template<typename... Args> |
| int | step (Args &&... args) |
| | Performs a step on a query and fetches all the data. More...
|
| |
| template<typename... Args> |
| int | stepGeneric (bool strict, int index, Args &&... args) |
| | Performs a step on a query and fetches data after the step with optional enabling of type checking (strict mode) More...
|
| |
| template<typename... Args> |
| int | stepAllGeneric (bool strict, Args &&... args) |
| | Performs a step on a query and fetches all the data after the step with optional enabling of type checking (strict mode) More...
|
| |
|
The following function allows easy operation on any query that returns one and only one row. They perform in one operation binding of parameters, a step on first row, fetching the data of the row and a second step to check the query effetively returned only one row. For example: int x;
qry.executeSingle<1>(4, x);
Is more or less equivalent to: qry.bind(4) && qry.step() && qry.columnAll(x) && "qry.step() returns SQLITE3_DONE"
Note All the function in this group will return an error if the query returns no row or more than one row
|
| template<typename... Args> |
| int | executeSinglePartial (int index, Args &&... args) |
| | Execute a query returning just one row and fetches some of the returned data. More...
|
| |
| template<typename... Args> |
| int | executeSingle (Args &&... args) |
| | Execute a query returning just one row and fetches all of the returned data. More...
|
| |
| template<int I, typename... Args> |
| int | executeSinglePartial (int indexBind, int indexFetch, Args &&... args) |
| | Execute a query returning just one row and fetches some of the returned data. More...
|
| |
| template<int I, typename... Args> |
| int | executeSingle (Args &&... args) |
| | Execute a query returning just one row and fetches all of the returned data. More...
|
| |
| template<typename... Args> |
| int | executeSinglePartialStrict (int index, Args &&... args) |
| | Execute a query returning just one row and fetches some of the returned data checking data types. More...
|
| |
| template<typename... Args> |
| int | executeSingleStrict (Args &&... args) |
| | Execute a query returning just one row and fetches all of the returned data checking data types. More...
|
| |
| template<int I, typename... Args> |
| int | executeSinglePartialStrict (int indexBind, int indexFetch, Args &&... args) |
| | Execute a query returning just one row and fetches some of the returned data checking data types. More...
|
| |
| template<int I, typename... Args> |
| int | executeSingleStrict (Args &&... args) |
| | Execute a query returning just one row and fetches all of the returned data checking data types. More...
|
| |
| template<int I, typename... Args> |
| int | executeSingleGeneric (bool strict, int indexBind, int indexFetch, Args &&... args) |
| | Execute a query returning just one row and fetches some of the returned data. More...
|
| |
| template<int I, typename... Args> |
| int | executeSingleAllGeneric (bool strict, Args &&... args) |
| | Execute a query returning just one row and fetches all of the returned data. More...
|
| |
|
The following function allows easy operation on any query that returns no row (e.g. CREATE TABLE or DELETE) They perform in one operation binding of parameters, and a step to run a query, checking that effectively the query returns no rows For example: Is more or less equivalent to: qry.bind(4) && "qry.step() returns SQLITE3_DONE"
Note All the function in this group will return an error if the query returns any row.
|
| template<typename... Args> |
| int | executeCommand (Args &&... args) |
| | Executes a query returning no rows. More...
|
| |
|
The functions here can be used to bind arguments while the query is in a reset state. For arguments see Bounded data types .
|
| template<typename... Args> |
| int | bind (int i, Args &&...args) |
| | Binds some values in a query. More...
|
| |
| template<typename... Args> |
| int | bindAll (Args &&...args) |
| | Binds all values of a query. More...
|
| |
| template<typename... Args> |
| int | bindTemporary (int i, Args &&...args) |
| | Binds some values in a query. The existence of passed values must be guaranteed to persist until the binding is cleared (Query is destroyed or clearBindings() is called) More...
|
| |
| template<typename... Args> |
| int | bindTemporaryAll (Args &&...args) |
| | Binds all values. The existence of passed values must be guaranteed to persist until the binding is cleared (Query is destroyed or clearBindings() is called) More...
|
| |
|
The functions here can be used to retrived data while a query is currently pointing to a row. For a description of types accepted see Fetched data types .
|
| template<typename... Args> |
| int | column (int i, Args &&...args) |
| | Retrieves some columns from a row. More...
|
| |
| template<typename... Args> |
| int | columnStrict (int i, Args &&...args) |
| | Retrieves some columns from a row, returning error if types do not match. More...
|
| |
| template<typename... Args> |
| int | columnAll (Args &&...args) |
| | Retrieves all columns from a row. If the number of retrived columns does not match the columns returned by the query the function returns an error. More...
|
| |
| template<typename... Args> |
| int | columnStrictAll (Args &&...args) |
| | Retrieves all columns from a row, returning error if types do not match. More...
|
| |
|
|
template<typename... Args> |
| int | bindSingleWithChecks (bool temporary, int i, const std::tuple< Args... > &args) |
| |
|
bool | fetchErrorString () |
| |
|
void | forceFetchErrorString () |
| |
|
int | assertBindColumnCount (int i) |
| |
|
template<typename T > |
| int | bindSingle (bool, int i, T &&value) |
| |
|
int | bindSingle (bool, int i, std::nullptr_t) |
| |
|
int | bindSingle (bool temporary, int i, QByteArray &&value) |
| |
|
int | bindSingle (bool temporary, int i, QByteArray &value) |
| |
|
int | bindSingle (bool, int i, const QByteArray &value) |
| |
|
int | bindSingle (bool temporary, int i, Null &&) |
| |
|
int | bindSingle (bool temporary, int i, const Null &) |
| |
|
int | bindSingle (bool temporary, int i, Null &) |
| |
|
int | bindSingle (bool temporary, int i, ZeroBlob &&value) |
| |
|
int | bindSingle (bool temporary, int i, ZeroBlob &value) |
| |
|
int | bindSingle (bool, int i, const ZeroBlob &zeroBlob) |
| |
|
int | bindSingle (bool, int i, qint64 value) |
| |
|
int | bindSingle (bool, int i, double value) |
| |
|
int | bindSingle (bool, int i, const char *value, int len=-1) |
| |
|
int | bindSingle (bool temporary, int i, int value) |
| |
|
int | bindSingle (bool temporary, int i, unsigned value) |
| |
|
int | bindSingle (bool temporary, int i, const QString &value) |
| |
|
template<class ... T> |
| int | bindSingle (bool temporary, int i, const std::tuple< T... > &value) |
| |
|
template<class ... T> |
| int | bindSingle (bool temporary, int i, std::tuple< T... > &&value) |
| |
|
template<class ... T, int ... I> |
| int | bindSingleHelper (bool temporary, int i, const std::tuple< T... > &value, Helper::int_sequence< I... >) |
| |
|
Type | columnType (int i) |
| |
|
int | assertFetchColumnCount (int i) |
| |
|
template<typename... Args> |
| int | columnHelper (bool strict, int i, Args &&...args) |
| |
|
template<typename... Args> |
| int | columnAllHelper (bool strict, Args &&...args) |
| |
|
qint64 | readColumnIntSQLite (int i, bool &ok) |
| |
|
double | readColumnDoubleSQLite (int i, bool &ok) |
| |
|
template<class T > |
| int | readColumnInt (bool strict, int i, T &value) |
| |