def update_groups(conn): cur_select = conn.cursor() cur_select.execute("SELECT id, mfl_name FROM common_orgunitgroupsmapping") for id, mfl_name in cur_select.fetchall(): mfl_name = "MFL-" + mfl_name print("Processing " + mfl_name + "...") response = get_org_unit_group_ids(mfl_name) cur_update = conn.cursor() cur_update.execute("UPDATE common_orgunitgroupsmapping SET " + "dhis_name = '" + str(response["dhis_name"].replace("'", "''")) + "', " + "dhis_id = '" + str(response["dhis_id"]) + "', " "group_set_ids = '" + str(response["group_set_ids"]).replace("'", "''") + "', " "group_code = '" + str(response["group_code"]) + "' " + "WHERE id = '" + str(id) + "'") conn.commit() print("Updated " + mfl_name + "\n\n_________________________\n\n") cur_update.close() cur_select.close() print("Done.")
def copy_facility_regulating_body(): cur_select = conn.cursor() cur_select.execute("SELECT name, id FROM facilities_regulatingbody") for name, _id in cur_select.fetchall(): cur_insert = conn.cursor() name = str(name).replace("'", "''") cur_insert.execute( "INSERT INTO common_orgunitgroupsmapping (mfl_name, created, updated) " + " VALUES ('" + str(name) + "', '" + str(datetime.datetime.now()) + "', '" + str(datetime.datetime.now()) + "')") print("Inserted Facility Regulating Body - " + str(name)) # print(str(cur_insert), str(cur_select)) conn.commit() cur_insert.close() cur_select.close()
def copy_facility_keph_levels(): cur_select = conn.cursor() cur_select.execute( "SELECT DISTINCT ON (name) name, id FROM facilities_kephlevel") for name, _id in cur_select.fetchall(): cur_insert = conn.cursor() name = str(name).replace("'", "''") cur_insert.execute( "INSERT INTO common_orgunitgroupsmapping (mfl_name, created, updated) " + " VALUES ('" + "KEPH " + str(name) + "', '" + str(datetime.datetime.now()) + "', '" + str(datetime.datetime.now()) + "')") print("Inserted KEPH Level - " + str(name)) # print(str(cur_insert), str(cur_select)) conn.commit() cur_insert.close() cur_select.close()
def copy_facility_type(): cur_select = conn.cursor() cur_select.execute( "SELECT DISTINCT ON (sub_division) sub_division, id FROM facilities_facilitytype WHERE sub_division IS NOT NULL" ) for sub_division, _id in cur_select.fetchall(): cur_insert = conn.cursor() sub_division = str(sub_division).replace("'", "''") cur_insert.execute( "INSERT INTO common_orgunitgroupsmapping (mfl_name, created, updated) " + " VALUES ('" + str(sub_division) + "', '" + str(datetime.datetime.now()) + "', '" + str(datetime.datetime.now()) + "')") print("Inserted Facility Type - " + str(sub_division)) # print(str(cur_insert), str(cur_select)) conn.commit() cur_insert.close() cur_select.close()