summaryrefslogtreecommitdiff
path: root/test/engine
Commit message (Collapse)AuthorAgeFilesLines
* Add basic support of unique constraints reflectionpr/4Roman Podolyaka2013-06-091-0/+37
| | | | | | | | | | | | Inspection API already supports reflection of table indexes information and those also include unique constraints (at least for PostgreSQL and MySQL). But it could be actually useful to distinguish between indexes and plain unique constraints (though both are implemented in the same way internally in RDBMS). This change adds a new method to Inspection API - get_unique_constraints() and implements it for SQLite, PostgreSQL and MySQL dialects.
* - clean up some of the requires for cross-schema reflectionMike Bayer2013-06-031-7/+4
| | | | - add oracle profile counts
* Fixed bug whereby using :meth:`.MetaData.reflect` across a remoteMike Bayer2013-06-031-0/+24
| | | | | | schema as well as a local schema could produce wrong results in the case where both schemas had a table of the same name. [ticket:2728]
* - additional oracle fixes. cx_oracle under py3k is complaining about tuples ↵Mike Bayer2013-05-271-1/+4
| | | | | | | to executemany(), so just unconditionally turn this into a list - this one test segfaults only on py3k + cx_oracle
* fix test_execute w c extensionsMike Bayer2013-05-261-4/+2
|
* merge defaultMike Bayer2013-05-051-17/+20
|\
| * - cleanupMike Bayer2013-05-051-17/+20
| | | | | | | | - move the timeout here to 14 seconds as jenkins still chokes occasionally
| * cleanupMike Bayer2013-05-041-79/+78
| |
* | that's all of engineMike Bayer2013-05-042-10/+11
| |
* | cleanupMike Bayer2013-05-041-79/+78
| |
* | test_execute up for sqlite, pg, oursql, mysql 2.7 + 3.3Mike Bayer2013-05-041-1/+2
| |
* | merge defaultMike Bayer2013-04-301-2/+2
|\ \ | |/
| * missing commaMike Bayer2013-04-301-2/+2
| |
* | merge defaultMike Bayer2013-04-291-13/+6
|\ \ | |/
| * Updated mysqlconnector dialect to check for disconnect basedMike Bayer2013-04-291-13/+6
| | | | | | | | | | on the apparent string message sent in the exception; tested against mysqlconnector 1.0.9.
* | - the raw 2to3 runMike Bayer2013-04-2710-75/+75
|/ | | | - went through examples/ and cleaned out excess list() calls
* - test + changelog for [ticket:2691]Mike Bayer2013-04-181-1/+23
|
* Improvements to Connection auto-invalidationMike Bayer2013-04-111-14/+122
| | | | | | | | | | | | | handling. If a non-disconnect error occurs, but leads to a delayed disconnect error within error handling (happens with MySQL), the disconnect condition is detected. The Connection can now also be closed when in an invalid state, meaning it will raise "closed" on next usage, and additionally the "close with result" feature will work even if the autorollback in an error handling routine fails and regardless of whether the condition is a disconnect or not. [ticket:2695]
* Merged in nakagami/sqlalchemy/cymysql (pull request #42)Mike Bayer2013-03-073-2/+6
|\ | | | | | | cymysql support
| * fix decorator positionHajime Nakagami2013-03-021-1/+1
| |
| * mymysql dialectHajime Nakagami2013-03-011-0/+3
| |
| * avoid drop table in mysql+cymysql test because of deadlockHajime Nakagami2013-02-221-0/+1
| |
| * test for cymysqlHajime Nakagami2013-02-171-2/+2
| |
* | - :meth:`.MetaData.create_all` and :meth:`.MetaData.drop_all` willMike Bayer2013-03-021-0/+184
| | | | | | | | | | | | | | | | | | | | now accommodate an empty list as an instruction to not create/drop any items, rather than ignoring the collection. [ticket:2664]. This is a behavioral change and extra notes to the changelog and migration document have been added. - create a new test suite for exercising codepaths in engine/ddl.py
* | - Fixed an import of "logging" in test_execute which was notMike Bayer2013-03-021-1/+1
|\ \ | |/ |/| | | | | working on some linux platforms. Also in 0.7.11. - only need "logging.handlers" here, "logging" comes in implicitly
| * test_execute: import logging.handlers to fix AttributeErrorMike Gilbert2013-02-271-1/+1
|/ | | | See also: https://bugs.gentoo.org/show_bug.cgi?id=458684
* - adding in requirementsMike Bayer2013-02-061-3/+3
| | | | - get test_naturalpks to be more generalized
* - recognize that do_rollback() and do_commit() work with a DBAPI connection,Mike Bayer2012-11-221-5/+73
| | | | | | | | | | | | | | | | | | whereas the other do_rollback_twophase(), savepoint etc. work with :class:`.Connection`. the context on these are different as twophase/savepoint are available at the :class:`.Connection` level, whereas commit/rollback are needed at a lower level as well. Rename the argument to "dbapi_connection" when the conneciton is in fact the DBAPI interface. - start thinking about being able to track "autocommit" vs. "commit", but not sure we have a need for this yet. - have Pool call out to a Dialect for all rollback/commit/close operations now. Pool no longer calls DBAPI methods directly. May use this for a workaround for [ticket:2611] - add a new Pool event reset() to allow the pool's reset of the connection to be intercepted. - remove methods in Informix dialect which appear to be hardcoding some isolation settings on new Transaction only; the isolation API should be implemented for Informix. also removed "flag" for transaction commit/rollback being not available; this should be based on server/DBAPI version and we will need someone with test access in order to help determine how this should work
* The :meth:`.Connection.connect` and :meth:`.Connection.contextual_connect`Mike Bayer2012-11-141-1/+24
| | | | | | | methods now return a "branched" version so that the :meth:`.Connection.close` method can be called on the returned connection without affecting the original. Allows symmetry when using :class:`.Engine` and :class:`.Connection` objects as context managers.
* Fixed :meth:`.MetaData.reflect` to correctly useMike Bayer2012-11-141-10/+37
| | | | | | the given :class:`.Connection`, if given, without opening a second connection from that connection's :class:`.Engine`. [ticket:2604]
* Added a new method :meth:`.Engine.execution_options`Mike Bayer2012-10-231-2/+63
| | | | | | | | | | | to :class:`.Engine`. This method works similarly to :class:`.Connection.execution_options` in that it creates a copy of the parent object which will refer to the new set of options. The method can be used to build sharding schemes where each engine shares the same underlying pool of connections. The method has been tested against the horizontal shard recipe in the ORM as well.
* - test updatesMike Bayer2012-10-041-5/+7
|
* - more tests, move some tests out of test_reflection, test_queryMike Bayer2012-09-271-317/+0
|
* trying different approaches to test layout. in this one, the testing modulesMike Bayer2012-09-279-44/+49
| | | | | | | become an externally usable package but still remains within the main sqlalchemy parent package. in this system, we use kind of an ugly hack to get the noseplugin imported outside of the "sqlalchemy" package, while still making it available within sqlalchemy for usage by third party libraries.
* - got firebird runningMike Bayer2012-09-231-5/+5
| | | | | | | | | | | | - add some failure cases - [bug] Firebird now uses strict "ansi bind rules" so that bound parameters don't render in the columns clause of a statement - they render literally instead. - [bug] Support for passing datetime as date when using the DateTime type with Firebird; other dialects support this.
* finished fixes for mxodbc; need to use at least version 3.2.1Mike Bayer2012-09-211-3/+1
|
* - add req's for predictable gcMike Bayer2012-09-051-0/+2
|
* - fixes for mxODBC, some pyodbcMike Bayer2012-09-021-6/+10
| | | | | | - enhancements to test suite including ability to set up a testing engine for a whole test class, fixes to how noseplugin sets up/tears down per-class context
* with statementMike Bayer2012-09-011-0/+1
|
* - get all tests within -w engine + pyodbc:mssql on windows to passMike Bayer2012-09-012-17/+24
|
* adjust this test which passes on some psycopg2s, fails on others, and we ↵Mike Bayer2012-08-281-2/+2
| | | | | | dont have a good testing decorator to check this
* - [feature] The "required" flag is set toMike Bayer2012-08-271-6/+4
| | | | | | | | | | True by default, if not passed explicitly, on bindparam() if the "value" or "callable" parameters are not passed. This will cause statement execution to check for the parameter being present in the final collection of bound parameters, rather than implicitly assigning None. [ticket:2556]
* - [feature] Added support for .info dictionary argument toMike Bayer2012-08-241-1/+1
| | | | | | column_property(), relationship(), composite(). All MapperProperty classes have an auto-creating .info dict available overall.
* future for with statementMike Bayer2012-08-241-0/+2
|
* - [feature] The before_cursor_execute eventMike Bayer2012-08-231-1/+29
| | | | | | | | | fires off for so-called "_cursor_execute" events, which are usually special-case executions of primary-key bound sequences and default-generation SQL phrases that invoke separately when RETURNING is not used with INSERT. [ticket:2459]
* - add new C extension "utils", so far includes distill_paramsMike Bayer2012-08-072-10/+118
| | | | | - repair test_processors which wasn't hitting the python functions - add another suite to test_processors that does distill_params
* - break out engine/base.py into base, interfaces, result, util.Mike Bayer2012-08-072-8/+8
| | | | - remove deprecated 0.7 engine methods
* -whitespace bonanza, contdMike Bayer2012-07-285-69/+69
|
* - [feature] Connection event listeners canMike Bayer2012-07-181-70/+113
| | | | | | now be associated with individual Connection objects, not just Engine objects. [ticket:2511]
* try to loosen the times up here to reduce failures due to latencyMike Bayer2012-07-171-18/+18
|