def test_sort_by_candidate_id(self): factories.CandidateHistoryFactory( candidate_id='S001', name='Robert Ritchie', two_year_period=2012, office='S', state='NY', ) factories.CandidateHistoryFactory( candidate_id='S002', name='FARLEY Ritchie', two_year_period=2012, office='S', state='NY', ) factories.CandidateHistoryFactory( candidate_id='S003', name='Robert Ritchie', election_years=[2012], two_year_period=2012, office='S', state='NY', ) factories.CandidateElectionFactory(candidate_id='S001', cand_election_year=2012) factories.CandidateElectionFactory(candidate_id='S002', cand_election_year=2012) factories.CandidateElectionFactory(candidate_id='S003', cand_election_year=2012) factories.ElectioneeringByCandidateFactory( cycle=2012, candidate_id='S001', total=700, count=5, ), factories.ElectioneeringByCandidateFactory( cycle=2012, candidate_id='S002', total=500, count=3, ), factories.ElectioneeringByCandidateFactory( cycle=2012, candidate_id='S003', total=100, count=1, ), response = self._results( api.url_for(ElectioneeringByCandidateView, sort='-candidate_id', office='senate', state='NY', cycle=2012)) self.assertEqual(len(response), 3) self.assertEqual(response[0]['candidate_id'], 'S003') self.assertEqual(response[1]['candidate_id'], 'S002') self.assertEqual(response[2]['candidate_id'], 'S001')
def test_sort_by_committee_name(self): factories.CommitteeHistoryFactory(name='Warner for America', cycle=2010, committee_id='C005') factories.CommitteeHistoryFactory(name='Ritche for America', cycle=2010, committee_id='C006') factories.CandidateHistoryFactory( candidate_id='S005', name='WARNER, MARK', election_years=[2010], two_year_period=2010, office='S', state='NY', ) factories.CandidateHistoryFactory( candidate_id='S006', name='BALDWIN, ALISSA', election_years=[2010], two_year_period=2010, office='S', state='NY', ) factories.CandidateElectionFactory(candidate_id='S005', cand_election_year=2010) factories.CandidateElectionFactory(candidate_id='S006', cand_election_year=2010) factories.ScheduleEByCandidateFactory( total=50000, count=10, cycle=2010, candidate_id='S005', support_oppose_indicator='S', committee_id='C005', ), factories.ScheduleEByCandidateFactory( total=10000, count=5, cycle=2010, candidate_id='S005', support_oppose_indicator='S', committee_id='C006', ), response = self._results( api.url_for(ScheduleEByCandidateView, sort='-committee_name', office='senate', cycle=2010, state='NY')) self.assertEqual(len(response), 2) self.assertEqual(response[0]['committee_name'], 'Warner for America') self.assertEqual(response[1]['committee_name'], 'Ritche for America')
def test_case_insensitivity(self): lower_candidate = factories.CandidateDetailFactory(candidate_id="H01") lower_committee_1 = factories.CommitteeDetailFactory(committee_id="ID01") [ factories.CommitteeHistoryFactory( committee_id=lower_committee_1.committee_id, cycle=2014, designation='J', is_active=False, ), ] db.session.flush() [ factories.CandidateCommitteeLinkFactory( candidate_id=lower_candidate.candidate_id, committee_id=lower_committee_1.committee_id, fec_election_year=2014, committee_type='P', committee_designation='J', ), ] [ factories.CandidateElectionFactory( candidate_id=lower_candidate.candidate_id, cand_election_year=2012, prev_election_year=2008, ), factories.CandidateElectionFactory( candidate_id=lower_candidate.candidate_id, cand_election_year=2016, prev_election_year=2012, ), ] results = self._results( api.url_for( CommitteeHistoryView, committee_id="id01", cycle=2014, election_full=False, is_active=False, ) ) assert len(results) == 1 results = self._results( api.url_for( CommitteeHistoryView, candidate_id="h01", cycle=2014, election_full=False, is_active=False, ) ) assert len(results) == 1
def test_house_cand_history_between_cycles(self): # Committee factories.CommitteeDetailFactory() candidate = factories.CandidateDetailFactory(candidate_id='H001') history = factories.CandidateHistoryFactory( candidate_id=candidate.candidate_id, two_year_period=2018, candidate_election_year=2020, ) db.session.flush() # Link factories.CandidateCommitteeLinkFactory( candidate_id=candidate.candidate_id, fec_election_year=2018, committee_type='H', ) factories.CandidateElectionFactory( candidate_id=candidate.candidate_id, cand_election_year=2020, prev_election_year=2018, ) # Make sure future house candidate returns results results = self._results( api.url_for( CandidateHistoryView, candidate_id=candidate.candidate_id, cycle=2020, # election_full='false' is strictly 2-year period election_full='true', )) assert len(results) == 1 assert results[0]['candidate_id'] == history.candidate_id assert results[0]['two_year_period'] == history.two_year_period assert results[0][ 'candidate_election_year'] == history.candidate_election_year
def setUp(self): super().setUp() self.candidate = factories.CandidateDetailFactory() self.committees = [factories.CommitteeDetailFactory() for _ in range(2)] self.histories = [ factories.CommitteeHistoryFactory(committee_id=self.committees[0].committee_id, cycle=2010), factories.CommitteeHistoryFactory(committee_id=self.committees[1].committee_id, cycle=2012), ] db.session.flush() self.links = [ factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[0].committee_id, fec_election_year=2010, committee_type='P', ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, fec_election_year=2012, committee_type='P', ), ] self.election = factories.CandidateElectionFactory( candidate_id=self.candidate.candidate_id, cand_election_year=2012, )
def test_sort_by_candidate_name_descending(self): factories.CandidateHistoryFactory( candidate_id='S005', name='WARNER, MARK', two_year_period=2010, office='S', state='NY', ) factories.CandidateHistoryFactory( candidate_id='S006', name='BALDWIN, ALISSA', two_year_period=2010, office='S', state='NY', ) factories.CandidateElectionFactory(candidate_id='S005', cand_election_year=2010) factories.CandidateElectionFactory(candidate_id='S006', cand_election_year=2010) factories.ScheduleEByCandidateFactory( total=50000, count=10, cycle=2010, candidate_id='S005', support_oppose_indicator='S', ), factories.ScheduleEByCandidateFactory( total=10000, count=5, cycle=2010, candidate_id='S006', support_oppose_indicator='S', ), response = self._results( api.url_for(ScheduleEByCandidateView, cycle=2010, office='senate', state='NY', sort='-candidate_name')) self.assertEqual(len(response), 2) self.assertEqual(response[0]['candidate_name'], 'WARNER, MARK') self.assertEqual(response[1]['candidate_name'], 'BALDWIN, ALISSA')
def setUp(self): super().setUp() self.committee = factories.CommitteeDetailFactory() self.candidates = [ factories.CandidateDetailFactory(candidate_id='P001'), factories.CandidateDetailFactory(candidate_id='P002'), ] self.histories = [ factories.CandidateHistoryFactory( candidate_id=self.candidates[0].candidate_id, two_year_period=2010), factories.CandidateHistoryFactory( candidate_id=self.candidates[1].candidate_id, two_year_period=2012), ] db.session.flush() self.links = [ factories.CandidateCommitteeLinkFactory( candidate_id=self.candidates[0].candidate_id, committee_id=self.committee.committee_id, fec_election_year=2010, committee_type='P', ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidates[1].candidate_id, committee_id=self.committee.committee_id, fec_election_year=2012, committee_type='P', ), ] self.elections = [ factories.CandidateElectionFactory( candidate_id=self.candidates[0].candidate_id, cand_election_year=2012, prev_election_year=2008, ), factories.CandidateElectionFactory( candidate_id=self.candidates[1].candidate_id, cand_election_year=2012, prev_election_year=2008, ), ]
def test_fields(self): candidate_id = 'S001' support_oppose_indicator = 'S' factories.ScheduleEByCandidateFactory( candidate_id=candidate_id, support_oppose_indicator=support_oppose_indicator, cycle=2018) factories.CandidateElectionFactory(candidate_id=candidate_id, cand_election_year=2018) results = self._results( api.url_for(ScheduleEByCandidateView, candidate_id='S001')) assert len(results) == 1 assert results[0].keys() == ScheduleEByCandidateSchema().fields.keys()
def setUp(self): super().setUp() self.candidate = factories.CandidateHistoryFactory( candidate_id='S123', two_year_period=2012, ) self.committees = [ factories.CommitteeHistoryFactory(cycle=2012, designation='P'), factories.CommitteeHistoryFactory(cycle=2012, designation='A'), ] factories.CandidateDetailFactory( candidate_id=self.candidate.candidate_id, election_years=[2008, 2012], ) [ factories.CandidateElectionFactory( candidate_id=self.candidate.candidate_id, cand_election_year=election_year) for election_year in [2008, 2012] ] [ factories.CommitteeDetailFactory(committee_id=each.committee_id) for each in self.committees ] db.session.flush() # Create two-year totals for both the target period (2011-2012) and the # previous period (2009-2010) for testing the `election_full` flag factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[0].committee_id, committee_designation='P', committee_type='S', fec_election_year=2012, ) factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, committee_designation='A', committee_type='S', fec_election_year=2012, ) factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, committee_designation='A', committee_type='S', fec_election_year=2010, )
def setUp(self): super(TestAggregates, self).setUp() self.committee = factories.CommitteeHistoryFactory( name='Ritchie for America', cycle=2012, ) self.candidate = factories.CandidateDetailFactory( candidate_id='P123', name='Robert Ritchie', election_years=[2012], office='P', ) self.candidate_history = factories.CandidateHistoryFactory( candidate_id='P123', name='Robert Ritchie', election_years=[2012], two_year_period=2012, office='P', ) factories.CandidateElectionFactory( candidate_id='P123', cand_election_year=2012, )
def test_sched_e_filter_match(self): factories.CandidateElectionFactory(candidate_id='S002', cand_election_year=2014) factories.ScheduleEByCandidateFactory( total=50000, count=10, cycle=2008, candidate_id='S001', support_oppose_indicator='O', ), factories.ScheduleEByCandidateFactory( total=10000, count=5, cycle=2010, candidate_id='S002', support_oppose_indicator='O', ), results = self._results( api.url_for(ScheduleEByCandidateView, candidate_id='S002', cycle=2014, support_oppose_indicator='S')) self.assertEqual(len(results), 1)
def setUp(self): super().setUp() self.candidate = factories.CandidateDetailFactory() self.committees = [factories.CommitteeDetailFactory() for _ in range(5)] self.histories = [ factories.CommitteeHistoryFactory( committee_id=self.committees[0].committee_id, cycle=2010, designation='P', is_active=True, ), factories.CommitteeHistoryFactory( committee_id=self.committees[1].committee_id, cycle=2012, designation='P', is_active=True, ), factories.CommitteeHistoryFactory( committee_id=self.committees[2].committee_id, cycle=2014, designation='P', is_active=True, ), factories.CommitteeHistoryFactory( committee_id=self.committees[3].committee_id, cycle=2014, designation='A', is_active=False, ), factories.CommitteeHistoryFactory( committee_id=self.committees[4].committee_id, cycle=2014, designation='J', is_active=False, ), ] db.session.flush() self.links = [ factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[0].committee_id, fec_election_year=2010, election_yr_to_be_included=2012, committee_type='P', committee_designation='P', ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, fec_election_year=2012, election_yr_to_be_included=2012, committee_type='P', committee_designation='P', ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[2].committee_id, fec_election_year=2014, committee_type='P', committee_designation='P', ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[3].committee_id, fec_election_year=2014, committee_type='P', committee_designation='A', ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[4].committee_id, fec_election_year=2014, committee_type='P', committee_designation='J', ), ] self.elections = [ factories.CandidateElectionFactory( candidate_id=self.candidate.candidate_id, cand_election_year=2012, prev_election_year=2008, ), factories.CandidateElectionFactory( candidate_id=self.candidate.candidate_id, cand_election_year=2016, prev_election_year=2012, ), ]
def setUp(self): super().setUp() self.candidate = factories.CandidateHistoryFutureFactory( candidate_id='S123', two_year_period=2012, candidate_election_year=2012, ) self.committees = [ factories.CommitteeHistoryFactory(cycle=2012, designation='P'), factories.CommitteeHistoryFactory(cycle=2012, designation='A'), ] factories.CandidateDetailFactory( candidate_id=self.candidate.candidate_id, election_years=[2008, 2012], ) [ factories.CandidateElectionFactory( candidate_id=self.candidate.candidate_id, cand_election_year=election_year, ) for election_year in [2008, 2012] ] [ factories.CommitteeDetailFactory(committee_id=each.committee_id) for each in self.committees ] factories.CandidateTotalFactory( candidate_id=self.candidate.candidate_id, cycle=2012, is_election=True, receipts=100, ) factories.CandidateTotalFactory( candidate_id=self.candidate.candidate_id, cycle=2012, is_election=False, receipts=75, ) factories.CandidateFlagsFactory( candidate_id=self.candidate.candidate_id) db.session.flush() # Create two-year totals for both the target period (2011-2012) and the # previous period (2009-2010) for testing the `election_full` flag factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[0].committee_id, committee_designation='P', committee_type='S', fec_election_year=2012, election_yr_to_be_included=2012, ) factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, committee_designation='A', committee_type='S', fec_election_year=2012, election_yr_to_be_included=2012, ) factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, committee_designation='A', committee_type='S', fec_election_year=2010, election_yr_to_be_included=2012, ) # Create a candidate_zero without a committee and $0 in CandidateTotal self.candidate_zero = factories.CandidateHistoryFutureFactory( candidate_id='H321', two_year_period=2018, candidate_election_year=2018, candidate_inactive=True, ) factories.CandidateDetailFactory( candidate_id=self.candidate_zero.candidate_id, election_years=[2018], ) factories.CandidateTotalFactory( candidate_id=self.candidate_zero.candidate_id, cycle=2018, is_election=False, receipts=0, ) factories.CandidateTotalFactory( candidate_id=self.candidate_zero.candidate_id, cycle=2018, is_election=True, receipts=0, ) # Create data for a candidate who ran in 2017 and 2018 self.candidate_17_18 = factories.CandidateHistoryFutureFactory( candidate_id='S456', two_year_period=2018, candidate_election_year=2018, candidate_inactive=False, ) self.committees_17_18 = [ factories.CommitteeHistoryFactory(cycle=2018, designation='P'), ] factories.CandidateDetailFactory( candidate_id=self.candidate_17_18.candidate_id, election_years=[2018], ) [ factories.CandidateElectionFactory( candidate_id=self.candidate_17_18.candidate_id, cand_election_year=election_year, ) for election_year in [2017, 2018] ] [ factories.CommitteeDetailFactory(committee_id=each.committee_id) for each in self.committees_17_18 ] factories.CandidateTotalFactory( candidate_id=self.candidate_17_18.candidate_id, cycle=2018, is_election=True, receipts=100, ) factories.CandidateTotalFactory( candidate_id=self.candidate_17_18.candidate_id, cycle=2018, is_election=False, receipts=100, ) factories.CandidateFlagsFactory( candidate_id=self.candidate_17_18.candidate_id) db.session.flush() factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate_17_18.candidate_id, committee_id=self.committees_17_18[0].committee_id, committee_designation='P', committee_type='S', cand_election_year=2017, fec_election_year=2018, ) factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate_17_18.candidate_id, committee_id=self.committees_17_18[0].committee_id, committee_designation='P', committee_type='S', cand_election_year=2018, fec_election_year=2018, ) # Create data for a candidate who ran just in 2017 self.candidate_17_only = factories.CandidateHistoryFutureFactory( candidate_id='H456', two_year_period=2018, candidate_election_year=2017, ) self.committees_17_only = [ factories.CommitteeHistoryFactory(cycle=2018, designation='P'), ] factories.CandidateDetailFactory( candidate_id=self.candidate_17_only.candidate_id, election_years=[2017], ) [ factories.CandidateElectionFactory( candidate_id=self.candidate_17_only.candidate_id, cand_election_year=election_year, ) for election_year in [2017] ] [ factories.CommitteeDetailFactory(committee_id=each.committee_id) for each in self.committees_17_only ] factories.CandidateTotalFactory( candidate_id=self.candidate_17_only.candidate_id, cycle=2018, is_election=True, receipts=150, ) factories.CandidateTotalFactory( candidate_id=self.candidate_17_only.candidate_id, cycle=2018, is_election=False, receipts=150, ) factories.CandidateFlagsFactory( candidate_id=self.candidate_17_only.candidate_id) db.session.flush() factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate_17_only.candidate_id, committee_id=self.committees_17_only[0].committee_id, committee_designation='P', committee_type='S', cand_election_year=2017, fec_election_year=2018, ) # Create data for future presidential - next_cycle. Use formula for future # Test full next_cycle and current_cycle 2-year totals self.candidate_20 = factories.CandidateHistoryFutureFactory( candidate_id='P456', two_year_period=self.current_cycle, candidate_election_year=self.next_cycle, ) self.candidate_20 = factories.CandidateHistoryFutureFactory( candidate_id='P456', two_year_period=self.next_cycle, candidate_election_year=self.next_cycle, ) # Candidate history won't have next_cycle yet self.committees_20 = [ factories.CommitteeHistoryFactory(cycle=self.current_cycle, designation='P'), ] factories.CandidateDetailFactory( candidate_id=self.candidate_20.candidate_id, election_years=[self.next_cycle], ) [ factories.CandidateElectionFactory( candidate_id=self.candidate_20.candidate_id, cand_election_year=election_year, ) for election_year in [self.next_cycle - 4, self.next_cycle] ] [ factories.CommitteeDetailFactory(committee_id=each.committee_id) for each in self.committees_20 ] # Full next_cycle factories.CandidateTotalFactory( candidate_id=self.candidate_20.candidate_id, cycle=self.next_cycle, is_election=True, receipts=55000, ) # current_cycle 2-year factories.CandidateTotalFactory( candidate_id=self.candidate_20.candidate_id, cycle=self.current_cycle, is_election=False, receipts=25000, ) factories.CandidateFlagsFactory( candidate_id=self.candidate_20.candidate_id) db.session.flush() factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate_20.candidate_id, committee_id=self.committees_20[0].committee_id, committee_designation='P', committee_type='P', cand_election_year=self.next_cycle, fec_election_year=self.current_cycle, ) factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate_20.candidate_id, committee_id=self.committees_20[0].committee_id, committee_designation='P', committee_type='P', cand_election_year=self.next_cycle, fec_election_year=self.next_cycle, )
def setUp(self): super().setUp() self.candidate = factories.CandidateDetailFactory() self.candidates = [ factories.CandidateHistoryFactory( candidate_id=self.candidate.candidate_id, state='PR', district='00', two_year_period=2018, election_years=[2020], cycles=[2018, 2020], office='H', candidate_election_year=2020, ), factories.CandidateHistoryFactory( candidate_id=self.candidate.candidate_id, state='PR', district='00', two_year_period=2020, election_years=[2020], cycles=[2018, 2020], office='H', candidate_election_year=2020, ), ] self.committees = [ factories.CommitteeHistoryFactory(cycle=2020, designation='P'), factories.CommitteeHistoryFactory(cycle=2020, designation='A'), ] [ factories.CandidateElectionFactory( candidate_id=self.candidate.candidate_id, cand_election_year=year) for year in [2016, 2020] ] [ factories.CommitteeDetailFactory(committee_id=each.committee_id) for each in self.committees ] db.session.flush() self.candidate_committee_links = [ factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[0].committee_id, committee_designation='P', fec_election_year=2018, election_yr_to_be_included=2020, ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, committee_designation='A', fec_election_year=2018, election_yr_to_be_included=2020, ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[0].committee_id, committee_designation='P', fec_election_year=2020, election_yr_to_be_included=2020, ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, committee_designation='A', fec_election_year=2020, election_yr_to_be_included=2020, ), ] self.totals = [ factories.TotalsHouseSenateFactory( receipts=50, disbursements=75, committee_id=self.committees[1].committee_id, coverage_end_date=datetime.datetime(2018, 12, 31), last_cash_on_hand_end_period=100, cycle=2018, ), factories.TotalsHouseSenateFactory( receipts=50, disbursements=75, committee_id=self.committees[1].committee_id, coverage_end_date=datetime.datetime(2020, 12, 31), last_cash_on_hand_end_period=300, cycle=2020, ), ] db.session.flush()
def setUp(self): super().setUp() self.candidate = factories.CandidateDetailFactory() self.candidates = [ factories.CandidateHistoryFactory( candidate_id=self.candidate.candidate_id, state='NY', two_year_period=2012, election_years=[2010, 2012], cycles=[2010, 2012], office='S', candidate_election_year=2012, ), factories.CandidateHistoryFactory( candidate_id=self.candidate.candidate_id, state='NY', two_year_period=2010, election_years=[2010, 2012], cycles=[2010, 2012], office='S', candidate_election_year=2012, ), ] self.committees = [ factories.CommitteeHistoryFactory(cycle=2012, designation='P'), factories.CommitteeHistoryFactory(cycle=2012, designation='A'), ] [ factories.CandidateElectionFactory( candidate_id=self.candidate.candidate_id, cand_election_year=year) for year in [2010, 2012] ] [ factories.CommitteeDetailFactory(committee_id=each.committee_id) for each in self.committees ] db.session.flush() self.candidate_committee_links = [ factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[0].committee_id, committee_designation='A', fec_election_year=2012, election_yr_to_be_included=2012, ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, committee_designation='P', fec_election_year=2012, election_yr_to_be_included=2012, ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, committee_designation='P', fec_election_year=2010, election_yr_to_be_included=2012, ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, committee_designation='P', fec_election_year=2010, ), ] self.totals = [ factories.TotalsHouseSenateFactory( receipts=50, disbursements=75, committee_id=self.committees[0].committee_id, coverage_end_date=datetime.datetime(2012, 9, 30), last_cash_on_hand_end_period=100, cycle=2012, ), factories.TotalsHouseSenateFactory( receipts=50, disbursements=75, committee_id=self.committees[1].committee_id, coverage_end_date=datetime.datetime(2012, 12, 31), last_cash_on_hand_end_period=100, cycle=2012, ), factories.TotalsHouseSenateFactory( receipts=50, disbursements=75, committee_id=self.committees[1].committee_id, coverage_end_date=datetime.datetime(2012, 12, 31), last_cash_on_hand_end_period=300, cycle=2010, ), ] self.president_candidate = factories.CandidateDetailFactory() self.president_candidates = [ factories.CandidateHistoryFactory( candidate_id=self.president_candidate.candidate_id, state='NY', two_year_period=2020, office='P', candidate_inactive=False, candidate_election_year=2020, ), factories.CandidateHistoryFactory( candidate_id=self.president_candidate.candidate_id, state='NY', two_year_period=2018, office='P', candidate_inactive=False, candidate_election_year=2020, ), ] self.president_committees = [ factories.CommitteeHistoryFactory(cycle=2020, designation='P'), factories.CommitteeHistoryFactory(cycle=2020, designation='J'), ] [ factories.CandidateElectionFactory( candidate_id=self.president_candidate.candidate_id, cand_election_year=year, ) for year in [2016, 2020] ] [ factories.CommitteeDetailFactory(committee_id=each.committee_id) for each in self.president_committees ] db.session.flush() self.president_candidate_committee_links = [ factories.CandidateCommitteeLinkFactory( candidate_id=self.president_candidate.candidate_id, committee_id=self.president_committees[0].committee_id, committee_designation='P', fec_election_year=2020, cand_election_year=2020, election_yr_to_be_included=2020, ), factories.CandidateCommitteeLinkFactory( candidate_id=self.president_candidate.candidate_id, committee_id=self.president_committees[0].committee_id, committee_designation='P', fec_election_year=2018, cand_election_year=2020, election_yr_to_be_included=2020, ), factories.CandidateCommitteeLinkFactory( candidate_id=self.president_candidate.candidate_id, committee_id=self.president_committees[1].committee_id, committee_designation='P', fec_election_year=2018, cand_election_year=2020, election_yr_to_be_included=2020, ), ] self.presidential_totals = [ factories.TotalsCombinedFactory( receipts=50, disbursements=75, committee_id=self.president_committees[0].committee_id, coverage_end_date=datetime.datetime(2019, 9, 30), last_cash_on_hand_end_period=0, cycle=2020, ), factories.TotalsCombinedFactory( receipts=1, disbursements=1, committee_id=self.president_committees[1].committee_id, coverage_end_date=datetime.datetime(2017, 12, 31), last_cash_on_hand_end_period=100, cycle=2018, ), factories.TotalsCombinedFactory( receipts=25, disbursements=10, committee_id=self.president_committees[0].committee_id, coverage_end_date=datetime.datetime(2017, 12, 31), last_cash_on_hand_end_period=300, cycle=2018, ), ]
def setUp(self): super().setUp() self.candidate = factories.CandidateDetailFactory() self.candidates = [ factories.CandidateHistoryFactory( candidate_id=self.candidate.candidate_id, state='NY', two_year_period=2012, election_years=[2010, 2012], cycles=[2010, 2012], office='S', ), factories.CandidateHistoryFactory( candidate_id=self.candidate.candidate_id, state='NY', two_year_period=2010, election_years=[2010, 2012], cycles=[2010, 2012], office='S', ), ] self.committees = [ factories.CommitteeHistoryFactory(cycle=2012, designation='P'), factories.CommitteeHistoryFactory(cycle=2012, designation='A'), ] [ factories.CandidateElectionFactory( candidate_id=self.candidate.candidate_id, cand_election_year=year) for year in [2010, 2012] ] [ factories.CommitteeDetailFactory(committee_id=each.committee_id) for each in self.committees ] db.session.flush() factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[0].committee_id, committee_designation='A', fec_election_year=2012, ) factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, committee_designation='P', fec_election_year=2012, ) factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, committee_designation='P', fec_election_year=2010, ) self.totals = [ factories.TotalsHouseSenateFactory( receipts=50, disbursements=75, committee_id=self.committees[0].committee_id, coverage_end_date=datetime.datetime(2012, 9, 30), last_cash_on_hand_end_period=1979, cycle=2012, ), factories.TotalsHouseSenateFactory( receipts=50, disbursements=75, committee_id=self.committees[1].committee_id, coverage_end_date=datetime.datetime(2012, 12, 31), last_cash_on_hand_end_period=1979, cycle=2012, ), factories.TotalsHouseSenateFactory( receipts=50, disbursements=75, committee_id=self.committees[1].committee_id, coverage_end_date=datetime.datetime(2012, 12, 31), last_cash_on_hand_end_period=1979, cycle=2010, ), ]
def setUp(self): super().setUp() self.candidate = factories.CandidateHistoryFactory( candidate_id='S123', two_year_period=2012, candidate_election_year=2012, ) self.committees = [ factories.CommitteeHistoryFactory(cycle=2012, designation='P'), factories.CommitteeHistoryFactory(cycle=2012, designation='A'), ] factories.CandidateHistoryLatestFactory( candidate_id=self.candidate.candidate_id, candidate_election_year=2012, two_year_period=2012, ) factories.CandidateDetailFactory( candidate_id=self.candidate.candidate_id, election_years=[2008, 2012], ) [ factories.CandidateElectionFactory( candidate_id=self.candidate.candidate_id, cand_election_year=election_year) for election_year in [2008, 2012] ] [ factories.CommitteeDetailFactory(committee_id=each.committee_id) for each in self.committees ] factories.CandidateTotalFactory( candidate_id=self.candidate.candidate_id, cycle=2012, is_election=True, receipts=100, ) factories.CandidateTotalFactory( candidate_id=self.candidate.candidate_id, cycle=2012, is_election=False, receipts=75, ) factories.CandidateFlagsFactory( candidate_id=self.candidate.candidate_id) db.session.flush() # Create two-year totals for both the target period (2011-2012) and the # previous period (2009-2010) for testing the `election_full` flag factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[0].committee_id, committee_designation='P', committee_type='S', fec_election_year=2012, ) factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, committee_designation='A', committee_type='S', fec_election_year=2012, ) factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, committee_designation='A', committee_type='S', fec_election_year=2010, ) # Create a candidate_zero without a committee and $0 in CandidateTotal self.candidate_zero = factories.CandidateHistoryFactory( candidate_id='H321', two_year_period=2018, candidate_election_year=2018, ) factories.CandidateDetailFactory( candidate_id=self.candidate_zero.candidate_id, election_years=[2018], ) factories.CandidateTotalFactory( candidate_id=self.candidate_zero.candidate_id, cycle=2018, is_election=False, receipts=0, )
def setUp(self): super().setUp() self.candidate = factories.CandidateDetailFactory() self.committees = [ factories.CommitteeDetailFactory() for _ in range(6) ] self.histories = [ factories.CommitteeHistoryFactory( committee_id=self.committees[0].committee_id, cycle=2010, designation='P', is_active=True, ), factories.CommitteeHistoryFactory( committee_id=self.committees[1].committee_id, cycle=2012, designation='P', is_active=True, ), factories.CommitteeHistoryFactory( committee_id=self.committees[2].committee_id, cycle=2014, designation='P', is_active=True, ), # Candidate PCC converted to PAC in 2016 factories.CommitteeHistoryFactory( committee_id=self.committees[2].committee_id, cycle=2016, designation='P', is_active=True, # Needed to show conversion info former_candidate_id=self.candidate.candidate_id, former_candidate_election_year=2016, former_committee_name= "Used to be PCC but I'm a PAC now committeee"), factories.CommitteeHistoryFactory( committee_id=self.committees[3].committee_id, cycle=2014, designation='A', is_active=False, ), factories.CommitteeHistoryFactory( committee_id=self.committees[4].committee_id, cycle=2014, designation='J', is_active=False, ), factories.CommitteeHistoryFactory( committee_id=self.committees[5].committee_id, cycle=2020, designation='D', is_active=True, sponsor_candidate_ids=['H003']), ] db.session.flush() self.links = [ factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[0].committee_id, fec_election_year=2010, election_yr_to_be_included=2012, committee_type='P', committee_designation='P', ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[1].committee_id, fec_election_year=2012, election_yr_to_be_included=2012, committee_type='P', committee_designation='P', ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[2].committee_id, fec_election_year=2014, committee_type='P', committee_designation='P', ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[3].committee_id, fec_election_year=2014, committee_type='P', committee_designation='A', ), factories.CandidateCommitteeLinkFactory( candidate_id=self.candidate.candidate_id, committee_id=self.committees[4].committee_id, fec_election_year=2014, committee_type='P', committee_designation='J', ), ] self.elections = [ factories.CandidateElectionFactory( candidate_id=self.candidate.candidate_id, cand_election_year=2012, prev_election_year=2008, ), factories.CandidateElectionFactory( candidate_id=self.candidate.candidate_id, cand_election_year=2016, prev_election_year=2012, ), ]