Python Controller.action_insert_data_to_table 예제들

예제 #1

파일: 2_build_wealth_intersection_table.py 프로젝트: 00krishna-tools/pydhs

def main_wealth(database, tablefile):

    c = Controller(database)

    c.action_build_intersection_fields_table('intersection_table', tablefile)
    c.action_get_variables_by_table_csv_file()
    c.action_insert_data_to_table(tablefile, 'intersection_table')
    c.action_add_wealth_id_column_to_intersection_table()
    c.action_add_wealth_v002_column_to_intersection_table()
    c.action_add_wealth_v003_column_to_intersection_table()
    c.action_separate_whhid_to_cluster_and_household_id()
    c.action_rename_intersection_table('intersection_table_wealth')
    print('wealth intersection table built.')

예제 #2

파일: 3_build_birth_intersection_table.py 프로젝트: 00krishna-tools/pydhs

def main_birth(database, tablefile):

    c = Controller(database)

    c.action_build_intersection_fields_table('intersection_table', tablefile)
    c.action_insert_data_to_table(tablefile, 'intersection_table')
    c.action_add_wealth_id_column_to_intersection_table()
    c.action_add_wealth_wlthindf_column_to_intersection_table()
    c.action_add_wealth_wlthind5_column_to_intersection_table()
    c.action_rename_intersection_table('intersection_table_birth')
    c.action_add_columns_for_merge()

    d = Controller_postprocessing(database)
    d.update_b2_dates_to_four_digits()
    d.update_v007_dates_to_four_digits()
    d.update_v190_recode()

    print("birth intersection table built.")