File indexing completed on 2024-04-14 14:53:35

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 PARSER_TEST_H
0021 #define PARSER_TEST_H
0022 
0023 #include <KDbParser>
0024 #include <KDbConnection>
0025 #include <KDbNativeStatementBuilder>
0026 
0027 int parserTest(const KDbEscapedString &st, const QStringList &params)
0028 {
0029     int r = 0;
0030     if (!conn->useDatabase()) {
0031         qDebug() << conn->result();
0032         return 1;
0033     }
0034 
0035     KDbParser parser(conn);
0036 
0037     const bool ok = parser.parse(st);
0038     QScopedPointer<KDbQuerySchema> q(parser.query());
0039     QList<QVariant> variantParams;
0040     for(const QString &param : params) {
0041         variantParams.append(param.toLocal8Bit());
0042     }
0043     if (ok && q) {
0044         cout << qPrintable(KDbUtils::debugString(KDbConnectionAndQuerySchema(conn, *q))) << '\n';
0045         KDbNativeStatementBuilder builder(conn, KDb::DriverEscaping);
0046         KDbEscapedString sql;
0047         if (builder.generateSelectStatement(&sql, q.data(), variantParams)) {
0048             cout << "-STATEMENT:\n" << sql.toByteArray().constData() << '\n';
0049         }
0050         else {
0051             cout << "-CANNOT GENERATE STATEMENT\n";
0052         }
0053     } else {
0054         qDebug() << parser.error();
0055         r = 1;
0056     }
0057     q.reset();
0058 
0059     if (!conn->closeDatabase()) {
0060         qDebug() << conn->result();
0061         return 1;
0062     }
0063 
0064     return r;
0065 }
0066 
0067 #endif
0068