def test_match_010_match_distances(pgdbConnAdmin, pgdbConnMatchEngine,
pgdbConnWeb):
cleanup(pgdbConnAdmin)
rider_args1 = {
'IPAddress': '127.0.0.1',
'RiderFirstName': 'RiderFirstName',
'RiderLastName': 'RiderLastName',
'RiderEmail': '*****@*****.**',
'RiderPhone': '555-555-5555',
'RiderCollectionZIP': '20111',
'RiderDropOffZIP': '20111',
'AvailableRideTimesLocal': '2018-10-01T01:00/2018-10-01T18:00',
'TotalPartySize': '1',
'TwoWayTripNeeded': 'True',
'RiderIsVulnerable': 'False',
'RiderWillNotTalkPolitics': 'True',
'PleaseStayInTouch': 'True',
'NeedWheelchair': 'False',
'RiderPreferredContact': 'Email',
'RiderAccommodationNotes': 'I am picky',
'RiderLegalConsent': 'True',
'RiderWillBeSafe': 'True',
'RiderCollectionAddress': 'at home',
'RiderDestinationAddress': 'at the polls'
}
results = generic_rider_insert(pgdbConnWeb, rider_args1)
uuid_rider1 = results['uuid']
error_code = results['error_code']
error_text = results['error_text']
assert len(uuid_rider1) > 0
rider_args2 = {
'IPAddress': '127.0.0.1',
'RiderFirstName': 'RiderFirstName',
'RiderLastName': 'RiderLastName',
'RiderEmail': '*****@*****.**',
'RiderPhone': '555-555-5555',
'RiderCollectionZIP': '20112',
'RiderDropOffZIP': '20112',
'AvailableRideTimesLocal': '2018-10-01T01:00/2018-10-01T18:00',
'TotalPartySize': '1',
'TwoWayTripNeeded': 'True',
'RiderIsVulnerable': 'False',
'RiderWillNotTalkPolitics': 'True',
'PleaseStayInTouch': 'True',
'NeedWheelchair': 'False',
'RiderPreferredContact': 'Email',
'RiderAccommodationNotes': 'I am picky',
'RiderLegalConsent': 'True',
'RiderWillBeSafe': 'True',
'RiderCollectionAddress': 'at home',
'RiderDestinationAddress': 'at the polls'
}
results = generic_rider_insert(pgdbConnWeb, rider_args2)
uuid_rider2 = results['uuid']
error_code = results['error_code']
error_text = results['error_text']
assert len(uuid_rider1) > 0
rider_args3 = {
'IPAddress': '127.0.0.1',
'RiderFirstName': 'RiderFirstName',
'RiderLastName': 'RiderLastName',
'RiderEmail': '*****@*****.**',
'RiderPhone': '555-555-5555',
'RiderCollectionZIP': '20115',
'RiderDropOffZIP': '20115',
'AvailableRideTimesLocal': '2018-10-01T01:00/2018-10-01T18:00',
'TotalPartySize': '1',
'TwoWayTripNeeded': 'True',
'RiderIsVulnerable': 'False',
'RiderWillNotTalkPolitics': 'True',
'PleaseStayInTouch': 'True',
'NeedWheelchair': 'False',
'RiderPreferredContact': 'Email',
'RiderAccommodationNotes': 'I am picky',
'RiderLegalConsent': 'True',
'RiderWillBeSafe': 'True',
'RiderCollectionAddress': 'at home',
'RiderDestinationAddress': 'at the polls'
}
results = generic_rider_insert(pgdbConnWeb, rider_args3)
uuid_rider3 = results['uuid']
error_code = results['error_code']
error_text = results['error_text']
assert len(uuid_rider3) > 0
rider_args4 = {
'IPAddress': '127.0.0.1',
'RiderFirstName': 'RiderFirstName',
'RiderLastName': 'RiderLastName',
'RiderEmail': '*****@*****.**',
'RiderPhone': '555-555-5555',
'RiderCollectionZIP': '22401',
'RiderDropOffZIP': '22401',
'AvailableRideTimesLocal': '2018-10-01T01:00/2018-10-01T18:00',
'TotalPartySize': '1',
'TwoWayTripNeeded': 'True',
'RiderIsVulnerable': 'False',
'RiderWillNotTalkPolitics': 'True',
'PleaseStayInTouch': 'True',
'NeedWheelchair': 'False',
'RiderPreferredContact': 'Email',
'RiderAccommodationNotes': 'I am picky',
'RiderLegalConsent': 'True',
'RiderWillBeSafe': 'True',
'RiderCollectionAddress': 'at home',
'RiderDestinationAddress': 'at the polls'
}
results = generic_rider_insert(pgdbConnWeb, rider_args4)
uuid_rider4 = results['uuid']
error_code = results['error_code']
error_text = results['error_text']
assert len(uuid_rider3) > 0
driver_args = {
'IPAddress': '127.0.0.1',
'DriverCollectionZIP': '20105',
'DriverCollectionRadius': '15',
'AvailableDriveTimesLocal': '2018-10-01T01:00/2018-10-01T18:00',
'DriverCanLoadRiderWithWheelchair': 'False',
'SeatCount': '1',
'DriverLicenseNumber': '',
'DriverFirstName': 'DriverFirstName',
'DriverLastName': 'DriverLastName',
'DriverEmail': '*****@*****.**',
'DriverPhone': '666-666-6666',
'DrivingOnBehalfOfOrganization': 'False',
'DrivingOBOOrganizationName': 'Good Org',
'RidersCanSeeDriverDetails': 'True',
'DriverWillNotTalkPolitics': 'True',
'PleaseStayInTouch': 'True',
'DriverPreferredContact': 'Email',
'DriverWillTakeCare': 'True'
}
results = generic_driver_insert(pgdbConnWeb, driver_args)
uuid_driver = results['uuid']
error_code = results['error_code']
error_text = results['error_text']
assert len(uuid_driver) > 0
pgdbConnWeb.commit()
cursor = pgdbConnMatchEngine.cursor()
cursor.execute("SELECT * FROM carpoolvote.perform_match()")
match_stats = getMatcherActivityStats(pgdbConnMatchEngine)
assert match_stats['error_count'] == 0
assert match_stats['expired_count'] == 0
assert match_stats['evaluated_pairs'] == 3
assert match_stats['proposed_count'] == 3
pgdbConnMatchEngine.commit()
def test_match_002_perfect_match(pgdbConnAdmin, pgdbConnMatchEngine,
pgdbConnWeb):
cleanup(pgdbConnAdmin)
rider_args = {
'IPAddress': '127.0.0.1',
'RiderFirstName': 'RiderFirstName',
'RiderLastName': 'RiderLastName',
'RiderEmail': '*****@*****.**',
'RiderPhone': '555-555-5555',
'RiderCollectionZIP': '90210',
'RiderDropOffZIP': '90210',
'AvailableRideTimesLocal': '2018-10-01T02:00/2018-10-01T03:00',
'TotalPartySize': '1',
'TwoWayTripNeeded': 'True',
'RiderIsVulnerable': 'True',
'RiderWillNotTalkPolitics': 'True',
'PleaseStayInTouch': 'True',
'NeedWheelchair': 'True',
'RiderPreferredContact': 'Email',
'RiderAccommodationNotes': 'I am picky',
'RiderLegalConsent': 'True',
'RiderWillBeSafe': 'True',
'RiderCollectionAddress': 'at home',
'RiderDestinationAddress': 'at the polls'
}
results = generic_rider_insert(pgdbConnWeb, rider_args)
uuid_rider = results['uuid']
error_code = results['error_code']
error_text = results['error_text']
assert len(uuid_rider) > 0
driver_args = {
'IPAddress': '127.0.0.1',
'DriverCollectionZIP': '90210',
'DriverCollectionRadius': '10',
'AvailableDriveTimesLocal': '2018-10-01T02:00/2018-10-01T03:00',
'DriverCanLoadRiderWithWheelchair': 'True',
'SeatCount': '1',
'DriverLicenseNumber': '',
'DriverFirstName': 'DriverFirstName',
'DriverLastName': 'DriverLastName',
'DriverEmail': '*****@*****.**',
'DriverPhone': '666-666-6666',
'DrivingOnBehalfOfOrganization': 'True',
'DrivingOBOOrganizationName': 'Good Org',
'RidersCanSeeDriverDetails': 'True',
'DriverWillNotTalkPolitics': 'True',
'PleaseStayInTouch': 'True',
'DriverPreferredContact': 'Email',
'DriverWillTakeCare': 'True'
}
results = generic_driver_insert(pgdbConnWeb, driver_args)
uuid_driver = results['uuid']
error_code = results['error_code']
error_text = results['error_text']
assert len(uuid_driver) > 0
pgdbConnWeb.commit()
cursor = pgdbConnMatchEngine.cursor()
cursor.execute("SELECT * FROM carpoolvote.perform_match()")
match_stats = getMatcherActivityStats(pgdbConnMatchEngine)
assert match_stats['error_count'] == 0
assert match_stats['expired_count'] == 0
assert match_stats['evaluated_pairs'] == 1
assert match_stats['proposed_count'] == 1
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver)
assert match_record['status'] == 'MatchProposed'
pgdbConnMatchEngine.commit()
cursor = pgdbConnWeb.cursor()
cursor.execute(
"""SELECT status FROM carpoolvote.driver WHERE "UUID"=%(uuid)s """,
{'uuid': uuid_driver})
results = cursor.fetchone()
assert results[0] == 'MatchProposed'
cursor.execute(
"""SELECT status FROM carpoolvote.rider WHERE "UUID"=%(uuid)s """,
{'uuid': uuid_rider})
results = cursor.fetchone()
assert results[0] == 'MatchProposed'
def test_user_actions_002_driver_cancels_drive_offer_email_only(pgdbConnAdmin, pgdbConnWeb):
cleanup(pgdbConnAdmin)
# 1. insert drive offer
driver_args = {
'IPAddress' : '127.0.0.1',
'DriverCollectionZIP' : '90210',
'DriverCollectionRadius' : '10',
'AvailableDriveTimesLocal' : '2018-10-01T02:00/2018-10-01T03:00',
'DriverCanLoadRiderWithWheelchair' : 'True',
'SeatCount' : '1',
'DriverLicenseNumber' : '',
'DriverFirstName' : 'DriverFirstName',
'DriverLastName' : 'DriverLastName',
'DriverEmail' : '*****@*****.**',
'DriverPhone' : '666-666-6666',
'DrivingOnBehalfOfOrganization' : 'True',
'DrivingOBOOrganizationName' : 'Good Org',
'RidersCanSeeDriverDetails' : 'True',
'DriverWillNotTalkPolitics' : 'True',
'PleaseStayInTouch' : 'True',
'DriverPreferredContact' : 'Email',
'DriverWillTakeCare' : 'True'
}
results = generic_driver_insert(pgdbConnWeb, driver_args)
uuid_driver=results['uuid']
error_code=results['error_code']
error_text=results['error_text']
assert len(uuid_driver)>0
pgdbConnWeb.commit()
# 2. Check the number of email and sms notification
cursor = pgdbConnAdmin.cursor()
cursor.execute("""SELECT COUNT(*) FROM carpoolvote.outgoing_email WHERE uuid=%(uuid)s """,
{'uuid' : uuid_driver})
results = cursor.fetchone()
assert results[0] == 1
cursor.execute("""SELECT COUNT(*) FROM carpoolvote.outgoing_sms WHERE uuid=%(uuid)s """,
{'uuid' : uuid_driver})
results = cursor.fetchone()
assert results[0] == 0
# 3. Cancel it
cursor = pgdbConnWeb.cursor()
cursor.execute("SELECT * FROM carpoolvote.driver_cancel_drive_offer(%(uuid)s, %(confparam)s)",
{'uuid' : uuid_driver, 'confparam' : driver_args['DriverLastName']})
results = cursor.fetchone()
assert len(results[1]) == 0
assert results[0] == 0
pgdbConnWeb.commit()
# 4. check the status
cursor = pgdbConnAdmin.cursor()
cursor.execute("""SELECT status FROM carpoolvote.driver where "UUID"=%(uuid)s """,
{'uuid' : uuid_driver})
results = cursor.fetchone()
assert results[0] == 'Canceled'
# 5. Check the number of email and sms notification
cursor = pgdbConnAdmin.cursor()
cursor.execute("""SELECT COUNT(*) FROM carpoolvote.outgoing_email WHERE uuid=%(uuid)s """,
{'uuid' : uuid_driver})
results = cursor.fetchone()
assert results[0] == 2
cursor.execute("""SELECT COUNT(*) FROM carpoolvote.outgoing_sms WHERE uuid=%(uuid)s """,
{'uuid' : uuid_driver})
results = cursor.fetchone()
assert results[0] == 0
# 6. Cancel it again
cursor = pgdbConnWeb.cursor()
cursor.execute("SELECT * FROM carpoolvote.driver_cancel_drive_offer(%(uuid)s, %(confparam)s)",
{'uuid' : uuid_driver, 'confparam' : driver_args['DriverLastName']})
results = cursor.fetchone()
assert len(results[1]) == 0
assert results[0] == 0
pgdbConnWeb.commit()
# 7. check the status
cursor = pgdbConnAdmin.cursor()
cursor.execute("""SELECT status FROM carpoolvote.driver where "UUID"=%(uuid)s """,
{'uuid' : uuid_driver})
results = cursor.fetchone()
assert results[0] == 'Canceled'
def test_user_actions_008_driver_cancels_confirmed_match(pgdbConnAdmin, pgdbConnMatchEngine, pgdbConnWeb):
cleanup(pgdbConnAdmin)
rider_args = {
'IPAddress' : '127.0.0.1',
'RiderFirstName' : 'RiderFirstName',
'RiderLastName' : 'RiderLastName',
'RiderEmail' : '*****@*****.**',
'RiderPhone' : '555-555-5555',
'RiderCollectionZIP' : '90210',
'RiderDropOffZIP' : '90210',
'AvailableRideTimesLocal' : '2018-10-01T02:00/2018-10-01T03:00',
'TotalPartySize' : '1',
'TwoWayTripNeeded' : 'True',
'RiderIsVulnerable' : 'True',
'RiderWillNotTalkPolitics' : 'True',
'PleaseStayInTouch' : 'True',
'NeedWheelchair' : 'True',
'RiderPreferredContact' : 'Email',
'RiderAccommodationNotes' : 'I am picky',
'RiderLegalConsent' : 'True',
'RiderWillBeSafe' : 'True',
'RiderCollectionAddress' : 'at home',
'RiderDestinationAddress' : 'at the polls'
}
rider_args2 = {
'IPAddress' : '127.0.0.1',
'RiderFirstName' : 'RiderFirstName2',
'RiderLastName' : 'RiderLastName2',
'RiderEmail' : '*****@*****.**',
'RiderPhone' : '555-555-5555',
'RiderCollectionZIP' : '90210',
'RiderDropOffZIP' : '90210',
'AvailableRideTimesLocal' : '2018-10-01T02:00/2018-10-01T03:00',
'TotalPartySize' : '1',
'TwoWayTripNeeded' : 'True',
'RiderIsVulnerable' : 'True',
'RiderWillNotTalkPolitics' : 'True',
'PleaseStayInTouch' : 'True',
'NeedWheelchair' : 'True',
'RiderPreferredContact' : 'Email',
'RiderAccommodationNotes' : 'I am picky',
'RiderLegalConsent' : 'True',
'RiderWillBeSafe' : 'True',
'RiderCollectionAddress' : 'at home',
'RiderDestinationAddress' : 'at the polls'
}
results = generic_rider_insert(pgdbConnWeb, rider_args)
uuid_rider=results['uuid']
error_code=results['error_code']
error_text=results['error_text']
assert len(uuid_rider)>0
results = generic_rider_insert(pgdbConnWeb, rider_args2)
uuid_rider2=results['uuid']
error_code=results['error_code']
error_text=results['error_text']
assert len(uuid_rider2)>0
driver_args = {
'IPAddress' : '127.0.0.1',
'DriverCollectionZIP' : '90210',
'DriverCollectionRadius' : '10',
'AvailableDriveTimesLocal' : '2018-10-01T02:00/2018-10-01T03:00',
'DriverCanLoadRiderWithWheelchair' : 'True',
'SeatCount' : '1',
'DriverLicenseNumber' : '',
'DriverFirstName' : 'DriverFirstName',
'DriverLastName' : 'DriverLastName',
'DriverEmail' : '*****@*****.**',
'DriverPhone' : '666-666-6666',
'DrivingOnBehalfOfOrganization' : 'True',
'DrivingOBOOrganizationName' : 'Good Org',
'RidersCanSeeDriverDetails' : 'True',
'DriverWillNotTalkPolitics' : 'True',
'PleaseStayInTouch' : 'True',
'DriverPreferredContact' : 'Email',
'DriverWillTakeCare' : 'True'
}
driver_args2 = {
'IPAddress' : '127.0.0.1',
'DriverCollectionZIP' : '90210',
'DriverCollectionRadius' : '10',
'AvailableDriveTimesLocal' : '2018-10-01T02:00/2018-10-01T03:00',
'DriverCanLoadRiderWithWheelchair' : 'True',
'SeatCount' : '1',
'DriverLicenseNumber' : '',
'DriverFirstName' : 'DriverFirstName',
'DriverLastName' : 'DriverLastName2',
'DriverEmail' : '*****@*****.**',
'DriverPhone' : '666-666-6666',
'DrivingOnBehalfOfOrganization' : 'True',
'DrivingOBOOrganizationName' : 'Good Org',
'RidersCanSeeDriverDetails' : 'True',
'DriverWillNotTalkPolitics' : 'True',
'PleaseStayInTouch' : 'True',
'DriverPreferredContact' : 'Email',
'DriverWillTakeCare' : 'True'
}
results = generic_driver_insert(pgdbConnWeb, driver_args)
uuid_driver=results['uuid']
error_code=results['error_code']
error_text=results['error_text']
assert len(uuid_driver)>0
results = generic_driver_insert(pgdbConnWeb, driver_args2)
uuid_driver2=results['uuid']
error_code=results['error_code']
error_text=results['error_text']
assert len(uuid_driver2)>0
pgdbConnWeb.commit()
cursor = pgdbConnMatchEngine.cursor()
cursor.execute("SELECT * FROM carpoolvote.perform_match()")
match_stats = getMatcherActivityStats(pgdbConnMatchEngine)
assert match_stats['error_count']==0
assert match_stats['expired_count']==0
assert match_stats['evaluated_pairs']==4
assert match_stats['proposed_count']==4
pgdbConnMatchEngine.commit()
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver)
assert match_record['status'] == 'MatchProposed'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver2)
assert match_record['status'] == 'MatchProposed'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider2, uuid_driver)
assert match_record['status'] == 'MatchProposed'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider2, uuid_driver2)
assert match_record['status'] == 'MatchProposed'
cursor = pgdbConnWeb.cursor()
cursor.execute("SELECT * FROM carpoolvote.driver_confirm_match(%(uuid_driver)s, %(uuid_rider)s, %(confirm)s)",
{'uuid_driver' : uuid_driver, 'uuid_rider' : uuid_rider, 'confirm' : driver_args['DriverLastName']})
results = cursor.fetchone()
assert len(results[1]) == 0
assert results[0] == 0
pgdbConnWeb.commit()
# Match is confirmed.
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver)
assert match_record['status'] == 'MatchConfirmed'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver2)
assert match_record['status'] == 'MatchProposed'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider2, uuid_driver)
assert match_record['status'] == 'MatchProposed'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider2, uuid_driver2)
assert match_record['status'] == 'MatchProposed'
# Cannot confirm and already confirmed match
cursor.execute("SELECT * FROM carpoolvote.driver_confirm_match(%(uuid_driver)s, %(uuid_rider)s, %(confirm)s)",
{'uuid_driver' : uuid_driver, 'uuid_rider' : uuid_rider, 'confirm' : driver_args['DriverLastName']})
results = cursor.fetchone()
assert len(results[1])> 0
assert results[0] == 2
pgdbConnWeb.commit()
# A 2nd Driver is not able to confirm an already confirmed ride request
cursor.execute("SELECT * FROM carpoolvote.driver_confirm_match(%(uuid_driver)s, %(uuid_rider)s, %(confirm)s)",
{'uuid_driver' : uuid_driver2, 'uuid_rider' : uuid_rider, 'confirm' : driver_args2['DriverLastName']})
results = cursor.fetchone()
assert len(results[1]) > 0
assert results[0] == 2
pgdbConnWeb.commit()
# Same driver confirms 2nd rider
cursor.execute("SELECT * FROM carpoolvote.driver_confirm_match(%(uuid_driver)s, %(uuid_rider)s, %(confirm)s)",
{'uuid_driver' : uuid_driver, 'uuid_rider' : uuid_rider2, 'confirm' : driver_args['DriverLastName']})
results = cursor.fetchone()
assert len(results[1]) == 0
assert results[0] == 0
pgdbConnWeb.commit()
# Match is confirmed (driver has 2 confirmed matches)
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver)
assert match_record['status'] == 'MatchConfirmed'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver2)
assert match_record['status'] == 'MatchProposed'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider2, uuid_driver)
assert match_record['status'] == 'MatchConfirmed'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider2, uuid_driver2)
assert match_record['status'] == 'MatchProposed'
cursor.execute("""SELECT status FROM carpoolvote.driver WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_driver})
results = cursor.fetchone()
assert results[0] == 'MatchConfirmed'
cursor.execute("""SELECT status FROM carpoolvote.driver WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_driver2})
results = cursor.fetchone()
assert results[0] == 'MatchProposed'
cursor.execute("""SELECT status FROM carpoolvote.rider WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_rider})
results = cursor.fetchone()
assert results[0] == 'MatchConfirmed'
cursor.execute("""SELECT status FROM carpoolvote.rider WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_rider2})
results = cursor.fetchone()
assert results[0] == 'MatchConfirmed'
# Now driver cancels one match
cursor.execute("SELECT * FROM carpoolvote.driver_cancel_confirmed_match(%(uuid_driver)s, %(uuid_rider)s, %(confirm)s)",
{'uuid_driver' : uuid_driver, 'uuid_rider' : uuid_rider2, 'confirm' : driver_args['DriverLastName']})
results = cursor.fetchone()
assert len(results[1]) == 0
assert results[0] == 0
pgdbConnWeb.commit()
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver)
assert match_record['status'] == 'MatchConfirmed'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver2)
assert match_record['status'] == 'MatchProposed'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider2, uuid_driver)
assert match_record['status'] == 'Canceled'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider2, uuid_driver2)
assert match_record['status'] == 'MatchProposed'
cursor.execute("""SELECT status FROM carpoolvote.driver WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_driver})
results = cursor.fetchone()
assert results[0] == 'MatchConfirmed'
cursor.execute("""SELECT status FROM carpoolvote.driver WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_driver2})
results = cursor.fetchone()
assert results[0] == 'MatchProposed'
cursor.execute("""SELECT status FROM carpoolvote.rider WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_rider})
results = cursor.fetchone()
assert results[0] == 'MatchConfirmed'
cursor.execute("""SELECT status FROM carpoolvote.rider WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_rider2})
results = cursor.fetchone()
assert results[0] == 'MatchProposed'
# Driver2 cancels
cursor.execute("SELECT * FROM carpoolvote.driver_cancel_drive_offer(%(uuid)s, %(confparam)s)",
{'uuid' : uuid_driver2, 'confparam' : driver_args2['DriverPhone']})
results = cursor.fetchone()
assert len(results[1]) == 0
assert results[0] == 0
pgdbConnWeb.commit()
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver)
assert match_record['status'] == 'MatchConfirmed'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver2)
assert match_record['status'] == 'Canceled'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider2, uuid_driver)
assert match_record['status'] == 'Canceled'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider2, uuid_driver2)
assert match_record['status'] == 'Canceled'
cursor.execute("""SELECT status FROM carpoolvote.driver WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_driver})
results = cursor.fetchone()
assert results[0] == 'MatchConfirmed'
cursor.execute("""SELECT status FROM carpoolvote.driver WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_driver2})
results = cursor.fetchone()
assert results[0] == 'Canceled'
cursor.execute("""SELECT status FROM carpoolvote.rider WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_rider})
results = cursor.fetchone()
assert results[0] == 'MatchConfirmed'
cursor.execute("""SELECT status FROM carpoolvote.rider WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_rider2})
results = cursor.fetchone()
assert results[0] == 'Pending'
# Driver1 cancels
cursor.execute("SELECT * FROM carpoolvote.driver_cancel_drive_offer(%(uuid)s, %(confparam)s)",
{'uuid' : uuid_driver, 'confparam' : driver_args['DriverPhone']})
results = cursor.fetchone()
assert len(results[1]) == 0
assert results[0] == 0
pgdbConnWeb.commit()
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver)
assert match_record['status'] == 'Canceled'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver2)
assert match_record['status'] == 'Canceled'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider2, uuid_driver)
assert match_record['status'] == 'Canceled'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider2, uuid_driver2)
assert match_record['status'] == 'Canceled'
cursor.execute("""SELECT status FROM carpoolvote.driver WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_driver})
results = cursor.fetchone()
assert results[0] == 'Canceled'
cursor.execute("""SELECT status FROM carpoolvote.driver WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_driver2})
results = cursor.fetchone()
assert results[0] == 'Canceled'
cursor.execute("""SELECT status FROM carpoolvote.rider WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_rider})
results = cursor.fetchone()
assert results[0] == 'Pending'
cursor.execute("""SELECT status FROM carpoolvote.rider WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_rider2})
results = cursor.fetchone()
assert results[0] == 'Pending'
def test_user_actions_005_rider_cancels_ride_request_email_only(pgdbConnAdmin, pgdbConnMatchEngine, pgdbConnWeb):
cleanup(pgdbConnAdmin)
# 1. insert ride request
args = {
'IPAddress' : '127.0.0.1',
'RiderFirstName' : 'RiderFirstName',
'RiderLastName' : 'RiderLastName',
'RiderEmail' : '*****@*****.**',
'RiderPhone' : '555-555-555',
'RiderCollectionZIP' : '90210',
'RiderDropOffZIP' : '90210',
'AvailableRideTimesLocal' : '2018-10-01T02:00/2018-10-01T03:00|2019-10-01T02:00/2019-10-01T03:00',
'TotalPartySize' : '10',
'TwoWayTripNeeded' : 'True',
'RiderIsVulnerable' : 'True',
'RiderWillNotTalkPolitics' : 'True',
'PleaseStayInTouch' : 'True',
'NeedWheelchair' : 'True',
'RiderPreferredContact' : 'Email',
'RiderAccommodationNotes' : 'I am picky',
'RiderLegalConsent' : 'True',
'RiderWillBeSafe' : 'True',
'RiderCollectionAddress' : 'at home',
'RiderDestinationAddress' : 'at the polls'
}
results = generic_rider_insert(pgdbConnWeb, args)
uuid=results['uuid']
error_code=results['error_code']
error_text=results['error_text']
assert len(error_text)==0
assert error_code==0
assert len(uuid)>0
pgdbConnWeb.commit()
# 2. Check the number of email and sms notification
cursor = pgdbConnAdmin.cursor()
cursor.execute("""SELECT COUNT(*) FROM carpoolvote.outgoing_email WHERE uuid=%(uuid)s """,
{'uuid' : uuid})
results = cursor.fetchone()
assert results[0] == 1
cursor.execute("""SELECT COUNT(*) FROM carpoolvote.outgoing_sms WHERE uuid=%(uuid)s """,
{'uuid' : uuid})
results = cursor.fetchone()
assert results[0] == 0
# 3. Cancel it
cursor = pgdbConnWeb.cursor()
cursor.execute("SELECT * FROM carpoolvote.rider_cancel_ride_request(%(uuid)s, %(confparam)s)",
{'uuid' : uuid, 'confparam' : args['RiderLastName']})
results = cursor.fetchone()
assert len(results[1]) == 0
assert results[0] == 0
pgdbConnWeb.commit()
# 4. check the status
cursor = pgdbConnAdmin.cursor()
cursor.execute("""SELECT status FROM carpoolvote.rider where "UUID"=%(uuid)s """,
{'uuid' : uuid})
results = cursor.fetchone()
assert results[0] == 'Canceled'
# 5. Check the number of email and sms notification
cursor = pgdbConnAdmin.cursor()
cursor.execute("""SELECT COUNT(*) FROM carpoolvote.outgoing_email WHERE uuid=%(uuid)s """,
{'uuid' : uuid})
results = cursor.fetchone()
assert results[0] == 2
cursor.execute("""SELECT COUNT(*) FROM carpoolvote.outgoing_sms WHERE uuid=%(uuid)s """,
{'uuid' : uuid})
results = cursor.fetchone()
assert results[0] == 0
# 6. Cancel it again
cursor = pgdbConnWeb.cursor()
cursor.execute("SELECT * FROM carpoolvote.rider_cancel_ride_request(%(uuid)s, %(confparam)s)",
{'uuid' : uuid, 'confparam' : args['RiderLastName']})
results = cursor.fetchone()
assert len(results[1]) == 0
assert results[0] == 0
pgdbConnWeb.commit()
# 7. check the status
cursor = pgdbConnAdmin.cursor()
cursor.execute("""SELECT status FROM carpoolvote.rider where "UUID"=%(uuid)s """,
{'uuid' : uuid})
results = cursor.fetchone()
assert results[0] == 'Canceled'
# now test cancellation on confirmed match
rider_args = {
'IPAddress' : '127.0.0.1',
'RiderFirstName' : 'RiderFirstName',
'RiderLastName' : 'RiderLastName',
'RiderEmail' : '*****@*****.**',
'RiderPhone' : '555-555-5555',
'RiderCollectionZIP' : '90210',
'RiderDropOffZIP' : '90210',
'AvailableRideTimesLocal' : '2018-10-01T02:00/2018-10-01T03:00',
'TotalPartySize' : '1',
'TwoWayTripNeeded' : 'True',
'RiderIsVulnerable' : 'True',
'RiderWillNotTalkPolitics' : 'True',
'PleaseStayInTouch' : 'True',
'NeedWheelchair' : 'True',
'RiderPreferredContact' : 'Email',
'RiderAccommodationNotes' : 'I am picky',
'RiderLegalConsent' : 'True',
'RiderWillBeSafe' : 'True',
'RiderCollectionAddress' : 'at home',
'RiderDestinationAddress' : 'at the polls'
}
results = generic_rider_insert(pgdbConnWeb, rider_args)
uuid_rider=results['uuid']
error_code=results['error_code']
error_text=results['error_text']
assert len(uuid_rider)>0
driver_args = {
'IPAddress' : '127.0.0.1',
'DriverCollectionZIP' : '90210',
'DriverCollectionRadius' : '10',
'AvailableDriveTimesLocal' : '2018-10-01T02:00/2018-10-01T03:00',
'DriverCanLoadRiderWithWheelchair' : 'True',
'SeatCount' : '1',
'DriverLicenseNumber' : '',
'DriverFirstName' : 'DriverFirstName',
'DriverLastName' : 'DriverLastName',
'DriverEmail' : '*****@*****.**',
'DriverPhone' : '666-666-6666',
'DrivingOnBehalfOfOrganization' : 'True',
'DrivingOBOOrganizationName' : 'Good Org',
'RidersCanSeeDriverDetails' : 'True',
'DriverWillNotTalkPolitics' : 'True',
'PleaseStayInTouch' : 'True',
'DriverPreferredContact' : 'Email',
'DriverWillTakeCare' : 'True'
}
results = generic_driver_insert(pgdbConnWeb, driver_args)
uuid_driver=results['uuid']
error_code=results['error_code']
error_text=results['error_text']
assert len(uuid_driver)>0
pgdbConnWeb.commit()
cursor = pgdbConnMatchEngine.cursor()
cursor.execute("SELECT * FROM carpoolvote.perform_match()")
match_stats = getMatcherActivityStats(pgdbConnMatchEngine)
assert match_stats['error_count']==0
assert match_stats['expired_count']==0
assert match_stats['evaluated_pairs']==1
assert match_stats['proposed_count']==1
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver)
assert match_record['status'] == 'MatchProposed'
pgdbConnMatchEngine.commit()
cursor = pgdbConnWeb.cursor()
cursor.execute("SELECT * FROM carpoolvote.driver_confirm_match(%(uuid_driver)s, %(uuid_rider)s, %(confirm)s)",
{'uuid_driver' : uuid_driver, 'uuid_rider' : uuid_rider, 'confirm' : driver_args['DriverLastName']})
results = cursor.fetchone()
assert len(results[1]) == 0
assert results[0] == 0
pgdbConnWeb.commit()
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver)
assert match_record['status'] == 'MatchConfirmed'
pgdbConnMatchEngine.commit()
cursor = pgdbConnWeb.cursor()
cursor.execute("""SELECT status FROM carpoolvote.driver WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_driver})
results = cursor.fetchone()
assert results[0] == 'MatchConfirmed'
cursor.execute("""SELECT status FROM carpoolvote.rider WHERE "UUID"=%(uuid)s """, {'uuid' : uuid_rider})
results = cursor.fetchone()
assert results[0] == 'MatchConfirmed'
# Cannot match an already matched record
cursor.execute("SELECT * FROM carpoolvote.driver_confirm_match(%(uuid_driver)s, %(uuid_rider)s, %(confirm)s)",
{'uuid_driver' : uuid_driver, 'uuid_rider' : uuid_rider, 'confirm' : driver_args['DriverLastName']})
results = cursor.fetchone()
assert len(results[1])> 0
assert results[0] == 2
# Cancel the ride request
cursor = pgdbConnWeb.cursor()
cursor.execute("SELECT * FROM carpoolvote.rider_cancel_ride_request(%(uuid)s, %(confparam)s)",
{'uuid' : uuid_rider, 'confparam' : rider_args['RiderLastName']})
results = cursor.fetchone()
assert len(results[1]) == 0
assert results[0] == 0
pgdbConnWeb.commit()
# 7. check the status
cursor = pgdbConnAdmin.cursor()
cursor.execute("""SELECT status FROM carpoolvote.rider where "UUID"=%(uuid)s """,
{'uuid' : uuid_rider})
results = cursor.fetchone()
assert results[0] == 'Canceled'
cursor = pgdbConnAdmin.cursor()
cursor.execute("""SELECT status FROM carpoolvote.driver where "UUID"=%(uuid)s """,
{'uuid' : uuid_driver})
results = cursor.fetchone()
assert results[0] == 'Pending'
match_record = getMatchRecord(pgdbConnMatchEngine, uuid_rider, uuid_driver)
assert match_record['status'] == 'Canceled'
pgdbConnMatchEngine.commit()