from flask import Flask, request, jsonify
from flask_cors import CORS
import mysql.connector

app = Flask(__name__)
CORS(app)

config = {
    "host": "10.110.61.97",
    "user": "admin",
    "password": "Azert123!",
    "database": "app_db"
}

db = mysql.connector.connect(**config)
cursor = db.cursor()
cursor.execute("CREATE TABLE IF NOT EXISTS items (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL)")
db.commit()

@app.route('/api/items', methods=['GET'])
def get_items():
    cursor.execute("SELECT * FROM items")
    results = cursor.fetchall()
    return jsonify(results)

@app.route('/api/items', methods=['POST'])
def add_item():
    data = request.get_json()
    name = data.get('name', '').strip()
    if not name:
        return jsonify({"error": "Le nom est requis"}), 400
    
    cursor.execute("INSERT INTO items (name) VALUES (%s)", (name,))
    db.commit()
    return jsonify({"message": "Élément ajouté"}), 201

if __name__ == '__main__':
    app.run(host='0.0.0.0', port=5000)