summaryrefslogtreecommitdiff
path: root/test/dialect
Commit message (Collapse)AuthorAgeFilesLines
* - The exception wrapping system for DBAPI errors can now accommodateMike Bayer2014-07-291-0/+10
| | | | | | | | non-standard DBAPI exceptions, such as the psycopg2 TransactionRollbackError. These exceptions will now be raised using the closest available subclass in ``sqlalchemy.exc``, in the case of TransactionRollbackError, ``sqlalchemy.exc.OperationalError``. fixes #3075
* - add support for tags, including include/exclude support.Mike Bayer2014-07-272-2/+2
| | | | simplify tox again now that we can exclude tests more easily
* - scale up for mysql, sqliteMike Bayer2014-07-261-59/+84
|
* - Fixed bug in :class:`.postgresql.array` object where comparisonMike Bayer2014-07-252-0/+29
| | | | | to a plain Python list would fail to use the correct array constructor. Pull request courtesy Andrew. fixes #3141
* - flake8 all of test/dialect/postgresqlMike Bayer2014-07-255-758/+995
| | | | - add __backend__ to most tests so that pg8000 can start coming in
* - Fixed bug in oracle dialect test suite where in one test,Mike Bayer2014-07-181-4/+5
| | | | | 'username' was assumed to be in the database URL, even though this might not be the case. Fixes #3128
* - determine the root cause of the mysqlconnector issue, reportMike Bayer2014-07-101-5/+4
| | | | it and move on
* - mark tests failing for mysqlconnector, oursqlMike Bayer2014-07-101-3/+10
|
* - support __only_on__ and __backend__ at the same timeMike Bayer2014-07-091-6/+1
|
* - Changed the default value of "raise_on_warnings" to False forMike Bayer2014-07-094-3/+9
| | | | | | | | MySQLconnector. This was set at True for some reason. The "buffered" flag unfortunately must stay at True as MySQLconnector does not allow a cursor to be closed unless all results are fully fetched. fixes #2515 - lots of MySQL tests seemed to not be hitting all backends, so we should be getting some mysqlconnector failures now
* - add postgresql_regconfig argument to PG dialect for match() operator,jonathan vanasco2014-07-081-0/+81
| | | | implements PG's to_tsquery('regconfig', 'arg') pattern. fixes #3078
* Merge pull request #101 from ddimmich/mastermike bayer2014-07-071-2/+49
|\ | | | | Postgres 9.4 Jsonb support
| * jsonb support for <@, ?| and ?& added.pr/101Damian Dimmich2014-07-011-0/+19
| | | | | | | | need to see if equality already works.
| * it's OK to pass a dict in - it does the right thing, no need to quote itDamian Dimmich2014-06-281-1/+1
| | | | | | | | in the tests.
| * minor cleanup of the jsonb - had extraneous operators that where copiedDamian Dimmich2014-06-281-1/+15
| | | | | | | | | | | | from hstore that don't apply. Add tests for ? and @> operators.
| * and tests for JSONB - as this is a superset of JSON i've subclassedDamian Dimmich2014-06-281-1/+15
| | | | | | | | the JSON tests as all of these should be applicable as well.
* | - add a test to confirm #3096, we definitely get a timedeltaMike Bayer2014-06-251-0/+10
|/
* - fix test failuresMike Bayer2014-06-211-2/+2
|
* - Added a new type :class:`.postgresql.OID` to the Postgresql dialect.Mike Bayer2014-06-201-0/+13
| | | | | | | | While "oid" is generally a private type within PG that is not exposed in modern versions, there are some PG use cases such as large object support where these types might be exposed, as well as within some user-reported schema reflection use cases. fixes #3002
* - Fixed bug where column names added to ``mysql_length`` parameterMike Bayer2014-06-181-0/+33
| | | | | | | | on an index needed to have the same quoting for quoted names in order to be recognized. The fix makes the quotes optional but also provides the old behavior for backwards compatibility with those using the workaround. fixes #3085
* Merge branch 'master' of https://github.com/tlocke/sqlalchemy into tlocke-masterMike Bayer2014-05-302-64/+53
|\
| * PEP 8 tidy of pg8000 dialect and postgresql/test_dialect.pypr/88Tony Locke2014-05-221-50/+40
| |
| * Autocommit isolation level for postgresql+pg8000Tony Locke2014-05-221-7/+13
| | | | | | | | | | | | | | | | As with postgresql+psycopg2, execution_options(isolation_level='AUTOCOMMIT') now works for the postgresql+pg8000 dialect. Also enabled the autocommit test in test_dialect.py for pg8000.
| * pg8000 now passes test_extract() testTony Locke2014-05-211-1/+0
| |
| * Two tests now work for pg800 in EnumTestTony Locke2014-05-211-6/+0
| | | | | | | | | | The two tests, test_create_table() and test_unicode_labels() previously failed under pg8000, but now they pass, so this commit opens them up.
* | - Added the ``hashable=False`` flag to the PG :class:`.HSTORE` type, whichMike Bayer2014-05-251-0/+15
| | | | | | | | | | | | is needed to allow the ORM to skip over trying to "hash" an ORM-mapped HSTORE column when requesting it in a mixed column/entity list. Patch courtesy Gunnlaugur Þór Briem. Fixes #3053
* | - repair oracle compilation for new limit/offset system.Mike Bayer2014-05-241-15/+22
| |
* | - more tests, including backend testsMike Bayer2014-05-161-6/+6
|/ | | | - implement for SQL server, use window functions when simple limit/offset not available
* - changelog for #2785Mike Bayer2014-05-161-29/+15
| | | | | - refactor tests a bit fixes #2785
* Merge branch 'zero_indexes-param-for-postgresql-ARRAY-type' of ↵Mike Bayer2014-05-161-0/+53
|\ | | | | | | https://bitbucket.org/LevonXXL/sqlalchemy/overview into t
| * zero_indexes-param-for-postgresql-ARRAY-typeAlexey Terentev2014-05-131-0/+53
| |
* | Merged in WSMcG/sqlalchemy (pull request #15) Mike Bayer2014-05-121-0/+4
|\ \ | |/ |/| Added optional '=' to MySQL KEY_BLOCK_SIZE regex
| * Added optional '=' to MySQL KEY_BLOCK_SIZE regexW. Sean McGivern2014-04-191-0/+4
| |
* | - Fixed bug where the combination of "limit" rendering asMike Bayer2014-04-301-2/+5
| | | | | | | | | | | | | | | | | | "SELECT FIRST n ROWS" using a bound parameter (only firebird has both), combined with column-level subqueries which also feature "limit" as well as "positional" bound parameters (e.g. qmark style) would erroneously assign the subquery-level positions before that of the enclosing SELECT, thus returning parameters which are out of order. Fixes #3038
* | Fix many typos throughout the codebasepr/85Alex Gaynor2014-04-264-4/+4
|/ | | | Found using: https://github.com/intgr/topy
* - Fixed regression caused by release 0.8.5 / 0.9.3's compatibilityMike Bayer2014-03-251-1/+1
| | | | | | | | | enhancements where index reflection on Postgresql versions specific to only the 8.1, 8.2 series again broke, surrounding the ever problematic int2vector type. While int2vector supports array operations as of 8.1, apparently it only supports CAST to a varchar as of 8.3. fix #3000
* - Fixed a few errant ``u''`` strings that would prevent tests from passingMike Bayer2014-03-221-2/+2
| | | | in Py3.2. Patch courtesy Arfrever Frehtes Taifersar Arahesis. fixes #2980
* - Added new datatype :class:`.oracle.DATE`, which is a subclass ofMike Bayer2014-03-221-10/+15
| | | | | | | | | | | | :class:`.DateTime`. As Oracle has no "datetime" type per se, it instead has only ``DATE``, it is appropriate here that the ``DATE`` type as present in the Oracle dialect be an instance of :class:`.DateTime`. This issue doesn't change anything as far as the behavior of the type, as data conversion is handled by the DBAPI in any case, however the improved subclass layout will help the use cases of inspecting types for cross-database compatibility. Also removed uppercase ``DATETIME`` from the Oracle dialect as this type isn't functional in that context. fixes #2987
* - cx_oracle test for "unicode returns" needs to be cx_oracle only,Mike Bayer2014-03-061-0/+4
| | | | | | | and also will fail on py3k. - enhance exclusions so that a requirement attribute can be passed to fails_if/skip_if. - fix coverage docs to mention pytest.
* Merge branch 'master' of https://github.com/Cito/sqlalchemy into tMike Bayer2014-03-051-2/+8
|\
| * Restore coercion to unicode with cx_Oracle.pr/74Christoph Zwerschke2014-02-271-2/+8
| | | | | | | | This feature is now turned off by default.
* | pytest calls all the descriptors. and we can't call this one unconditionallyMike Bayer2014-03-041-7/+6
| |
* | - Support has been added for pytest to run tests. This runnerMike Bayer2014-03-034-41/+20
|/ | | | | | | | | | | | | | | | | | | | | | | | | | is currently being supported in addition to nose, and will likely be preferred to nose going forward. The nose plugin system used by SQLAlchemy has been split out so that it works under pytest as well. There are no plans to drop support for nose at the moment and we hope that the test suite itself can continue to remain as agnostic of testing platform as possible. See the file README.unittests.rst for updated information on running tests with pytest. The test plugin system has also been enhanced to support running tests against mutiple database URLs at once, by specifying the ``--db`` and/or ``--dburi`` flags multiple times. This does not run the entire test suite for each database, but instead allows test cases that are specific to certain backends make use of that backend as the test is run. When using pytest as the test runner, the system will also run specific test suites multiple times, once for each database, particularly those tests within the "dialect suite". The plan is that the enhanced system will also be used by Alembic, and allow Alembic to run migration operation tests against multiple backends in one run, including third-party backends not included within Alembic itself. Third party dialects and extensions are also encouraged to standardize on SQLAlchemy's test suite as a basis; see the file README.dialects.rst for background on building out from SQLAlchemy's test platform.
* - Added new MySQL-specific :class:`.mysql.DATETIME` which includesMike Bayer2014-02-191-3/+24
| | | | | | | fractional seconds support; also added fractional seconds support to :class:`.mysql.TIMESTAMP`. DBAPI support is limited, though fractional seconds are known to be supported by MySQL Connector/Python. Patch courtesy Geert JM Vanderkelen. #2941
* Merge branch 'master' of https://bitbucket.org/50onred/sqlalchemy/overview ↵Mike Bayer2014-02-191-0/+30
|\ | | | | | | into t
| * Fixes MySQL dialect partitioningMarcus McCurdy2014-02-141-0/+30
| |
* | - Support has been improved for Postgresql reflection behavior on very oldMike Bayer2014-02-184-7/+12
| | | | | | | | | | | | | | | | | | | | | | | | (pre 8.1) versions of Postgresql, and potentially other PG engines such as Redshift (assuming Redshift reports the version as < 8.1). The query for "indexes" as well as "primary keys" relies upon inspecting a so-called "int2vector" datatype, which refuses to coerce to an array prior to 8.1 causing failures regarding the "ANY()" operator used in the query. Extensive googling has located the very hacky, but recommended-by-PG-core-developer query to use when PG version < 8.1 is in use, so index and primary key constraint reflection now work on these versions.
* | - dont need this import and it's not in 2.6 anywayMike Bayer2014-02-171-1/+0
| |
* | - rewrite SQLite reflection tests into one consistent fixture, which testsMike Bayer2014-02-161-159/+144
| | | | | | | | both _resolve_type_affinity() directly as well as round trip tests fully.
* | - The SQLite dialect will now skip unsupported arguments when reflectingMike Bayer2014-02-161-4/+16
| | | | | | | | | | | | types; such as if it encounters a string like ``INTEGER(5)``, the :class:`.INTEGER` type will be instantiated without the "5" being included, based on detecting a ``TypeError`` on the first attempt.