def unfollow(con, follower_email, followee_email): query = "DELETE FROM follower WHERE follower = \'" + str(follower_email) + "\' AND " + "followee = \'" + str( followee_email) + "\'" dbConnector.update_query(con, query, ()) return details(con, follower_email)
def follow(con, follower_email, followee_email): query = "INSERT INTO follower (follower, followee) VALUES (\'" + str(follower_email) + "\', \'" + str( followee_email) + "\')" dbConnector.update_query(con, query, ()) return details(con, follower_email)
def restore_remove(connection, post, isDeleted):
query = "UPDATE post SET isDeleted = " + str(isDeleted) + " WHERE id = " + str(post)
dbConnector.update_query(connection, query, ())
response = {"post": post}
return response
def update(con, message, slug, thread): query = "UPDATE thread SET slug = " + "\'" + str(slug) + "\'" + ", message = " + "\'" + str( message) + "\'" + " WHERE id = " + str(thread); try: dbConnector.update_query(con, query, ()) except Exception as e: print(e.message) return details(con, id=thread, related=[])
def vote(connection, vote, post):
if vote == 1:
query = "UPDATE post SET likes = likes + 1, points = points + 1 WHERE id = " + str(post)
else:
query = "UPDATE post SET dislikes = dislikes + 1, points = points - 1 WHERE id = " + str(post)
dbConnector.update_query(connection, query, ())
return
def updateProfile(con, about, user, name): query = "UPDATE user SET about = \'" + str(about) + "\', email = \'" + str(user) + "\', name = \'" + str( name) + "\' WHERE email = \'" + str(user) + "\'" try: dbConnector.update_query(con, query, ()) except Exception as e: print (e.message) print details(con, user) return details(con, user)
def unsubscribe(connection, user, thread):
query = "DELETE FROM subscription WHERE thread = \'" + \
str(thread) + "\' AND user = \'" + str(user) + "\'"
try:
dbConnector.update_query(connection, query, ())
except Exception as e:
print (e.message)
result = {"thread": str(thread), "user": str(user)}
return result
def vote(con, vote, thread): if vote == -1: query = "UPDATE thread SET dislikes = dislikes + 1, points = points - 1 WHERE id = " + str(thread) else: query = "UPDATE thread SET likes = likes + 1, points = points + 1 WHERE id = " + str(thread) try: dbConnector.update_query(con, query, ()) except Exception as e: print (e.message) return details(con, thread=id, related=[])
def open_close(con, thread, isClosed):
query = "UPDATE thread SET isClosed = " + str(isClosed) + " WHERE id = " + str(thread);
try:
dbConnector.update_query(con, query, ())
except Exception as e:
print (e.message)
response = {
"thread": thread}
return response
def create(con, name, short_name, user): dbConnector.update_query( con, 'INSERT INTO forum (name, short_name, user) VALUES (%s, %s, %s)', (name, short_name, user) ); # check result of update query: forum = dbConnector.select_query( con, 'SELECT id, name, short_name, user FROM forum WHERE short_name = %s', (short_name,) ) return forum_description(forum);
def create(connection, name, short_name, user):
dbConnector.update_query(
connection,
'INSERT INTO forum (name, short_name, user) VALUES (%s, %s, %s)', (name,
short_name, user)
)
forum = dbConnector.select_query(
connection,
'SELECT id, name, short_name, user FROM forum WHERE short_name = %s', (
short_name,)
)
return serialise_f(forum)
def create(con, forum, title, isClosed, user, date, message, slug, optional):
isDeleted = 0
if "isDeleted" in optional:
isDeleted = optional["isDeleted"]
thread = dbConnector.update_query(con,
'INSERT INTO thread (forum, title, isClosed, user, date, message, slug, isDeleted) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)',
(forum, title, isClosed, user, date, message, slug, isDeleted,))
if thread == "Error":
raise Exception("Thread already exists")
thread = dbConnector.select_query(con,
'SELECT date, forum, id, isClosed, isDeleted, message, slug, title, user, dislikes, likes, points, posts FROM thread WHERE slug = %s',
(slug,)
)
thread = thread[0]
response = {
'date': str(thread[0]),
'forum': thread[1],
'id': thread[2],
'isClosed': bool(thread[3]),
'isDeleted': bool(thread[4]),
'message': thread[5],
'slug': thread[6],
'title': thread[7],
'user': thread[8],
}
return response
def subscribe(connection, user, thread):
query = "INSERT INTO subscription (thread, user) VALUES (\'" + \
str(thread) + "\',\'" + str(user) + "\')"
try:
dbConnector.update_query(connection, query, ())
except Exception as e:
print (e.message)
query = "SELECT thread, user FROM subscription WHERE thread = \'" + \
str(thread) + "\', " + "user = \'" + str(user) + "\'"
try:
sub = dbConnector.select_query(connection, query, ())
except Exception as e:
print (e.message)
result = {"thread": sub[0][0], "user": sub[0][1]}
return result
def restore_remove(con, thread, isDeleted):
posts = 0
if isDeleted == 0:
query = "SELECT COUNT(id) FROM post WHERE thread = " + str(thread)
print query
posts = dbConnector.select_query(con, query, ())[0][0]
query_thread = "UPDATE thread SET isDeleted = " + str(isDeleted) + ", posts = " + str(posts) + " WHERE id = " + str(
thread)
query_post = "UPDATE post SET isDeleted = " + str(isDeleted) + " WHERE thread = " + str(thread)
try:
dbConnector.update_query(con, query_thread, ())
dbConnector.update_query(con, query_post, ())
except Exception as e:
print (e.message)
response = {
"thread": thread}
return response
def create(con, username, about, name, email, optional):
isAnonymous = 0;
if "isAnonymous" in optional:
isAnonymous = optional["isAnonymous"]
user = dbConnector.update_query(
con,
'INSERT INTO user (username, about, name, email, isAnonymous) VALUES (%s, %s, %s, %s, %s)',
(username, about, name, email, isAnonymous,)
)
if user == "Error":
raise Exception("5")
# check insertion
user = dbConnector.select_query(
con,
'SELECT id, email, about, isAnonymous, name, username FROM user WHERE email = %s',
(email,)
)
return user_description(user)
def update(connection, post, message):
query = "UPDATE post SET message = " + str(message) + " WHERE id = " + str(post)
dbConnector.update_query(connection, query, ())
return details(connection, details_id=post, related=[])
def dec_posts(con, post): query = "SELECT thread FROM post WHERE id = " + str(post) thread = dbConnector.select_query(con, query, ())[0][0] query = "UPDATE thread SET posts = posts - 1 WHERE id = " + str(thread) dbConnector.update_query(con, query, ()) return
