Diffstat (limited to 'libopie2/examples/opiedb/sqltest/zeilenweise.cpp') (more/less context) (show whitespace changes)
-rw-r--r-- | libopie2/examples/opiedb/sqltest/zeilenweise.cpp | 86 |
1 files changed, 0 insertions, 86 deletions
diff --git a/libopie2/examples/opiedb/sqltest/zeilenweise.cpp b/libopie2/examples/opiedb/sqltest/zeilenweise.cpp deleted file mode 100644 index 126e797..0000000 --- a/libopie2/examples/opiedb/sqltest/zeilenweise.cpp +++ b/dev/null | |||
@@ -1,86 +0,0 @@ | |||
1 | #include <qdir.h> | ||
2 | |||
3 | #include <qpe/qpeapplication.h> | ||
4 | #include <opie2/osqlmanager.h> | ||
5 | #include <opie2/osqlquery.h> | ||
6 | #include <opie2/osqldriver.h> | ||
7 | #include <opie2/osqlresult.h> | ||
8 | |||
9 | using namespace Opie::DB; | ||
10 | |||
11 | int main( int argc, char* argv[] ) { | ||
12 | |||
13 | QPEApplication app( argc, argv ); | ||
14 | OSQLManager man; | ||
15 | man.registerPath( QDir::currentDirPath() ); | ||
16 | OSQLBackEnd::ValueList list = man.queryBackEnd(); | ||
17 | |||
18 | OSQLDriver *driver = man.standard(); | ||
19 | owarn << "testmain" + driver->id() << oendl; | ||
20 | driver->setUrl("/home/ich/zeilenweise"); | ||
21 | if ( driver->open() ) { | ||
22 | owarn << "could open" << oendl; | ||
23 | }else | ||
24 | owarn << "wasn't able to open" << oendl; | ||
25 | OSQLRawQuery raw2("BEGIN TRANSACTION"); | ||
26 | OSQLRawQuery *raw = new OSQLRawQuery("create table todolist(uid,key,value)"); | ||
27 | OSQLResult res = driver->query( &raw2 ); | ||
28 | res = driver->query( raw ); | ||
29 | delete raw; | ||
30 | for (int i = 0; i< 10000; i++ ) { | ||
31 | int uid = i; | ||
32 | OSQLRawQuery *raw; | ||
33 | raw = new OSQLRawQuery("insert into todolist VALUES("+QString::number(uid)+",'Categories',"+"'-122324;-12132')"); | ||
34 | OSQLResult res = driver->query(raw ); | ||
35 | delete raw; | ||
36 | |||
37 | raw = new OSQLRawQuery("insert into todolist VALUES("+QString::number(uid) + | ||
38 | ",'Completed',1)" ); | ||
39 | res = driver->query(raw ); | ||
40 | delete raw; | ||
41 | |||
42 | raw = new OSQLRawQuery("insert into todolist VALUES("+ | ||
43 | QString::number(uid)+",'Progress',100)" ); | ||
44 | res = driver->query( raw ); | ||
45 | delete raw; | ||
46 | |||
47 | raw = new OSQLRawQuery("insert into todolist VALUES("+ | ||
48 | QString::number(uid)+",'Summary',"+ | ||
49 | "'Summary234-"+ QString::number(uid) + "')"); | ||
50 | res = driver->query( raw ); | ||
51 | delete raw; | ||
52 | |||
53 | raw = new OSQLRawQuery("insert into todolist VALUES("+ | ||
54 | QString::number(uid)+",'HasDate',1)"); | ||
55 | res = driver->query( raw ); | ||
56 | delete raw; | ||
57 | |||
58 | raw = new OSQLRawQuery("insert into todolist VALUES("+ | ||
59 | QString::number(uid)+",'DateDay',5)"); | ||
60 | res = driver->query( raw ); | ||
61 | delete raw; | ||
62 | |||
63 | raw = new OSQLRawQuery("insert into todolist VALUES("+ | ||
64 | QString::number(uid)+",'DateMonth',8)"); | ||
65 | res = driver->query( raw ); | ||
66 | delete raw; | ||
67 | |||
68 | raw = new OSQLRawQuery("insert into todolist VALUES("+ | ||
69 | QString::number(uid)+",'DateYear',2002)"); | ||
70 | res = driver->query( raw ); | ||
71 | delete raw; | ||
72 | |||
73 | raw = new OSQLRawQuery("insert into todolist VALUES("+ | ||
74 | QString::number(uid)+",'Priority',1)"); | ||
75 | res = driver->query( raw ); | ||
76 | delete raw; | ||
77 | |||
78 | raw = new OSQLRawQuery("insert into todolist VALUES("+ | ||
79 | QString::number(uid)+",'Description','" + | ||
80 | QString::number(uid) + "Description\n12344')"); | ||
81 | res = driver->query( raw ); | ||
82 | delete raw; | ||
83 | } | ||
84 | OSQLRawQuery raw3("COMMIT"); | ||
85 | res = driver->query(&raw3 ); | ||
86 | }; | ||