def user_page(id): current_user = session.checkSession(request) _user = user.getUserInformations(id) if _user is None: return template("achieved", {"message": "Cet utilisateur n'existe pas", "link": "/index"}) _followed = user.getUserFollowed(id) _follow = user.getUserFollow(id) _followedNumber = len(_followed) _followNumber = len(_follow) _layers = layers.getLayersForUser(id) if str(current_user) != id: isFollowUser = user.followsUser(current_user, id) return template("other", {"user" : _user, "followed" : _followed, "follow":_follow, "followedNumber": _followedNumber, "followNumber": _followNumber, "isFollowUser": isFollowUser, "layers": _layers }) else: _layers = layers.getLayersForUser(id) _notifications = user.getUserNotifications(id) users = [] try: for i in xrange(0,len(_notifications)): _user = user.getUserInformations(_notifications[i][1]) users.append(_user[3] + " " + _user[4]) except NameError: #Correction python 3 for i in range(0,len(_notifications)): _user = user.getUserInformations(_notifications[i][1]) users.append(_user[3] + " " + _user[4]) _notificationsNumber = len(_notifications) return template("self", {"user" : _user, "followed" : _followed, "follow":_follow, "followedNumber": _followedNumber, "followNumber": _followNumber, "layers": _layers, "notifications": _notifications, "notificationsNumber": _notificationsNumber, "users": users })
def addCalqueCreationNotification(_user, layer): followers = user.getUserFollowed(_user) cnx = database.init("./../data/bdd.sq3") for follower in followers: cnx[1].execute("INSERT INTO notification (user, notificator, type, layer) VALUES ('"+ str(follower[0]) +"', '"+ str(_user) +"', '3', '"+ str(layer) +"')") database.save(cnx) database.close(cnx)