def test_column_headers(database):
expected_subset = {
"row_number", "assistance_type", "action_date",
"awardee_or_recipient_uniqu", "business_types", "record_type"
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {
'row_number', 'record_type', 'business_types', 'uei',
'uniqueid_AssistanceTransactionUniqueKey'
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {
"row_number", "period_of_performance_star",
"period_of_performance_curr"
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {
'row_number', 'record_type', 'legal_entity_zip_last4',
'uniqueid_AssistanceTransactionUniqueKey'
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {'row_number', 'beginning_period_of_availa', 'ending_period_of_availabil',
'agency_identifier', 'allocation_transfer_agency', 'availability_type_code',
'main_account_code', 'sub_account_code', 'object_class', 'program_activity_code',
'by_direct_reimbursable_fun'}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {
'row_number', 'place_of_performance_code',
'uniqueid_AssistanceTransactionUniqueKey'
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected = {
'row_number', 'allocation_transfer_agency', 'agency_identifier',
'beginning_period_of_availa', 'ending_period_of_availabil',
'availability_type_code', 'main_account_code', 'sub_account_code',
}
assert expected == set(query_columns(_FILE, database))
def test_column_headers(database):
expected_subset = {
'row_number', "obligations_undelivered_or_fyb",
"ussgl480100_undelivered_or_fyb"
}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {
'row_number', 'awarding_office_code', 'action_type',
'correction_delete_indicatr', 'action_date',
'uniqueid_AssistanceTransactionUniqueKey'
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {
'row_number', 'fain', 'award_modification_amendme', 'uri',
'awarding_sub_tier_agency_c', 'cfda_number',
'uniqueid_AssistanceTransactionUniqueKey'
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {
"row_number", "allocation_transfer_agency", "agency_identifier",
"beginning_period_of_availa", "ending_period_of_availabil",
"availability_type_code", "main_account_code", "sub_account_code"
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {
'source_row_number', 'source_value_gross_outlay_amount_by_tas_cpe',
'target_value_gross_outlay_amount_by_pro_cpe_sum', 'difference',
'uniqueid_TAS'
}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {'row_number', 'gross_outlays_delivered_or_cpe', 'ussgl490200_delivered_orde_cpe',
'ussgl490800_authority_outl_cpe', 'ussgl498200_upward_adjustm_cpe', 'difference',
'uniqueid_TAS', 'uniqueid_DisasterEmergencyFundCode', 'uniqueid_ProgramActivityCode',
'uniqueid_ProgramActivityName', 'uniqueid_ObjectClass',
'uniqueid_ByDirectReimbursableFundingSource'}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {
"row_number", "place_of_performance_zip4a",
"place_of_performance_congr", "place_of_perform_country_c",
"record_type"
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {
"row_number", "other_budgetary_resources_cpe",
"contract_authority_amount_cpe", "borrowing_authority_amount_cpe",
"spending_authority_from_of_cpe"
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {
'row_number', 'disaster_emergency_fund_code',
'transaction_obligated_amou', 'gross_outlay_amount_by_awa_cpe',
'uniqueid_TAS', 'uniqueid_DisasterEmergencyFundCode'
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {
'uniqueid_TAS', 'row_number', 'other_budgetary_resources_cpe',
'contract_authority_amount_cpe', 'borrowing_authority_amount_cpe',
'spending_authority_from_of_cpe', 'difference'
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {
'row_number', 'fain', 'uri', 'awarding_sub_tier_agency_c',
'action_type', 'record_type', 'correction_delete_indicatr',
'uniqueid_AssistanceTransactionUniqueKey'
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {
'row_number', 'allocation_transfer_agency', 'agency_identifier', 'beginning_period_of_availa',
'ending_period_of_availabil', 'availability_type_code', 'main_account_code', 'sub_account_code',
'gross_outlay_amount_by_tas_cpe', 'gross_outlay_amount_by_pro_cpe_sum'
}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {
'uniqueid_TAS', 'row_number', 'adjustments_to_unobligated_cpe',
'expected_value_SUM of GTAS SF133 Lines 1010 through 1042',
'difference'
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {
'row_number', 'deobligations_recov_by_pro_cpe',
'ussgl487100_downward_adjus_cpe', 'ussgl487200_downward_adjus_cpe',
'ussgl497100_downward_adjus_cpe', 'ussgl497200_downward_adjus_cpe'
}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {
'source_row_number', 'source_value_fain', 'source_value_uri',
'source_value_transaction_obligated_amount', 'difference',
'uniqueid_TAS', 'uniqueid_FAIN', 'uniqueid_URI'
}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {
'row_number', 'assistance_type', 'action_date', 'action_type',
'awardee_or_recipient_uniqu', 'business_types', 'record_type',
'correction_delete_indicatr', 'uniqueid_AssistanceTransactionUniqueKey'
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {
'row_number', 'gross_outlays_undelivered_fyb',
'ussgl480200_undelivered_or_fyb', 'difference', 'uniqueid_TAS',
'uniqueid_ProgramActivityCode', 'uniqueid_ObjectClass'
}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {
'row_number', 'gross_outlays_undelivered_fyb',
'ussgl480200_undelivered_or_fyb', 'difference', 'uniqueid_TAS',
'uniqueid_PIID', 'uniqueid_FAIN', 'uniqueid_URI'
}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {'row_number', 'obligations_undelivered_or_cpe', 'ussgl480100_undelivered_or_cpe',
'ussgl483100_undelivered_or_cpe', 'ussgl488100_upward_adjustm_cpe', 'difference', 'uniqueid_TAS',
'uniqueid_DisasterEmergencyFundCode', 'uniqueid_ProgramActivityCode',
'uniqueid_ProgramActivityName', 'uniqueid_ObjectClass',
'uniqueid_ByDirectReimbursableFundingSource'}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {
"row_number", "total_budgetary_resources_cpe",
"budget_authority_appropria_cpe", "budget_authority_unobligat_fyb",
"adjustments_to_unobligated_cpe", "other_budgetary_resources_cpe"
}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {
'source_row_number', 'source_value_piid',
'source_value_parent_award_id', 'uniqueid_PIID',
'uniqueid_ParentAwardId'
}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {
'row_number', 'transaction_obligated_amou', 'uniqueid_TAS',
'uniqueid_PIID', 'uniqueid_FAIN', 'uniqueid_URI',
'uniqueid_DisasterEmergencyFundCode'
}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {
'row_number', 'obligations_delivered_orde_fyb',
'ussgl490100_delivered_orde_fyb', 'difference', 'uniqueid_TAS',
'uniqueid_ProgramActivityCode', 'uniqueid_ObjectClass'
}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {
'row_number', "gross_outlays_delivered_or_cpe",
"ussgl490200_delivered_orde_cpe", "ussgl490800_authority_outl_cpe",
"ussgl498200_upward_adjustm_cpe"
}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {
'source_row_number', 'source_value_obligations_incurred_total_cpe',
'target_value_obligations_incurred_by_pr_cpe_sum', 'difference',
'uniqueid_TAS'
}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {
'row_number', 'beginning_period_of_availa', 'agency_identifier',
'allocation_transfer_agency', 'main_account_code',
'program_activity_name', 'program_activity_code'
}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database, sql_file):
expected_subset = {
"row_number", "allocation_transfer_agency", "agency_identifier",
"beginning_period_of_availa", "ending_period_of_availabil",
"availability_type_code", "main_account_code", "sub_account_code"
}
actual = set(query_columns(sql_file, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {'row_number', 'tas', 'program_activity_code', 'ussgl480100_undelivered_or_fyb_sum_c',
'ussgl480100_undelivered_or_cpe_sum_c', 'ussgl483100_undelivered_or_cpe_sum_c',
'ussgl488100_upward_adjustm_cpe_sum_c', 'obligations_undelivered_or_fyb_sum_c',
'obligations_undelivered_or_cpe_sum_c', 'ussgl490100_delivered_orde_fyb_sum_c',
'ussgl490100_delivered_orde_cpe_sum_c', 'ussgl493100_delivered_orde_cpe_sum_c',
'ussgl498100_upward_adjustm_cpe_sum_c', 'obligations_delivered_orde_fyb_sum_c',
'obligations_delivered_orde_cpe_sum_c', 'ussgl480200_undelivered_or_fyb_sum_c',
'ussgl480200_undelivered_or_cpe_sum_c', 'ussgl483200_undelivered_or_cpe_sum_c',
'ussgl488200_upward_adjustm_cpe_sum_c', 'gross_outlays_undelivered_fyb_sum_c',
'gross_outlays_undelivered_cpe_sum_c', 'ussgl490200_delivered_orde_cpe_sum_c',
'ussgl490800_authority_outl_fyb_sum_c', 'ussgl490800_authority_outl_cpe_sum_c',
'ussgl498200_upward_adjustm_cpe_sum_c', 'gross_outlays_delivered_or_fyb_sum_c',
'gross_outlays_delivered_or_cpe_sum_c', 'gross_outlay_amount_by_awa_fyb_sum_c',
'gross_outlay_amount_by_awa_cpe_sum_c', 'obligations_incurred_byawa_cpe_sum_c',
'ussgl487100_downward_adjus_cpe_sum_c', 'ussgl497100_downward_adjus_cpe_sum_c',
'ussgl487200_downward_adjus_cpe_sum_c', 'ussgl497200_downward_adjus_cpe_sum_c',
'deobligations_recov_by_awa_cpe_sum_c', 'ussgl480100_undelivered_or_fyb_sum_b',
'ussgl480100_undelivered_or_cpe_sum_b', 'ussgl483100_undelivered_or_cpe_sum_b',
'ussgl488100_upward_adjustm_cpe_sum_b', 'obligations_undelivered_or_fyb_sum_b',
'obligations_undelivered_or_cpe_sum_b', 'ussgl490100_delivered_orde_fyb_sum_b',
'ussgl490100_delivered_orde_cpe_sum_b', 'ussgl493100_delivered_orde_cpe_sum_b',
'ussgl498100_upward_adjustm_cpe_sum_b', 'obligations_delivered_orde_fyb_sum_b',
'obligations_delivered_orde_cpe_sum_b', 'ussgl480200_undelivered_or_fyb_sum_b',
'ussgl480200_undelivered_or_cpe_sum_b', 'ussgl483200_undelivered_or_cpe_sum_b',
'ussgl488200_upward_adjustm_cpe_sum_b', 'gross_outlays_undelivered_fyb_sum_b',
'gross_outlays_undelivered_cpe_sum_b', 'ussgl490200_delivered_orde_cpe_sum_b',
'ussgl490800_authority_outl_fyb_sum_b', 'ussgl490800_authority_outl_cpe_sum_b',
'ussgl498200_upward_adjustm_cpe_sum_b', 'gross_outlays_delivered_or_fyb_sum_b',
'gross_outlays_delivered_or_cpe_sum_b', 'gross_outlay_amount_by_pro_fyb_sum_b',
'gross_outlay_amount_by_pro_cpe_sum_b', 'obligations_incurred_by_pr_cpe_sum_b',
'ussgl487100_downward_adjus_cpe_sum_b', 'ussgl497100_downward_adjus_cpe_sum_b',
'ussgl487200_downward_adjus_cpe_sum_b', 'ussgl497200_downward_adjus_cpe_sum_b',
'deobligations_recov_by_pro_cpe_sum_b'}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {'row_number', 'piid', 'parent_award_id'}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {"row_number", "legal_entity_country_code", "legal_entity_foreign_city", "record_type"}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {"row_number", "action_type", "record_type"}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {'row_number', 'deobligations_recov_by_pro_cpe', 'ussgl487100_downward_adjus_cpe',
'ussgl487200_downward_adjus_cpe', 'ussgl497100_downward_adjus_cpe',
'ussgl497200_downward_adjus_cpe'}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {"row_number", "awarding_office_code"}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {'row_number', 'gross_outlays_undelivered_cpe', 'ussgl480200_undelivered_or_cpe',
'ussgl488200_upward_adjustm_cpe'}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {"row_number", "gross_outlays_delivered_or_cpe", "ussgl490200_delivered_orde_cpe",
"ussgl490800_authority_outl_cpe", "ussgl498200_upward_adjustm_cpe"}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {"row_number", "assistance_type", "federal_action_obligation"}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {"row_number", "status_of_budgetary_resour_cpe", "obligations_incurred_total_cpe",
"unobligated_balance_cpe"}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {"row_number", "place_of_performance_code", "place_of_performance_zip4a"}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {'row_number', "fain", "uri", "piid"}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {'row_number', 'agency_identifier', 'main_account_code',
'program_activity_name', 'program_activity_code'}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {"row_number", "assistance_type", "action_date", "awardee_or_recipient_uniqu",
"business_types", "record_type"}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {"row_number", "transaction_obligated_amou_sum", "federal_action_obligation_sum",
"original_loan_subsidy_cost_sum"}
actual = set(query_columns(_FILE, database))
assert expected_subset <= actual
def test_column_headers(database):
expected_subset = {'row_number', 'obligations_undelivered_or_fyb', 'ussgl480100_undelivered_or_fyb'}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {"row_number", "legal_entity_zip5", "legal_entity_zip_last4"}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {'row_number', 'obligations_delivered_orde_cpe', 'ussgl490100_delivered_orde_cpe',
'ussgl498100_upward_adjustm_cpe'}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {'row_number', 'budget_authority_unobligat_fyb', 'sf_133_amount'}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {'row_number', 'object_class'}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
def test_column_headers(database):
expected_subset = {'row_number', 'funding_sub_tier_agency_co', 'funding_office_code'}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {"row_number", "assistance_type", "original_loan_subsidy_cost"}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {"row_number", "record_type", "awardee_or_recipient_legal"}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {"row_number", "cfda_number", "action_date", "action_type", "correction_late_delete_ind"}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {"row_number", "legal_entity_congressional", "record_type"}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
def test_column_headers(database):
expected_subset = {"row_number", "gross_outlay_amount_by_awa_fyb", "gross_outlays_undelivered_fyb",
"gross_outlays_delivered_or_fyb"}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
