WSF
wizard::RevisionSqlStmt Class Reference

#include <RevisionSqlStmt.hpp>

Public Member Functions

 RevisionSqlStmt ()
 RevisionSqlStmt (sqlite3 *aDb, const std::string &aSql)
virtual ~RevisionSqlStmt ()
bool Prepare (sqlite3 *aDb, const std::string &aSql)
void Finalize ()
bool Bind (int idx, int aInt)
bool Bind (int idx, const std::string &aString)
bool Bind (int idx, const char *aString)
bool Bind (int idx, double aValue)
bool Bind (int idx, const QByteArray &aBlob)
bool BindBlobStatic (int idx, const char *aBlob, int aBlobSize)
bool BindZipped (int idx, const QByteArray &aBlob)
bool Bind64 (int idx, long long aInt64)
bool BindNull (int idx)
bool Reset ()
bool Step ()
bool StepRow ()
bool Execute ()
bool ExecuteStepRow ()
std::string GetParameterName (int idx)
int GetParameterCount ()
const char * ColCString (int col)
std::string ColText (int col)
int ColInt (int col)
long long ColInt64 (int col)
QByteArray ColBlob (int col)
QByteArray ColBlobUnzipped (int col)

Static Public Member Functions

static int Exec (sqlite3 *aSqlDb, const char *aSql)
static int ExecOk (sqlite3 *aSqlDb, const char *aSql)

Constructor & Destructor Documentation

◆ RevisionSqlStmt() [1/2]

wizard::RevisionSqlStmt::RevisionSqlStmt ( )

◆ RevisionSqlStmt() [2/2]

wizard::RevisionSqlStmt::RevisionSqlStmt ( sqlite3 * aDb,
const std::string & aSql )

References Prepare().

◆ ~RevisionSqlStmt()

wizard::RevisionSqlStmt::~RevisionSqlStmt ( )
virtual

References Finalize().

Member Function Documentation

◆ Bind() [1/5]

bool wizard::RevisionSqlStmt::Bind ( int idx,
const char * aString )

References Bind().

◆ Bind() [2/5]

bool wizard::RevisionSqlStmt::Bind ( int idx,
const QByteArray & aBlob )

◆ Bind() [3/5]

bool wizard::RevisionSqlStmt::Bind ( int idx,
const std::string & aString )

◆ Bind() [4/5]

bool wizard::RevisionSqlStmt::Bind ( int idx,
double aValue )

◆ Bind() [5/5]

bool wizard::RevisionSqlStmt::Bind ( int idx,
int aInt )

◆ Bind64()

bool wizard::RevisionSqlStmt::Bind64 ( int idx,
long long aInt64 )

◆ BindBlobStatic()

bool wizard::RevisionSqlStmt::BindBlobStatic ( int idx,
const char * aBlob,
int aBlobSize )

◆ BindNull()

bool wizard::RevisionSqlStmt::BindNull ( int idx)

◆ BindZipped()

bool wizard::RevisionSqlStmt::BindZipped ( int idx,
const QByteArray & aBlob )

References Bind().

◆ ColBlob()

QByteArray wizard::RevisionSqlStmt::ColBlob ( int col)

Referenced by ColBlobUnzipped().

◆ ColBlobUnzipped()

QByteArray wizard::RevisionSqlStmt::ColBlobUnzipped ( int col)

References ColBlob().

◆ ColCString()

const char * wizard::RevisionSqlStmt::ColCString ( int col)

Referenced by ColText().

◆ ColInt()

int wizard::RevisionSqlStmt::ColInt ( int col)

◆ ColInt64()

long long wizard::RevisionSqlStmt::ColInt64 ( int col)

◆ ColText()

std::string wizard::RevisionSqlStmt::ColText ( int col)

References ColCString().

◆ Exec()

int wizard::RevisionSqlStmt::Exec ( sqlite3 * aSqlDb,
const char * aSql )
static

Executes a given SQL query.

Parameters
aSqlDbThe database to run the query on.
aSqlThe query to run.
Returns
The SQLite result code of running the query.

Referenced by ExecOk().

◆ ExecOk()

int wizard::RevisionSqlStmt::ExecOk ( sqlite3 * aSqlDb,
const char * aSql )
static

Executes a given SQL query and checks that the result code is SQLITE_OK.

Parameters
aSqlDbThe database to run the query on.
aSqlThe query to run.
Returns
The SQLite result code of running the query.

References Exec(), and success.

◆ Execute()

bool wizard::RevisionSqlStmt::Execute ( )

References Reset(), and Step().

◆ ExecuteStepRow()

bool wizard::RevisionSqlStmt::ExecuteStepRow ( )

References Reset(), and StepRow().

◆ Finalize()

void wizard::RevisionSqlStmt::Finalize ( )

◆ GetParameterCount()

int wizard::RevisionSqlStmt::GetParameterCount ( )

◆ GetParameterName()

std::string wizard::RevisionSqlStmt::GetParameterName ( int idx)

◆ Prepare()

bool wizard::RevisionSqlStmt::Prepare ( sqlite3 * aDb,
const std::string & aSql )

◆ Reset()

bool wizard::RevisionSqlStmt::Reset ( )

◆ Step()

bool wizard::RevisionSqlStmt::Step ( )

◆ StepRow()

bool wizard::RevisionSqlStmt::StepRow ( )

Referenced by ExecuteStepRow().


The documentation for this class was generated from the following files:
Copyrights Multiple, All Rights Reserved