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)
