
    ܴ
j]                    L    d dl mZ d dlmZ d dlmZmZ d dlmZ d dl	m
Z
 ddZy)	    )annotations)get_budget_overview)confirm_budget_plan_itemcreate_budget_plan_item_preview)connect_memory)apply_migrationsc            	     p   t               } t        |        | j                  d      j                         d   }t	        | d|dddd      }t        | |d          t        | d      }|d	   dk(  sJ |d
   dk(  sJ |d   dk(  sJ |d   dk(  sJ |d   d   d   dk(  sJ |d   d   d   dk(  sJ |d   g k(  sJ y )Nz=SELECT category_id FROM budget_categories WHERE name='Wohnen'r   z2026-01zSynthetischer Wohnplanz100.00excel_seed_dry_run)
plan_monthcategory_idnamemonthly_amount_chfsource_typepayloadplanned_budget_chfactual_expense_chfz0.00remaining_budget_chfbudget_status
no_actualsbudget_categoriesbudget_monthactual_year_to_dateuncategorized_transactions)r   r   executefetchoner   r   r   )connr   previewoverviews       (tests/unit/test_budget_overview_plans.pyEtest_budget_overview_includes_confirmed_budget_plan_with_zero_actualsr    	   s   DT,,^_hhjklmK-d"(&+5 G T79#56"43H()X555()V333*+x777O$444'(+N;xGGG'(+,ABfLLL01R777    N)returnNone)
__future__r   'jarvis_finance.services.budget_overviewr   $jarvis_finance.services.budget_plansr   r   jarvis_finance.storage.databaser   !jarvis_finance.storage.migrationsr   r     r!   r   <module>r*      s    " G j : >8r!   