§
    ¤”j1  ã                   óB   — d dl Z d dlmZ d dlmZ  G d„ de¦  «        ZdS )é    N)ÚBaseDatabaseFeatures)Úcached_propertyc                   óš  ‡ — e Zd ZdZdZdZdZdZdZdZ	dZ
dZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZ dZ!dZ"e#d„ ¦   «         Z$e#d	„ ¦   «         Z%d
Z&e#d„ ¦   «         Z'e#d„ ¦   «         Z(e#d„ ¦   «         Z)e#d„ ¦   «         Z*e#d„ ¦   «         Z+e#ˆ fd„¦   «         Z,e#d„ ¦   «         Z- e. e/j0        d¦  «        ¦  «        Z1e#d„ ¦   «         Z2e#d„ ¦   «         Z3e#d„ ¦   «         Z4 e. e/j0        d¦  «        ¦  «        Z5e#d„ ¦   «         Z6e#d„ ¦   «         Z7e#d„ ¦   «         Z8e#d„ ¦   «         Z9e#d„ ¦   «         Z:e#d„ ¦   «         Z;e#d„ ¦   «         Z<e#d„ ¦   «         Z=e#d„ ¦   «         Z>e#d „ ¦   «         Z?e#d!„ ¦   «         Z@e#d"„ ¦   «         ZA e. e/j0        d#¦  «        ¦  «        ZBe#d$„ ¦   «         ZCe#d%„ ¦   «         ZDe#d&„ ¦   «         ZEe#d'„ ¦   «         ZFˆ xZGS )(ÚDatabaseFeatures© TFz…
        CREATE PROCEDURE test_procedure ()
        BEGIN
            DECLARE V_I INTEGER;
            SET V_I = 1;
        END;
    z’
        CREATE PROCEDURE test_procedure (P_I INTEGER)
        BEGIN
            DECLARE V_I INTEGER;
            SET V_I = P_I;
        END;
    z¸
        CREATE TABLE test_table_composite_pk (
            column_1 INTEGER NOT NULL,
            column_2 INTEGER NOT NULL,
            PRIMARY KEY(column_1, column_2)
        )
    zINSERT INTO {} () VALUES ()c                 ó"   — | j         j        rdS dS )N)é
   é   )é   r   é   ©Ú
connectionÚmysql_is_mariadb©Úselfs    úp/var/www/finuniver-perm.ru/html/portfolio/venv/lib/python3.11/site-packages/django/db/backends/mysql/features.pyÚminimum_database_versionz)DatabaseFeatures.minimum_database_versionA   s   € àŒ?Ô+ð 	Ø�7à�:ó    c                 ó    — d}| j         j        r| j         j        dk    s| j         j        s| j         j        dk    rd}|› d�|› d�|› d�|› d�dœS )	NÚutf8©r	   é   )r   r   é   Úutf8mb3Ú_general_ciÚ_esperanto_ciÚ_swedish_ci)ÚciÚnon_defaultÚ
swedish_ciÚvirtual©r   r   Úmysql_version)r   Úcharsets     r   Útest_collationsz DatabaseFeatures.test_collationsH   s‰   € àˆàŒOÔ,ð	 à”Ô-°Ò8Ð8à”Ô0ð 9ð ”Ô-°Ò;Ð;ð  ˆGàÐ)Ð)Ð)Ø%Ð4Ð4Ð4Ø$Ð1Ð1Ð1Ø!Ð0Ð0Ð0ð	
ð 
ð 	
r   zUTC_TIMESTAMP(6)c                 óB  — ddhddhdhdhh d£dœ}| j         j        r2d	| j         j        cxk     rd
k     rn n|                     ddhi¦  «         | j         j        r2d| j         j        cxk     rdk     rn n|                     ddhi¦  «         | j        s|                     ddhi¦  «         d| j         j        v r|                     ddhi¦  «         | j         j        dk     r|                     ddhi¦  «         | j         j        s|                     dddhi¦  «         |S )NzLdb_functions.comparison.test_greatest.GreatestTests.test_coalesce_workaroundzFdb_functions.comparison.test_least.LeastTests.test_coalesce_workaroundz5model_fields.test_textfield.TextFieldTests.test_emojiz4model_fields.test_charfield.TestCharField.test_emojiz;schema.tests.SchemaTests.test_func_index_json_key_transformzDexpressions.tests.FTimeDeltaTests.test_durationfield_multiply_divide>   ú@update.tests.AdvancedTests.test_update_ordered_by_m2m_annotationúEupdate.tests.AdvancedTests.test_update_ordered_by_m2m_annotation_descúGupdate.tests.AdvancedTests.test_update_ordered_by_inline_m2m_annotation)zThis doesn't work on MySQL.z4Running on MySQL requires utf8mb4 encoding (#18392).zHMySQL doesn't support functional indexes on a function that returns JSONzkMySQL supports multiplying and dividing DurationFields by a scalar value but it's not implemented (#25287).zWUPDATE ... ORDER BY syntax on MySQL/MariaDB does not support ordering byrelated fields.)r	   r
   é   ©r	   é   é   z*https://jira.mariadb.org/browse/MDEV-19598zCschema.tests.SchemaTests.test_alter_not_unique_field_to_primary_key)r	   r
   é   )r	   r,   z*https://jira.mariadb.org/browse/MDEV-22775zBschema.tests.SchemaTests.test_alter_pk_with_self_referential_fieldz%MariaDB and MySQL >= 8.0.18 specific.z4queries.test_explain.ExplainTests.test_mysql_analyzeÚONLY_FULL_GROUP_BYzjGROUP BY cannot contain nonaggregated column when ONLY_FULL_GROUP_BY mode is enabled on MySQL, see #34262.zOaggregation.tests.AggregateTestCase.test_group_by_nested_expression_with_params©r   r   é   zKNesting of UNIONs at the right-hand side is not supported on MySQL < 8.0.31zGqueries.test_qs_combinators.QuerySetSetOperationTests.test_union_nestedzDMySQL doesn't allow renaming columns referenced by generated columnsz_migrations.test_operations.OperationTests.test_invalid_generated_field_changes_on_rename_storedz`migrations.test_operations.OperationTests.test_invalid_generated_field_changes_on_rename_virtual)r   r   r#   ÚupdateÚsupports_explain_analyzeÚsql_mode)r   Úskipss     r   Údjango_test_skipsz"DatabaseFeatures.django_test_skips]   s?  € ð+ð+ð,ð HØFðEð Nðð
 Wð@ð ð  ð  ð)
