summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases
Commit message (Collapse)AuthorAgeFilesLines
...
* - Simplified the check for ResultProxy "autoclose without results"Mike Bayer2008-11-046-99/+7
| | | | | | to be based solely on presence of cursor.description. All the regexp-based guessing about statements returning rows has been removed [ticket:1212].
* - added 'EXPLAIN' to the list of 'returns rows', but thisMike Bayer2008-11-041-1/+1
| | | | issue will be addressed more fully by [ticket:1212].
* Accept USING as a prefix or postfix modifer when reflecting keys. [ticket:1117]Jason Kirtland2008-10-281-1/+2
|
* Mysql no longer expects include_columns to be specified in lowercase. Fixes ↵Michael Trier2008-10-281-1/+1
| | | | #1206.
* Fixed mysql FK reflection for the edge case where a Table has expicitly ↵Jason Kirtland2008-10-271-0/+9
| | | | provided a schema= that matches the connection's default schema.
* auto_convert_lobs=False honored by OracleBinary, OracleText typesMike Bayer2008-10-241-4/+5
| | | | [ticket:1178]
* - fixed some oracle unit tests in test/sql/Mike Bayer2008-10-241-2/+115
| | | | | - wrote a docstring for oracle dialect, needs formatting perhaps - made FIRST_ROWS optimization optional based on optimize_limits=True, [ticket:536]
* Corrected case in mssql where binary expression has bind parameters on both ↵Michael Trier2008-10-231-1/+2
| | | | sides.
* Modifications to allow the backends to control the behavior of an empty ↵Michael Trier2008-10-203-19/+6
| | | | insert. If supports_empty_insert is True then the backend specifically supports the 'insert into t1 () values ()' syntax. If supports_default_values is True then the backend supports the 'insert into t1 default values' syntax. If both are false then the backend has no support for empty inserts at all and an exception gets raised. Changes here are careful to not change current behavior except where the current behavior was failing to begin with.
* Cleaned up the create_connect_args so that it makes no expectations about ↵Michael Trier2008-10-191-8/+40
| | | | keys. Fixes 1193. Added server version info into mssql pyodbc dialect.
* - 0.5.0rc3, dohMike Bayer2008-10-184-39/+3
| | | | | | | | | | | | - The internal notion of an "OID" or "ROWID" column has been removed. It's basically not used by any dialect, and the possibility of its usage with psycopg2's cursor.lastrowid is basically gone now that INSERT..RETURNING is available. - Removed "default_order_by()" method on all FromClause objects. - profile/compile/select test is 8 function calls over on buildbot 2.4 for some reason, will adjust after checking the results of this commit
* - "not equals" comparisons of simple many-to-one relationMike Bayer2008-10-183-5/+5
| | | | | | | | | | | | | | | to an instance will not drop into an EXISTS clause and will compare foreign key columns instead. - removed not-really-working use cases of comparing a collection to an iterable. Use contains() to test for collection membership. - Further simplified SELECT compilation and its relationship to result row processing. - Direct execution of a union() construct will properly set up result-row processing. [ticket:1194]
* - String's (and Unicode's, UnicodeText's, etc.) convert_unicoderel_0_5rc2Mike Bayer2008-10-121-3/+31
| | | | | | | logic disabled in the sqlite dialect, to adjust for pysqlite 2.5.0's new requirement that only Python unicode objects are accepted; http://itsystementwicklung.de/pipermail/list-pysqlite/2008-March/000018.html
* Removed the visit_function stuff in mssql dialect. Added some tests for the ↵Michael Trier2008-10-111-10/+4
| | | | function overrides. Fixed up the test_select in the sql/defaults.py tests which was a mess.
* Correction of mssql schema reflection in reflectable. Still a problem since ↵Michael Trier2008-10-111-2/+6
| | | | the assumed default is dbo, whereas it could be modified by the connection. Allows SchemaTest.test_select to pass now.
* - Oracle will detect string-based statements which containMike Bayer2008-10-071-0/+5
| | | | | comments at the front before a SELECT as SELECT statements. [ticket:1187]
* Fixed mysql TEMPORARY table reflection.Jason Kirtland2008-09-271-1/+1
|
* genericized the relationship between bind_processor() and _bind_processor() ↵Mike Bayer2008-09-191-9/+22
| | | | a little more
* - Overhauled SQLite date/time bind/result processingMike Bayer2008-09-191-42/+34
| | | | | | to use regular expressions and format strings, rather than strptime/strftime, to generically support pre-1900 dates, dates with microseconds. [ticket:968]
* - the function func.utc_timestamp() compiles to UTC_TIMESTAMP, withoutMike Bayer2008-09-101-1/+2
| | | | | the parenthesis, which seem to get in the way when using in conjunction with executemany().
* Fix bug with MSSQL reflecting and schemasPaul Johnston2008-09-091-6/+1
|
* added BFILE to reflected type names [ticket:1121]Mike Bayer2008-09-031-0/+1
|
* - has_sequence() now takes the current "schema" argument intoMike Bayer2008-09-031-4/+6
| | | | account [ticket:1155]
* - limit/offset no longer uses ROW NUMBER OVER to limit rows,Mike Bayer2008-09-031-15/+43
| | | | | | and instead uses subqueries in conjunction with a special Oracle optimization comment. Allows LIMIT/OFFSET to work in conjunction with DISTINCT. [ticket:536]
* - Added MSMediumInteger type [ticket:1146].Mike Bayer2008-08-241-2/+29
|
* - logging scale-back; the echo_uow flag on Session is deprecated, and unit ↵Mike Bayer2008-08-242-3/+1
| | | | | | | | | | | | of work logging is now class level like all the other logging. - trimmed back the logging API, centralized class_logger() as the single point of configuration for logging, removed per-instance logging checks from ORM. - Engine and Pool logging remain at the instance level. The modulus of "instance ids" has been upped to 65535. I'd like to remove the modulus altogether but I do see a couple of users each month calling create_engine() on a per-request basis, an incorrect practice but I'd rather their applications don't just run out of memory.
* - The 'length' argument to all Numeric types has been renamedMike Bayer2008-08-2410-86/+91
| | | | | | | | | | | | | | | | to 'scale'. 'length' is deprecated and is still accepted with a warning. [ticket:827] - The 'length' argument to MSInteger, MSBigInteger, MSTinyInteger, MSSmallInteger and MSYear has been renamed to 'display_width'. [ticket:827] - mysql._Numeric now consumes 'unsigned' and 'zerofill' from the given kw, so that the same kw can be passed along to Numeric and allow the 'length' deprecation logic to still take effect - added testlib.engines.all_dialects() to return a dialect for every db module - informix added to sqlalchemy.databases.__all__. Since other "experimental" dbs like access and sybase are there, informix should be as well.
* - Temporarily rolled back the "ORDER BY" enhancementMike Bayer2008-08-067-9/+2
| | | | | from [ticket:1068]. This feature is on hold pending further development.
* - compiler visit_label() checks a flag "within_order_by" and will render its ↵Mike Bayer2008-08-038-4/+12
| | | | | | | | | | | | | | | | | | | own name and not its contained expression, if the dialect reports true for supports_simple_order_by_label. the flag is not propagated forwards, meant to closely mimic the syntax Postgres expects which is that only a simple name can be in the ORDER BY, not a more complex expression or function call with the label name embedded (mysql and sqlite support more complex expressions). This further sets the standard for propigation of **kwargs within compiler, that we can't just send **kwargs along blindly to each XXX.process() call; whenever a **kwarg needs to propagate through, most methods will have to be aware of it and know when they should send it on forward and when not. This was actually already the case with result_map as well. The supports_simple_order_by dialect flag defaults to True but is conservatively explicitly set to False on all dialects except SQLite/MySQL/Postgres to start. [ticket:1068]
* Corrects reflecttable in firebird database. Closes #1119.Michael Trier2008-07-291-1/+1
|
* Raised an error when sqlite version does not support default values. ↵Michael Trier2008-07-291-2/+8
| | | | Addresses #909 in a purposeful way.
* Corrected problem with detecting closed connections. Fixed issues in ↵Michael Trier2008-07-231-3/+8
| | | | reflecttable for reflecting the mssql tables. Removed unicode reflection test from mssql. Need to investigate this further.
* - mysql.MSEnum value literals now automatically quoted when used in a CREATE.Jason Kirtland2008-07-161-18/+59
| | | | | The change is backward compatible. Slight expansion of patch from catlee. Thanks! [ticket:1110]
* Removed deprecated get_version_info, use server_version_infoJason Kirtland2008-07-161-13/+0
|
* - Removed 2.3 Decimal compatJason Kirtland2008-07-154-7/+7
|
* - Removed 2.3 set emulations/enhancements.Jason Kirtland2008-07-156-19/+19
| | | | (sets.Set-based collections & DB-API returns still work.)
* Fix reflection where the table name has a duplicate name in a different schemaPaul Johnston2008-07-151-1/+2
|
* Fixed messed up __init__ in MSSmallDate. Fixes #1040.Michael Trier2008-07-131-1/+1
|
* Added new basic match() operator that performs a full-text search. Supported ↵Michael Trier2008-07-134-3/+10
| | | | on PostgreSQL, SQLite, MySQL, MS-SQL, and Oracle backends.
* - SQLite Date, DateTime, and Time types only accept PythonMike Bayer2008-07-091-4/+3
| | | | | | | | datetime objects now, not strings. If you'd like to format dates as strings yourself with SQLite, use a String type. If you'd like them to return datetime objects anyway despite their accepting strings as input, make a TypeDecorator around String - SQLA doesn't encourage this pattern.
* - re-fixed the fix to the prefixes fixMike Bayer2008-07-0610-96/+11
| | | | | - removed ancient descriptor() functions from dialects; replaced with Dialect.name - removed similarly ancient sys.modules silliness in Engine.name
* Added PGCidr type to postgres. Closes #1092Michael Trier2008-07-031-0/+5
| | | | (cherry picked from commit 2394a6bb6c5f77afd448640ce03cf6fda0335a23)
* merge r4889, SQLite Float type, from 0.4 branchMike Bayer2008-07-021-1/+14
|
* - Modified SQLite's representation of "microseconds" toMike Bayer2008-06-271-3/+10
| | | | | | | | | | | match the output of str(somedatetime), i.e. in that the microseconds are represented as fractional seconds in string format. [ticket:1090] - implemented a __legacy_microseconds__ flag on DateTimeMixin which can be used per-class or per-type instances to get the old behavior, for compatibility with existing SQLite databases encoded by a previous version of SQLAlchemy. - will implement the reverse legacy behavior in 0.4.
* merged r4870 from 0.4 branch, index name truncation, [ticket:820]Mike Bayer2008-06-225-5/+6
|
* merged r4857, postgres server_side_cursors fix, from 0.4 branchMike Bayer2008-06-171-1/+4
|
* restored a "distinct" setting that got whackedMike Bayer2008-06-091-1/+1
|
* merged merge fix from r4834/rel_0_4 branchMike Bayer2008-06-031-1/+1
|
* merged [ticket:1062] fix from 0.4 branch r4827Mike Bayer2008-05-301-1/+8
|
* - added "CALL" to Mysql select keywordsMike Bayer2008-05-271-1/+1
| | | | - NameError doesn't have "message" in py2.4
View Lorry Controller Status