rdkit.Dbase.DbInfo module¶
- rdkit.Dbase.DbInfo.GetColumnInfoFromCursor(cursor)¶
- rdkit.Dbase.DbInfo.GetColumnNames(dBase, table, user='sysdba', password='masterkey', join='', what='*', cn=None)¶
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
- rdkit.Dbase.DbInfo.GetColumnNamesAndTypes(dBase, table, user='sysdba', password='masterkey', join='', what='*', cn=None)¶
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:
column name
column type
- rdkit.Dbase.DbInfo.GetDbNames(user='sysdba', password='masterkey', dirName='.', dBase='::template1', cn=None)¶
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)
- rdkit.Dbase.DbInfo.GetTableNames(dBase, user='sysdba', password='masterkey', includeViews=0, cn=None)¶
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)