当前位置: 首页>>代码示例>>Python>>正文


Python utils.query_columns函数代码示例

本文整理汇总了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))
开发者ID:tony-sappe,项目名称:data-act-broker-backend,代码行数:7,代码来源:test_a33_appropriations_1.py

示例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
开发者ID:fedspendingtransparency,项目名称:data-act-broker-backend,代码行数:8,代码来源:test_a18_cross_file.py

示例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
开发者ID:fedspendingtransparency,项目名称:data-act-broker-backend,代码行数:9,代码来源:test_a1_rules.py

示例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
开发者ID:fedspendingtransparency,项目名称:data-act-broker-backend,代码行数:36,代码来源:test_c21_award_financial.py

示例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
开发者ID:fedspendingtransparency,项目名称:data-act-broker-backend,代码行数:5,代码来源:test_c4_award_financial_1.py

示例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
开发者ID:tony-sappe,项目名称:data-act-broker-backend,代码行数:4,代码来源:test_c11_cross_file.py

示例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
开发者ID:fedspendingtransparency,项目名称:data-act-broker-backend,代码行数:5,代码来源:test_b9_award_financial.py

示例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


注:本文中的tests.unit.dataactvalidator.utils.query_columns函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。