def other_profile(username): user = User() logged = json.loads(session['log']) my_id = logged['id'] if not user.exists(username): return render_template('print.html', title='Error', values=['This user does not exist']) if username != logged['login']: vis = Visit(my_id) vis.add_visit(username) user.dict_to_obj(logged) session["log"] = user.to_json() logged = json.loads(session['log']) session["user_id"] = '' res = user.query('''SELECT users.id, login, gender, email, pic_id, popularity, firstname, lastname, longitude, latitude, bio, \ orientation, birthdate, city FROM users WHERE login = ?''', (username,)) profile_pic = user.query('''SELECT * FROM pics WHERE id = ?''', (res[0][4],)) pics = user.query('''SELECT * FROM pics WHERE user_id = ? AND id != ?''', (res[0][0], res[0][4])) info = {'id': res[0][0], 'login': res[0][1], 'gender': res[0][2], 'email': res[0][3], 'pic_id': res[0][4], 'popularity': res[0][5], 'firstname': res[0][6], 'lastname': res[0][7], 'longitude': res[0][8], 'latitude': res[0][9], 'bio': res[0][10], 'orientation': res[0][11], "birthdate": res[0][12], "city": res[0][13], "pics": pics, "likes": user.does_like(my_id, username), "blocks": user.does_block(my_id, username)} if len(profile_pic) > 0: info.update({'profile_pic': profile_pic[0]}) return render_template('profil.html', info=info, user=logged)
def report_user(): us = User() user_id = request.args.get('id') info = json.loads(session['log']) ct = us.count_query('''DELETE FROM reports WHERE to_id = ? AND from_id = ?''', (user_id, info['id'])) if ct == 0: us.query('''INSERT INTO reports(to_id, from_id) VALUES(?, ?)''', (user_id, info['id'])) return jsonify(result=[])
def block_user(): us = User() user_id = request.args.get('id') info = json.loads(session['log']) res = False ct = us.count_query('''DELETE FROM blocks WHERE to_id = ? AND from_id = ?''', (user_id, info['id'])) if ct == 0: res = True us.query('''INSERT INTO blocks(to_id, from_id) VALUES(?, ?)''', (user_id, info['id'])) return jsonify(result=res)
def profile(): user = User() info = json.loads(session['log']) user.dict_to_obj(info) session['log'] = user.to_json() info = json.loads(session['log']) profile_pic = user.query('''SELECT * FROM pics WHERE id = ?''', (info['pic_id'],)) pics = user.query('''SELECT * FROM pics WHERE user_id = ? AND id != ?''', (info['id'], info['pic_id'])) info['pics'] = pics if len(profile_pic) > 0: info['profile_pic'] = profile_pic[0] return render_template('profil.html', info=info)