本文整理汇总了Python中tests.unit.dataactvalidator.utils.query_columns函数的典型用法代码示例。如果您正苦于以下问题:Python query_columns函数的具体用法?Python query_columns怎么用?Python query_columns使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了query_columns函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: test_column_headers
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))
示例2: test_column_headers
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
开发者ID:fedspendingtransparency,项目名称:data-act-broker-backend,代码行数:7,代码来源:test_b19_object_class_program_activity.py
示例3: test_column_headers
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
示例4: test_column_headers
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
示例5: test_column_headers
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
示例6: test_column_headers
def test_column_headers(database):
expected_subset = {"row_number", "action_type", "record_type"}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
开发者ID:fedspendingtransparency,项目名称:data-act-broker-backend,代码行数:4,代码来源:test_fabs3_detached_award_financial_assistance_1.py
示例7: test_column_headers
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
开发者ID:fedspendingtransparency,项目名称:data-act-broker-backend,代码行数:6,代码来源:test_b13_object_class_program_activity.py
示例8: test_column_headers
def test_column_headers(database):
expected_subset = {"row_number", "awarding_office_code"}
actual = set(query_columns(_FILE, database))
assert expected_subset == actual
开发者ID:fedspendingtransparency,项目名称:data-act-broker-backend,代码行数:4,代码来源:test_fabs38_detached_award_financial_assistance_4_1.py
示例9: test_column_headers
def test_column_headers(database):
expected_subset = {'row_number', 'object_class'}
actual = set(query_columns(_FILE, database))
assert (actual & expected_subset) == expected_subset
开发者ID:fedspendingtransparency,项目名称:data-act-broker-backend,代码行数:4,代码来源:test_b11_object_class_program_activity_1.py
示例10: test_column_headers
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
示例11: test_column_headers
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
示例12: test_column_headers
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
示例13: test_column_headers
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
开发者ID:fedspendingtransparency,项目名称:data-act-broker-backend,代码行数:5,代码来源:test_fabs31_detached_award_financial_assistance_4.py
示例14: test_column_headers
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
开发者ID:tony-sappe,项目名称:data-act-broker-backend,代码行数:4,代码来源:test_fabs37_detached_award_financial_assistance_2.py
示例15: test_column_headers
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
开发者ID:fedspendingtransparency,项目名称:data-act-broker-backend,代码行数:4,代码来源:test_fabs15_detached_award_financial_assistance_2.py