def get_member_ranking(username):
conn = Connection()
member = conn.query_sql("SELECT * FROM members where username = '******'")
ranked = sorted([(x[0], x[1], find_in_pi(x[2]))
for x in conn.get_pi_members()],
key=lambda tup: tup[2])
if member:
return str(
ranked.index((member[0], member[1], find_in_pi(member[2]))) +
1) + "°: " + member[
1] + ", respectiva posição nos dígitos de π: " + str(
member[2]) + "\n"
else:
generate_member_ranking(username)
member = conn.query_sql("SELECT * FROM members where username = '******'")
ranked = sorted([(x[0], x[1], find_in_pi(x[2]))
for x in conn.get_pi_members()],
key=lambda tup: tup[2])
return str(
ranked.index((member[0], member[1], find_in_pi(member[2]))) +
1) + "°: " + member[
1] + ", respectiva posição nos dígitos de π: " + str(
member[2]) + "\n"
def get_daily_ranking():
conn = Connection()
msg = ''
ranked = sorted([(x[0], x[1], find_in_pi(x[2]))
for x in conn.get_pi_members()],
key=lambda tup: tup[2])
for rank in ranked:
msg += str(ranked.index(rank) + 1) + "°: " + rank[
1] + ", respectiva posição nos dígitos de π: " + str(
rank[2]) + "\n"
return msg