a#nSc@sdZddlmZddlZddlZddlZdefdYZddlm Z m Z ddl Z de fdYZ dS( sF defines class _DbConnect_, for abstracting connections to databases i(tRDConfigNtDbErrorcBseZRS((t__name__t __module__(((sZ/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbConnection.pyRs(tDbUtilstDbInfot DbConnectcBseZdZdddddZdZddZddddd Zddddd Zddd Zdddd ddd dZ ddddZ dZ dZ dZdZdZdZdZRS(s This class is intended to abstract away many of the details of interacting with databases. It includes some GUI functionality ttsysdbat masterkeycCs:||_||_||_||_d|_d|_dS(s Constructor **Arguments** (all optional) - dbName: the name of the DB file to be used - tableName: the name of the table to be used - user: the username for DB access - password: the password to be used for DB access N(tdbNamet tableNametusertpasswordtNonetcntcursor(tselfR R R R ((sZ/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbConnection.pyt__init__ s      cCs|jj|_|jj|_|jj|_x-t|jj D]}|jj dqLW|j }x|D]}|jj |qyW|j j||j j||jdS(s Modifies a connect dialog to reflect new table names **Arguments** - dlg: the dialog to be updated iN(t userEntrytGetValueR t passwdEntryR tdbBrowseButtonR txranget dbTableChoicetNumbertDeletet GetTableNamestAppendtsizertFitt SetSizeHintstRefresh(Rtdlgtitnamestname((sZ/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbConnection.pytUpdateTableNames7s   icCs+tj|j|j|jd|d|jS(s gets a list of tables available in a database **Arguments** - includeViews: if this is non-null, the views in the db will also be returned **Returns** a list of table names **Notes** - this uses _DbInfo.GetTableNames_ t includeViewsR(RRR R R R(RR&((sZ/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbConnection.pyRNst*c KsF|s|j}ntj|j||j|jd|d|d|jS(s gets a list of columns available in the current table **Returns** a list of column names **Notes** - this uses _DbInfo.GetColumnNames_ tjointwhatR(R RtGetColumnNamesR R R R(RttableR(R)twheretkwargs((sZ/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbConnection.pyR*cs  c KsF|s|j}ntj|j||j|jd|d|d|jS(s gets a list of columns available in the current table along with their types **Returns** a list of 2-tuples containing: 1) column name 2) column type **Notes** - this uses _DbInfo.GetColumnNamesAndTypes_ R(R)R(R RtGetColumnNamesAndTypesR R R R(RR+R(R)R,R-((sZ/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbConnection.pyR.ts  cKs:|s|j}ntj|j|||j|jd|S(s gets a set of data from a table **Arguments** - fields: a string with the names of the fields to be extracted, this should be a comma delimited list **Returns** a list of the data **Notes** - this uses _DbUtils.GetColumns_ R((R Rt GetColumnsR R R (RtfieldsR+R(R-((sZ/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbConnection.pyR/s  iic Ks|d kr|j}n|jdd|dR@RAR(RR tvalsRCtinsTxttcmdR@((sZ/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbConnection.pyt InsertDatas '  cCs<|j}d||tj|f}|j||fdS(s% inserts data into a particular column of the table **Arguments** - tableName: the name of the table to manipulate - columnName: name of the column to update - value: the value to insert - where: a query yielding the row where the data should be inserted supdate %s set %s=%s where %sN(R<R:RMR>(RR t columnNametvalueR,RCRQ((sZ/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbConnection.pytInsertColumnData/s  cCs=|j}y|jd|||fWn dGHnXdS(s adds a column to a table **Arguments** - tableName: the name of the table to manipulate - colName: name of the column to insert - colType: the type of the column to add salter table %s add %s %ssAddColumn failedN(R<R>(RR tcolNametcolTypeRC((sZ/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbConnection.pyt AddColumnBs cCs|jjdS(s+ commits the current transaction N(Rtcommit(R((sZ/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbConnection.pyR?TsN(RRt__doc__RR%RR*R.R/RR8R9R<R=RERRRURXR?(((sZ/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbConnection.pyRs"  !  $   (RZtrdkitRtsysRJt exceptionst RuntimeErrorRt rdkit.DbaseRRR:tobjectR(((sZ/public2/ftp/pub/ccp4/6.5/ccp4-6.5/lib/python2.7/site-packages/rdkit/Dbase/DbConnection.pyt s