def post(self):
conn = sqlite3.connect('lbg.db')
cursor = conn.cursor()
messages = cursor.execute('select * from messages')
res = []
for message in messages:
m = Message(message)
res.append(m.getFullInfo())
return jsonify(res)
def post(self):
print(request.json)
conn = sqlite3.connect('lbg.db')
cursor = conn.cursor()
mId = cursor.execute('select max(id) from messages')
for MmId in mId:
pass
if MmId[0] is not None:
mId = int(MmId[0]) + 1
else:
mId = 0
message_text = request.json['message_text']
sender_id = request.json['sender_id']
sender_login = request.json['sender_login']
dt = request.json['dt']
m = Message([mId, dt, sender_id, message_text, sender_login])
insertIntoTable(cursor, 'messages', m.addToDB())
conn.commit()
return jsonify(m.getFullInfo())
