Nwg)ddlmZddlmZmZddlmZmZmZddl m Z ddl m Z m Z dZGddeZGd d ej ZGd d Zy ))settings) connectionmodels)OuterRefQuerySetSubquery)timezone)get_app_model_primary_key_nameget_change_reason_from_object_historycXeZdZdZfdZdZfdZdZdZfdZ fdZ d Z xZ S) HistoricalQuerySetaS Enables additional functionality when working with historical records. For additional history on this topic, see: - https://github.com/jazzband/django-simple-history/pull/229 - https://github.com/jazzband/django-simple-history/issues/354 - https://github.com/jazzband/django-simple-history/issues/397 ct||i|d|_d|_|jj j jj|_ y)NF) super__init__ _as_instances_as_ofmodel instance_type_metapkattname_pk_attrselfargskwargs __class__s M/var/www/horilla/myenv/lib/python3.12/site-packages/simple_history/manager.pyrzHistoricalQuerySet.__init__sG $)&)"  006699AA ct|js|jd}d|_|S|j}|S)z Return a queryset that generates instances instead of historical records. Queries against the resulting queryset will translate `pk` into the primary key field of the original type. Returns a queryset. -) history_typeT)rexclude_clone)rresults r as_instanceszHistoricalQuerySet.as_instances s>!!\\s\3F#'F  [[]F r c~|jr"d|vr|jd||j<t||i|S)a If a `pk` filter arrives and the queryset is returning instances then the caller actually wants to filter based on the original type's primary key, and not the history_id (historical record's primary key); this happens frequently with DRF. r)rpoprrfilterrs rr*zHistoricalQuerySet.filter/s?   $&.$*JJt$4F4== !w~t.v..r ctj}|dk(rwi}|jddD]>}t||j|vs|j |t||j<@|j |j}|S|dk(r[|j|jddj|jjdd}|j |}|S|j d i|jt|jijddjdd d }|j t|}|S) z Ensures results in the queryset are the latest historical record for each primary key. Deletions are not removed. Returns a queryset. mysqlz -history_datez-pk)history_id__in postgresqlrT)flatN) rvendororder_bygetattrrrr*valuesdistinct values_listrr)rbackend history_idsitemlatest_historicslatest_pk_attr_historic_idss rlatest_of_eachz!HistoricalQuerySet.latest_of_each:sR## g K ou= H4/{B@DKdmm <= H ${{+:L:L:N{O " ! $ dmm_eD$--(T- ( ${{:U{V   Gt}}ht}}.EFG/51bq" ( ${{'(CD +   r c|jjDcgc](}t|tjr |j *}}|j |Scc}w)z A convenience method that calls ``select_related()`` with all the names of the model's history-tracked ``ForeignKey`` fields. )rtracked_fields isinstancer ForeignKeynameselect_related)rfield field_namess r$_select_related_history_tracked_objsz7HistoricalQuerySet._select_related_history_tracked_objs^sY22 %!2!23 JJ  #t""K00  s-Act|}|j|_|j|_|j|_|SN)rr%rrr)rcrs rr%zHistoricalQuerySet._clonejs7 GN ,,;;]] r cBt||jyrH)r _fetch_all _instanceizerrs rrKzHistoricalQuerySet._fetch_allqs  r cL|jr|jrt|jd|jrb|jDcgc]}|jc}|_|jD])}t |t }t|d|j+yyyycc}w)z Convert the result cache to instances if possible and it has not already been done. If a query extracts `.values(...)` then the result cache will not contain historical objects to be converted. rrN) _result_cacherr@rinstancer4 SIMPLE_HISTORY_REVERSE_ATTR_NAMEsetattrr)rr:historics rrLzHistoricalQuerySet._instanceizeus   ""4--a0$**=<@# "Ps B!) __name__ __module__ __qualname____doc__rr'r*r=rFr%rKrL __classcell__rs@rrrs2B  /" H 19r rcPeZdZdfd ZfdZdZdZdZ ddZxZ S) HistoryManagerc>t|||_||_yrH)rrrrP)rrrPrs rrzHistoryManager.__init__s    r c t|SrH)r get_querysetrMs rget_super_querysetz!HistoryManager.get_super_querysetsw#%%r c|j}|j|St|j}|jjdi||jjiS)Nr1)r_rPr r*r)rqskey_names rr^zHistoryManager.get_querysets[  $ $ & == I1$--@/t&&(//O8T]]=M=M2NOOr c|js8tdj|jjj g}|jj D]V}t|tjr|j|jdz<|j|jXt|} |jj|d}|jj"di|S#t$r=|jj!d|jjj zwxYw)zX Returns the most recent copy of the instance available in the history. z.Can't use most_recent() without a {} instance._idrz%s has no historical record.r1)rP TypeErrorformatrr object_namer?r@rrAappendrBtupler^r5 IndexError DoesNotExistr)rtmprDfieldsr5s r most_recentzHistoryManager.most_recents}}@GGJJ$$00  ZZ.. 'E%!2!23 5::-. 5::&  ' s /T&&(//8;F 't}}&&000  --,,.1D1D1P1PP  s  C>>AEcR|jj|}|js7t|tr||_|j j}|S |d}|jdk(r<|jjd|jjjz|j}t|t}t|d||S#t$r=|jjd|jjjzwxYw)a Get a snapshot as of a specific date. When this is used on an instance, it will return the instance based on the specific date. If the instance did not exist yet, or had been deleted, then a DoesNotExist error is railed. When this is used on a model's history manager, the resulting queryset will locate the most recent historical record before the specified date for each primary key, generating instances. If the most recent historical record is a deletion, that instance is dropped from the result. A common usage pattern for querying is to accept an optional time point `date` and then use: `qs = .history.as_of(date) if date else .objects` after which point one can add filters, values - anything a normal queryset would support. To retrieve historical records, query the model's history directly; for example: `qs = .history.filter(history_date__lte=date, pk=...)` To retrieve the most recent historical record, including deletions, you could then use: `qs = qs.latest_of_each()` )history_date__lterz%s had not yet been created.r"z%s had already been deleted.r)r^r*rPr@rrr=r'rjrkrrgr#r4rQrR)rdatequeryset history_objr&rSs ras_ofzHistoryManager.as_ofs :$$&---E}}($67"&..0==?HO "1+K  # #s *--,,.1D1D1P1PP %%6#CD(D)  --,,.1D1D1P1PP  s %C AD&c xttddsyd}|rd}g} |D]} t| d|xs|jj| } |jd t| d|xst j | t | xs||d|jjD cic]#} | jt| | j%c} |xsi} t|jd r| j| _ | j| |jjj| | Scc} w) z Bulk create the history for the objects specified by objs. If called by bulk_update_with_history, use the update boolean and save the history_type accordingly. SIMPLE_HISTORY_ENABLEDTN+~ _history_user _history_date) history_date history_userhistory_change_reasonr#history_relation) batch_sizer1)r4rrget_default_history_userr nowr r?rhasattrrhistory_relation_idrhobjects bulk_create)robjsrupdate default_userdefault_change_reason default_datecustom_historical_attrsr#historical_instancesrPr|rDrows rbulk_history_createz"HistoryManager.bulk_history_createsIx!94@  L! -H"M C CH ML $** $o|/Mx||~*&CH&M')() "&!:!:MM78U]]#CC +0b Ctzz#56*2++' ' ' ,- -0zz!!-- Z.  s#(D7rH)NFNNN) rTrUrVrr_r^rnrtrrXrYs@rr[r[s7! &P142n  $1 r r[ceZdZeefdZdZy)HistoryDescriptorc.||_||_||_yrH)rqueryset_class manager_class)rrmanagerrrs rrzHistoryDescriptor.__init__s &$r cn|jj|j|j|SrH)r from_querysetrr)rrPowners r__get__zHistoryDescriptor.__get__s1Dt!!//0C0CD JJ  r N)rTrUrVr[rrrr1r rrrs&4?Q%  r rN) django.confr django.dbrrdjango.db.modelsrrr django.utilsr simple_history.utilsr r rQrManagerr[rr1r rrsM (99!$. s9s9lP V^^P f   r