
    ihx$                     V    d dl mZmZ d dlmZ d dlmZ d dlmZ  G d de          Z	dS )    )DatabaseErrorInterfaceError)BaseDatabaseFeatures)is_oracledb)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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Z0dZ1dZ2dZ3dZ4dZ5dd	hZ6d
Z7e8d             Z9e8 fd            Z:e8d             Z;e8d             Z<e8d             Z=e8d             Z>e8d             Z?e8d             Z@e8d             ZAe8d             ZB xZCS )DatabaseFeatures)   FTz|
        CREATE PROCEDURE "TEST_PROCEDURE" AS
            V_I INTEGER;
        BEGIN
            V_I := 1;
        END;
    z
        CREATE PROCEDURE "TEST_PROCEDURE" (P_I INTEGER) AS
            V_I INTEGER;
        BEGIN
            V_I := P_I;
        END;
    i  z$CURRENT_TIMESTAMP AT TIME ZONE 'UTC'zFannotations.tests.NonAggregateAnnotationTestCase.test_custom_functionsz^annotations.tests.NonAggregateAnnotationTestCase.test_custom_functions_can_ref_other_functionsz1INSERT INTO {} VALUES (DEFAULT, DEFAULT, DEFAULT)c                 (   ddhddhh dddhdhd	hd
hd}| j         j        dk     r|                    ddhi           | j         j        r|                    dh di           t          r(| j         j        dk    r|                    ddhi           |S )Nz4db_functions.text.test_sha224.SHA224Tests.test_basicz8db_functions.text.test_sha224.SHA224Tests.test_transformzVdb_functions.datetime.test_extract_trunc.DateFunctionTests.test_trunc_week_before_1000zbdb_functions.datetime.test_extract_trunc.DateFunctionWithTimeZoneTests.test_trunc_week_before_1000>   Cexpressions.tests.ExpressionOperatorTests.test_lefthand_bitwise_xorHexpressions.tests.ExpressionOperatorTests.test_lefthand_bitwise_xor_nullNexpressions.tests.ExpressionOperatorTests.test_lefthand_bitwise_xor_right_nullzHexpressions_window.tests.WindowFunctionTests.test_row_number_no_orderingz:prefetch_related.tests.PrefetchLimitTests.test_empty_orderzMmigrations.test_operations.OperationTests.test_alter_field_pk_fk_db_collationzIgeneric_relations_regress.tests.GenericRelationTests.test_textlink_filterz?lookup.tests.LookupQueryingTests.test_aggregate_combined_lookup)zOracle doesn't support SHA224.zwOracle doesn't correctly calculate ISO 8601 week numbering before 1583 (the Gregorian calendar was introduced in 1582).z#Oracle doesn't support bitwise XOR.z9Oracle requires ORDER BY in row_number, ANSI:SQL doesn't.zGOracle doesn't support changing collations on indexed columns (#33671).z1Oracle doesn't support comparing NCLOB to NUMBER.z1Oracle doesn't support casting filters to NUMBER.   z6Raises ORA-00600 on Oracle < 23c: internal error code.z?model_fields.test_jsonfield.TestQuerying.test_usage_in_subqueryz/Pooling does not support persistent connections>   Cbackends.oracle.tests.TransactionalTests.test_password_with_at_signGservers.tests.LiveServerTestCloseConnectionTest.test_closes_connectionsNbackends.base.test_base.ConnectionHealthChecksTests.test_health_checks_enabledObackends.base.test_base.ConnectionHealthChecksTests.test_health_checks_disabled]backends.base.test_base.ConnectionHealthChecksTests.test_set_autocommit_health_checks_enabled^backends.base.test_base.ConnectionHealthChecksTests.test_health_checks_enabled_errors_occurred)      r   zhpython-oracledb 2.1.2+ no longer hides 'ORA-1403: no data found' exceptions raised in database triggers.zLbackends.oracle.tests.TransactionalTests.test_hidden_no_data_found_exception)
connectionoracle_versionupdateis_poolr   oracledb_version)selfskipss     Y/var/www/histauto/venv/lib/python3.11/site-packages/django/db/backends/oracle/features.pydjango_test_skipsz"DatabaseFeatures.django_test_skipsY   s3    GJ/.LF4 4 4.LJ6X
'B
 RBA#
 #
H ?)E11LLL1O   ?" 	LLE H H H  $  		4?;yHHLL>>@       c                 @    i t                      j        dddddddS )N	CharFieldBigIntegerFieldIntegerFieldDateTimeField)GenericIPAddressFieldPositiveBigIntegerFieldPositiveIntegerFieldPositiveSmallIntegerFieldSmallIntegerField	TimeField)superintrospected_field_types)r   	__class__s    r    r/   z)DatabaseFeatures.introspected_field_types   s=    
gg.
%0'8$2)7!/(
 
 
 	
