def get_chats():
"""
Returns chats for a given user_id
"""
result_proxy = db.session.execute(
'''
SELECT
c.id
,c.name
,c.created_at
,c.updated_at
FROM
chats AS c
INNER JOIN
chat_users AS cu
ON
cu.chat_id = c.id
WHERE
cu.user_id = :user_id
ORDER BY
c.updated_at DESC
''',dict(user_id=request.args['user_id'])
)
result = [Chat.from_dict(r).to_dict() for r in result_proxy]
return jsonify(result)
def create_chat():
"""
Create a chat for a given user_id
"""
chat = Chat.from_dict(request.json)
chat_user = ChatUser.from_dict(request.json, request.args(['user_id']))
query_1 = db.session.execute(
'''
INSERT INTO chats (name)
VALUES (name)
RETURNING id
ON CONFLICT DO NOTHING
'''
, dict(name=chat.name)
)
query_2 = db.session.execute(
'''
INSERT INTO chat_users (user_id, chat_id)
VALUES (:user_id, :chat_id)
'''
, dict(user_id=request.args['user_id'], chat_id=1)
)
db.session.commit()
