Exemplo n.º 1
0
def DatabaseToDatabase(fromDb,
                       fromTbl,
                       toDb,
                       toTbl,
                       fields='*',
                       join='',
                       where='',
                       user='******',
                       password='******',
                       keyCol=None,
                       nullMarker='None'):
    """

   FIX: at the moment this is a hack

  """
    sio = StringIO()
    sio.write(
        DatabaseToText(fromDb,
                       fromTbl,
                       fields=fields,
                       join=join,
                       where=where,
                       user=user,
                       password=password))
    sio.seek(0)
    TextFileToDatabase(toDb,
                       toTbl,
                       sio,
                       user=user,
                       password=password,
                       keyCol=keyCol,
                       nullMarker=nullMarker)
Exemplo n.º 2
0
def DatabaseToDatabase(fromDb, fromTbl, toDb, toTbl, fields='*', join='', where='', user='******',
                       password='******', keyCol=None, nullMarker='None'):
  """

   FIX: at the moment this is a hack

  """
  sio = StringIO()
  sio.write(
    DatabaseToText(fromDb, fromTbl, fields=fields, join=join, where=where, user=user,
                   password=password))
  sio.seek(0)
  TextFileToDatabase(toDb, toTbl, sio, user=user, password=password, keyCol=keyCol,
                     nullMarker=nullMarker)
Exemplo n.º 3
0
    sio.write(
        DatabaseToText(fromDb,
                       fromTbl,
                       fields=fields,
                       join=join,
                       where=where,
                       user=user,
                       password=password))
    sio.seek(0)
    TextFileToDatabase(toDb,
                       toTbl,
                       sio,
                       user=user,
                       password=password,
                       keyCol=keyCol,
                       nullMarker=nullMarker)


if __name__ == '__main__':  # pragma: nocover
    sio = StringIO()
    sio.write('foo,bar,baz\n')
    sio.write('1,2,3\n')
    sio.write('1.1,4,5\n')
    sio.write('4,foo,6\n')
    sio.seek(0)
    from rdkit import RDConfig
    import os
    dirLoc = os.path.join(RDConfig.RDCodeDir, 'Dbase', 'TEST.GDB')

    TextFileToDatabase(dirLoc, 'fromtext', sio)
Exemplo n.º 4
0

def DatabaseToDatabase(fromDb, fromTbl, toDb, toTbl, fields='*', join='', where='', user='******',
                       password='******', keyCol=None, nullMarker='None'):
  """

   FIX: at the moment this is a hack

  """
  sio = StringIO()
  sio.write(
    DatabaseToText(fromDb, fromTbl, fields=fields, join=join, where=where, user=user,
                   password=password))
  sio.seek(0)
  TextFileToDatabase(toDb, toTbl, sio, user=user, password=password, keyCol=keyCol,
                     nullMarker=nullMarker)


if __name__ == '__main__':  # pragma: nocover
  sio = StringIO()
  sio.write('foo,bar,baz\n')
  sio.write('1,2,3\n')
  sio.write('1.1,4,5\n')
  sio.write('4,foo,6\n')
  sio.seek(0)
  from rdkit import RDConfig
  import os
  dirLoc = os.path.join(RDConfig.RDCodeDir, 'Dbase', 'TEST.GDB')

  TextFileToDatabase(dirLoc, 'fromtext', sio)