�
���ec@s�dZd
dl
Z
d
dlZddlmZ
ddlmZ
ddlmZ
ddlmZ
dd	l	m
Z

d
ef
d��YZdef
d
��YZ
dS(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
(
tasyncio(
t
exclusions(
tonly_oni(
tutil(
t	QueuePooltRequirementsc
BseZ
RS((t__name__t
__module__(((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRs
tSuiteRequirementscBs�eZ
ed��
Zed
��
Zed��
Zed��
Zed��
Zed��
Zed��
Z	ed��
Z
ed��
Zed	��
Zed
��
Z
ed��
Zed��
Zed
��
Zed��
Zed��
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-��
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_ed]��
Z`ed^��
Zaed_��
Zbed`��
Zceda��
Zdedb��
Zeedc��
Zfedd��
Zgede��
Zhedf��
Ziedg��
Zjedh��
Zkedi��
Zledj��
Zmedk��
Znedl��
Zoedm��
Zpedn��
Zqedo��
Zredp��
Zsedq��
Ztedr��
Zueds��
Zvdt�Zwedu��
Zxedv��
Zyedw��
Zzedx��
Z{edy��
Z|edz��
Z}ed{��
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�ed���
Z�ed���
Z�ed���
Z�ed���
Z�ed���
Z�ed���
Z�ed���
Z�ed���
Z�ed���
Z�d��Z�ed���
Z�ed���
Z�ed���
Z�ed���
Z�ed���
Z�ed���
Z�d��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�d��Z�d��Z�ed���
Z�ed���
Z�d��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���
Z�ed���
Z�ed���
Z�RS(�c


Cs
tj
�S(
s/target platform can emit basic CreateTable DDL.(R
topen(
tself((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytcreate_table!sc


Cs
tj
�S(
s-target platform can emit basic DropTable DDL.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
drop_table'sc


Cs
tj
�S(
s>target platform supports IF NOT EXISTS / IF EXISTS for tables.(R
tclosed(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttable_ddl_if_exists-sc


Cs
tj
�S(
s?target platform supports IF NOT EXISTS / IF EXISTS for indexes.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytindex_ddl_if_exists3sc


Cs
tj
�S(
s*Target database must support foreign keys.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytforeign_keys9sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttable_value_constructor?s
c


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytstandard_cursor_sqlKsc


Cs
tj
�S(
sQtarget database must support ON UPDATE..CASCADE behavior in
        foreign keys.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyton_update_cascade_sc


Cs
tj
�S(
sWtarget database must *not* support ON UPDATE..CASCADE behavior in
        foreign keys.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytnon_updating_cascadefsc


Cs
tj
�S(
N(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdeferrable_fkslsc

stj
�f
d
��
S(Nc
s�jj
p�jj
S(
N(RtenabledR((
R
(sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt<lambda>vs
(R
tonly_if(
R
((
R
sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyton_update_or_deferrable_fksps
c
Csd
�}
tj
|
�
S(s"target database is using QueuePoolc

Sst|j
jt�S(
N(t
isinstancetdbtpoolR(
tconfig((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytgo~s
(R
R(R
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
queue_poolzs	c


Cs
tj
�S(
s;Target database must support self-referential foreign keys.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytself_referential_foreign_keys�sc


Cs
tj
�S(
s=Target database must support the DDL phrases for FOREIGN KEY.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytforeign_key_ddl�sc


Cs
tj
�S(
s3target database must support names for constraints.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytnamed_constraints�sc


Cs
tj
�S(
s8target database must apply names to unnamed constraints.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytimplicitly_named_constraints�sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytunusual_column_name_characters�s	c


Cs
tj
�S(
s(Target database must support subqueries.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
subqueries�sc


Cs
tj
�S(
sRtarget database can render OFFSET, or an equivalent, in a
        SELECT.
        (R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytoffset�sc


Cs
tj
�S(
sWtarget database can render LIMIT and/or OFFSET using a bound
        parameter
        (R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytbound_limit_offset�sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytsql_expression_limit_offset�sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt/parens_in_union_contained_select_w_limit_offset�s
c


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt0parens_in_union_contained_select_wo_limit_offset�sc


Cs
tj
�S(
s;Target database must support boolean expressions as columns(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytboolean_col_expressions�sc


Cs
tj
�S(
s5Target database allows boolean columns to store NULL.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytnullable_booleans�sc


Cs
tj
�S(
s,Target backends that support nulls ordering.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
nullsordering�sc


Cs
tj
�S(
s�target database/driver supports bound parameters as column
        expressions without being in the context of a typed column.
        (R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytstandalone_binds�sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt!standalone_null_binds_whereclause�sc


Cs
tj
�S(
s5Target database must support INTERSECT or equivalent.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt	intersect
sc


Cs
tj
�S(
s?Target database must support EXCEPT or equivalent (i.e. MINUS).(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytexcept_
sc


Cs
tj
�S(
s.Target database must support window functions.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytwindow_functions

sc


Cs
tj
�S(
sTarget database supports CTEs(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytctes
sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytctes_with_update_delete
sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytctes_on_dml
sc


Cs
tj
�S(
s~target platform generates new surrogate integer primary key values
        when insert() is executed, excluding the pk column.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytautoincrement_insert%
sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytfetch_rows_post_commit,
sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytgroup_by_complex_expression9
s
c

Cstj
d
�d�S(Nc


Ss|jj
jS(
N(Rtdialecttsupports_sane_rowcount(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRH
ts&driver doesn't support 'sane' rowcount(R
tskip_if(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
sane_rowcountE
s

c

Cstj
d
�d�S(Nc


Ss|jj
jS(
N(RR9tsupports_sane_multi_rowcount(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRO
R;s;driver %(driver)s %(doesnt_support)s 'sane' multi row count(R
tfails_if(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytsane_multi_rowcountL
s

c

Cstj
d
�d�S(Nc


Ss|jj
jS(
N(RR9t supports_sane_rowcount_returning(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRV
s
s;driver doesn't support 'sane' rowcount when returning is on(R
R?(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytsane_rowcount_w_returningS
s
c

Cstj
d
�d�S(satarget platform supports INSERT with no values, i.e.
        INSERT DEFAULT VALUES or equivalent.c


Ss+|jj
jp*|jj
jp*|jj
jS(
N(RR9tsupports_empty_inserttsupports_default_valuestsupports_default_metavalue(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRb
s

sempty inserts not supported(R
R(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
empty_inserts\
s
c


Cs|jS(
svtarget platform supports INSERT with no values, i.e.
        INSERT DEFAULT VALUES or equivalent, within executemany()(
RF(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytempty_inserts_executemanyh
sc


Cs
tj
�S(
s.target platform supports INSERT from a SELECT.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytinsert_from_selecto
sc

Cstj
d
�d�S(sbtarget platform supports RETURNING completely, including
        multiple rows returned.

        c


Ss
|jj
jS(
N(RR9tfull_returning(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR}
R;s:%(database)s %(does_support)s 'RETURNING of multiple rows'(R
R(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRIu
s

c

Cstj
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


Ss
|jj
jS(
N(RR9tinsert_executemany_returning(
R((sP/opt/alt/python27/lib/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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRJ�
s

c

Cstj
d
�d�S(s�target platform supports RETURNING for at least one row.

        .. seealso::

            :attr:`.Requirements.full_returning`

        c


Ss
|jj
jS(
N(RR9timplicit_returning(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�
R;s9%(database)s %(does_support)s 'RETURNING of a single row'(R
R(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt	returning�
s


c


Cs
tj
�S(
sZTarget platform supports the syntax
        "(x, y) IN ((x1, y1), (x2, y2), ...)"
        (R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttuple_in�
sc


Cs|jS(
s%Target platform tuple IN w/ empty set(
RM(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttuple_in_w_empty�
sc


Cs
tj
�S(
swtarget platform supports a SELECT statement that has
        the same name repeated more than once in the columns list.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt%duplicate_names_in_cursor_description�
sc

Cstj
d
�d�S(s[Target database must have 'denormalized', i.e.
        UPPERCASE as case insensitive names.c


Ss|jj
jS(
N(RR9trequires_name_normalize(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�
R;s,Backend does not require denormalized names.(R
R<(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdenormalized_names�
s

c

Cstj
d
�d�S(sTtarget database must support multiple VALUES clauses in an
        INSERT statement.c


Ss|jj
jS(
N(RR9tsupports_multivalues_insert(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�
R;s*Backend does not support multirow inserts.(R
R<(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytmultivalues_inserts�
s

c


Cs
tj
�S(
svtarget dialect implements the executioncontext.get_lastrowid()
        method without reliance on RETURNING.

        (R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytimplements_get_lastrowid�
sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytemulated_lastrowid�
s
c


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt&emulated_lastrowid_even_with_sequences�
sc


Cs
tj
�S(
s]target platform includes a 'lastrowid' accessor on the DBAPI
        cursor object.

        (R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdbapi_lastrowid�
sc


Cs
tj
�S(
s#Target database must support VIEWs.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytviews�
sc

Cs
td
��
S(sXTarget database must support external schemas, and have one
        named 'test_schema'.c


Ss
|jj
jS(
N(RR9tsupports_schemas(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�
R;(
R(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytschemas�
sc


Cs
tj
�S(
sJtarget system must support reflection of inter-schema
        foreign keys(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytcross_schema_fk_reflection�
sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt&foreign_key_constraint_name_reflection�
s
c


Cs
tj
�S(
s�target system has a strong concept of 'default' schema that can
        be referred to implicitly.

        basically, PostgreSQL.

        (R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytimplicit_default_schema
sc


Cs
tj
�S(
s`target dialect implements provisioning module including
        set_default_schema_on_connection(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdefault_schema_name_switchsc

Cstj
d
�g
d�S(s0Target dialect must support server side cursors.c


Ss
|jj
jS(
N(RR9tsupports_server_side_cursors(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR R;sno server side cursors support(R
R(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytserver_side_cursorss
	
c

Cstj
d
�g
d�S(s'Target database must support SEQUENCEs.c


Ss
|jj
jS(
N(RR9tsupports_sequences(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR)R;sno sequence support(R
R(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt	sequences$s
	
c

Cstj
|j�
S(
sJthe opposite of "sequences", DB does not support sequences at
        all.(R
tNotPredicateRb(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytno_sequences-sc

Cstj
d
�g
d�S(sgTarget database supports sequences, but also optionally
        as a means of generating new PK values.c


Ss|jj
jo|jj
jS(
N(RR9Ratsequences_optional(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR;s
s.no sequence support, or sequences not optional(R
R(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRe4s	c

Cstj
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


Ss
|jj
jS(
N(RR9tpostfetch_lastrowid(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRKR;(R
R(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytsupports_lastrowidAs	
c

Cstj
d
�g
�
S(s"the opposite of supports_lastrowidc


Ss|jj
jS(
N(RR9Rf(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRRR;(R
R(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytno_lastrowid_supportNs
c


Cs
tj
�S(
N(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytreflects_pk_namesUsc


Cs
tj
�S(
s8target database has general support for table reflection(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttable_reflectionYsc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytreflect_tables_no_columns^sc


Cs
tj
�S(
N(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytcomment_reflectionesc


Cs|jS(
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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytview_column_reflectionisc


Cs|jS(
sStarget database must support inspection of the full CREATE VIEW
        definition.(
RX(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytview_reflectionssc


Cs|jS(
N(
RZ(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytschema_reflectionysc


Cs
tj
�S(
N(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt!primary_key_constraint_reflection}sc


Cs
tj
�S(
N(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt!foreign_key_constraint_reflection�sc


Cs
tj
�S(
N(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt1foreign_key_constraint_option_reflection_ondelete�sc


Cs
tj
�S(
N(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt1fk_constraint_option_reflection_ondelete_restrict�sc


Cs
tj
�S(
N(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt1fk_constraint_option_reflection_ondelete_noaction�sc


Cs
tj
�S(
N(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt1foreign_key_constraint_option_reflection_onupdate�sc


Cs
tj
�S(
N(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt1fk_constraint_option_reflection_onupdate_restrict�sc


Cs
tj
�S(
N(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttemp_table_reflection�sc


Cs|jS(
N(
Rw(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttemp_table_reflect_indexes�sc


Cs
tj
�S(
s8target dialect supports listing of temporary table names(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttemp_table_names�sc


Cs
tj
�S(
s9target dialect supports checking a single temp table name(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pythas_temp_table�sc


Cs
tj
�S(
s)target database supports temporary tables(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttemporary_tables�sc


Cs
tj
�S(
s(target database supports temporary views(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttemporary_views�sc


Cs
tj
�S(
N(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytindex_reflection�sc


Cs
tj
�S(
N(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytindex_reflects_included_columns�sc


Cs
tj
�S(
s?target database supports CREATE INDEX with per-column ASC/DESC.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytindexes_with_ascdesc�sc


Cs
tj
�S(
s>target database supports CREATE INDEX against SQL expressions.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytindexes_with_expressions�sc


Cs
tj
�S(
s8target dialect supports reflection of unique constraints(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytunique_constraint_reflection�sc


Cs
tj
�S(
s7target dialect supports reflection of check constraints(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytcheck_constraint_reflection�sc


Cs
tj
�S(
s�target dialect raises IntegrityError when reporting an INSERT
        with a primary key violation.  (hint: it should)

        (R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt$duplicate_key_raises_integrity_error�sc


Cs
tj
�S(
s3Target database must support VARCHAR with no length(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytunbounded_varchar�sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytunicode_data�sc


Cs
tj
�S(
sRTarget driver must support some degree of non-ascii symbol
        names.
        (R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytunicode_ddl�sc


Cs
tj
�S(
s?Target driver can create tables with a name like 'some " table'(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytsymbol_names_w_double_quote�sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdatetime_literals�sc


Cs
tj
�S(
sUtarget dialect supports representation of Python
        datetime.datetime() objects.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdatetime�sc


Cs
tj
�S(
svtarget dialect supports representation of Python
        datetime.datetime() with tzinfo with DateTime(timezone=True).(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdatetime_timezonesc


Cs
tj
�S(
sntarget dialect supports representation of Python
        datetime.time() with tzinfo with Time(timezone=True).(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
time_timezonesc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdatetime_implicit_boundsc


Cs
tj
�S(
sftarget dialect supports representation of Python
        datetime.datetime() with microsecond objects.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdatetime_microsecondssc


Cs
tj
�S(
s�target dialect supports representation of Python
        datetime.datetime() with microsecond objects but only
        if TIMESTAMP is used.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttimestamp_microseconds"sc


Cs|jS(
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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt%timestamp_microseconds_implicit_bound)sc


Cs
tj
�S(
sutarget dialect supports representation of Python
        datetime.datetime() objects with historic (pre 1970) values.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdatetime_historic3sc


Cs
tj
�S(
sQtarget dialect supports representation of Python
        datetime.date() objects.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdate:sc


Cs
tj
�S(
sPtarget dialect accepts a datetime object as the target
        of a date column.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdate_coerces_from_datetimeAsc


Cs
tj
�S(
sutarget dialect supports representation of Python
        datetime.datetime() objects with historic (pre 1970) values.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
date_historicHsc


Cs
tj
�S(
sQtarget dialect supports representation of Python
        datetime.time() objects.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttimeOsc


Cs
tj
�S(
sbtarget dialect supports representation of Python
        datetime.time() with microsecond objects.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttime_microsecondsVsc


Cs
tj
�S(
sttarget database/driver can allow BLOB/BINARY fields to be compared
        against a bound parameter value.
        (R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytbinary_comparisons]sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytbinary_literalsesc


Cs
tj
�S(
s:target dialect supports 'AUTOCOMMIT' as an isolation_level(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
autocommitusc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytisolation_levelzsc
Csd
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((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytget_isolation_levels�R;c


Cs
tj
�S(
s.target platform implements a native JSON type.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt	json_type�sc


Cs|jS(
sNtarget platform supports numeric array indexes
        within a JSON structure(
R�(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytjson_array_indexes�sc


Cs
tj
�S(
N(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt(json_index_supplementary_unicode_element�sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt!legacy_unconditional_json_extract�sc


Cs
tj
�S(
sRtarget backend has general support for moderately high-precision
        numerics.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytprecision_numerics_general�sc


Cs
tj
�S(
sbtarget backend supports Decimal() objects using E notation
        to represent very small values.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt"precision_numerics_enotation_small�sc


Cs
tj
�S(
sbtarget backend supports Decimal() objects using E notation
        to represent very large values.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt"precision_numerics_enotation_large�sc


Cs
tj
�S(
s�target backend supports values with many digits on both sides,
        such as 319438950232418390.273596, 87673.594069654243

        (R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt*precision_numerics_many_significant_digits�sc


Cs|jS(
s}same as precision_numerics_many_significant_digits but within the
        context of a CAST statement (hello MySQL)

        (
R�(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt/cast_precision_numerics_many_significant_digits�sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytimplicit_decimal_binds�sc


Cs
tj
�S(
shtarget database can select an aggregate from a subquery that's
        also using an aggregate

        (R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytnested_aggregates�sc


Cs
tj
�S(
sbtarget database must support ON DELETE CASCADE on a self-referential
        foreign key

        (R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytrecursive_fk_cascade�sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt-precision_numerics_retains_significant_digitssc


Cs
tj
�S(
s@The Float type can persist and load float('inf'), float('-inf').(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytinfinity_floatssc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytprecision_generic_float_typesc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytliteral_float_coercionsc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytfloats_to_four_decimals$sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytfetch_null_from_numeric-sc


Cs
tj
�S(
sUTarget database must support an unbounded Text() "
        "type such as TEXT or CLOB(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt	text_type7sc


Cs
tj
�S(
sTtarget database can persist/return an empty string with a
        varchar.

        (R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytempty_strings_varchar>sc


Cs
tj
�S(
sRtarget database can persist/return an empty string with an
        unbounded text.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytempty_strings_textFsc


Cs
tj
�S(
sUtarget database supports use of an unbounded textual field in a
        WHERE clause.(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt"expressions_against_unbounded_textMsc


Cs
tj
�S(
s;target driver must support the literal statement 'select 1'(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt	selectoneTsc


Cs
tj
�S(
s(Target database must support savepoints.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
savepointsYsc


Cs
tj
�S(
s4Target database must support two-phase transactions.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttwo_phase_transactions_sc


Cs
tj
�S(
s'Target must support UPDATE..FROM syntax(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytupdate_fromesc


Cs
tj
�S(
s=Target must support DELETE FROM..FROM or DELETE..USING syntax(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdelete_fromjsc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytupdate_where_target_in_subqueryosc


Cs
tj
�S(
sOtarget database must use a plain percent '%' as the 'modulus'
        operator.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytmod_operator_as_percent_signsc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytpercent_schema_names�s
c


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytorder_by_col_from_union�sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytorder_by_label_with_expression�s
c
s�f
d
�}
tj
|
�
S(Nc

s.y�j|�

t
SWntk
r)


tSXdS(
N(tget_order_by_collationtFalsetNotImplementedErrortTrue(
R(
R
(sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytcheck�s







(R
R<(R
R�((
R
sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytorder_by_collation�sc
Cs
t��
dS(
N(
R�(R
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR��s
c


Cs
tj
�S(
sUTarget driver must support non-ASCII characters being passed at
        all.
        (R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytunicode_connections�sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytgraceful_disconnects�sc


Cs
tj
�S(
sU
        Target must support simultaneous, independent database connections.
        (R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytindependent_connections�sc


Cs
tj
�S(
s9Catchall for a large variety of MySQL on Windows failures(R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytskip_mysql_on_windows�sc

Cstj
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


Ss
|jj
S(
N(toptionstlow_connections(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�R;(R
R<(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytad_hoc_engines�s	
c

Cstj
|j��
S(
N(R
R<t_running_on_windows(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
no_windows�sc

Cstj
d
�dd�

S(NcSstj
�d
kS(NtWindows(tplatformtsystem(((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�R;tdescriptionsrunning on Windows(R
tLambdaPredicate(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR��s

	
c

Cs
tj
d
�
S(Nttiming_intensive(R
trequires_tag(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR��sc

Cs
tj
d
�
S(Ntmemory_intensive(R
R�(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR��sc

Cstj
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


Sstj
o|jjS(
N(Rtpy3kR�thas_coverage(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�R;s%Stability issues with coverage + py3k(R
R<(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytthreading_with_mock�s

c
Csd
�}
tj
|
�
S(Nc

Ss+ytd
�

Wnt
k
r"


tSXtSdS(Nssqlalchemy-stubs.ext.mypy(t
__import__tImportErrorR�R�(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR��s





(R
R(R
R�((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytsqlalchemy2_stubs�s	c

Cstj
d
�d�S(NcSs
tj
dkS(Ni(
i(tsystversion_info(((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRR;s Python version 2.xx is required.(R
R<(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytpython2	s

c

Cstj
d
�d�S(NcSs
tj
dkS(Ni(
i(R�R�(((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRR;s Python version 3.xx is required.(R
R<(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytpython3s
c


Cs|jS(
N(
tpython36(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytpep520sc


Cs|jS(
N(
tpython37(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytinsert_order_dictssc

Cstj
d
�d�S(NcSs
tj
dkS(Nii(ii(R�R�(((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR!R;s*Python version 3.6 or greater is required.(R
R<(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�s

c

Cstj
d
�d�S(NcSs
tj
dkS(Nii(ii(R�R�(((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR(R;s*Python version 3.7 or greater is required.(R
R<(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�%s

c


Cs|jS(
N(
R�(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdataclasses,sc

Cstj
d
�d�S(Nc
Sstj
S(
N(Rtpy38(((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR3R;sPython 3.8 or above required(R
R(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytpython380s
c

Cstj
d
�d�S(Nc
Sstj
S(
N(Rtcpython(((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR9R;scPython interpreter needed(R
R(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�6s
c

Cstj
d
�d�S(Nc
Sstj
S(
N(Rtis64bit(((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR>R;s64bit required(R
R(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�<sc
Csd
�}
tj
|
d�S(NcSs+ytd
�

Wnt
k
r"


tSXtSdS(Ntpatch(R�R�R�R�(((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt	check_libBs





spatch library needed(R
R(R
R�((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
patch_library@s	c

s)d
dlm
�
tj�f
d�d�S(Ni����(
tpicklecs%tj
r�jd
kp$tjdkS(NtcPickleii(ii(RR�RR�R�((
R�(sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRQs	

s.Needs cPickle+cPython or newer Python 3 pickle(tsqlalchemy.utilR�R
R(
R
((
R�sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytnon_broken_pickleLs
c


Cs|jS(
s�target platform must remove all cycles unconditionally when
        gc.collect() is called, as well as clean out unreferenced subclasses.

        (
R�(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytpredictable_gcWsc

Cstj
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


Ss
|jj
S(
N(R�R�(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRhR;s(Issues observed when coverage is enabled(R
R<(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytno_coverage_s

c
CstS(
N(
R�(R
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt_has_mysql_on_windowsls
c
CstS(
N(
R�(R
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt_has_mysql_fully_case_sensitiveos
c

stj
�f
d
��
S(Nc
s�j�S(
N(
t_has_sqlite((
R
(sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRtR;(R
R<(
R
((
R
sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytsqlitersc

Cstj
d
�d�S(Nc
Sstj
�S(
N(Rthas_compiled_ext(((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRyR;sC extensions not installed(R
R<(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytcextensionsvs
c
Cs;d
dlm
}

y|
d�

tSWntk
r6


tSXdS(Ni����(
t
create_engines	sqlite://(t
sqlalchemyR�R�R�R�(R
R�((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�|s






c


Cs
tj
�S(
s@dialect makes use of await_() to invoke operations on the DBAPI.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
async_dialect�sc


Cs|jS(
N(
tgreenlet(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�sc
Csd
�}
tj
|
�
S(Nc
Ss:tj
s
tSyd
dl}
Wntk
r1


tSXtSdS(Ni����(t
_test_asynciotENABLE_ASYNCIOR�R�R�R�(RR�((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�s
	




(R
R(R
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR��s	c


Cs
tj
�S(
sSupports computed columns(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytcomputed_columns�sc


Cs
tj
�S(
s/Supports computed columns with `persisted=True`(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytcomputed_columns_stored�sc


Cs
tj
�S(
s0Supports computed columns with `persisted=False`(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytcomputed_columns_virtual�sc


Cs
tj
�S(
sSIf the default persistence is virtual or stored when `persisted`
        is omitted(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt"computed_columns_default_persisted�sc


Cs
tj
�S(
sTIf persistence information is returned by the reflection of
        computed columns(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt"computed_columns_reflect_persisted�sc


Cs
tj
�S(
s1If a backend supports the DISTINCT ON in a select(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytsupports_distinct_on�sc

Cstj
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


Ss|jj
jS(
N(RR9tsupports_is_distinct_from(
R((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR�R;s4driver doesn't support an IS DISTINCT FROM construct(R
R<(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR
�s

c


Cs
tj
�S(
sKIf a backend supports GENERATED { ALWAYS | BY DEFAULT }
        AS IDENTITY(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytidentity_columns�sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytidentity_columns_standard�sc


Cs
tj
�S(
s+backend supports the regexp_match operator.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytregexp_match�sc


Cs
tj
�S(
s-backend supports the regexp_replace operator.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytregexp_replace�sc


Cs
tj
�S(
s(backend supports the fetch first clause.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytfetch_first�sc


Cs
tj
�S(
s5backend supports the fetch first clause with percent.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
fetch_percent�sc


Cs
tj
�S(
s2backend supports the fetch first clause with ties.(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt
fetch_ties�sc


Cs
tj
�S(
s1backend supports the fetch first without order by(R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytfetch_no_order_by�sc


Cs
tj
�S(
swbackend supports the offset when using fetch first with percent
        or ties. basically this is "not mssql"
        (R
R
(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytfetch_offset_with_options�sc


Cs
tj
�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
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytfetch_expression
sc


Cs
tj
�S(
sIf autoincrement=True on a column does not require an explicit
        sequence. This should be false only for oracle.
        (R
R	(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytautoincrement_without_sequence
sc

Cstj
d
��
S(s=If X[Y] can be implemented with ``__class_getitem__``. py3.7+c
Sstj
S(
N(Rtpy37(((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRR;(R
R(
R
((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytgeneric_classess(�RRtpropertyRRRRRRRRRRRRR R!R"R#R$R%R&R'R(R)R*R+R,R-R.R/R0R1R2R3R4R5R6R7R8R=R@RBRFRGRHRIRJRLRMRNRORQRSRTRURVRWRXRZR[R\R]R^R`RbRdReRgRhRiRjRkRlRmRnRoRpRqRrRsRtRuRvRwRxRyRzR{R|R}R~RR�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�RR�R�R�R�R�R�R�R
R

R
R
R
R
R
R
R
R	
R

R
R

(((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR s�


			
	

	
		


			

	
	

	
	
					(t__doc__R�R�R;RR�R
RRRRtobjectRR(((sP/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt<module>s