def test_get_upload_file_url_s3(database, monkeypatch):
""" Test getting the url of the uploaded file non-locally. """
monkeypatch.setattr(fileHandler, 'CONFIG_BROKER', {'local': False})
s3_url_handler = Mock()
s3_url_handler.return_value.get_signed_url.return_value = 'some/url/here.csv'
monkeypatch.setattr(fileHandler, 'S3Handler', s3_url_handler)
# create and insert submission/job
sess = database.session
sub = SubmissionFactory(submission_id=1, d2_submission=False)
job = JobFactory(
submission_id=1,
job_status=sess.query(JobStatus).filter_by(name='finished').one(),
job_type=sess.query(JobType).filter_by(name='file_upload').one(),
file_type=sess.query(FileType).filter_by(name='appropriations').one(),
filename='1/some_file.csv')
add_models(database, [sub, job])
json_response = fileHandler.get_upload_file_url(sub, 'A')
url = json.loads(json_response.get_data().decode('utf-8'))['url']
assert url == 'some/url/here.csv'
assert s3_url_handler.return_value.get_signed_url.call_args == ((
'1', 'some_file.csv'), {
'method':
'GET'
})
def test_get_upload_file_url_s3(database, monkeypatch):
""" Test getting the url of the uploaded file non-locally. """
monkeypatch.setattr(fileHandler, 'CONFIG_BROKER', {
'local': False,
'submission_bucket_mapping': 'test/path'
})
s3_url_handler = Mock()
s3_url_handler.return_value.get_signed_url.return_value = 'some/url/here.csv'
monkeypatch.setattr(fileHandler, 'S3Handler', s3_url_handler)
# create and insert submission/job
sub = SubmissionFactory(submission_id=1, d2_submission=False)
job = JobFactory(submission_id=1,
job_status_id=JOB_STATUS_DICT['finished'],
job_type_id=JOB_TYPE_DICT['file_upload'],
file_type_id=FILE_TYPE_DICT['appropriations'],
filename='1/some_file.csv')
add_models(database, [sub, job])
json_response = fileHandler.get_upload_file_url(sub, 'A')
url = json.loads(json_response.get_data().decode('utf-8'))['url']
assert url == 'some/url/here.csv'
assert s3_url_handler.return_value.get_signed_url.call_args == ((
'1', 'some_file.csv'), {
'method':
'get_object',
'url_mapping':
'test/path'
})
def test_get_upload_file_url_no_file(database):
""" Test that a proper error is thrown when an upload job doesn't have a file associated with it
get_upload_file_url.
"""
sub = SubmissionFactory(submission_id=1, d2_submission=False)
job = JobFactory(submission_id=1, job_status_id=JOB_STATUS_DICT['finished'],
job_type_id=JOB_TYPE_DICT['file_upload'], file_type_id=FILE_TYPE_DICT['appropriations'],
filename=None)
add_models(database, [sub, job])
json_response = fileHandler.get_upload_file_url(sub, 'A')
assert json_response.status_code == 400
response = json.loads(json_response.get_data().decode('utf-8'))
assert response['message'] == 'No file uploaded or generated for this type'
def test_get_upload_file_url_local(database, monkeypatch, tmpdir):
""" Test getting the url of the uploaded file locally. """
file_path = str(tmpdir) + os.path.sep
monkeypatch.setattr(fileHandler, 'CONFIG_BROKER', {'local': True, 'broker_files': file_path})
# create and insert submission/job
sub = SubmissionFactory(submission_id=1, d2_submission=False)
job = JobFactory(submission_id=1, job_status_id=JOB_STATUS_DICT['finished'],
job_type_id=JOB_TYPE_DICT['file_upload'], file_type_id=FILE_TYPE_DICT['appropriations'],
filename='a/path/to/some_file.csv')
add_models(database, [sub, job])
json_response = fileHandler.get_upload_file_url(sub, 'A')
url = json.loads(json_response.get_data().decode('utf-8'))['url']
assert url == os.path.join(file_path, 'some_file.csv')
def test_list_submissions_detached(database, monkeypatch):
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
d2_sub = SubmissionFactory(user_id=1, submission_id=2, d2_submission=True, publish_status_id=1)
add_models(database, [user, sub, d2_sub])
monkeypatch.setattr(fileHandler, 'g', Mock(user=user))
result = list_submissions_result()
fabs_result = list_submissions_result(is_fabs=True)
assert result['total'] == 1
assert result['submissions'][0]['submission_id'] == sub.submission_id
assert fabs_result['total'] == 1
assert fabs_result['submissions'][0]['submission_id'] == d2_sub.submission_id
delete_models(database, [user, sub, d2_sub])
def test_list_submissions_sort_success(database, monkeypatch):
user1 = UserFactory(user_id=1, name='Oliver Queen', website_admin=True)
user2 = UserFactory(user_id=2, name='Barry Allen')
sub1 = SubmissionFactory(user_id=1, submission_id=1, number_of_warnings=1, reporting_start_date=date(2010, 1, 1),
publish_status_id=1)
sub2 = SubmissionFactory(user_id=1, submission_id=2, number_of_warnings=1, reporting_start_date=date(2010, 1, 2),
publish_status_id=1)
sub3 = SubmissionFactory(user_id=2, submission_id=3, number_of_warnings=1, reporting_start_date=date(2010, 1, 3),
publish_status_id=1)
sub4 = SubmissionFactory(user_id=2, submission_id=4, number_of_warnings=1, reporting_start_date=date(2010, 1, 4),
publish_status_id=1)
sub5 = SubmissionFactory(user_id=2, submission_id=5, number_of_warnings=1, reporting_start_date=date(2010, 1, 5),
publish_status_id=1)
add_models(database, [user1, user2, sub1, sub2, sub3, sub4, sub5])
monkeypatch.setattr(fileHandler, 'g', Mock(user=user1))
result = list_submissions_sort('reporting', 'desc')
assert result['total'] == 5
sub = result['submissions'][0]
index = 0
for subit in result['submissions']:
index += 1
assert subit['reporting_start_date'] <= sub['reporting_start_date']
sub = subit
result = list_submissions_sort('reporting', 'asc')
assert result['total'] == 5
sub = result['submissions'][0]
for subit in result['submissions']:
assert subit['reporting_start_date'] >= sub['reporting_start_date']
sub = subit
result = list_submissions_sort('submitted_by', 'asc')
assert result['total'] == 5
sub = result['submissions'][0]
for subit in result['submissions']:
assert subit['user']['name'] >= sub['user']['name']
sub = subit
result = list_submissions_sort('submitted_by', 'desc')
assert result['total'] == 5
sub = result['submissions'][0]
for subit in result['submissions']:
assert subit['user']['name'] <= sub['user']['name']
sub = subit
delete_models(database, [user1, user2, sub1, sub2, sub3, sub4, sub5])
def test_get_upload_file_url_no_file(database):
""" Test that a proper error is thrown when an upload job doesn't have a file associated with it
get_upload_file_url.
"""
sess = database.session
sub = SubmissionFactory(submission_id=1, d2_submission=False)
job = JobFactory(
submission_id=1,
job_status=sess.query(JobStatus).filter_by(name='finished').one(),
job_type=sess.query(JobType).filter_by(name='file_upload').one(),
file_type=sess.query(FileType).filter_by(name='appropriations').one(),
filename=None)
add_models(database, [sub, job])
json_response = fileHandler.get_upload_file_url(sub, 'A')
assert json_response.status_code == 400
response = json.loads(json_response.get_data().decode('utf-8'))
assert response['message'] == 'No file uploaded or generated for this type'
def test_get_upload_file_url_invalid_for_type(database):
""" Test that a proper error is thrown when a file type that doesn't match the submission is provided to
get_upload_file_url.
"""
sub_1 = SubmissionFactory(submission_id=1, d2_submission=False)
sub_2 = SubmissionFactory(submission_id=2, d2_submission=True)
add_models(database, [sub_1, sub_2])
json_response = fileHandler.get_upload_file_url(sub_2, 'A')
# check invalid type for FABS
assert json_response.status_code == 400
response = json.loads(json_response.get_data().decode('utf-8'))
assert response['message'] == 'Invalid file type for this submission'
# check invalid type for DABS
json_response = fileHandler.get_upload_file_url(sub_1, 'FABS')
assert json_response.status_code == 400
response = json.loads(json_response.get_data().decode('utf-8'))
assert response['message'] == 'Invalid file type for this submission'
def test_get_upload_file_url_invalid_for_type(database):
""" Test that a proper error is thrown when a file type that doesn't match the submission is provided to
get_upload_file_url.
"""
sub_1 = SubmissionFactory(submission_id=1, d2_submission=False)
sub_2 = SubmissionFactory(submission_id=2, d2_submission=True)
add_models(database, [sub_1, sub_2])
json_response = fileHandler.get_upload_file_url(sub_2, 'A')
# check invalid type for FABS
assert json_response.status_code == 400
response = json.loads(json_response.get_data().decode('utf-8'))
assert response['message'] == 'Invalid file type for this submission'
# check invalid type for DABS
json_response = fileHandler.get_upload_file_url(sub_1, 'FABS')
assert json_response.status_code == 400
response = json.loads(json_response.get_data().decode('utf-8'))
assert response['message'] == 'Invalid file type for this submission'
def test_get_upload_file_url_s3(database, monkeypatch):
""" Test getting the url of the uploaded file non-locally. """
monkeypatch.setattr(fileHandler, 'CONFIG_BROKER', {'local': False, 'submission_bucket_mapping': 'test/path'})
s3_url_handler = Mock()
s3_url_handler.return_value.get_signed_url.return_value = 'some/url/here.csv'
monkeypatch.setattr(fileHandler, 'S3Handler', s3_url_handler)
# create and insert submission/job
sub = SubmissionFactory(submission_id=1, d2_submission=False)
job = JobFactory(submission_id=1, job_status_id=JOB_STATUS_DICT['finished'],
job_type_id=JOB_TYPE_DICT['file_upload'], file_type_id=FILE_TYPE_DICT['appropriations'],
filename='1/some_file.csv')
add_models(database, [sub, job])
json_response = fileHandler.get_upload_file_url(sub, 'A')
url = json.loads(json_response.get_data().decode('utf-8'))['url']
assert url == 'some/url/here.csv'
assert s3_url_handler.return_value.get_signed_url.call_args == (
('1', 'some_file.csv'),
{'method': 'get_object', 'url_mapping': 'test/path'}
)
def test_list_submissions_failure(database, monkeypatch):
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, number_of_errors=1, publish_status_id=1)
add_models(database, [user, sub])
monkeypatch.setattr(fileHandler, 'g', Mock(user=user))
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "validation_errors"
delete_models(database, [user, sub])
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(submission_id=1, job_status_id=JOB_STATUS_DICT['failed'],
job_type_id=JOB_TYPE_DICT['csv_record_validation'], file_type_id=FILE_TYPE_DICT['award'])
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "failed"
delete_models(database, [user, sub, job])
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(submission_id=1, job_status_id=JOB_STATUS_DICT['invalid'],
job_type_id=JOB_TYPE_DICT['csv_record_validation'], file_type_id=FILE_TYPE_DICT['award'])
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "file_errors"
delete_models(database, [user, sub, job])
def test_list_submissions_failure(database, job_constants, monkeypatch):
fh = fileHandler.FileHandler(Mock())
mock_value = Mock()
mock_value.getName.return_value = 1
monkeypatch.setattr(fileHandler, 'LoginSession', mock_value)
user = UserFactory(user_id=1, cgac_code='cgac')
sub = SubmissionFactory(user_id=1,
submission_id=1,
number_of_errors=1,
cgac_code='cgac')
add_models(database, [user, sub])
json_response = fh.list_submissions(PAGE, LIMIT, CERTIFIED)
assert json.loads(json_response.get_data().decode("utf-8"))['total'] == 1
assert json.loads(json_response.get_data().decode(
"utf-8"))['submissions'][0]['status'] == "validation_errors"
delete_models(database, [user, sub])
sess = database.session
user = UserFactory(user_id=1, cgac_code='cgac')
sub = SubmissionFactory(user_id=1, submission_id=1, cgac_code='cgac')
job = JobFactory(
submission_id=1,
job_status=sess.query(JobStatus).filter_by(name='failed').one(),
job_type=sess.query(JobType).filter_by(
name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
json_response = fh.list_submissions(PAGE, LIMIT, CERTIFIED)
assert json.loads(json_response.get_data().decode("utf-8"))['total'] == 1
assert json.loads(json_response.get_data().decode(
"utf-8"))['submissions'][0]['status'] == "failed"
delete_models(database, [user, sub, job])
sess = database.session
user = UserFactory(user_id=1, cgac_code='cgac')
sub = SubmissionFactory(user_id=1, submission_id=1, cgac_code='cgac')
job = JobFactory(
submission_id=1,
job_status=sess.query(JobStatus).filter_by(name='invalid').one(),
job_type=sess.query(JobType).filter_by(
name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
json_response = fh.list_submissions(PAGE, LIMIT, CERTIFIED)
assert json.loads(json_response.get_data().decode("utf-8"))['total'] == 1
assert json.loads(json_response.get_data().decode(
"utf-8"))['submissions'][0]['status'] == "file_errors"
delete_models(database, [user, sub, job])
def test_list_submissions_failure(database, monkeypatch):
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1,
submission_id=1,
number_of_errors=1,
publish_status_id=1)
add_models(database, [user, sub])
monkeypatch.setattr(fileHandler, 'g', Mock(user=user))
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "validation_errors"
delete_models(database, [user, sub])
sess = database.session
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(
submission_id=1,
job_status=sess.query(JobStatus).filter_by(name='failed').one(),
job_type=sess.query(JobType).filter_by(
name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "failed"
delete_models(database, [user, sub, job])
sess = database.session
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(
submission_id=1,
job_status=sess.query(JobStatus).filter_by(name='invalid').one(),
job_type=sess.query(JobType).filter_by(
name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "file_errors"
delete_models(database, [user, sub, job])
def test_list_submissions_failure(database, job_constants, monkeypatch):
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, number_of_errors=1, publish_status_id=1)
add_models(database, [user, sub])
monkeypatch.setattr(fileHandler, 'g', Mock(user=user))
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "validation_errors"
delete_models(database, [user, sub])
sess = database.session
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(submission_id=1, job_status=sess.query(JobStatus).filter_by(name='failed').one(),
job_type=sess.query(JobType).filter_by(name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "failed"
delete_models(database, [user, sub, job])
sess = database.session
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(submission_id=1, job_status=sess.query(JobStatus).filter_by(name='invalid').one(),
job_type=sess.query(JobType).filter_by(name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "file_errors"
delete_models(database, [user, sub, job])
def test_list_submissions_success(database, monkeypatch):
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1,
submission_id=1,
number_of_warnings=1,
publish_status_id=1)
add_models(database, [user, sub])
monkeypatch.setattr(fileHandler, 'g', Mock(user=user))
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0][
'status'] == "validation_successful_warnings"
delete_models(database, [user, sub])
sess = database.session
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(
submission_id=1,
job_status=sess.query(JobStatus).filter_by(name='finished').one(),
job_type=sess.query(JobType).filter_by(
name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "validation_successful"
delete_models(database, [user, sub, job])
sess = database.session
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(
submission_id=1,
job_status=sess.query(JobStatus).filter_by(name='running').one(),
job_type=sess.query(JobType).filter_by(
name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "running"
delete_models(database, [user, sub, job])
sess = database.session
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(
submission_id=1,
job_status=sess.query(JobStatus).filter_by(name='waiting').one(),
job_type=sess.query(JobType).filter_by(
name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "waiting"
delete_models(database, [user, sub, job])
sess = database.session
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(
submission_id=1,
job_status=sess.query(JobStatus).filter_by(name='ready').one(),
job_type=sess.query(JobType).filter_by(
name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "ready"
delete_models(database, [user, sub, job])
sess = database.session
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1,
submission_id=1,
publish_status_id=1,
d2_submission=True)
job = JobFactory(
submission_id=1,
job_status=sess.query(JobStatus).filter_by(name='ready').one(),
job_type=sess.query(JobType).filter_by(
name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
result = list_submissions_result(d2_submission=True)
assert result['total'] == 1
assert result['submissions'][0]['status'] == "ready"
delete_models(database, [user, sub, job])
def test_list_submissions_success(database, monkeypatch):
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, number_of_warnings=1, publish_status_id=1)
add_models(database, [user, sub])
monkeypatch.setattr(fileHandler, 'g', Mock(user=user))
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "validation_successful_warnings"
delete_models(database, [user, sub])
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(submission_id=1, job_status_id=JOB_STATUS_DICT['finished'],
job_type_id=JOB_TYPE_DICT['csv_record_validation'], file_type_id=FILE_TYPE_DICT['award'])
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "validation_successful"
delete_models(database, [user, sub, job])
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(submission_id=1, job_status_id=JOB_STATUS_DICT['running'],
job_type_id=JOB_TYPE_DICT['csv_record_validation'], file_type_id=FILE_TYPE_DICT['award'])
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "running"
delete_models(database, [user, sub, job])
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(submission_id=1, job_status_id=JOB_STATUS_DICT['waiting'],
job_type_id=JOB_TYPE_DICT['csv_record_validation'], file_type_id=FILE_TYPE_DICT['award'])
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "waiting"
delete_models(database, [user, sub, job])
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(submission_id=1, job_status_id=JOB_STATUS_DICT['ready'],
job_type_id=JOB_TYPE_DICT['csv_record_validation'], file_type_id=FILE_TYPE_DICT['award'])
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "ready"
delete_models(database, [user, sub, job])
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1, d2_submission=True)
job = JobFactory(submission_id=1, job_status_id=JOB_STATUS_DICT['ready'],
job_type_id=JOB_TYPE_DICT['csv_record_validation'], file_type_id=FILE_TYPE_DICT['award'])
add_models(database, [user, sub, job])
result = list_submissions_result(is_fabs=True)
assert result['total'] == 1
assert result['submissions'][0]['status'] == "ready"
delete_models(database, [user, sub, job])
def test_list_submissions_success(database, job_constants, monkeypatch):
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, number_of_warnings=1, publish_status_id=1)
add_models(database, [user, sub])
monkeypatch.setattr(fileHandler, 'g', Mock(user=user))
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "validation_successful_warnings"
delete_models(database, [user, sub])
sess = database.session
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(submission_id=1, job_status=sess.query(JobStatus).filter_by(name='finished').one(),
job_type=sess.query(JobType).filter_by(name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "validation_successful"
delete_models(database, [user, sub, job])
sess = database.session
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(submission_id=1, job_status=sess.query(JobStatus).filter_by(name='running').one(),
job_type=sess.query(JobType).filter_by(name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "running"
delete_models(database, [user, sub, job])
sess = database.session
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(submission_id=1, job_status=sess.query(JobStatus).filter_by(name='waiting').one(),
job_type=sess.query(JobType).filter_by(name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "waiting"
delete_models(database, [user, sub, job])
sess = database.session
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1)
job = JobFactory(submission_id=1, job_status=sess.query(JobStatus).filter_by(name='ready').one(),
job_type=sess.query(JobType).filter_by(name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
result = list_submissions_result()
assert result['total'] == 1
assert result['submissions'][0]['status'] == "ready"
delete_models(database, [user, sub, job])
sess = database.session
user = UserFactory(user_id=1)
sub = SubmissionFactory(user_id=1, submission_id=1, publish_status_id=1, d2_submission=True)
job = JobFactory(submission_id=1, job_status=sess.query(JobStatus).filter_by(name='ready').one(),
job_type=sess.query(JobType).filter_by(name='csv_record_validation').one(),
file_type=sess.query(FileType).filter_by(name='award').one())
add_models(database, [user, sub, job])
result = list_submissions_result(d2_submission=True)
assert result['total'] == 1
assert result['submissions'][0]['status'] == "ready"
delete_models(database, [user, sub, job])
