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)