def get_sums_by_taxon(cls, session: Session, acquis_id: AcquisitionIDT) \ -> Dict[ClassifIDT, int]: res: ResultProxy = session.execute( "SELECT o.classif_id, count(1)" " FROM obj_head o " " WHERE o.acquisid = :acq" " GROUP BY o.classif_id", {"acq": acquis_id}) return { int(classif_id): int(cnt) for (classif_id, cnt) in res.fetchall() }
def get_sums_by_taxon(cls, session: Session, acquis_id: AcquisitionIDT) \ -> Dict[ClassifIDT, int]: sql = text("SELECT o.classif_id, count(1)" " FROM obj_head o " " WHERE o.acquisid = :acq " " AND o.classif_id IS NOT NULL " " AND o.classif_qual = 'V'" " GROUP BY o.classif_id") res: Result = session.execute(sql, {"acq": acquis_id}) return { int(classif_id): int(cnt) for (classif_id, cnt) in res.fetchall() }