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()
