summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases
Commit message (Collapse)AuthorAgeFilesLines
...
* - merged -r5338:5429 of sphinx branch.Mike Bayer2008-12-061-411/+385
| | | | | | | | | | | | | - Documentation has been converted to Sphinx. In particular, the generated API documentation has been constructed into a full blown "API Reference" section which organizes editorial documentation combined with generated docstrings. Cross linking between sections and API docs are vastly improved, a javascript-powered search feature is provided, and a full index of all classes, functions and members is provided.
* - Adjusted the format of create_xid() to repairMike Bayer2008-12-051-2/+2
| | | | | | two-phase commit. We now have field reports of Oracle two-phase commit working properly with this change.
* - bump, this may become 0.5.0Mike Bayer2008-11-141-1/+2
| | | | | - Calling alias.execute() in conjunction with server_side_cursors won't raise AttributeError.
* Pulled out values test that uses boolean evaluation in the SELECT in order ↵Michael Trier2008-11-141-3/+4
| | | | to appropriately flag it as not supported on mssql. I sure hope I didn't jack things up for other dialects. Cleaned up a comment and removed some commented pdb statements.
* Fixed a problem with the casting of a zero length type to a varchar. It now ↵Michael Trier2008-11-141-1/+1
| | | | correctly adjusts the CAST accordingly.
* The str(query) output is also correct on the mssql dialect.Michael Trier2008-11-141-1/+2
|
* Corrected mssql schema named subqueries from not properly aliasing the ↵Michael Trier2008-11-121-3/+4
| | | | columns. Fixes #973.
* Handle the mssql port properly. If we're using the SQL Server driver then ↵Michael Trier2008-11-101-3/+9
| | | | use the correct host,port syntax, otherwise use the Port= parameter in the connection string. Fixes #1192.
* Corrected issue with decimal e notation that broke regular decimal tests for ↵Michael Trier2008-11-101-1/+1
| | | | mssql.
* If there's a zero offset with mssql just ignore it.Michael Trier2008-11-101-1/+1
|
* Corrected problem in access dialect that was still referring to the old ↵Michael Trier2008-11-101-2/+2
| | | | column.foreign_key property.
* flattened _get_from_objects() into a descriptor/class-bound attributeMike Bayer2008-11-092-5/+4
|
* Corrected problems with Access dialect. Corrected issue with reflection due ↵Michael Trier2008-11-091-1/+6
| | | | to missing Currency type. Functions didn't return the value. JOINS must be specified as LEFT OUTER JOIN or INNER JOIN. Fixes #1017.
* Corrected problems with reflection on mssql when dealing with schemas. Fixes ↵Michael Trier2008-11-091-4/+4
| | | | #1217.
* Fixed E notation problem in mssql. Closes #1216.Michael Trier2008-11-081-1/+8
|
* Corrected a lot of mssql limit / offset issues. Also ensured that mssql uses ↵Michael Trier2008-11-081-13/+20
| | | | the IN / NOT IN syntax when using a binary expression with a subquery.
* docstring fixMike Bayer2008-11-071-1/+1
|
* - 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]
View Lorry Controller Status