Differential D4131 Diff 10159 autotests/ItemDelete.cpp

Changeset View

Standalone View

autotests/ItemDelete.cpp

This file was added.

1		#include <QApplication>
2		#include <QFileInfo>
3		#include <QPointer>
4		#include <QTextStream>
5
6		#include <KDbDriverManager>
7		#include <KDbDriver>
8		#include <KDbDriverManager_p.h>
9		#include <KDbDriverMetaData>
10		#include <KDbConnection>
11		#include <KDbConnectionData>
12		#include <KDbCursor>
13		#include <KDbTableSchema>
14		#include <KDbQuerySchema>
15		#include <KDbIndexSchema>
16		#include "KDbUtils_p.h"
17		#include <bits/stdc++.h>
18		using namespace std;
19		//#define KDB_EXPORT __attribute__((visibility("true")))
20		//#define KDB_EXPORT bool deleteRecords(KDbConnection* conn, const QString &tableName,
21		// const QString &keyname, KDbField::Type keytype, const QVariant &keyval);
22		#include <QFile>
23		#include <QTest>
24		#include <QMimeDatabase>
25
26		#include "../tests/features/tables_test_p.h"
27
28
29		#define ll long long
30		QByteArray prgname;
31		QString db_name;
32		QString drv_id;
33		QString test_name;
34		int cursor_options = 0;
35		bool db_name_required = true;
36		KDbConnectionData conn_data;
37		KDbConnection* conn = 0;
38		KDbDriver* driver;
39		QApplication *app = 0;
40
41		int main()
42		{
43		//conn_data.setHostName("localhost");
44		conn_data.setUserName("root");
45		conn_data.setPassword("rememberreach");
46		//conn_data.setPort(455);
47		KDbDriverManager manager;
48		const QStringList driverIds = manager.driverIds();
49		qDebug() << "DRIVERS: " << driverIds;
50		driver = manager.driver("org.kde.kdb.mysql");
51		cout<<"checkpoint -1"<<endl;
52		conn_data.setDatabaseName("testdata");
53		cout<<"checkpoint 0"<<endl;
54		conn_data.setDatabaseName("nkdtestdb");
55		cout<<"checkpoint 1"<<endl;
56
57		conn = driver->createConnection(conn_data);
58		cout<<"checkpoint 2"<<endl;
59		if (!conn \|\| driver->result().isError()) {
60		qDebug() << driver->result();
61		return 1;
62		}
63		qDebug() << "main: KDbConnection object created.";
64		if (!conn->connect()) {
65		qDebug() << conn->result();
66		return 1;
67		}
68		qDebug() << "main: KDbConnection::connect() OK.";
69
70		// This far - i have created database connection..
71
72
73		conn->dropDatabase("nkdtestdb");
74		cout<<"checkpoint 3"<<endl;
75		conn->createDatabase("nkdtestdb");
76		cout<<"checkpoint 4"<<endl;
77		if(conn->databaseExists("nkdtestdb"))
78		qDebug() << "DB" << " nkdtestdb " << "created";
79
80
81		// this far, i have created database.
82
83		conn->useDatabase("nkdtestdb");
84		cout<<"checkpoint 5"<<endl;
85		KDbField *f;
86		KDbTableSchema *kdbtest_t = new KDbTableSchema("kdbtestteam");
87		kdbtest_t->setCaption("kdbtestteam database");
88		kdbtest_t->addField(f = new KDbField("id", KDbField::Integer, KDbField::PrimaryKey \| KDbField::AutoInc, KDbField::Unsigned));
89		f->setCaption("ID");
90		kdbtest_t->addField(f = new KDbField("Age", KDbField::Integer, 0, KDbField::Unsigned));
91		f->setCaption("Age");
92		kdbtest_t->addField(f = new KDbField("Fname", KDbField::Text));
93		f->setCaption("Name");
94		kdbtest_t->addField(f = new KDbField("Sname", KDbField::Text));
95		f->setCaption("Surname");
96		cout<<"checkpoint 6"<<endl;
97		if (!conn->createTable(kdbtest_t)) {
98		qDebug() << conn->result();
99		return 1;
100		}
101		cout<<"checkpoint 7"<<endl;
102		qDebug() << "kdbtestteam table schema made.";
103
104
105		//this far, i have created table and schema.
106
107
108
109		qDebug() << *kdbtest_t;
110		cout<<"checkpoint 8"<<endl;
111		if (!conn->insertRecord(kdbtest_t, QVariant(1), QVariant(27), QVariant("Jaroslaw"), QVariant("Staniek"))
112		\|\| !conn->insertRecord(kdbtest_t, QVariant(2), QVariant(20), QVariant("Nitish"), QVariant("Dwivedi"))
113		\|\| !conn->insertRecord(kdbtest_t, QVariant(3), QVariant(20), QVariant("Khushboo"), QVariant("Gupta"))
114		\|\| !conn->insertRecord(kdbtest_t, QVariant(4), QVariant(20), QVariant("Priyanshu"), QVariant("Jain"))
115		) {
116		qDebug() << "Unable to insert in kdbtestteam table.";
117		return 1;
118		}
119		cout<<"checkpoint 9"<<endl;
120		qDebug() << "values in kdbtestteam inserted.";
121		cout<<"checkpoint 10"<<endl;
122
123
124		// this far, i have inserted values in table.
125		// Now , REAL TEST GOES!!!
126
127
128		//! @overload bool deleteRecord(KDbConnection*, const KDbTableSchema&, const QString &, KDbField::Type, const QVariant &)
129		/KDB_EXPORT bool deleteRecords(KDbConnection conn, const QString &tableName,
130		const QString &keyname, KDbField::Type keytype, const QVariant &keyval);*/
131		//! Deletes records using one generic criteria.
132
133
134		if(!KDb::deleteRecords(conn, *kdbtest_t, QLatin1String("id"), 4))
	staniekUnsubmitted Done Q_VERIFY here staniek: Q_VERIFY here
135		{
136		qDebug() << "Unable to delete record.";
137		return 1;
138		}
139		return 0;
140		}