From 86352e32f449ecf00de254674b7dcac72bc34a14 Mon Sep 17 00:00:00 2001 From: zecke Date: Tue, 27 Aug 2002 20:17:50 +0000 Subject: Initial check in of the light wrapper library around normal SQL The first driver implementation is a SQLite version --- (limited to 'libsql/test') diff --git a/libsql/test/main.cpp b/libsql/test/main.cpp new file mode 100644 index 0000000..9b35ff3 --- a/dev/null +++ b/libsql/test/main.cpp @@ -0,0 +1,29 @@ +#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/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/libsql/test/spaltenweise.cpp b/libsql/test/spaltenweise.cpp new file mode 100644 index 0000000..8790cdd --- a/dev/null +++ b/libsql/test/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/libsql/test/spaltenweise.pro b/libsql/test/spaltenweise.pro new file mode 100644 index 0000000..5b881c0 --- a/dev/null +++ b/libsql/test/spaltenweise.pro @@ -0,0 +1,9 @@ +TEMPLATE = app +CONFIG = qt warn_on release +HEADERS = +SOURCES = spaltenweise.cpp +INCLUDEPATH += $(OPIEDIR)/include +DEPENDPATH += $(OPIEDIR)/include +LIBS += -lqpe -lopiesql +TARGET = spaltenweise + diff --git a/libsql/test/test.osql b/libsql/test/test.osql new file mode 100644 index 0000000..340e4f2 --- a/dev/null +++ b/libsql/test/test.osql @@ -0,0 +1,4 @@ +Name = Test1 +Vendor = Zecke +License = ZPL +Preference = 15 diff --git a/libsql/test/test.pro b/libsql/test/test.pro new file mode 100644 index 0000000..188c367 --- a/dev/null +++ b/libsql/test/test.pro @@ -0,0 +1,9 @@ +TEMPLATE = app +CONFIG = qt warn_on release +HEADERS = +SOURCES = main.cpp +INCLUDEPATH += $(OPIEDIR)/include +DEPENDPATH += $(OPIEDIR)/include +LIBS += -lqpe -lopiesql +TARGET = sqltest + diff --git a/libsql/test/test2.osql b/libsql/test/test2.osql new file mode 100644 index 0000000..952c99b --- a/dev/null +++ b/libsql/test/test2.osql @@ -0,0 +1,5 @@ +Name = Test2 +Vendor = Schaf +License = SPL +Preference = 15 +Default = 0 diff --git a/libsql/test/zeilenweise.cpp b/libsql/test/zeilenweise.cpp new file mode 100644 index 0000000..e538c9f --- a/dev/null +++ b/libsql/test/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/libsql/test/zeilenweise.pro b/libsql/test/zeilenweise.pro new file mode 100644 index 0000000..516b7c0 --- a/dev/null +++ b/libsql/test/zeilenweise.pro @@ -0,0 +1,9 @@ +TEMPLATE = app +CONFIG = qt warn_on release +HEADERS = +SOURCES = zeilenweise.cpp +INCLUDEPATH += $(OPIEDIR)/include +DEPENDPATH += $(OPIEDIR)/include +LIBS += -lqpe -lopiesql +TARGET = zeilenweise + -- cgit v0.9.0.2