QSQLite2ResultPrivate Class Reference

Public Functions
void	cleanup ()
bool	fetchNext (QSqlCachedResult::ValueCache &values, int idx, bool initialFetch)
void	finalize ()
void	init (const char **cnames, int numCols)
bool	isSelect ()
	QSQLite2ResultPrivate (QSQLite2Result *res)

Public Variables
sqlite *	access
sqlite_vm *	currentMachine
const char *	currentTail
QVector< QVariant >	firstRow
QSQLite2Result *	q
QSqlRecord	rInf
bool	skippedStatus
bool	skipRow
bool	utf8

Detailed Description

Definition at line 94 of file qsql_sqlite2.cpp.

Constructors and Destructors

QSQLite2ResultPrivate()

QSQLite2ResultPrivate::QSQLite2ResultPrivate

(

QSQLite2Result *

res

)

Definition at line 122 of file qsql_sqlite2.cpp.

                                                                : q(res), access(0), currentTail(0),
    currentMachine(0), skippedStatus(false), skipRow(false), utf8(false)
{
}

Functions

cleanup()

void QSQLite2ResultPrivate::cleanup

(

)

Definition at line 127 of file qsql_sqlite2.cpp.

Referenced by QSQLite2Result::reset(), and QSQLite2Result::~QSQLite2Result().

{
    finalize();
    rInf.clear();
    currentTail = 0;
    currentMachine = 0;
    skippedStatus = false;
    skipRow = false;
    q->setAt(QSql::BeforeFirstRow);
    q->setActive(false);
    q->cleanup();
}

fetchNext()

bool QSQLite2ResultPrivate::fetchNext	(	QSqlCachedResult::ValueCache &	values,
		int	idx,
		bool	initialFetch
	)

Definition at line 183 of file qsql_sqlite2.cpp.

Referenced by QSQLite2Result::gotoNext(), and QSQLite2Result::reset().

{
    // may be caching.
    const char **fvals;
    const char **cnames;
    int colNum;
    int res;
    int i;

    if (skipRow) {
        // already fetched
        Q_ASSERT(!initialFetch);
        skipRow = false;
        for(int i=0;i<firstRow.count(); i++)
            values[i] = firstRow[i];
        return skippedStatus;
    }
    skipRow = initialFetch;

    if (!currentMachine)
        return false;

    // keep trying while busy, wish I could implement this better.
    while ((res = sqlite_step(currentMachine, &colNum, &fvals, &cnames)) == SQLITE_BUSY) {
        // sleep instead requesting result again immidiately.
#if defined Q_WS_WIN32
        Sleep(1000);
#else
        sleep(1);
#endif
    }

    if(initialFetch) {
        firstRow.clear();
        firstRow.resize(colNum);
    }
    
    switch(res) {
    case SQLITE_ROW:
        // check to see if should fill out columns
        if (rInf.isEmpty())
            // must be first call.
            init(cnames, colNum);
        if (!fvals)
            return false;
        if (idx < 0 && !initialFetch)
            return true;
        for (i = 0; i < colNum; ++i)
            values[i + idx] = utf8 ? QString::fromUtf8(fvals[i]) : QString::fromAscii(fvals[i]);
        return true;
    case SQLITE_DONE:
        if (rInf.isEmpty())
            // must be first call.
            init(cnames, colNum);
        q->setAt(QSql::AfterLastRow);
        return false;
    case SQLITE_ERROR:
    case SQLITE_MISUSE:
    default:
        // something wrong, don't get col info, but still return false
        finalize(); // finalize to get the error message.
        q->setAt(QSql::AfterLastRow);
        return false;
    }
    return false;
}

finalize()

void QSQLite2ResultPrivate::finalize

(

)

Definition at line 140 of file qsql_sqlite2.cpp.

Referenced by cleanup(), fetchNext(), and QSQLite2Result::virtual_hook().

{
    if (!currentMachine)
        return;

    char* err = 0;
    int res = sqlite_finalize(currentMachine, &err);
    if (err) {
        q->setLastError(QSqlError(QCoreApplication::translate("QSQLite2Result",
                                  "Unable to fetch results"), QString::fromAscii(err),
                                  QSqlError::StatementError, res));
        sqlite_freemem(err);
    }
    currentMachine = 0;
}

init()

void QSQLite2ResultPrivate::init	(	const char **	cnames,
		int	numCols
	)

Definition at line 157 of file qsql_sqlite2.cpp.

Referenced by fetchNext().

{
    if (!cnames)
        return;

    rInf.clear();
    if (numCols <= 0)
        return;
    q->init(numCols);

    for (int i = 0; i < numCols; ++i) {
        const char* lastDot = strrchr(cnames[i], '.');
        const char* fieldName = lastDot ? lastDot + 1 : cnames[i];
        
        //remove quotations around the field name if any
        QString fieldStr = QString::fromAscii(fieldName);
        QLatin1Char quote('\"');
        if ( fieldStr.length() > 2 && fieldStr.startsWith(quote) && fieldStr.endsWith(quote)) {
            fieldStr = fieldStr.mid(1);
            fieldStr.chop(1);
        }
        rInf.append(QSqlField(fieldStr,
                              nameToType(QString::fromAscii(cnames[i+numCols]))));
    }
}

isSelect()

bool QSQLite2ResultPrivate::isSelect

(

)

Properties

access

sqlite* QSQLite2ResultPrivate::access

Definition at line 106 of file qsql_sqlite2.cpp.

Referenced by QSQLite2Result::numRowsAffected(), QSQLite2Result::QSQLite2Result(), and QSQLite2Result::reset().

currentMachine

sqlite_vm* QSQLite2ResultPrivate::currentMachine

Definition at line 111 of file qsql_sqlite2.cpp.

Referenced by cleanup(), fetchNext(), finalize(), QSQLite2Result::handle(), and QSQLite2Result::reset().

currentTail

const char* QSQLite2ResultPrivate::currentTail

Definition at line 110 of file qsql_sqlite2.cpp.

Referenced by cleanup(), and QSQLite2Result::reset().

firstRow

QVector<QVariant> QSQLite2ResultPrivate::firstRow

Definition at line 117 of file qsql_sqlite2.cpp.

Referenced by fetchNext(), and QSQLite2Result::reset().

q

QSQLite2Result* QSQLite2ResultPrivate::q

Definition at line 105 of file qsql_sqlite2.cpp.

Referenced by cleanup(), fetchNext(), finalize(), and init().

rInf

QSqlRecord QSQLite2ResultPrivate::rInf

Definition at line 116 of file qsql_sqlite2.cpp.

Referenced by cleanup(), fetchNext(), init(), QSQLite2Result::record(), and QSQLite2Result::reset().

skippedStatus

bool QSQLite2ResultPrivate::skippedStatus

Definition at line 113 of file qsql_sqlite2.cpp.

Referenced by cleanup(), fetchNext(), and QSQLite2Result::reset().

skipRow

bool QSQLite2ResultPrivate::skipRow

Definition at line 114 of file qsql_sqlite2.cpp.

Referenced by cleanup(), and fetchNext().

utf8

bool QSQLite2ResultPrivate::utf8

Definition at line 115 of file qsql_sqlite2.cpp.

Referenced by fetchNext(), QSQLite2Result::QSQLite2Result(), and QSQLite2Result::reset().

---

The documentation for this class was generated from the following file:

• /src/sql/drivers/sqlite2/qsql_sqlite2.cpp