def make_friends(): gets_user_account_number=user_get_request.Users(session['the_user_id']) account_number_me = gets_user_account_number.get_user_account_number() gets_user_account_number = user_get_request.Users(session['the_user_id'],account_number_me[0][0]) requests=gets_user_account_number.get_request() requests_me=requests[0] if request.form['agree']: get_id = user_get_id.Users(account_number_me,session['name']) the_friends=get_id.get_friends_id() the_friends_id=the_friends[0][0] connection = connect.connection_out() try: with connection.cursor() as cursor: sql = "delete from request where the_account_number=%s" cursor.execute(sql,(account_number_me)) sql = "insert into friends (the_user_id,his_friends_id,friends_name) values(%s,%s,%s)" cursor.execute(sql,(session['the_user_id'],the_friends_id,requests_me)) connection.commit() finally: connection.close() gets_ideas = user_get_ideas.Users_id(session['the_user_id']) my_friends=gets_ideas.get_friends() gets_request = user_get_request.Users(session['the_user_id'],account_number_me) requests=gets_request.get_request(account_number_me) return render_template('log_in_friends.html',name=session['name'],friends=my_friends,request=requests)
def set(): time=get_time() connection = connect.connection_out() try: with connection.cursor() as cursor: sql="insert into user_me (user,password,account_number,time) values (%s,%s,%s,%s)" cursor.execute(sql,(request.form['name'],request.form['password'],request.form['account_number'],time)) connection.commit() finally: connection.close() return render_template('zhuye.html')
def check_account_number(): account_number_me = int(request.form['account_number']) connection = connect.connection_out() try: with connection.cursor() as cursor: sql = "select account_number from user_me" cursor.execute(sql) result = cursor.fetchall() for i in result: if account_number_me == i['account_number']: return json.dumps({"result":1}) return json.dumps({"result":0}) finally: connection.close()
def my_thoughts(): time=get_time() connection = connect.connection_out() try: with connection.cursor() as cursor: sql="insert into shuoshuo_me (user_id,shuoshuo,time) values (%s,%s,%s)" cursor.execute(sql,(session['the_user_id'],request.form['my_thoughts'],time)) connection.commit() finally: connection.close() gets_ideas = user_get_ideas.Users_id(session['the_user_id']) the_idea=gets_ideas.get_ideas() my_friends=gets_ideas.get_friends() return render_template('log_in.html',name=session['name'],shuoshuo=the_idea,friends=my_friends)
def search_friend(): account_number=int(request.form['account_number']) gets_ideas = user_get_ideas.Users_id(session['the_user_id']) the_idea=gets_ideas.get_ideas() my_friends=gets_ideas.get_friends() connection = connect.connection_out() try: with connection.cursor() as cursor: sql = "insert into request (friends_name,the_account_number) values (%s,%s)" cursor.execute(sql,(session['name'],account_number)) connection.commit() finally: connection.close() return render_template('log_in.html',name=session['name'],shuoshuo=the_idea,friends=my_friends)
def log_in(): account_number_me=int(request.form['account_number']) password_me=int(request.form['password']) get_id = user_get_id.Users(account_number_me) user_id = get_id.get_user_id() connection = connect.connection_out() try: with connection.cursor() as cursor: sql="select password,user from user_me where account_number = %s" cursor.execute(sql,account_number_me) result=cursor.fetchall() print(result) password=int(result[0]['password']) if password_me==password: session['the_user_id']=user_id session['name']=result[0]['user'] check=json.dumps({"result":1}) return check else: check=json.dumps({"result":0}) return check finally: connection.close()