Python reset_test_tables示例

示例#1

文件： test_minimums_weight_xml_integration.py 项目： uk-gov-mirror/ONSdigital.ips_services

def teardown_module(module):
    # Delete any previous records from the Survey_Subsample tables for the given run ID
    ctf.reset_test_tables(RUN_ID, STEP_CONFIGURATION[STEP_NAME])

    # Cleanses Survey Subsample table.
    cf.delete_from_table(idm.SURVEY_SUBSAMPLE_TABLE, 'RUN_ID', '=', RUN_ID)

    print("Teardown")

示例#2

文件： test_rail_imputation_integration.py 项目： uk-gov-mirror/ONSdigital.ips_services

def teardown_module(module):
    """ Teardown any state that was previously setup with a setup_module method. """
    # Deletes data from temporary tables as necessary.
    ctf.reset_test_tables(RUN_ID, STEP_CONFIGURATION[STEP_NAME])

    # Cleanses Survey Subsample table.
    cf.delete_from_table(idm.SURVEY_SUBSAMPLE_TABLE, 'RUN_ID', '=', RUN_ID)

    print("Duration: {}".format(time.strftime("%H:%M:%S", time.gmtime(time.time() - START_TIME))))

示例#3

文件： test_final_weight_xml_integration.py 项目： uk-gov-mirror/ONSdigital.ips_services

def setup_module(module):
    """ Setup any state specific to the execution of the given module. """

    # Assign variables
    december_survey_data_path = (TEST_DATA_DIR + r'\surveydata.csv')

    # Deletes data from tables as necessary
    ctf.reset_test_tables(RUN_ID, STEP_CONFIGURATION[STEP_NAME])

    # Import survey data
    ctf.import_survey_data_into_database(december_survey_data_path, RUN_ID)

示例#4

def setup_module(module):
    """ setup any state specific to the execution of the given module."""
    # deletes data from tables as necessary
    ctf.reset_test_tables(RUN_ID, STEP_CONFIGURATION[STEP_NAME])

    # Import survey and external data.
    import_data_dir = r'tests\data\import_data\dec'
    ctf.import_test_data_into_database(import_data_dir, RUN_ID)

    # populates test data within pv table
    conn = database_connection()
    ctf.populate_test_pv_table(conn, RUN_ID, PV_RUN_ID)

示例#5

文件： test_regional_weights_xml_integration.py 项目： uk-gov-mirror/ONSdigital.ips_services

def setup_module(module):
    """ Setup any state specific to the execution of the given module. """

    # Assign variables
    december_survey_data_path = (TEST_DATA_DIR + r'\surveydata.csv')

    # Deletes data from tables as necessary.
    ctf.reset_test_tables(RUN_ID, STEP_CONFIGURATION[STEP_NAME])

    # Import survey data.
    ctf.import_survey_data_into_database(december_survey_data_path, RUN_ID)

    # Populates test data within pv table.
    conn = database_connection()
    ctf.populate_test_pv_table(conn, RUN_ID, PV_RUN_ID)

示例#6

文件： test_minimums_weight_xml_integration.py 项目： uk-gov-mirror/ONSdigital.ips_services

def setup_module(module):
    """ setup any state specific to the execution of the given module."""

    ist = time.time()

    # Deletes data from tables as necessary
    ctf.reset_test_tables(RUN_ID, STEP_CONFIGURATION[STEP_NAME])

    # Import survey data
    survey_data_path = r'tests\data\ips_data_management\import_data\minimums_weight\surveydata.csv'
    ctf.import_survey_data_into_database(survey_data_path, RUN_ID)

    # Import external data
    import_data_dir = r'tests\data\import_data\dec'
    ctf.import_test_data_into_database(import_data_dir, RUN_ID, load_survey_data=False)

    # Populate test data within pv table
    conn = database_connection()
    ctf.populate_test_pv_table(conn, RUN_ID, PV_RUN_ID)

    print("Setup")

示例#7

文件： test_traffic_xml_integration.py 项目： uk-gov-mirror/ONSdigital.ips_services

def teardown_module(module):
    # Delete any previous records from the Survey_Subsample tables for the given run ID
    ctf.reset_test_tables(RUN_ID, STEP_CONFIGURATION[STEP_NAME])

    print("Teardown")