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() # Vérifier les dates de valorisation par compte cursor.execute(""" SELECT account_id, MAX(valuation_date) as max_date FROM daily_account_valuation WHERE account_id != 'TOTAL' GROUP BY account_id ORDER BY max_date DESC LIMIT 10 """) print("Dates max par compte (hors TOTAL):") for row in cursor.fetchall(): print(f" {row[0][:40]:40} | {row[1]}") # Vérifier combien de dates max différentes existent cursor.execute(""" SELECT DISTINCT MAX(valuation_date) as max_date FROM daily_account_valuation WHERE account_id != 'TOTAL' GROUP BY account_id """) unique_dates = cursor.fetchall() print(f"\nNombre de dates max différentes: {len(unique_dates)}") if len(unique_dates) > 1: print("Dates max uniques:") for d in unique_dates: print(f" {d[0]}") # Date max globale (hors TOTAL) cursor.execute(""" SELECT MAX(valuation_date) as max_date FROM daily_account_valuation WHERE account_id != 'TOTAL' """) max_date = cursor.fetchone()[0] print(f"\nDate max globale (hors TOTAL): {max_date}") # Compter combien de comptes ont cette date cursor.execute(""" SELECT COUNT(DISTINCT account_id) as nb_comptes FROM daily_account_valuation WHERE account_id != 'TOTAL' AND valuation_date = ? """, (max_date,)) nb_at_max = cursor.fetchone()[0] # Compter le total de comptes distincts cursor.execute(""" SELECT COUNT(DISTINCT account_id) as total_comptes FROM daily_account_valuation WHERE account_id != 'TOTAL' """) total_comptes = cursor.fetchone()[0] print(f"Comptes à la date max: {nb_at_max} / {total_comptes}") if nb_at_max < total_comptes: print("\n⚠️ PROBLÈME: Tous les comptes n'ont pas la même date de valorisation!") print(" La requête get_accounts_summary va ignorer certains comptes.") else: print("\n✓ OK: Tous les comptes ont la même date max") conn.close()