diff --git a/autotests/CMakeLists.txt b/autotests/CMakeLists.txt --- a/autotests/CMakeLists.txt +++ b/autotests/CMakeLists.txt @@ -43,7 +43,7 @@ DriverTest.cpp ExpressionsTest.cpp KDbTest.cpp - + ItemDelete.cpp LINK_LIBRARIES kdbtestutils ) diff --git a/autotests/ItemDelete.cpp b/autotests/ItemDelete.cpp new file mode 100644 --- /dev/null +++ b/autotests/ItemDelete.cpp @@ -0,0 +1,140 @@ +#include +#include +#include +#include + +#include +#include +#include +#include +#include +#include +#include +#include +#include +#include +#include "KDbUtils_p.h" +#include +using namespace std; +//#define KDB_EXPORT __attribute__((visibility("true"))) +//#define KDB_EXPORT bool deleteRecords(KDbConnection* conn, const QString &tableName, +// const QString &keyname, KDbField::Type keytype, const QVariant &keyval); +#include +#include +#include + +#include "../tests/features/tables_test_p.h" + + +#define ll long long +QByteArray prgname; +QString db_name; +QString drv_id; +QString test_name; +int cursor_options = 0; +bool db_name_required = true; +KDbConnectionData conn_data; +KDbConnection* conn = 0; +KDbDriver* driver; +QApplication *app = 0; + +int main() +{ + //conn_data.setHostName("localhost"); + conn_data.setUserName("root"); + conn_data.setPassword("rememberreach"); + //conn_data.setPort(455); + KDbDriverManager manager; + const QStringList driverIds = manager.driverIds(); + qDebug() << "DRIVERS: " << driverIds; + driver = manager.driver("org.kde.kdb.mysql"); + cout<<"checkpoint -1"<createConnection(conn_data); + cout<<"checkpoint 2"<result().isError()) { + qDebug() << driver->result(); + return 1; + } + qDebug() << "main: KDbConnection object created."; + if (!conn->connect()) { + qDebug() << conn->result(); + return 1; + } + qDebug() << "main: KDbConnection::connect() OK."; + +// This far - i have created database connection.. + + + conn->dropDatabase("nkdtestdb"); + cout<<"checkpoint 3"<createDatabase("nkdtestdb"); + cout<<"checkpoint 4"<databaseExists("nkdtestdb")) + qDebug() << "DB" << " nkdtestdb " << "created"; + + +// this far, i have created database. + + conn->useDatabase("nkdtestdb"); + cout<<"checkpoint 5"<setCaption("kdbtestteam database"); + kdbtest_t->addField(f = new KDbField("id", KDbField::Integer, KDbField::PrimaryKey | KDbField::AutoInc, KDbField::Unsigned)); + f->setCaption("ID"); + kdbtest_t->addField(f = new KDbField("Age", KDbField::Integer, 0, KDbField::Unsigned)); + f->setCaption("Age"); + kdbtest_t->addField(f = new KDbField("Fname", KDbField::Text)); + f->setCaption("Name"); + kdbtest_t->addField(f = new KDbField("Sname", KDbField::Text)); + f->setCaption("Surname"); + cout<<"checkpoint 6"<createTable(kdbtest_t)) { + qDebug() << conn->result(); + return 1; + } + cout<<"checkpoint 7"<insertRecord(kdbtest_t, QVariant(1), QVariant(27), QVariant("Jaroslaw"), QVariant("Staniek")) + || !conn->insertRecord(kdbtest_t, QVariant(2), QVariant(20), QVariant("Nitish"), QVariant("Dwivedi")) + || !conn->insertRecord(kdbtest_t, QVariant(3), QVariant(20), QVariant("Khushboo"), QVariant("Gupta")) + || !conn->insertRecord(kdbtest_t, QVariant(4), QVariant(20), QVariant("Priyanshu"), QVariant("Jain")) + ) { + qDebug() << "Unable to insert in kdbtestteam table."; + return 1; + } + cout<<"checkpoint 9"<