
    ܴ
j]                    N    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d	S )    )annotations)get_budget_overview)confirm_budget_plan_itemcreate_budget_plan_item_preview)connect_memory)apply_migrationsreturnNonec            	        t                      } t          |            |                     d                                          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 d S )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"   	   sJ   DT,,^__hhjjklmK-d"(&+5 5  G T79#5666"433H()X5555()V3333*+x7777O$4444'(+N;xGGGG'(+,ABfLLLL01R777777    N)r	   r
   )
__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 G G G G G j j j j j j j j : : : : : : > > > > > >8 8 8 8 8 8r#   