def post(self, forum_id, thread_id):
data = Post.parser.parse_args()
if Postname.find(forum_id, thread_id) is None:
return {"message": "forum / thread does not exist"}, 404
connection = get_db()
cursor = connection.cursor()
query = "INSERT INTO post VALUES (NULL,?,?,?,?,?)"
cursor.execute(query, (forum_id, thread_id, data['content'],
current_identity.username, datetime.now()))
#
# query = "INSERT INTO forums VALUES (NULL,?,?)"
# cursor.execute(query, (forum_id, data['creator']))
connection.commit()
# thread_id = Threadname.get_Thread_id()
# if thread_id:
# query = "INSERT INTO posts VALUES (NULL,?,?,?,?,?)"
# cursor.execute(query, (forum_id, thread_id, data['content'], data['creator'], datetime.now()))
# connection.commit()
resp = Response(status=201, mimetype='application/json')
connection.close()
return resp
def post(self, forum_id):
data = Thread.parser.parse_args()
if Threadname.find_by_forumid(forum_id) is None:
return {"message": "forum does not exist"}, 404
connection = get_db()
cursor = connection.cursor()
query = "INSERT INTO thread VALUES (NULL,?,?,?,?)"
cursor.execute(query,
(forum_id, data['title'], current_identity.username,
datetime.now()))
#
# query = "INSERT INTO forums VALUES (NULL,?,?)"
# cursor.execute(query, (forum_id, data['creator']))
connection.commit()
thread_id = Threadname.get_Thread_id()
if thread_id:
query = "INSERT INTO post VALUES (NULL,?,?,?,?,?)"
cursor.execute(query, (forum_id, thread_id, data['content'],
current_identity.username, datetime.now()))
connection.commit()
resp = Response(status=201, mimetype='application/json')
resp.headers['Location'] = 'http://127.0.0.1:5000/forums/' + str(
forum_id) + '/' + str(thread_id)
connection.close()
return resp
def post(self):
data = UserRegister.parser.parse_args()
if User.find_by_username(data['username']):
return {"message": "user with that name already exists"}, 409
connection = get_db()
cursor = connection.cursor()
query = "INSERT INTO user VALUES (NULL,?,?)"
cursor.execute(query, (data['username'], data['password']))
connection.commit()
connection.close()
resp = Response(status=201, mimetype='application/json')
return resp
def put(self, username):
data = UserUpdation.parser.parse_args()
if User.find_by_username(username) is None:
return {"message": "user with that name not found"}, 404
if current_identity.username != username:
return {"message": "not authenticated user"}, 409
connection = get_db()
cursor = connection.cursor()
query = "update user set username = ?, password = ? where username = ?"
cursor.execute(query, (data['username'], data['password'], username))
connection.commit()
connection.close()
return {"message": "user updated successfully"}, 200
def post(self):
data = Forum.parser.parse_args()
if Forumname.find_by_forumname(data['name']):
return {"message": "forum with that name already exists"}, 409
connection = get_db()
cursor = connection.cursor()
query = "INSERT INTO forum VALUES (NULL,?,?)"
cursor.execute(query, (data['name'], current_identity.username))
connection.commit()
resp = Response(status=201, mimetype='application/json')
forum_id = Forumname.get_forum_id()
if forum_id:
resp.headers['Location'] = 'http://127.0.0.1:5000/forums/' + str(
forum_id)
connection.close()
return resp