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)
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)
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)