Package install :: Package MoSTBioDat :: Package DataBase :: Package SubStructSearch :: Module DB2SmiDict :: Class DB2SmiDict
[hide private]
[frames] | no frames]

Class DB2SmiDict

source code

                                              object --+            
                                                       |            
   MoSTBioDat.DataBase.Connect.MoSTBioDatDB.MoSTBioDatDB --+        
                                                           |        
MoSTBioDat.DataBase.Scheme.MoSTBioDatScheme.MoSTBioDatScheme --+    
                                                               |    
      MoSTBioDat.DataBase.ImportData.Data2DB.TaBuilder.TaBuilder --+
                                                                   |
                                                      object --+   |
                                                               |   |
  MoSTBioDat.DataBase.ImportData.Data2DB.InserTables.InserTables --+
                                                                   |
                                                                  DB2SmiDict


get Ligand.ChemComp table data to id:smile dictionary
INPUT:
    host - string, host to connect
    user - string, user to connect as
    passwd - string, password to use
    db - string, database to use
    port - integer, TCP/IP port to connect 
    log - boolen, logging flag
    unix_socket - string, location of unix_socket to use
    conv - conversion dictionary, see MySQLdb.converters
    connect_timeout - number of seconds to wait before the connection attempt fails.
    compress - if set, compression is enabled
    named_pipe - if set, a named pipe is used to connect (Windows only)
    init_command - command which is run once the connection is created
    read_default_file - file from which default client values are read
    read_default_group -  configuration group to use from the default file
    cursorclass - class object, used to create cursors (keyword only)
    use_unicode - if True, text-like columns are returned as unicode objects
                  using the connection's character set.  Otherwise, text-like
                  columns are returned as strings.  columns are returned as
                  normal strings. Unicode objects will always be encoded to
                  the connection's character set regardless of this setting.
    charset - if supplied, the connection character set will be changed
                  to this character set (MySQL-4.1 and newer). This implies
                  use_unicode=True.
    sql_mode - if supplied, the session SQL mode will be changed to this
               setting (MySQL-4.1 and newer). For more details and legal
               values, see the MySQL documentation.  
    client_flag -  integer, flags to use or 0
                   (see MySQL docs or constants/CLIENTS.py)
    ssl - dictionary or mapping, contains SSL connection parameters;
          see the MySQL documentation for more details
          (mysql_ssl_set()).  If this is set, and the client does not
          support SSL, NotSupportedError will be raised.
    local_infile - integer, non-zero enables LOAD LOCAL INFILE; zero disables
    format - string format for log handler
    filter - filter object from logger object
    datefmt - data/time format
    path - directory path to log file
    filename - log filename, default log
    filemode - mode to open log file, default='a'
    level - set root logger level to specified level
    logfilelevel- set level to log file
    cache - create cache for query, default=True
    scheme2file - Boolen - save database scheme to shelve file
    log - log flag, boolean default=False
OUTPUT:
    class object 

Instance Methods [hide private]
 
__init__(self, host='localhost', db='Ligand', user=None, passwd=None, port=3306, log=0, **kwargs)
INPUT: host - string, host to connect user - string, user to connect as passwd - string, password to use db - string, database to use port - integer, TCP/IP port to connect to unix_socket - string, location of unix_socket to use conv - conversion dictionary, see MySQLdb.converters connect_timeout - number of seconds to wait before the connection attempt fails.
source code
 
readb(self, logdebug=0, lowercasetablenames=1, **kwarg)
create id:smile dictionary from ChemComp table INPUT: logdebug - log debug in log file lowercasetablenames - boolean, lower case table names MySQL engine settings, default True OUTPUT: dictionary
source code
 
isTabDesCorr(self, tablename, tabcol)
check table description with table name INPUT: tablename- name of table tabcol - list of column names OUTPUT: boolean
source code

