def test_all_ois_records_destroyed_when_new_record_posted(self, testapp):
''' Posting a new record with an id that matches a set of past records destroys all of them.
'''
# Set up the extractor
department = Department.create(name="B Police Department", short_name="BPD", load_defaults=False)
extractor, _ = Extractor.from_department_and_password(department=department, password="******")
# Set the correct authorization
testapp.authorization = ('Basic', (extractor.username, 'password'))
# post to the heartbeat URL to start the update
response = testapp.post_json("/data/heartbeat", params={"heartbeat": "heartbeat"})
# Post 5 fake incidents with an identical opaqueId to the OIS endpoint
ois_count = 5
test_client = JSONTestClient()
ois_data = test_client.make_ois(count=ois_count, short_name=department.short_name)
use_id = ois_data[0]['opaqueId']
for idx, _ in enumerate(ois_data):
ois_data[idx]['opaqueId'] = use_id
response = testapp.post_json("/data/OIS", params={'month': 0, 'year': 0, 'data': ois_data})
# assert that we got the expected reponse
assert response.status_code == 200
# there are 5 incident rows in the database
check_ois = OfficerInvolvedShootingBPD.query.all()
assert len(check_ois) == ois_count
# all the records in the database have the same id
ois_records = OfficerInvolvedShootingBPD.query.filter_by(opaque_id=use_id).all()
assert len(ois_records) == ois_count
# verify that the opaqueId is recorded in an IncidentsUpdated table
record_updated = IncidentsUpdated.query.filter_by(opaque_id=use_id).first()
assert record_updated is not None
assert record_updated.incident_type == "ois"
assert record_updated.department_id == department.id
# post to the heartbeat URL to start the update
response = testapp.post_json("/data/heartbeat", params={"heartbeat": "heartbeat"})
# Create 1 new fake incident
new_data = test_client.make_ois(count=1, short_name=department.short_name)
# give it the same opaqueId as the first batch
new_data[0]['opaqueId'] = use_id
# post the new incident
response = testapp.post_json("/data/OIS", params={'month': 0, 'year': 0, 'data': new_data})
# assert that we got the expected reponse
assert response.status_code == 200
# there is now only 1 incident row in the database
check_ois = OfficerInvolvedShootingBPD.query.all()
assert len(check_ois) == 1
# verify that the opaqueID posted matches that in the database
assert check_ois[0].opaque_id == use_id
# verify that the opaqueId is recorded in an IncidentsUpdated table
record_updated = IncidentsUpdated.query.filter_by(opaque_id=use_id).first()
assert record_updated is not None
assert record_updated.incident_type == "ois"
assert record_updated.department_id == department.id
def test_all_ois_records_destroyed_when_new_record_posted(self, testapp):
''' Posting a new record with an id that matches a set of past records destroys all of them.
'''
# Set up the extractor
department = Department.create(name="B Police Department",
short_name="BPD",
load_defaults=False)
extractor, _ = Extractor.from_department_and_password(
department=department, password="******")
# Set the correct authorization
testapp.authorization = ('Basic', (extractor.username, 'password'))
# post to the heartbeat URL to start the update
response = testapp.post_json("/data/heartbeat",
params={"heartbeat": "heartbeat"})
# Post 5 fake incidents with an identical opaqueId to the OIS endpoint
ois_count = 5
test_client = JSONTestClient()
ois_data = test_client.make_ois(count=ois_count,
short_name=department.short_name)
use_id = ois_data[0]['opaqueId']
for idx, _ in enumerate(ois_data):
ois_data[idx]['opaqueId'] = use_id
response = testapp.post_json("/data/OIS",
params={
'month': 0,
'year': 0,
'data': ois_data
})
# assert that we got the expected reponse
assert response.status_code == 200
# there are 5 incident rows in the database
check_ois = OfficerInvolvedShootingBPD.query.all()
assert len(check_ois) == ois_count
# all the records in the database have the same id
ois_records = OfficerInvolvedShootingBPD.query.filter_by(
opaque_id=use_id).all()
assert len(ois_records) == ois_count
# verify that the opaqueId is recorded in an IncidentsUpdated table
record_updated = IncidentsUpdated.query.filter_by(
opaque_id=use_id).first()
assert record_updated is not None
assert record_updated.incident_type == "ois"
assert record_updated.department_id == department.id
# post to the heartbeat URL to start the update
response = testapp.post_json("/data/heartbeat",
params={"heartbeat": "heartbeat"})
# Create 1 new fake incident
new_data = test_client.make_ois(count=1,
short_name=department.short_name)
# give it the same opaqueId as the first batch
new_data[0]['opaqueId'] = use_id
# post the new incident
response = testapp.post_json("/data/OIS",
params={
'month': 0,
'year': 0,
'data': new_data
})
# assert that we got the expected reponse
assert response.status_code == 200
# there is now only 1 incident row in the database
check_ois = OfficerInvolvedShootingBPD.query.all()
assert len(check_ois) == 1
# verify that the opaqueID posted matches that in the database
assert check_ois[0].opaque_id == use_id
# verify that the opaqueId is recorded in an IncidentsUpdated table
record_updated = IncidentsUpdated.query.filter_by(
opaque_id=use_id).first()
assert record_updated is not None
assert record_updated.incident_type == "ois"
assert record_updated.department_id == department.id
def test_post_ois_data(self, testapp):
''' New and updated OIS data from the extractor is processed as expected.
'''
# Set up the extractor
department = Department.create(name="B Police Department", short_name="BPD", load_defaults=False)
extractor, _ = Extractor.from_department_and_password(department=department, password="******")
# Set the correct authorization
testapp.authorization = ('Basic', (extractor.username, 'password'))
# post to the heartbeat URL to start the update
response = testapp.post_json("/data/heartbeat", params={"heartbeat": "heartbeat"})
# Post 5 fake incidents to the OIS endpoint
ois_count = 5
test_client = JSONTestClient()
ois_data = test_client.make_ois(count=ois_count, short_name=department.short_name)
response = testapp.post_json("/data/OIS", params={'month': 0, 'year': 0, 'data': ois_data})
# assert that we got the expected reponse
assert response.status_code == 200
# there are 5 incident rows in the database
check_ois = OfficerInvolvedShootingBPD.query.all()
assert len(check_ois) == ois_count
for incident in ois_data:
# verify that the opaqueIDs posted match those in the database
assert OfficerInvolvedShootingBPD.query.filter_by(opaque_id=incident['opaqueId']).first() is not None
# verify that the opaqueIds are recorded in IncidentsUpdated tables
record_updated = IncidentsUpdated.query.filter_by(opaque_id=incident['opaqueId']).first()
assert record_updated is not None
assert record_updated.incident_type == "ois"
assert record_updated.department_id == department.id
# post to the heartbeat URL to start a new update
response = testapp.post_json("/data/heartbeat", params={"heartbeat": "heartbeat"})
# Create 5 more fake incidents
new_data = test_client.make_ois(count=ois_count, short_name=department.short_name)
# give them the same opaqueIds as the first batch
for idx, _ in enumerate(new_data):
new_data[idx]['opaqueId'] = ois_data[idx]['opaqueId']
# post the new incident rows
response = testapp.post_json("/data/OIS", params={'month': 0, 'year': 0, 'data': new_data})
# assert that we got the expected reponse
assert response.status_code == 200
# there are 5 incident rows in the database
check_ois = OfficerInvolvedShootingBPD.query.all()
assert len(check_ois) == ois_count
# verify that the opaqueIDs posted match those in the database
for incident in ois_data:
assert OfficerInvolvedShootingBPD.query.filter_by(opaque_id=incident['opaqueId']).first() is not None
# Create 5 more fake incidents
new_data = test_client.make_ois(count=ois_count, short_name=department.short_name)
# give them the same opaqueIds as the first batch
for idx, _ in enumerate(new_data):
new_data[idx]['opaqueId'] = ois_data[idx]['opaqueId']
# post the new incident rows without starting a new update
response = testapp.post_json("/data/OIS", params={'month': 0, 'year': 0, 'data': new_data})
# assert that we got the expected reponse
assert response.status_code == 200
# there are 10 incident rows in the database
check_ois = OfficerInvolvedShootingBPD.query.all()
assert len(check_ois) == ois_count * 2
def test_post_ois_data(self, testapp):
''' New and updated OIS data from the extractor is processed as expected.
'''
# Set up the extractor
department = Department.create(name="B Police Department",
short_name="BPD",
load_defaults=False)
extractor, _ = Extractor.from_department_and_password(
department=department, password="******")
# Set the correct authorization
testapp.authorization = ('Basic', (extractor.username, 'password'))
# post to the heartbeat URL to start the update
response = testapp.post_json("/data/heartbeat",
params={"heartbeat": "heartbeat"})
# Post 5 fake incidents to the OIS endpoint
ois_count = 5
test_client = JSONTestClient()
ois_data = test_client.make_ois(count=ois_count,
short_name=department.short_name)
response = testapp.post_json("/data/OIS",
params={
'month': 0,
'year': 0,
'data': ois_data
})
# assert that we got the expected reponse
assert response.status_code == 200
# there are 5 incident rows in the database
check_ois = OfficerInvolvedShootingBPD.query.all()
assert len(check_ois) == ois_count
for incident in ois_data:
# verify that the opaqueIDs posted match those in the database
assert OfficerInvolvedShootingBPD.query.filter_by(
opaque_id=incident['opaqueId']).first() is not None
# verify that the opaqueIds are recorded in IncidentsUpdated tables
record_updated = IncidentsUpdated.query.filter_by(
opaque_id=incident['opaqueId']).first()
assert record_updated is not None
assert record_updated.incident_type == "ois"
assert record_updated.department_id == department.id
# post to the heartbeat URL to start a new update
response = testapp.post_json("/data/heartbeat",
params={"heartbeat": "heartbeat"})
# Create 5 more fake incidents
new_data = test_client.make_ois(count=ois_count,
short_name=department.short_name)
# give them the same opaqueIds as the first batch
for idx, _ in enumerate(new_data):
new_data[idx]['opaqueId'] = ois_data[idx]['opaqueId']
# post the new incident rows
response = testapp.post_json("/data/OIS",
params={
'month': 0,
'year': 0,
'data': new_data
})
# assert that we got the expected reponse
assert response.status_code == 200
# there are 5 incident rows in the database
check_ois = OfficerInvolvedShootingBPD.query.all()
assert len(check_ois) == ois_count
# verify that the opaqueIDs posted match those in the database
for incident in ois_data:
assert OfficerInvolvedShootingBPD.query.filter_by(
opaque_id=incident['opaqueId']).first() is not None
# Create 5 more fake incidents
new_data = test_client.make_ois(count=ois_count,
short_name=department.short_name)
# give them the same opaqueIds as the first batch
for idx, _ in enumerate(new_data):
new_data[idx]['opaqueId'] = ois_data[idx]['opaqueId']
# post the new incident rows without starting a new update
response = testapp.post_json("/data/OIS",
params={
'month': 0,
'year': 0,
'data': new_data
})
# assert that we got the expected reponse
assert response.status_code == 200
# there are 10 incident rows in the database
check_ois = OfficerInvolvedShootingBPD.query.all()
assert len(check_ois) == ois_count * 2