author | mickeyl <mickeyl> | 2005-01-29 14:09:25 (UTC) |
---|---|---|
committer | mickeyl <mickeyl> | 2005-01-29 14:09:25 (UTC) |
commit | 7b06e36fe27adc6a4fde2004eac13aaf8c0f0f02 (patch) (unidiff) | |
tree | 5b38b6eb9d8430b0a96a2e156995bb421cc1a570 /examples/opiedb/sqltest/zeilenweise.cpp | |
parent | 0db5704f66f0d08f9928f749774ee0f37bb0250d (diff) | |
download | opie-7b06e36fe27adc6a4fde2004eac13aaf8c0f0f02.zip opie-7b06e36fe27adc6a4fde2004eac13aaf8c0f0f02.tar.gz opie-7b06e36fe27adc6a4fde2004eac13aaf8c0f0f02.tar.bz2 |
examples start to appear here
Diffstat (limited to 'examples/opiedb/sqltest/zeilenweise.cpp') (more/less context) (ignore whitespace changes)
-rw-r--r-- | examples/opiedb/sqltest/zeilenweise.cpp | 86 |
1 files changed, 86 insertions, 0 deletions
diff --git a/examples/opiedb/sqltest/zeilenweise.cpp b/examples/opiedb/sqltest/zeilenweise.cpp new file mode 100644 index 0000000..126e797 --- a/dev/null +++ b/examples/opiedb/sqltest/zeilenweise.cpp | |||
@@ -0,0 +1,86 @@ | |||
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 | }; | ||