Inherited from MoSTBioDat.DataBase.ImportData.Data2DB.TaBuilder.TaBuilder: genColumn, genTable, genTables, getFKDesc, isFK, isKey, isNull, parseType

Inherited from MoSTBioDat.DataBase.Scheme.MoSTBioDatScheme.MoSTBioDatScheme: createdict, executeQuery, geTableDesc, geTables, geTablesDesc, lastInsID

Inherited from MoSTBioDat.DataBase.Connect.MoSTBioDatDB.MoSTBioDatDB: __repr__, autocommit, closeDB, commit, connectDB, displayStatus, executeFileQuery, getClientInfo, getConnectPort, isDB, lockTable, rollback, starTransaction, unlockTables

Inherited from MoSTBioDat.DataBase.ImportData.Data2DB.InserTables.InserTables: AtomStat, Atoms, ChemComp, ConfStat, ConnTab, ElemTab, Prop2Tab, PropDef, ProtStat, UserAtoms, UserChemComp, UserConnTab, UserProp2Tab, UserPropDef, UserProtStat, getAtomStatonIdFk, getAtomsonIdFk, getChemCompIdIsoSmi, getChemComponIdIsoSmiZINCode, getConfStatonIdFk, getConnTabonIdFk, getElemTab, getPropDef, getProponIdFk, getProtStat, getProtStatonIdFk, insertrecord, ligvalidrecord, uservalidrecord, validrecord

Inherited from object: __delattr__, __getattribute__, __hash__, __new__, __reduce__, __reduce_ex__, __setattr__, __str__

Static Methods [hide private]

Inherited from MoSTBioDat.DataBase.Connect.MoSTBioDatDB.MoSTBioDatDB: getNumberConnect

Class Variables [hide private]

Inherited from MoSTBioDat.DataBase.Connect.MoSTBioDatDB.MoSTBioDatDB: db, host, numberConn, port

Properties [hide private]

Inherited from object: __class__

Method Details [hide private]

__init__(self, host='localhost', db='Ligand', user=None, passwd=None, port=3306, log=0, **kwargs)
(Constructor)

source code 

INPUT:
host - string, host to connect
user - string, user to connect as
passwd - string, password to use
db - string, database to use
port - integer, TCP/IP port to connect to
unix_socket - string, location of unix_socket to use
conv - conversion dictionary, see MySQLdb.converters
connect_timeout - number of seconds to wait before the connection attempt fails.
compress - if set, compression is enabled
named_pipe - if set, a named pipe is used to connect (Windows only)
init_command - command which is run once the connection is created
read_default_file - file from which default client values are read
read_default_group -  configuration group to use from the default file
cursorclass - class object, used to create cursors (keyword only)
use_unicode - if True, text-like columns are returned as unicode objects
              using the connection's character set.  Otherwise, text-like
              columns are returned as strings.  columns are returned as
              normal strings. Unicode objects will always be encoded to
              the connection's character set regardless of this setting.
charset - if supplied, the connection character set will be changed
              to this character set (MySQL-4.1 and newer). This implies
              use_unicode=True.
sql_mode - if supplied, the session SQL mode will be changed to this
           setting (MySQL-4.1 and newer). For more details and legal
           values, see the MySQL documentation.  
client_flag -  integer, flags to use or 0
               (see MySQL docs or constants/CLIENTS.py)
ssl - dictionary or mapping, contains SSL connection parameters;
      see the MySQL documentation for more details
      (mysql_ssl_set()).  If this is set, and the client does not
      support SSL, NotSupportedError will be raised.
local_infile - integer, non-zero enables LOAD LOCAL INFILE; zero disables
format - string format for log handler
filter - filter object from logger object
datefmt - data/time format
path - directory path to log file
filename - log filename, default log
filemode - mode to open log file, default='a'
level - set root logger level to specified level
logfilelevel- set level to log file
OUTPUT:
class object 

Overrides: object.__init__
(inherited documentation)