Differential D4131 Diff 10172 autotests/DeleteItemsTest.cpp

Changeset View

Standalone View

autotests/DeleteItemsTest.cpp

This file was added.

1		#include "DeleteItemsTest.h"
2		#include <QApplication>
3		#include <QFileInfo>
4		#include <QPointer>
5		#include <QTextStream>
6
7		#include <KDbDriverManager>
8		#include <KDbDriver>
9		#include <KDbDriverManager_p.h>
10		#include <KDbDriverMetaData>
11		#include <KDbConnection>
12		#include <KDbConnectionData>
13		#include <KDbCursor>
14		#include <KDbTableSchema>
15		#include <KDbQuerySchema>
16		#include <KDbIndexSchema>
17		#include "KDbUtils_p.h"
18		#include <bits/stdc++.h>
19		using namespace std;
20		//#define KDB_EXPORT __attribute__((visibility("true")))
21		//#define KDB_EXPORT bool deleteRecords(KDbConnection* conn, const QString &tableName,
22		// const QString &keyname, KDbField::Type keytype, const QVariant &keyval);
23		#include <QFile>
24		#include <QTest>
25		#include <QMimeDatabase>
26		#include <QDir>
27		#include "../tests/features/tables_test_p.h"
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		KDbTableSchema *kdbtest_t;
41
42		QTEST_GUILESS_MAIN(DeleteItemsTest)
43
44		void DeleteItemsTest::initTestCase()
45		{
46		conn_data.setUserName("root");
47		conn_data.setPassword("rememberreach");
48		//conn_data.setPort(455);
49		KDbDriverManager manager;
50		const QStringList driverIds = manager.driverIds();
51		qDebug() << "DRIVERS: " << driverIds;
52		driver = manager.driver("org.kde.kdb.mysql");
53		conn_data.setDatabaseName("testdata");
54		conn_data.setDatabaseName("nkdtestdb");
55
56		conn = driver->createConnection(conn_data);
57
58		QVERIFY(conn \|\| !driver->result().isError());
59		qDebug() << "main: KDbConnection object created.";
60		QVERIFY(conn->connect());
61		qDebug() << "main: KDbConnection::connect() OK.";
62
63		// This far - i have created database connection..
64
65
66		QVERIFY(conn->dropDatabase("nkdtestdb"));
67		QVERIFY(conn->createDatabase("nkdtestdb"));
68		if(conn->databaseExists("nkdtestdb"))
69		qDebug() << "DB" << " nkdtestdb " << "created";
70
71
72		// this far, i have created database.
73
74		QVERIFY(conn->useDatabase("nkdtestdb"));
75		KDbField *f;
76		kdbtest_t = new KDbTableSchema("kdbtestteam");
77		kdbtest_t->setCaption("kdbtestteam database");
78		kdbtest_t->addField(f = new KDbField("id", KDbField::Integer, KDbField::PrimaryKey \| KDbField::AutoInc, KDbField::Unsigned));
79		f->setCaption("ID");
80		kdbtest_t->addField(f = new KDbField("age", KDbField::Integer, 0, KDbField::Unsigned));
81		f->setCaption("Age");
82		kdbtest_t->addField(f = new KDbField("fname", KDbField::Text));
83		f->setCaption("Name");
84		kdbtest_t->addField(f = new KDbField("sname", KDbField::Text));
85		f->setCaption("Surname");
86		QVERIFY(conn->createTable(kdbtest_t));
87		qDebug() << "kdbtestteam table schema made.";
88
89
90		//this far, i have created table and schema.
91
92
93
94		qDebug() << *kdbtest_t;
95		QVERIFY(conn->insertRecord(kdbtest_t, QVariant(1), QVariant(30), QVariant("Jaroslaw"), QVariant("Staniek")));
96		QVERIFY(conn->insertRecord(kdbtest_t, QVariant(2), QVariant(20), QVariant("Nitish"), QVariant("Dwivedi")));
97		QVERIFY(conn->insertRecord(kdbtest_t, QVariant(3), QVariant(20), QVariant("Khushboo"), QVariant("Gupta")));
98		QVERIFY(conn->insertRecord(kdbtest_t, QVariant(4), QVariant(20), QVariant("Priyanshu"), QVariant("Jain")));
99		qDebug() << "values in kdbtestteam inserted.";
100
101		// this far, i have inserted values in table.
102		// Now , REAL TEST GOES!!!
103
104
105		//! @overload bool deleteRecord(KDbConnection*, const KDbTableSchema&, const QString &, KDbField::Type, const QVariant &)
106		/KDB_EXPORT bool deleteRecords(KDbConnection conn, const QString &tableName,
107		const QString &keyname, KDbField::Type keytype, const QVariant &keyval);*/
108		//! Deletes records using one generic criteria.
109
110		QVERIFY(KDb::deleteRecords(conn, *kdbtest_t, QLatin1String("id"), 4));
111		QVERIFY(KDb::deleteRecords(conn, *kdbtest_t, QLatin1String("sname"), "Gupta"));
112		QVERIFY(KDb::deleteRecords(conn, *kdbtest_t, QLatin1String("fname"), "Nitish"));
113		QVERIFY(KDb::deleteRecords(conn, *kdbtest_t, QLatin1String("age"), 30));
114		//NON existing ROW -- should return false;
115		//QTest::currentTestFailed(!KDb::deleteRecords(conn, *kdbtest_t, QLatin1String("NonExistingColumn"), 30));
116		QVERIFY(KDb::deleteRecords(conn, *kdbtest_t, QLatin1String("age"), "Nitish"));
117
118		}
119
120		//by default, if we try to delete a row that does not exist in a table, the query will execute successfully and returns
121		//zero rows affected. Hence when we try to delete row that does not exist, the query should complete its execution successfully.
122
123		void DeleteItemsTest::deleteNonExistingrowTest()
124		{
125		QVERIFY(KDb::deleteRecords(conn, *kdbtest_t, QLatin1String("id"), 400));
126		}
127
128		/*
129		//! Deletes records with two generic criterias.
130		KDB_EXPORT bool deleteRecords(KDbConnection* conn, const QString &tableName,
131		const QString &keyname1, KDbField::Type keytype1, const QVariant& keyval1,
132		const QString &keyname2, KDbField::Type keytype2, const QVariant& keyval2);
133
134		*/
135		void DeleteItemsTest::DeletewithTwoConstraintsTest()
136		{
137		QVERIFY(conn->insertRecord(kdbtest_t, QVariant(1), QVariant(30), QVariant("Jaroslaw"), QVariant("Staniek")));
138		QVERIFY(conn->insertRecord(kdbtest_t, QVariant(2), QVariant(20), QVariant("Nitish"), QVariant("Dwivedi")));
139		QVERIFY(conn->insertRecord(kdbtest_t, QVariant(3), QVariant(20), QVariant("Khushboo"), QVariant("Gupta")));
140		QVERIFY(conn->insertRecord(kdbtest_t, QVariant(4), QVariant(20), QVariant("Priyanshu"), QVariant("Jain")));
141		qDebug() << "values in kdbtestteam inserted.";
142
143		//Both Arguments as INTEGER
144		QVERIFY(KDb::deleteRecords(conn, QLatin1String("kdbtestteam"),QLatin1String("id"),KDbField::Integer,2,QLatin1String("age"),KDbField::Integer,20));
145
146		QVERIFY(conn->insertRecord(kdbtest_t, QVariant(5), QVariant(30), QVariant("A"), QVariant("Staniek")));
147		QVERIFY(conn->insertRecord(kdbtest_t, QVariant(6), QVariant(20), QVariant("A"), QVariant("Dwivedi")));
148		QVERIFY(conn->insertRecord(kdbtest_t, QVariant(7), QVariant(20), QVariant("A"), QVariant("Gupta")));
149		qDebug() << "values in kdbtestteam inserted.";
150
151		//One argument is Integer and another one in Text--- SHOULD RETURN TRUE;
152		QVERIFY(KDb::deleteRecords(conn, QLatin1String("kdbtestteam"),QLatin1String("age"),KDbField::Integer,20,QLatin1String("fname"),KDbField::Text,"A"));
153
154		//using wrong type of data-- SHOULD RETURN FALSE;
155		//THIS FUNCTION IS RETURNING AND WHILE EXECUTING SQL QUERY, QUERY RETURNS ERROR. SOMETHING FISHY!!!!
156		//mysql> delete from kdbtestteam where age = 20 and fname = 56;
157		//ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'Khushboo'
158		/*
159		bool KDb::deleteRecords(KDbConnection* conn, const QString &tableName,
160		const QString &keyname1, KDbField::Type keytype1, const QVariant& keyval1,
161		const QString &keyname2, KDbField::Type keytype2, const QVariant& keyval2)
162		{
163		Q_ASSERT(conn);
164		return conn->executeVoidSQL(KDbEscapedString("DELETE FROM %1 WHERE %2=%3 AND %4=%5")
165		.arg(conn->escapeIdentifier(tableName))
166		.arg(conn->escapeIdentifier(keyname1))
167		.arg(conn->driver()->valueToSQL(keytype1, keyval1))
168		.arg(conn->escapeIdentifier(keyname2))
169		.arg(conn->driver()->valueToSQL(keytype2, keyval2)));
170		}
171
172		*/
173
174		//here in the declaration , the keys are parsed i guess. thus preventing error in case below. SHOULD HAVE A CHECK HERE.
175
176		QVERIFY(!KDb::deleteRecords(conn, QLatin1String("kdbtestteam"),QLatin1String("age"),KDbField::Integer,20,QLatin1String("fname"),KDbField::Text,56));
	dwivediAuthorUnsubmitted Not Done In this test, the deleteRecords() function is failing. What i did is passed an Integer value when it is expecting a String. The query in the comments above shows what kind of error is expected. But instead of that , it does executes the query successfully leading the test to fail. dwivedi: In this test, the deleteRecords() function is failing. What i did is passed an Integer value…
	staniekUnsubmitted Not Done Do we ask for fname = 56? Ok, that should work, a good test. staniek: Do we ask for fname = 56? Ok, that should work, a good test.
	dwivediAuthorUnsubmitted Not Done No, fname = 56 does not exist. Its just a random number that i choose. Only motive behind this test was to check how it handles a type of data which it does not expect. dwivedi: No, fname = 56 does not exist. Its just a random number that i choose. Only motive behind this…
177
178		//passing both wrond type of arguments -- SHOULD RETURN FALSE;
179		QVERIFY(!KDb::deleteRecords(conn, QLatin1String("kdbtestteam"),QLatin1String("age"),KDbField::Integer,"TRAP",QLatin1String("fname"),KDbField::Text,56));
180
181
182		}
183		No newline at end of file
	staniekUnsubmitted Not Done We're adding new line here so e.g. patch tools work better staniek: We're adding new line here so e.g. patch tools work better