def insert_message_info(state):
response = requests.get('https://api.cai.tools.sap/connect/v1/conversations/' + data['conversation']['id'],
headers={'Authorization': '54187a3945f3af9ea86d40ebca0400f2'}
)
d = response.json()
l = ''
for i in range(len(d['results']['messages'])):
l = l + ' ' + str(d['results']['messages'][i]['attachment']['content'])
len_of_message = len(re.split('Thank you!!! | Took a note on that ', l)[-1].split(' '))
my_con = DBConnect("d51dpnoammut78","mfeteccnqkvtor","8c505e55eb950c9b8a5a8a3fb3118b103fc7dabac9b7eb0737b156c9f695fad5",
'ec2-54-217-235-87.eu-west-1.compute.amazonaws.com')
if state == 'no':
my_con.db_connection()
my_con.cur.execute("INSERT INTO messages_info(bad_mess_len) VALUES(%s);", [len_of_message])
my_con.cur.execute("SELECT ROUND(AVG(bad_mess_len)) FROM messages_info;")
av = my_con.cur.fetchone()[0]
my_con.cur.execute("UPDATE messages_stats SET bad_mess_avr = %s",[av])
my_con.end_connection()
elif state == 'yes':
my_con.db_connection()
my_con.cur.execute("INSERT INTO messages_info(good_mess_len) VALUES(%s);", [len_of_message])
my_con.cur.execute("SELECT ROUND(AVG(good_mess_len)) FROM messages_info;")
av = my_con.cur.fetchone()[0]
my_con.cur.execute("UPDATE messages_stats SET good_mess_avr = %s",[av])
my_con.end_connection()
