summaryrefslogtreecommitdiff
path: root/test/engine
Commit message (Collapse)AuthorAgeFilesLines
...
* | - [feature] The column_reflect event nowMike Bayer2012-04-241-1/+1
| | | | | | | | | | | | | | | | | | accepts the Inspector object as the first argument, preceding "table". Code which uses the 0.7 version of this very new event will need modification to add the "inspector" object as the first argument. [ticket:2418]
* | merge patch for [ticket:2208]. This still needs documentation.Mike Bayer2012-04-231-16/+13
|\ \
| * | begin implementing inspection system for #2208Mike Bayer2012-04-031-16/+13
| |/
* | - [bug] If conn.begin() fails when callingMike Bayer2012-04-121-0/+17
| | | | | | | | | | | | "with engine.begin()", the newly acquired Connection is closed explicitly before propagating the exception onward normally.
* | - [feature] Added new connection eventMike Bayer2012-04-101-0/+17
|/ | | | | | | dbapi_error(). Is called for all DBAPI-level errors passing the original DBAPI exception before SQLAlchemy modifies the state of the cursor.
* cleanup test_processors, modeling the PEP 399 stylePhilip Jenvey2012-03-071-72/+25
|
* test failuresMike Bayer2012-02-151-0/+2
|
* - [feature] Added "no_parameters=True" executionMike Bayer2012-02-131-0/+10
| | | | | | | | | | | | | | | | option for connections. If no parameters are present, will pass the statement as cursor.execute(statement), thereby invoking the DBAPIs behavior when no parameter collection is present; for psycopg2 and mysql-python, this means not interpreting % signs in the string. This only occurs with this option, and not just if the param list is blank, as otherwise this would produce inconsistent behavior of SQL expressions that normally escape percent signs (and while compiling, can't know ahead of time if parameters will be present in some cases). [ticket:2407]
* - test failures. one in particular seems to be a weird oursql bug, oh wellMike Bayer2012-02-121-0/+2
|
* - [feature] Added support for the "isolation_level"Mike Bayer2012-02-121-27/+65
| | | | | | | parameter to all MySQL dialects. Thanks to mu_mind for the patch here. [ticket:2394] - add documentation examples for mysql, postgresql - pep8ing
* - [bug] Fixed bug in new "autoload_replace" flagMike Bayer2012-02-121-1/+13
| | | | | | which would fail to preserve the primary key constraint of the reflected table. [ticket:2402]
* - add a context manager availble via Engine.begin()Mike Bayer2012-02-121-0/+134
| | | | | | - add a test suite for all the Engine/Connection/TLEngine transaction/begin helpers/context managers - update docs
* - [feature] Added pool_reset_on_return argumentMike Bayer2012-02-011-3/+24
| | | | | | | | to create_engine, allows control over "connection return" behavior. Also added new arguments 'rollback', 'commit', None to pool.reset_on_return to allow more control over connection return activity. [ticket:2378]
* - [feature] New reflection feature "autoload_replace";Mike Bayer2012-01-281-0/+42
| | | | | | | | | | | | | | | when set to False on Table, the Table can be autoloaded without existing columns being replaced. Allows more flexible chains of Table construction/reflection to be constructed, including that it helps with combining Declarative with table reflection. See the new example on the wiki. [ticket:2356] - [bug] Improved the API for add_column() such that if the same column is added to its own table, an error is not raised and the constraints don't get doubled up. Also helps with some reflection/declarative patterns. [ticket:2356]
* fix a few py3k bugsMike Bayer2012-01-281-1/+1
|
* - [bug] Fixed bug in "mock" strategy wherebyMike Bayer2012-01-281-1/+30
| | | | | | correct DDL visit method wasn't called, resulting in "CREATE/DROP SEQUENCE" statements being duplicated [ticket:2384]
* exception pickling fails on cx_oracleMike Bayer2012-01-221-0/+3
|
* - [bug] Fixed bug whereby a table-bound ColumnMike Bayer2012-01-221-2/+2
| | | | | | | | | | | object named "<a>_<b>" which matched a column labeled as "<tablename>_<colname>" could match inappropriately when targeting in a result set row. [ticket:2377] - requires that we change the tuple format in RowProxy. Makes an improvement to the cases tested against an unpickled RowProxy as well though doesn't solve the problem there entirely.
* - [bug] Improved error messages when a non-stringMike Bayer2012-01-221-0/+107
| | | | | | | | | or invalid string is passed to any of the date/time processors used by SQLite, including C and Python versions. [ticket:2382] - changed the import model of processors.py so that we can get at the pure python versions and C versions simultaneously in tests.
* another serializable for [ticket:2371]Mike Bayer2012-01-121-1/+2
|
* further fixes for column/table errorsMike Bayer2012-01-111-6/+9
|
* some adjustments for py3kMike Bayer2012-01-111-4/+6
|
* fix failures for oursql, python 2.4Mike Bayer2012-01-111-4/+7
|
* - [bug] Added __reduce__ to StatementError,Mike Bayer2012-01-101-0/+37
| | | | | | | DBAPIError so that exceptions are pickleable, as when using multiprocessing. However, not all DBAPIs support this yet, such as psycopg2. [ticket:2371]
* - [bug] the "name" of an FK constraint in SQLiteMike Bayer2012-01-071-2/+10
| | | | | | is reflected as "None", not "0" [ticket:2364]. SQLite does not appear to support constraint naming in any case (the names are ignored).
* - [bug] Decode incoming values when retrievingMike Bayer2011-12-061-36/+97
| | | | | | | list of index names and the names of columns within those indexes. [ticket:2269] - rewrite unicode reflection test to be of more general use on broken backends
* - reflection process always resets the primary key constraintMike Bayer2011-12-041-2/+5
| | | | first, fixes extend_existing
* - [bug] Fixed bug whereby transaction.rollback()Mike Bayer2011-12-041-0/+21
| | | | | | | | | | | would throw an error on an invalidated connection if the transaction were a two-phase or savepoint transaction. For plain transactions, rollback() is a no-op if the connection is invalidated, so while it wasn't 100% clear if it should be a no-op, at least now the interface is consistent. [ticket:2317]
* - [feature] The "extend_existing" flag on TableMike Bayer2011-12-041-1/+40
| | | | | | | | | | | | | now allows for the reflection process to take effect for a Table object that's already been defined; when autoload=True and extend_existing=True are both set, the full set of columns will be reflected from the Table which will then *overwrite* those columns already present, rather than no activity occurring. Columns that are present directly in the autoload run will be used as always, however. [ticket:1410]
* - [bug] Fixed bug whereby "order_by='foreign_key'"Mike Bayer2011-12-011-400/+363
| | | | | | | option to Inspector.get_table_names wasn't implementing the sort properly, replaced with the existing sort algorithm - clean up metadata usage in reflection tests
* - [feature] Added new support for remote "schemas":Mike Bayer2011-10-231-17/+56
| | | | | | | | | | | | | | | | | | | | | | | | - MetaData() accepts "schema" and "quote_schema" arguments, which will be applied to the same-named arguments of a Table or Sequence which leaves these at their default of ``None``. - Sequence accepts "quote_schema" argument - tometadata() for Table will use the "schema" of the incoming MetaData for the new Table if the schema argument is explicitly "None" - Added CreateSchema and DropSchema DDL constructs - these accept just the string name of a schema and a "quote" flag. - When using default "schema" with MetaData, ForeignKey will also assume the "default" schema when locating remote table. This allows the "schema" argument on MetaData to be applied to any set of Table objects that otherwise don't have a "schema". - a "has_schema" method has been implemented on dialect, but only works on Postgresql so far. Courtesy Manlio Perillo, [ticket:1679]
* some mssql stuff, though unicode is really not working still...Mike Bayer2011-10-161-1/+1
|
* fix this test for oursqlMike Bayer2011-10-151-2/+2
|
* - Added an exception catch + warning for theMike Bayer2011-10-151-0/+15
| | | | | | | "return unicode detection" step within connect, allows databases that crash on NVARCHAR to continue initializing, assuming no NVARCHAR type implemented. [ticket:2299]
* - adjust some tests and such to work better with a mysql 5.5 installMike Bayer2011-10-112-2/+6
| | | | | - Added mysql_length parameter to Index construct, specifies "length" for indexes. [ticket:2293]
* ensure sa_pool_key isn't passed to connectMike Bayer2011-09-211-0/+15
|
* - Improvement to multi-param statement logging,Mike Bayer2011-08-221-1/+80
| | | | | | | | long lists of bound parameter sets will be compressed with an informative indicator of the compression taking place. Exception messages use the same improved formatting. [ticket:2243]
* - The recreate() method in all pool classes usesMike Bayer2011-08-141-1/+2
| | | | | | | self.__class__ to get at the type of pool to produce, in the case of subclassing. Note there's no usual need to subclass pools. [ticket:2254]
* - Narrowed the assumption made when reflectingMike Bayer2011-08-091-0/+1
| | | | | | | | | | a foreign-key referenced table with schema in the current search path; an explicit schema will be applied to the referenced table only if it actually matches that of the referencing table, which also has an explicit schema. Previously it was assumed that "current" schema was synonymous with the full search_path. [ticket:2249]
* - Context manager provided by Connection.begin()Mike Bayer2011-07-121-0/+22
| | | | | will issue rollback() if the commit() fails, not just if an exception occurs.
* - fix up the invalidate on connect for py3kMike Bayer2011-07-061-1/+2
| | | | - fix the test for separately installed pysqlite
* - Failures on connect which raise dbapi.ErrorMike Bayer2011-07-011-12/+43
| | | | | | | | | | | | will forward the error to dialect.is_disconnect() and set the "connection_invalidated" flag if the dialect knows this to be a potentially "retryable" condition. Only Oracle ORA-01033 implemented for now. [ticket:2201] - Added ORA-01033 to disconnect codes, which can be caught during a connection event. [ticket:2201]
* - Fixed bug whereby adaptation of old append_ddl_listener()Mike Bayer2011-06-301-0/+57
| | | | | | | function was passing unexpected **kw through to the Table event. Table gets no kws, the MetaData event in 0.6 would get "tables=somecollection", this behavior is preserved. [ticket:2206]
* if python 2.4, have DontWrapException be old styleMike Bayer2011-06-261-1/+0
|
* - Added mixin class sqlalchemy.ext.DontWrapMixin.Mike Bayer2011-06-221-1/+28
| | | | | | | | | | User-defined exceptions of this type are never wrapped in StatementException when they occur in the context of a statement execution. - StatementException wrapping will display the original exception class in the message.
* ARGMike Bayer2011-06-021-1/+3
|
* - adjust further for unix-style casing, also this is mysql not just mysqldbMike Bayer2011-06-021-1/+2
|
* - Unit tests pass 100% on MySQL installedMike Bayer2011-06-022-10/+53
| | | | | | | | | | | | | | | | | | | | | | | | | | on windows, after aggressive exclusion of a wide variety of tests. Not clear to what degree the failures are related to version 5.5 vs. the usage of windows, in particular the ON UPDATE CASCADE immediately crashes the server. The features being tested here are all edge cases not likely to be used in typical MySQL environments. - Removed the "adjust casing" step that would fail when reflecting a table on MySQL on windows with a mixed case name. After some experimenting with a windows MySQL server, it's been determined that this step wasn't really helping the situation much; MySQL does not return FK names with proper casing on non-windows platforms either, and removing the step at least allows the reflection to act more like it does on other OSes. A warning here has been considered but its difficult to determine under what conditions such a warning can be raised, so punted on that for now - added some docs instead. [ticket:2181] - supports_sane_rowcount will be set to False if using MySQLdb and the DBAPI doesn't provide the constants.CLIENT module.
* - Fixed bug whereby metadata.reflect(bind)Mike Bayer2011-06-011-0/+12
| | | | | would close a Connection passed as a bind argument. Regression from 0.6.
* - make sure we definitely get every connection createdMike Bayer2011-05-141-0/+1
| | | | | - ensure we lose self.conns, cx_oracle only closes on __del__ - fix reconnectingfixture to lose all connection references