[tpop3d-discuss]Database connection

ohp@pyrenet.fr ohp at pyrenet.fr
Wed, 30 Nov 2005 19:19:05 +0100 (MET)


  This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.
  Send mail to mime@docserver.cac.washington.edu for more info.

---559023410-851401618-1133374745=:21638
Content-Type: TEXT/PLAIN; charset=US-ASCII

You're right daniel!
I thought it would not work until the connection succeeded witch is'nt the
case.
This patch should be ok.
Left as an exercice parametrizing the number of loops and sleep time in
do_query. :)

It does work here for to 2 cases  I talked before.

Best regards.
On Wed, 30 Nov 2005, Daniel Tiefnig wrote:

> Date: Wed, 30 Nov 2005 18:21:07 +0100
> From: Daniel Tiefnig <tpop3d@inode.at>
> To: tpop3d-discuss@lists.beasts.org
> Subject: Re: [tpop3d-discuss]Database connection
>
> ohp@pyrenet.fr wrote:
> > My understanding is that auth_pgsql_init has to be called at drivers
> > init time to save the parametrized queries.
>
> That's true, and beside that it opens a connection to the database.
>
> > Of course, I could wipe db connection off and put it in an other
> > function, but that would mean a second pace to read conf file..
>
> I think you misunderstood the functionality of PQreset(). From the manual:
> "[PQreset] will close the connection to the server and attempt to
> reestablish a new connection to the same server, using all the same
> parameters previously used."
> So, there's no need to establish a new connection after PQreset(), as
> PQreset() should have allready done that.
>
>
> lg,
> daniel
>
> _______________________________________________
> tpop3d-discuss mailing list
> tpop3d-discuss@lists.beasts.org
> http://lists.beasts.org/mailman/listinfo/tpop3d-discuss
>
>

-- 
Olivier PRENANT        	        Tel: +33-5-61-50-97-00 (Work)
15, Chemin des Monges                +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                       +33-6-07-63-80-64 (GSM)
FRANCE                          Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
---559023410-851401618-1133374745=:21638
Content-Type: TEXT/PLAIN; charset=US-ASCII; name="tpop3d.diff"
Content-Transfer-Encoding: BASE64
Content-ID: <Pine.UW2.4.53.0511301919050.21638@sun.pyrenet>
Content-Description: 
Content-Disposition: attachment; filename="tpop3d.diff"

