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')