From 616e919ff6aea6a30e18edb37128c229e806beae Mon Sep 17 00:00:00 2001 From: mickeyl Date: Sun, 10 Aug 2003 15:40:31 +0000 Subject: merge zeckes libsql into libopie2 --- (limited to 'libopie2/examples/opiedb') diff --git a/libopie2/examples/opiedb/.cvsignore b/libopie2/examples/opiedb/.cvsignore new file mode 100644 index 0000000..972e959 --- a/dev/null +++ b/libopie2/examples/opiedb/.cvsignore @@ -0,0 +1,6 @@ +Makefile* +moc* +*moc +*.o +~* +obj diff --git a/libopie2/examples/opiedb/opiedb.pro b/libopie2/examples/opiedb/opiedb.pro new file mode 100644 index 0000000..85fa6db --- a/dev/null +++ b/libopie2/examples/opiedb/opiedb.pro @@ -0,0 +1,3 @@ +TEMPLATE = subdirs +SUBDIRS = sqltest + diff --git a/libopie2/examples/opiedb/sqltest/.cvsignore b/libopie2/examples/opiedb/sqltest/.cvsignore new file mode 100644 index 0000000..972e959 --- a/dev/null +++ b/libopie2/examples/opiedb/sqltest/.cvsignore @@ -0,0 +1,6 @@ +Makefile* +moc* +*moc +*.o +~* +obj diff --git a/libopie2/examples/opiedb/sqltest/main.cpp b/libopie2/examples/opiedb/sqltest/main.cpp new file mode 100644 index 0000000..2ecbf76 --- a/dev/null +++ b/libopie2/examples/opiedb/sqltest/main.cpp @@ -0,0 +1,29 @@ +#include + +#include +#include +#include +#include +#include + +int main( int argc, char* argv[] ) { + +QPEApplication app( argc, argv ); +OSQLManager man; +man.registerPath( QDir::currentDirPath() ); +OSQLBackEnd::ValueList list = man.queryBackEnd(); + +OSQLDriver *driver = man.standard(); + qWarning("testmain" + driver->id() ); + driver->setUrl("/home/ich/test2vhgytry"); + if ( driver->open() ) { + qWarning("could open"); + }else + qWarning("wasn't able to open"); + OSQLRawQuery raw("select * from t2" ); + OSQLResult res = driver->query( &raw ); + + OSQLRawQuery raw2( "insert into t2 VALUES(ROWID,'Meine Mutter') "); + res = driver->query(&raw2); + +}; diff --git a/libopie2/examples/opiedb/sqltest/spaltenweise.cpp b/libopie2/examples/opiedb/sqltest/spaltenweise.cpp new file mode 100644 index 0000000..8790cdd --- a/dev/null +++ b/libopie2/examples/opiedb/sqltest/spaltenweise.cpp @@ -0,0 +1,41 @@ +#include + +#include +#include "../osqlmanager.h" +#include "../osqlquery.h" +#include "../osqldriver.h" +#include "../osqlresult.h" + +int main( int argc, char* argv[] ) { + + QPEApplication app( argc, argv ); + OSQLManager man; + man.registerPath( QDir::currentDirPath() ); + OSQLBackEnd::ValueList list = man.queryBackEnd(); + + OSQLDriver *driver = man.standard(); + qWarning("testmain" + driver->id() ); + driver->setUrl("/home/ich/spaltenweise"); + if ( driver->open() ) { + qWarning("could open"); + }else + qWarning("wasn't able to open"); + OSQLRawQuery *raw = new OSQLRawQuery("create table todolist(" + "uid,categories,completed," + "progress,summary,HasDate," + "DateDay,DateMonth,DateYear," + "priority,description)" ); + + OSQLResult res = driver->query( raw ); + delete raw; + for (int i = 0; i< 10000; i++ ) { + int uid = i; + OSQLRawQuery raw("insert into todolist VALUES("+ + QString::number(uid)+ ",'-122324;-12132',1,100,"+ + "'Summary234-"+QString::number(uid)+"',1,5,8,2002,1,"+ + "'Description\n12344')"); + OSQLResult res = driver->query( &raw ); + + } + return 0; +}; diff --git a/libopie2/examples/opiedb/sqltest/spaltenweise.pro b/libopie2/examples/opiedb/sqltest/spaltenweise.pro new file mode 100644 index 0000000..f54fada --- a/dev/null +++ b/libopie2/examples/opiedb/sqltest/spaltenweise.pro @@ -0,0 +1,13 @@ +TEMPLATE = app +CONFIG = qt warn_on release +HEADERS = +SOURCES = spaltenweise.cpp +INCLUDEPATH += $(OPIEDIR)/include +DEPENDPATH += $(OPIEDIR)/include +LIBS += -lqpe -lopiesql +TARGET = spaltenweise + + + + +include ( $(OPIEDIR)/include.pro ) diff --git a/libopie2/examples/opiedb/sqltest/sqltest.pro b/libopie2/examples/opiedb/sqltest/sqltest.pro new file mode 100644 index 0000000..1e40468 --- a/dev/null +++ b/libopie2/examples/opiedb/sqltest/sqltest.pro @@ -0,0 +1,13 @@ +TEMPLATE = app +CONFIG = qt warn_on release +HEADERS = +SOURCES = main.cpp +INCLUDEPATH += $(OPIEDIR)/include +DEPENDPATH += $(OPIEDIR)/include +LIBS += -lqpe -lopiedb2 -lsqlite +TARGET = sqltest + + + + +include ( $(OPIEDIR)/include.pro ) diff --git a/libopie2/examples/opiedb/sqltest/test.osql b/libopie2/examples/opiedb/sqltest/test.osql new file mode 100644 index 0000000..340e4f2 --- a/dev/null +++ b/libopie2/examples/opiedb/sqltest/test.osql @@ -0,0 +1,4 @@ +Name = Test1 +Vendor = Zecke +License = ZPL +Preference = 15 diff --git a/libopie2/examples/opiedb/sqltest/test2.osql b/libopie2/examples/opiedb/sqltest/test2.osql new file mode 100644 index 0000000..952c99b --- a/dev/null +++ b/libopie2/examples/opiedb/sqltest/test2.osql @@ -0,0 +1,5 @@ +Name = Test2 +Vendor = Schaf +License = SPL +Preference = 15 +Default = 0 diff --git a/libopie2/examples/opiedb/sqltest/zeilenweise.cpp b/libopie2/examples/opiedb/sqltest/zeilenweise.cpp new file mode 100644 index 0000000..e538c9f --- a/dev/null +++ b/libopie2/examples/opiedb/sqltest/zeilenweise.cpp @@ -0,0 +1,84 @@ +#include + +#include +#include "../osqlmanager.h" +#include "../osqlquery.h" +#include "../osqldriver.h" +#include "../osqlresult.h" + +int main( int argc, char* argv[] ) { + +QPEApplication app( argc, argv ); +OSQLManager man; +man.registerPath( QDir::currentDirPath() ); +OSQLBackEnd::ValueList list = man.queryBackEnd(); + +OSQLDriver *driver = man.standard(); + qWarning("testmain" + driver->id() ); + driver->setUrl("/home/ich/zeilenweise"); + if ( driver->open() ) { + qWarning("could open"); + }else + qWarning("wasn't able to open"); + OSQLRawQuery raw2("BEGIN TRANSACTION"); + OSQLRawQuery *raw = new OSQLRawQuery("create table todolist(uid,key,value)"); + OSQLResult res = driver->query( &raw2 ); + res = driver->query( raw ); + delete raw; + for (int i = 0; i< 10000; i++ ) { + int uid = i; + OSQLRawQuery *raw; + raw = new OSQLRawQuery("insert into todolist VALUES("+QString::number(uid)+",'Categories',"+"'-122324;-12132')"); + OSQLResult res = driver->query(raw ); + delete raw; + + raw = new OSQLRawQuery("insert into todolist VALUES("+QString::number(uid) + + ",'Completed',1)" ); + res = driver->query(raw ); + delete raw; + + raw = new OSQLRawQuery("insert into todolist VALUES("+ + QString::number(uid)+",'Progress',100)" ); + res = driver->query( raw ); + delete raw; + + raw = new OSQLRawQuery("insert into todolist VALUES("+ + QString::number(uid)+",'Summary',"+ + "'Summary234-"+ QString::number(uid) + "')"); + res = driver->query( raw ); + delete raw; + + raw = new OSQLRawQuery("insert into todolist VALUES("+ + QString::number(uid)+",'HasDate',1)"); + res = driver->query( raw ); + delete raw; + + raw = new OSQLRawQuery("insert into todolist VALUES("+ + QString::number(uid)+",'DateDay',5)"); + res = driver->query( raw ); + delete raw; + + raw = new OSQLRawQuery("insert into todolist VALUES("+ + QString::number(uid)+",'DateMonth',8)"); + res = driver->query( raw ); + delete raw; + + raw = new OSQLRawQuery("insert into todolist VALUES("+ + QString::number(uid)+",'DateYear',2002)"); + res = driver->query( raw ); + delete raw; + + raw = new OSQLRawQuery("insert into todolist VALUES("+ + QString::number(uid)+",'Priority',1)"); + res = driver->query( raw ); + delete raw; + + raw = new OSQLRawQuery("insert into todolist VALUES("+ + QString::number(uid)+",'Description','" + + QString::number(uid) + "Description\n12344')"); + res = driver->query( raw ); + delete raw; + } + OSQLRawQuery raw3("COMMIT"); + res = driver->query(&raw3 ); +}; diff --git a/libopie2/examples/opiedb/sqltest/zeilenweise.pro b/libopie2/examples/opiedb/sqltest/zeilenweise.pro new file mode 100644 index 0000000..e5cfcc7 --- a/dev/null +++ b/libopie2/examples/opiedb/sqltest/zeilenweise.pro @@ -0,0 +1,13 @@ +TEMPLATE = app +CONFIG = qt warn_on release +HEADERS = +SOURCES = zeilenweise.cpp +INCLUDEPATH += $(OPIEDIR)/include +DEPENDPATH += $(OPIEDIR)/include +LIBS += -lqpe -lopiesql +TARGET = zeilenweise + + + + +include ( $(OPIEDIR)/include.pro ) -- cgit v0.9.0.2