From 7b06e36fe27adc6a4fde2004eac13aaf8c0f0f02 Mon Sep 17 00:00:00 2001 From: mickeyl Date: Sat, 29 Jan 2005 14:09:25 +0000 Subject: examples start to appear here --- (limited to 'examples/opiedb') diff --git a/examples/opiedb/.cvsignore b/examples/opiedb/.cvsignore new file mode 100644 index 0000000..972e959 --- a/dev/null +++ b/examples/opiedb/.cvsignore @@ -0,0 +1,6 @@ +Makefile* +moc* +*moc +*.o +~* +obj diff --git a/examples/opiedb/opiedb.pro b/examples/opiedb/opiedb.pro new file mode 100644 index 0000000..85fa6db --- a/dev/null +++ b/examples/opiedb/opiedb.pro @@ -0,0 +1,3 @@ +TEMPLATE = subdirs +SUBDIRS = sqltest + diff --git a/examples/opiedb/sqltest/.cvsignore b/examples/opiedb/sqltest/.cvsignore new file mode 100644 index 0000000..3290247 --- a/dev/null +++ b/examples/opiedb/sqltest/.cvsignore @@ -0,0 +1,7 @@ +sqltest +Makefile* +moc* +*moc +*.o +~* +obj diff --git a/examples/opiedb/sqltest/main.cpp b/examples/opiedb/sqltest/main.cpp new file mode 100644 index 0000000..f4338e9 --- a/dev/null +++ b/examples/opiedb/sqltest/main.cpp @@ -0,0 +1,62 @@ +/* + =. This file is part of the Opie Project + .=l. Copyright (C) 2004 Opie Team + .>+-= + _;:, .> :=|. This library is free software; you can +.> <`_, > . <= redistribute it and/or modify it under +:`=1 )Y*s>-.-- : the terms of the GNU Library General Public +.="- .-=="i, .._ License as published by the Free Software + - . .-<_> .<> Foundation; either version 2 of the License, + ._= =} : or (at your option) any later version. + .%`+i> _;_. + .i_,=:_. -`: PARTICULAR PURPOSE. See the GNU +..}^=.= = ; Library General Public License for more +++= -. .` .: details. + : = ...= . :.=- + -. .:....=;==+<; You should have received a copy of the GNU + -_. . . )=. = Library General Public License along with + -- :-=` this library; see the file COPYING.LIB. + If not, write to the Free Software Foundation, + Inc., 59 Temple Place - Suite 330, + Boston, MA 02111-1307, USA. + +*/ + +/* OPIE */ +#include +#include +#include +#include +#include + +#include + +/* QT */ +#include + +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(); + owarn << "testmain" + driver->id() << oendl; + driver->setUrl("/home/ich/test2vhgytry"); + if ( driver->open() ) { + owarn << "could open" << oendl; + }else + owarn << "wasn't able to open" << oendl; + 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/examples/opiedb/sqltest/spaltenweise.cpp b/examples/opiedb/sqltest/spaltenweise.cpp new file mode 100644 index 0000000..c11724c --- a/dev/null +++ b/examples/opiedb/sqltest/spaltenweise.cpp @@ -0,0 +1,43 @@ +#include + +#include +#include +#include +#include +#include + +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(); + owarn << "testmain" + driver->id() << oendl; + driver->setUrl("/home/ich/spaltenweise"); + if ( driver->open() ) { + owarn << "could open" << oendl; + }else + owarn << "wasn't able to open" << oendl; + 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/examples/opiedb/sqltest/spaltenweise.pro b/examples/opiedb/sqltest/spaltenweise.pro new file mode 100644 index 0000000..0335d16 --- a/dev/null +++ b/examples/opiedb/sqltest/spaltenweise.pro @@ -0,0 +1,13 @@ +TEMPLATE = app +CONFIG = qt warn_on +HEADERS = +SOURCES = spaltenweise.cpp +INCLUDEPATH += $(OPIEDIR)/include +DEPENDPATH += $(OPIEDIR)/include +LIBS += -lqpe -lopiedb2 +TARGET = spaltenweise + + + + +include( $(OPIEDIR)/include.pro ) diff --git a/examples/opiedb/sqltest/sqltest.pro b/examples/opiedb/sqltest/sqltest.pro new file mode 100644 index 0000000..a4eee6b --- a/dev/null +++ b/examples/opiedb/sqltest/sqltest.pro @@ -0,0 +1,17 @@ +TEMPLATE = app +CONFIG = qt warn_on +HEADERS = +SOURCES = main.cpp +INCLUDEPATH += $(OPIEDIR)/include +DEPENDPATH += $(OPIEDIR)/include +LIBS += -lqpe -lopiedb2 -lsqlite3 +TARGET = sqltest + +include( $(OPIEDIR)/include.pro ) + +!isEmpty( LIBSQLITE_INC_DIR ) { + INCLUDEPATH = $$LIBSQLITE_INC_DIR $$INCLUDEPATH +} +!isEmpty( LIBSQLITE_LIB_DIR ) { + LIBS = -L$$LIBSQLITE_LIB_DIR $$LIBS +} diff --git a/examples/opiedb/sqltest/test.osql b/examples/opiedb/sqltest/test.osql new file mode 100644 index 0000000..340e4f2 --- a/dev/null +++ b/examples/opiedb/sqltest/test.osql @@ -0,0 +1,4 @@ +Name = Test1 +Vendor = Zecke +License = ZPL +Preference = 15 diff --git a/examples/opiedb/sqltest/test2.osql b/examples/opiedb/sqltest/test2.osql new file mode 100644 index 0000000..952c99b --- a/dev/null +++ b/examples/opiedb/sqltest/test2.osql @@ -0,0 +1,5 @@ +Name = Test2 +Vendor = Schaf +License = SPL +Preference = 15 +Default = 0 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 @@ +#include + +#include +#include +#include +#include +#include + +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(); + owarn << "testmain" + driver->id() << oendl; + driver->setUrl("/home/ich/zeilenweise"); + if ( driver->open() ) { + owarn << "could open" << oendl; + }else + owarn << "wasn't able to open" << oendl; + 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/examples/opiedb/sqltest/zeilenweise.pro b/examples/opiedb/sqltest/zeilenweise.pro new file mode 100644 index 0000000..1fa17cd --- a/dev/null +++ b/examples/opiedb/sqltest/zeilenweise.pro @@ -0,0 +1,13 @@ +TEMPLATE = app +CONFIG = qt warn_on +HEADERS = +SOURCES = zeilenweise.cpp +INCLUDEPATH += $(OPIEDIR)/include +DEPENDPATH += $(OPIEDIR)/include +LIBS += -lqpe -lopiedb2 +TARGET = zeilenweise + + + + +include( $(OPIEDIR)/include.pro ) -- cgit v0.9.0.2