def updating_setting(update_dict, owner_id):
df = dl.reading_file('users.csv')
for key in update_dict.keys():
df.loc[df['id'] == int(owner_id), key] = update_dict[key]
dl.writing_file(df, 'users.csv')
def editing_task(task_id, owner_id):
df = dl.reading_file('tasks.csv')
df = df[(df.status == 'active') | (df.owner_id != int(owner_id))]
row = df[df.id == int(task_id)]
row['status'] = 'inactive'
df = df.append(row, ignore_index=True)
dl.writing_file(df, 'tasks.csv')
def updating_inactive_task(update_dict, owner_id):
df = dl.reading_file('tasks.csv')
#id name time_cost time repeat start weekend Why Periority
new_task = df[(df.status == 'inactive')
& (df.owner_id == int(owner_id))].iloc[0]
if 'status' in update_dict.keys() and update_dict['status'] == 'active':
df = df[df.id != new_task.id]
else:
df = df[(df.status != 'inactive') | (df.owner_id != int(owner_id))]
for c in update_dict.keys():
new_task[c] = update_dict[c]
df = df.append(new_task, ignore_index=True)
dl.writing_file(df, 'tasks.csv')
return new_task.id
def change_status(val, text, owner_id):
if text.isnumeric():
df = dl.reading_file('have_done.csv')
df = df.append(
{
'task_id': int(text),
'date': get_today(owner_id=owner_id),
'type': val,
'owner_id': owner_id,
'time': time_to_num(get_time(owner_id=owner_id))
},
ignore_index=True)
dl.writing_file(df, 'have_done.csv')
result = 'Done'
else:
result = 'input is not a number'
return result
def adding_task(text, group_id, owner_id):
df = dl.reading_file('tasks.csv')
#id name time_cost time repeat start weekend Why Periority
new_id = 1 if len(df) == 0 else df.id.max() + 1
df = df[(df.status == 'active') | (df.owner_id != int(owner_id))]
df = df.append(
{
'id': new_id,
'name': text,
'repeat': 'Once',
'start_date': get_today(owner_id=owner_id),
'duration': 'Free time',
'Periority': 1,
'group_id': group_id,
'status': 'inactive',
'owner_id': owner_id,
},
ignore_index=True)
dl.writing_file(df, 'tasks.csv')
return new_id
def add_user_if_not_exist(owner_id, name):
df_user = dl.reading_file('users.csv')
if int(owner_id) not in df_user.id.to_list():
new_user_row = {'id': owner_id, 'name': name, 'local_time_diff': '-4'}
df_user = df_user.append(new_user_row, ignore_index=True)
dl.writing_file(df_user, 'users.csv')
df_usergroup = dl.reading_file('user_group.csv')
new_row = {
'group_id': 'P_' + owner_id,
'user_id': owner_id,
'branch_name': 'Personal'
}
df_usergroup = df_usergroup.append(new_row, ignore_index=True)
dl.writing_file(df_usergroup, 'user_group.csv')
df_times = dl.reading_file('times.csv')
max_id = df_times.id.max() if len(df_times) > 0 else 0
new_row = [{
'id': max_id + 1,
'title': 'All time',
'start time': 7,
'end time': 23,
'days': "0,1,2,3,4,5,6",
'owner_id': owner_id
}, {
'id': max_id + 2,
'title': 'Free time',
'start time': 7,
'end time': 23,
'days': "5,6",
'owner_id': owner_id
}, {
'id': max_id + 3,
'title': 'Free time',
'start time': 17,
'end time': 23,
'days': "0,1,2,3,4",
'owner_id': owner_id
}, {
'id': max_id + 3,
'title': 'Free time',
'start time': 7,
'end time': 7,
'days': "0,1,2,3,4",
'owner_id': owner_id
}, {
'id': max_id + 4,
'title': 'Weekend',
'start time': 7,
'end time': 23,
'days': "5,6",
'owner_id': owner_id
}]
df_times = df_times.append(new_row, ignore_index=True)
dl.writing_file(df_times, 'times.csv')
my_logging(
'info',
' __Business__ add_user_if_not_exist __> result: this rows has been added:'
+ str(new_row) + '|\n and this row: ' + str(new_user_row))