Dear folks, I have some old code which I would like to convert smoothly to rdkit. I have set-up a MySQL database of molecules given MOL2 and SMILES. The substructure search happens via frowns: " db_smiles = db.do('SELECT ligand_id, smiles FROM ligands;')
ligand_ids = [] for db_smile in db_smiles: try: db_can_smiles = Smiles.smilin(db_smile[1]).cansmiles() match = pattern.match(Smiles.smilin(db_can_smiles)) if match != None: ligand_ids.append(db_smile[0]) except: pass #print "Warning: failed for to recognize \"%s\" SMILES string<br>\n" %db_smile[1] return ligand_ids " Do I necessarily need to convert MySQL to PostgreSQL? A quick google search shows me that this should be feasible, but I have never done it so far. Or can I just replace the frowns SMILES search by the RDkit SMILES search? Cheers & Thanks, Paul This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you must not copy this message or attachment or disclose the contents to any other person. If you have received this transmission in error, please notify the sender immediately and delete the message and any attachment from your system. Merck KGaA, Darmstadt, Germany and any of its subsidiaries do not accept liability for any omissions or errors in this message which may arise as a result of E-Mail-transmission or for damages resulting from any unauthorized changes of the content of this message and any attachment thereto. Merck KGaA, Darmstadt, Germany and any of its subsidiaries do not guarantee that this message is free of viruses and does not accept liability for any damages caused by any virus transmitted therewith. Click http://disclaimer.merck.de to access the German, French, Spanish and Portuguese versions of this disclaimer. ------------------------------------------------------------------------------ vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 _______________________________________________ Rdkit-discuss mailing list Rdkit-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rdkit-discuss