app.py

from flask import Flask, render_template, request, redirect, url_for
from flask_mysqldb import MySQL

app = Flask(__name__)

# Configuração do MySQL
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_PASSWORD'] = '1234'
app.config['MYSQL_DB'] = 'tasks'
mysql = MySQL(app)

# Rota para exibir a lista de tarefas
@app.route('/')
def index():
    cur = mysql.connection.cursor()
    cur.execute("SELECT * FROM tasks")
    tasks = cur.fetchall()
    cur.close()
    return render_template('index.html', tasks=tasks)

# Rota para adicionar uma nova tarefa
@app.route('/add', methods=['POST'])
def add_task():
    if request.method == 'POST':
        description = request.form['description']
        due_date = request.form['due_date']
        cur = mysql.connection.cursor()
        cur.execute("INSERT INTO tasks (description, due_date) VALUES (%s, %s)", (description, due_date))
        mysql.connection.commit()
        cur.close()
        return redirect(url_for('index'))
    
# Rota para atualizar uma tarefa
@app.route('/update/<int:task_id>', methods=['POST'])
def update_task(task_id):
    if request.method == 'POST':
        description = request.form['description']
        due_date = request.form['due_date']
        status = request.form['status']
        cur = mysql.connection.cursor()
        cur.execute("UPDATE tasks SET description=%s, due_date=%s, status=%s WHERE id=%s", (description, due_date, status, task_id))
        mysql.connection.commit()
        cur.close()
        return redirect(url_for('index'))
    
# Rota para excluir uma tarefa
@app.route('/delete/<int:task_id>', methods=['POST'])
def delete_task(task_id):
    if request.method == 'POST':
        cur = mysql.connection.cursor()
        cur.execute("DELETE FROM tasks WHERE id=%s", (task_id,))
        mysql.connection.commit()
        cur.close()
        return redirect(url_for('index'))


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