app.py

# app.py
from flask import Flask, render_template, request, redirect, url_for, session, jsonify
from werkzeug.security import generate_password_hash, check_password_hash
import sqlite3
import random

app = Flask(__name__)
app.secret_key = 'simone'

DB = 'tic_tac_toe.db'

def init_db():
    with sqlite3.connect(DB) as conn:
        c = conn.cursor()
        c.execute('''CREATE TABLE IF NOT EXISTS users (
                                                          id INTEGER PRIMARY KEY,
                                                          username TEXT UNIQUE NOT NULL,
                                                          password TEXT NOT NULL,
                                                          wins INTEGER DEFAULT 0
                     )''')
        conn.commit()  # facoltativo, ma buona pratica


@app.route('/')
def home():
    if 'user_id' in session:
        return redirect(url_for('game'))
    return redirect(url_for('login'))




#codice per la registrazione e login (tommy)
@app.route('/register', methods=['GET', 'POST'])
def register():
    
    #Gli utenti possono registrarsi inviando un modulo con username e password, in seguito la password viene cifrata per essere memorizzata nel database.
    if request.method == 'POST':
        username = request.form['username']
        password = generate_password_hash(request.form['password'])
        with sqlite3.connect(DB) as conn:   #apre una connessione al database SQLite
            c = conn.cursor()   #serve per eseguire operazioni SQL sul database
            try:
                c.execute('INSERT INTO users (username, password) VALUES (?, ?)', (username, password)) #prova a inserire il nuovo utente nella tabella users
                conn.commit()
                return redirect(url_for('login'))
            except sqlite3.IntegrityError:
                return 'Username already exists.'
    return render_template('register.html')

 #TOMMY
@app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        username = request.form['username']
        password = request.form['password']

        with sqlite3.connect(DB) as conn:   #connessione al database e creazione del cursore
            c = conn.cursor()

            c.execute('SELECT id, password FROM users WHERE username = ?', (username,)) #cerca nel database l’utente con quell’username
            user = c.fetchone()

            if user and check_password_hash(user[1], password):
                session['user_id'] = user[0]
                session['username'] = username
                return redirect(url_for('game'))
            else:
                return 'Invalid credentials.'
    return render_template('login.html')

 #tommy
@app.route('/logout')
def logout():

    session.clear() #rimuove tutte le variabili salvate nella sessione
    
    return redirect(url_for('login'))





@app.route('/game')
def game():
    if 'user_id' not in session:
        return redirect(url_for('login'))
    return render_template('game.html', username=session['username'])

#cc
@app.route('/ai_move', methods=['POST'])
def ai_move():
    board = request.json['board']
    empty = [i for i, cell in enumerate(board) if cell == '']
    if empty:
        move = random.choice(empty)
        return jsonify({'move': move})
    return jsonify({'move': -1})



# codice per la classifica nico
@app.route('/record_win', methods=['POST'])
def record_win():
    winner = request.json['winner']
    if 'user_id' in session and winner == session['username']:
        with sqlite3.connect(DB) as conn:
            c = conn.cursor()
            c.execute('UPDATE users SET wins = wins + 1 WHERE id = ?', (session['user_id'],))
            conn.commit()
    return ('', 204)
#cc nico
@app.route('/leaderboard')
def leaderboard():
    with sqlite3.connect(DB) as conn:
        c = conn.cursor()
        c.execute('SELECT username, wins FROM users ORDER BY wins DESC LIMIT 10')
        leaders = c.fetchall()
    return render_template('leaderboard.html', leaders=leaders)



if __name__ == '__main__':
    init_db()
    app.run(debug=True)