def getLastSession(): query = "SELECT MAX(id) FROM session" record = "" con = Connection(query,record) user = con.fetchOneQuerySQL() query = """ SELECT user FROM session WHERE id = %s """ record = (user[0],) con = Connection(query,record) result = con.fetchOneQuerySQL() return result[0]
def add_friend(): """Send a friend request to another user.""" user_a_id = session["current_user"]["id"] #user_b_id = request.form.get("user_b_id") user_b_id = request.form['button_for_add'] print user_b_id # Check connection status between user_a and user_b is_friends, is_pending = is_friends_or_pending(user_a_id, user_b_id) if user_a_id == user_b_id: return "You cannot add yourself as a friend." elif is_friends: return "You are already friends." elif is_pending: return "Your friend request is pending." else: requested_connection = Connection(user_a_id=user_a_id, user_b_id=user_b_id, status="Requested") db.session.add(requested_connection) db.session.commit() print "User ID %s has sent a friend request to User ID %s" % ( user_a_id, user_b_id) return "Request Sent"
def listOfExcercise(): query = "SELECT name FROM excercise ORDER BY type DESC, name" record = "" con = Connection(query,record) result = con.fetchAllQuerySQL() exc = [r[0] for r in result] #exc.append(" ") return exc
def returnMinDate(user): query = "SELECT MIN(dateCreated) FROM lift WHERE user_id = %s" record = (user,) con = Connection(query,record) result = con.fetchOneQuerySQL() try: return result[0].strftime("%Y-%m-%d") except: return datetime.now().strftime('%Y-%m-%d')
def returnDateLogin(user_id): query = "SELECT DISTINCT dateCreated FROM lift WHERE user_id = %s" record = (user_id,) #result = list(fetchAllQuerySQL(query,record)) con = Connection(query,record) result = con.fetchAllQuerySQL() date = [d[0] for d in result] dateString = [dt.strftime("%Y-%m-%d") for dt in date] return dateString
def ifUser(username): query = "SELECT user_id FROM user WHERE name = %s" record = (username,) con = Connection(query,record) result = con.fetchOneQuerySQL() if result == None: return 0 else: return result[0]
def load_connections(): """Load sample connection.""" print "Loading connections..." Connection.query.delete() connect = Connection(pet_id=1, owner_id=1, seeker_id=4, connection_status='Interested') connect2 = Connection(pet_id=1, owner_id=1, seeker_id=2, connection_status='Interested') db.session.add(connect) db.session.add(connect2) db.session.commit()
def checkLoginValid(username,password): query = "SELECT password FROM user WHERE name = %s" record = (username,) con = Connection(query,record) result = con.fetchOneQuerySQL() if result == None: return 0 elif result[0] != password: return -1 else: return 1
def create_connection(user_id_1, user_id_2, connected=True): """Creates new Connection""" connect_date = datetime.today() connection = Connection(user_id_1=user_id_1, user_id_2=user_id_2, connect_date=connect_date, connected=connected) db.session.add(connection) db.session.commit() return connection
def add_friend(): """ send a friend request """ user_a_id = session["current_user"]["user_id"] user_b_id = request.form.get("user_b_id") friend_request = Connection(user_a_id=user_a_id, user_b_id=user_b_id, status="Pending") session["current_user"]["num_sent_requests"] += 1 session["current_user"]["num_total_requests"] += 1 db.session.add(friend_request) db.session.commit() return "Request Sent"
def fromExcToAbr(exc): query = "SELECT abbreviation FROM excercise WHERE name = %s" record = (exc,) con = Connection(query,record) result = con.fetchOneQuerySQL() return result[0]
def idFromUser(user): query = "SELECT user_id FROM user WHERE name = %s" record = (user,) con = Connection(query,record) result = con.fetchOneQuerySQL() return result[0]