tag

#!/usr/bin/python3

import telegram
import json
import random
import sqlite3

yabk = 255314645
#tag = -264625770
tag = yabk
dbase = '/home/pi/telegramBots/tag.db'


def main():
    conn = sqlite3.connect(dbase)
    c = conn.cursor()
    with open('/home/pi/telegramBots/params.json') as f:
        params = json.load(f)
    bot = telegram.Bot(token='469800488:AAH7VTeFLEQBUtWgdDvqu-RMh1Q3rAgHo8c')

    bot.send_message(chat_id=tag, text='`'+get_leaderboard()+'`',
        parse_mode=telegram.ParseMode.MARKDOWN)

    if random.randrange(0, params['weeks_left']) < params['to_be_played']:
        bot.send_message(chat_id=tag, text=params['it'] + ' lovi')
        bot.send_message(chat_id=tag, text='Let the games begin')
        c.execute('''INSERT INTO tags VALUES(datetime("now"), null, "yabk")''')
    else:
        bot.send_message(chat_id=tag, text='Nista ovaj tjedan')
        bot.send_message(chat_id=tag, text=params['it'] + ' ostaje pizda')

    conn.commit()
    conn.close()


def get_leaderboard():
    """Return formated string representing the current leaderboard"""
    conn = sqlite3.connect(dbase)
    c = conn.cursor()

    c.execute('''SELECT * FROM player ORDER BY timeIt DESC''')
    result = c.fetchall()
    formated = '    nick       timeIt(seconds)\n'

    for i in range(len(result)):
        formated += ('{:2}. {:7} {:5}\n'.format(i+1, result[i][0], result[i][4]))

    return formated


if __name__ == '__main__':
    main()