def person_main(): assembly_id = int(request.args.get("assembly_id", current_assembly_id())) officials = ( Person.query.order_by(desc(Person.id)) .join(Candidacy) .filter(and_(Candidacy.assembly_id == assembly_id, Candidacy.is_elected == True)) ) return render_template("people.html", officials=officials, assembly_id=assembly_id)
def party_main(): assembly_id = int(request.args.get('assembly_id', current_assembly_id())) parties = Party.query.distinct(Party.id)\ .join(Candidacy)\ .filter(Candidacy.assembly_id==assembly_id) return render_template('parties.html',\ assembly_id=assembly_id,\ parties=parties)
def legislator_of(cls, region_id): if not region_id: return None assembly_id = current_assembly_id() region = Region.query.filter_by(id=region_id).one() legislator = None while not legislator and region: try: legislator = region.candidates\ .filter(Candidacy.assembly_id == assembly_id)\ .filter_by(is_elected=True)\ .one() except MultipleResultsFound as e: break except NoResultFound as e: region = region.parents.order_by(False)\ .order_by(func.length(Region.id).desc())\ .first() return legislator
def bill_main(): assembly_id = int(request.args.get('assembly_id', current_assembly_id())) bills = Bill.query.filter(Bill.assembly_id==assembly_id)\ .order_by(Bill.proposed_date.desc().nullslast()) return render_template('bills.html',\ assembly_id=assembly_id, bills=bills)