summaryrefslogtreecommitdiff
path: root/libopie2/examples/opiedb/sqltest
authormickeyl <mickeyl>2005-01-29 14:23:27 (UTC)
committer mickeyl <mickeyl>2005-01-29 14:23:27 (UTC)
commit20b3de56573b9e86c6b6041faf684adc8cbb2a45 (patch) (side-by-side diff)
treee0d91c84dee46d1cce3b0d68fd2c10c3dd7ce3a1 /libopie2/examples/opiedb/sqltest
parent555b999359a5aad999eaaf48632ce85f25125b85 (diff)
downloadopie-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/.cvsignore7
-rw-r--r--libopie2/examples/opiedb/sqltest/main.cpp62
-rw-r--r--libopie2/examples/opiedb/sqltest/spaltenweise.cpp43
-rw-r--r--libopie2/examples/opiedb/sqltest/spaltenweise.pro13
-rw-r--r--libopie2/examples/opiedb/sqltest/sqltest.pro17
-rw-r--r--libopie2/examples/opiedb/sqltest/test.osql4
-rw-r--r--libopie2/examples/opiedb/sqltest/test2.osql5
-rw-r--r--libopie2/examples/opiedb/sqltest/zeilenweise.cpp86
-rw-r--r--libopie2/examples/opiedb/sqltest/zeilenweise.pro13
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 )