ƟlQ? R d dl T d dlmZ G d de Z G d de ZdS ) )*) JSONFieldc e Zd Z e ed g Z e Z e Z e Z
e Z dS )
BaseChangeLogzDEFAULT CURRENT_TIMESTAMP) constraintsN)
__name__
__module__ __qualname__
DateTimeFieldSQL timestamp TextFieldactiontable IntegerField primary_keyr changes z/builddir/build/BUILD/imunify360-venv-2.6.2/opt/imunify360/venv/lib/python3.11/site-packages/playhouse/sqlite_changelog.pyr r sZ
33/J+K+K*LMMMI
Y[[F IKKE ,..KikkGGGr r c ^ e Zd ZeZdZdZdZd
dZddZ ddZ
d Z e d
Z
dd ZdS ) ChangeLoga CREATE TRIGGER IF NOT EXISTS %(table)s_changes_%(action)s
AFTER %(action)s ON %(table)s
BEGIN
INSERT INTO %(change_table)s
("action", "table", "primary_key", "changes")
SELECT
'%(action)s', '%(table)s', %(new_old)s."%(primary_key)s", "changes"
FROM (
SELECT json_group_object(
col,
json_array(
case when json_valid("oldval") then json("oldval")
else "oldval" end,
case when json_valid("newval") then json("newval")
else "newval" end)
) AS "changes"
FROM (
SELECT json_extract(value, '$[0]') as "col",
json_extract(value, '$[1]') as "oldval",
json_extract(value, '$[2]') as "newval"
FROM json_each(json_array(%(column_array)s))
WHERE "oldval" IS NOT "newval"
)
);
END;z3DROP TRIGGER IF EXISTS %(table)s_changes_%(action)s)INSERTUPDATEDELETE changelogc " || _ || _ d S N)db
table_name)selfr r s r __init__zChangeLog.__init__7 s $r Nc
, g }|j j D ]q}|j r
|
|j |v r|j }|sdnd|z }|sdnd|z } t |t r|rd| z } |rd|z }| d|d| d|d rd | S ) NNULLzNEW."%s"zOLD."%s"zjson(%s)z json_array('z', z, )) _meta
sorted_fieldsr name column_name
isinstancer appendjoin)
r! modeluse_olduse_new skip_fields col_arrayfieldcolumnnewolds
r _build_column_arrayz ChangeLog._build_column_array; s [. N NE
&5:+D+D&F '@&&Z&-@C '@&&Z&-@C%++
3 2*s"2C2*s"2C 666333 L M M M Myy###r c || j v sJ |dk }|dk }| |||| }| j |j j ||dk rdnd|j j j || j dz S )Nr r NEWOLD)r r new_oldr column_array change_table)_actionsr6 templater& r r r) )r! r- r r0 r. r/ colss r trigger_sqlzChangeLog.trigger_sqlT s &&&&H$H$''wMM}[+ &( 2 2uu ;2> O
- - - -r c F || j v sJ | j |j j |dz S )N)r r )r=
drop_templater& r )r! r- r s r drop_trigger_sqlzChangeLog.drop_trigger_sqla s: &&&&![+ % % r c j t d s G fdd j }| _ j S )N_changelog_modelc . e Zd Z G fdd ZdS )"ChangeLog.model..ChangeLogc , e Zd Z j Z j ZdS )'ChangeLog.model..ChangeLog.MetaN)r r r
r databaser r! s r MetarI k s #wH!% JJJr rL N)r r r
rL rK s r r rG j sG 1 1 1 1 1 1 1 1 1 1 1 1r r )hasattr
base_modelrE )r! r s ` r r- zChangeLog.modelg s_ t /00 .
1
1
1
1
1
1
1DO
1
1
1 %.D !$$r Tc p | j }|r| t t |||f| j } |r6| D ]3\ }
} | j | || 4| D ]8\ } } | r1| || | }
| j |
9d S r ) r- create_tablelistzipr= r execute_sqlrC r@ )r! r- r0 dropinsertupdatedeleterP r actions_r enabledsqls r installzChangeLog.installr s J % " " $ $ $sFFF3T]CCDD J $
J
J 6##D$9$9%$H$HIIII & ) )OGV
)&&ufkBB##C((( ) )r )r r )NTTTTT)r r r
r rN r> rB r= r" r6 r@ rC propertyr- r\ r r r r r
s J H4 JM-H% % % %$ $ $ $2 - - - - % % X% BF7;) ) ) ) ) )r r N)peeweeplayhouse.sqlite_extr Modelr objectr r r r rb s * * * * * * E s) s) s) s) s) s) s) s) s) s)r