def get_all(election_id=None, area_name=None, associated_area_id=None, area_type=None): election = Election.get_by_id(electionId=election_id) if associated_area_id is not None and area_type is not None: associated_area = get_by_id(areaId=associated_area_id) query = get_associated_areas_query(area=associated_area, areaType=area_type, electionId=election_id) else: query = Model.query if area_name is not None: query = query.filter(Model.areaName.like(area_name)) if election is not None: query = query.filter( or_( Model.electionId.in_(election.mappedElectionIds), Model.electionId.in_(election.subElectionIds) ) ) if area_type is not None: query = query.filter(Model.areaType == area_type) query = query.order_by(Model.areaId) result = get_paginated_query(query).all() return result
def get_all(electionId=None, officeId=None, tallySheetCode=None): query = Model.query.join( Submission.Model, Submission.Model.submissionId == Model.tallySheetId ).join( Election.Model, Election.Model.electionId == Submission.Model.electionId ) if electionId is not None: query = query.filter( or_( Election.Model.electionId == electionId, Election.Model.parentElectionId == electionId ) ) if officeId is not None: query = query.filter(Submission.Model.areaId == officeId) if tallySheetCode is not None: query = query.filter(Model.tallySheetCode == get_tally_sheet_code(tallySheetCode)) result = get_paginated_query(query).all() return result
def get_all(electionId=None, issuingOfficeId=None, receivingOfficeId=None, issuedBy=None, issuedTo=None): query = Model.query.filter(Model.delete == False) if electionId is not None: query = query.filter(Model.electionId == electionId) if issuingOfficeId is not None: query = query.filter(Model.issuingOfficeId == issuingOfficeId) if receivingOfficeId is not None: query = query.filter(Model.receivingOfficeId == receivingOfficeId) if issuedBy is not None: query = query.filter(Model.issuedBy == issuedBy) if issuedTo is not None: query = query.filter(Model.issuedTo == issuedTo) result = get_paginated_query(query).all() return result
def get_all(election_id=None, area_name=None, associated_area_id=None, area_type=None): if associated_area_id is not None and area_type is not None: associated_area = get_by_id(areaId=associated_area_id) query = get_associated_areas_query(area=associated_area, areaType=area_type, electionId=election_id) else: query = Model.query if area_name is not None: query = query.filter(Model.areaName.like(area_name)) # if election_id is not None: # query = query.filter( # or_( # Election.Model.electionId == election_id, # Election.Model.parentElectionId == election_id # ) # ) if area_type is not None: query = query.filter(Model.areaType == area_type) query = query.order_by(Model.areaId) result = get_paginated_query(query).all() return result
def get_all(electionId=None, officeId=None, tallySheetCode=None): election = Election.get_by_id(electionId=electionId) query = Model.query.join( Submission.Model, Submission.Model.submissionId == Model.tallySheetId).join( Election.Model, Election.Model.electionId == Submission.Model.electionId) if electionId is not None: query = query.filter( Election.Model.electionId.in_(election.mappedElectionIds)) if officeId is not None: query = query.filter(Submission.Model.areaId == officeId) if tallySheetCode is not None: query = query.filter( Model.tallySheetCode == get_tally_sheet_code(tallySheetCode)) # Filter by authorized areas user_access_area_ids: Set[int] = get_user_access_area_ids() query = query.filter(Submission.Model.areaId.in_(user_access_area_ids)) result = get_paginated_query(query).all() return result
def get_all(ballotBoxId=None): query = Model.query if ballotBoxId is not None: query = query.filter(Model.ballotBoxId.like(ballotBoxId)) result = get_paginated_query(query).all() return result
def get_all(): query = Model.query.filter( Model.parentElectionId == None ) result = get_paginated_query(query).all() return result
def get_all(ballotId=None, ballotType=None, electionId=None): result = Ballot.get_all(ballotId=ballotId, ballotType=ballotType, electionId=electionId) result = get_paginated_query(result).all() return Schema(many=True).dump(result).data
def getAll(electionId=None, areaId=None, tallySheetCode=None): result = TallySheet.get_all(electionId=electionId, areaId=areaId, tallySheetCode=tallySheetCode) result = get_paginated_query(result).all() return TallySheetSchema(many=True).dump(result).data
def get_all(submissionId, submissionCode=None): query = Model.query.filter(Model.submissionId == submissionId) if submissionCode is not None: query = query.filter(Model.submissionCode == submissionCode) result = get_paginated_query(query).all() return result
def get_all(tallySheetId, tallySheetCode=None): query = Model.query.filter(Model.tallySheetId == tallySheetId) if tallySheetCode is not None: query = query.filter(Model.tallySheetCode == tallySheetCode) result = get_paginated_query(query).all() return result
def get_all(electionId=None, areaId=None, tallySheetCode=None, voteType=None, partyId=None, limit=None, offset=None): # Filter by authorized areas user_access_area_ids: Set[int] = get_user_access_area_ids() query_args = [Model] query_filters = [ Submission.Model.areaId.in_(user_access_area_ids), Template.Model.templateId == Model.templateId, Submission.Model.submissionId == Model.tallySheetId, Election.Model.electionId == Submission.Model.electionId ] query_group_by = [Model.tallySheetId] if areaId is not None: query_filters.append(Submission.Model.areaId == areaId) if electionId is not None: election = Election.get_by_id(electionId=electionId) query_filters.append( Election.Model.electionId.in_( election.get_this_and_below_election_ids())) if tallySheetCode is not None: query_filters.append(Template.Model.templateName == tallySheetCode) if voteType is not None: query_filters.append(Election.Model.voteType == voteType) if partyId is not None: query_filters += [ MetaData.Model.metaId == Model.metaId, MetaData.Model.metaDataKey == "partyId", MetaData.Model.metaDataValue == partyId ] tally_sheet_list = db.session.query(*query_args).filter( *query_filters).group_by(*query_group_by).order_by(Model.tallySheetId) tally_sheet_list = get_paginated_query(query=tally_sheet_list, limit=limit, offset=offset) authorized_tally_sheet_list = [] for tally_sheet in tally_sheet_list: if has_role_based_access(election=tally_sheet.submission.election, tally_sheet_code=tally_sheet.tallySheetCode, access_type=WORKFLOW_ACTION_TYPE_VIEW): authorized_tally_sheet_list.append(tally_sheet) return authorized_tally_sheet_list
def get_all(ballotId=None): query = Model.query # if ballotId is not None: # query = query.filter( # Model.ballotId.like(ballotId) # ) result = get_paginated_query(query).all() return result
def get_all(tallySheetId): tallySheet = TallySheet.get_by_id(tallySheetId=tallySheetId) if tallySheet is None: raise NotFoundException("Tally sheet not found. (tallySheetId=%d)" % tallySheetId) result = TallySheetVersion.get_all(tallySheetId=tallySheetId) result = get_paginated_query(result).all() return TallySheetVersion_CE_201_PV_Schema(many=True).dump(result).data
def get_all(electionId=None, electorateName=None, parentElectorateId=None, electorateType=None): result = Electorate.get_all( electionId=electionId, electorateName=electorateName, parentElectorateId=parentElectorateId, electorateType=electorateType ) result = get_paginated_query(result).all() return Schema(many=True).dump(result).data
def get_all(electionId=None, categoryDescription=None): query = Model.query if electionId is not None: query = query.filter(Model.electionId == electionId) if categoryDescription is not None: query = query.filter(Model.categoryDescription == categoryDescription) result = get_paginated_query(query).all() return result
def get_all(electionId=None, officeId=None): query = Model.query if electionId is not None: query = query.filter(Model.electionId == electionId) if officeId is not None: query = query.filter(Model.officeId == officeId) result = get_paginated_query(query).all() return result
def get_all(electionId=None, officeName=None, parentOfficeId=None, officeType=None): result = Office.get_all(electionId=electionId, officeName=officeName, parentOfficeId=parentOfficeId, officeType=officeType) result = get_paginated_query(result).all() return Schema(many=True).dump(result).data
def get_all(electionId=None, areaName=None, associatedAreaId=None, areaType=None): query = Area.get_all(election_id=electionId, area_name=areaName, associated_area_id=associatedAreaId, area_type=get_area_type(area_type=areaType)) query = get_paginated_query(query) result = query.all() return AreaSchema(many=True).dump(result).data
def get_all(tallySheetId): tallySheet = TallySheet.get_by_id(tallySheetId=tallySheetId) if tallySheet is None: raise NotFoundException( message="Tally sheet not found (tallySheetId=%d)" % tallySheetId, code=MESSAGE_CODE_TALLY_SHEET_NOT_FOUND) result = TallySheetVersion.get_all(tallySheetId=tallySheetId) result = get_paginated_query(result).all() return TallySheetVersion_CE_201_PV_Schema(many=True).dump(result).data
def get_all(electionId=None, candidateId=None): query = Model.query if electionId is not None: query = query.filter(Model.electionId == electionId) if candidateId is not None: query = query.filter(Model.candidateId == candidateId) result = get_paginated_query(query).all() return result
def get_all(ballotBoxId=None, electionId=None): query = Model.query if ballotBoxId is not None: query = query.filter(Model.ballotBoxId.like(ballotBoxId)) if electionId is not None: query = query.filter(Model.electionId == electionId) query = query.order_by(cast(Model.ballotBoxId, Integer)) result = get_paginated_query(query).all() return result
def get_all(electionId=None, issuingOfficeId=None, receivingOfficeId=None, issuedBy=None, issuedTo=None): result = Model.get_all(electionId=electionId, issuingOfficeId=issuingOfficeId, receivingOfficeId=receivingOfficeId, issuedBy=issuedBy, issuedTo=issuedTo) result = get_paginated_query(result).all() return Schema(many=True).dump(result).data
def get_all(electionId=None, areaId=None, reportCode=None): query = Model.query if electionId is not None: query = query.filter(Model.electionId == electionId) if areaId is not None: query = query.filter(Model.areaId == areaId) if reportCode is not None: query = query.filter(Model.reportCode == get_report_code(reportCode)) result = get_paginated_query(query).all() return result
def get_all(invoiceId=None, stationaryItemId=None, received=None, receivedFrom=None, receivedBy=None, receivedOffice=None): result = InvoiceStationaryItem.get_all(invoiceId=invoiceId, stationaryItemId=stationaryItemId, received=received, receivedFrom=receivedFrom, receivedBy=receivedBy, receivedOffice=receivedOffice) result = get_paginated_query(result).all() return Schema(many=True).dump(result).data
def get_all(electionId=None, officeName=None, parentOfficeId=None, officeType=None): query = Model.query if officeName is not None: query = query.filter(Model.officeName.like(officeName)) if electionId is not None: query = query.filter(Model.electionId == electionId) if officeType is not None: query = query.filter(Model.officeType == officeType) else: query = query.filter(Model.parentOfficeId == parentOfficeId) result = get_paginated_query(query).all() return result
def get_all(invoiceId=None, stationaryItemId=None, received=None, receivedFrom=None, receivedBy=None, receivedOffice=None): query = Model.query.filter(Model.delete == False) if invoiceId is not None: query = query.filter(Model.invoiceId == invoiceId) if stationaryItemId is not None: query = query.filter(Model.stationaryItemId == stationaryItemId) if received is not None: query = query.filter(Model.received == received) if receivedFrom is not None: query = query.filter(Model.receivedFrom == receivedFrom) if receivedBy is not None: query = query.filter(Model.receivedBy == receivedBy) if receivedOffice is not None: query = query.filter(Model.receivedOffice == receivedOffice) result = get_paginated_query(query).all() return result
def get_all(ballotId=None, stationaryItemId=None, electionId=None, ballotType=None): query = Model.query if ballotId is not None: query = query.filter(Model.ballotId.like(ballotId)) if stationaryItemId is not None: query = query.filter(Model.stationaryItemId == stationaryItemId) if ballotType is not None: query = query.filter(Model.ballotType == ballotType) if electionId is not None: query = query.filter(Model.electionId == electionId) query = query.order_by(cast(Model.ballotId, Integer)) result = get_paginated_query(query).all() return result
def get_all(electionId=None, officeName=None, parentOfficeId=None, officeType=None): query = Model.query.join(Area.AreaAreaModel, Model.areaId == Area.AreaAreaModel.childAreaId, isouter=True) if officeName is not None: query = query.filter(Model.officeName.like(officeName)) if electionId is not None: query = query.filter(Model.electionId == electionId) if officeType is not None: query = query.filter(Model.officeType == officeType) if parentOfficeId is not None: query = query.filter(Area.AreaAreaModel.parentAreaId == parentOfficeId) result = get_paginated_query(query).all() return result
def get_all(tallySheetId): query = Model.query.filter(Model.tallySheetId == tallySheetId) result = get_paginated_query(query).all() return result