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.')
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.")
def test_create_intersection_table(self): c = Controller('db_antonio_india') c.action_build_intersection_fields_table('intersect_table', 'tablelist2.csv')