def edit(cmp_id, title, description, questions):
"""Edit campetition
questions - cortage of cortages
EXAMPLE: (
('Question1','Answer1'),
('Question2','Answer2', 'Answer22')
)
return id or None
"""
cmp_row = db.select('CMPS', "id={}".format(cmp_id))[0]
vals = (title, description, cmp_row[3], cmp_row[4], cmp_row[5])
if db.update('CMPS', cmp_id, vals):
cmp_id_sql = "cmp_id={}".format(cmp_id)
for task in questions:
task_row = db.select('QUESTIONS', cmp_id_sql)[0]
if task_row and len(task_row) and task_row[0]:
db.update_rows('QUESTIONS', [task_row], (task[0], cmp_id))
task_id_sql = 'task_id={}'.format(task_row[0])
db.remove_conditions('ANSWERS', task_id_sql)
for i in range(1, len(task)):
db.insert('ANSWERS', (task[i], task_row[0], cmp_id))
return cmp_id
else:
return None
def logout(headers, cookies):
"""Log out user from his account
headers - dictionary
cookies - dictionary
return True or False
"""
if 'session_id' in cookies:
#try without session_id value
expires_in = 'Thu, 31 Aug 1995 00:00:00 GMT'
cookie = 'session_id={}; expires={}; path=/'
cookie = cookie.format(cookies['session_id'], expires_in)
headers.append(('Set-Cookie', cookie))
sql_str = "session_id='{}'"
sql_str = sql_str.format(cookies['session_id'])
return db.remove_conditions('SESSIONS', sql_str)
return False
