blob: 7f0e92231b94edde86b18c36e0306ad4f0f9a60d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
|
#include <kdebug.h>
#include <kinstance.h>
#include <kexidb/drivermanager.h>
#include <kexidb/driver.h>
#include <kexidb/connection.h>
#include <kexidb/cursor.h>
int main(int argc, char * argv[])
{
KInstance instance("newapi");
KexiDB::DriverManager manager;
QStringList names = manager.driverNames();
kdDebug() << "DRIVERS: " << endl;
for (QStringList::ConstIterator it = names.constBegin(); it != names.constEnd() ; ++it)
kdDebug() << *it << endl;
if (manager.error()) {
kdDebug() << manager.errorMsg() << endl;
return 1;
}
//get driver
KexiDB::Driver *driver = manager.driver("mySQL");
if (manager.error()) {
kdDebug() << manager.errorMsg() << endl;
return 1;
}
//connection data that can be later reused
KexiDB::ConnectionData conn_data;
conn_data.userName="root";
if (argc>1)
conn_data.password=argv[1];
else
conn_data.password="mysql";
conn_data.hostName="localhost";
KexiDB::Connection *conn = driver->createConnection(conn_data);
if (driver->error()) {
kdDebug() << driver->errorMsg() << endl;
return 1;
}
if (!conn->connect()) {
kdDebug() << conn->errorMsg() << endl;
return 1;
}
if (!conn->useDatabase( "test" )) {
kdDebug() <<"use db:"<< conn->errorMsg() << endl;
return 1;
}
kdDebug()<<"Creating first cursor"<<endl;
KexiDB::Cursor *c=conn->executeQuery("select * from Applications");
if (!c) kdDebug()<<conn->errorMsg()<<endl;
kdDebug()<<"Creating second cursor"<<endl;
KexiDB::Cursor *c2=conn->executeQuery("select * from Applications");
if (!c2) kdDebug()<<conn->errorMsg()<<endl;
QStringList l=conn->databaseNames();
if (l.isEmpty()) kdDebug()<<conn->errorMsg()<<endl;
kdDebug()<<"Databases:"<<endl;
for (QStringList::ConstIterator it = l.constBegin(); it != l.constEnd() ; ++it)
kdDebug() << *it << endl;
if (c) {
while (c->moveNext()) {
kdDebug()<<"Cursor: Value(0)"<<c->value(0).asString()<<endl;
kdDebug()<<"Cursor: Value(1)"<<c->value(1).asString()<<endl;
}
kdDebug()<<"Cursor error:"<<c->errorMsg()<<endl;
}
if (c2) {
while (c2->moveNext()) {
kdDebug()<<"Cursor2: Value(0)"<<c2->value(0).asString()<<endl;
kdDebug()<<"Cursor2: Value(1)"<<c2->value(1).asString()<<endl;
}
}
if (c) {
kdDebug()<<"Cursor::prev"<<endl;
while (c->movePrev()) {
kdDebug()<<"Cursor: Value(0)"<<c->value(0).asString()<<endl;
kdDebug()<<"Cursor: Value(1)"<<c->value(1).asString()<<endl;
}
kdDebug()<<"up/down"<<endl;
c->moveNext();
kdDebug()<<"Cursor: Value(0)"<<c->value(0).asString()<<endl;
kdDebug()<<"Cursor: Value(1)"<<c->value(1).asString()<<endl;
c->moveNext();
kdDebug()<<"Cursor: Value(0)"<<c->value(0).asString()<<endl;
kdDebug()<<"Cursor: Value(1)"<<c->value(1).asString()<<endl;
c->movePrev();
kdDebug()<<"Cursor: Value(0)"<<c->value(0).asString()<<endl;
kdDebug()<<"Cursor: Value(1)"<<c->value(1).asString()<<endl;
c->movePrev();
kdDebug()<<"Cursor: Value(0)"<<c->value(0).asString()<<endl;
kdDebug()<<"Cursor: Value(1)"<<c->value(1).asString()<<endl;
}
#if 0
KexiDB::Table *t = conn->tableSchema( "persons" );
if (t)
t->debug();
t = conn->tableSchema( "cars" );
if (t)
t->debug();
// conn->tableNames();
if (!conn->disconnect()) {
kdDebug() << conn->errorMsg() << endl;
return 1;
}
debug("before del");
delete conn;
debug("after del");
#endif
return 0;
}
|