ð 
ˆð6 Œ?Ô+ð 	ð 1
ð ŒOÔ)ð	17ð 17ò 17ð 17ð -7ò	17ð 17ð 17ð 17ð 17ð
 �LŠLà@ðEðCðñô ð ð Œ?Ô+ð 	ð 1
ð ŒOÔ)ð	14ð 14ò 14ð 14ð -4ò	14ð 14ð 14ð 14ð 14ð
 �LŠLà@ðDðCðñô ð ð Ô,ð 	Ø�LŠLà;ØNð>ðñô ð ð   4¤?Ô#;Ð;Ð;Ø�LŠLðOðFðQðñô ð ð Œ?Ô(¨:Ò5Ð5Ø�LŠLð%ð,ð'ðñô ð ð ŒÔ/ð 	Ø�LŠLððPðQð ðñ
ô 
ð 
ð ˆr   c                 ó&   — | j         j        d         S )zGInternal method used in Django tests. Don't rely on this from your codeÚdefault_storage_engine©r   Úmysql_server_datar   s    r   Ú_mysql_storage_enginez&DatabaseFeatures._mysql_storage_engine¾   s   € ð ŒÔ0Ð1IÔJÐJr   c                 ó   — d| j         j        v S )zt
        Autoincrement primary key can be set to 0 if it doesn't generate new
        autoincrement values.
        ÚNO_AUTO_VALUE_ON_ZERO)r   r4   r   s    r   Úallows_auto_pk_0z!DatabaseFeatures.allows_auto_pk_0Ã   s   € ð '¨$¬/Ô*BÐBÐBr   c                 ó   — | j         j        S ©Nr   r   s    r   Úupdate_can_self_selectz'DatabaseFeatures.update_can_self_selectË   s   € àŒÔ/Ð/r   c                 ó   — | j         dk    S )z-Confirm support for introspected foreign keysÚMyISAM©r;   r   s    r   Úcan_introspect_foreign_keysz,DatabaseFeatures.can_introspect_foreign_keysÏ   s   € ð Ô)¨XÒ5Ð5r   c                 ó<   •— i t          ¦   «         j        ¥dddddœ¥S )NÚ	TextFieldÚIntegerFieldÚBigIntegerFieldÚ	CharField)ÚBinaryFieldÚBooleanFieldÚDurationFieldÚGenericIPAddressField)ÚsuperÚintrospected_field_types)r   Ú	__class__s    €r   rP   z)DatabaseFeatures.introspected_field_typesÔ   s7   ø€ ð
