/**************************************************************************** ** ** Copyright (C) 2012 Digia Plc and/or its subsidiary(-ies). ** Contact: http://www.qt-project.org/legal ** ** This file is part of the Qt3Support module of the Qt Toolkit. ** ** $QT_BEGIN_LICENSE:LGPL$ ** Commercial License Usage ** Licensees holding valid commercial Qt licenses may use this file in ** accordance with the commercial license agreement provided with the ** Software or, alternatively, in accordance with the terms contained in ** a written agreement between you and Digia. For licensing terms and ** conditions see http://qt.digia.com/licensing. For further information ** use the contact form at http://qt.digia.com/contact-us. ** ** GNU Lesser General Public License Usage ** Alternatively, this file may be used under the terms of the GNU Lesser ** General Public License version 2.1 as published by the Free Software ** Foundation and appearing in the file LICENSE.LGPL included in the ** packaging of this file. Please review the following information to ** ensure the GNU Lesser General Public License version 2.1 requirements ** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html. ** ** In addition, as a special exception, Digia gives you certain additional ** rights. These rights are described in the Digia Qt LGPL Exception ** version 1.1, included in the file LGPL_EXCEPTION.txt in this package. ** ** GNU General Public License Usage ** Alternatively, this file may be used under the terms of the GNU ** General Public License version 3.0 as published by the Free Software ** Foundation and appearing in the file LICENSE.GPL included in the ** packaging of this file. Please review the following information to ** ensure the GNU General Public License version 3.0 requirements will be ** met: http://www.gnu.org/copyleft/gpl.html. ** ** ** $QT_END_LICENSE$ ** ****************************************************************************/ #include "q3sqlselectcursor.h" #include "qsqldriver.h" #include "q3sqlrecordinfo.h" #ifndef QT_NO_SQL QT_BEGIN_NAMESPACE class Q3SqlSelectCursorPrivate { public: Q3SqlSelectCursorPrivate() : populated(false) {} QString query; bool populated : 1; }; /*! \class Q3SqlSelectCursor \brief The Q3SqlSelectCursor class provides browsing of general SQL SELECT statements. \compat Q3SqlSelectCursor is a convenience class that makes it possible to display result sets from general SQL \c SELECT statements in data-aware Qt widgets. Q3SqlSelectCursor is read-only and does not support \c INSERT, \c UPDATE or \c DELETE operations. Pass the query in at construction time, or use the Q3SqlSelectCursor::exec() function. Example: \snippet doc/src/snippets/code/src_qt3support_sql_q3sqlselectcursor.cpp 0 */ /*! Constructs a read only cursor on database \a db using the query \a query. */ Q3SqlSelectCursor::Q3SqlSelectCursor(const QString& query, QSqlDatabase db) : Q3SqlCursor(QString(), false, db) { d = new Q3SqlSelectCursorPrivate; d->query = query; Q3SqlCursor::setMode(ReadOnly); if (!query.isEmpty()) exec(query); } /*! Constructs a copy of \a other */ Q3SqlSelectCursor::Q3SqlSelectCursor(const Q3SqlSelectCursor& other) : Q3SqlCursor(other) { d = new Q3SqlSelectCursorPrivate; d->query = other.d->query; d->populated = other.d->populated; } /*! Destroys the object and frees any allocated resources */ Q3SqlSelectCursor::~Q3SqlSelectCursor() { delete d; } /*! \internal */ bool Q3SqlSelectCursor::exec(const QString& query) { d->query = query; bool ret = Q3SqlCursor::exec(query); if (ret) { Q3SqlCursor::clear(); populateCursor(); } return ret; } /*! \fn bool Q3SqlSelectCursor::select() \internal */ /*! \internal */ bool Q3SqlSelectCursor::select(const QString&, const QSqlIndex&) { bool ret = Q3SqlCursor::exec(d->query); if (ret && !d->populated) populateCursor(); return ret; } /*! \internal */ void Q3SqlSelectCursor::populateCursor() { Q3SqlRecordInfo inf = Q3SqlRecordInfo(record()); for (Q3SqlRecordInfo::const_iterator it = inf.begin(); it != inf.end(); ++it) Q3SqlCursor::append(*it); d->populated = true; } /*! \fn QSqlIndex Q3SqlSelectCursor::primaryIndex(bool) const \internal */ /*! \fn QSqlIndex Q3SqlSelectCursor::index(const QStringList&) const \internal */ /*! \fn QSqlIndex Q3SqlSelectCursor::index(const QString&) const \internal */ /*! \fn QSqlIndex Q3SqlSelectCursor::index(const char*) const \internal */ /*! \fn void Q3SqlSelectCursor::setPrimaryIndex(const QSqlIndex&) \internal */ /*! \fn void Q3SqlSelectCursor::append(const Q3SqlFieldInfo&) \internal */ /*! \fn void Q3SqlSelectCursor::insert(int, const Q3SqlFieldInfo&) \internal */ /*! \fn void Q3SqlSelectCursor::remove(int) \internal */ /*! \fn void Q3SqlSelectCursor::clear() \internal */ /*! \fn void Q3SqlSelectCursor::setGenerated(const QString&, bool) \internal */ /*! \fn void Q3SqlSelectCursor::setGenerated(int, bool) \internal */ /*! \fn QSqlRecord* Q3SqlSelectCursor::editBuffer(bool) \internal */ /*! \fn QSqlRecord* Q3SqlSelectCursor::primeInsert() \internal */ /*! \fn QSqlRecord* Q3SqlSelectCursor::primeUpdate() \internal */ /*! \fn QSqlRecord* Q3SqlSelectCursor::primeDelete() \internal */ /*! \fn int Q3SqlSelectCursor::insert(bool) \internal */ /*! \fn int Q3SqlSelectCursor::update(bool) \internal */ /*! \fn int Q3SqlSelectCursor::del(bool) \internal */ /*! \fn void Q3SqlSelectCursor::setMode(int) \internal */ /*! \fn void Q3SqlSelectCursor::setSort(const QSqlIndex&) \internal */ /*! \fn QSqlIndex Q3SqlSelectCursor::sort() const \internal */ /*! \fn void Q3SqlSelectCursor::setFilter(const QString&) \internal */ /*! \fn QString Q3SqlSelectCursor::filter() const \internal */ /*! \fn void Q3SqlSelectCursor::setName(const QString&, bool) \internal */ /*! \fn QString Q3SqlSelectCursor::name() const \internal */ /*! \fn QString Q3SqlSelectCursor::toString(const QString&, const QString&) const \internal */ /*! \fn int Q3SqlSelectCursor::update(const QString & filter, bool invalidate = true) \overload Updates the database with the current contents of the cursor edit buffer using the specified \a filter. Returns the number of records which were updated. For error information, use lastError(). Only records which meet the filter criteria are updated, otherwise all records in the table are updated. If \a invalidate is true (the default), the cursor can no longer be navigated. A new select() call must be made before you can move to a valid record. \sa Q3SqlCursor::update() primeUpdate() setMode() lastError() */ QT_END_NAMESPACE #endif // QT_NO_SQL