fei "dZddlmZmZddlmZddlZddlmZmZddl m Z ddl m Z ddl mZmZmZdd lmZdd lmZej*eZd e d ed edefdZd e dedeefdZdd e dededeefdZd e ded edefdZd e dedefdZy)zG Generic Notes Services - For handling notes across different entities )ListOptional)datetimeN)selectupdate)Session)Note) NoteSchemaNoteCreateRequestSchemaNoteUpdateRequestSchema) APIException)statusdbpayload created_by_idreturnc|K t|j|}|j||j|j |t j |S#t$rN}|jtjd|ttitjdd}~wwxYww)zCreate a new note.) descriptionrzError creating note: zCould not create notemoduleerror status_codemessageN)r raddcommitrefreshr model_validate Exceptionrollbackloggerrr __name__rHTTP_500_INTERNAL_SERVER_ERROR)rrrnotees G/var/www/html/hwPaymentPortal-be-uat/backend/src/apps/notes/services.py create_noter&s   3 3=Q t   4((..    ,QC01==+    s*B<AA"!B<" B9+A B44B99B<note_idcKttjtj|k(tjj d}|j |j}|rtj|SdSw)zRetrieve a note by ID.N) rr whereid deleted_atis_executescalar_one_or_noner r)rr'stmtr#s r%get_note_by_idr0+sc $<  dgg0$//2E2Ed2K LD ::d  . . 0D.2: $ $T *<rZs"%"+ff,   8 $  $    .=W=s=x 7K= 9 9 9 9T*EU 9+++%+ +8#$rY