def createList():
authHeader = request.headers.get('Authorization')
tokenEncoded = authHeader.split(' ')[1]
token = decodeToken(tokenEncoded)
user = getUser(token)
userId = user['id']
listname = request.json['listname']
taskArr = request.json['taskArr']
cursor = mysql.connection.cursor()
cursor.execute(""" INSERT INTO list (listname, userId) VALUES (%s, %s) """,
(listname, userId))
cursor.execute(""" SELECT id, listname FROM list WHERE listname = %s """,
(listname, ))
result = cursor.fetchone()
mysql.connection.commit()
for task in taskArr:
cursor.execute(
""" INSERT INTO tasks ( task, listId, userId ) VALUES (%s, %s, %s) """,
(task, result['id'], userId))
mysql.connection.commit()
cursor.close()
return {"message": "List and tasks created"}
def details():
authHeader = request.headers.get('Authorization')
tokenEncoded = authHeader.split(' ')[1]
id = decodeToken(tokenEncoded)
cursor = mysql.connection.cursor()
cursor.execute(""" SELECT username FROM users WHERE id = %s """, (id, ))
results = cursor.fetchall()
cursor.close()
return {"user": getData(results)}
def deleteBlog(id):
authHeader = request.headers.get('Authorization')
tokenEncoded = authHeader.split(' ')[1]
userId = decodeToken(tokenEncoded)
cursor = mysql.connection.cursor()
cursor.execute(
"""DELETE FROM blogs2 WHERE id = %s AND userId = %s """, (id, userId)
)
mysql.connection.commit()
cursor.close()
return {"message": "blog deleted"}
def userBlogs():
authHeader = request.headers.get('Authorization')
tokenEncoded = authHeader.split(' ')[1]
token = decodeToken(tokenEncoded)
user = getUser(token)
userId = user[0]['id']
cursor = mysql.connection.cursor()
cursor.execute(
""" SELECT * FROM blogs2 WHERE userId = %s """, (userId,)
)
results = cursor.fetchall()
cursor.close()
return { "blogs" : getData(results) }
def updateBlog(id):
authHeader = request.headers.get('Authorization')
tokenEncoded = authHeader.split(' ')[1]
userId = decodeToken(tokenEncoded)
title = request.json['title']
blog = request.json['blog']
category = request.json['category']
cursor = mysql.connection.cursor()
cursor.execute(
"""UPDATE blogs2 SET title = %s, blog = %s, category = %s WHERE id = %s AND userId = %s """, (title, blog, category, id, userId)
)
mysql.connection.commit()
cursor.close()
return {"message": "blog updated"}
def createComment():
authHeader = request.headers.get('Authorization')
tokenEncoded = authHeader.split(' ')[1]
token = decodeToken(tokenEncoded)
user = getUser(token)
username = user[0]['username']
blogId = request.json['blogId']
comment = request.json['comment']
cursor = mysql.connection.cursor()
cursor.execute(
"""INSERT INTO comments2 (blogId, comment, username)
VALUES (%s, %s, %s) """, (blogId, comment, username))
mysql.connection.commit()
cursor.close()
return {"message": "comment created"}
def createTask():
task = request.json['task']
authHeader = request.headers.get('Authorization')
tokenEncoded = authHeader.split(' ')[1]
token = decodeToken(tokenEncoded)
user = getUser(token)
userId = user['id']
listId = request.json['listId']
cursor = mysql.connection.cursor()
cursor.execute(
""" INSERT INTO tasks ( task, listId, userId ) VALUES (%s, %s, %s) """,
(task, listId, userId))
mysql.connection.commit()
cursor.close()
return {'message': "Task added"}
def read():
authHeader = request.headers.get('Authorization')
tokenEncoded = authHeader.split(' ')[1]
token = decodeToken(tokenEncoded)
user = getUser(token)
userId = user['id']
cursor = mysql.connection.cursor()
cursor.execute(
""" SELECT list.id AS listId, listname, COUNT(tasks.id) AS task FROM list JOIN tasks ON list.id = tasks.listId WHERE list.userId = %s GROUP BY list.id """,
(userId, ))
result = cursor.fetchall()
cursor.close()
return {'lists': getData(result)}
def createBlog():
authHeader = request.headers.get('Authorization')
tokenEncoded = authHeader.split(' ')[1]
userId = int(decodeToken(tokenEncoded))
user = getUser(userId)
username = user[0]['username']
print(username)
title = request.json['title']
blog = request.json['blog']
category = request.json['category']
cursor = mysql.connection.cursor()
cursor.execute(
"""INSERT INTO blogs2 (userId, title, blog, category, username)
VALUES (%s, %s, %s, %s, %s) """, (userId, title, blog, category, username)
)
mysql.connection.commit()
cursor.close()
return {"message": "blog created"}
