o bL@shddlZddlmZddlmZmZddlmZmZm Z ddl m Z ddl m Z mZddlmZdd lmZdd lmZd gZGd d d eeZdHddZGddde ZGddde ZGddde ZGdddeZGdddeZGdddeZGddde jZ e!ee!ee!ee!ee!ee!e GdddeZ"Gd d!d!e"Z#Gd"d#d#Z$Gd$d%d%Z%Gd&d'd'e j&Z'Gd(d)d)e j(Z)Gd*d+d+e Z*Gd,d-d-e%e$e j+Z,Gd.d/d/e%e$e j-Z.Gd0d1d1e$e j/Z0Gd2d3d3e%e$e j1Z2Gd4d5d5e$e j3Z4Gd6d7d7e%e$e j5Z6Gd8d9d9e$e j7Z8Gd:d;d;e%e$e j9Z:Gdd?d?e;e j<Z=Gd@dAdAe;e j>Z?GdBdCdCe;e j@ZAGdDdEdEe;e jBZCe"!e)e"!e*e"!e,e"!e'e"!e.e"!e0e"!e2e"!e4e"!e6e"!e8e"!e:e"!e=e"!e?e"!eAe"!eCGdFdGdGZDdS)IN)forms)checks exceptions)NotSupportedError connectionsrouter)lookups)PostgresOperatorLookup Transform) gettext_lazy)Field)CheckFieldDefaultMixin JSONFieldcseZdZdZedZdediZdZ dfdd Zfd d Z d d Z fd dZ ddZ ddZ ddZfddZfddZddZfddZZS)rFz A JSON objectinvalidzValue must be valid JSON.)dictz{}Nc sN|r t|s td|rt|std||_||_tj||fi|dS)Nz0The encoder parameter must be a callable object.z0The decoder parameter must be a callable object.)callable ValueErrorencoderdecodersuper__init__)selfZ verbose_namenamerrkwargs __class__[/var/www/secure340b-portal/env/lib/python3.10/site-packages/django/db/models/fields/json.pyrs  zJSONField.__init__c s4tjdi|}|dpg}||||S)N databasesr)rcheckgetextend_check_supported)rrerrorsrrrrr $szJSONField.checkcCszg}|D]6}t||jsqt|}|jjjr |jjj|jkr qd|jjjvs:|jj s:| t j d|j |jddq|S)Nsupports_json_fieldz%s does not support JSONFields.z fields.E180)objid)rZallow_migrate_modelmodelr_metaZrequired_db_vendorvendorZrequired_db_featuresfeaturesr%appendrErrorZ display_name)rrr$db connectionrrrr#*s2 zJSONField._check_supportedcsFt\}}}}|jdur|j|d<|jdur|j|d<||||fS)Nrr)r deconstructrr)rrpathargsrrrrr0Cs      zJSONField.deconstructcCsP|dur|St|trt|ts|Sz tj||jdWStjy'|YSwNcls) isinstance KeyTransformstrjsonloadsrJSONDecodeError)rvalueZ expressionr/rrr from_db_valueKszJSONField.from_db_valuecCsdS)Nrrrrrrget_internal_typeWszJSONField.get_internal_typecCs|dur|Stj||jdSr3)r9dumpsr)rr<rrrget_prep_valueZszJSONField.get_prep_valuecst|}|r |St|SN)r get_transformKeyTransformFactory)rrZ transformrrrrC_s zJSONField.get_transformcsNt||z tj||jdWdSty&tj|jddd|idw)Nr4rr<)codeparams) rvalidater9r@r TypeErrorrZValidationErrorZerror_messages)rr<Zmodel_instancerrrrGes zJSONField.validatecCs ||SrB)Zvalue_from_object)rr&rrrvalue_to_stringp zJSONField.value_to_stringc s$tjditj|j|jd|S)N)Z form_classrrr)r formfieldrrrr)rrrrrrKss zJSONField.formfield)NNNN)__name__ __module__ __qualname__Zempty_strings_allowed_ descriptionZdefault_error_messagesZ _default_hintrr r#r0r=r?rArCrGrIrK __classcell__rrrrrs$      Tc Csj|rdgng}|D]&}zt|}Wnty'|d|t|Yq w|d|q d|S)N$.z[%s])intrr,r9r@join)key_transforms include_rootr1 key_transformnumrrrcompile_json_path|s    r[c@eZdZdZdZddZdS) DataContainscontainsz@>cCsP|jjstd|||\}}|||\}}t|t|}d||f|fS)Nz:contains lookup is not supported on this database backend.JSON_CONTAINS(%s, %s)r+Zsupports_json_field_containsr process_lhs process_rhstuplercompilerr/lhs lhs_paramsrhs rhs_paramsrFrrras_sqlzDataContains.as_sqlNrLrMrN lookup_namepostgres_operatorrjrrrrr] r]c@r\) ContainedByZ contained_byz<@cCsP|jjstd|||\}}|||\}}t|t|}d||f|fS)Nz>contained_by lookup is not supported on this database backend.r_r`rdrrrrjrkzContainedBy.as_sqlNrlrrrrrprorpcsBeZdZdZd ddZddZddZfdd Zd d ZZ S) HasKeyLookupNc Cst|jtr|j||\}}}t|}n |||\}}d}||}|j} g} t| ttfs2| g} | D]!} t| trE| ||^} } n| g} | d|t| ddfq4|j rfd|j |gt | }|t|t| fS)NrRz%s%sF)rXz(%s)) r6rfr7preprocess_lhsr[rarhlistrcr,logical_operatorrVlen)rrer/templaterfrgZlhs_key_transformsZ lhs_json_pathsqlrhrikeyrOrhs_key_transformsrrrrjs*     zHasKeyLookup.as_sqlcC|j||ddS)Nz"JSON_CONTAINS_PATH(%s, 'one', %%s)rvrjrrer/rrras_mysqlzHasKeyLookup.as_mysqlcCs$|j||dd\}}|t|gfS)NzJSON_EXISTS(%s, '%%s')r{)rjrc)rrer/rwrFrrr as_oracleszHasKeyLookup.as_oraclecsXt|jtr%|j||^}}|ddD] }t||j|_q|d|_t||S)N)r6rhr7rrrfr as_postgresql)rrer/rOryrxrrrrs  zHasKeyLookup.as_postgresqlcCrz)NJSON_TYPE(%s, %%s) IS NOT NULLr{r|r}rrr as_sqliterzHasKeyLookup.as_sqliterB) rLrMrNrtrjr~rrrrQrrrrrqs  rqc@eZdZdZdZdZdS)HasKeyZhas_key?FN)rLrMrNrmrnZ prepare_rhsrrrrrrc@s eZdZdZdZdZddZdS)HasKeysZhas_keysz?&z AND cCsdd|jDS)NcSsg|]}t|qSr)r8).0itemrrr sz+HasKeys.get_prep_lookup..)rhr>rrrget_prep_lookuprzHasKeys.get_prep_lookupN)rLrMrNrmrnrtrrrrrrs  rc@r) HasAnyKeysZ has_any_keysz?|z OR N)rLrMrNrmrnrtrrrrrrrc,eZdZdZfddZfddZZS) JSONExactTcsPt||\}}|jdkr$t||\}}|dkr$|dgkr$d|}||fS)Nsqlite%szJSON_TYPE(%s, '$'))rrar*rb)rrer/rfrgrhrirrrras  zJSONExact.process_lhscsVt||\}}|dkr|dgkrdg}|jdkr'dgt|}|t|}||fS)NrnullmysqlJSON_EXTRACT(%s, '$'))rrbr*rurc)rrer/rhrifuncrrrrbs  zJSONExact.process_rhs)rLrMrNZcan_use_none_as_rhsrarbrQrrrrrs  rcsLeZdZdZdZfddZddZddZd d Zd d Z d dZ Z S)r7z->z#>cs tj|i|t||_dSrB)rrr8key_name)rrr2rrrrrszKeyTransform.__init__cCsf|jg}|j}t|tr|d|j|j}t|ts ||\}}|jdkr.dd|D}|||fS)NroraclecSsg|]}|ddqS)%z%%)replace)rrxrrrr sz/KeyTransform.preprocess_lhs..)rrfr6r7insertcompiler*)rrer/rWpreviousrfrFrrrrrs    zKeyTransform.preprocess_lhscC0|||\}}}t|}d|t||ffSNzJSON_EXTRACT(%s, %%s)rrr[rcrrer/rfrFrWZ json_pathrrrr~#zKeyTransform.as_mysqlcCs6|||\}}}t|}d||fdt|dfS)Nz4COALESCE(JSON_QUERY(%s, '%s'), JSON_VALUE(%s, '%s'))rrrrrr(s  zKeyTransform.as_oraclecCs|||\}}}t|dkrd||jf}|t||ffSzt|j}Wn ty2|j}Ynwd||jft||ffS)Nr z (%s %s %%s))rrrupostgres_nested_operatorrcrUrrrn)rrer/rfrFrWrwlookuprrrr0s   zKeyTransform.as_postgresqlcCrrrrrrrr;rzKeyTransform.as_sqlite) rLrMrNrnrrrrr~rrrrQrrrrr7s   r7c@seZdZdZdZdS)KeyTextTransformz->>z#>>N)rLrMrNrnrrrrrrAsrcs eZdZdZfddZZS)KeyTransformTextLookupMixinz Mixin for combining with a lookup expecting a text lhs from a JSONField key lookup. On PostgreSQL, make use of the ->> operator instead of casting key values to text and performing the lookup on the resulting representation. csLt|ts tdt|jg|jRi|j}tj|g|Ri|dS)NzLTransform should be an instance of KeyTransform in order to use this lookup.) r6r7rHrrZsource_expressionsextrarr)rrYr2rZkey_text_transformrrrrMs z$KeyTransformTextLookupMixin.__init__)rLrMrN__doc__rrQrrrrrFsrcr)CaseInsensitiveMixinz Mixin to allow case-insensitive comparison of JSON values on MySQL. MySQL handles strings used in JSON context using the utf8mb4_bin collation. Because utf8mb4_bin is a binary collation, comparison of JSON values is case-sensitive. c0t||\}}|jdkrd||fS||fSNrz LOWER(%s))rrar*)rrer/rfrgrrrraa  z CaseInsensitiveMixin.process_lhscrr)rrbr*rrer/rhrirrrrbgrz CaseInsensitiveMixin.process_rhs)rLrMrNrrarbrQrrrrrZs rc@eZdZddZddZdS)KeyTransformIsNullcCs\t|jj|jj||\}}|js||fS|j||\}}}d||ft|t|fS)Nz(NOT %s OR %s IS NULL))rrfrrrhrrrc)rrer/rwrFrfrgrOrrrrpszKeyTransformIsNull.as_oraclecCs,d}|jsd}t|jj|jjj|||dS)NzJSON_TYPE(%s, %%s) IS NULLrr{)rhrrfrrj)rrer/rvrrrr{szKeyTransformIsNull.as_sqliteN)rLrMrNrrrrrrrns rceZdZfddZZS)KeyTransformIncst||||\}}t|ds8|jjs8|jdkr1t|}d}t|t t fr,|d}n |d}n|jdvr8d}|jdkrD|j rDd |}||fS) Nrjr9%s(JSON_OBJECT('value' VALUE %%s FORMAT JSON), '$.value') JSON_QUERY JSON_VALUE>rrrrzJSON_UNQUOTE(%s)) rresolve_expression_parameterhasattrr+has_native_json_fieldr*r9r:r6rsrZmysql_is_mariadb)rrer/rwparamrFr<rrrrs$     z+KeyTransformIn.resolve_expression_parameter)rLrMrNrrQrrrrrrcs4eZdZfddZfddZfddZZS)KeyTransformExactcsbt||\}}|jdkr-t||\}}|dkr-|dgkr-|j||^}}d|}||fS)NrrrzJSON_TYPE(%s, %%s))rrar*rbrfrr)rrer/rfrgrhrirOrrrras zKeyTransformExact.process_lhscst|jtrttj|||St||\}}|jdkrLg}d}|D]}t |}t|t t fr:| |dq$| |dq$|t |}||fS|jdkr^dd|D}|t |}||fS)NrrrrrcSsg|] }|dkr dndqS)rrrrrr<rrrrsz1KeyTransformExact.process_rhs..)r6rhr7rrExactrbr*r9r:rsrr,rc)rrer/rhrirrwr<rrrrbs"      zKeyTransformExact.process_rhsc st||\}}|dgkr?t|jj|jj}|||\}}|jd|jd}|||\} } d|| ft|t| fSt||S)NrZisnullTz %s AND %s) rrbrrfrrZ get_lookuprjrc) rrer/rhriZ has_key_exprZ has_key_sqlZhas_key_paramsZ is_null_exprZ is_null_sqlZis_null_paramsrrrrs  zKeyTransformExact.as_oracle)rLrMrNrarbrrQrrrrrs  rc@ eZdZdS)KeyTransformIExactNrLrMrNrrrrrrc@r)KeyTransformIContainsNrrrrrrrrc@r)KeyTransformStartsWithNrrrrrrrrc@r)KeyTransformIStartsWithNrrrrrrrrc@r)KeyTransformEndsWithNrrrrrrrrc@r)KeyTransformIEndsWithNrrrrrrrrc@r)KeyTransformRegexNrrrrrrrrc@r)KeyTransformIRegexNrrrrrrrrcr)KeyTransformNumericLookupMixincs0t||\}}|jjsdd|D}||fS)NcSsg|]}t|qSr)r9r:rrrrrsz>KeyTransformNumericLookupMixin.process_rhs..)rrbr+rrrrrrbsz*KeyTransformNumericLookupMixin.process_rhs)rLrMrNrbrQrrrrrrrc@r)KeyTransformLtNrrrrrrrrc@r)KeyTransformLteNrrrrrrrrc@r)KeyTransformGtNrrrrrrrrc@r)KeyTransformGteNrrrrrrrrc@r)rDcCs ||_dSrB)r)rrrrrrrJzKeyTransformFactory.__init__cOst|jg|Ri|SrB)r7r)rr2rrrr__call__szKeyTransformFactory.__call__N)rLrMrNrrrrrrrDs rD)T)Er9djangorZ django.corerrZ django.dbrrrZdjango.db.modelsrZdjango.db.models.lookupsr r Zdjango.utils.translationr rOrTr mixinsr__all__rr[r]rprqrrrrrZregister_lookupr7rrrZIsNullrInrrZIExactrZ IContainsrZ StartsWithrZ IStartsWithrZEndsWithrZ IEndsWithrRegexrZIRegexrrZLessThanrZLessThanOrEqualrZ GreaterThanrZGreaterThanOrEqualrrDrrrrsz      l 4       2,