def change(filename, username, auth, myname):
if auth == -1:
for user in Users.all_users():
if user[0] != myname:
change(filename, user[0], 1, myname)
return
if auth == -2:
for user in Users.all_users():
if user[0] != myname:
change(filename, user[0], 0, myname)
return
conn = connect()
cursor = conn.cursor()
s = "SELECT auth FROM authorization WHERE filename='" + filename + "' AND username='******';"
# print s
cursor.execute(s)
ret = cursor.fetchall()
if len(ret) == 0:
s = "INSERT INTO authorization (filename, username, auth) " + \
"values ('" + filename + "', '" + username + "', " + str(auth) + ");"
cursor.execute(s)
conn.commit()
else:
s = "UPDATE authorization SET auth=" + str(auth) + \
" WHERE filename='" + filename + "' AND username='******';"
# print s
cursor.execute(s)
conn.commit()
