-rw-r--r-- | libopie2/examples/opiedb/sqltest/spaltenweise.cpp | 10 | ||||
-rw-r--r-- | libopie2/examples/opiedb/sqltest/spaltenweise.pro | 2 | ||||
-rw-r--r-- | libopie2/examples/opiedb/sqltest/zeilenweise.cpp | 10 | ||||
-rw-r--r-- | libopie2/examples/opiedb/sqltest/zeilenweise.pro | 2 |
4 files changed, 14 insertions, 10 deletions
diff --git a/libopie2/examples/opiedb/sqltest/spaltenweise.cpp b/libopie2/examples/opiedb/sqltest/spaltenweise.cpp index 8790cdd..e1a4d5d 100644 --- a/libopie2/examples/opiedb/sqltest/spaltenweise.cpp +++ b/libopie2/examples/opiedb/sqltest/spaltenweise.cpp @@ -1,41 +1,43 @@ #include <qdir.h> #include <qpe/qpeapplication.h> -#include "../osqlmanager.h" -#include "../osqlquery.h" -#include "../osqldriver.h" -#include "../osqlresult.h" +#include <opie2/osqlmanager.h> +#include <opie2/osqlquery.h> +#include <opie2/osqldriver.h> +#include <opie2/osqlresult.h> + +using namespace Opie::DB; 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 index f54fada..3cab802 100644 --- a/libopie2/examples/opiedb/sqltest/spaltenweise.pro +++ b/libopie2/examples/opiedb/sqltest/spaltenweise.pro @@ -1,13 +1,13 @@ TEMPLATE = app CONFIG = qt warn_on release HEADERS = SOURCES = spaltenweise.cpp INCLUDEPATH += $(OPIEDIR)/include DEPENDPATH += $(OPIEDIR)/include -LIBS += -lqpe -lopiesql +LIBS += -lqpe -lopiedb2 TARGET = spaltenweise include ( $(OPIEDIR)/include.pro ) diff --git a/libopie2/examples/opiedb/sqltest/zeilenweise.cpp b/libopie2/examples/opiedb/sqltest/zeilenweise.cpp index e538c9f..2d11ac5 100644 --- a/libopie2/examples/opiedb/sqltest/zeilenweise.cpp +++ b/libopie2/examples/opiedb/sqltest/zeilenweise.cpp @@ -1,84 +1,86 @@ #include <qdir.h> #include <qpe/qpeapplication.h> -#include "../osqlmanager.h" -#include "../osqlquery.h" -#include "../osqldriver.h" -#include "../osqlresult.h" +#include <opie2/osqlmanager.h> +#include <opie2/osqlquery.h> +#include <opie2/osqldriver.h> +#include <opie2/osqlresult.h> + +using namespace Opie::DB; 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 index e5cfcc7..6952921 100644 --- a/libopie2/examples/opiedb/sqltest/zeilenweise.pro +++ b/libopie2/examples/opiedb/sqltest/zeilenweise.pro @@ -1,13 +1,13 @@ TEMPLATE = app CONFIG = qt warn_on release HEADERS = SOURCES = zeilenweise.cpp INCLUDEPATH += $(OPIEDIR)/include DEPENDPATH += $(OPIEDIR)/include -LIBS += -lqpe -lopiesql +LIBS += -lqpe -lopiedb2 TARGET = zeilenweise include ( $(OPIEDIR)/include.pro ) |