Ý‰gŒgÔ.ð
à&Ø*Ø.Ø%0ð
ð 
ð 
ð 	
r   c                 ó:   — | j         j        o| j         j        dk    S )N)r	   r,   r   r"   r   s    r   Úcan_return_columns_from_insertz/DatabaseFeatures.can_return_columns_from_insertÞ   s&   € àŒÔ/ð 
°D´OÔ4Qð V
ò 5
ð 	
r   rS   c                 ó&   — | j         j        d         S )NÚhas_zoneinfo_databaser9   r   s    r   rU   z&DatabaseFeatures.has_zoneinfo_databaseê   s   € àŒÔ0Ð1HÔIÐIr   c                 ó&   — | j         j        d         S )NÚsql_auto_is_nullr9   r   s    r   Úis_sql_auto_is_null_enabledz,DatabaseFeatures.is_sql_auto_is_null_enabledî   s   € àŒÔ0Ð1CÔDÐDr   c                 ó>   — | j         j        rdS | j         j        dk    S ©NT©r   r   é   r"   r   s    r   Ú!supports_column_check_constraintsz2DatabaseFeatures.supports_column_check_constraintsò   ó$   € àŒ?Ô+ð 	Ø�4ØŒÔ,°
Ò:Ð:r   r]   c                 ó>   — | j         j        rdS | j         j        dk    S rZ   r"   r   s    r   Ú can_introspect_check_constraintsz1DatabaseFeatures.can_introspect_check_constraintsü   r^   r   c                 ó>   — | j         j        r| j         j        dk    S dS )Nr   Tr"   r   s    r   Ú!has_select_for_update_skip_lockedz2DatabaseFeatures.has_select_for_update_skip_locked  s$   € àŒ?Ô+ð 	<Ø”?Ô0°GÒ;Ð;Øˆtr   c                 ó   — | j         j         S r@   r   r   s    r   Úhas_select_for_update_ofz)DatabaseFeatures.has_select_for_update_of  s   € à”?Ô3Ð3Ð3r   c                 ó:   — | j         j        p| j         j        dk    S )N)r   r   é   r"   r   s    r   r3   z)DatabaseFeatures.supports_explain_analyze  s&   € àŒÔ/ð 
°4´?Ô3Pð U
ò 4
ð 	
r   c                 óp   — h d£}| j         j        s%| j         j        dk    r|                     d¦  «         |S )N>   ÚJSONÚTEXTÚTRADITIONALr[   ÚTREE)r   r   r#   Úadd)r   Úformatss     r   Úsupported_explain_formatsz*DatabaseFeatures.supported_explain_formats  sL   € ð 2Ð1Ð1ˆØŒÔ/ð 	 °D´OÔ4Qð V
ò 5
ð 5
ð
 �KŠK˜ÑÔÐØˆr   c                 ó   — | j         dk    S )zI
        All storage engines except MyISAM support transactions.
        rC   rD   r   s    r   Úsupports_transactionsz&DatabaseFeatures.supports_transactions!  s   € ð
 Ô)¨XÒ5Ð5r   c                 ó&   — | j         j        d         S )NÚlower_case_table_namesr9   r   s    r   Úignores_table_name_casez(DatabaseFeatures.ignores_table_name_case(  s   € àŒÔ0Ð1IÔJÐJr   c                 ó   — | j         j         S r@   r   r   s    r   Úsupports_default_in_lead_lagz-DatabaseFeatures.supports_default_in_lead_lag,  s   € ð ”?Ô3Ð3Ð3r   c                 ó,   — | j         j        r| j        S dS )NT)r   r   r`   r   s    r   Úcan_introspect_json_fieldz*DatabaseFeatures.can_introspect_json_field1  s   € àŒ?Ô+ð 	9ØÔ8Ð8Øˆtr   c                 óX   — | j         dk    rdS | j        j        r| j        j        dk    S dS )NÚInnoDBF)r	   r   T)r;   r   r   r#   r   s    r   Úsupports_index_column_orderingz/DatabaseFeatures.supports_index_column_ordering7  s7   € àÔ%¨Ò1Ð1Ø�5ØŒ?Ô+ð 	<Ø”?Ô0°GÒ;Ð;Øˆtr   c                 óR   — | j         j         o| j        dk    o| j         j        dk    S )NrC   ©r   r   é   )r   r   r;   r#   r   s    r   Úsupports_expression_indexesz,DatabaseFeatures.supports_expression_indexes?  s6   € ð ”Ô0Ð0ð <ØÔ*¨hÒ6ð<à”Ô-°Ò;ð	
r   c                 ó>   — | j         j        }|p| j         j        dk    S )Nr0   r"   ©r   Ú
is_mariadbs     r   Úsupports_select_intersectionz-DatabaseFeatures.supports_select_intersectionG  s!   € à”_Ô5ˆ
ØÐH˜Tœ_Ô:¸jÒHÐHr   r‚   c                 ó>   — | j         j        r| j         j        dk    S dS )Nr+   Tr"   r   s    r   Úcan_rename_indexz!DatabaseFeatures.can_rename_indexP  s$   € àŒ?Ô+ð 	?Ø”?Ô0°JÒ>Ð>Øˆtr   c                 ó>   — | j         j        rdS | j         j        dk    S )NTr|   r"   r   s    r   Úsupports_expression_defaultsz-DatabaseFeatures.supports_expression_defaultsV  r^   r   c                 ó>   — | j         j        }|o| j         j        dk    S )N)r	   é   r"   r€   s     r   Úhas_native_uuid_fieldz&DatabaseFeatures.has_native_uuid_field\  s!   € à”_Ô5ˆ
ØÐF˜dœoÔ;¸wÒFÐFr   c                 ó:   — | j         j        rd| j         j        vS dS )Nr/   T)r   r   r4   r   s    r   Úallows_group_by_selected_pksz-DatabaseFeatures.allows_group_by_selected_pksa  s%   € àŒ?Ô+ð 	HØ'¨t¬Ô/GÐGÐGØˆtr   )HÚ__name__Ú
__module__Ú__qualname__Úempty_fetchmany_valueÚrelated_fields_match_typeÚallow_sliced_subqueries_with_inÚhas_select_for_updateÚhas_select_for_update_nowaitÚsupports_forward_referencesÚsupports_regex_backreferencingÚ!supports_date_lookup_using_stringÚsupports_timezonesÚ-requires_explicit_null_ordering_when_groupingÚatomic_transactionsÚcan_clone_databasesÚsupports_commentsÚsupports_comments_inlineÚsupports_temporal_subtractionÚ%supports_slicing_ordering_in_compoundÚsupports_index_on_text_fieldÚsupports_over_clauseÚ#supports_frame_range_fixed_distanceÚsupports_update_conflictsÚ"delete_can_self_reference_subqueryÚ(create_test_procedure_without_params_sqlÚ(create_test_procedure_with_int_param_sqlÚ,create_test_table_with_composite_primary_keyÚsupports_partial_indexesÚcollate_as_index_expressionÚinsert_test_table_with_defaultsÚ supports_order_by_nulls_modifierÚorder_by_nulls_firstÚsupports_logical_xorÚ!supports_stored_generated_columnsÚ"supports_virtual_generated_columnsr   r   r%   Útest_now_utc_templater6   r;   r>   rA   rE   rP   rS   ÚpropertyÚoperatorÚ
attrgetterÚ can_return_rows_from_bulk_insertrU   rX   r]   Ú supports_table_check_constraintsr`   rb   rd   r3   rn   rp   rs   ru   rw   rz   r~   r‚   Úsupports_select_differencer„   r†   r‰   r‹   Ú__classcell__)rQ   s   @r   r   r      ss  ø€ € € € € ØÐØ $Ðà&+Ð#Ø ÐØ#'Ð Ø"'ÐØ%*Ð"Ø(-Ð%ØÐØ48Ð1ØÐØÐØÐØ#ÐØ$(Ð!Ø,0Ð)Ø#(Ð ØÐØ*.Ð'Ø $ÐØ).Ð&ð0Ð,ð0Ð,ð4Ð0ð  %Ðð #'ÐØ&CÐ#à',Ð$ØÐØÐà(,Ð%Ø)-Ð&àðð ñ „_ðð ð
ð 
ñ „_ð
ð$ /Ðàð^ð ^ñ „_ð^ð@ ðKð Kñ „_ðKð ðCð Cñ „_ðCð ð0ð 0ñ „_ð0ð ð6ð 6ñ „_ð6ð ð
ð 
ð 
ð 
ñ „_ð
ð ð
ð 
ñ „_ð
ð (0 xØˆÔÐ<Ñ=Ô=ñ(ô (Ð$ð ðJð Jñ „_ðJð ðEð Eñ „_ðEð ð;ð ;ñ „_ð;ð
 (0 xØˆÔÐ?Ñ@Ô@ñ(ô (Ð$ð ð;ð ;ñ „_ð;ð
 ðð ñ „_ðð
 ð4ð 4ñ „_ð4ð ð
ð 
ñ „_ð
ð ð
ð 
ñ „_ð
ð ð6ð 6ñ „_ð6ð ðKð Kñ „_ðKð ð4ð 4ñ „_ð4ð ðð ñ „_ðð
 ðð ñ „_ðð ð
ð 
ñ „_ð
ð ðIð Iñ „_ðIð "* ØˆÔÐ:Ñ;Ô;ñ"ô "Ðð ðð ñ „_ðð
 ð;ð ;ñ „_ð;ð
 ðGð Gñ „_ðGð ðð ñ „_ðð ð ð ð r   r   )r±   Ú django.db.backends.base.featuresr   Údjango.utils.functionalr   r   r   r   r   ú<module>r¹      sq   ðØ €€€à AÐ AÐ AÐ AÐ AÐ AØ 3Ð 3Ð 3Ð 3Ð 3Ð 3ð^ð ^ð ^ð ^ð ^Ð+ñ ^ô ^ð ^ð ^ð ^r   