tests/features/cursors_test.h

0001 /* This file is part of the KDE project
0002    Copyright (C) 2003-2004 Jarosław Staniek <staniek@kde.org>
0003
0004    This library is free software; you can redistribute it and/or
0005    modify it under the terms of the GNU Library General Public
0006    License as published by the Free Software Foundation; either
0007    version 2 of the License, or (at your option) any later version.
0008
0009    This library is distributed in the hope that it will be useful,
0010    but WITHOUT ANY WARRANTY; without even the implied warranty of
0011    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
0012    Library General Public License for more details.
0013
0014    You should have received a copy of the GNU Library General Public License
0015    along with this library; see the file COPYING.LIB.  If not, write to
0016    the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
0017  * Boston, MA 02110-1301, USA.
0018 */
0019
0020 #ifndef CURSORS_TEST_H
0021 #define CURSORS_TEST_H
0022
0023 int tablesTest(KDbConnection *conn);
0024
0025 int cursorsTest()
0026 {
0027     if (!conn->databaseExists(db_name)) {
0028         if (tablesTest(conn) != 0)
0029             return 1;
0030         qDebug() << "DB created & filled";
0031     }
0032
0033     if (!conn->useDatabase()) {
0034         qDebug() << conn->result();
0035         return 1;
0036     }
0037
0038     KDbCursor *cursor = conn->executeQuery(KDbEscapedString("SELECT * FROM persons"), cursor_options);  //KDbCursor::Buffered );
0039     qDebug() << "executeQuery() = " << !!cursor;
0040     if (!cursor)
0041         return 1;
0042
0043     qDebug() << "KDbCursor::moveLast() ---------------------";
0044     qDebug() << "-- KDbCursor::moveLast() == " << cursor->moveLast();
0045     cursor->moveLast();
0046     qDebug() << "KDbCursor::moveFirst() ---------------------";
0047     qDebug() << "-- KDbCursor::moveFirst() == " << cursor->moveFirst();
0048
0049     if (cursor_options & KDbCursor::Option::Buffered) {
0050       qDebug() << "KDbCursor Buffered -------------------------";
0051       qDebug() << "-- KDbCursor::value(0) == " << cursor->value(0);
0052       qDebug() << "-- KDbCursor::moveNext() == " << cursor->moveNext();
0053       qDebug() << "-- KDbCursor::value(0) == " << cursor->value(0);
0054       qDebug() << "-- KDbCursor::moveNext() == "<< cursor->moveNext();
0055       qDebug() << "-- KDbCursor::value(0) == " << cursor->value(0);
0056       qDebug() << "-- KDbCursor::moveNext() == "<< cursor->moveNext();
0057       qDebug() << "-- KDbCursor::value(0) == " << cursor->value(0);
0058       qDebug() << "-- KDbCursor::moveNext() == "<< cursor->moveNext();
0059       qDebug() << "-- KDbCursor::value(0) == " << cursor->value(0);
0060       qDebug() << "-- KDbCursor::movePrev() == "<< cursor->movePrev();
0061       qDebug() << "-- KDbCursor::value(0) == " << cursor->value(0);
0062       qDebug() << "-- KDbCursor::moveNext() == "<< cursor->moveNext();
0063       qDebug() << "-- KDbCursor::value(0) == " << cursor->value(0);
0064       qDebug() << "-- KDbCursor::eof() == " << cursor->eof();
0065     }
0066
0067     conn->deleteCursor(cursor);
0068
0069     return 0;
0070 }
0071
0072 #endif
0073