def signup():
logout_user()
if request.method == "POST" and request.form is not None:
username = request.form["username"]
email = request.form["email"]
key_string = str(request.form["password"])
salt = "1Ha7"
password = salt + ":" + hashlib.md5(salt + key_string).hexdigest()
u = insertUsers([username, email, password])
if u != 0:
print "******************session****************"
sessionid = random.randint(10000, 65535)
print sessionid
session["id"] = sessionid
"""session['userid']=u.id
data[sessionid]=dict()
data[sessionid]["username"]=u.username
data[sessionid]["userid"]=u.id"""
user_sess = UserSession(int(sessionid), int(u.id), str(u.username))
db_session.add(user_sess)
db_session.commit()
return redirect(url_for("showprojects"))
else:
flash("Username/Email already exists. Please try a different one.")
return render_template("signup.html")
def signup():
if request.method=='POST' and request.form is not None:
username=request.form["username"]
email=request.form["email"]
password=request.form["password"]
u=insertUsers([username,email,password])
if u!=0:
session["userid"] = u.id
session["username"]=u.username
return redirect(url_for("showprojects"))
else:
flash("Username/Email already exists. Please try a different one.")
return render_template("signup.html")
def test_insert():
insertUsers()
return "sucess tested"
errorList = {"taskIndex": task_index, "message": err_msg}
tasks_unsuccessful.append(errorList)
# Append error to error
if not hasError:
conn = database.openConnection()
admins_db_ids = []
users_db_ids = []
# insert group zonder admin colomn -> groupID
# TODO find a way to get telegram_id
group_db_id = database.insertGroups(
conn, [(telegram_url, channel_title, project_name, total_users,
returned_results, channel_id, channel_username)])
# insert admin users --> admin user id list
if insert_admin_tuples:
admins_db_ids = database.insertUsers(conn, insert_admin_tuples)
if insert_user_tuples:
users_db_ids = database.insertUsers(conn, insert_user_tuples)
# link users with group in table group_users
assign_users_tuples = []
assign_admins_tuples = []
if users_db_ids:
for user in users_db_ids:
assign_users_tuples.append((group_db_id[0], user, False))
database.addUserToGroup(conn, assign_users_tuples)
if admins_db_ids:
for admin in admins_db_ids:
assign_admins_tuples.append((group_db_id[0], admin, True))
database.addUserToGroup(conn, assign_admins_tuples)
