app.py

from flask import Flask, render_template, request, jsonify
import sqlite3, os

app = Flask(__name__)
DB_PATH = 'database.db'

def init_db():
# ... (existing code) ...
    c.execute('''
        CREATE TABLE IF NOT EXISTS transacoes (
# ... (existing code) ...
        )
    ''')
    conn.commit()
# ... (existing code) ...
init_db()

@app.route('/')
# ... (existing code) ...
    return render_template('index.html')

@app.route('/financas')
def financas():
    return render_template('financas.html')

@app.route('/tarefas')
# ... (existing code) ...
    return render_template('tarefas.html')

@app.route('/api/transacoes', methods=['POST'])
def add_transacao():
# ... (existing code) ...
    c.execute('INSERT INTO transacoes (tipo, valor, descricao) VALUES (?, ?, ?)',
              (data['tipo'], data['valor'], data['descricao']))
    conn.commit()
# ... (existing code) ...
    return jsonify({'status':'ok'})

@app.route('/api/dashboard', methods=['GET'])
def dashboard_data():
# ... (existing code) ...
    c = conn.cursor()

    c.execute("SELECT SUM(valor) FROM transacoes WHERE tipo='receita'")
# ... (existing code) ...
    c.execute("SELECT SUM(valor) FROM transacoes WHERE tipo='despesa'")
    total_despesas = c.fetchone()[0] or 0

    saldo = total_receitas - total_despesas

    c.execute("SELECT tipo, valor, descricao FROM transacoes ORDER BY id DESC LIMIT 5")
# ... (existing code) ...
    conn.close()

    return jsonify({
# ... (existing code) ...
        "despesas": total_despesas,
        "saldo": saldo,
        "recentes": recentes
    })

if __name__ == '__main__':
    # Lê a porta do ambiente (fornecida pelo Hugging Face)
    port = int(os.environ.get('PORT', 7860))
    # debug=True causa conflitos, então usamos debug=False
    app.run(host='0.0.0.0', port=port, debug=False)