관리-도구
편집 파일: requirements.cpython-311.pyc
� �܋f'� � �b � d Z ddlZddlmZ ddlmZ G d� de� � Z G d � d e� � ZdS ) z�Global database feature support policy. Provides decorators to mark tests requiring specific feature support from the target database. External dialect test suites should subclass SuiteRequirements to provide specific inclusion/exclusions. � N� )� exclusions� )�utilc � � e Zd ZdS )� RequirementsN)�__name__� __module__� __qualname__� � �r/builddir/build/BUILD/cloudlinux-venv-1.0.6/venv/lib64/python3.11/site-packages/sqlalchemy/testing/requirements.pyr r s � � � � � ��Dr r c � � e Zd Zed� � � Zed� � � Zed� � � Zed� � � Zed� � � Zed� � � Z ed� � � Z ed� � � Z ed � � � Z ed � � � Z ed � � � Zed � � � Zed � � � Zed� � � Zed� � � Zed� � � Zed� � � Zed� � � Zed� � � Zed� � � Zed� � � Zed� � � Zed� � � Zed� � � Zed� � � Z ed� � � Z ed� � � Z ed � � � Z ed � � � Z ed � � � Z!ed � � � Z"ed � � � Z#ed!� � � Z$ed"� � � Z%ed#� � � Z&ed$� � � Z'ed%� � � Z(ed&� � � Z)ed'� � � Z*ed(� � � Z+ed)� � � Z,ed*� � � Z-ed+� � � Z.ed,� � � Z/ed-� � � Z0ed.� � � Z1ed/� � � Z2ed0� � � Z3ed1� � � Z4ed2� � � Z5ed3� � � Z6ed4� � � Z7ed5� � � Z8ed6� � � Z9ed7� � � Z:ed8� � � Z;ed9� � � Z<ed:� � � Z=ed;� � � Z>ed<� � � Z?ed=� � � Z@ed>� � � ZAed?� � � ZBed@� � � ZCedA� � � ZDedB� � � ZEedC� � � ZFedD� � � ZGedE� � � ZHedF� � � ZIedG� � � ZJedH� � � ZKedI� � � ZLedJ� � � ZMedK� � � ZNedL� � � ZOedM� � � ZPedN� � � ZQedO� � � ZRedP� � � ZSedQ� � � ZTedR� � � ZUedS� � � ZVedT� � � ZWedU� � � ZXedV� � � ZYedW� � � ZZedX� � � Z[edY� � � Z\edZ� � � Z]ed[� � � Z^ed\� � � Z_d]� Z`ed^� � � Zaed_� � � Zbed`� � � Zceda� � � Zdedb� � � Zeedc� � � Zfedd� � � Zgede� � � Zhedf� � � Ziedg� � � Zjedh� � � Zkedi� � � Zledj� � � Zmedk� � � Znedl� � � Zoedm� � � Zpedn� � � Zqedo� � � Zredp� � � Zsedq� � � Ztedr� � � Zueds� � � Zvedt� � � Zwedu� � � Zxedv� � � Zyedw� � � Zzedx� � � Z{edy� � � Z|edz� � � Z}d{� Z~ed|� � � Zed}� � � Z�ed~� � � Z�ed� � � Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�d�� Z�d�� Z�ed�� � � Z�ed�� � � Z�d�� Z�d�� Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�ed�� � � Z�d�S )��SuiteRequirementsc �( � t j � � S )z/target platform can emit basic CreateTable DDL.�r �open��selfs r � create_tablez SuiteRequirements.create_table � � � �� � � r c �( � t j � � S )z-target platform can emit basic DropTable DDL.r r s r � drop_tablez SuiteRequirements.drop_table# r r c �( � t j � � S )z*Target database must support foreign keys.r r s r � foreign_keysz SuiteRequirements.foreign_keys) r r c �( � t j � � S )zQtarget database must support ON UPDATE..CASCADE behavior in foreign keys.r r s r �on_update_cascadez#SuiteRequirements.on_update_cascade/ � � � �� � � r c �( � t j � � S )zWtarget database must *not* support ON UPDATE..CASCADE behavior in foreign keys.�r �closedr s r �non_updating_cascadez&SuiteRequirements.non_updating_cascade6 � � � � �"�"�"r c �( � t j � � S �Nr r s r �deferrable_fksz SuiteRequirements.deferrable_fks< � � �� �"�"�"r c �2 � � t j � fd�� � S )Nc �4 �� � j j p � j j S r% )r �enabledr& r s �r �<lambda>z?SuiteRequirements.on_update_or_deferrable_fks.<locals>.<lambda>F s �� �D�*�2� +��"�*� r �r �only_ifr s `r �on_update_or_deferrable_fksz-SuiteRequirements.on_update_or_deferrable_fks@ s. �� � �!� +� +� +� +� � � r c �( � t j � � S )z;Target database must support self-referential foreign keys.r r s r � self_referential_foreign_keysz/SuiteRequirements.self_referential_foreign_keysJ r r c �( � t j � � S )z=Target database must support the DDL phrases for FOREIGN KEY.r r s r �foreign_key_ddlz!SuiteRequirements.foreign_key_ddlP r r c �( � t j � � S )z3target database must support names for constraints.r r s r �named_constraintsz#SuiteRequirements.named_constraintsV r r c �( � t j � � S )z(Target database must support subqueries.r r s r � subqueriesz SuiteRequirements.subqueries\ r r c �( � t j � � S )zRtarget database can render OFFSET, or an equivalent, in a SELECT. r r s r �offsetzSuiteRequirements.offsetb � � � �� � � r c �( � t j � � S )zWtarget database can render LIMIT and/or OFFSET using a bound parameter r r s r �bound_limit_offsetz$SuiteRequirements.bound_limit_offsetj r9 r c �( � t j � � S )z�target database can render LIMIT and/or OFFSET with a complete SQL expression, such as one that uses the addition operator. parameter r r s r �sql_expression_limit_offsetz-SuiteRequirements.sql_expression_limit_offsetr � � � �� � � r c �( � t j � � S )z�Target database must support parenthesized SELECT in UNION when LIMIT/OFFSET is specifically present. E.g. (SELECT ...) UNION (SELECT ..) This is known to fail on SQLite. r r s r �/parens_in_union_contained_select_w_limit_offsetzASuiteRequirements.parens_in_union_contained_select_w_limit_offset{ � � � �� � � r c �( � t j � � S )al Target database must support parenthesized SELECT in UNION when OFFSET/LIMIT is specifically not present. E.g. (SELECT ... LIMIT ..) UNION (SELECT .. OFFSET ..) This is known to fail on SQLite. It also fails on Oracle because without LIMIT/OFFSET, there is currently no step that creates an additional subquery. r r s r �0parens_in_union_contained_select_wo_limit_offsetzBSuiteRequirements.parens_in_union_contained_select_wo_limit_offset� s � � �� � � r c �( � t j � � S )z;Target database must support boolean expressions as columnsr r s r �boolean_col_expressionsz)SuiteRequirements.boolean_col_expressions� r# r c �( � t j � � S )z5Target database allows boolean columns to store NULL.r r s r �nullable_booleansz#SuiteRequirements.nullable_booleans� r r c �( � t j � � S )z,Target backends that support nulls ordering.r r s r � nullsorderingz SuiteRequirements.nullsordering� r# r c �( � t j � � S )z�target database/driver supports bound parameters as column expressions without being in the context of a typed column. r r s r �standalone_bindsz"SuiteRequirements.standalone_binds� � � � � �"�"�"r c �( � t j � � S )z�target database/driver supports bound parameters with NULL in the WHERE clause, in situations where it has to be typed. r r s r �!standalone_null_binds_whereclausez3SuiteRequirements.standalone_null_binds_whereclause� r9 r c �( � t j � � S )z5Target database must support INTERSECT or equivalent.r r s r � intersectzSuiteRequirements.intersect� � � � � �"�"�"r c �( � t j � � S )z?Target database must support EXCEPT or equivalent (i.e. MINUS).r r s r �except_zSuiteRequirements.except_� rQ r c �( � t j � � S )z.Target database must support window functions.r r s r �window_functionsz"SuiteRequirements.window_functions� rQ r c �( � t j � � S )z Target database supports CTEsr r s r �cteszSuiteRequirements.ctes� r# r c �( � t j � � S )z�target database supports CTES that ride on top of a normal UPDATE or DELETE statement which refers to the CTE in a correlated subquery. r r s r �ctes_with_update_deletez)SuiteRequirements.ctes_with_update_delete� � � � � �"�"�"r c �( � t j � � S )z}target database supports CTES which consist of INSERT, UPDATE or DELETE *within* the CTE, e.g. WITH x AS (UPDATE....)r r s r � ctes_on_dmlz SuiteRequirements.ctes_on_dml� � � � � �"�"�"r c �( � t j � � S )z~target platform generates new surrogate integer primary key values when insert() is executed, excluding the pk column.r r s r �autoincrement_insertz&SuiteRequirements.autoincrement_insert� r r c �( � t j � � S )a# target platform will allow cursor.fetchone() to proceed after a COMMIT. Typically this refers to an INSERT statement with RETURNING which is invoked within "autocommit". If the row can be returned after the autocommit, then this rule can be open. r r s r �fetch_rows_post_commitz(SuiteRequirements.fetch_rows_post_commit� s � � �� � � r c �( � t j � � S )z�target platform supports SQL expressions in GROUP BY e.g. SELECT x + y AS somelabel FROM table GROUP BY x + y r r s r �group_by_complex_expressionz-SuiteRequirements.group_by_complex_expression� rA r c �. � t j d� d� � S )Nc �& � | j j j S r% )�db�dialect�supports_sane_rowcount��configs r r+ z1SuiteRequirements.sane_rowcount.<locals>.<lambda>� s � �v�y� 0� G�G� r z&driver doesn't support 'sane' rowcount�r �skip_ifr s r � sane_rowcountz SuiteRequirements.sane_rowcount� s � ��!� G� G� 4� � � r c �. � t j d� d� � S )Nc �& � | j j j S r% )rf rg � supports_sane_multi_rowcountri s r r+ z7SuiteRequirements.sane_multi_rowcount.<locals>.<lambda> s � �v�y� 0� M�M� r z;driver %(driver)s %(doesnt_support)s 'sane' multi row count�r �fails_ifr s r �sane_multi_rowcountz%SuiteRequirements.sane_multi_rowcount s � ��"� M� M� I� � � r c �. � t j d� d� � S )Nc �& � | j j j S r% )rf rg � supports_sane_rowcount_returningri s r r+ z=SuiteRequirements.sane_rowcount_w_returning.<locals>.<lambda> s � �� �!�B� � r z;driver doesn't support 'sane' rowcount when returning is onrq r s r �sane_rowcount_w_returningz+SuiteRequirements.sane_rowcount_w_returning s' � ��"� � � J� � � r c �. � t j d� d� � S )zatarget platform supports INSERT with no values, i.e. INSERT DEFAULT VALUES or equivalent.c �F � | j j j p| j j j S r% )rf rg �supports_empty_insert�supports_default_valuesri s r r+ z1SuiteRequirements.empty_inserts.<locals>.<lambda> s! � �6�9�,�B� 9��y� �8� r zempty inserts not supportedr, r s r � empty_insertsz SuiteRequirements.empty_inserts s& � � �!� 9� 9� )� � � r c �( � t j � � S )z.target platform supports INSERT from a SELECT.r r s r �insert_from_selectz$SuiteRequirements.insert_from_select r r c �. � t j d� d� � S )z#target platform supports RETURNING.c �$ � | j j j S r% )rf rg �implicit_returningri s r r+ z-SuiteRequirements.returning.<locals>.<lambda>) s � �6�9�,�?� r z)%(database)s %(does_support)s 'returning'r, r s r � returningzSuiteRequirements.returning$ s" � � �!� ?� ?� 7� � � r c �( � t j � � S )zZTarget platform supports the syntax "(x, y) IN ((x1, y1), (x2, y2), ...)" r r s r �tuple_inzSuiteRequirements.tuple_in- rL r c � � | j S )z%Target platform tuple IN w/ empty set)r� r s r �tuple_in_w_emptyz"SuiteRequirements.tuple_in_w_empty5 s � � �}� r c �( � t j � � S )zwtarget platform supports a SELECT statement that has the same name repeated more than once in the columns list.r r s r �%duplicate_names_in_cursor_descriptionz7SuiteRequirements.duplicate_names_in_cursor_description: r r c �. � t j d� d� � S )z[Target database must have 'denormalized', i.e. UPPERCASE as case insensitive names.c �& � | j j j S r% )rf rg �requires_name_normalizeri s r r+ z6SuiteRequirements.denormalized_names.<locals>.<lambda>G s � �v�y� 0� H�H� r z,Backend does not require denormalized names.rk r s r �denormalized_namesz$SuiteRequirements.denormalized_namesA s" � � �!� H� H� :� � � r c �. � t j d� d� � S )zTtarget database must support multiple VALUES clauses in an INSERT statement.c �& � | j j j S r% )rf rg �supports_multivalues_insertri s r r+ z7SuiteRequirements.multivalues_inserts.<locals>.<lambda>Q s � �v�y� 0� L�L� r z*Backend does not support multirow inserts.rk r s r �multivalues_insertsz%SuiteRequirements.multivalues_insertsK s" � � �!� L� L� 8� � � r c �( � t j � � S )zvtarget dialect implements the executioncontext.get_lastrowid() method without reliance on RETURNING. r r s r �implements_get_lastrowidz*SuiteRequirements.implements_get_lastrowidU r9 r c �( � t j � � S )a< target dialect retrieves cursor.lastrowid, or fetches from a database-side function after an insert() construct executes, within the get_lastrowid() method. Only dialects that "pre-execute", or need RETURNING to get last inserted id, would return closed/fail/skip for this. r r s r �emulated_lastrowidz$SuiteRequirements.emulated_lastrowid] � � � � �"�"�"r c �( � t j � � S )z]target platform includes a 'lastrowid' accessor on the DBAPI cursor object. r r s r �dbapi_lastrowidz!SuiteRequirements.dbapi_lastrowidi rL r c �( � t j � � S )z#Target database must support VIEWs.r r s r �viewszSuiteRequirements.viewsq r# r c �( � t j � � S )zXTarget database must support external schemas, and have one named 'test_schema'.r r s r �schemaszSuiteRequirements.schemasw r] r c �( � t j � � S )zJtarget system must support reflection of inter-schema foreign keysr r s r �cross_schema_fk_reflectionz,SuiteRequirements.cross_schema_fk_reflection~ r# r c �( � t j � � S )a Target supports refleciton of FOREIGN KEY constraints and will return the name of the constraint that was used in the "CONSTRANT <name> FOREIGN KEY" DDL. MySQL prior to version 8 and MariaDB prior to version 10.5 don't support this. r r s r �&foreign_key_constraint_name_reflectionz8SuiteRequirements.foreign_key_constraint_name_reflection� r� r c �( � t j � � S )z�target system has a strong concept of 'default' schema that can be referred to implicitly. basically, PostgreSQL. r r s r �implicit_default_schemaz)SuiteRequirements.implicit_default_schema� � � � � �"�"�"r c �0 � t j d� gd� � S )z0Target dialect must support server side cursors.c �$ � | j j j S r% )rf rg � supports_server_side_cursorsri s r r+ z7SuiteRequirements.server_side_cursors.<locals>.<lambda>� s � �F�I� -� J� r z no server side cursors supportr, r s r �server_side_cursorsz%SuiteRequirements.server_side_cursors� s% � � �!� J� J� K� ,� � � r c �0 � t j d� gd� � S )z'Target database must support SEQUENCEs.c �$ � | j j j S r% )rf rg �supports_sequencesri s r r+ z-SuiteRequirements.sequences.<locals>.<lambda>� s � �F�I� -� @� r zno sequence supportr, r s r � sequenceszSuiteRequirements.sequences� s% � � �!� @� @� A� !� � � r c �0 � t j d� gd� � S )zgTarget database supports sequences, but also optionally as a means of generating new PK values.c �F � | j j j o| j j j S r% )rf rg r� �sequences_optionalri s r r+ z6SuiteRequirements.sequences_optional.<locals>.<lambda>� s! � �v�y� 0� C� 9��I�%�8� r z.no sequence support, or sequences not optionalr, r s r r� z$SuiteRequirements.sequences_optional� s- � � �!�9� 9� � =� � � r c �. � t j d� g� � S )a target database / driver supports cursor.lastrowid as a means of retrieving the last inserted primary key value. note that if the target DB supports sequences also, this is still assumed to work. This is a new use case brought on by MariaDB 10.3. c �$ � | j j j S r% )rf rg �postfetch_lastrowidri s r r+ z6SuiteRequirements.supports_lastrowid.<locals>.<lambda>� s � �F�I� -� A� r r, r s r �supports_lastrowidz$SuiteRequirements.supports_lastrowid� s" � � �!� A� A� B� � � r c �4 � t j | j � � S )z"the opposite of supports_lastrowid)r � NotPredicater� r s r �no_lastrowid_supportz&SuiteRequirements.no_lastrowid_support� s � � �&�t�'>�?�?�?r c �( � t j � � S r% r r s r �reflects_pk_namesz#SuiteRequirements.reflects_pk_names� r' r c �( � t j � � S r% r r s r �table_reflectionz"SuiteRequirements.table_reflection� � � ��� � � r c �( � t j � � S r% r r s r �comment_reflectionz$SuiteRequirements.comment_reflection� r' r c � � | j S )z�target database must support retrieval of the columns in a view, similarly to how a table is inspected. This does not include the full CREATE VIEW definition. �r� r s r �view_column_reflectionz(SuiteRequirements.view_column_reflection� s � � �z�r c � � | j S )zStarget database must support inspection of the full CREATE VIEW definition.r� r s r �view_reflectionz!SuiteRequirements.view_reflection� s � � �z�r c � � | j S r% )r� r s r �schema_reflectionz#SuiteRequirements.schema_reflection� s � ��|�r c �( � t j � � S r% r r s r �!primary_key_constraint_reflectionz3SuiteRequirements.primary_key_constraint_reflection� r� r c �( � t j � � S r% r r s r �!foreign_key_constraint_reflectionz3SuiteRequirements.foreign_key_constraint_reflection� r� r c �( � t j � � S r% r r s r �1foreign_key_constraint_option_reflection_ondeletezCSuiteRequirements.foreign_key_constraint_option_reflection_ondelete� r' r c �( � t j � � S r% r r s r �1foreign_key_constraint_option_reflection_onupdatezCSuiteRequirements.foreign_key_constraint_option_reflection_onupdate� r' r c �( � t j � � S r% r r s r �temp_table_reflectionz'SuiteRequirements.temp_table_reflection� r� r c �( � t j � � S )z8target dialect supports listing of temporary table namesr r s r �temp_table_namesz"SuiteRequirements.temp_table_names� rQ r c �( � t j � � S )z)target database supports temporary tablesr r s r �temporary_tablesz"SuiteRequirements.temporary_tables � � � �� � � r c �( � t j � � S )z(target database supports temporary viewsr r s r �temporary_viewsz!SuiteRequirements.temporary_views rQ r c �( � t j � � S r% r r s r �index_reflectionz"SuiteRequirements.index_reflection r� r c �( � t j � � S )z?target database supports CREATE INDEX with per-column ASC/DESC.r r s r �indexes_with_ascdescz&SuiteRequirements.indexes_with_ascdesc r� r c �( � t j � � S )z>target database supports CREATE INDEX against SQL expressions.r r s r �indexes_with_expressionsz*SuiteRequirements.indexes_with_expressions rQ r c �( � t j � � S )z8target dialect supports reflection of unique constraintsr r s r � unique_constraint_reflectionz.SuiteRequirements.unique_constraint_reflection r� r c �( � t j � � S )z7target dialect supports reflection of check constraintsr r s r �check_constraint_reflectionz-SuiteRequirements.check_constraint_reflection! rQ r c �( � t j � � S )z�target dialect raises IntegrityError when reporting an INSERT with a primary key violation. (hint: it should) r r s r �$duplicate_key_raises_integrity_errorz6SuiteRequirements.duplicate_key_raises_integrity_error& r9 r c �( � t j � � S )z3Target database must support VARCHAR with no lengthr r s r �unbounded_varcharz#SuiteRequirements.unbounded_varchar. r r c �( � t j � � S )z�Target database/dialect must support Python unicode objects with non-ASCII characters represented, delivered as bound parameters as well as in result rows. r r s r � unicode_dataz SuiteRequirements.unicode_data4 r> r c �( � t j � � S )zRTarget driver must support some degree of non-ascii symbol names. r r s r � unicode_ddlz SuiteRequirements.unicode_ddl= r] r c �( � t j � � S )z?Target driver can create tables with a name like 'some " table'r r s r �symbol_names_w_double_quotez-SuiteRequirements.symbol_names_w_double_quoteD r� r c �( � t j � � S )z�target dialect supports rendering of a date, time, or datetime as a literal string, e.g. via the TypeEngine.literal_processor() method. r r s r �datetime_literalsz#SuiteRequirements.datetime_literalsI rZ r c �( � t j � � S )zUtarget dialect supports representation of Python datetime.datetime() objects.r r s r �datetimezSuiteRequirements.datetimeR r r c �( � t j � � S )zftarget dialect supports representation of Python datetime.datetime() with microsecond objects.r r s r �datetime_microsecondsz'SuiteRequirements.datetime_microsecondsY r r c �( � t j � � S )z�target dialect supports representation of Python datetime.datetime() with microsecond objects but only if TIMESTAMP is used.r r s r �timestamp_microsecondsz(SuiteRequirements.timestamp_microseconds` r] r c �( � t j � � S �zutarget dialect supports representation of Python datetime.datetime() objects with historic (pre 1970) values.r r s r �datetime_historicz#SuiteRequirements.datetime_historicg r] r c �( � t j � � S )zQtarget dialect supports representation of Python datetime.date() objects.r r s r �datezSuiteRequirements.daten r r c �( � t j � � S )zPtarget dialect accepts a datetime object as the target of a date column.r r s r �date_coerces_from_datetimez,SuiteRequirements.date_coerces_from_datetimeu r r c �( � t j � � S r� r r s r � date_historicz SuiteRequirements.date_historic| r] r c �( � t j � � S )zQtarget dialect supports representation of Python datetime.time() objects.r r s r �timezSuiteRequirements.time� r r c �( � t j � � S )zbtarget dialect supports representation of Python datetime.time() with microsecond objects.r r s r �time_microsecondsz#SuiteRequirements.time_microseconds� r r c �( � t j � � S )zttarget database/driver can allow BLOB/BINARY fields to be compared against a bound parameter value. r r s r �binary_comparisonsz$SuiteRequirements.binary_comparisons� r9 r c �( � t j � � S )a! target backend supports simple binary literals, e.g. an expression like:: SELECT CAST('foo' AS BINARY) Where ``BINARY`` is the type emitted from :class:`.LargeBinary`, e.g. it could be ``BLOB`` or similar. Basically fails on Oracle. r r s r �binary_literalsz!SuiteRequirements.binary_literals� � � � �� � � r c �( � t j � � S )z:target dialect supports 'AUTOCOMMIT' as an isolation_levelr r s r � autocommitz SuiteRequirements.autocommit� rQ r c �( � t j � � S )z�target dialect supports general isolation level settings. Note that this requirement, when enabled, also requires that the get_isolation_levels() method be implemented. r r s r �isolation_levelz!SuiteRequirements.isolation_level� r� r c � � dS )a� Return a structure of supported isolation levels for the current testing dialect. The structure indicates to the testing suite what the expected "default" isolation should be, as well as the other values that are accepted. The dictionary has two keys, "default" and "supported". The "supported" key refers to a list of all supported levels and it should include AUTOCOMMIT if the dialect supports it. If the :meth:`.DefaultRequirements.isolation_level` requirement is not open, then this method has no return value. E.g.:: >>> testing.requirements.get_isolation_levels() { "default": "READ_COMMITED", "supported": [ "SERIALIZABLE", "READ UNCOMMITTED", "READ COMMITTED", "REPEATABLE READ", "AUTOCOMMIT" ] } Nr �r rj s r �get_isolation_levelsz&SuiteRequirements.get_isolation_levels� s � � � r c �( � t j � � S )z.target platform implements a native JSON type.r r s r � json_typezSuiteRequirements.json_type� r# r c � � | j S )zNtarget platform supports numeric array indexes within a JSON structure)r r s r �json_array_indexesz$SuiteRequirements.json_array_indexes� s � � �~� r c �( � t j � � S r% r r s r �(json_index_supplementary_unicode_elementz:SuiteRequirements.json_index_supplementary_unicode_element� r� r c �( � t j � � S )zRtarget backend has general support for moderately high-precision numerics.r r s r �precision_numerics_generalz,SuiteRequirements.precision_numerics_general� r r c �( � t j � � S )zbtarget backend supports Decimal() objects using E notation to represent very small values.r r s r �"precision_numerics_enotation_smallz4SuiteRequirements.precision_numerics_enotation_small� r# r c �( � t j � � S )zbtarget backend supports Decimal() objects using E notation to represent very large values.r r s r �"precision_numerics_enotation_largez4SuiteRequirements.precision_numerics_enotation_large� r# r c �( � t j � � S )z�target backend supports values with many digits on both sides, such as 319438950232418390.273596, 87673.594069654243 r r s r �*precision_numerics_many_significant_digitsz<SuiteRequirements.precision_numerics_many_significant_digits� rL r c �( � t j � � S )a- target backend will return a selected Decimal as a Decimal, not a string. e.g.:: expr = decimal.Decimal("15.7563") value = e.scalar( select([literal(expr)]) ) assert value == expr See :ticket:`4036` r r s r �implicit_decimal_bindsz(SuiteRequirements.implicit_decimal_binds� s � �& �� � � r c �( � t j � � S )zhtarget database can select an aggregate from a subquery that's also using an aggregate r r s r �nested_aggregatesz#SuiteRequirements.nested_aggregates r9 r c �( � t j � � S )zbtarget database must support ON DELETE CASCADE on a self-referential foreign key r r s r �recursive_fk_cascadez&SuiteRequirements.recursive_fk_cascade r9 r c �( � t j � � S )z�A precision numeric type will return empty significant digits, i.e. a value such as 10.000 will come back in Decimal form with the .000 maintained.r r s r �-precision_numerics_retains_significant_digitsz?SuiteRequirements.precision_numerics_retains_significant_digits" rL r c �( � t j � � S )z�target backend will return native floating point numbers with at least seven decimal places when using the generic Float type. r r s r � precision_generic_float_typez.SuiteRequirements.precision_generic_float_type* r9 r c �( � t j � � S )z�target backend can return a floating-point number with four significant digits (such as 15.7563) accurately (i.e. without FP inaccuracies, such as 15.75629997253418). r r s r �floats_to_four_decimalsz)SuiteRequirements.floats_to_four_decimals2 r> r c �( � t j � � S )z�target backend doesn't crash when you try to select a NUMERIC value that has a value of NULL. Added to support Pyodbc bug #351. r r s r �fetch_null_from_numericz)SuiteRequirements.fetch_null_from_numeric; � � � �� � � r c �( � t j � � S )zUTarget database must support an unbounded Text() " "type such as TEXT or CLOBr r s r � text_typezSuiteRequirements.text_typeE r r c �( � t j � � S )zTtarget database can persist/return an empty string with a varchar. r r s r �empty_strings_varcharz'SuiteRequirements.empty_strings_varcharL r9 r c �( � t j � � S )zRtarget database can persist/return an empty string with an unbounded text.r r s r �empty_strings_textz$SuiteRequirements.empty_strings_textT r r c �( � t j � � S )zUtarget database supports use of an unbounded textual field in a WHERE clause.r r s r �"expressions_against_unbounded_textz4SuiteRequirements.expressions_against_unbounded_text[ r r c �( � t j � � S )z;target driver must support the literal statement 'select 1'r r s r � selectonezSuiteRequirements.selectoneb r� r c �( � t j � � S )z(Target database must support savepoints.r r s r � savepointsz SuiteRequirements.savepointsg r# r c �( � t j � � S )z4Target database must support two-phase transactions.r r s r �two_phase_transactionsz(SuiteRequirements.two_phase_transactionsm r# r c �( � t j � � S )z'Target must support UPDATE..FROM syntaxr r s r � update_fromz SuiteRequirements.update_froms rQ r c �( � t j � � S )z=Target must support DELETE FROM..FROM or DELETE..USING syntaxr r s r � delete_fromz SuiteRequirements.delete_fromx rQ r c �( � t j � � S )a� Target must support UPDATE (or DELETE) where the same table is present in a subquery in the WHERE clause. This is an ANSI-standard syntax that apparently MySQL can't handle, such as:: UPDATE documents SET flag=1 WHERE documents.title IN (SELECT max(documents.title) AS title FROM documents GROUP BY documents.user_id ) r r s r � update_where_target_in_subqueryz1SuiteRequirements.update_where_target_in_subquery} r r c �( � t j � � S )zOtarget database must use a plain percent '%' as the 'modulus' operator.r r s r � mod_operator_as_percent_signz.SuiteRequirements.mod_operator_as_percent_sign� r# r c �( � t j � � S )a target backend supports weird identifiers with percent signs in them, e.g. 'some % column'. this is a very weird use case but often has problems because of DBAPIs that use python formatting. It's not a critical use case either. r r s r �percent_schema_namesz&SuiteRequirements.percent_schema_names� r� r c �( � t j � � S )z�target database supports ordering by a column from a SELECT inside of a UNION E.g. (SELECT id, ...) UNION (SELECT id, ...) ORDER BY id r r s r �order_by_col_from_unionz)SuiteRequirements.order_by_col_from_union� r% r c �( � t j � � S )a target backend supports ORDER BY a column label within an expression. Basically this:: select data as foo from test order by foo || 'bar' Lots of databases including PostgreSQL don't support this, so this is off by default. r r s r � order_by_label_with_expressionz0SuiteRequirements.order_by_label_with_expression� s � � � �"�"�"r c �6 � � � fd�}t j |� � S )Nc �V �� �� | � � dS # t $ r Y dS w xY w)NFT)�get_order_by_collation�NotImplementedError)rj r s �r �checkz3SuiteRequirements.order_by_collation.<locals>.check� sC �� � ��+�+�F�3�3�3� �u��&� � � ��t�t� ���s � � (�(rk )r rF s ` r �order_by_collationz$SuiteRequirements.order_by_collation� s/ �� � � � � � � �!�%�(�(�(r c � � t � � �r% )rE r s r rD z(SuiteRequirements.get_order_by_collation� s � �!�#�#�#r c �( � t j � � S )zUTarget driver must support non-ASCII characters being passed at all. r r s r �unicode_connectionsz%SuiteRequirements.unicode_connections� r r c �( � t j � � S )z�Target driver must raise a DBAPI-level exception, such as InterfaceError, when the underlying connection has been closed and the execute() method is called. r r s r �graceful_disconnectsz&SuiteRequirements.graceful_disconnects� r9 r c �( � t j � � S )zU Target must support simultaneous, independent database connections. r r s r �independent_connectionsz)SuiteRequirements.independent_connections� r r c �( � t j � � S )z9Catchall for a large variety of MySQL on Windows failuresr r s r �skip_mysql_on_windowsz'SuiteRequirements.skip_mysql_on_windows� r� r c �, � t j d� � � S )a Test environment must allow ad-hoc engine/connection creation. DBs that scale poorly for many connections, even when closed, i.e. Oracle, may use the "--low-connections" option which flags this requirement as not present. c � � | j j S r% )�options�low_connectionsri s r r+ z2SuiteRequirements.ad_hoc_engines.<locals>.<lambda>� s � �6�>�9� r rk r s r �ad_hoc_enginesz SuiteRequirements.ad_hoc_engines� s � � �!� 9� 9� � � r c �* � t j d� � S )N�timing_intensive�r � requires_tagr s r rW z"SuiteRequirements.timing_intensive� � � ��&�'9�:�:�:r c �* � t j d� � S )N�memory_intensiverX r s r r\ z"SuiteRequirements.memory_intensive� rZ r c �. � t j d� d� � S )z�Mark tests that use threading and mock at the same time - stability issues have been observed with coverage + python 3.3 c �2 � t j o | j j S r% )r �py3krS � has_coverageri s r r+ z7SuiteRequirements.threading_with_mock.<locals>.<lambda>� s � �4�9�D�� �)D� r z%Stability issues with coverage + py3krk r s r �threading_with_mockz%SuiteRequirements.threading_with_mock� s" � � �!� D� D� 3� � � r c �. � t j d� d� � S )Nc �" � t j dk S �N)� ��sys� version_infor r r r+ z+SuiteRequirements.python2.<locals>.<lambda> s � �C�$��,� r z Python version 2.xx is required.rk r s r �python2zSuiteRequirements.python2 s � ��!� ,� ,� .� � � r c �. � t j d� d� � S )Nc �" � t j dk S rd rf r r r r+ z+SuiteRequirements.python3.<locals>.<lambda> s � �C�$�t�+� r z Python version 3.xx is required.rk r s r �python3zSuiteRequirements.python3 s � ��!� +� +�-O� � � r c � � | j S r% )�python36r s r �pep520zSuiteRequirements.pep520 s � ��}� r c �. � t j d� d� � S )Nc �" � t j dk S )N)re � rf r r r r+ z,SuiteRequirements.python36.<locals>.<lambda> � � �C�$�v�-� r z*Python version 3.6 or greater is required.rk r s r rn zSuiteRequirements.python36 � � ��!� -� -� 8� � � r c �. � t j d� d� � S )Nc �" � t j dk S )N)re � rf r r r r+ z,SuiteRequirements.python37.<locals>.<lambda> rs r z*Python version 3.7 or greater is required.rk r s r �python37zSuiteRequirements.python37 rt r c �. � t j d� d� � S )Nc � � t j S r% )r �cpythonr r r r+ z+SuiteRequirements.cpython.<locals>.<lambda># s � �D�L� r zcPython interpreter neededr, r s r r{ zSuiteRequirements.cpython s � ��!� � �">� � � r c �@ �� ddl m� t j �fd�d� � S )Nr ��picklec �T �� t j r � j dk pt j dk S )N�cPickle)re r )r �pypyr rg rh r} s �r r+ z5SuiteRequirements.non_broken_pickle.<locals>.<lambda>+ s- �� �� �M� -���9�,�*�� �6�)� r z.Needs cPickle+cPython or newer Python 3 pickle)�sqlalchemy.utilr~ r r- )r r~ s @r �non_broken_picklez#SuiteRequirements.non_broken_pickle& sC �� �*�*�*�*�*�*��!� *� *� *� *� =� � � r c � � | j S )z�target platform must remove all cycles unconditionally when gc.collect() is called, as well as clean out unreferenced subclasses. )r{ r s r �predictable_gcz SuiteRequirements.predictable_gc1 s � � �|�r c �. � t j d� d� � S )z�Test should be skipped if coverage is enabled. This is to block tests that exercise libraries that seem to be sensitive to coverage, such as PostgreSQL notice logging. c � � | j j S r% )rS r` ri s r r+ z/SuiteRequirements.no_coverage.<locals>.<lambda>B s � �6�>�6� r z(Issues observed when coverage is enabledrk r s r � no_coveragez SuiteRequirements.no_coverage9 s" � � �!� 6� 6� 6� � � r c � � dS �NFr r s r �_has_mysql_on_windowsz'SuiteRequirements._has_mysql_on_windowsF � � ��ur c � � dS r� r r s r � _has_mysql_fully_case_sensitivez1SuiteRequirements._has_mysql_fully_case_sensitiveI r� r c �2 � � t j � fd�� � S )Nc �. �� � � � � S r% )� _has_sqliter s �r r+ z*SuiteRequirements.sqlite.<locals>.<lambda>N s �� �d�.>�.>�.@�.@�*@� r rk r s `r �sqlitezSuiteRequirements.sqliteL s �� ��!�"@�"@�"@�"@�A�A�Ar c �4 � � t j � fd�d� � S )Nc �. �� � � � � S r% )�_has_cextensionsr s �r r+ z/SuiteRequirements.cextensions.<locals>.<lambda>S s �� ��-�-�/�/�/� r zC extensions not installedrk r s `r � cextensionsz SuiteRequirements.cextensionsP s' �� ��!� /� /� /� /�1M� � � r c �L � ddl m} |d� � dS # t $ r Y dS w xY w)Nr )� create_enginez sqlite://TF)� sqlalchemyr� � ImportError)r r� s r r� z SuiteRequirements._has_sqliteV sP � �,�,�,�,�,�,� � �M�+� &� &� &��4��� � � ��5�5� ���s � � #�#c �: � ddl m}m} dS # t $ r Y dS w xY w)Nr )� cresultproxy� cprocessorsTF)r� r� r� r� )r r� r� s r r� z"SuiteRequirements._has_cextensions_ sF � � � <� <� <� <� <� <� <� <��4��� � � ��5�5� ���s � � �c �( � t j � � S )zSupports computed columnsr r s r �computed_columnsz"SuiteRequirements.computed_columnsg rQ r c �( � t j � � S )z/Supports computed columns with `persisted=True`r r s r �computed_columns_storedz)SuiteRequirements.computed_columns_storedl rQ r c �( � t j � � S )z0Supports computed columns with `persisted=False`r r s r �computed_columns_virtualz*SuiteRequirements.computed_columns_virtualq rQ r c �( � t j � � S )zSIf the default persistence is virtual or stored when `persisted` is omittedr r s r �"computed_columns_default_persistedz4SuiteRequirements.computed_columns_default_persistedv r# r c �( � t j � � S )zTIf persistence information is returned by the reflection of computed columnsr r s r �"computed_columns_reflect_persistedz4SuiteRequirements.computed_columns_reflect_persisted| r# r c �. � t j d� d� � S )a Supports some form of "x IS [NOT] DISTINCT FROM y" construct. Different dialects will implement their own flavour, e.g., sqlite will emit "x IS NOT y" instead of "x IS DISTINCT FROM y". .. seealso:: :meth:`.ColumnOperators.is_distinct_from` c �& � | j j j S r% )rf rg �supports_is_distinct_fromri s r r+ z=SuiteRequirements.supports_is_distinct_from.<locals>.<lambda>� s � �v�y� 0� J�J� r z4driver doesn't support an IS DISTINCT FROM constructrk r s r r� z+SuiteRequirements.supports_is_distinct_from� s" � � �!� J� J� B� � � r N)�r r r �propertyr r r r r" r& r. r0 r2 r4 r6 r8 r; r= r@ rC rE rG rI rK rN rP rS rU rW rY r\ r_ ra rc rm rs rw r| r~ r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r r r r r r r r r r r r r r r r r" r$ r' r) r+ r- r/ r1 r3 r5 r7 r9 r; r= r? rA rG rD rJ rL rN rP rU rW r\ ra ri rl ro rn rx r{ r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r r r r r s� � � � � � � �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� �#� #� �X�#� �#� #� �X�#� � � � �X� � �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� � !� !� �X� !� � !� !� �X� !� �#� #� �X�#� �!� !� �X�!� �#� #� �X�#� �#� #� �X�#� �!� !� �X�!� �#� #� �X�#� �#� #� �X�#� �#� #� �X�#� �#� #� �X�#� �#� #� �X�#� �#� #� �X�#� �!� !� �X�!� � !� !� �X� !� � !� !� �X� !� � � � �X� � � � � �X� � � � � �X� � � � � �X� � �!� !� �X�!� � � � �X� � �#� #� �X�#� � � � �X� � �!� !� �X�!� � � � �X� � � � � �X� � �!� !� �X�!� � #� #� �X� #� �#� #� �X�#� �#� #� �X�#� �#� #� �X�#� �#� #� �X�#� � #� #� �X� #� �#� #� �X�#� � � � �X� � � � � �X� � � � � �X� � � � � �X� � �@� @� �X�@� �#� #� �X�#� �!� !� �X�!� �#� #� �X�#� �� � �X�� �� � �X�� � � � �X� � �!� !� �X�!� �!� !� �X�!� �#� #� �X�#� �#� #� �X�#� �!� !� �X�!� �#� #� �X�#� �!� !� �X�!� �#� #� �X�#� �!� !� �X�!� �!� !� �X�!� �#� #� �X�#� �!� !� �X�!� �#� #� �X�#� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� �#� #� �X�#� �!� !� �X�!� �#� #� �X�#� �!� !� �X�!� �!� !� �X�!� �#� #� �X�#� �#� #� �X�#� �!� !� �X�!� �!� !� �X�!� �#� #� �X�#� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� � !� !� �X� !� �#� #� �X�#� �#� #� �X�#� � � �4 �#� #� �X�#� � � � �X� � �!� !� �X�!� �!� !� �X�!� �#� #� �X�#� �#� #� �X�#� �#� #� �X�#� �!� !� �X�!�( �!� !� �X�!� �!� !� �X�!� �#� #� �X�#� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� �#� #� �X�#� �#� #� �X�#� �#� #� �X�#� �#� #� �X�#� � !� !� �X� !� �#� #� �X�#� � #� #� �X� #� �!� !� �X�!� � #� #� �X� #� �)� )� �X�)�$� $� $� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� �!� !� �X�!� � � � �X� � �;� ;� �X�;� �;� ;� �X�;� � � � �X� � � � � �X� � � � � �X� � � � � �X� � � � � �X� � � � � �X� � � � � �X� � � � � �X� � � � � �X� � � � � �X� �� � �� � � �B� B� �X�B� � � � �X� � � � �� � � �#� #� �X�#� �#� #� �X�#� �#� #� �X�#� �#� #� �X�#� �#� #� �X�#� � � � �X� � � r r )�__doc__rg � r r �objectr r r r r �<module>r� s� ��� � � � � � � � � � � � � � � � � � � � � � �6� � � �t � t � t � t � t � � t � t � t � t � t r