Wealthfolio MCP Server

import sqlite3 DB_PATH = r"C:\Users\miche\AppData\Roaming\com.teymz.wealthfolio\app.db" conn = sqlite3.connect(DB_PATH) cursor = conn.cursor() # Trouver la date max globale cursor.execute("SELECT MAX(valuation_date) FROM daily_account_valuation") max_date_global = cursor.fetchone()[0] print(f"Date max globale: {max_date_global}") # Trouver la date max pour TOTAL cursor.execute("SELECT MAX(valuation_date) FROM daily_account_valuation WHERE account_id = 'TOTAL'") max_date_total = cursor.fetchone()[0] print(f"Date max pour TOTAL: {max_date_total}") # Vérifier ce que retourne la requête actuelle (bugguée) cursor.execute(""" SELECT CAST(total_value AS REAL) as total_value, base_currency, valuation_date FROM daily_account_valuation WHERE account_id = 'TOTAL' AND valuation_date = (SELECT MAX(valuation_date) FROM daily_account_valuation) """) result = cursor.fetchone() print(f"\nRequête actuelle (bugguée):") print(f" Résultat: {result}") # Vérifier ce que retourne la requête corrigée cursor.execute(""" SELECT CAST(total_value AS REAL) as total_value, base_currency, valuation_date FROM daily_account_valuation WHERE account_id = 'TOTAL' AND valuation_date = (SELECT MAX(valuation_date) FROM daily_account_valuation WHERE account_id = 'TOTAL') """) result_fixed = cursor.fetchone() print(f"\nRequête corrigée:") print(f" Résultat: {result_fixed}") print(f" Valeur: {result_fixed[0]:,.2f} {result_fixed[1]}") conn.close()