Skip to content
GitLab
Select Git revision
  • dev default
  • 6.2
  • 6.2.2
  • 5.12.12
  • 5.12
  • 6.1
  • 6.2.1
  • 6.2.0
  • 6.1.3
  • 6.0
  • 6.1.2
  • 6.1.1
  • 5.12.11
  • 6.1.0
  • 5.15
  • 6.0.0
  • 5.15.2
  • 5.12.10
  • 5.15.1
  • 5.12.9
  • v5.15.0-alpha1
  • v5.12.7
  • v5.14.1
  • v5.9.9
  • v5.14.0
  • v5.14.0-rc2
  • v5.14.0-rc1
  • v5.12.6
  • v5.14.0-beta3
  • v5.13.2
  • v5.14.0-beta2
  • v5.14.0-beta1
  • v5.14.0-alpha1
  • v5.12.5
  • v5.13.1
  • v5.13.0
  • v5.13.0-rc3
  • v5.12.4
  • v5.13.0-rc2
  • v5.13.0-rc1
Find file BlameHistoryPermalink
qsql_sqlite.cpp 21.00 KiB
1 
/****************************************************************************
2 
**
3 
** Copyright (C) 2011 Nokia Corporation and/or its subsidiary(-ies).
4 
** All rights reserved.
5 
** Contact: Nokia Corporation (qt-info@nokia.com)
6 
**
7 
** This file is part of the QtSql module of the Qt Toolkit.
8 
**
9 
** $QT_BEGIN_LICENSE:LGPL$
10 
** GNU Lesser General Public License Usage
11 
** This file may be used under the terms of the GNU Lesser General Public
12 
** License version 2.1 as published by the Free Software Foundation and
13 
** appearing in the file LICENSE.LGPL included in the packaging of this
14 
** file. Please review the following information to ensure the GNU Lesser
15 
** General Public License version 2.1 requirements will be met:
16 
** http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html.
17 
**
18 
** In addition, as a special exception, Nokia gives you certain additional
19 
** rights. These rights are described in the Nokia Qt LGPL Exception
20 
** version 1.1, included in the file LGPL_EXCEPTION.txt in this package.
21 
**
22 
** GNU General Public License Usage
23 
** Alternatively, this file may be used under the terms of the GNU General
24 
** Public License version 3.0 as published by the Free Software Foundation
25 
** and appearing in the file LICENSE.GPL included in the packaging of this
26 
** file. Please review the following information to ensure the GNU General
27 
** Public License version 3.0 requirements will be met:
28 
** http://www.gnu.org/copyleft/gpl.html.
29 
**
30 
** Other Usage
31 
** Alternatively, this file may be used in accordance with the terms and
32 
** conditions contained in a signed written agreement between you and Nokia.
33 
**
34 
**
35 
**
36 
**
37 
**
38 
** $QT_END_LICENSE$
39 
**
40 
****************************************************************************/
41
42 
#include "qsql_sqlite.h"
43
44 
#include <qcoreapplication.h>
45 
#include <qvariant.h>
46 
#include <qsqlerror.h>
47 
#include <qsqlfield.h>
48 
#include <qsqlindex.h>
49 
#include <qsqlquery.h>
50 
#include <qstringlist.h>
51 
#include <qvector.h>
52 
#include <qdebug.h>
53
54 
#if defined Q_OS_WIN
55 
# include <qt_windows.h>
56 
#else
57 
# include <unistd.h>
58 
#endif
59
60 
#include <sqlite3.h>
61
62 
Q_DECLARE_METATYPE(sqlite3*)
63 
Q_DECLARE_METATYPE(sqlite3_stmt*)
64
65 
QT_BEGIN_NAMESPACE
66
67 
static QString _q_escapeIdentifier(const QString &identifier)
68 
{
69 
    QString res = identifier;
70 
    if(!identifier.isEmpty() && identifier.left(1) != QString(QLatin1Char('"')) && identifier.right(1) != QString(QLatin1Char('"')) ) {
7172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140
res.replace(QLatin1Char('"'), QLatin1String("\"\"")); res.prepend(QLatin1Char('"')).append(QLatin1Char('"')); res.replace(QLatin1Char('.'), QLatin1String("\".\"")); } return res; } static QVariant::Type qGetColumnType(const QString &tpName) { const QString typeName = tpName.toLower(); if (typeName == QLatin1String("integer") || typeName == QLatin1String("int")) return QVariant::Int; if (typeName == QLatin1String("double") || typeName == QLatin1String("float") || typeName.startsWith(QLatin1String("numeric"))) return QVariant::Double; if (typeName == QLatin1String("blob")) return QVariant::ByteArray; return QVariant::String; } static QSqlError qMakeError(sqlite3 *access, const QString &descr, QSqlError::ErrorType type, int errorCode = -1) { return QSqlError(descr, QString(reinterpret_cast<const QChar *>(sqlite3_errmsg16(access))), type, errorCode); } class QSQLiteDriverPrivate { public: inline QSQLiteDriverPrivate() : access(0) {} sqlite3 *access; }; class QSQLiteResultPrivate { public: QSQLiteResultPrivate(QSQLiteResult *res); void cleanup(); bool fetchNext(QSqlCachedResult::ValueCache &values, int idx, bool initialFetch); // initializes the recordInfo and the cache void initColumns(bool emptyResultset); void finalize(); QSQLiteResult* q; sqlite3 *access; sqlite3_stmt *stmt; bool skippedStatus; // the status of the fetchNext() that's skipped bool skipRow; // skip the next fetchNext()? QSqlRecord rInf; QVector<QVariant> firstRow; }; QSQLiteResultPrivate::QSQLiteResultPrivate(QSQLiteResult* res) : q(res), access(0), stmt(0), skippedStatus(false), skipRow(false) { } void QSQLiteResultPrivate::cleanup() { finalize(); rInf.clear(); skippedStatus = false;