def tomessagedoread():
to_id = request.form.get('to', -1)
print(to_id)
query = "UPDATE messages SET `status`= '1' where from_id = %s and to_id = %s AND `status` = '0'"
cursor = connection.cursor()
cursor.execute(query, (session['id'], to_id))
connection.commit()
cursor.close()
return "ok"
def value_changed(message):
now = datetime.now()
message['pub_date'] = now.strftime("%Y-%m-%d %H:%M:%S")
query = "INSERT INTO messages(from_id, to_id, message) VALUES(%s, %s, %s)"
cursor = connection.cursor()
cursor.execute(query,
(message['from_id'], message['who'], message['data']))
connection.commit()
cursor.close()
result = {}
if message['yollayan'] == message['who']:
who = '<span class="badge badge-success" role="alert"> <i class="fas fa-long-arrow-alt-left"></i> ME:</span>'
else:
who = '<span class="badge badge-warning" role="alert"> <i class="fas fa-long-arrow-alt-right"></i> YOU:</span>'
result[
'template'] = '<li class="list-group-item text-right" id=""> {}: {} - <span class="badge badge-secondary"><i class="far fa-clock"> {}</i></span></li>'.format(
who, Markup.escape(message['data']), message['pub_date'])
result['fromto'] = str(message['from_id']) + str(message['who'])
result['tofrom'] = str(message['who']) + str(message['from_id'])
emit('update value', result, broadcast=True)
def insert_match_result(self):
insert_match_result_query = f"INSERT INTO match_results(home_team, away_team, fans, hts, ats)" \
f"VALUES('%s', '%s', %s, %s, %s);" % \
(self.home_team, self.away_team, self.fans, self.hts, self.ats)
cursor.execute(insert_match_result_query)
connection.commit()
from db_config import cur
from db_config import connection
cur.execute('''
CREATE TABLE trophies(
id BIGSERIAL PRIMARY KEY,
trophies_name VARCHAR(50) NOT NULL,
times VARCHAR(5) NOT NULL,
season VARCHAR(10) NOT NULL,
wins VARCHAR(5) NOT NULL,
loses VARCHAR(5) NOT NULL,
draws VARCHAR(5) NOT NULL,
goal_difference VARCHAR(10) NOT NULL,
points VARCHAR(5) NOT NULL
);
''')
connection.commit()
print("Create Database")