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