KioqIGF1dGhfcGdzcWwuYy5vcmlnCW1hciBqdWwgMTUgMDE6MzE6MjAgMjAw
Mw0KLS0tIGF1dGhfcGdzcWwuYwltZXIgbm92IDMwIDE4OjM4OjM3IDIwMDUN
CioqKioqKioqKioqKioqKg0KKioqIDE1MCwxNTUgKioqKg0KLS0tIDE1MCwx
NzkgLS0tLQ0KICAgKiBkZWJ1Z2dlci4gKi8NCiAgUEdjb25uICpwZ19jb25u
Ow0KICANCisgUEdyZXN1bHQgKmRvX3F1ZXJ5KGNvbnN0IGNoYXIgKnF1ZXJ5
KSB7DQorICAgaW50IGNvbm5fc3RhdHVzOw0KKyAgIGludCBsb29wPTA7DQor
ICAgUEdyZXN1bHQgKnJlcz1OVUxMOw0KKyAgIA0KKyANCisgICB3aGlsZSAo
KGNvbm5fc3RhdHVzID0gKHBnX2Nvbm4gPyBQUXN0YXR1cyhwZ19jb25uKSA6
IENPTk5FQ1RJT05fQkFEKSkNCisgCSA9PSBDT05ORUNUSU9OX0JBRCkgew0K
KyAgICAgaWYgKHBnX2Nvbm4pDQorICAgICAgIFBRcmVzZXQocGdfY29ubik7
DQorICAgICBpZiAoIXBnX2Nvbm4gfHwgKGNvbm5fc3RhdHVzPVBRc3RhdHVz
KHBnX2Nvbm4pKSA9PSBDT05ORUNUSU9OX0JBRCkgew0KKyAgICAgICBzbGVl
cCgxMCk7DQorICAgICAgIGxvb3ArKzsNCisgICAgICAgaWYgKGxvb3AgPT0g
NSkNCisgCWJyZWFrOw0KKyAgICAgfQ0KKyAgIH0NCisgICBpZiAobG9vcCA9
PSA1KSANCisgICAgIGxvZ19wcmludChMT0dfRVJSLCAiYXV0aF9wZ3NxbF9p
bml0OiBQUWNvbm5lY3RkYjogZmFpbGVkICglcykgZ2l2aW5nIHVwIGFmdGVy
ICVkIHRpbWVzIiwgUFFlcnJvck1lc3NhZ2UocGdfY29ubiksNSk7DQorICAg
ZWxzZQ0KKyAgICAgcmVzPVBRZXhlYyhwZ19jb25uLHF1ZXJ5KTsNCisgICBy
ZXR1cm4gcmVzOw0KKyB9DQorIA0KICBpbnQgYXV0aF9wZ3NxbF9pbml0KHZv
aWQpIHsNCiAgICAgIGNoYXIgKnVzZXJuYW1lID0gTlVMTCwgKnBhc3N3b3Jk
ID0gTlVMTCwgKmhvc3RuYW1lID0gTlVMTCwgKmRhdGFiYXNlID0gTlVMTCwg
KmxvY2FsaG9zdCA9ICJsb2NhbGhvc3QiLCAqczsNCiAgICAgIGNoYXIgKmRi
Y29ubmVjdCA9IE5VTEw7DQoqKioqKioqKioqKioqKioNCioqKiAyMTksMjMx
ICoqKioNCiAgICAgICAgICAgICAgcGFzc3dvcmQgPyBwYXNzd29yZCA6ICIi
DQogICAgICAgICAgKTsNCiAgICAgIA0KISAgICAgcGdfY29ubiA9IFBRY29u
bmVjdGRiKGRiY29ubmVjdCk7DQohICAgICBpZiAoUFFzdGF0dXMocGdfY29u
bikgPT0gQ09OTkVDVElPTl9CQUQpIHsNCiAgICAgICAgICBsb2dfcHJpbnQo
TE9HX0VSUiwgImF1dGhfcGdzcWxfaW5pdDogUFFjb25uZWN0ZGI6IGZhaWxl
ZCAoJXMpIiwgUFFlcnJvck1lc3NhZ2UocGdfY29ubikpOw0KLSAgICAgICAg
IGdvdG8gZmFpbDsNCi0gICAgIH0NCiAgDQohICAgICByZXQgPSAxOw0KICAN
CiAgZmFpbDoNCiAgICAgIGlmICh1c2VybmFtZSkgc3RyY2xyKHVzZXJuYW1l
KTsNCi0tLSAyNDMsMjUzIC0tLS0NCiAgICAgICAgICAgICAgcGFzc3dvcmQg
PyBwYXNzd29yZCA6ICIiDQogICAgICAgICAgKTsNCiAgICAgIA0KISAgICAg
ICBwZ19jb25uID0gUFFjb25uZWN0ZGIoZGJjb25uZWN0KTsNCiEgICAgICAg
aWYgKFBRc3RhdHVzKHBnX2Nvbm4pID09IENPTk5FQ1RJT05fQkFEKQ0KICAg
ICAgICAgIGxvZ19wcmludChMT0dfRVJSLCAiYXV0aF9wZ3NxbF9pbml0OiBQ
UWNvbm5lY3RkYjogZmFpbGVkICglcykiLCBQUWVycm9yTWVzc2FnZShwZ19j
b25uKSk7DQogIA0KISAJcmV0PTE7DQogIA0KICBmYWlsOg0KICAgICAgaWYg
KHVzZXJuYW1lKSBzdHJjbHIodXNlcm5hbWUpOw0KKioqKioqKioqKioqKioq
DQoqKiogMjUwLDI1NiAqKioqDQogIA0KICAgICAgd2hvID0gdXNlcm5hbWVf
c3RyaW5nKG5hbWUsIGxvY2FsX3BhcnQsIGRvbWFpbik7DQogIA0KISAgICAg
aWYgKCFwZ19jb25uIHx8ICFhcG9wX3F1ZXJ5X3RlbXBsYXRlKSByZXR1cm4g
TlVMTDsNCiAgDQogICAgICAvKiBPYnRhaW4gdGhlIGFjdHVhbCBxdWVyeSB0
byB1c2UuICovDQogICAgICBpZiAoIShxdWVyeSA9IHN1YnN0aXR1dGVfcXVl
cnlfcGFyYW1zKGFwb3BfcXVlcnlfdGVtcGxhdGUsIG5hbWUsIGxvY2FsX3Bh
cnQsIGRvbWFpbiwgTlVMTCwgc2VydmVyaG9zdCkpKQ0KLS0tIDI3MiwyNzgg
LS0tLQ0KICANCiAgICAgIHdobyA9IHVzZXJuYW1lX3N0cmluZyhuYW1lLCBs
b2NhbF9wYXJ0LCBkb21haW4pOw0KICANCiEgICAgIGlmICghYXBvcF9xdWVy
eV90ZW1wbGF0ZSkgcmV0dXJuIE5VTEw7DQogIA0KICAgICAgLyogT2J0YWlu
IHRoZSBhY3R1YWwgcXVlcnkgdG8gdXNlLiAqLw0KICAgICAgaWYgKCEocXVl
cnkgPSBzdWJzdGl0dXRlX3F1ZXJ5X3BhcmFtcyhhcG9wX3F1ZXJ5X3RlbXBs
YXRlLCBuYW1lLCBsb2NhbF9wYXJ0LCBkb21haW4sIE5VTEwsIHNlcnZlcmhv
c3QpKSkNCioqKioqKioqKioqKioqKg0KKioqIDI1OSwyNjUgKioqKg0KICAg
ICAgaWYgKHZlcmJvc2UpDQogICAgICAgICAgbG9nX3ByaW50KExPR19ERUJV
RywgImF1dGhfcGdzcWxfbmV3X2Fwb3A6IFNRTCBxdWVyeTogJXMiLCBxdWVy
eSk7DQogIA0KISAgICAgaWYgKChyZXMgPSBQUWV4ZWMocGdfY29ubiwgcXVl
cnkpKSkgew0KICAgICAgICAgIGludCBpOw0KICANCiAgICAgICAgICBpZiAo
UFFyZXN1bHRTdGF0dXMocmVzKSAhPSBQR1JFU19UVVBMRVNfT0spIHsNCi0t
LSAyODEsMjg3IC0tLS0NCiAgICAgIGlmICh2ZXJib3NlKQ0KICAgICAgICAg
IGxvZ19wcmludChMT0dfREVCVUcsICJhdXRoX3Bnc3FsX25ld19hcG9wOiBT
UUwgcXVlcnk6ICVzIiwgcXVlcnkpOw0KICANCiEgICAgIGlmICgocmVzID0g
ZG9fcXVlcnkocXVlcnkpKSkgew0KICAgICAgICAgIGludCBpOw0KICANCiAg
ICAgICAgICBpZiAoUFFyZXN1bHRTdGF0dXMocmVzKSAhPSBQR1JFU19UVVBM
RVNfT0spIHsNCioqKioqKioqKioqKioqKg0KKioqIDM0NCwzNTAgKioqKg0K
ICANCiAgICAgIHdobyA9IHVzZXJuYW1lX3N0cmluZyh1c2VyLCBsb2NhbF9w
YXJ0LCBkb21haW4pOw0KICAgICAgDQohICAgICBpZiAoIXBnX2Nvbm4gfHwg
IXVzZXJfcGFzc19xdWVyeV90ZW1wbGF0ZSkgcmV0dXJuIE5VTEw7DQogIA0K
ICAgICAgLyogT2J0YWluIHRoZSBhY3R1YWwgcXVlcnkgdG8gdXNlLiAqLw0K
ICAgICAgaWYgKCEocXVlcnkgPSBzdWJzdGl0dXRlX3F1ZXJ5X3BhcmFtcyh1
c2VyX3Bhc3NfcXVlcnlfdGVtcGxhdGUsIHVzZXIsIGxvY2FsX3BhcnQsIGRv
bWFpbiwgTlVMTCwgc2VydmVyaG9zdCkpKQ0KLS0tIDM2NiwzNzIgLS0tLQ0K
ICANCiAgICAgIHdobyA9IHVzZXJuYW1lX3N0cmluZyh1c2VyLCBsb2NhbF9w
YXJ0LCBkb21haW4pOw0KICAgICAgDQohICAgICBpZiAoIXVzZXJfcGFzc19x
dWVyeV90ZW1wbGF0ZSkgcmV0dXJuIE5VTEw7DQogIA0KICAgICAgLyogT2J0
YWluIHRoZSBhY3R1YWwgcXVlcnkgdG8gdXNlLiAqLw0KICAgICAgaWYgKCEo
cXVlcnkgPSBzdWJzdGl0dXRlX3F1ZXJ5X3BhcmFtcyh1c2VyX3Bhc3NfcXVl
cnlfdGVtcGxhdGUsIHVzZXIsIGxvY2FsX3BhcnQsIGRvbWFpbiwgTlVMTCwg
c2VydmVyaG9zdCkpKQ0KKioqKioqKioqKioqKioqDQoqKiogMzUzLDM1OSAq
KioqDQogICAgICBpZiAodmVyYm9zZSkNCiAgICAgICAgICBsb2dfcHJpbnQo
TE9HX0RFQlVHLCAiYXV0aF9wZ3NxbF9uZXdfdXNlcl9wYXNzOiBTUUwgcXVl
cnk6ICVzIiwgcXVlcnkpOw0KICANCiEgICAgIGlmICgocmVzID0gUFFleGVj
KHBnX2Nvbm4sIHF1ZXJ5KSkpIHsNCiAgICAgICAgICBpbnQgaTsNCiAgDQog
ICAgICAgICAgaWYgKFBRcmVzdWx0U3RhdHVzKHJlcykgIT0gUEdSRVNfVFVQ
TEVTX09LKSB7DQotLS0gMzc1LDM4MSAtLS0tDQogICAgICBpZiAodmVyYm9z
ZSkNCiAgICAgICAgICBsb2dfcHJpbnQoTE9HX0RFQlVHLCAiYXV0aF9wZ3Nx
bF9uZXdfdXNlcl9wYXNzOiBTUUwgcXVlcnk6ICVzIiwgcXVlcnkpOw0KICAN
CiEgICAgIGlmICgocmVzID0gZG9fcXVlcnkocXVlcnkpKSkgew0KICAgICAg
ICAgIGludCBpOw0KICANCiAgICAgICAgICBpZiAoUFFyZXN1bHRTdGF0dXMo
cmVzKSAhPSBQR1JFU19UVVBMRVNfT0spIHsNCioqKioqKioqKioqKioqKg0K
KioqIDQzNCw0NDAgKioqKg0KICAgICAgY2hhciAqcXVlcnk7DQogICAgICBQ
R3Jlc3VsdCAqcmVzID0gTlVMTDsNCiAgDQohICAgICBpZiAoIXBnX2Nvbm4g
fHwgIW9ubG9naW5fcXVlcnlfdGVtcGxhdGUpIHJldHVybjsNCiAgDQogICAg
ICBxdWVyeSA9IHN1YnN0aXR1dGVfcXVlcnlfcGFyYW1zKG9ubG9naW5fcXVl
cnlfdGVtcGxhdGUsIEEtPnVzZXIsIEEtPmxvY2FsX3BhcnQsIEEtPmRvbWFp
biwgY2xpZW50aG9zdCwgc2VydmVyaG9zdCk7DQogICAgICBpZiAoIXF1ZXJ5
KQ0KLS0tIDQ1Niw0NjIgLS0tLQ0KICAgICAgY2hhciAqcXVlcnk7DQogICAg
ICBQR3Jlc3VsdCAqcmVzID0gTlVMTDsNCiAgDQohICAgICBpZiAoIW9ubG9n
aW5fcXVlcnlfdGVtcGxhdGUpIHJldHVybjsNCiAgDQogICAgICBxdWVyeSA9
IHN1YnN0aXR1dGVfcXVlcnlfcGFyYW1zKG9ubG9naW5fcXVlcnlfdGVtcGxh
dGUsIEEtPnVzZXIsIEEtPmxvY2FsX3BhcnQsIEEtPmRvbWFpbiwgY2xpZW50
aG9zdCwgc2VydmVyaG9zdCk7DQogICAgICBpZiAoIXF1ZXJ5KQ0KKioqKioq
KioqKioqKioqDQoqKiogNDQzLDQ0OSAqKioqDQogICAgICBpZiAodmVyYm9z
ZSkNCiAgICAgICAgICBsb2dfcHJpbnQoTE9HX0RFQlVHLCBfKCJhdXRoX3Bn
c3FsX29ubG9naW46IFNRTCBxdWVyeTogJXMiKSwgcXVlcnkpOw0KICANCiEg
ICAgIGlmICgocmVzID0gUFFleGVjKHBnX2Nvbm4sIHF1ZXJ5KSkpIHsgLyog
WFhYIHRyYW5zYWN0aW9ucz8gKi8NCiAgICAgICAgICBpZiAoUFFyZXN1bHRT
dGF0dXMocmVzKSAhPSBQR1JFU19UVVBMRVNfT0spIHsNCiAgICAgICAgICAg
ICAgbG9nX3ByaW50KExPR19FUlIsICJhdXRoX3Bnc3FsX29ubG9naW46IGJh
ZCBzdGF0dXMgYWZ0ZXIgUFFleGVjOiAlcyIsIHBnX3N0cmVycm9yKHBnX2Nv
bm4pKTsNCiAgICAgICAgICB9IGVsc2UgaWYgKFBRbnR1cGxlcyhyZXMpKSB7
DQotLS0gNDY1LDQ3MSAtLS0tDQogICAgICBpZiAodmVyYm9zZSkNCiAgICAg
ICAgICBsb2dfcHJpbnQoTE9HX0RFQlVHLCBfKCJhdXRoX3Bnc3FsX29ubG9n
aW46IFNRTCBxdWVyeTogJXMiKSwgcXVlcnkpOw0KICANCiEgICAgIGlmICgo
cmVzID0gZG9fcXVlcnkocXVlcnkpKSkgeyAvKiBYWFggdHJhbnNhY3Rpb25z
PyAqLw0KICAgICAgICAgIGlmIChQUXJlc3VsdFN0YXR1cyhyZXMpICE9IFBH
UkVTX1RVUExFU19PSykgew0KICAgICAgICAgICAgICBsb2dfcHJpbnQoTE9H
X0VSUiwgImF1dGhfcGdzcWxfb25sb2dpbjogYmFkIHN0YXR1cyBhZnRlciBQ
UWV4ZWM6ICVzIiwgcGdfc3RyZXJyb3IocGdfY29ubikpOw0KICAgICAgICAg
IH0gZWxzZSBpZiAoUFFudHVwbGVzKHJlcykpIHsNCg==

---559023410-851401618-1133374745=:21638--