def get_by_token(self): session, id = query_db("SELECT * FROM sessions WHERE token = ?", (self.token, ), True) if session != None: self.id = session["id"] self.token = session["token"] self.user_id = session["user_id"] return self return None
def get_by_id(self): user, id = query_db("SELECT * FROM users WHERE id = ?", (self.id,), True) # True == je veux qu un element if user != None : self.username = user["username"] self.email = user["email"] self.password = user["password"] self.id = user["id"] return self return None
def get_by_email(self): user, id = query_db("SELECT * FROM users WHERE email = ?", (self.email,), True) if user != None : self.username = user["username"] self.email = user["email"] self.password = user["password"] self.id = user["id"] return self return None
def get_by_id(self): article, id = query_db("SELECT * FROM articles WHERE id = ?", (self.id,), True) # True == je veux qu un element if article != None : self.title = article["title"] self.body = article["body"] self.creation_date= article["creation_date"] self.id = article["id"] self.user_id = article["user_id"] return self return None
def get_by_id(self): comment, id = query_db("SELECT * FROM comments WHERE id = ?", (self.id,), True) # True == je veux qu un element if comment != None : self.message = comment["message"] self.creation_date= comment["creation_date"] self.id = comment["id"] self.article_id = comment["article_id"] self.user_id = comment["user_id"] return self return None
def all(self): articles, ids = query_db("SELECT * FROM articles") for art in articles : tmp = Article() tmp.title = art["title"] tmp.body = art["body"] tmp.creation_date = art["creation_date"] tmp.user_id = art["user_id"] tmp.id = art["id"] self.articles.append(tmp)
def all(self): comments, ids = query_db("SELECT * FROM comments WHERE article_id = ?", (self.article_id,)) if comments is None : return for com in comments : tmp = Comment() tmp.message = com["message"] tmp.creation_date = com["creation_date"] tmp.article_id = com["article_id"] tmp.user_id = com["user_id"] tmp.id = com["id"] self.comments.append(tmp)
def save(self): usr, id = query_db("INSERT INTO users (username, email, password) VALUES(?, ?, ?)", (self.username, self.email, self.password)) return id
def delete(self): query_db("DELETE FROM sessions WHERE id = ?", (self.id, ), True)
def create(self): art, id = query_db( "INSERT INTO sessions (token, user_id) VALUES(?, ?)", (self.token, self.user_id)) return id
def delete(self): query_db("DELETE FROM users WHERE id = ?", (self.id,), True)
def update(self): query_db("UPDATE comments SET message = ? WHERE id = ?", (self.message, self.id))
def save(self): # le query db renvoit comment vide (car INSERT) et un id (remplie) comment, id = query_db("INSERT INTO comments (message, creation_date, article_id, user_id) VALUES(?, ?, ?, ?)", (self.message, self.creation_date, self.article_id, self.user_id)) return id
def delete(self): query_db("DELETE FROM articles WHERE id = ?", (self.id,), True)
def update(self): query_db("UPDATE articles SET title = ?, body = ? WHERE id = ?", (self.title, self.body, self.id))
def update(self, passwd = False): # boolen pour gerer la modif du password if passwd == False : query_db("UPDATE users SET username = ?, email = ? WHERE id = ?", (self.username, self.email, self.id)) else : query_db("UPDATE users SET username = ?, email = ?, password = ? WHERE id = ?", (self.username, self.email, self.password, self.id))
def delete(self): query_db("DELETE FROM comments WHERE id = ?", (self.id,), True)
def all(self): users, ids = query_db("SELECT * FROM users") for usr in users : tmp = User(usr['username'], usr['email'], usr['password']) tmp.id = usr["id"] self.users.append(tmp)
def save(self): # le query db renvoit art vide (car INSERT) et un id (remplie) art, id = query_db("INSERT INTO articles (title, body, creation_date, user_id) VALUES(?, ?, ?, ?)", (self.title, self.body, self.creation_date, self.user_id)) return id