b]c@sbdZddlZddlmZddlmZdefdYZd efd YZdS( sGlobal 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. iNi(t exclusionsi(tutilt RequirementscBseZRS((t__name__t __module__(((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRstSuiteRequirementscBseZedZedZedZedZedZedZedZ edZ edZ ed Z ed Z ed Zed Zed ZedZedZedZedZedZedZedZedZedZedZedZedZedZedZedZedZ edZ!edZ"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/Z2ed0Z3ed1Z4ed2Z5ed3Z6ed4Z7ed5Z8ed6Z9ed7Z:ed8Z;ed9Z<ed:Z=ed;Z>ed<Z?ed=Z@ed>ZAed?ZBed@ZCedAZDedBZEedCZFedDZGedEZHedFZIedGZJedHZKedIZLedJZMedKZNedLZOedMZPedNZQedOZRedPZSedQZTedRZUedSZVedTZWedUZXedVZYedWZZedXZ[edYZ\edZZ]ed[Z^ed\Z_ed]Z`ed^Zaed_Zbed`ZcedaZdedbZeedcZfeddZgedeZhedfZiedgZjedhZkediZledjZmedkZnedlZoedmZpednZqedoZredpZsdqZtedrZuedsZvedtZweduZxedvZyedwZzedxZ{edyZ|edzZ}ed{Z~ed|Zed}Zed~ZedZdZdZedZedZdZdZRS(cCs tjS(s/target platform can emit basic CreateTable DDL.(Rtopen(tself((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt create_tablescCs tjS(s-target platform can emit basic DropTable DDL.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt drop_table#scCs tjS(s*Target database must support foreign keys.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt foreign_keys)scCs tjS(sR"target database must support ON UPDATE..CASCADE behavior in foreign keys.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyton_update_cascade/scCs tjS(sWtarget database must *not* support ON UPDATE..CASCADE behavior in foreign keys.(Rtclosed(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytnon_updating_cascade6scCs tjS(N(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdeferrable_fks<scstjfdS(NcsjjpjjS(N(R tenabledR((R(s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytFs (Rtonly_if(R((Rs>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyton_update_or_deferrable_fks@scCs tjS(s;Target database must support self-referential foreign keys.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytself_referential_foreign_keysJscCs tjS(s=Target database must support the DDL phrases for FOREIGN KEY.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytforeign_key_ddlPscCs tjS(s3target database must support names for constraints.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytnamed_constraintsVscCs tjS(s(Target database must support subqueries.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt subqueries\scCs tjS(sRtarget database can render OFFSET, or an equivalent, in a SELECT. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytoffsetbscCs tjS(sWtarget database can render LIMIT and/or OFFSET using a bound parameter (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytbound_limit_offsetjscCs tjS(starget database can render LIMIT and/or OFFSET with a complete SQL expression, such as one that uses the addition operator. parameter (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytsql_expression_limit_offsetrscCs tjS(sTarget 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. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt/parens_in_union_contained_select_w_limit_offset{s cCs tjS(slTarget 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. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt0parens_in_union_contained_select_wo_limit_offsets cCs tjS(s;Target database must support boolean expressions as columns(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytboolean_col_expressionsscCs tjS(s5Target database allows boolean columns to store NULL.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytnullable_booleansscCs tjS(s,Target backends that support nulls ordering.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt nullsorderingscCs tjS(starget database/driver supports bound parameters as column expressions without being in the context of a typed column. (RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytstandalone_bindsscCs tjS(starget database/driver supports bound parameters with NULL in the WHERE clause, in situations where it has to be typed. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt!standalone_null_binds_whereclausescCs tjS(s5Target database must support INTERSECT or equivalent.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt intersectscCs tjS(s?Target database must support EXCEPT or equivalent (i.e. MINUS).(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytexcept_scCs tjS(s.Target database must support window functions.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytwindow_functionsscCs tjS(sTarget database supports CTEs(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytctesscCs tjS(starget database supports CTES that ride on top of a normal UPDATE or DELETE statement which refers to the CTE in a correlated subquery. (RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytctes_with_update_deletescCs tjS(s}target database supports CTES which consist of INSERT, UPDATE or DELETE *within* the CTE, e.g. WITH x AS (UPDATE....)(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt ctes_on_dmlscCs tjS(s~target platform generates new surrogate integer primary key values when insert() is executed, excluding the pk column.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytautoincrement_insertscCs tjS(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. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytfetch_rows_post_commits cCs tjS(starget platform supports SQL expressions in GROUP BY e.g. SELECT x + y AS somelabel FROM table GROUP BY x + y (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytgroup_by_complex_expressions cCstjddS(NcSs|jjj S(N(tdbtdialecttsupports_sane_rowcount(tconfig((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRts&driver doesn't support 'sane' rowcount(Rtskip_if(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt sane_rowcountscCstjddS(NcSs|jjj S(N(R*R+tsupports_sane_multi_rowcount(R-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRR.s;driver %(driver)s %(doesnt_support)s 'sane' multi row count(Rtfails_if(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytsane_multi_rowcountscCstjddS(NcSs|jjj S(N(R*R+t supports_sane_rowcount_returning(R-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR ss;driver doesn't support 'sane' rowcount when returning is on(RR2(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytsane_rowcount_w_returning scCstjddS(satarget platform supports INSERT with no values, i.e. INSERT DEFAULT VALUES or equivalent.cSs|jjjp|jjjS(N(R*R+tsupports_empty_inserttsupports_default_values(R-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRssempty inserts not supported(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt empty_insertsscCs tjS(s.target platform supports INSERT from a SELECT.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytinsert_from_selectscCstjddS(s#target platform supports RETURNING.cSs |jjjS(N(R*R+timplicit_returning(R-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyR)R.s)%(database)s %(does_support)s 'returning'(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt returning$scCs tjS(sZTarget platform supports the syntax "(x, y) IN ((x1, y1), (x2, y2), ...)" (RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttuple_in-scCs tjS(swtarget platform supports a SELECT statement that has the same name repeated more than once in the columns list.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt%duplicate_names_in_cursor_description5scCstjddS(s[Target database must have 'denormalized', i.e. UPPERCASE as case insensitive names.cSs|jjj S(N(R*R+trequires_name_normalize(R-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRBR.s,Backend does not require denormalized names.(RR/(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdenormalized_names<scCstjddS(sTtarget database must support multiple VALUES clauses in an INSERT statement.cSs|jjj S(N(R*R+tsupports_multivalues_insert(R-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRLR.s*Backend does not support multirow inserts.(RR/(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytmultivalues_insertsFscCs tjS(sw"target dialect implements the executioncontext.get_lastrowid() method without reliance on RETURNING. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytimplements_get_lastrowidPscCs tjS(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. (RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytemulated_lastrowidXs cCs tjS(s^"target platform includes a 'lastrowid' accessor on the DBAPI cursor object. (RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdbapi_lastrowiddscCs tjS(s#Target database must support VIEWs.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytviewslscCs tjS(sXTarget database must support external schemas, and have one named 'test_schema'.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytschemasrscCs tjS(sLtarget system must support reflection of inter-schema foreign keys (RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytcross_schema_fk_reflectionyscCs tjS(starget system has a strong concept of 'default' schema that can be referred to implicitly. basically, PostgreSQL. (RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytimplicit_default_schemascCstjdgdS(s0Target dialect must support server side cursors.cSs |jjjS(N(R*R+tsupports_server_side_cursors(R-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRR.sno server side cursors support(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytserver_side_cursorss cCstjdgdS(s'Target database must support SEQUENCEs.cSs |jjjS(N(R*R+tsupports_sequences(R-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRR.sno sequence support(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt sequencess cCstjdgdS(sgTarget database supports sequences, but also optionally as a means of generating new PK values.cSs|jjjo|jjjS(N(R*R+RKtsequences_optional(R-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRss.no sequence support, or sequences not optional(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRMs cCs tjS(N(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytreflects_pk_namesscCs tjS(N(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttable_reflectionscCs tjS(N(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytcomment_reflectionscCs|jS(starget 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. (RE(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytview_column_reflectionscCs|jS(sTtarget database must support inspection of the full CREATE VIEW definition. (RE(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytview_reflectionscCs|jS(N(RF(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytschema_reflectionscCs tjS(N(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt!primary_key_constraint_reflectionscCs tjS(N(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt!foreign_key_constraint_reflectionscCs tjS(N(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt1foreign_key_constraint_option_reflection_ondeletescCs tjS(N(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt1foreign_key_constraint_option_reflection_onupdatescCs tjS(N(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttemp_table_reflectionscCs tjS(s8target dialect supports listing of temporary table names(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttemp_table_namesscCs tjS(s)target database supports temporary tables(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttemporary_tablesscCs tjS(s(target database supports temporary views(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttemporary_viewsscCs tjS(N(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytindex_reflectionscCs tjS(s>target database supports CREATE INDEX against SQL expressions.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytindexes_with_expressionsscCs tjS(s8target dialect supports reflection of unique constraints(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytunique_constraint_reflectionscCs tjS(s7target dialect supports reflection of check constraints(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytcheck_constraint_reflectionscCs tjS(starget dialect raises IntegrityError when reporting an INSERT with a primary key violation. (hint: it should) (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt$duplicate_key_raises_integrity_errorscCs tjS(s3Target database must support VARCHAR with no length(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytunbounded_varcharscCs tjS(sTarget database/dialect must support Python unicode objects with non-ASCII characters represented, delivered as bound parameters as well as in result rows. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt unicode_data scCs tjS(sRTarget driver must support some degree of non-ascii symbol names. (RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt unicode_ddlscCs tjS(starget dialect supports rendering of a date, time, or datetime as a literal string, e.g. via the TypeEngine.literal_processor() method. (RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdatetime_literalsscCs tjS(sUtarget dialect supports representation of Python datetime.datetime() objects.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdatetime&scCs tjS(sftarget dialect supports representation of Python datetime.datetime() with microsecond objects.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdatetime_microseconds-scCs tjS(starget dialect supports representation of Python datetime.datetime() with microsecond objects but only if TIMESTAMP is used.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttimestamp_microseconds4scCs tjS(sutarget dialect supports representation of Python datetime.datetime() objects with historic (pre 1970) values.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdatetime_historic;scCs tjS(sQtarget dialect supports representation of Python datetime.date() objects.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdateBscCs tjS(sPtarget dialect accepts a datetime object as the target of a date column.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytdate_coerces_from_datetimeIscCs tjS(sutarget dialect supports representation of Python datetime.datetime() objects with historic (pre 1970) values.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt date_historicPscCs tjS(sQtarget dialect supports representation of Python datetime.time() objects.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttimeWscCs tjS(sbtarget dialect supports representation of Python datetime.time() with microsecond objects.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttime_microseconds^scCs tjS(sttarget database/driver can allow BLOB/BINARY fields to be compared against a bound parameter value. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytbinary_comparisonsescCs tjS(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. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytbinary_literalsmscCs tjS(s:target dialect supports 'AUTOCOMMIT' as an isolation_level(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt autocommit}scCs tjS(s.target platform implements a native JSON type.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt json_typescCs|jS(sO"target platform supports numeric array indexes within a JSON structure(Rq(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytjson_array_indexesscCs tjS(sRtarget backend has general support for moderately high-precision numerics.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytprecision_numerics_generalscCs tjS(sbtarget backend supports Decimal() objects using E notation to represent very small values.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt"precision_numerics_enotation_smallscCs tjS(sbtarget backend supports Decimal() objects using E notation to represent very large values.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt"precision_numerics_enotation_largescCs tjS(starget backend supports values with many digits on both sides, such as 319438950232418390.273596, 87673.594069654243 (RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt*precision_numerics_many_significant_digitsscCs tjS(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` (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytimplicit_decimal_bindsscCs tjS(shtarget database can select an aggregate from a subquery that's also using an aggregate (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytnested_aggregatesscCs tjS(sbtarget database must support ON DELETE CASCADE on a self-referential foreign key (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytrecursive_fk_cascadescCs tjS(sA 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.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt-precision_numerics_retains_significant_digitsscCs tjS(starget backend will return native floating point numbers with at least seven decimal places when using the generic Float type. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytprecision_generic_float_typescCs tjS(starget 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). (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytfloats_to_four_decimalsscCs tjS(starget backend doesn't crash when you try to select a NUMERIC value that has a value of NULL. Added to support Pyodbc bug #351. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytfetch_null_from_numericscCs tjS(sUTarget database must support an unbounded Text() " "type such as TEXT or CLOB(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt text_typescCs tjS(sTtarget database can persist/return an empty string with a varchar. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytempty_strings_varcharscCs tjS(sRtarget database can persist/return an empty string with an unbounded text.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytempty_strings_textscCs tjS(sUtarget database supports use of an unbounded textual field in a WHERE clause.(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt"expressions_against_unbounded_textscCs tjS(s;target driver must support the literal statement 'select 1'(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt selectonescCs tjS(s(Target database must support savepoints.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt savepointsscCs tjS(s4Target database must support two-phase transactions.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyttwo_phase_transactionsscCs tjS(s'Target must support UPDATE..FROM syntax(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt update_fromscCs tjS(s=Target must support DELETE FROM..FROM or DELETE..USING syntax(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt delete_from$scCs tjS(sTarget 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 ) (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytupdate_where_target_in_subquery)scCs tjS(sOtarget database must use a plain percent '%' as the 'modulus' operator.(RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytmod_operator_as_percent_sign9scCs tjS(starget 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. (RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytpercent_schema_names?s cCs tjS(starget database supports ordering by a column from a SELECT inside of a UNION E.g. (SELECT id, ...) UNION (SELECT id, ...) ORDER BY id (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytorder_by_col_from_unionKscCs tjS(starget 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. (RR (R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytorder_by_label_with_expressionUs csfd}tj|S(Ncs.yj|tSWntk r)tSXdS(N(tget_order_by_collationtFalsetNotImplementedErrortTrue(R-(R(s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytcheckfs   (RR/(RR((Rs>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytorder_by_collationdscCs tdS(N(R(RR-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRoscCs tjS(sUTarget driver must support non-ASCII characters being passed at all. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytunicode_connectionsrscCs tjS(sTarget driver must raise a DBAPI-level exception, such as InterfaceError, when the underlying connection has been closed and the execute() method is called. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytgraceful_disconnectsyscCs tjS(sU Target must support simultaneous, independent database connections. (RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytindependent_connectionsscCs tjS(s9Catchall for a large variety of MySQL on Windows failures(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytskip_mysql_on_windowsscCstjdS(sTest 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. cSs |jjS(N(toptionstlow_connections(R-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRR.(RR/(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytad_hoc_enginess cCs tjdS(Nttiming_intensive(Rt requires_tag(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRscCs tjdS(Ntmemory_intensive(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRscCstjddS(sMark tests that use threading and mock at the same time - stability issues have been observed with coverage + python 3.3 cSstjo|jjS(N(Rtpy3kRt has_coverage(R-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRR.s%Stability issues with coverage + py3k(RR/(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytthreading_with_mockscCstjddS(NcSs tjdkS(Ni(i(tsyst version_info(((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRR.s Python version 2.xx is required.(RR/(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytpython2scCstjddS(NcSs tjdkS(Ni(i(RR(((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRR.s Python version 3.xx is required.(RR/(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytpython3scCstjddS(NcSstjS(N(Rtcpython(((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRR.scPython interpreter needed(RR(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRscs)ddlmtjfddS(Ni(tpicklecs&tj rjdkp%tjdkS(NtcPickleii(ii(RtpypyRRR((R(s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRs s.Needs cPickle+cPython or newer Python 3 pickle(tsqlalchemy.utilRRR(R((Rs>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytnon_broken_pickles cCs|jS(starget platform must remove all cycles unconditionally when gc.collect() is called, as well as clean out unreferenced subclasses. (R(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytpredictable_gcscCstjddS(sTest 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. cSs |jjS(N(RR(R-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRR.s(Issues observed when coverage is enabled(RR/(R((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt no_coveragescCstS(N(R(RR-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt_has_mysql_on_windowsscCstS(N(R(RR-((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt_has_mysql_fully_case_sensitivescstjfdS(Ncs j S(N(t _has_sqlite((R(s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRR.(RR/(R((Rs>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pytsqlitescstjfddS(Ncs j S(N(t_has_cextensions((R(s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRR.sC extensions not installed(RR/(R((Rs>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyt cextensionsscCs;ddlm}y|dtSWntk r6tSXdS(Ni(t create_engines sqlite://(t sqlalchemyRRt ImportErrorR(RR((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRs   cCs7yddlm}m}tSWntk r2tSXdS(Ni(t cresultproxyt cprocessors(RRRRRR(RRR((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRs  (RRtpropertyRR R R R RRRRRRRRRRRRRRRR R!R"R#R$R%R&R'R(R)R0R3R5R8R9R;R<R=R?RARBRCRDRERFRGRHRJRLRMRNRORPRQRRRSRTRURVRWRXRYRZR[R\R]R^R_R`RaRbRcRdReRfRgRhRiRjRkRlRmRnRoRpRqRrRsRtRuRvRwRxRyRzR{R|R}R~RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR(((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyRs                               (t__doc__RR.RRtobjectRR(((s>lib/python2.7/site-packages/sqlalchemy/testing/requirements.pyts