U
    d                     @   s<   d dl mZmZ d dlmZ d dlmZ G dd deZdS )    )DatabaseErrorInterfaceError)BaseDatabaseFeatures)cached_propertyc                	       s.  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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Z0dZ1dd	d
d
dZ2dZ3ddhddhddhdddhdhdhdhdhdZ4ddhZ5e6 fddZ7e6dd  Z8  Z9S )!DatabaseFeatures)   FTz
 FROM DUALz|
        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	BINARY_CIBINARYZ
SWEDISH_CI)cicsZnon_defaultZ
swedish_ciz$CURRENT_TIMESTAMP AT TIME ZONE 'UTC'z4db_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_1000zadb_functions.datetime.test_extract_trunc.DateFunctionTests.test_extract_second_func_no_fractionalzmdb_functions.datetime.test_extract_trunc.DateFunctionWithTimeZoneTests.test_extract_second_func_no_fractionalzCexpressions.tests.ExpressionOperatorTests.test_lefthand_bitwise_xorzHexpressions.tests.ExpressionOperatorTests.test_lefthand_bitwise_xor_nullzNexpressions.tests.ExpressionOperatorTests.test_lefthand_bitwise_xor_right_nullzHexpressions_window.tests.WindowFunctionTests.test_row_number_no_orderingz?model_fields.test_jsonfield.TestQuerying.test_usage_in_subqueryzMmigrations.test_operations.OperationTests.test_alter_field_pk_fk_db_collationzQqueries.test_qs_combinators.QuerySetSetOperationTests.test_union_in_with_ordering)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 extracts seconds including fractional seconds (#33517).z#Oracle doesn't support bitwise XOR.z9Oracle requires ORDER BY in row_number, ANSI:SQL doesn't.z&Raises ORA-00600: internal error code.zGOracle doesn't support changing collations on indexed columns (#33671).zUOracle raises an error when a subquery contains unnecessary ORDER BY clause (#32786).zFannotations.tests.NonAggregateAnnotationTestCase.test_custom_functionsz^annotations.tests.NonAggregateAnnotationTestCase.test_custom_functions_can_ref_other_functionsc                    s   t  jdddddddS )NZ	CharFieldZBigIntegerFieldZIntegerFieldZDateTimeField)ZGenericIPAddressFieldZPositiveBigIntegerFieldZPositiveIntegerFieldZPositiveSmallIntegerFieldZSmallIntegerFieldZ	TimeField)superintrospected_field_types)self	__class__ F/tmp/pip-unpacked-wheel-7vj2equ7/django/db/backends/oracle/features.pyr   ~   s    z)DatabaseFeatures.introspected_field_typesc                 C   s|   | j  h}z|d W nH tk
rb } z*|jd jdkrPW Y W 5 Q R  dS  W 5 d }~X Y nX W 5 Q R  dS Q R X d S )Nz,SELECT CAST('a' AS VARCHAR2(4001)) FROM dualr   i  FT)
connectioncursorexecuter   argscode)r   r   er   r   r   supports_collation_on_charfield   s    z0DatabaseFeatures.supports_collation_on_charfield):__name__
__module____qualname__Zminimum_database_versionZallows_group_by_lobZ!interprets_empty_strings_as_nullsZhas_select_for_updateZhas_select_for_update_nowaitZ!has_select_for_update_skip_lockedZhas_select_for_update_ofZselect_for_update_of_columnZcan_return_columns_from_insertZsupports_subqueries_in_group_byZ*ignores_unnecessary_order_by_in_subqueriesZsupports_transactionsZsupports_timezonesZhas_native_duration_fieldZcan_defer_constraint_checksZ.supports_partially_nullable_unique_constraintsZ&supports_deferrable_unique_constraintsZtruncates_namesZsupports_tablespacesZsupports_sequence_resetZ!can_introspect_materialized_viewsZatomic_transactionsZnulls_order_largestZrequires_literal_defaultsr   Zclosed_cursor_error_classZbare_select_suffixZ%supports_select_for_update_with_limitZsupports_temporal_subtractionZignores_table_name_caseZsupports_index_on_text_fieldZ(create_test_procedure_without_params_sqlZ(create_test_procedure_with_int_param_sqlZsupports_callproc_kwargsZsupports_over_clauseZ#supports_frame_range_fixed_distanceZsupports_ignore_conflictsZmax_query_paramsZsupports_partial_indexesZcan_rename_indexZ%supports_slicing_ordering_in_compoundZ*allows_multiple_constraints_on_same_fieldsZ&supports_boolean_expr_in_select_clauseZsupports_comparing_boolean_exprZ!supports_primitives_in_json_fieldZsupports_json_field_containsZsupports_collation_on_textfieldZtest_collationsZtest_now_utc_templateZdjango_test_skipsZdjango_test_expected_failuresr   r   r   __classcell__r   r   r   r   r      s   *r   N)Z	django.dbr   r   Z django.db.backends.base.featuresr   Zdjango.utils.functionalr   r   r   r   r   r   <module>   s   