jq) dZddlmZddlmZddlmZddlmZmZm Z m Z m Z m Z m Z mZmZmZddlmZddlmZeZedej,ed ee d d ed ee dd Zedej,ed ee d d edee dd ZGddeZGddeZGddeZGddeZGddeZGddeZGddeZGd d!eZ y")#z' SQLAlchemy ORM models for TripTalley. )datetime)Decimal)Optional) ColumnIntegerStringDateTimeDateNumeric ForeignKeyTableEnumUniqueConstraint)declarative_base) relationship user_groupuser_idusers.idT primary_keygroup_id groups.id user_triptrip_idtrips.idceZdZdZdZeedZeeddddZ eeddZ eeddZ eed d Z ee ejd Zee ejejd ZededZededZeddZeddZeddZeddZdefdZy)Userz User account model. Users can belong to multiple groups and trips. Each trip has a settlement currency preference. usersTrF)uniquenullableindexr!USDdefaultr'r!r'onupdater!Group secondaryback_populatesTripPaymentzPayment.from_user_id foreign_keyszPayment.to_user_idExpensepayerr.ExpenseParticipantuserreturncVd|jd|jd|jdS)Nz )idemail display_nameselfs 5/srv/projects/triptalley/backend/app/models/models.py__repr__z User.__repr__=s-477)9TZZL $BSBSATTWXXN)__name__ __module__ __qualname____doc__ __tablename__rrr;rr<hashed_passwordr= home_currencyr rutcnow created_at updated_atrrgroupsrtrips payments_madepayments_received expenses_paidexpense_participantsstrrArBr@rr!s M T *B 6#;te4 HEVC[59O&+6L6!9e4M(//EJJ(//HOO!&(J'Z PF 9W ME 9OPM$Y=QR 7CM'(s r@rAzExpenseParticipant.__repr__s81$//1BC<<.1A1A0B"F GrBN)rCrDrErFrGrrr rwrrxr rrJrKrrer7rSrArTrBr@r6r6s} +MM!:MJWj4$GG51K(//EJJ9^DG /E FDG#GrBr6c&eZdZdZdZeedZeeddZ ee ddZ ee ddZ eedZ eedZee d Zeeej$ Zed d d dfZdefdZedefdZy)FXRatez Cached FX rate for historical lookups. Stores rates by date, from_currency, to_currency to avoid repeated API calls. fx_ratesTrF)r!r"r$r#2r&date from_currency to_currencyuq_fx_rate_lookup)rZr8c d|jd|jd|jd|jd|jdd S)Nz s r@rAzFXRate.__repr__sM {"T-?-?,@DDTDTCUUV??#1T__S$9= >rBcpt|jt|jtdz zS)zGet rate as Decimal.i@B)rrrr>s r@ rate_decimalzFXRate.rate_decimals+t''$//*BWWEU*UUUrBN)rCrDrErFrGrrr;r r}rr~rrrsourcer rrJ fetched_atr__table_args__rSrArtrrrTrBr@rzrzs M T *B $d 3D6!9u5MU3K%0J%0JF2J F(//:J -0 2N >#>VgVVrBrzceZdZdZdZeedZeeeddZ eeeddZ eeeddZ eedZ ee d dZee d d Zee d Zeeej&dZeeZedZede gZede gZdefdZy)r0zc Settlement payment record. Stores actual transfers made to settle trip balances. paymentsTrrFr#rr$pendingr&rr(r/rr1r8c d|jd|jd|jd|jd|j|j d S)Nz s r@rAzPayment.__repr__ sTtwwiz$,,r$$%S(94;L;L:Mdmm_\^` arBN)rCrDrErFrGrrr;r rrrrrrstatus referencer rrJrK completed_atrr] from_userto_userrSrArTrBr@r0r0s M T *BWj4uEG':j#9EJLJ!7%HJ'E2LfQi%0HF2J 2Fvc{#I(//EJJ(#L  DV<.AI6 =Ga#arBr0cBeZdZdZdZeedZeeeddZ eeeddZ ee d dd Z ee dZee ZeeedZee ej$d Zed Zed e gZed egZdefdZy) TripInvitezj Trip invitation with signed link. Enables secure invitation sharing via expiring links. trip_invitesTrrFr#r$)r r!r(r/rr1r8cVd|jd|jd|jdS)Nz