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