ó a#nSc@s¶ddlmZddlZddlZejZejZejZejZdddddd„Z ddddd „Z d „Z ddd d dd „Z ddd d dd„Z dS(iÿÿÿÿ(tRDConfigNtsysdbat masterkeyt.s ::template1c Cs tjrÑ|s?ytj|||ƒ}Wq?d|GHgSXn|jƒ}|jtjƒtjr”g|jƒD]}dt|dƒ^qq}n-g|jƒD]}dt|dƒ^q¡}|j |ƒnKtj rddl }ddl } | j |j j|tj ƒƒ}ng}|S(sà returns a list of databases that are available **Arguments** - user: the username for DB access - password: the password to be used for DB access **Returns** - a list of db names (strings) sProblems opening database: %ss::iiÿÿÿÿN(tDbModuletgetDbSqltconnecttcursortexecuteRtusePgSQLtfetchalltstrtremovet fileWildcardtos.pathtglobtpathtjoin( tusertpasswordtdirNametdBasetcntctxtnamestosR((sT/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbInfo.pyt GetDbNamess$    0- $ic CsÂ|s6ytj|||ƒ}Wq6d|GHgSXn|jƒ}|sTtj}n tj}|j|ƒg|jƒD]}t|dƒjƒ^qw}t j r¾d|kr¾|j dƒn|S(sv returns a list of tables available in a database **Arguments** - dBase: the name of the DB file to be used - user: the username for DB access - password: the password to be used for DB access - includeViews: if this is non-null, the views in the db will also be returned **Returns** - a list of table names (strings) sProblems opening database: %sit PG_LOGDIR_LS( RRRt getTablesSqltgetTablesAndViewsSqlRR R tupperRR R ( RRRt includeViewsRRtcommRR((sT/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbInfo.pyt GetTableNames8s     /c CsÍ|dks|jdkrgSg}tjsàx˜|jD]¡}|d}|d}|tkrgd}n_|tkr|d}nJ|tkr‘d}n5|tkr¦d}n tj j d|t |ƒfƒ|j ||fƒq8Wnéddl }|jƒ}|s|SxÄt|ƒD]¶\}} |j|d}t| ƒ} | |jkrPd}nb| |jkrhd}nJ| |jkr€d}n2| |jkr˜d}ntj j d|| fƒ|j ||fƒqW|S( Niitstringtintegertfloattbinarysodd type in col %s: %s iÿÿÿÿ(tNonet descriptionRt useSqlLitet sqlTextTypest sqlIntTypest sqlFloatTypest sqlBinTypestsyststderrtwriteR tappendttypestfetchonet enumeratettypet StringTypestIntTypet FloatTypet BufferType( RtresultstitemtcNametcTypettypeStrR2trtitvttyp((sT/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbInfo.pytGetColumnInfoFromCursor_sF                   tt*c Csh|stj|||ƒ}n|jƒ}d||f}|rQ|d|7}n|j|ƒt|ƒS(s  gets a list of columns available in a DB table along with their types **Arguments** - dBase: the name of the DB file to be used - table: the name of the table to query - user: the username for DB access - password: the password to be used for DB access - join: an optional join clause (omit the verb 'join') - what: an optional clause indicating what to select **Returns** - a list of 2-tuples containing: 1) column name 2) column type sselect %s from %ss join %s(RRRRRC( RttableRRRtwhatRRtcmd((sT/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbInfo.pytGetColumnNamesAndTypes…s  c Cs¯|stj|||ƒ}n|jƒ}d||f}|ry|jƒjdƒdkrhd|}n|d|7}n|j|ƒ|jƒ|j} td„| ƒ} | S(s¸ gets a list of columns available in a DB table **Arguments** - dBase: the name of the DB file to be used - table: the name of the table to query - user: the username for DB access - password: the password to be used for DB access - join: an optional join clause (omit the verb 'join') - what: an optional clause indicating what to select **Returns** - a list of column names sselect %s from %sRisjoin %st cSst|dƒS(Ni(R (R((sT/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbInfo.pytÌs( RRRtstriptfindRR3R(tmap( RRFRRRRGRRRHtdesctres((sT/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbInfo.pytGetColumnNamesªs     (trdkitRRR.R*R+R,R-R'RR"RCRIRQ(((sT/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbInfo.pyt s      $& '#