import psycopg2

class utenti(object):
    def registra(self, email, nickname, passwrd):
        conn = psycopg2.connect("dbname='FANTAGOL' user='tonyfrancis' host='localhost' password='marianeri'")
        cur = conn.cursor()
        cur.execute("INSERT INTO Giocatori (email, nickname, passwrd) VALUES (%s, %s, %s)", (email, nickname, passwrd))
        conn.commit()
        cur.close()
        conn.close()