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)