author | mickeyl <mickeyl> | 2005-01-29 14:23:27 (UTC) |
---|---|---|
committer | mickeyl <mickeyl> | 2005-01-29 14:23:27 (UTC) |
commit | 20b3de56573b9e86c6b6041faf684adc8cbb2a45 (patch) (side-by-side diff) | |
tree | e0d91c84dee46d1cce3b0d68fd2c10c3dd7ce3a1 /libopie2/examples/opiedb/sqltest | |
parent | 555b999359a5aad999eaaf48632ce85f25125b85 (diff) | |
download | opie-20b3de56573b9e86c6b6041faf684adc8cbb2a45.zip opie-20b3de56573b9e86c6b6041faf684adc8cbb2a45.tar.gz opie-20b3de56573b9e86c6b6041faf684adc8cbb2a45.tar.bz2 |
examples to where they belong
Diffstat (limited to 'libopie2/examples/opiedb/sqltest') (more/less context) (ignore whitespace changes)
-rw-r--r-- | libopie2/examples/opiedb/sqltest/.cvsignore | 7 | ||||
-rw-r--r-- | libopie2/examples/opiedb/sqltest/main.cpp | 62 | ||||
-rw-r--r-- | libopie2/examples/opiedb/sqltest/spaltenweise.cpp | 43 | ||||
-rw-r--r-- | libopie2/examples/opiedb/sqltest/spaltenweise.pro | 13 | ||||
-rw-r--r-- | libopie2/examples/opiedb/sqltest/sqltest.pro | 17 | ||||
-rw-r--r-- | libopie2/examples/opiedb/sqltest/test.osql | 4 | ||||
-rw-r--r-- | libopie2/examples/opiedb/sqltest/test2.osql | 5 | ||||
-rw-r--r-- | libopie2/examples/opiedb/sqltest/zeilenweise.cpp | 86 | ||||
-rw-r--r-- | libopie2/examples/opiedb/sqltest/zeilenweise.pro | 13 |
9 files changed, 0 insertions, 250 deletions
diff --git a/libopie2/examples/opiedb/sqltest/.cvsignore b/libopie2/examples/opiedb/sqltest/.cvsignore deleted file mode 100644 index 3290247..0000000 --- a/libopie2/examples/opiedb/sqltest/.cvsignore +++ b/dev/null @@ -1,7 +0,0 @@ -sqltest -Makefile* -moc* -*moc -*.o -~* -obj diff --git a/libopie2/examples/opiedb/sqltest/main.cpp b/libopie2/examples/opiedb/sqltest/main.cpp deleted file mode 100644 index f4338e9..0000000 --- a/libopie2/examples/opiedb/sqltest/main.cpp +++ b/dev/null @@ -1,62 +0,0 @@ -/* - =. This file is part of the Opie Project - .=l. Copyright (C) 2004 Opie Team <opie-devel@handhelds.org> - .>+-= - _;:, .> :=|. 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_,=:_. -<s. This library is distributed in the hope that - + . -:. = it will be useful, but WITHOUT ANY WARRANTY; - : .. .:, . . . without even the implied warranty of - =_ + =;=|` MERCHANTABILITY or FITNESS FOR A - _.=:. : :=>`: 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 <opie2/osqlmanager.h> -#include <opie2/osqlquery.h> -#include <opie2/osqldriver.h> -#include <opie2/osqlresult.h> -#include <opie2/odebug.h> - -#include <qpe/qpeapplication.h> - -/* QT */ -#include <qdir.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(); - 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/libopie2/examples/opiedb/sqltest/spaltenweise.cpp b/libopie2/examples/opiedb/sqltest/spaltenweise.cpp deleted file mode 100644 index c11724c..0000000 --- a/libopie2/examples/opiedb/sqltest/spaltenweise.cpp +++ b/dev/null @@ -1,43 +0,0 @@ -#include <qdir.h> - -#include <qpe/qpeapplication.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(); - 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/libopie2/examples/opiedb/sqltest/spaltenweise.pro b/libopie2/examples/opiedb/sqltest/spaltenweise.pro deleted file mode 100644 index 0335d16..0000000 --- a/libopie2/examples/opiedb/sqltest/spaltenweise.pro +++ b/dev/null @@ -1,13 +0,0 @@ -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/libopie2/examples/opiedb/sqltest/sqltest.pro b/libopie2/examples/opiedb/sqltest/sqltest.pro deleted file mode 100644 index a4eee6b..0000000 --- a/libopie2/examples/opiedb/sqltest/sqltest.pro +++ b/dev/null @@ -1,17 +0,0 @@ -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/libopie2/examples/opiedb/sqltest/test.osql b/libopie2/examples/opiedb/sqltest/test.osql deleted file mode 100644 index 340e4f2..0000000 --- a/libopie2/examples/opiedb/sqltest/test.osql +++ b/dev/null @@ -1,4 +0,0 @@ -Name = Test1 -Vendor = Zecke -License = ZPL -Preference = 15 diff --git a/libopie2/examples/opiedb/sqltest/test2.osql b/libopie2/examples/opiedb/sqltest/test2.osql deleted file mode 100644 index 952c99b..0000000 --- a/libopie2/examples/opiedb/sqltest/test2.osql +++ b/dev/null @@ -1,5 +0,0 @@ -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 deleted file mode 100644 index 126e797..0000000 --- a/libopie2/examples/opiedb/sqltest/zeilenweise.cpp +++ b/dev/null @@ -1,86 +0,0 @@ -#include <qdir.h> - -#include <qpe/qpeapplication.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(); - 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/libopie2/examples/opiedb/sqltest/zeilenweise.pro b/libopie2/examples/opiedb/sqltest/zeilenweise.pro deleted file mode 100644 index 1fa17cd..0000000 --- a/libopie2/examples/opiedb/sqltest/zeilenweise.pro +++ b/dev/null @@ -1,13 +0,0 @@ -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 ) |