jnddlmZddlmZddlmZddlmZdZde defdZ d ed e dd fd Z d edd fd Z y ))select)db)Category) Transactionctjjdjtjj tj jS)z7All active categories: system first, then alphabetical.T) is_active)rquery filter_byorder_by is_systemdescnameall9/var/www/html/financials/app/services/category_service.pyget_all_activers@ NN YY & Xh((--/ ? SUrrreturncF|j}|s tdt|dkDr tdtjj |j rtd|dt|dd }tjj||S) zCAdd a new custom category. Raises ValueError on validation failure.Category name is required.2z,Category name must be 50 characters or less.rA category named '' already exists.FT)rr r) strip ValueErrorlenrr r firstrsessionadd)rcats r create_customr"s ::CJJNN3 Jrcategorynew_nameNc.|j}|s tdt|dkDr tdtjj |j }|r(|j|jk7rtd|d||_y)z;Rename a category. Raises ValueError on validation failure.rrz#Name must be 50 characters or less.rrrN) rrrrr r ridr)r#r$conflicts rrenamer(s~~H 566 8}r>??~~''X'6<<>HHKK8;;.-hZ7HIJJHMrcX|jr tdtjj t t jjt j|jk(jdjdu}|r tdd|_ y)zESoft-delete a custom category. Raises ValueError if system or in use.z$System categories cannot be deleted.Nu&Category in use — cannot be deleted.F) r rrrexecuterrr&where category_idlimitrr)r#has_txnss r soft_deleter0*s?@@zz!!{~~$$[%<%< %KLRRSTU egTHABBHr) sqlalchemyrapp.extensionsrapp.models.categoryrapp.models.transactionrrstrr"r(r0rrrr6sV(.    X    ( t r