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)
def addChapter(lesson, name): if lesson == "" or name == "" or lesson == None or name == None: return cnx = database.init("./../data/bdd.sq3") cnx[1].execute("INSERT INTO chapter(lesson, name) VALUES ('"+lesson+"','"+name+"')") database.save(cnx) database.close(cnx)
def removeCommentsForUser(ide): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("DELETE FROM comments WHERE user='******'") database.save(cnx) database.close(cnx)
def removeLesson(ide): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("DELETE FROM lesson WHERE id='"+ide+"'") database.save(cnx) cnx[1].execute("DELETE FROM chapter WHERE lesson='"+ide+"'") database.save(cnx) database.close(cnx)
def removeLayer(id, admin): notification.addLayerSuppressionNotification(id, admin) cnx = database.init("./../data/bdd.sq3") cnx[1].execute("DELETE FROM layer WHERE id ='"+ str(id) +"'") #TODO: ajouter validation database.save(cnx) database.close(cnx) os.remove("/data/layer/"+ str(id) +".html")
def deadminUser(id): info = getUserInformations(id) if info[7] == "True" and getAdminNumber() <= 1: return cnx = database.init("./../data/bdd.sq3") cnx[1].execute("UPDATE user SET admin='False' WHERE id='" + id + "'") database.save(cnx) database.close(cnx)
def removeUser(id): info = getUserInformations(id) if info[7] == "True" and getAdminNumber() <= 1: return cnx = database.init("./../data/bdd.sq3") cnx[1].execute("DELETE FROM user WHERE id='" + id + "'") database.save(cnx) database.close(cnx) comments.removeCommentsForUser(id) notification.removeNotificationsForUser(id)
def addLayer(basedOn, user, chapter, date, content): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("INSERT INTO layer(basedOn, user, chapter, date, validated) VALUES ('"+ str(basedOn) +"', '"+ str(user) +"','"+ str(chapter) +"','"+ str(date) +"', 'False')") database.save(cnx) database.close(cnx) fil = open("./../data/layer/"+str(lastLayerId())+".html", "w") render = unicode(content).encode("utf-8") fil.write(render) fil.close() notification.addCalqueCreationNotification(user, lastLayerId())
def adminUser(id): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("UPDATE user SET admin='True' WHERE id='" + id + "'") database.save(cnx) database.close(cnx)
def addLesson(name, teatcher): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("INSERT INTO lesson(name, teatcher) VALUES ('"+name+"','"+teatcher+"')") database.save(cnx) database.close(cnx)
def removeNotificationsForUser(ide): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("DELETE FROM notification WHERE user='******'") database.save(cnx) database.close(cnx)
def addLayerValidationNotification(id, admin): cnx = database.init("./../data/bdd.sq3") res = (cnx[1].execute("SELECT user FROM layer WHERE id = '"+ str(id) +"'")).fetchone() cnx[1].execute("INSERT INTO notification (user, notificator, type, layer) VALUES ('"+ str(res[0]) +"', '"+ str(admin) +"', '6', '"+ str(id) +"')") database.save(cnx) database.close(cnx)
def updateUserInformation(id, variable, value): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("UPDATE user SET "+ str(variable) +"='"+ str(value) +"' WHERE user.id = '"+ str(id) +"'") database.save(cnx) database.close(cnx)
def addUnfollowNotification(user, userFollowed): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("INSERT INTO notification (user, notificator, type) VALUES ('"+ str(userFollowed) +"', '"+ str(user) +"', '2')") database.save(cnx) database.close(cnx)
def addCommentNotification(_user, _layer): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("INSERT INTO notification (user, notificator, type, layer) VALUES ('"+ str(layers.getLayerInformations(_layer)[1]) +"', '"+ str(_user) +"', '0', '"+ str(_layer) +"')") database.save(cnx) database.close(cnx)
def followUser(id_user, id_user_followed): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("INSERT INTO follow (user, follow) VALUES ('"+ str(id_user) +"', '"+ str(id_user_followed) +"')") database.save(cnx) database.close(cnx) notification.addFollowNotification(id_user, id_user_followed)
def removeComment(ide, admin): notification.addCommentSuppressionNotification(ide, admin) cnx = database.init("./../data/bdd.sq3") cnx[1].execute("DELETE FROM comments WHERE id='"+ str(ide) +"'") database.save(cnx) database.close(cnx)
def validateLayer(id): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("UPDATE layer SET validated='True' WHERE id = '"+ str(id) +"'") #TODO: ajouter notify user database.save(cnx) database.close(cnx)
def debanUser(id): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("UPDATE user SET banned='False' WHERE id='" + id + "'") database.save(cnx) database.close(cnx)
def removeLayer(id): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("DELETE FROM layer WHERE id='"+ str(id) +"'") database.save(cnx) database.close(cnx) os.remove("./../data/layer/"+id+".html")
def unfollowUser(id_user, id_user_followed): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("DELETE FROM follow WHERE user='******' AND follow='"+str(id_user_followed)+"' ") database.save(cnx) database.close(cnx) notification.addUnfollowNotification(id_user, id_user_followed)
def addComment(user, layer, date, content): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("INSERT INTO comments(layer, user, date, content) VALUES ('"+str(layer)+"','"+str(user)+"','"+str(date)+"','"+str(content)+"')") database.save(cnx) database.close(cnx) notification.addCommentNotification(user, layer)
def addUser(name, password, mail): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("INSERT INTO user(name, password, mail) VALUES ('" + name + "','" + password + "','" + mail + "')") database.save(cnx) database.close(cnx)
def addComment(layer, user, date, content): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("INSERT INTO comments(layer, user, date, content) VALUES ('"+layer+"', '"+user+"', '"+date+"', '"+content+"')") database.save(cnx) database.close(cnx)
def removeComment(ide): cnx = database.init("./../data/bdd.sq3") cnx[1].execute("DELETE FROM comments WHERE id='"+str(ide)+"'") database.save(cnx) database.close(cnx)