def create():
user_id = request.args.get('user_id')
user_info = get_user_info(user_id)
req = request.form
is_reply_from = req['is_reply_from'] if req['is_reply_from'] else None
data = Comment(body=req['body'],
list_id=req['list_id'],
card_id=req['card_id'],
is_reply_from=is_reply_from,
created_by=user_id)
db.session.add(data)
db.session.commit()
db.session.query(Card).filter(Card.id == data.id).update(
{'comment_count': Card.comment_count + 1})
db.session.commit()
res = {
'id': data.id,
'body': data.body,
'list_id': data.list_id,
'card_id': data.card_id,
'list_id': data.list_id,
'is_reply_from': data.is_reply_from
}
return jsonify(message="success", data=res)
def show(id):
user_id = request.args.get('user_id')
user_info = get_user_info(user_id)
id = request.view_args['id']
data = Comment.query.filter(Comment.id == id).first()
if not data:
return jsonify(message='No data found.'), 422
per_page = 20
page = request.args.get('page') if request.args.get('page') else 0
list_data = Comment.query.filter(
Comment.is_reply_from == data.id).paginate(int(page), int(per_page),
False)
total = list_data.total
items = list_data.items
data_list = []
for reply in items:
data_list.append({
'id': reply.id,
'title': reply.body,
'list_id': reply.list_id,
'card_id': reply.card_id,
'is_reply_from': reply.is_reply_from
})
res = {'id': data.id, 'body': data.title, 'reply_list': data_list}
return jsonify(message='success', data=res)
def show(id):
user_id = request.args.get('user_id')
user_info = get_user_info(user_id)
id = request.view_args['id']
data = List.query.filter(List.id == id).first()
if not data:
return jsonify(message='No data found.'), 422
if user_info.type == 'member' and str(
data.assigned_member) != str(user_id):
return jsonify(message="Not authorized."), 422
per_page = 20
page = request.args.get('page') if request.args.get('page') else 0
list_data = Card.query.filter(Card.list_id == id).paginate(
int(page), int(per_page), False)
total = list_data.total
items = list_data.items
card_list = []
for card in items:
card_list.append({
'id': card.id,
'title': card.title,
'assigned_member': card.assigned_member
})
res = {'id': data.id, 'title': data.title, 'cards': card_list}
return jsonify(message='success', data=res)
def create():
user_id = request.args.get('user_id')
user_info = get_user_info(user_id)
if user_info.type == 'member':
return jsonify(message="Not authorized"), 422
req = request.form
check = List.query.filter(List.title == req['title']).first()
if check:
return jsonify(message="Title Already Taken"), 422
data = List(title=req['title'], created_by=user_id)
db.session.add(data)
db.session.commit()
res = {
'id': data.id,
'title': data.title,
'assigned_member': data.assigned_member
}
return jsonify(message="success", data=res)
def delete(id):
user_id = request.args.get('user_id')
user_info = get_user_info(user_id)
if user_info.type == 'member':
return jsonify(message="Not authorized"), 422
id = request.view_args['id']
req = request.form
check = List.query.filter(List.id == id).first()
if str(check.created_by) != str(user_id):
return jsonify(
message="You cannot delete a list which is not belong to you."
), 422
if check:
db.session.query(Card).filter(Card.list_id == id).delete()
db.session.commit()
db.session.query(List).filter(List.id == id).delete()
db.session.commit()
return jsonify(message="successfully deleted.")
return jsonify(message="No data found."), 422
def member_assignment(id):
user_id = request.args.get('user_id')
user_info = get_user_info(user_id)
if user_info.type == 'member':
return jsonify(message="Not authorized"), 422
id = request.view_args['id']
req = request.form
check = List.query.filter(List.id == id).first()
if check:
if req['action'] == 'assign':
db.session.query(List).filter(List.id == id).update(
{'assigned_member': req['member_id']})
if req['action'] == 'unassign':
db.session.query(List).filter(List.id == id).update(
{'assigned_member': None})
db.session.commit()
return jsonify(message="successfully updated.")
return jsonify(message="No data found."), 422
def index():
user_id = request.args.get('user_id')
user_info = get_user_info(user_id)
per_page = 20
page = request.args.get('page') if request.args.get('page') else 0
list_data = List.query.paginate(int(page), int(per_page), False)
if user_info.type == 'member':
list_data = List.query.filter(
List.assigned_member == user_id).paginate(int(page), int(per_page),
False)
total = list_data.total
items = list_data.items
res = []
for data in items:
res.append({
'id': data.id,
'title': data.title,
'assigned_member': data.assigned_member
})
return jsonify(message="success", data=res, records=total)
def index():
user_id = request.args.get('user_id')
user_info = get_user_info(user_id)
per_page = 20
page = request.args.get('page') if request.args.get('page') else 0
list_data = Card.query.order_by(Card.comment_count.desc()).paginate(int(page), int(per_page), False)
total = list_data.total
items = list_data.items
res = []
for data in items:
res.append({'id': data.id, 'title': data.title, 'list_id': data.list_id, 'description': data.description, 'comment_count': data.comment_count})
return jsonify(message="success", data=res, records=total)
def update(id):
user_id = request.args.get('user_id')
user_info = get_user_info(user_id)
id = request.view_args['id']
req = request.form
check = Card.query.filter(Card.id==id).first()
if str(check.created_by) != str(user_id):
return jsonify(message="You cannot update a card which is not belong to you."), 422
if check:
db.session.query(Card).filter(Card.id == id).update({'title': req['title'], 'description': req['description']})
db.session.commit()
return jsonify(message="successfully updated.")
return jsonify(message="No data found."), 422
def create():
user_id = request.args.get('user_id')
user_info = get_user_info(user_id)
req = request.form
check = Card.query.filter(List.title==req['title']).first()
if check:
return jsonify(message="Card Title Already Taken"), 422
data = Card(title=req['title'], description=req['description'], list_id=req['list_id'], created_by=user_id)
db.session.add(data)
db.session.commit()
res = {'id': data.id,'title': data.title, 'description': data.description, 'list_id': data.list_id}
return jsonify(message="success", data=res)
def show(id):
user_id = request.args.get('user_id')
user_info = get_user_info(user_id)
id = request.view_args['id']
data = Comment.query.filter(List.id==id).first()
list_data = Comment.query.filter(Comment.card_id==req['card_id'])[:3]
data_list = []
for comments in list_data:
data_list.append({'id': comments.id, 'body': comments.body, 'card_id': comments.card_id, 'list_id': comments.list_id})
if not data:
return jsonify(message='No data found.'), 422
res = {'id': data.id,'title': data.title, 'description': data.description, 'cards': data_list}
return jsonify(message='success', data=res)
def update(id):
user_id = request.args.get('user_id')
user_info = get_user_info(user_id)
if user_info.type == 'member':
return jsonify(message="Not authorized"), 422
id = request.view_args['id']
req = request.form
check = List.query.filter(List.id == id).first()
if check:
db.session.query(List).filter(List.id == id).update(
{'title': req['title']})
db.session.commit()
return jsonify(message="successfully updated.")
return jsonify(message="No data found."), 422
def delete(id):
user_id = request.args.get('user_id')
user_info = get_user_info(user_id)
id = request.view_args['id']
req = request.form
check = Card.query.filter(Card.id==id).first()
if str(check.created_by) != str(user_id):
return jsonify(message="You cannot delete a card which is not belong to you."), 422
if check:
db.session.query(Comment).filter(Comment.card_id == id).delete()
db.session.commit()
db.session.query(Card).filter(Card.id == id).delete()
db.session.commit()
return jsonify(message="successfully deleted.")
return jsonify(message="No data found."), 422
def index():
user_id = request.args.get('user_id')
user_info = get_user_info(user_id)
per_page = 20
page = request.args.get('page') if request.args.get('page') else 0
card_id = request.args.get('card_id')
list_data = Comment.query.filter(Comment.card_id == card_id).paginate(
int(page), int(per_page), False)
total = list_data.total
items = list_data.items
res = []
for data in items:
res.append({
'id': data.id,
'body': data.body,
'card_id': data.card_id,
'is_replay_from': data.is_reply_from,
'list_id': data.list_id
})
return jsonify(message="success", data=res, records=total)
