o Gdd?d?e0e jAZBGd@dAdAe&e0e jCZDGdBdCdCZEGdDdEdEeEe jFZGGdFdGdGeEe jHZIGdHdIdIeEe jJZKGdJdKdKeEe jLZMe,+e4e,+e5e,+e7e,+e2e,+e8e,+e:e,+e<e,+e>e,+e@e,+eBe,+eDe,+eGe,+eIe,+eKe,+eMGdLdMdMZNdS)ON)forms)checks exceptions)NotSupportedError connectionsrouter) expressionslookups) LOOKUP_SEP) TextField)FieldGetDbPrepValueMixinPostgresOperatorLookup Transform) gettext_lazy)Field)CheckFieldDefaultMixin JSONFieldcseZdZdZedZdediZdZ    dfdd Zfd d Z d d Z fd dZ ddZ ddZ d ddZddZfddZfddZddZfddZZS)!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__)self verbose_namenamerrkwargs __class__O/var/www/html/venv/lib/python3.10/site-packages/django/db/models/fields/json.pyrs  zJSONField.__init__c s4tjdi|}|dpg}||||S)N databasesr")rcheckgetextend_check_supported)rrerrorsr$r r"r#r%.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)rallow_migrate_modelmodelr_metarequired_db_vendorvendorrequired_db_featuresfeaturesr*appendrError display_name)rr$r)db connectionr"r"r#r(4s*zJSONField._check_supportedcsFt\}}}}|jdur|j|d<|jdur|j|d<||||fS)Nrr)r deconstructrr)rrpathargsrr r"r#r9Ls      zJSONField.deconstructcCsP|dur|St|trt|ts|Sz tj||jdWStjy'|YSw)Ncls) isinstance KeyTransformstrjsonloadsrJSONDecodeError)rvalue expressionr8r"r"r# from_db_valueTszJSONField.from_db_valuecCsdS)Nrr"rr"r"r#get_internal_type`szJSONField.get_internal_typecCsL|s||}t|tjrt|jtr|j}nt|dr|S|j ||j S)Nas_sql) get_prep_valuer>rValue output_fieldrrDhasattropsadapt_json_valuer)rrDr8preparedr"r"r#get_db_prep_valuecs  zJSONField.get_db_prep_valuecCs|dur|S|||SN)rQ)rrDr8r"r"r#get_db_prep_savens zJSONField.get_db_prep_savecst|}|r |St|SrR)r get_transformKeyTransformFactory)rr transformr r"r#rTss zJSONField.get_transformcsNt||z tj||jdWdSty&tj|jddd|idw)Nr<rrD)codeparams) rvalidaterAdumpsr TypeErrorrValidationErrorerror_messages)rrDmodel_instancer r"r#rYys zJSONField.validatecCs ||SrR)value_from_object)rr+r"r"r#value_to_string zJSONField.value_to_stringc s$tjditj|j|jd|S)N) form_classrrr")r formfieldrrrr)rrr r"r#rcs zJSONField.formfield)NNNN)F)__name__ __module__ __qualname__empty_strings_allowed_ descriptiondefault_error_messages _default_hintrr%r(r9rFrHrQrSrTrYr`rc __classcell__r"r"r r#rs,      Tc Csj|rdgng}|D]&}zt|}Wnty'|d|t|Yq w|d|q d|S)N$.z[%s])intrr4rArZjoin)key_transforms include_rootr: key_transformnumr"r"r#compile_json_paths    rvc@eZdZdZdZddZdS) DataContainscontainsz@>cCsP|jjstd|||\}}|||\}}t|t|}d||f|fS)Nz:contains lookup is not supported on this database backend.JSON_CONTAINS(%s, %s)r3supports_json_field_containsr process_lhs process_rhstuplercompilerr8lhs lhs_paramsrhs rhs_paramsrXr"r"r#rIzDataContains.as_sqlNrdrerf lookup_namepostgres_operatorrIr"r"r"r#rx rxc@rw) ContainedBy contained_byz<@cCsP|jjstd|||\}}|||\}}t|t|}d||f|fS)Nz>contained_by lookup is not supported on this database backend.rzr{rr"r"r#rIrzContainedBy.as_sqlNrr"r"r"r#rrrcsZeZdZdZddZddZddZddd Zd d Zd d Z fddZ ddZ Z S) HasKeyLookupNcCsdt|S)Nz.%s)rArZrrtr"r"r#compile_json_path_final_keysz(HasKeyLookup.compile_json_path_final_keyc cst|jtr|j||\}}}t|}n |||\}}d}|j}t|ttfs-|g}|D].}t|tr@|||^} } n|g} | ^} } t| dd} | | | 7} |||| fVq/dS)NrmFrs) r>rr?preprocess_lhsrvr}rlistrr) rrr8lhs_sqlrlhs_key_transforms lhs_json_pathrkeyrhrhs_key_transforms final_key rhs_json_pathr"r"r# _as_sql_partss(     zHasKeyLookup._as_sql_partscCs |jr d|j|Sd|S)Nz(%s)ro)logical_operatorrq)rpartsr"r"r#_combine_sql_partss zHasKeyLookup._combine_sql_partsc CsTg}g}|||D]\}}}|||df|||gq ||t|fS)N%srr4r'rr rrr8template sql_partsrXrrrr"r"r#rIszHasKeyLookup.as_sqlcC|j||ddS)Nz!JSON_CONTAINS_PATH(%s, 'one', %s)rrIrrr8r"r"r#as_mysqlzHasKeyLookup.as_mysqlc CsRd}g}g}|||D]\}}}||||f||q ||t|fS)NzJSON_EXISTS(%s, '%s')rrr"r"r# as_oracles zHasKeyLookup.as_oraclecsXt|jtr%|j||^}}|ddD] }t||j|_q|d|_t||S)N)r>rr?rrr as_postgresql)rrr8rhrrr r"r#rs  zHasKeyLookup.as_postgresqlcCr)NJSON_TYPE(%s, %s) IS NOT NULLrrrr"r"r# as_sqliterzHasKeyLookup.as_sqliterR) rdrerfrrrrrIrrrrrlr"r"r r#rs   rc@eZdZdZdZdZdS)HasKeyhas_key?FN)rdrerfrr prepare_rhsr"r"r"r#rrc@s eZdZdZdZdZddZdS)HasKeyshas_keysz?&z AND cCsdd|jDS)NcSg|]}t|qSr")r@).0itemr"r"r# z+HasKeys.get_prep_lookup..)rrGr"r"r#get_prep_lookupszHasKeys.get_prep_lookupN)rdrerfrrrrr"r"r"r#rs  rc@r) HasAnyKeys has_any_keysz?|z OR N)rdrerfrrrr"r"r"r#rrrc@seZdZddZdS)HasKeyOrArrayIndexcCst|gddS)NFr)rvrr"r"r#r$sz.HasKeyOrArrayIndex.compile_json_path_final_keyN)rdrerfrr"r"r"r#r#s rcs,eZdZdZfddZfddZZS)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||fSNmysqlz LOWER(%s))rr}r1)rrr8rrr r"r#r}0  z CaseInsensitiveMixin.process_lhscrr)rr~r1rrr8rrr r"r#r~6rz CaseInsensitiveMixin.process_rhs)rdrerf__doc__r}r~rlr"r"r r#r(s rcs(eZdZdZfddZddZZS) JSONExactTcsVt||\}}|dkr|dgkrdg}|jdkr'dgt|}|t|;}||fS)NrnullrJSON_EXTRACT(%s, '$'))rr~r1lenr)rrr8rrfuncr r"r#r~@s  zJSONExact.process_rhscCs`|||\}}|||\}}|jjr d|d}d|d}d|d|dg||RfS)NzJSON()z JSON_EQUAL(z, z ERROR ON ERROR))r}r~r3!supports_primitives_in_json_field)rrr8rrrrr"r"r#rJs    zJSONExact.as_oracle)rdrerfcan_use_none_as_rhsr~rrlr"r"r r#r=s  rc@ eZdZdS) JSONIContainsNrdrerfr"r"r"r#rSrcsLeZdZdZdZfddZddZddZd d Zd d Z d dZ Z S)r?z->z#>cs tj|i|t||_dSrR)rrr@key_name)rrr;rr r"r#rdszKeyTransform.__init__cCsf|jg}|j}t|tr|d|j|j}t|ts ||\}}|jdkr.dd|D}|||fS)NroraclecSsg|]}|ddqS)%z%%)replace)rrr"r"r#rqsz/KeyTransform.preprocess_lhs..)rrr>r?insertcompiler1)rrr8rrpreviousrrXr"r"r#rhs    zKeyTransform.preprocess_lhscCs0|||\}}}t|}d|t||ffS)NzJSON_EXTRACT(%s, %%s))rrvr)rrr8rrXrr json_pathr"r"r#rtszKeyTransform.as_mysqlcCsH|||\}}}t|}|jjrd}nd}|||fdt|dfS)NzECOALESCE(JSON_VALUE(%s, '%s'), JSON_QUERY(%s, '%s' DISALLOW SCALARS))z4COALESCE(JSON_QUERY(%s, '%s'), JSON_VALUE(%s, '%s')))rrvr3rr)rrr8rrXrrrsqlr"r"r#ryszKeyTransform.as_oraclecCs|||\}}}t|dkrd||jf}|t||ffSzt|j}Wn ty2|j}Ynwd||jft||ffS)Nrz (%s %s %%s))rrpostgres_nested_operatorrrprrr)rrr8rrXrrrlookupr"r"r#rs   zKeyTransform.as_postgresqlcCsT|||\}}}t|}ddd|jjD}d||||ft||fdfS)N,cSrr")repr)rdatatyper"r"r#rrz*KeyTransform.as_sqlite..z](CASE WHEN JSON_TYPE(%s, %%s) IN (%s) THEN JSON_TYPE(%s, %%s) ELSE JSON_EXTRACT(%s, %%s) END))rrvrqrNjsonfield_datatype_valuesr)rrr8rrXrrrdatatype_valuesr"r"r#rs zKeyTransform.as_sqlite) rdrerfrrrrrrrrrlr"r"r r#r?`s    r?cs6eZdZdZdZeZfddZeddZ Z S)KeyTextTransformz->>z#>>csT|jrt||\}}d||fS|||\}}}t|}d|t||ffS)NJSON_UNQUOTE(%s)z (%s ->> %%s))mysql_is_mariadbrrrrvr)rrr8rrXrrrrr r"r#rs  zKeyTextTransform.as_mysqlcCs2|t^}}|s td|D]}|||}q|S)Nz,Lookup must contain key or index transforms.)splitr r)r=rrVkeysrr"r"r# from_lookups  zKeyTextTransform.from_lookup) rdrerfrrr rLr classmethodrrlr"r"r r#rs  rcs 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.) r>r?r[rrsource_expressionsextrarr)rrtr;rkey_text_transformr r"r#rs z$KeyTransformTextLookupMixin.__init__)rdrerfrrrlr"r"r r#rsrc@eZdZddZddZdS)KeyTransformIsNullcCs\t|jj|jj||\}}|js||fS|j||\}}}d||ft|t|fS)Nz(NOT %s OR %s IS NULL))rrrrrrr)rrr8rrXrrrhr"r"r#rszKeyTransformIsNull.as_oraclecCs,d}|jsd}t|jj|jjj|||dS)NzJSON_TYPE(%s, %s) IS NULLrr)rrrrrI)rrr8rr"r"r#rszKeyTransformIsNull.as_sqliteN)rdrerfrrr"r"r"r#rs rceZdZfddZZS)KeyTransformIncst||||\}}t|dsE|jjsE|jdkr1t|}d}t|t t fr,|d;}n|d;}n|jdksC|jdkrE|d|j j vrEd }|jdkrQ|j rQd |}||fS) NrIr9%s(JSON_OBJECT('value' VALUE %%s FORMAT JSON), '$.value') JSON_QUERY JSON_VALUErsqliterrr)rresolve_expression_parameterrMr3has_native_json_fieldr1rArBr>rrrNrr)rrr8rparamrXrDr r"r#rs.      z+KeyTransformIn.resolve_expression_parameter)rdrerfrrlr"r"r r#rrcs(eZdZfddZfddZZS)KeyTransformExactcst|jtrttj|||St||\}}|jdkrLg}d}|D]}t |}t|t t fr:| |dq$| |dq$|t |;}||fS|jdkrog}|D]}||jjvrc| dqU| dqU|t |;}||fS)Nrrrrrrr)r>rr?rr Exactr~r1rArBrrr4rrNr)rrr8rrrrrDr r"r#r~s*         zKeyTransformExact.process_rhsc st||\}}|dgkr?t|jj|jj}|||\}}|jd|jd}|||\} } d|| ft|t| fSt||S)NrisnullTz %s AND %s) rr~rrrr get_lookuprIr) rrr8rr has_key_expr has_key_sqlhas_key_params is_null_expr is_null_sqlis_null_paramsr r"r#rs  zKeyTransformExact.as_oracle)rdrerfr~rrlr"r"r r#rs rc@r)KeyTransformIExactNrr"r"r"r#r*rc@r)KeyTransformIContainsNrr"r"r"r#r0rrc@r)KeyTransformStartsWithNrr"r"r"r#r6rrc@r)KeyTransformIStartsWithNrr"r"r"r#r :rr c@r)KeyTransformEndsWithNrr"r"r"r#r @rr c@r)KeyTransformIEndsWithNrr"r"r"r#r Drr c@r)KeyTransformRegexNrr"r"r"r#r Jrr c@r)KeyTransformIRegexNrr"r"r"r#r Nrr cr)KeyTransformNumericLookupMixincs0t||\}}|jjsdd|D}||fS)NcSsg|]}t|qSr")rArB)rrDr"r"r#rXsz>KeyTransformNumericLookupMixin.process_rhs..)rr~r3rrr r"r#r~Usz*KeyTransformNumericLookupMixin.process_rhs)rdrerfr~rlr"r"r r#rTrrc@r)KeyTransformLtNrr"r"r"r#r\rrc@r)KeyTransformLteNrr"r"r"r#r`rrc@r)KeyTransformGtNrr"r"r"r#rdrrc@r)KeyTransformGteNrr"r"r"r#rhrrc@r)rUcCs ||_dSrR)r)rrr"r"r#rrazKeyTransformFactory.__init__cOst|jg|Ri|SrR)r?r)rr;rr"r"r#__call__szKeyTransformFactory.__call__N)rdrerfrrr"r"r"r#rU~s rU)T)OrAdjangor django.corerr django.dbrrrdjango.db.modelsrr django.db.models.constantsr django.db.models.fieldsr django.db.models.lookupsr r rdjango.utils.translationrrhrormixinsr__all__rrvrxrrrrrrrrr IContainsrregister_lookupr?rrKTrIsNullrInrrIExactrr StartsWithr IStartsWithr EndsWithr  IEndsWithr Regexr IRegexr rLessThanrLessThanOrEqualr GreaterThanrGreaterThanOrEqualrrUr"r"r"r#s       | Q        ; (