You can subscribe to this list here.
2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(7) |
Oct
|
Nov
(5) |
Dec
|
---|---|---|---|---|---|---|---|---|---|---|---|---|
2003 |
Jan
|
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
|
Jul
(8) |
Aug
(1) |
Sep
(4) |
Oct
(1) |
Nov
|
Dec
(5) |
2004 |
Jan
(5) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2014 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
(1) |
Dec
|
2017 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(4) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: 杜萍 <993...@qq...> - 2017-07-28 07:19:48
|
千种游戏,顶级盘口,注册即送28,首存10送18,100起送388,唯一网址:7771584.com |
From: 徐进 <914...@qq...> - 2017-07-27 19:56:31
|
千种游戏,顶级盘口,注册即送28,首存10送18,100起送388,唯一网址:7771584.com |
From: Stefan V. <bo...@sk...> - 2004-01-18 12:13:16
|
Hey, Has annyone tried writing BLOBs to a sqlite db using qsqlite ?? Ive tried it the way it is shown in the examples ($qt/examples/sql/blob) but that doesn't work ... Using prepare() I always get a "Empty query" error message. Stefan Vunckx |
From: AgarFu <he...@cr...> - 2004-01-14 12:56:53
|
El Miércoles, 14 de Enero de 2004 10:33, Richard Taylor escribió: > > If you need an example look at > > http://krunning.sourceforge.net > > i'm using sqlite there ... this is another example: http://kolombo.lebrillo.osl.ull.es http://lebrillo.osl.ull.es/projects/kolombo I never had a problem related to qsqlite, well, not true at all, but those bugs are fixed right now. -- --------------------------·={ AgarFu }=·------- | ._aasuas,. | | .adZ#X"!""!!X#Xc René Martín Rodríguez | | ._#X?` . ~4XXc Centro Superior de | | .jZ' _ss, ]b/j Informática Universidad | | jX( .7 .. )X[] De La Laguna. | | 3X 3 - ]X(] Grupo Usuarios Linux de | | 3o .],. _, ' 2': Canarias: www.gulic.org | | ]X; -]5s,_sa2"` Sitio en internet: | | 4Z> . "" | | {q, . croasanaso.sytes.net | | ."Xa | | -9as ag...@gu... | ------------------------------------------------- |
From: Richard T. <r.t...@er...> - 2004-01-14 10:39:26
|
=2D----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wednesday 14 January 2004 10:22 am, Andreas Scherf wrote: > I would use the Qt database sheme beacause sqlite would be included int t= he > upcoming 3.3 release. > This is good news indeed. Does this mean that trolltech are taking on the=20 sqlite maintainance as well? Will it require a compile time flag like the mysql support? I am worried th= at=20 a user might have to recompile qt in order to use the app. > -- For normal use i would say its stable. For myself i never had problems > with it. > This is reassuring. > You could do it with shiping the needed sqlite files with your > package or wait until qt3.3 or let the user do the work and link to sqlite sqlite itself does not appear to be a problem as it is packaged widely with= =20 the distros. It was the qsqlite adaptor bit that I was worried about. Is th= is=20 loaded into Qt by the app or does it need to be compiled into Qt. I would n= ot=20 like to have to require all the users to upgrade to qt3.3 or to recompile=20 their qt installation. > -- You could so all that thing inside you app and the user didn't know wh= at > happens ... This is what I wanted to hear. > > If you need an example look at > http://krunning.sourceforge.net > i'm using sqlite there ... I'll take a look. Thanks for the prompt response. Richard =2D --=20 QinetiQ =20 B009 Woodward Building St. Andrews Road Malvern Worcs WR14 3PS Jabber: Ric...@ja... PGPKey: http://search.keyserver.net:11371/pks/lookup?op=3Dget&search=3D0xA7= DA9FD9 Key fingerprint =3D D051 A121 E7C3 485F 3C0E 1593 ED9E D868 A7DA 9FD9 =2D----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFABRr97Z7YaKfan9kRAptbAKCq5R4Uz1CPXkLeZABw4J52lCKqtQCg1Bjr lh/JSoWrjS6ui9jk3bL2Ir4=3D =3DeKf5 =2D----END PGP SIGNATURE----- |
From: Andreas S. <sc...@we...> - 2004-01-14 10:22:42
|
Hi I have just started to help out on a photo management application called iota. The first task I am look at is moving the current Berkely database backen to a more 'full featured' database. Sqlite is looking like a good fit. My current dilemma is whether to interface directly with sqlite or instead to use the Qt database interface and use qsqlite. This would provide for adding support for other, larger, databases later but raises some concerns in my mind. I would use the Qt database sheme beacause sqlite would be included int the upcoming 3.3 release. I am not new to programming or to databases but I am new to Qt and sqlite, so bear with me if I sound a little nieve. On with the questions... 1) How mature / stable is qsqlite? I don't mind helping to stablise it, I just want to get a feel for what I am letting myself in for. -- For normal use i would say its stable. For myself i never had problems with it. 2) qsqlite is not currently part of the main distros (at least not Gentoo which is my development platform). What would our app need to do at install time to make qsqlite available? Is it possible to install qsqlite just for use with one app or is there a separate 'system wide' install that the user would need to perform? Is it possible to package qsqlite along with the app if needed? I am concerned that the install process should remain as simple as possible or at least as simple as it is with the existing Berkeley database. -- You could do it with shiping the needed sqlite files with your package or wait until qt3.3 or let the user do the work and link to sqlite ... 3) From what I understand about sqlite, the user does not need to perform any initialisation steps prior to an app making use of the database and there are no 'username, password' issues for the user to deal with. Is this true for qsqlite as well? -- You could so all that thing inside you app and the user didn't know what happens ... I hope these questions make sense. Deciding on a database interface approach is a tricky decision and will have long lasting implications for the internal architecture of the app, so I hope you don't mind me asking these questions. -- I hope this answers make sense ;-) If you need an example look at http://krunning.sourceforge.net i'm using sqlite there ... Many thanks. Richard No Problem Andreas - -- Jabber: Ric...@ja... PGPKey: http://search.keyserver.net:11371/pks/lookup?op=get&search=0xA7DA9FD9 Key fingerprint = D051 A121 E7C3 485F 3C0E 1593 ED9E D868 A7DA 9FD9 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFABQAo7Z7YaKfan9kRAjHwAJ41ZdOjcEIGcJPUtHKh8ivBQ9RqvQCZAWPo lBPdtRtdwfN3YB8x9ymVfXw= =1sIR -----END PGP SIGNATURE----- ------------------------------------------------------- This SF.net email is sponsored by: Perforce Software. Perforce is the Fast Software Configuration Management System offering advanced branching capabilities and atomic changes on 50+ platforms. Free Eval! http://www.perforce.com/perforce/loadprog.html _______________________________________________ QSQLite-users mailing list QSQ...@li... https://lists.sourceforge.net/lists/listinfo/qsqlite-users ______________________________________________________________________________ Nachrichten, Musik und Spiele schnell und einfach per Quickstart im WEB.DE Screensaver - Gratis downloaden: http://screensaver.web.de/?mc=021110 |
From: Richard T. <r.t...@er...> - 2004-01-14 08:45:01
|
=2D----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi I have just started to help out on a photo management application called io= ta.=20 The first task I am look at is moving the current Berkely database backen t= o=20 a more 'full featured' database. Sqlite is looking like a good fit.=20 My current dilemma is whether to interface directly with sqlite or instead = to=20 use the Qt database interface and use qsqlite. This would provide for addin= g=20 support for other, larger, databases later but raises some concerns in my=20 mind. I am not new to programming or to databases but I am new to Qt and sqlite, = so=20 bear with me if I sound a little nieve. On with the questions... 1) How mature / stable is qsqlite? I don't mind helping to stablise it, I j= ust=20 want to get a feel for what I am letting myself in for. 2) qsqlite is not currently part of the main distros (at least not Gentoo=20 which is my development platform). What would our app need to do at install= =20 time to make qsqlite available? Is it possible to install qsqlite just for= =20 use with one app or is there a separate 'system wide' install that the user= =20 would need to perform? Is it possible to package qsqlite along with the app= =20 if needed? I am concerned that the install process should remain as simple = as=20 possible or at least as simple as it is with the existing Berkeley database. 3) From what I understand about sqlite, the user does not need to perform a= ny=20 initialisation steps prior to an app making use of the database and there a= re=20 no 'username, password' issues for the user to deal with. Is this true for= =20 qsqlite as well?=20 I hope these questions make sense. Deciding on a database interface approac= h=20 is a tricky decision and will have long lasting implications for the intern= al=20 architecture of the app, so I hope you don't mind me asking these questions= =2E=20 Many thanks. Richard =2D --=20 Jabber: Ric...@ja... PGPKey: http://search.keyserver.net:11371/pks/lookup?op=3Dget&search=3D0xA7= DA9FD9 Key fingerprint =3D D051 A121 E7C3 485F 3C0E 1593 ED9E D868 A7DA 9FD9 =2D----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFABQAo7Z7YaKfan9kRAjHwAJ41ZdOjcEIGcJPUtHKh8ivBQ9RqvQCZAWPo lBPdtRtdwfN3YB8x9ymVfXw=3D =3D1sIR =2D----END PGP SIGNATURE----- |
From: AgarFu <he...@cr...> - 2003-12-27 21:35:48
|
El Viernes, 26 de Diciembre de 2003 15:52, Dominik Seichter escribió: uhmm sorry /* TODO: Hay que poner que demonios es lo que pasa no?¿ */ /* TODO: we have to say waht hell is happening, don't you think?*/ ;-) > Hi, > > I tried with KBarcode and it seems to work fine :-D. > By reading the diff of your path I only found one issue: > > + /* TODO: Hay que poner que demonios es lo que pasa no?¿ */ > Maybe its better to keep comments in english, so that everyone can > understand them :). > > Thanks for your contribution. > > CU Dom > > Am Donnerstag, 25. Dezember 2003 16:00 schrieb AgarFu: > > Well, I've just commit some bugfixes and some new features. Try it, > > please. > > > > Merry Christmas! -- --------------------------·={ AgarFu }=·------- | ._aasuas,. | | .adZ#X"!""!!X#Xc René Martín Rodríguez | | ._#X?` . ~4XXc Centro Superior de | | .jZ' _ss, ]b/j Informática Universidad | | jX( .7 .. )X[] De La Laguna. | | 3X 3 - ]X(] Grupo Usuarios Linux de | | 3o .],. _, ' 2': Canarias: www.gulic.org | | ]X; -]5s,_sa2"` Sitio en internet: | | 4Z> . "" | | {q, . croasanaso.sytes.net | | ."Xa | | -9as ag...@gu... | ------------------------------------------------- |
From: Dominik S. <dom...@we...> - 2003-12-26 15:53:52
|
Hi, I tried with KBarcode and it seems to work fine :-D. By reading the diff of your path I only found one issue: + /* TODO: Hay que poner que demonios es lo que pasa no?=BF */ Maybe its better to keep comments in english, so that everyone can understa= nd=20 them :).=20 Thanks for your contribution. CU Dom Am Donnerstag, 25. Dezember 2003 16:00 schrieb AgarFu: > Well, I've just commit some bugfixes and some new features. Try it, pleas= e. > > Merry Christmas! =2D-=20 ********************************************************************** Dominik Seichter - dom...@we... KRename - http://www.krename.net - Powerful batch renamer for KDE KBarcode - http://www.kbarcode.net - Barcode and label printing KESI - http://kesi.sf.net - KESI Easy SQL Import ********************************************************************** |
From: AgarFu <he...@cr...> - 2003-12-25 15:02:40
|
Well, I've just commit some bugfixes and some new features. Try it, please. Merry Christmas! -- --------------------------·={ AgarFu }=·------- | ._aasuas,. | | .adZ#X"!""!!X#Xc René Martín Rodríguez | | ._#X?` . ~4XXc Centro Superior de | | .jZ' _ss, ]b/j Informática Universidad | | jX( .7 .. )X[] De La Laguna. | | 3X 3 - ]X(] Grupo Usuarios Linux de | | 3o .],. _, ' 2': Canarias: www.gulic.org | | ]X; -]5s,_sa2"` Sitio en internet: | | 4Z> . "" | | {q, . croasanaso.sytes.net | | ."Xa | | -9as ag...@gu... | ------------------------------------------------- |
From: Robert W. <ro...@wi...> - 2003-10-05 07:12:33
|
Fine with me... On Sunday 21 September 2003 23:15, Roberto Alsina wrote: > Hello, > > Since qsqlite seems to be working (a couple apps use it), I am > proposing it to get into KDE, where it will become popular and well > maintained (in theory ;-). > > By policy, it has to be under the LGPL instead of the GPL. > > But to change that, I need permission from all authors, if they > agree. > > I am of course granting it, but I need all to do it. > > I see a large patch by Robert Wittams (BTW, the patch in the patch > manager is applied or not?), and bugfixes by agarfu. > > If anyone else made a substantial modification, or knows of a > substantial modification made by someone else, please also step up! > > Thanks in advance, |
From: Dominik S. <dom...@we...> - 2003-09-28 12:19:31
|
Hello, I just wanted to announce that KBarcode CVS (http://www.kbarcode.net) finally works with SQLite using the qsqlite Qt plugin. Previously only MySQL was supported. I did only a few tests, but the qsqlite plugin seems to work fine. CU Dom -- ********************************************************************** Dominik Seichter - dom...@we... KRename - http://www.krename.net - Powerful batch renamer for KDE KBarcode - http://www.kbarcode.net - Barcode and label printing KESI - http://kesi.sf.net - KESI Easy SQL Import ********************************************************************** |
From: Dominik S. <dom...@we...> - 2003-09-24 15:45:18
|
"Dominik Seichter" <dom...@we...> schrieb am 24.09.03 16:40:00: > "Roberto Alsina" <ra...@kd...> schrieb am 23.09.03 19:48:52: > > > > > > Do you have the email address of Robert Wittams? The web archive at > > sourceforge doesn't show it. > I think so. But as I am not at home this week and answer all mails from an internet cafe,I do not have it at hand right now. I'll look for it as soon as I am back. > > CU Dom > ______________________________________________________________________________ Die Besten ihrer Klasse! WEB.DE FreeMail (1,7) und WEB.DE Club (1,9) - bei der Stiftung Warentest - ein Doppelsieg! http://f.web.de/?mc=021184 |
From: Andreas S. <sc...@we...> - 2003-09-21 22:02:40
|
Hello, after a long time i will try to add some work to qsqlite again. And i have no problems with changing its license to LGPL. I didn't see any disadvantages in changing this license. So i will soon (in a few days check the sources and try to get back into it ... Greeting from Germany Andreas Am Montag, 22. September 2003 00:15 schrieb Roberto Alsina: > Hello, > > Since qsqlite seems to be working (a couple apps use it), I am proposing > it to get into KDE, where it will become popular and well maintained (in > theory ;-). > > By policy, it has to be under the LGPL instead of the GPL. > > But to change that, I need permission from all authors, if they agree. > > I am of course granting it, but I need all to do it. > > I see a large patch by Robert Wittams (BTW, the patch in the patch manager > is applied or not?), and bugfixes by agarfu. > > If anyone else made a substantial modification, or knows of a substantial > modification made by someone else, please also step up! > > Thanks in advance, -- Andreas Scherf ICQ: 240328793 sc...@we... |
From: Roberto A. <ra...@kd...> - 2003-09-21 21:52:59
|
Hello, Since qsqlite seems to be working (a couple apps use it), I am proposing it to get into KDE, where it will become popular and well maintained (in theory ;-). By policy, it has to be under the LGPL instead of the GPL. But to change that, I need permission from all authors, if they agree. I am of course granting it, but I need all to do it. I see a large patch by Robert Wittams (BTW, the patch in the patch manager is applied or not?), and bugfixes by agarfu. If anyone else made a substantial modification, or knows of a substantial modification made by someone else, please also step up! Thanks in advance, -- ("\''/").__..-''"`-. . Roberto Alsina `9_ 9 ) `-. ( ).`-._.`) ra...@kd... (_Y_.)' ._ ) `._`. " -.-' KDE Developer (MFCH) _..`-'_..-_/ /-'_.' (l)-'' ((i).' ((!.' Buenos Aires - Argentina Imminentizing the eschaton since 1971. |
From: BenLau <be...@sw...> - 2003-08-07 03:57:16
|
-- Ben Embedded Linux Developer be...@sw... Sun Wah Linux Limited www.sw-linux.com Tel: 852 2250 0227 Fax: 852 2259 9112 |
From: Dominik S. <dom...@we...> - 2003-07-24 15:36:32
|
Am Dienstag, 22. Juli 2003 23:28 schrieb AgarFu: > El Lunes, 21 de Julio de 2003 17:01, Dominik Seichter escribi=F3: > > Am Sonntag, 20. Juli 2003 02:08 schrieb AgarFu: > > > El S=E1bado, 19 de Julio de 2003 09:20, Dominik Seichter escribi=F3: > > > > Account created. Sorry for the long delay. > > > > > > there isn't any problem, yesterday I'v solved one more bug. > > > > Thanks for fixing all these problems. Did you commit your fixes already > > to CVS? If qsqlite works otherwise well for you, we should perhaps do a > > public release. > > > > CU Dom > > I can't write to CVS ;-( I updated your permissions. You should be able to commit to CVS now. Be sur= e=20 to use developers CVS and not annoncvs! CU Dom =2D-=20 ************************************************************ Dominik Seichter - dom...@we... Krename - http://www.krename.net KBarcode - http://www.kbarcode.net ************************************************************ |
From: AgarFu <ag...@so...> - 2003-07-24 14:57:33
|
=2D----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 El Lunes, 21 de Julio de 2003 17:01, Dominik Seichter escribi=F3: > Am Sonntag, 20. Juli 2003 02:08 schrieb AgarFu: > > El S=E1bado, 19 de Julio de 2003 09:20, Dominik Seichter escribi=F3: > > > Account created. Sorry for the long delay. > > > > there isn't any problem, yesterday I'v solved one more bug. > > Thanks for fixing all these problems. Did you commit your fixes already to > CVS? If qsqlite works otherwise well for you, we should perhaps do a publ= ic > release. > > CU Dom I can't write to CVS ;-( =2D -- --------------------------=B7=3D{ AgarFu }=3D=B7------- | ._aasuas,. | | .adZ#X"!""!!X#Xc Ren=E9 Mart=EDn Rodr=EDguez | | ._#X?` . ~4XXc Centro Superior de | | .jZ' _ss, ]b/j Inform=E1tica Universidad | | jX( .7 .. )X[] De La Laguna. | | 3X 3 - ]X(] Grupo Usuarios Linux de | | 3o .],. _, ' 2': Canarias: www.gulic.org | | ]X; -]5s,_sa2"` Sitio en internet: | | 4Z> . "" | | {q, . croasanaso.sytes.net (difunto) | | ."Xa | | -9as ag...@gu... | ------------------------------------------------- =2D----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/HayXHfyGHDFT1lYRAvQAAKDAwH1uWfktM6azZjJvIPEeyFl8NACfRKSP IOum9saZuPH/8QHwpA2K1NQ=3D =3DfDu1 =2D----END PGP SIGNATURE----- |
From: Dominik S. <dom...@we...> - 2003-07-21 16:02:04
|
Am Sonntag, 20. Juli 2003 02:08 schrieb AgarFu: > El S=E1bado, 19 de Julio de 2003 09:20, Dominik Seichter escribi=F3: > > Account created. Sorry for the long delay. > > there isn't any problem, yesterday I'v solved one more bug. Thanks for fixing all these problems. Did you commit your fixes already to= =20 CVS? If qsqlite works otherwise well for you, we should perhaps do a public= =20 release. CU Dom =2D-=20 ************************************************************ Dominik Seichter - dom...@we... Krename - http://www.krename.net KBarcode - http://www.kbarcode.net ************************************************************ |
From: AgarFu <ag...@so...> - 2003-07-20 00:09:46
|
=2D----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 El S=E1bado, 19 de Julio de 2003 09:20, Dominik Seichter escribi=F3: > Account created. Sorry for the long delay. there isn't any problem, yesterday I'v solved one more bug. If you use triggers on tables or views you can use a function named RAISE. = If=20 you use something like: CREATE TRIGGER update_sexo BEFORE UPDATE OF sexo ON paloma =46OR EACH ROW BEGIN SELECT RAISE (ABORT, "Paloma con descendencia, no se le puede cambiar el= =20 sexo.") FROM paloma WHERE madreID =3D old.palomaID OR padreID =3D old.palomaID; END; and you try to update an ilegal row, sqlite compiles the query without any= =20 problem but when the firs step is done an error code is returned. I've catc= h=20 this code and set LastError. > > CU Dom =2D --=20 --------------------------=B7=3D{ AgarFu }=3D=B7------- | ._aasuas,. | | .adZ#X"!""!!X#Xc Ren=E9 Mart=EDn Rodr=EDguez | | ._#X?` . ~4XXc Centro Superior de | | .jZ' _ss, ]b/j Inform=E1tica Universidad | | jX( .7 .. )X[] De La Laguna. | | 3X 3 - ]X(] Grupo Usuarios Linux de | | 3o .],. _, ' 2': Canarias: www.gulic.org | | ]X; -]5s,_sa2"` Sitio en internet: | | 4Z> . "" | | {q, . croasanaso.sytes.net (difunto) | | ."Xa | | -9as ag...@gu... | ------------------------------------------------- =2D----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/Gd2cHfyGHDFT1lYRAqO2AKCRrq3jj0R3xi1j6tzJhuo2rpOqQgCcChNO Lky0bqlM3SOwHfUOuOko468=3D =3Dog1o =2D----END PGP SIGNATURE----- |
From: Dominik S. <dom...@we...> - 2003-07-19 08:18:12
|
Am Dienstag, 15. Juli 2003 14:44 schrieb AgarFu: > El Martes, 15 de Julio de 2003 08:12, Dominik Seichter escribi=F3: > > Hello, > > > > Am Dienstag, 15. Juli 2003 00:55 schrieb AgarFu: > > > Hi every one, I'm usin qsqlite in two projects and I have a bug. > > > > I pleased to hear that qsqlite is used in real world projets. If you wa= nt > > to I can give you a CVS account. So that you can continue to fix bugs in > > the source directly as soon as you find them. Unfortunately I have never > > found the time to work on qsqlite. I just set the SF.net project up and > > put everything into CVS. The real work was done by Roberto Alsina. > > > > If you don't want CVS access, I will commit the bug fix for you. > > Otherwise, if you want CVS access, you need a SF.net username and have = to > > send it to me. > > > > CU Dom > > Ok, let me an account, my username is: agarfu Account created. Sorry for the long delay. CU Dom =2D-=20 ************************************************************ Dominik Seichter - dom...@we... Krename - http://www.krename.net KBarcode - http://www.kbarcode.net ************************************************************ |
From: AgarFu <ag...@so...> - 2003-07-15 12:44:53
|
=2D----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 El Martes, 15 de Julio de 2003 08:12, Dominik Seichter escribi=F3: > Hello, > > Am Dienstag, 15. Juli 2003 00:55 schrieb AgarFu: > > Hi every one, I'm usin qsqlite in two projects and I have a bug. > > I pleased to hear that qsqlite is used in real world projets. If you want > to I can give you a CVS account. So that you can continue to fix bugs in > the source directly as soon as you find them. Unfortunately I have never > found the time to work on qsqlite. I just set the SF.net project up and p= ut > everything into CVS. The real work was done by Roberto Alsina. > > If you don't want CVS access, I will commit the bug fix for you. Otherwis= e, > if you want CVS access, you need a SF.net username and have to send it to > me. > > CU Dom Ok, let me an account, my username is: agarfu I can't work in my own projects all time as I wish, but I'll do evething I= =20 can. =2D --=20 --------------------------=B7=3D{ AgarFu }=3D=B7------- | ._aasuas,. | | .adZ#X"!""!!X#Xc Ren=E9 Mart=EDn Rodr=EDguez | | ._#X?` . ~4XXc Centro Superior de | | .jZ' _ss, ]b/j Inform=E1tica Universidad | | jX( .7 .. )X[] De La Laguna. | | 3X 3 - ]X(] Grupo Usuarios Linux de | | 3o .],. _, ' 2': Canarias: www.gulic.org | | ]X; -]5s,_sa2"` Sitio en internet: | | 4Z> . "" | | {q, . croasanaso.sytes.net (difunto) | | ."Xa | | -9as ag...@gu... | ------------------------------------------------- =2D----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/E/cbHfyGHDFT1lYRAgicAKCX33hj90F9E2c3NB4tN960hy5qoQCgn83Z pSUxKNzbLd5X3ETTolMHB+E=3D =3DHkn5 =2D----END PGP SIGNATURE----- |
From: Dominik S. <dom...@we...> - 2003-07-15 07:10:13
|
Hello, Am Dienstag, 15. Juli 2003 00:55 schrieb AgarFu: > Hi every one, I'm usin qsqlite in two projects and I have a bug. I pleased to hear that qsqlite is used in real world projets. If you want to I can give you a CVS account. So that you can continue to fix bugs in the source directly as soon as you find them. Unfortunately I have never found the time to work on qsqlite. I just set the SF.net project up and put everything into CVS. The real work was done by Roberto Alsina. If you don't want CVS access, I will commit the bug fix for you. Otherwise, if you want CVS access, you need a SF.net username and have to send it to me. CU Dom -- ************************************************************ Dominik Seichter - dom...@we... Krename - http://www.krename.net KBarcode - http://www.kbarcode.net ************************************************************ |
From: AgarFu <ag...@so...> - 2003-07-14 22:57:11
|
-- Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Content-Disposition: inline Hi every one, I'm usin qsqlite in two projects and I have a bug. You can't access views from Qt-designer when you try to add a QDataTable to a form. I have solved this. To do it I had to add [ and ] to field names because sqlite names view fields as they are described in the query and I have a field called: case sex where '0' then 'Male' where '1' then 'Female' end so there is only a way to acces that field, using brackets. here is qsqlite.cpp Thank you for your great work!!!!! -- --------------------------·={ AgarFu }=·------- | ._aasuas,. | | .adZ#X"!""!!X#Xc René Martín Rodríguez | | ._#X?` . ~4XXc Centro Superior de | | .jZ' _ss, ]b/j Informática Universidad | | jX( .7 .. )X[] De La Laguna. | | 3X 3 - ]X(] Grupo Usuarios Linux de | | 3o .],. _, ' 2': Canarias: www.gulic.org | | ]X; -]5s,_sa2"` Sitio en internet: | | 4Z> . "" | | {q, . croasanaso.sytes.net (difunto) | | ."Xa | | -9as ag...@gu... | ------------------------------------------------- -- Content-Type: text/x-c++src; charset="iso-8859-1"; name="qsqlite.cpp" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="qsqlite.cpp" #include "qsqlite.h" #include <sqlite.h> #include <stdlib.h> #include <qregexp.h> SqliteDriver::SqliteDriver (QObject * parent, const char *name): QSqlDriver(parent,name){ } bool SqliteDriver::open ( const QString & db, const QString &, const QString &, const QString &, int) { char *errmsg=0; bool ok=false; _db=sqlite_open(db.latin1(),0,&errmsg); if (db){ if (SQLITE_OK==sqlite_exec(_db,"PRAGMA empty_result_callbacks = ON;", NULL,NULL,NULL)){ ok=true; } }if (!ok){ setOpen (false); setOpenError(true); setLastError(QSqlError(errmsg,QString::null,QSqlError::Unknown)); return false; }else{ setOpen (true); setOpenError(false); return true; } } void SqliteDriver::close (){ if (_db) sqlite_close(_db); } bool SqliteDriver::hasFeature ( QSqlDriver::DriverFeature feature) const{ switch(feature){ case QSqlDriver::Transactions: case QSqlDriver::QuerySize: case QSqlDriver::Unicode: return true; case QSqlDriver::BLOB: case QSqlDriver::PreparedQueries: case QSqlDriver::NamedPlaceholders: case QSqlDriver::PositionalPlaceholders: return false; } } bool SqliteDriver::beginTransaction (){ int err=sqlite_exec(_db,"BEGIN TRANSACTION;",NULL,NULL,NULL); if (SQLITE_OK==err) return true; else return false; } bool SqliteDriver::commitTransaction (){ int err=sqlite_exec(_db,"COMMIT TRANSACTION;",NULL,NULL,NULL); if (SQLITE_OK==err) return true; else return false; } bool SqliteDriver::rollbackTransaction (){ int err=sqlite_exec(_db,"ROLLBACK TRANSACTION;",NULL,NULL,NULL); if (SQLITE_OK==err) return true; else return false; } /* Dunno what to do here really. Currently, I think I will make it use primary keys.... maybe add support for other indices later. */ QSqlIndex SqliteDriver::primaryIndex ( const QString & tableName ) const{ sqlite_vm *vm; const char *tail; const char **vals; const char **names; int ncol; char* errmsg; QSqlIndex index; QString query ="SELECT sql " "FROM sqlite_master " "WHERE type='table' OR type='view'" "AND name='"+tableName + "';" ; // is there an integer primary key? int err=sqlite_compile(_db, query, &tail, &vm, NULL); if(err != SQLITE_OK){ return QSqlIndex(); } err = sqlite_step(vm,&ncol,&vals, &names); if(err == SQLITE_ROW){ // We found a create statement.. QString sql = vals[0]; sql.replace("\n", " "); QRegExp re("(\\w+)\\s+\\w+(\\s+primary\\s+key)", false); if ( re.search(sql) > -1 ){ // We found a primary key.. QString primary = re.cap(1); QSqlField pkey(primary, QVariant::Int); index.append(pkey); } }else{ qDebug("sqlite_step error"); } sqlite_finalize(vm, NULL); return index; } QSqlQuery SqliteDriver::createQuery () const{ //qDebug ("sqlitedriver::createquery"); return QSqlQuery(new SqliteResult(this)); } QSqlRecord SqliteDriver::record ( const QString & tableName ) const{ //qDebug ("sqlitedriver::record tablename=%s",tableName.latin1()); return recordInfo(tableName).toRecord(); } QSqlRecordInfo SqliteDriver::recordInfo ( const QString & tablename ) const{ //qDebug ("SqliteDriver::recordInfo tablename=%s",tablename.latin1()); sqlite_vm *vm; const char *tail; const char **vals; const char **names; int ntab,ncol; char *errmsg; QSqlFieldInfoList l; QString query; query="PRAGMA table_info("+tablename+");"; int err=sqlite_compile(_db,query, &tail, &vm, &errmsg); if (err == SQLITE_OK){ while ( sqlite_step(vm,&ncol,&vals, &names) == SQLITE_ROW ){ QString cname = vals[1]; cname = "[" + cname + "]"; QVariant::Type t; QVariant defval; QString t1=vals[2]; //Check for integers if ((t1.find ("int")==0) || (t1.find ("tinyint")==0) || (t1.find ("bit")==0) || (t1.find ("bool")==0) || (t1.find ("smallint")==0) || (t1.find ("mediumint")==0) || (t1.find ("integer")==0) || (t1.find ("bigint")==0)){ t=QVariant::Int; } else if ((t1.find ("float")==0) || (t1.find ("double")==0) || (t1.find ("real")==0) || (t1.find ("dec")==0) || (t1.find ("numeric")==0) || (t1.find ("number")==0)){ t=QVariant::Double; } //TODO The date/time types are broken else if ((t1.find ("datetime")==0) || (t1.find ("time")==0) || (t1.find ("date")==0)){ t=QVariant::DateTime; } else{ t=QVariant::String; } defval=QString(vals[4]); defval.cast(t); l << QSqlFieldInfo (cname,t,-1,-1,-1,defval); } }else{ qDebug("error in compile:",errmsg); } err = sqlite_finalize(vm, &errmsg); if( err != SQLITE_OK){ qDebug("error in finalize", errmsg); } return QSqlRecordInfo (l); } QStringList SqliteDriver::tables( const QString& ) const { //qDebug ("Getting list of tables"); sqlite_vm *vm; const char *tail; const char **vals; const char **names; int ntab,ncol; QStringList r; char *errmsg; int err=sqlite_compile(_db,"SELECT name " "FROM sqlite_master " "WHERE type='table' OR type='view'" "ORDER BY name;", &tail, &vm, &errmsg); if (err == SQLITE_OK){ while ( sqlite_step(vm,&ncol,&vals, &names) == SQLITE_ROW ){ r << vals[0]; } sqlite_finalize(vm, NULL); return r; }else{ qDebug ("could not get list of tables: %d, %s",err,errmsg); } } SqliteResult::SqliteResult( const QSqlDriver* d ): QSqlResult(d){ db = static_cast<const SqliteDriver*>(d); } SqliteResult::~SqliteResult(){ } QVariant SqliteResult::data( int i ){ QStringList& row = tab[at()]; if(i < row.count()) return QVariant(row[i]); else return QVariant(); } void SqliteResult::setQuery ( const QString &q ) { //qDebug ("sqliteresult::setquery: %s",q.latin1()); query=q.stripWhiteSpace()+";"; if (q.find("select",0,false)==0) setSelect(true); else setSelect(false); } bool SqliteResult::reset ( const QString& q ){ sqlite_vm* vm; const char** vals; const char** names; query = q; char* errmsg; const char* tail; int err; setQuery(query); tab.clear(); err = sqlite_compile(db->_db,query.latin1(), &tail, &vm, &errmsg); if(err != SQLITE_OK){ qDebug("SQL compile failed:", errmsg); return FALSE; } while(sqlite_step(vm,&cols,&vals, &names) == SQLITE_ROW){ QStringList row; for(int i =0; i < cols; i++){ // copy all the vals.. row.append(vals[i]); } tab.append(row); } sqlite_finalize(vm, NULL); setActive(true); return true; } bool SqliteResult::fetch( int i){ if( i < tab.count() && i>=0 ){ setAt(i); return true; }else{ return false; } } bool SqliteResult::isNull( int i ){ QStringList& row = tab[at()]; if(i < row.count()) return row[i].isEmpty(); else return true; } bool SqliteResult::fetchFirst(){ setAt(0); return true; } bool SqliteResult::fetchLast(){ setAt(tab.count() - 1); return true; } //QSqlRecord SqliteResult::record(){} int SqliteResult::size(){ return tab.count(); } int SqliteResult::numRowsAffected(){ return sqlite_changes(db->_db); } -- Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline =2D----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi every one, I'm usin qsqlite in two projects and I have a bug. You can't access views from Qt-designer when you try to add a QDataTable to= a=20 form. I have solved this. To do it I had to add [ and ] to field names because=20 sqlite names view fields as they are described in the query and I have a=20 field called: case sex where '0' then 'Male' where '1' then 'Female' end so there is only a way to acces that field, using brackets. here is qsqlite.cpp Thank you for your great work!!!!! =2D --=20 --------------------------=B7=3D{ AgarFu }=3D=B7------- | ._aasuas,. | | .adZ#X"!""!!X#Xc Ren=E9 Mart=EDn Rodr=EDguez | | ._#X?` . ~4XXc Centro Superior de | | .jZ' _ss, ]b/j Inform=E1tica Universidad | | jX( .7 .. )X[] De La Laguna. | | 3X 3 - ]X(] Grupo Usuarios Linux de | | 3o .],. _, ' 2': Canarias: www.gulic.org | | ]X; -]5s,_sa2"` Sitio en internet: | | 4Z> . "" | | {q, . croasanaso.sytes.net (difunto) | | ."Xa | | -9as ag...@gu... | ------------------------------------------------- =2D----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/EzTpHfyGHDFT1lYRAm2tAJ9lLBv6LxTgQOPYEqGA/nqfnwjyuQCeIGrT 1QqPXLZ6hzrxLp3tdpdr+uA=3D =3DtnAn =2D----END PGP SIGNATURE----- -- Content-Type: text/x-c++src; charset="iso-8859-1"; name="qsqlite.cpp" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="qsqlite.cpp" #include "qsqlite.h" #include <sqlite.h> #include <stdlib.h> #include <qregexp.h> SqliteDriver::SqliteDriver (QObject * parent, const char *name): QSqlDriver(parent,name){ } bool SqliteDriver::open ( const QString & db, const QString &, const QString &, const QString &, int) { char *errmsg=0; bool ok=false; _db=sqlite_open(db.latin1(),0,&errmsg); if (db){ if (SQLITE_OK==sqlite_exec(_db,"PRAGMA empty_result_callbacks = ON;", NULL,NULL,NULL)){ ok=true; } }if (!ok){ setOpen (false); setOpenError(true); setLastError(QSqlError(errmsg,QString::null,QSqlError::Unknown)); return false; }else{ setOpen (true); setOpenError(false); return true; } } void SqliteDriver::close (){ if (_db) sqlite_close(_db); } bool SqliteDriver::hasFeature ( QSqlDriver::DriverFeature feature) const{ switch(feature){ case QSqlDriver::Transactions: case QSqlDriver::QuerySize: case QSqlDriver::Unicode: return true; case QSqlDriver::BLOB: case QSqlDriver::PreparedQueries: case QSqlDriver::NamedPlaceholders: case QSqlDriver::PositionalPlaceholders: return false; } } bool SqliteDriver::beginTransaction (){ int err=sqlite_exec(_db,"BEGIN TRANSACTION;",NULL,NULL,NULL); if (SQLITE_OK==err) return true; else return false; } bool SqliteDriver::commitTransaction (){ int err=sqlite_exec(_db,"COMMIT TRANSACTION;",NULL,NULL,NULL); if (SQLITE_OK==err) return true; else return false; } bool SqliteDriver::rollbackTransaction (){ int err=sqlite_exec(_db,"ROLLBACK TRANSACTION;",NULL,NULL,NULL); if (SQLITE_OK==err) return true; else return false; } /* Dunno what to do here really. Currently, I think I will make it use primary keys.... maybe add support for other indices later. */ QSqlIndex SqliteDriver::primaryIndex ( const QString & tableName ) const{ sqlite_vm *vm; const char *tail; const char **vals; const char **names; int ncol; char* errmsg; QSqlIndex index; QString query ="SELECT sql " "FROM sqlite_master " "WHERE type='table' OR type='view'" "AND name='"+tableName + "';" ; // is there an integer primary key? int err=sqlite_compile(_db, query, &tail, &vm, NULL); if(err != SQLITE_OK){ return QSqlIndex(); } err = sqlite_step(vm,&ncol,&vals, &names); if(err == SQLITE_ROW){ // We found a create statement.. QString sql = vals[0]; sql.replace("\n", " "); QRegExp re("(\\w+)\\s+\\w+(\\s+primary\\s+key)", false); if ( re.search(sql) > -1 ){ // We found a primary key.. QString primary = re.cap(1); QSqlField pkey(primary, QVariant::Int); index.append(pkey); } }else{ qDebug("sqlite_step error"); } sqlite_finalize(vm, NULL); return index; } QSqlQuery SqliteDriver::createQuery () const{ //qDebug ("sqlitedriver::createquery"); return QSqlQuery(new SqliteResult(this)); } QSqlRecord SqliteDriver::record ( const QString & tableName ) const{ //qDebug ("sqlitedriver::record tablename=%s",tableName.latin1()); return recordInfo(tableName).toRecord(); } QSqlRecordInfo SqliteDriver::recordInfo ( const QString & tablename ) const{ //qDebug ("SqliteDriver::recordInfo tablename=%s",tablename.latin1()); sqlite_vm *vm; const char *tail; const char **vals; const char **names; int ntab,ncol; char *errmsg; QSqlFieldInfoList l; QString query; query="PRAGMA table_info("+tablename+");"; int err=sqlite_compile(_db,query, &tail, &vm, &errmsg); if (err == SQLITE_OK){ while ( sqlite_step(vm,&ncol,&vals, &names) == SQLITE_ROW ){ QString cname = vals[1]; cname = "[" + cname + "]"; QVariant::Type t; QVariant defval; QString t1=vals[2]; //Check for integers if ((t1.find ("int")==0) || (t1.find ("tinyint")==0) || (t1.find ("bit")==0) || (t1.find ("bool")==0) || (t1.find ("smallint")==0) || (t1.find ("mediumint")==0) || (t1.find ("integer")==0) || (t1.find ("bigint")==0)){ t=QVariant::Int; } else if ((t1.find ("float")==0) || (t1.find ("double")==0) || (t1.find ("real")==0) || (t1.find ("dec")==0) || (t1.find ("numeric")==0) || (t1.find ("number")==0)){ t=QVariant::Double; } //TODO The date/time types are broken else if ((t1.find ("datetime")==0) || (t1.find ("time")==0) || (t1.find ("date")==0)){ t=QVariant::DateTime; } else{ t=QVariant::String; } defval=QString(vals[4]); defval.cast(t); l << QSqlFieldInfo (cname,t,-1,-1,-1,defval); } }else{ qDebug("error in compile:",errmsg); } err = sqlite_finalize(vm, &errmsg); if( err != SQLITE_OK){ qDebug("error in finalize", errmsg); } return QSqlRecordInfo (l); } QStringList SqliteDriver::tables( const QString& ) const { //qDebug ("Getting list of tables"); sqlite_vm *vm; const char *tail; const char **vals; const char **names; int ntab,ncol; QStringList r; char *errmsg; int err=sqlite_compile(_db,"SELECT name " "FROM sqlite_master " "WHERE type='table' OR type='view'" "ORDER BY name;", &tail, &vm, &errmsg); if (err == SQLITE_OK){ while ( sqlite_step(vm,&ncol,&vals, &names) == SQLITE_ROW ){ r << vals[0]; } sqlite_finalize(vm, NULL); return r; }else{ qDebug ("could not get list of tables: %d, %s",err,errmsg); } } SqliteResult::SqliteResult( const QSqlDriver* d ): QSqlResult(d){ db = static_cast<const SqliteDriver*>(d); } SqliteResult::~SqliteResult(){ } QVariant SqliteResult::data( int i ){ QStringList& row = tab[at()]; if(i < row.count()) return QVariant(row[i]); else return QVariant(); } void SqliteResult::setQuery ( const QString &q ) { //qDebug ("sqliteresult::setquery: %s",q.latin1()); query=q.stripWhiteSpace()+";"; if (q.find("select",0,false)==0) setSelect(true); else setSelect(false); } bool SqliteResult::reset ( const QString& q ){ sqlite_vm* vm; const char** vals; const char** names; query = q; char* errmsg; const char* tail; int err; setQuery(query); tab.clear(); err = sqlite_compile(db->_db,query.latin1(), &tail, &vm, &errmsg); if(err != SQLITE_OK){ qDebug("SQL compile failed:", errmsg); return FALSE; } while(sqlite_step(vm,&cols,&vals, &names) == SQLITE_ROW){ QStringList row; for(int i =0; i < cols; i++){ // copy all the vals.. row.append(vals[i]); } tab.append(row); } sqlite_finalize(vm, NULL); setActive(true); return true; } bool SqliteResult::fetch( int i){ if( i < tab.count() && i>=0 ){ setAt(i); return true; }else{ return false; } } bool SqliteResult::isNull( int i ){ QStringList& row = tab[at()]; if(i < row.count()) return row[i].isEmpty(); else return true; } bool SqliteResult::fetchFirst(){ setAt(0); return true; } bool SqliteResult::fetchLast(){ setAt(tab.count() - 1); return true; } //QSqlRecord SqliteResult::record(){} int SqliteResult::size(){ return tab.count(); } int SqliteResult::numRowsAffected(){ return sqlite_changes(db->_db); } -- ---- |
From: Dominik S. <dom...@we...> - 2003-03-24 15:39:14
|
Hello Robert, Am Montag, 24. M=E4rz 2003 11:07 schrieben Sie: > Ok, checked it in. Thanks a lot. I was able to compile it without any problems. I also saw tha= t=20 make install did not work. I fixed it now hopefully. I could not test your= =20 driver, because of some other problems with my Qt installation. > Dunno, what other features are needed from this driver? Well, most importantly it should work. Did you test it with some real world= =20 apps, yet? CU Dom =2D-=20 ************************************************************ Dominik Seichter - dom...@we... Krename - http://www.krename.net KBarcode - http://www.kbarcode.net ************************************************************ |