def insert_client_needs(column_values, row_values, id_value): ''' Inserts data into the Client_Needs table. Values are all Yes/No ''' index_list = [(11, 29), (30, 32), (33, 34), (41, 47), (48, 68)] table = "Client_Needs" prim = "(Client_Unique_ID_Value, Type)" lst = ["Value"] i = 0 while (i < len(index_list)): start = index_list[i][0] end = index_list[i][1] while (start < end): if (type(row_values[start] == str)): prim_val = "(" + id_value + ", '" + column_values[start] + "')" value = database_methods.get_existing_id( db, table, "Type", prim, prim_val) if (value is not None): (col, data) = database_methods.update_lists( lst, None, row_values, [(start, start + 1)]) query = database_methods.create_update_query( col, data, table, prim, prim_val) database_methods.update_query(query, db) else: insert_general.insert_3_value(column_values, row_values, table, id_value, start, start + 1) start += 1 i += 1 #if __name__ == "__main__": #df = pd.read_excel('file.xlsx') #column_values = df.iloc[1] #row_values = df.iloc[2]
def insert_skills(column_values, row_values, client_id): ''' Inserts rows in Skills table. ''' insert_general.insert_3_value(column_values, row_values, "Skills", client_id, 64, 69) insert_general.insert_3_value(column_values, row_values, "Skills", client_id, 70, 71)
def insert_service_needs(column_values, row_values, service_id): ''' Inserts rows into the Service_Needs table. ''' if (not (database_methods.check_id(service_id, 'client_data.db', "Service_Needs", "Service_ID"))): insert_general.insert_3_value(column_values, row_values, "Service_Needs", service_id, 31, 63) insert_general.insert_3_value(column_values, row_values, "Service_Needs", service_id, 71, 72)
def insert_skills(column_values, row_values, client_id): # client skills insert_general.insert_3_value(column_values, row_values, "Skills", client_id, 30, 36)
def insert_course_schedule(column_values, row_values, course_code): insert_general.insert_3_value(column_values, row_values, "Course_Schedule", course_code, 19, 25)
def insert_skill_levels(column_values, row_values, course_code): insert_general.insert_3_value(column_values, row_values, "Skill_Levels", course_code, 60, 117)