r"   c                 $    dddd| j         rdnd dS )N	BINARY_CIBINARY
SWEDISH_CI)cicsnon_default
swedish_civirtual)supports_collation_on_charfieldr   s    r    test_collationsz DatabaseFeatures.test_collations   s/     '&'+'KU||QU
 
 	
r"   c                 "   d| j         z   }| j                                        5 }	 |                    |           n:# t          $ r-}|j        d         j        dk    rY d }~d d d            dS  d }~ww xY w	 d d d            dS # 1 swxY w Y   d S )Nz"SELECT CAST('a' AS VARCHAR2(4001))r   i  FT)bare_select_suffixr   cursorexecuter   argscode)r   sqlr?   es       r    r:   z0DatabaseFeatures.supports_collation_on_charfield   s   2T5LL_##%% 	s####    6!9>S(( 555	 	 	 	 	 	 	 	  	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	s=   B<B
A3A.B-A..A33BBBc                 "    | j         j        dk    S N)   r   r   r;   s    r    !supports_primitives_in_json_fieldz2DatabaseFeatures.supports_primitives_in_json_field       -66r"   c                 "    | j         j        dk    S rF   rH   r;   s    r    supports_frame_exclusionz)DatabaseFeatures.supports_frame_exclusion   rJ   r"   c                 "    | j         j        dk    S Nr   rH   r;   s    r    &supports_boolean_expr_in_select_clausez7DatabaseFeatures.supports_boolean_expr_in_select_clause   rJ   r"   c                 "    | j         j        dk    S rN   rH   r;   s    r    supports_comparing_boolean_exprz0DatabaseFeatures.supports_comparing_boolean_expr   rJ   r"   c                 "    | j         j        dk    S rN   rH   r;   s    r    (supports_aggregation_over_interval_typesz9DatabaseFeatures.supports_aggregation_over_interval_types   rJ   r"   c                 *    | j         j        dk    rdndS )Nr    z
 FROM DUALrH   r;   s    r    r>   z#DatabaseFeatures.bare_select_suffix   s    _3u<<rr,Nr"   )D__name__
__module____qualname__minimum_database_versionallows_group_by_loballows_group_by_select_index!interprets_empty_strings_as_nullshas_select_for_updatehas_select_for_update_nowait!has_select_for_update_skip_lockedhas_select_for_update_ofselect_for_update_of_columncan_return_columns_from_insertsupports_subqueries_in_group_by*ignores_unnecessary_order_by_in_subqueriessupports_transactionssupports_timezoneshas_native_duration_fieldcan_defer_constraint_checks.supports_partially_nullable_unique_constraints&supports_deferrable_unique_constraintstruncates_namessupports_commentssupports_tablespacessupports_sequence_reset!can_introspect_materialized_viewsatomic_transactionsnulls_order_largestrequires_literal_defaults'supports_default_keyword_in_bulk_insertr   closed_cursor_error_class%supports_select_for_update_with_limitsupports_temporal_subtractionignores_table_name_casesupports_index_on_text_field(create_test_procedure_without_params_sql(create_test_procedure_with_int_param_sqlsupports_callproc_kwargssupports_over_clause#supports_frame_range_fixed_distancesupports_ignore_conflictsmax_query_paramssupports_partial_indexes!supports_stored_generated_columns"supports_virtual_generated_columnscan_rename_index%supports_slicing_ordering_in_compound#requires_compound_order_by_subquery*allows_multiple_constraints_on_same_fieldssupports_json_field_containssupports_collation_on_textfieldsupports_tuple_lookupstest_now_utc_templatedjango_test_expected_failuresinsert_test_table_with_defaultsr   r!   r/   r<   r:   rI   rL   rO   rQ   rS   r>   __classcell__)r0   s   @r    r	   r	      s       $   $) (,% #' (,%#"&%)"&+#16.  $"&5:2-1*O#(,% $.3+ . -2)$(! ##( 0,0,  $*.' % $(-%)-&,0)*.'16.#( &+#"B 	Q	8%! 	< $ K K _KZ 	
 	
 	
 	
 _	
 
 
 _
 	 	 _	 7 7 _7 7 7 _7 7 7 _7 7 7 _7 7 7 _7 O O _O O O O Or"   r	   N)
	django.dbr   r    django.db.backends.base.featuresr   &django.db.backends.oracle.oracledb_anyr   django.utils.functionalr   r	    r"   r    <module>r      s    3 3 3 3 3 3 3 3 A A A A A A > > > > > > 3 3 3 3 3 3XO XO XO XO XO+ XO XO XO XO XOr"   