def _get_pixel_result(self, connection, pxresult_id):
"""
Get the pixel result row from the database
"""
self._area_id = None
self._pxresult_id = None
if not self.noinsert:
pxresult = connection.execute(
select([
PIXEL_RESULT
]).where(PIXEL_RESULT.c.pxresult_id == pxresult_id)).first()
if pxresult is None:
self.logCritical(
"Pixel Result row not found for pxresult_id = %s\n",
pxresult_id)
else:
# Record the area_id
self._area_id = pxresult[PIXEL_RESULT.c.area_id]
self._pxresult_id = pxresult[PIXEL_RESULT.c.pxresult_id]
# Find the galaxy details
galaxy = connection.execute(
select([GALAXY], from_obj=GALAXY.join(AREA)).where(
AREA.c.area_id == self._area_id)).first()
self._galaxy_name = galaxy[GALAXY.c.name]
self._galaxy_id = galaxy[GALAXY.c.galaxy_id]
self._run_id = galaxy[GALAXY.c.run_id]
def _get_pixel_result(self, connection, pxresult_id):
"""
Get the pixel result row from the database
"""
self._area_id = None
self._pxresult_id = None
if not self.noinsert:
pxresult = connection.execute(select([PIXEL_RESULT]).where(PIXEL_RESULT.c.pxresult_id == pxresult_id)).first()
if pxresult is None:
self.logCritical("Pixel Result row not found for pxresult_id = %s\n", pxresult_id)
else:
# Record the area_id
self._area_id = pxresult[PIXEL_RESULT.c.area_id]
self._pxresult_id = pxresult[PIXEL_RESULT.c.pxresult_id]
# Find the galaxy details
galaxy = connection.execute(select([GALAXY], from_obj=GALAXY.join(AREA))
.where(AREA.c.area_id == self._area_id)).first()
self._galaxy_name = galaxy[GALAXY.c.name]
self._galaxy_id = galaxy[GALAXY.c.galaxy_id]
self._run_id = galaxy[GALAXY.c.run_id]
