import _sqlite3
from datetime import date

def query_action(f):
    def wrapper(self):
        param, query = f(self)
        with self.conn:
            self.c.execute(query, param)
            row = self.c.fetchone()
            return row
    return wrapper


class Training:
    report = None

    def __init__(self, id_player, date=date.today() ,*args):
        self.id = id_player
        self.date_ = date
        self.conn = _sqlite3.connect("database.db")
        self.conn.row_factory = _sqlite3.Row
        self.c = self.conn.cursor()
        self.wages = []
        self.rate = self.get_rate()


    @query_action
    def get_rate(self):
        param = (self.id,)
        query = "SELECT rate from player WHERE id = ? "
        return param, query