summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases
Commit message (Collapse)AuthorAgeFilesLines
...
* - auto-reconnect support improved; a Connection can now automaticallyMike Bayer2007-12-192-2/+9
| | | | | | | | | | reconnect after its underlying connection is invalidated, without needing to connect() again from the engine. This allows an ORM session bound to a single Connection to not need a reconnect. Open transactions on the Connection must be rolled back after an invalidation of the underlying connection else an error is raised. Also fixed bug where disconnect detect was not being called for cursor(), rollback(), or commit().
* - cleanup; lambdas removed from properties; properties mirror same-named ↵Mike Bayer2007-12-181-1/+1
| | | | | | functions (more like eventual decorator syntax); remove some old methods, factor out some "raiseerr" ugliness to outer lying functions. - corresponding_column() integrates "require_embedded" flag with other set arithmetic
* Revert to use default poolclass under FirebirdLele Gaifax2007-12-151-2/+20
| | | | | | | This partially reverts [3562] and instead documents the problem suggesting a possible workaround. For the tests, the occurence of the problem is largely reduced by using a TCP connection (that is, 'localhost:/some/file.fdb' instead of '/some/file.fdb')
* Remove some spurious spacesLele Gaifax2007-12-151-3/+7
|
* Implemented FBDialect.server_version_info()Lele Gaifax2007-12-151-5/+34
|
* Firebird module documentationLele Gaifax2007-12-141-12/+125
|
* Use the external strlen UDF for func.length() under FirebirdLele Gaifax2007-12-131-0/+6
|
* Use an external UDF to implement the mod operator under FirebirdLele Gaifax2007-12-121-1/+8
|
* Some code-level docs for r3916Jason Kirtland2007-12-121-0/+5
|
* - on mysql, emit inner joins as 'INNER JOIN ... ON' (for version 3.23)Jason Kirtland2007-12-121-0/+8
|
* Reflect Firebird PassiveDefaultsLele Gaifax2007-12-121-11/+32
| | | | | | - column's default values are properly reflected (also those coming from DOMAINs) - implemented .has_sequence() - fix type on FK reflection
* Cosmetic changes to the Firebird reflection queries.Lele Gaifax2007-12-111-59/+63
| | | | | This brings them more consistent with the syntax of the statements generated by SA, using lowercase field names.
* Better reflection of Firebird data types.Lele Gaifax2007-12-091-19/+23
| | | | | Instead of relying on internal numeric code, lookup the associated real name. This has the extra benefit of properly handling of DOMAINs.
* - basic framework for generic functions, [ticket:615]Mike Bayer2007-12-051-3/+3
| | | | | | | - changed the various "literal" generation functions to use an anonymous bind parameter. not much changes here except their labels now look like ":param_1", ":param_2" instead of ":literal" - from_obj keyword argument to select() can be a scalar or a list.
* default value of assert_unicode is None on String, False on create_engine(), ↵Mike Bayer2007-11-281-2/+2
| | | | and True on Unicode type.
* un-screw up the attribute manager checkinMike Bayer2007-11-271-30/+2
|
* fixed reflection of unicode, [ticket:881]Mike Bayer2007-11-271-6/+9
|
* AttributeManager class and "cached" state removed....attribute listingMike Bayer2007-11-271-2/+30
| | | | is tracked from _sa_attrs class collection
* Fix: MSSQL set identity_insert and errors [ticket:538]Paul Johnston2007-11-251-17/+23
|
* Fix: test_decimal on MSSQL - use a value that is accurately represented as a ↵Paul Johnston2007-11-251-1/+12
| | | | float, and make when asdecimal=False, convert Decimal to float
* Fix: MSSQL concatenate operator is + not || [ticket:879]Paul Johnston2007-11-251-1/+4
|
* Avoid doubling quoting of identifier in MSSQL reflectionPaul Johnston2007-11-251-1/+1
|
* Make function a reserved word in MSSQLPaul Johnston2007-11-251-5/+5
|
* MSSQL/PyODBC no longer has a global set nocount onPaul Johnston2007-11-251-10/+3
|
* Change to make PyODBC result fetching a bit more reliablePaul Johnston2007-11-251-8/+8
|
* column.foreign_key -> foreign_keys in MSSQLPaul Johnston2007-11-251-2/+2
|
* - named_with_column becomes an attributeMike Bayer2007-11-257-45/+29
| | | | | | | | | - cleanup within compiler visit_select(), column labeling - is_select() removed from dialects, replaced with returns_rows_text(), returns_rows_compiled() - should_autocommit() removed from dialects, replaced with should_autocommit_text() and should_autocommit_compiled() - typemap and column_labels collections removed from Compiler, replaced with single "result_map" collection. - ResultProxy uses more succinct logic in combination with result_map to target columns
* - all kinds of cleanup, tiny-to-slightly-significant speed improvementsMike Bayer2007-11-243-30/+21
|
* - MSSQL anonymous labels for selection of functions made deterministicMike Bayer2007-11-181-6/+6
| | | | - propagate correct **kwargs through mssql methods
* repaired FB functions, [ticket:862]Mike Bayer2007-11-181-3/+3
|
* Tests for mysql casts and a couple adjustments.Jason Kirtland2007-11-181-6/+6
|
* Migrated Connection.properties to Connection.info ('info' is the new ↵Jason Kirtland2007-11-181-8/+8
| | | | standard name for user-writable property collections that came out of [ticket:573]). 'properties' is now an alias, will be removed in 0.5.
* - oracle will now reflect "DATE" as an OracleDateTime column, notMike Bayer2007-11-181-3/+16
| | | | | | | OracleDate - added awareness of schema name in oracle table_names() function, fixes metadata.reflect(schema='someschema') [ticket:847]
* More column type __repr__ corrections.Jason Kirtland2007-11-131-1/+1
|
* - anonymous column expressions are automatically labeled.Mike Bayer2007-11-103-3/+4
| | | | | | | | | | | | | | | | | | | e.g. select([x* 5]) produces "SELECT x * 5 AS anon_1". This allows the labelname to be present in the cursor.description which can then be appropriately matched to result-column processing rules. (we can't reliably use positional tracking for result-column matches since text() expressions may represent multiple columns). - operator overloading is now controlled by TypeEngine objects - the one built-in operator overload so far is String types overloading '+' to be the string concatenation operator. User-defined types can also define their own operator overloading by overriding the adapt_operator(self, op) method. - untyped bind parameters on the right side of a binary expression will be assigned the type of the left side of the operation, to better enable the appropriate bind parameter processing to take effect [ticket:819]
* - mysql float types now do an end run around the base class and respect ↵Jason Kirtland2007-11-091-14/+86
| | | | | | | precision=None and length=None - Added the mysteriously missing mysql cast support - Added mysql REAL synonym for schema generation
* - figured out a way to get previous oracle behavior back. the ROWID thingMike Bayer2007-11-051-1/+1
| | | | is still a pretty thorny issue.
* - adjustments to oracle ROWID logic...recent oid changes mean we have toMike Bayer2007-11-051-5/+8
| | | | | | use "rowid" against the select itself (i.e. its just...'rowid', no table name). seems to work OK but not sure if issues will arise - fixes to oracle bind param stuff to account for recent removal of ClauseParameters object.
* Whitespace cleanupJason Kirtland2007-11-051-81/+80
|
* - SHOW CREATE TABLE output is slightly different if msyql is in ANSI modeJason Kirtland2007-11-051-7/+11
|
* - rewritten ClauseAdapter merged from the eager_minus_join branch; this is a ↵Mike Bayer2007-11-031-1/+0
| | | | | | | | much simpler and "correct" version which will copy all elements exactly once, except for those which were replaced with target elements. It also can match a wider variety of target elements including joins and selects on identity alone.
* Added some more notes for maxdbJason Kirtland2007-11-031-58/+66
|
* added REAL to reflection listMike Bayer2007-10-311-0/+1
|
* Fixup sp_columns callPaul Johnston2007-10-311-1/+1
|
* - Refinements for maxdb's handling of SERIAL and FIXED columnsJason Kirtland2007-10-311-18/+38
| | | | - Expanded maxdb's set of paren-less functions
* - merged path_based_options branchMike Bayer2007-10-281-9/+0
| | | | | | | | - behavior of query.options() is now fully based on paths, i.e. an option such as eagerload_all('x.y.z.y.x') will apply eagerloading to only those paths, i.e. and not 'x.y.x'; eagerload('children.children') applies only to exactly two-levels deep, etc. [ticket:777] - removes old compiler()/schemagenerator()/schemadropper() methods from mysql dialect
* - inlined a couple of context variablesMike Bayer2007-10-271-3/+3
| | | | - PG two phase was calling text() without the correct bind param format, previous compiler checkin revealed issue
* - removed regular expression step from most statement compilations.Mike Bayer2007-10-271-14/+18
| | | | | | also fixes [ticket:833] - inlining on PG with_returning() call - extra options added for profiling
* Make access dao detecting more reliable #828Paul Johnston2007-10-261-3/+9
|
* - Added initial version of MaxDB dialect.Jason Kirtland2007-10-232-2/+1087
| | | | - All optional test Sequences are now optional=True