Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
PostgreSQL OpenEye cartridge benchmark based on ChEMBL15.
-- set search_path = public, openeye;
DO $$
DECLARE
molregno integer;
fp oefp;
BEGIN
FOR molregno, fp IN SELECT cfp.molregno, cfp.circular_fp
FROM chembl.compound_oefps cfp
ORDER BY random() LIMIT 100
LOOP
EXECUTE
'
SELECT molregno, circular_fp % $1
FROM chembl.compound_oefps
WHERE circular_fp %? $1
ORDER BY circular_fp <%> $1
LIMIT 10;
' USING fp;
END LOOP;
END$$;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment