def well_images(request, conn=None, **kwargs):
# check for mandatory parameter id
well_id = request.GET.get("id", None)
if well_id is None:
return JsonResponse({"error": "No well id provided."})
try:
query_service = conn.getQueryService()
# set well id
params = ParametersI()
params.add("well_id", rlong(long(well_id)))
# get total count first
count = query_service.projection(
"select count(distinct ws.id) from WellSample ws " +
"where ws.well.id = :well_id",
params,
)
results = {"data": [], "meta": {"totalCount": count[0][0].val}}
# set offset and limit
filter = omero.sys.Filter()
filter.offset = rint(request.GET.get("offset", 0))
filter.limit = rint(request.GET.get("limit", 10))
params.theFilter = filter
# fire off query
images = query_service.findAllByQuery(
"select ws.image from WellSample ws " +
"where ws.well.id = :well_id order by well_index", params)
# we need only image id and name for our purposes
for img in images:
img_ret = {"@id": img.getId().getValue()}
if img.getName() is not None:
img_ret["Name"] = img.getName().getValue()
results["data"].append(img_ret)
return JsonResponse(results)
except Exception as get_well_images_exception:
return JsonResponse({"error": repr(get_well_images_exception)})
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import sys
import omero
from omero.rtypes import *
from omero_sys_ParametersI import ParametersI
client = omero.client(sys.argv)
try:
sf = client.createSession()
q = sf.getQueryService()
query_string = "select i from Image i where i.id = :id and name like :namedParameter";
p = ParametersI()
p.addId(1L)
p.add("namedParameter", rstring("cell%mit%"));
results = q.findAllByQuery(query_string, p)
finally:
client.closeSession()
def testAddBasicInt(self):
p = ParametersI()
p.add("int", rint(1))
self.assertEquals(rint(1), p.map["int"])
def testAddBasicString(self):
p = ParametersI()
p.add("string", rstring("a"))
self.assertEquals(rstring("a"), p.map["string"])
def testAddBasicInt(self):
p = ParametersI()
p.add("int", rint(1))
assert rint(1) == p.map["int"]
def testAddBasicString(self):
p = ParametersI()
p.add("string", rstring("a"))
assert rstring("a") == p.map["string"]
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import sys
import omero
from omero.rtypes import *
from omero_sys_ParametersI import ParametersI
client = omero.client(sys.argv)
try:
sf = client.createSession()
q = sf.getQueryService()
query_string = "select i from Image i where i.id = :id and name like :namedParameter"
p = ParametersI()
p.addId(1L)
p.add("namedParameter", rstring("cell%mit%"))
results = q.findAllByQuery(query_string, p)
finally:
client.closeSession()
def testAddBasicInt(self):
p = ParametersI()
p.add("int", rint(1))
assert rint(1) == p.map["int"]
def testAddBasicString(self):
p = ParametersI()
p.add("string", rstring("a"))
assert rstring("a") == p.map["string"]
def testAddBasicInt(self):
p = ParametersI()
p.add("int", rint(1))
self.assertEquals(rint(1), p.map["int"])
def testAddBasicString(self):
p = ParametersI()
p.add("string", rstring("a"))
self.assertEquals( rstring("a"), p.map["string"])
