[Bioperl-l] bioperl-db: posqgresql adaptor

Yves Bastide ybastide@irisa.fr
Tue, 19 Nov 2002 14:26:08 +0100


This is a multi-part message in MIME format.
--------------060803000901080100080902
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

attached is a patch to use bioperl-db with postgresql.  It consists of 2 
things:

* the adapter, Bio/DB/BioSQL/Pg/* and Bio/DB/DBI/Pg.pm

* a change to Bio/DB/BioSQL/BasePersistenceAdaptor.pm to not raise an 
exception on bind_param without bindable param (in WHERE 1 = 1).

Yves

--------------060803000901080100080902
Content-Type: application/gzip;
 name="bp.diff.gz"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
 filename="bp.diff.gz"

H4sICII62j0AA2JwLmRpZmYA7D37c9vG0T9Lf8V9tBqTI5ISZSeO6VrRi7Y5kSWFlJpmmg4H
BI4kahCg8ZDMz/X/3t29O+AOD4qyUzdNqbElEbh93N6+bm8B9X2Hf+iysRsseOi1nPHe2+OL
/qve8Hr75Zd/bQ9Oh2zierzL9mbBnO+FfBFEbhyEyz1Jcq+EdPN2O+Rx6PJb15+yEH5EbuCz
TrvT2XbcyYS1EtZasFaIV1jKcKvVKpvI1sH+/sFepwP/WOdZ9+nT7tP9LcK1u7u7GuA56zzp
7j/pfvt8++iItZ48a37HduH7cwYfT9xg7+xkD34Mfzrfmy+j9x5+iPj7hPs2P3asBUz0LNzO
jbwMLdvje8e+H8RWDBM7DTyP2/hbCuPe8rC9mFeAnlgRv+Jh5EaxQekeqBLeFMSuCXE1XY+9
Ith9rJVArGArN5Gr0J1b4XLI38uRJWMGfMJDDVnJEBMeF/bbDi7st0+bz7SFPTs504HPTvp7
Y5hd/hotfP6iELk+Ybx6Nc2N0z++tRYkvRK+8dbZiXajX7Bac4blq4CQX9+o1+Ss2ua/L9j8
96x6gjknsCZ13eT3n3c7+91vv9si2jkf8Rn4DBfS2f/uCWjZLv3s7KO6RckYxOk7o/FyBHYQ
Lj9us61JENbnS7bjspes8wJ//vklO9p5f2t5CY/wwu5ug+FIBl87EfcmrUOHj5NpvfYTImE7
731rzlFJfAdFagdeMvcRUxywX2u1NsBubTGFsnX4tx231fl7u/Zr7Ve/1nix3SLU7qT+f4A/
nrUOEdNoYYXWvL7jNguQDeRnl4AesZ85m3Kfh5bnLZkT+I9jdmf5MdIOLTfizPIZ/2DzBfqV
tgTDCYe3L+QnDujZR7wCMliPgxfsk4IWfIe3Qkhbj9j1zI0Y/ONuPOMhcxKOzAAbrh/z0Ada
IDwWhHQVpOVHMXDqxwJaSg98IqzXYhGEMXfYeMkAF0vAGkNviUKO7BmfW6zutnm7yebWYsEd
gQCw4rhJo81+noHxEOTEDaOY2aBFIJ0wBAFFhmCaOEqq/0USaorYDkJ3uldwput47Wp1Xtft
mzb2BaxsdZ4/22/td+Af2+909/fhX3tffbHd/c7+/moLXJcQ2mOr02mhPR50D/a7ne8KhNA+
95vwqdPsPMUQv737iO30nR34ib8CSTB2j80DJ4EFBBPFS93u2Um3K9jpdq+m3e69DEl8p0n8
zcKKpCb9cssj9Gux63D25+VY/mbFzA3dyGpPwkM2CYM5E5mGiDAs8Hmk0AWLJazELGb9i0H/
WF79JUhAD8EGwUeF7jiJUfPADOQkSHdJFyPwFgwsYQ4qGDGUNnNj9CvbuxLVJWB3wVC6+KFu
N9gb14N4zM5BzZts5sEPZHc6/9D2edxkKPO2Gvv64lWTveZ+MHftiPXButwYmQkmRP0iuLXC
GPga8IhboT1jrwLgzRJWoDD9NhMinihPQKvEobSsx0g/dm127trcB5OsR1yYqScvWLYdzBeW
T6aORBFRFExiMF7OFpb9zpryJvoQhJzF8aK7t3d3d9dG4m2A3fMsf5rAoL25G9l7imJ7Fs+9
BiJDnUKKgm0xl7uZC+JYymknEVCAubqTZRN8hQOhslwSNEv8f/2mP2RXx6c/Hr/uMfx1cPmX
/lnvjNWOh/C5xo4vztjP/es3lzfX8PsvrPfXq0FvOGSXA9Z/e3Xe750hmp+PB4Pji+t+b9gE
BTs9vznrX7xupoDn/bf96+Pr/uVFEyj2FKQGxi5fIZ63vcHpG7xy0j/vX/9C1F/1ry+Q4isg
eQy8Dq77pzfnxwN2dTO4uhz2xNoj9NXlGYQTO5lzX5gYa4FYXB8vRmzMQYBizezA4QjycsYt
p8Mujt/28OPnGSwQOesNTwf9K5wg6uzl+B8wTiMw/OXi8mrYH+Kl1wDDohhWxwodWDFYcAYx
R+dHQ4dXz3hkwxIK1gPCnYd41etBDnj6Y3rpgL21XA9V8RwUIMLrNxHwOuHcGYMuYrCT4W0K
cRj0M4yVufFbiGckPrpAIx0WYGQkGS0yPxe12ZDDTVDAEKQ6R8mL4VEynfIIsYB5hWhP1hii
fRxs7yKNFI3k0gMu2wztNyReXNtdiCVEnU1Ax8GBhNx2LfCIbZwOS/2+dyR/g2AzZcZXC70K
JhroEewkwrQRQaX5aXB7KC+UVTtCg0PQ43GQxCQRnctIk/GAY7DHOyfJlG6IK5gtRMp/qKli
BgFZg/2OcoEluPY5DplxbwFqwN5xvhD3t3flQhAWFCZ8cEMw5kguTBvpsZBoRZAi+KDcmCrO
3RgDxq1rbe9yZJpJl3HHx11TaIhbl1uFVPThe5rCHd+AZQ9ASHpkwvs9IlsWoQxVhhQqtkCP
HR7D+Civz6eXF9eD/snN9eWAjObYcVycOCwkQpJDC8KIYRYrRETTLeA5vrrqXZz1/4qXrkEO
IMJUzU1PoRjhFuiaHCFtbc7jWeBEoHV9lQ3KSwxdexIllMiienIHxH8HSSRkiSPiw07IEaB7
Oudx6n1gwSBcttttcVOGh89MGSCtBc/PIEhG7P1d/ag/PG7Ia+j87fiFYED4JWTUmo8hHLbA
/kFgEPhE8kDUB0EQi+8IhDhKmVq1lydyyAXk5sDPg+Ebkl+f39Ub6AAkm5AuZ7bnQtAN41GQ
+lp27cYwKca6+Xvshrws3IHfXyU+SbALngvjcggqwGzPisCXwcYkAPohai45PlQnWCrbAjmg
haRfZWsCZEXCMEUrgzxMZfxOwCP/8ePYwACLgFpjByEo5SJAKw8wB2HBHST5PmRAyzbr01bh
DpWV1S1vHkRxw8ACXMzQnyCjwi32PljzBcgB5zrgcRKCA+4yVP6FqJCAp1kqDQcJAw9CXBzT
BWAH3SvkO+B6SJbHxfUvXzswIVw9h6Viz77q4A9cGyfchDkCWe6Qf3SRVTRC5oxn9UYT9HVW
3wEGm7SpazTlhs0Zo9nzDzGOQXOf8ni0UCzEo8gL4qjeaMjN4nVmvEAE3I2aYdtcRBaqgpDc
7uE+i4SDqYI79YWsCBPsq90JjJGyC3IKoQOIjScq7sXN+TmkisGc6wMiStaALT/xPAiLHOep
4YKV8dkU8wRyF6ib5Omks1A+BWsDhqZ/FFhgp1ynTX9zx3IWzR242dyZvIMfUQMs8mj0QoQC
3IqHpCHgrW7dMAY/xq5+FLfkjVYHBn/SzC5ZQN7Ny80ud+8LzQ5WBHfUDi7MUmi56xtyEolC
4llhE7P4cpsEg/JBx7MZStu6x1j8ZD6GfAnWWswKjCO4i/54liFn94czDEMXH2wYUvtT5d/e
hV8fUGq5p9K9smRxX5V8rQLLPUh+k9rKfTTMskrn++7Tb1eVVZ50vqCssoqXTUVlU1HZVFR+
PxWVVba6KaZsiimbYsqmmPJvK6bcU7f4qnUU5GW9ikk2UtZGkA3aJU0DWDM0dNzWhErMrZB7
llxjPGgEKyEgyID/JEaMxDZoBHeBZh12B1s1IgvfeqAUyxor/3p5yGqgyJzGNDO4rP+iXwpa
BWcsUL6Ho1YNV0noAfQMQvfA9R2U2MTFbUkZ4Sq4Uy8BVQsreV2HT4nD4HUduGL7TE3Bqes5
kb7iFux8SicoSALcRIxZIVSJxVzEcsjhAuIQjypXEiFj60PgV5ITCAqyKQCdBzaZRNVKmDyO
PDm8iq5CpxN+IAr4eYE+FxxWKiu5PJCKW9hQlAdNXVdsgtcyjSgDzUojiObc9d/VCnN3xh8g
tajiVUCZ1lIOpdM6FVlMLU9LZjeV+i5uF9a0BEynlrZ31UxqaTGjil6+L6y2ClCnOKQyzV+w
rFHTKUJYDbxguhzhzqJSczNgwzorgXXKl3LQNY5Zh7IC6HYRpGgEa7ON4HmvWQEMdzBeYdSx
oijAhBOYL4YezZMhKtUplGqXwaQaOnLGHipyMx0d5tbfGG2upQAwWc4BvIdMBPw9D0dUttLA
MmZTOh9punmEOQZESI5m7iJD9gl/+UQfdQ9piqGMT83PVHNaIj9qNFops9wInat7Z6txdf98
M+6M2ZaId8Wil7CXTUASMia5Pq0ylVmHXFEuaxKsXsgSsvdqAHGztSUJKUPEgvDIimUJI2+E
afAwufb1OCPJ4zWNQyuBLB5y4KU2JLumi0dEZpMA1XJhBjJgEvQk8bwRrDaHZF4jhEEAnAiR
V4T0a9lI3x67I6DmOpnQ1DUYDZd1m8ZameWZ6yKvZcNgb+BaWkDDYeqaPscqf+ZGC89ajnSO
tGsZHXlWZwx0ZQbKQ13sts1pJz4SJxZCdOlV3RfAdlH3+kSbtpCLuDhSXV098hbTETlKjRSq
rO4YXtNfka7k5k8HRKbjF9dGqbUYAPbM9Zxc3KdrxfG5JTIdlbleX4eNNBc3icPlkS5gafMl
ovW4P41nJps4Ul433EghF9MYGME2V9ctbzGzxjzWbSK9pqmLK/qx9WHptaJKKx4Mz5cTiooM
pvGkvkmjM87ZfJnhlFlDmeYags1riQw8JkuhZWbS9wQfA1Y4x8jgIB07UnczjmM8Z63KbEfi
rqYSau9ROtrYmQiAOXfQ11awo+5qqhRbYZxj5+VhMXa2xcAMkPtOQQdLAXFghcGWS7SMpWwK
6/CRjU6JV62zNpbu6pza5duejFM8sM3jk0AjureatBqaEaah62zFCxqaIi5kmQWutQCUsoJj
R2Zk0mct04Qc/wSUM9zYmhpDC+NMtDAF13czDU+HazcKQKD0fBqYyZe6ZvrxW2NLp5T0Y1Wm
1qzOxT61cylZxk5l3meKvYyX6kyxTF+y0QVVzSeWhUVX6YlanJItRAlFfR9gKqly0LDeaRgw
NM9ciChIQnRvcnQeubxtgIhKaBpnVgaasmrN/U4FY+s67gTHmY4EnxvRB2bY6PpqoSoOV63i
f06XjO2+E2DvCccuHNpsRPomQ6Ub7XzqgQQ6Apeoc6eHQz6/yzUb0ZWsxYieDwrG/wA6cOfh
tf86EtS6lE4SSNoiZn0eNnXaYbQV0REhHlbadA7/GX0MWfNRseEF+Uz7XOo7tKFqHlkAkOtt
QUHhuTw+OEWjWofDm6veoNvFfksBoXWI2cECOwTjgE4ZwHpvwWGymRXNxAj5eBlMGPJo3E7W
fy0eMZBws8HFPSgAFS/moPzAVCmAKahZDqS86gSA5TeyecsGIEKT64BTDuwdF04xp5fF2xV9
cJfj2JIdozhOnZPpXZqpNNJOBWx+Ahg8hMh3w8V0JJce+4je07aakPwSD7qp3jJxWqd67yJx
kscnVuLFRNHmoeAR6eFty2xec0SL3swSHVluSM2r2gzaq3vsKqZdt+i8zZ82jH67PIiQgj44
bxP5tSj2gRGOnIGIi/RcISkRfST4eu6IrIGdb3I4f2/u5V4UFSk1tDxfdclHTtNS31iiZrl7
FTqm5L1KycSjmNimWAc3lCI2+4xL9G9VB2WenkL6oKUt6eozZv0fXE0xqM1qo8U7SjTUyj2w
TbD68fbVnXcrHotfrz2wGsFv0xq4An/uacuDbqeIX2sLPPjuyRe0BVbwsWkJ3LQEbloCf0ct
gRV2umkH3LQDbtoBN+2A/752wArHs3mk8rMeqSx/kguCQxA6IthD9iFWSiDElDumQVZoPjfk
B/JxoXb6dhb5IKbALHbtLH18Ck0WVFA4SXOXKp++EiUR0ug7TqE8wp0wPXDkcIu8EOkX+Qd8
74p4Pm3zWOXmsUpm1M2imTuJX2jbz8rHyXCEqqQFWcFHIH4cMZSwmpiQKRB2QRf/Hy0zJQuj
YBAWUZFU67BknUTxNqoTG0zx8UIRRwnTCCat5IcMvRs5nMqBik7r8G/7f5egJS+bYkfpyOxl
U7tbEs8//2li2nER1RaIm6xdjJLIP60okhhrUD8aNQrQX/kZVTQvcmGVj4hLV4bbEtOTaWFG
WVDE8V1VWNrDOJF1PlOVjd0FieewWQDfTGemF9fYG0SI1g1GUG9QtoL1OPQ3Ux9UCHYu3FeJ
kmKgUNex8C6djjDLg0DmLBn/gNkYuYTUqWQPi9IGi1C7pj/Sx9qACV0DeY07a5mFZxCanYQo
XHCSd26ICPFVVuY0UUnt8vIgpndz9NYkOvLWcgINwOd5MA0gaC4CBG1ImkP0RmIW+croMGjC
nFD02Uo7gQxgwPGMQ2YPk6YXhFEqr0vMQKVJD1SWHmLmHp/iYqNzNvS6cU+JdPMY8n91IPnc
x5BxXOagbUicOVaL4fbjYe+8d3rNbn5kj9vqfEINhCVJYwStVAqpIkH6yj7hsx9JO6U1A6ND
p8ei9x7cQnzVtVOkgThpWPKOirfpOCnLrL5dfEQkhcX3ZLxkNTkrherV4PKtIv/zm96gpxH5
AautW2KS8q2GgnN0CRJPBFsP0tsuURAvLQQgXUCk0a1DOes6jqNBj0gYJDlycFtl8pT6b8ax
R/RCRUYvIeSwnYnUYVTu/YSdJp1VIu30IACMIw3W/AO3E7koEx7bMx2PvFlvaOsOTiF9DyIB
gCWPyFjAgura2h/hULX0yk8JF9YU8UwUL4TewqjS0GxodUn2o6TCuAdBURATL0GJBVG2xPKk
ogdJ0QQ3rOKAFJxjga7pM6sJmnkA+qCxHviMTKBwd40zFOASXyGRxnIRPlX0obhoYbFAnHGg
J3Ljagd/LM9CWN04I8HqJaDQzmHMgxJ00wi1yDw8s+TbRXOHfaW7E8UucS9qm5jVZNlpej5v
YLtciCoBhghqfhC1AdR3fMMr1ZMm6mUb2gRwhcnJG9jE+kIwqiMXXoB1GwkAezTBjCjycgOZ
CvnmDk92Biq/TUWtCRb2MVSDWmX4ILilWQPWkj0em7hcvzXn8wDEIxanqSd3zLNiRDqzVJoj
30sLE6H3dTZKYkBO0SqigFoV12nukHibOyBbIyAIkHjWZIYfwpedolXrcYC/B+7TMzAwfGqL
4k5d4G4oF5D6SeHvnB/Q3enhRjnmk/7lsPcTG96cDK8HtTby3M6QEqc/1NjB1eWw1q2VONti
NNrKhSLh+rTsS0YmUeZP3wG7RkjSpGAHXja2pO1AHhm2Dj9Sb2zuDbECgWBvSxGcgazrNUjq
5YOV4qRcvAIWAJg6L5es1lKWPmmsfW7ETKdmRE2xKv2L13U1Z4qfsCCYb23l14nVsMwPd7sM
lkqMgZ/3x1wKQp8Td1X0ujf2CiXIxd+MbFUM3vpE2lyIvluloVeYAKko7moPpDIaUsp0soDi
AFDAkJbAs9vJZojYnih2yt9KnJl5aZR8qD0KS9xY29e0NsPG/hfspURnPytTXTNNlamfyFXB
W+EPqkjRN6zh0LuyH9Jykb5gv6RrIXv5/orWiXTQF7RHZDjSFojvWed59+BZd7+zsgXi4NnD
WiCAEh4JqLYEUYlZs8Xha/UyYEsCod40F2yaC37z5gJpAZv+gU3/wKZ/YNM/8Jv2D0jfsk6L
gHHWD3All7pdrFxUne+nA8QB/pc+DSFZX+9hB+VDpaiTSNVjFlYUgSxxgR1mHtukuWR7rUcf
0kRFK3EJtBkmeSZvwf1WesyAjcQallNxtW9WctTZBZXiaBIN0seW0UYsqm9l3cqFk7KrH1W3
NIitpN98jWcw8N6DnsPQMuKypxF8mPbIdcTpb0EpjHuaeuws3iFZqkEbo/KaUVm7tORpcpS4
YgeE8kHdtlCPtKpjoXyZFutgKX35lt4ZLItHhzyIAlFpf+8pX+1Dho26JnGSP8/Ty5VrtL/T
G7I08LQGyvoTalqJ5TGlnHdav4Ss2lCnutk4T+eReMAVydiY1xhN+IXKINuBfV+TNpy5rnax
Y4a78ug9v1tOhSwli3+XyHPFTj+34KzVqlEJiPit4Tk93JVnvzSSYZwRj8iTV80WrhXh25cm
rl0r7Az10gL9vaTEFi6WXoyutr1quwg7+axwYIoT8mRIZiIaVDzyABEgBD4BBFeyzaTarOMU
YKL1xwj+uFHTq6TO2HX0Y7E6If3mG3akfqnTGKSj9qCNRoXERZNP1vSDtfUQy9r5pYBNpi7v
RRiMKf1K/9QUD8MgzAtUuQDJs+4C5IqVuoDcvTWOOKhPI/Hd9wkvGpmh2mBb+EAinvGf8QUX
f0ksEEcI4L0ogKsUiTnUhlY86BfWJOv2SpvEn9kiv0L7LRd2SkgAEQoTNs9js8dRsq+yJ53w
DIrO45VmvvNhnfUHTn4X3k4hNOaDa5CeXIhmGlK1/xa/p3s9Qyu/ktczaP7RvR721/zBvZ47
we6MEch1An4s362au1nh917LrF+3EXwGbvKvyq5gJ0IYiP4K8bKrwX7AmjVRFhOTZU0k8WoW
aYS4C4diiPHnnddpS0vRxGPJlNAy89rXeQPGgrVYw/ED6ryxd6gWSov4mGZCUP5xX4vcLxiy
xht6mtRhoaJJ6+rgHprBj62KYKzo6V7Pu/uiVBxTuthSadbtnjMlOgrQJigZPjtyslOIHWaM
Ov+pEpyWSq1tq+QwSlaInUWSi3eR4kC9+MIkRNsuTBJ1f3yAagY6nxGM7qjz96YYikd8eNmv
L/9THujmW8Opzbti3w+Wz0K8RioZCp+6vpPhjuoqfO9QahLafCer7Olun5dZvuKfQDonqkB8
XmvVzfzHu/6L62Q2uvmd78qDTeY7kJ5oiWEfIilbrWVqZgpBs/zxGunQJZ3Ww3AdY32SwZnQ
jQJpIjPhv1Y1X39AQwi1BosMa4lVxdtaN39xspso3EJBOpkiw0JxvrlIBAL+7fq2NpX5KLTc
2BJMbSq29tM/W8+8YuicG940FEOeHZprVpN67agXDnC8Xmj6vbg9I2jU2UtL/AAp2y3WQHsA
AA==
--------------060803000901080100080902--