ó gbc@sddZddlZddlZddlmZdejfd„ƒYZdejfd„ƒYZdS(s  Module : KB.extern Author : Eric Coissac Date : 03/05/2004 Module wrapping psycopg interface module to allow connection to a postgresql databases with the same interface from backend and external script. This module define a class usable from external script iÿÿÿÿN(tkbt ConnectioncBs>eZd„Zd„Zd„Zd„Zd„Zd„ZRS(cOsG|r|ji|d6kn ||_|jGHtj|j|_dS(Ntdsn(t connectParamtpsycopg2tconnecttdb(tselfRt kconnectParam((s<lib/python2.7/site-packages/obitools/obischemas/kb/extern.pyt__init__s  cCsVd}xI|rQ|dkrQytj|j|_Wn|d7}q Xd}q WdS(Niièi(RRRR(Rtok((s<lib/python2.7/site-packages/obitools/obischemas/kb/extern.pytrestartscCs:t|jƒ}t|dƒr6|jr6|j|_n|S(Nt autocommit(tCursorRthasattrR (Rtcurs((s<lib/python2.7/site-packages/obitools/obischemas/kb/extern.pytcursor'scCs|jjƒdS(N(Rtcommit(R((s<lib/python2.7/site-packages/obitools/obischemas/kb/extern.pyR-scCs#t|dƒr|jjƒndS(NR(RRtrollback(R((s<lib/python2.7/site-packages/obitools/obischemas/kb/extern.pyR0scCs t|dƒr|jƒndS(NR(RR(R((s<lib/python2.7/site-packages/obitools/obischemas/kb/extern.pyt__del__4s(t__name__t __module__R R RRRR(((s<lib/python2.7/site-packages/obitools/obischemas/kb/extern.pyRs     R cBseZd„Zd„ZRS(cCs||_|jƒ|_dS(N(RRR(RR((s<lib/python2.7/site-packages/obitools/obischemas/kb/extern.pyR :s cCs y<|jj|ƒt|dƒr;|jr;|jjƒnWnYtjk rk}tj d|IJ|‚n-tj k r—}tj d|IJ|‚nXyYg|jj D]}|d^q¨}g|jj ƒD]}t td||ƒƒ^qÎSWntk rgSXdS(NR s===> %ss---> %si(RtexecuteRR RRRtProgrammingErrortsyststderrtIntegrityErrort descriptiontfetchalltdicttmaptNonet TypeError(Rtquerytetxtlabelty((s<lib/python2.7/site-packages/obitools/obischemas/kb/extern.pyR>s   #3 (RRR R(((s<lib/python2.7/site-packages/obitools/obischemas/kb/extern.pyR 8s (t__doc__RRt obischemasRRR (((s<lib/python2.7/site-packages/obitools/obischemas/kb/extern.pyt s   &