/
opt
/
alt
/
python27
/
lib64
/
python2.7
/
site-packages
/
sqlalchemy
/
testing
/
up file
home
� 1��fc @ s� d Z d d l Z d d l Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d e f d � � YZ d e f d � � YZ d S( s� 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. i����Ni ( t asyncio( t exclusions( t only_oni ( t util( t QueuePoolt Requirementsc B s e Z RS( ( t __name__t __module__( ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR s t SuiteRequirementsc B s� e Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z! e d � � Z" e d � � Z# e d! � � Z$ e d" � � Z% e d# � � Z& e d$ � � Z' e d% � � Z( e d& � � Z) e d' � � Z* e d( � � Z+ e d) � � Z, e d* � � Z- e d+ � � Z. e d, � � Z/ e d- � � Z0 e d. � � Z1 e d/ � � Z2 e d0 � � Z3 e d1 � � Z4 e d2 � � Z5 e d3 � � Z6 e d4 � � Z7 e d5 � � Z8 e d6 � � Z9 e d7 � � Z: e d8 � � Z; e d9 � � Z< e d: � � Z= e d; � � Z> e d< � � Z? e d= � � Z@ e d> � � ZA e d? � � ZB e d@ � � ZC e dA � � ZD e dB � � ZE e dC � � ZF e dD � � ZG e dE � � ZH e dF � � ZI e dG � � ZJ e dH � � ZK e dI � � ZL e dJ � � ZM e dK � � ZN e dL � � ZO e dM � � ZP e dN � � ZQ e dO � � ZR e dP � � ZS e dQ � � ZT e dR � � ZU e dS � � ZV e dT � � ZW e dU � � ZX e dV � � ZY e dW � � ZZ e dX � � Z[ e dY � � Z\ e dZ � � Z] e d[ � � Z^ e d\ � � Z_ e d] � � Z` e d^ � � Za e d_ � � Zb e d` � � Zc e da � � Zd e db � � Ze e dc � � Zf e dd � � Zg e de � � Zh e df � � Zi e dg � � Zj e dh � � Zk e di � � Zl e dj � � Zm e dk � � Zn e dl � � Zo e dm � � Zp e dn � � Zq e do � � Zr e dp � � Zs e dq � � Zt e dr � � Zu e ds � � Zv dt � Zw e du � � Zx e dv � � Zy e dw � � Zz e dx � � Z{ e dy � � Z| e dz � � Z} e d{ � � Z~ e d| � � Z e d} � � Z� e d~ � � Z� e d � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e 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 d� � � Z� d� � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e 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 d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� e d� � � Z� RS(� c C s t j � S( s/ target platform can emit basic CreateTable DDL.( R t open( t self( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt create_table! s c C s t j � S( s- target platform can emit basic DropTable DDL.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt drop_table' s c C s t j � S( s> target platform supports IF NOT EXISTS / IF EXISTS for tables.( R t closed( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt table_ddl_if_exists- s c C s t j � S( s? target platform supports IF NOT EXISTS / IF EXISTS for indexes.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt index_ddl_if_exists3 s c C s t j � S( s* Target database must support foreign keys.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt foreign_keys9 s c C s t j � S( s� Database / dialect supports a query like:: SELECT * FROM VALUES ( (c1, c2), (c1, c2), ...) AS some_table(col1, col2) SQLAlchemy generates this with the :func:`_sql.values` function. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt table_value_constructor? s c C s t j � S( s� Target database passes SQL-92 style statements to cursor.execute() when a statement like select() or insert() is run. A very small portion of dialect-level tests will ensure that certain conditions are present in SQL strings, and these tests use very basic SQL that will work on any SQL-like platform in order to assert results. It's normally a given for any pep-249 DBAPI that a statement like "SELECT id, name FROM table WHERE some_table.id=5" will work. However, there are dialects that don't actually produce SQL Strings and instead may work with symbolic objects instead, or dialects that aren't working with SQL, so for those this requirement can be marked as excluded. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt standard_cursor_sqlK s c C s t j � S( sQ target database must support ON UPDATE..CASCADE behavior in foreign keys.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt on_update_cascade_ s c C s t j � S( sW target database must *not* support ON UPDATE..CASCADE behavior in foreign keys.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt non_updating_cascadef s c C s t j � S( N( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt deferrable_fksl s c s t j � f d � � S( Nc s � j j p � j j S( N( R t enabledR ( ( R ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt <lambda>v s ( R t only_if( R ( ( R sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt on_update_or_deferrable_fksp s c C s d � } t j | � S( s" target database is using QueuePoolc S s t | j j t � S( N( t isinstancet dbt poolR ( t config( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt go~ s ( R R ( R R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt queue_poolz s c C s t j � S( s; Target database must support self-referential foreign keys.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt self_referential_foreign_keys� s c C s t j � S( s= Target database must support the DDL phrases for FOREIGN KEY.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt foreign_key_ddl� s c C s t j � S( s3 target database must support names for constraints.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt named_constraints� s c C s t j � S( s8 target database must apply names to unnamed constraints.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt implicitly_named_constraints� s c C s t j � S( s target database allows column names that have unusual characters in them, such as dots, spaces, slashes, or percent signs. The column names are as always in such a case quoted, however the DB still needs to support those characters in the name somehow. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt unusual_column_name_characters� s c C s t j � S( s( Target database must support subqueries.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt subqueries� s c C s t j � S( sR target database can render OFFSET, or an equivalent, in a SELECT. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt offset� s c C s t j � S( sW target database can render LIMIT and/or OFFSET using a bound parameter ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt bound_limit_offset� s c C s t j � S( s� target database can render LIMIT and/or OFFSET with a complete SQL expression, such as one that uses the addition operator. parameter ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt sql_expression_limit_offset� s c C s t j � S( s� 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt/ parens_in_union_contained_select_w_limit_offset� s c C s t j � S( sl 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt0 parens_in_union_contained_select_wo_limit_offset� s c C s t j � S( s; Target database must support boolean expressions as columns( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt boolean_col_expressions� s c C s t j � S( s5 Target database allows boolean columns to store NULL.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt nullable_booleans� s c C s t j � S( s, Target backends that support nulls ordering.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt nullsordering� s c C s t j � S( s� target database/driver supports bound parameters as column expressions without being in the context of a typed column. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt standalone_binds� s c C s t j � S( s� target database/driver supports bound parameters with NULL in the WHERE clause, in situations where it has to be typed. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt! standalone_null_binds_whereclause� s c C s t j � S( s5 Target database must support INTERSECT or equivalent.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt intersect s c C s t j � S( s? Target database must support EXCEPT or equivalent (i.e. MINUS).( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt except_ s c C s t j � S( s. Target database must support window functions.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt window_functions s c C s t j � S( s Target database supports CTEs( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt ctes s c C s t j � S( s� 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt ctes_with_update_delete s c C s t j � S( s} target database supports CTES which consist of INSERT, UPDATE or DELETE *within* the CTE, e.g. WITH x AS (UPDATE....)( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt ctes_on_dml s c C s t j � S( s~ target platform generates new surrogate integer primary key values when insert() is executed, excluding the pk column.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt autoincrement_insert% s c C s t j � S( s# 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt fetch_rows_post_commit, s c C s t j � S( s� target platform supports SQL expressions in GROUP BY e.g. SELECT x + y AS somelabel FROM table GROUP BY x + y ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt group_by_complex_expression9 s c C s t j d � d � S( Nc S s | j j j S( N( R t dialectt supports_sane_rowcount( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR H t s& driver doesn't support 'sane' rowcount( R t skip_if( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt sane_rowcountE s c C s t j d � d � S( Nc S s | j j j S( N( R R9 t supports_sane_multi_rowcount( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR O R; s; driver %(driver)s %(doesnt_support)s 'sane' multi row count( R t fails_if( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt sane_multi_rowcountL s c C s t j d � d � S( Nc S s | j j j S( N( R R9 t supports_sane_rowcount_returning( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR V s s; driver doesn't support 'sane' rowcount when returning is on( R R? ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt sane_rowcount_w_returningS s c C s t j d � d � S( sa target platform supports INSERT with no values, i.e. INSERT DEFAULT VALUES or equivalent.c S s+ | j j j p* | j j j p* | j j j S( N( R R9 t supports_empty_insertt supports_default_valuest supports_default_metavalue( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR b s s empty inserts not supported( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt empty_inserts\ s c C s | j S( sv target platform supports INSERT with no values, i.e. INSERT DEFAULT VALUES or equivalent, within executemany()( RF ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt empty_inserts_executemanyh s c C s t j � S( s. target platform supports INSERT from a SELECT.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt insert_from_selecto s c C s t j d � d � S( sb target platform supports RETURNING completely, including multiple rows returned. c S s | j j j S( N( R R9 t full_returning( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR } R; s: %(database)s %(does_support)s 'RETURNING of multiple rows'( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyRI u s c C s t j d � d � S( s� target platform supports RETURNING when INSERT is used with executemany(), e.g. multiple parameter sets, indicating as many rows come back as do parameter sets were passed. c S s | j j j S( N( R R9 t insert_executemany_returning( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR � R; sR %(database)s %(does_support)s 'RETURNING of multiple rows with INSERT executemany'( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyRJ � s c C s t j d � d � S( s� target platform supports RETURNING for at least one row. .. seealso:: :attr:`.Requirements.full_returning` c S s | j j j S( N( R R9 t implicit_returning( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR � R; s9 %(database)s %(does_support)s 'RETURNING of a single row'( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt returning� s c C s t j � S( sZ Target platform supports the syntax "(x, y) IN ((x1, y1), (x2, y2), ...)" ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt tuple_in� s c C s | j S( s% Target platform tuple IN w/ empty set( RM ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt tuple_in_w_empty� s c C s t j � S( sw target platform supports a SELECT statement that has the same name repeated more than once in the columns list.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt% duplicate_names_in_cursor_description� s c C s t j d � d � S( s[ Target database must have 'denormalized', i.e. UPPERCASE as case insensitive names.c S s | j j j S( N( R R9 t requires_name_normalize( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR � R; s, Backend does not require denormalized names.( R R< ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt denormalized_names� s c C s t j d � d � S( sT target database must support multiple VALUES clauses in an INSERT statement.c S s | j j j S( N( R R9 t supports_multivalues_insert( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR � R; s* Backend does not support multirow inserts.( R R< ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt multivalues_inserts� s c C s t j � S( sv target dialect implements the executioncontext.get_lastrowid() method without reliance on RETURNING. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt implements_get_lastrowid� s c C s t j � S( s< 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt emulated_lastrowid� s c C s t j � S( s� target dialect retrieves cursor.lastrowid or an equivalent after an insert() construct executes, even if the table has a Sequence on it. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt& emulated_lastrowid_even_with_sequences� s c C s t j � S( s] target platform includes a 'lastrowid' accessor on the DBAPI cursor object. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt dbapi_lastrowid� s c C s t j � S( s# Target database must support VIEWs.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt views� s c C s t d � � S( sX Target database must support external schemas, and have one named 'test_schema'.c S s | j j j S( N( R R9 t supports_schemas( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR � R; ( R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt schemas� s c C s t j � S( sJ target system must support reflection of inter-schema foreign keys( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt cross_schema_fk_reflection� s c C s t j � S( s Target supports refleciton of FOREIGN KEY constraints and will return the name of the constraint that was used in the "CONSTRAINT <name> FOREIGN KEY" DDL. MySQL prior to version 8 and MariaDB prior to version 10.5 don't support this. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt& foreign_key_constraint_name_reflection� s c C s t j � S( s� target system has a strong concept of 'default' schema that can be referred to implicitly. basically, PostgreSQL. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt implicit_default_schema s c C s t j � S( s` target dialect implements provisioning module including set_default_schema_on_connection( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt default_schema_name_switch s c C s t j d � g d � S( s0 Target dialect must support server side cursors.c S s | j j j S( N( R R9 t supports_server_side_cursors( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR R; s no server side cursors support( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt server_side_cursors s c C s t j d � g d � S( s' Target database must support SEQUENCEs.c S s | j j j S( N( R R9 t supports_sequences( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR ) R; s no sequence support( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt sequences$ s c C s t j | j � S( sJ the opposite of "sequences", DB does not support sequences at all.( R t NotPredicateRb ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt no_sequences- s c C s t j d � g d � S( sg Target database supports sequences, but also optionally as a means of generating new PK values.c S s | j j j o | j j j S( N( R R9 Ra t sequences_optional( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR ; s s. no sequence support, or sequences not optional( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyRe 4 s c C s t j d � g � S( s 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 S s | j j j S( N( R R9 t postfetch_lastrowid( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR K R; ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt supports_lastrowidA s c C s t j d � g � S( s" the opposite of supports_lastrowidc S s | j j j S( N( R R9 Rf ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR R R; ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt no_lastrowid_supportN s c C s t j � S( N( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt reflects_pk_namesU s c C s t j � S( s8 target database has general support for table reflection( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt table_reflectionY s c C s t j � S( s� target database supports creation and reflection of tables with no columns, or at least tables that seem to have no columns.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt reflect_tables_no_columns^ s c C s t j � S( N( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt comment_reflectione s c C s | j S( s� 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. ( RX ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt view_column_reflectioni s c C s | j S( sS target database must support inspection of the full CREATE VIEW definition.( RX ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt view_reflections s c C s | j S( N( RZ ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt schema_reflectiony s c C s t j � S( N( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt! primary_key_constraint_reflection} s c C s t j � S( N( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt! foreign_key_constraint_reflection� s c C s t j � S( N( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt1 foreign_key_constraint_option_reflection_ondelete� s c C s t j � S( N( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt1 fk_constraint_option_reflection_ondelete_restrict� s c C s t j � S( N( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt1 fk_constraint_option_reflection_ondelete_noaction� s c C s t j � S( N( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt1 foreign_key_constraint_option_reflection_onupdate� s c C s t j � S( N( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt1 fk_constraint_option_reflection_onupdate_restrict� s c C s t j � S( N( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt temp_table_reflection� s c C s | j S( N( Rw ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt temp_table_reflect_indexes� s c C s t j � S( s8 target dialect supports listing of temporary table names( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt temp_table_names� s c C s t j � S( s9 target dialect supports checking a single temp table name( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt has_temp_table� s c C s t j � S( s) target database supports temporary tables( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt temporary_tables� s c C s t j � S( s( target database supports temporary views( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt temporary_views� s c C s t j � S( N( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt index_reflection� s c C s t j � S( N( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt index_reflects_included_columns� s c C s t j � S( s? target database supports CREATE INDEX with per-column ASC/DESC.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt indexes_with_ascdesc� s c C s t j � S( s> target database supports CREATE INDEX against SQL expressions.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt indexes_with_expressions� s c C s t j � S( s8 target dialect supports reflection of unique constraints( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt unique_constraint_reflection� s c C s t j � S( s7 target dialect supports reflection of check constraints( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt check_constraint_reflection� s c C s t j � S( s� target dialect raises IntegrityError when reporting an INSERT with a primary key violation. (hint: it should) ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt$ duplicate_key_raises_integrity_error� s c C s t j � S( s3 Target database must support VARCHAR with no length( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt unbounded_varchar� s c C s t j � S( s� 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt unicode_data� s c C s t j � S( sR Target driver must support some degree of non-ascii symbol names. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt unicode_ddl� s c C s t j � S( s? Target driver can create tables with a name like 'some " table'( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt symbol_names_w_double_quote� s c C s t j � S( s� target dialect supports rendering of a date, time, or datetime as a literal string, e.g. via the TypeEngine.literal_processor() method. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt datetime_literals� s c C s t j � S( sU target dialect supports representation of Python datetime.datetime() objects.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt datetime� s c C s t j � S( sv target dialect supports representation of Python datetime.datetime() with tzinfo with DateTime(timezone=True).( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt datetime_timezone s c C s t j � S( sn target dialect supports representation of Python datetime.time() with tzinfo with Time(timezone=True).( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt time_timezone s c C s t j � S( s� target dialect when given a datetime object will bind it such that the database server knows the object is a datetime, and not a plain string. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt datetime_implicit_bound s c C s t j � S( sf target dialect supports representation of Python datetime.datetime() with microsecond objects.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt datetime_microseconds s c C s t j � S( s� target dialect supports representation of Python datetime.datetime() with microsecond objects but only if TIMESTAMP is used.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt timestamp_microseconds" s c C s | j S( s target dialect when given a datetime object which also includes a microseconds portion when using the TIMESTAMP data type will bind it such that the database server knows the object is a datetime with microseconds, and not a plain string. ( R� ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt% timestamp_microseconds_implicit_bound) s c C s t j � S( su target dialect supports representation of Python datetime.datetime() objects with historic (pre 1970) values.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt datetime_historic3 s c C s t j � S( sQ target dialect supports representation of Python datetime.date() objects.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt date: s c C s t j � S( sP target dialect accepts a datetime object as the target of a date column.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt date_coerces_from_datetimeA s c C s t j � S( su target dialect supports representation of Python datetime.datetime() objects with historic (pre 1970) values.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt date_historicH s c C s t j � S( sQ target dialect supports representation of Python datetime.time() objects.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt timeO s c C s t j � S( sb target dialect supports representation of Python datetime.time() with microsecond objects.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt time_microsecondsV s c C s t j � S( st target database/driver can allow BLOB/BINARY fields to be compared against a bound parameter value. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt binary_comparisons] s c C s t j � S( s! 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt binary_literalse s c C s t j � S( s: target dialect supports 'AUTOCOMMIT' as an isolation_level( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt autocommitu s c C s t j � S( s� 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt isolation_levelz s c C s d S( s� 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_COMMITTED", "supported": [ "SERIALIZABLE", "READ UNCOMMITTED", "READ COMMITTED", "REPEATABLE READ", "AUTOCOMMIT" ] } N( ( R R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt get_isolation_levels� R; c C s t j � S( s. target platform implements a native JSON type.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt json_type� s c C s | j S( sN target platform supports numeric array indexes within a JSON structure( R� ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt json_array_indexes� s c C s t j � S( N( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt( json_index_supplementary_unicode_element� s c C s t j � S( s� Backend has a JSON_EXTRACT or similar function that returns a valid JSON string in all cases. Used to test a legacy feature and is not needed. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt! legacy_unconditional_json_extract� s c C s t j � S( sR target backend has general support for moderately high-precision numerics.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt precision_numerics_general� s c C s t j � S( sb target backend supports Decimal() objects using E notation to represent very small values.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt" precision_numerics_enotation_small� s c C s t j � S( sb target backend supports Decimal() objects using E notation to represent very large values.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt" precision_numerics_enotation_large� s c C s t j � S( s� target backend supports values with many digits on both sides, such as 319438950232418390.273596, 87673.594069654243 ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt* precision_numerics_many_significant_digits� s c C s | j S( s} same as precision_numerics_many_significant_digits but within the context of a CAST statement (hello MySQL) ( R� ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt/ cast_precision_numerics_many_significant_digits� s c C s t j � S( s+ 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt implicit_decimal_binds� s c C s t j � S( sh target database can select an aggregate from a subquery that's also using an aggregate ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt nested_aggregates� s c C s t j � S( sb target database must support ON DELETE CASCADE on a self-referential foreign key ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt recursive_fk_cascade� s c C s t j � S( s� 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt- precision_numerics_retains_significant_digits s c C s t j � S( s@ The Float type can persist and load float('inf'), float('-inf').( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt infinity_floats s c C s t j � S( s� target backend will return native floating point numbers with at least seven decimal places when using the generic Float type. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt precision_generic_float_type s c C s t j � S( s� target backend will return the exact float value 15.7563 with only four significant digits from this statement: SELECT :param where :param is the Python float 15.7563 i.e. it does not return 15.75629997253418 ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt literal_float_coercion s c C s t j � S( s� 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt floats_to_four_decimals$ s c C s t j � S( s� 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt fetch_null_from_numeric- s c C s t j � S( sU Target database must support an unbounded Text() " "type such as TEXT or CLOB( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt text_type7 s c C s t j � S( sT target database can persist/return an empty string with a varchar. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt empty_strings_varchar> s c C s t j � S( sR target database can persist/return an empty string with an unbounded text.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt empty_strings_textF s c C s t j � S( sU target database supports use of an unbounded textual field in a WHERE clause.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt" expressions_against_unbounded_textM s c C s t j � S( s; target driver must support the literal statement 'select 1'( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt selectoneT s c C s t j � S( s( Target database must support savepoints.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt savepointsY s c C s t j � S( s4 Target database must support two-phase transactions.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt two_phase_transactions_ s c C s t j � S( s' Target must support UPDATE..FROM syntax( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt update_frome s c C s t j � S( s= Target must support DELETE FROM..FROM or DELETE..USING syntax( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt delete_fromj s c C s t j � S( s� 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt update_where_target_in_subqueryo s c C s t j � S( sO target database must use a plain percent '%' as the 'modulus' operator.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt mod_operator_as_percent_sign s c C s t j � S( s 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt percent_schema_names� s c C s t j � S( s� 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt order_by_col_from_union� s c C s t j � S( s 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt order_by_label_with_expression� s c s � f d � } t j | � S( Nc s. y � j | � t SWn t k r) t SXd S( N( t get_order_by_collationt Falset NotImplementedErrort True( R ( R ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt check� s ( R R< ( R R� ( ( R sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt order_by_collation� s c C s t � � d S( N( R� ( R R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR� � s c C s t j � S( sU Target driver must support non-ASCII characters being passed at all. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt unicode_connections� s c C s t j � S( s� 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 ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt graceful_disconnects� s c C s t j � S( sU Target must support simultaneous, independent database connections. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt independent_connections� s c C s t j � S( s9 Catchall for a large variety of MySQL on Windows failures( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt skip_mysql_on_windows� s c C s t j d � � S( s 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 S s | j j S( N( t optionst low_connections( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR � R; ( R R< ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt ad_hoc_engines� s c C s t j | j � � S( N( R R< t _running_on_windows( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt no_windows� s c C s t j d � d d �S( Nc S s t j � d k S( Nt Windows( t platformt system( ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR � R; t descriptions running on Windows( R t LambdaPredicate( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR� � s c C s t j d � S( Nt timing_intensive( R t requires_tag( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR� � s c C s t j d � S( Nt memory_intensive( R R� ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR� � s c C s t j d � d � S( s� Mark tests that use threading and mock at the same time - stability issues have been observed with coverage + python 3.3 c S s t j o | j j S( N( R t py3kR� t has_coverage( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR � R; s% Stability issues with coverage + py3k( R R< ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt threading_with_mock� s c C s d � } t j | � S( Nc S s+ y t d � Wn t k r" t SXt Sd S( Ns sqlalchemy-stubs.ext.mypy( t __import__t ImportErrorR� R� ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR� � s ( R R ( R R� ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt sqlalchemy2_stubs� s c C s t j d � d � S( Nc S s t j d k S( Ni ( i ( t syst version_info( ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR R; s Python version 2.xx is required.( R R< ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt python2 s c C s t j d � d � S( Nc S s t j d k S( Ni ( i ( R� R� ( ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR R; s Python version 3.xx is required.( R R< ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt python3 s c C s | j S( N( t python36( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt pep520 s c C s | j S( N( t python37( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt insert_order_dicts s c C s t j d � d � S( Nc S s t j d k S( Ni i ( i i ( R� R� ( ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR ! R; s* Python version 3.6 or greater is required.( R R< ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR� s c C s t j d � d � S( Nc S s t j d k S( Ni i ( i i ( R� R� ( ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR ( R; s* Python version 3.7 or greater is required.( R R< ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR� % s c C s | j S( N( R� ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt dataclasses, s c C s t j d � d � S( Nc S s t j S( N( R t py38( ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR 3 R; s Python 3.8 or above required( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt python380 s c C s t j d � d � S( Nc S s t j S( N( R t cpython( ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR 9 R; s cPython interpreter needed( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR� 6 s c C s t j d � d � S( Nc S s t j S( N( R t is64bit( ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR > R; s 64bit required( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR� < s c C s d � } t j | d � S( Nc S s+ y t d � Wn t k r" t SXt Sd S( Nt patch( R� R� R� R� ( ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt check_libB s s patch library needed( R R ( R R� ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt patch_library@ s c s) d d l m � t j � f d � d � S( Ni����( t picklec s% t j r � j d k p$ t j d k S( Nt cPicklei i ( i i ( R R� R R� R� ( ( R� ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR Q s s. Needs cPickle+cPython or newer Python 3 pickle( t sqlalchemy.utilR� R R ( R ( ( R� sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt non_broken_pickleL s c C s | j S( s� target platform must remove all cycles unconditionally when gc.collect() is called, as well as clean out unreferenced subclasses. ( R� ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt predictable_gcW s c C s t j d � d � S( s� 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 S s | j j S( N( R� R� ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR h R; s( Issues observed when coverage is enabled( R R< ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt no_coverage_ s c C s t S( N( R� ( R R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt _has_mysql_on_windowsl s c C s t S( N( R� ( R R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt _has_mysql_fully_case_sensitiveo s c s t j � f d � � S( Nc s � j � S( N( t _has_sqlite( ( R ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR t R; ( R R< ( R ( ( R sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt sqliter s c C s t j d � d � S( Nc S s t j � S( N( R t has_compiled_ext( ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR y R; s C extensions not installed( R R< ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt cextensionsv s c C s; d d l m } y | d � t SWn t k r6 t SXd S( Ni����( t create_engines sqlite://( t sqlalchemyR� R� R� R� ( R R� ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR� | s c C s t j � S( s@ dialect makes use of await_() to invoke operations on the DBAPI.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt async_dialect� s c C s | j S( N( t greenlet( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR � s c C s d � } t j | � S( Nc S s: t j s t Sy d d l } Wn t k r1 t SXt Sd S( Ni����( t _test_asynciot ENABLE_ASYNCIOR� R� R� R� ( R R� ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR � s ( R R ( R R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR� � s c C s t j � S( s Supports computed columns( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt computed_columns� s c C s t j � S( s/ Supports computed columns with `persisted=True`( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt computed_columns_stored� s c C s t j � S( s0 Supports computed columns with `persisted=False`( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt computed_columns_virtual� s c C s t j � S( sS If the default persistence is virtual or stored when `persisted` is omitted( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt" computed_columns_default_persisted� s c C s t j � S( sT If persistence information is returned by the reflection of computed columns( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt" computed_columns_reflect_persisted� s c C s t j � S( s1 If a backend supports the DISTINCT ON in a select( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt supports_distinct_on� s c C s t j d � d � S( s 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 S s | j j j S( N( R R9 t supports_is_distinct_from( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR � R; s4 driver doesn't support an IS DISTINCT FROM construct( R R< ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR � s c C s t j � S( sK If a backend supports GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt identity_columns� s c C s t j � S( s� If a backend supports GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY with a standard syntax. This is mainly to exclude MSSql. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt identity_columns_standard� s c C s t j � S( s+ backend supports the regexp_match operator.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt regexp_match� s c C s t j � S( s- backend supports the regexp_replace operator.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt regexp_replace� s c C s t j � S( s( backend supports the fetch first clause.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt fetch_first� s c C s t j � S( s5 backend supports the fetch first clause with percent.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt fetch_percent� s c C s t j � S( s2 backend supports the fetch first clause with ties.( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt fetch_ties� s c C s t j � S( s1 backend supports the fetch first without order by( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt fetch_no_order_by� s c C s t j � S( sw backend supports the offset when using fetch first with percent or ties. basically this is "not mssql" ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt fetch_offset_with_options� s c C s t j � S( s� backend supports fetch / offset with expression in them, like SELECT * FROM some_table OFFSET 1 + 1 ROWS FETCH FIRST 1 + 1 ROWS ONLY ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt fetch_expression s c C s t j � S( s If autoincrement=True on a column does not require an explicit sequence. This should be false only for oracle. ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt autoincrement_without_sequence s c C s t j d � � S( s= If X[Y] can be implemented with ``__class_getitem__``. py3.7+c S s t j S( N( R t py37( ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR R; ( R R ( R ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt generic_classes s (� R R t propertyR 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/ R0 R1 R2 R3 R4 R5 R6 R7 R8 R= R@ RB RF RG RH RI RJ RL RM RN RO RQ RS RT RU RV RW RX RZ R[ R\ R] R^ R` Rb Rd Re Rg Rh Ri Rj Rk Rl Rm Rn Ro Rp Rq Rr Rs Rt Ru Rv Rw Rx Ry Rz 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� 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 ( ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyR s� ( t __doc__R� R� R; R R� R R R R R t objectR R ( ( ( sR /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/testing/requirements.pyt <module> s