idr_search_by_map_anns.py

import omero
from omero.gateway import BlitzGateway

# See https://www.openmicroscopy.org/community/posting.php?mode=reply&f=6&t=8736

idr_client = omero.client(host="idr.openmicroscopy.org", port=4064)
idr_client.createSession('public', 'public')
conn = BlitzGateway(client_obj=idr_client)

# Use search service - NB: not currently working on IDR
# result = conn.searchObjects(["Project", "Screen"], "Organism: Homo sapiens")
# print result

def _escape_chars_like(query):
    escape_chars = {
        "%": "\%",
        "_": "\_",
    }
    for k, v in escape_chars.items():
        query = query.replace(k, v)
    return query

# Use query Service (like OMERO.mapr)...
query_service = conn.getQueryService()
params = omero.sys.ParametersI()
# Will match e.g. "Homo Sapiens"
# Use leading and trailing %% wildcard
params.addString('value', "%%%s%%" % _escape_chars_like("sapi"))
params.addString('name', 'Organism')

query = """select pal.parent from 
            ProjectAnnotationLink pal
            join pal.child a
            join a.mapValue mv
			where mv.value like :value and mv.name = :name
            """

result = query_service.findAllByQuery(query, params, conn.SERVICE_OPTS)

for p in result:
	print "ID", p.id.val, p.name.val

conn.close()