summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/mysql.py
Commit message (Collapse)AuthorAgeFilesLines
* merge 0.6 series to trunk.Mike Bayer2009-08-061-2732/+0
|
* - Reflecting a FOREIGN KEY construct will take into accountMike Bayer2009-05-171-1/+1
| | | | | a dotted schema.tablename combination, if the foreign key references a table in a remote schema. [ticket:1405]
* extract() is now dialect-sensitive and supports SQLite and others.Jason Kirtland2009-03-301-0/+4
|
* happy new yearMike Bayer2009-01-121-1/+1
|
* Added the missing keywords from MySQL 4.1 so they get escaped properly.Ants Aasma2009-01-081-1/+1
|
* assume table.schema, not None, when constraint reflection has no explicit ↵Mike Bayer2009-01-051-1/+1
| | | | schema. unit test TBD.
* - mysql, postgres: "%" signs in text() constructs are automatically escaped ↵Mike Bayer2009-01-021-0/+5
| | | | | | | to "%%". Because of the backwards incompatible nature of this change, a warning is emitted if '%%' is detected in the string. [ticket:1267]
* - Reflected foreign keys will properly locateMike Bayer2008-12-261-10/+6
| | | | | | | | | | | | | | | | | | | | | | | their referenced column, even if the column was given a "key" attribute different from the reflected name. This is achieved via a new flag on ForeignKey/ForeignKeyConstraint called "link_to_name", if True means the given name is the referred-to column's name, not its assigned key. [ticket:650] - removed column types from sqlite doc, we aren't going to list out "implementation" types since they aren't significant and are less present in 0.6 - mysql will report on missing reflected foreign key targets in the same way as other dialects (we can improve that to be immediate within reflecttable(), but it should be within ForeignKeyConstraint()). - postgres dialect can reflect table with an include_columns list that doesn't include one or more primary key columns
* - Fixed mysql bug in exception raise when FK columns not presentMike Bayer2008-12-211-1/+1
| | | | during reflection. [ticket:1241]
* removed the "create_execution_context()" method from dialects and replacedMike Bayer2008-12-191-3/+1
| | | | with a more succinct "dialect.execution_ctx_cls" member
* merged -r5299:5438 of py3k warnings branch. this fixes some sqlite py2.6 ↵Mike Bayer2008-12-181-3/+3
| | | | | | | | testing issues, and also addresses a significant chunk of py3k deprecations. It's mainly expicit __hash__ methods. Additionally, most usage of sets/dicts to store columns uses util-based placeholder names.
* - _execute_clauseelement() goes back to beingMike Bayer2008-12-171-5/+2
| | | | | | | | | | | | | | | | a private method. Subclassing Connection is not needed now that ConnectionProxy is available. - tightened the interface for the various _execute_XXX() methods to reduce ambiguity - __distill_params() no longer creates artificial [{}] entry, blank dict is no longer passed through to do_execute() in any case unless explicitly sent from the outside as in connection.execute("somestring"), {}) - fixed a few old sql.query tests which were doing that - removed needless do_execute() from mysql dialect - fixed charset param not properly being sent to _compat_fetchone() in mysql
* - 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.
* - Simplified the check for ResultProxy "autoclose without results"Mike Bayer2008-11-041-6/+0
| | | | | | 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.
* Fixed mysql TEMPORARY table reflection.Jason Kirtland2008-09-271-1/+1
|
* - 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().
* - 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-241-1/+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-241-70/+74
| | | | | | | | | | | | | | | | 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.
* - 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-151-2/+2
|
* - Removed 2.3 set emulations/enhancements.Jason Kirtland2008-07-151-11/+11
| | | | (sets.Set-based collections & DB-API returns still work.)
* Added new basic match() operator that performs a full-text search. Supported ↵Michael Trier2008-07-131-1/+2
| | | | on PostgreSQL, SQLite, MySQL, MS-SQL, and Oracle backends.
* - re-fixed the fix to the prefixes fixMike Bayer2008-07-061-11/+1
| | | | | - removed ancient descriptor() functions from dialects; replaced with Dialect.name - removed similarly ancient sys.modules silliness in Engine.name
* merged r4870 from 0.4 branch, index name truncation, [ticket:820]Mike Bayer2008-06-221-1/+1
|
* - added "CALL" to Mysql select keywordsMike Bayer2008-05-271-1/+1
| | | | - NameError doesn't have "message" in py2.4
* Columns now have default= and server_default=. PassiveDefault fades away.Jason Kirtland2008-05-141-6/+5
|
* MSText no longer implicitly creates TEXT for string with no lengthMike Bayer2008-05-091-1/+1
| | | | (this actually allows CAST (foo, VARCHAR) to render too)
* r4695 merged to trunk; trunk now becomes 0.5.Mike Bayer2008-05-091-14/+13
| | | | 0.4 development continues at /sqlalchemy/branches/rel_0_4
* refactor of default_paramstyle, use paramstyle argument on Dialect to changeMatt Harrison2008-04-071-1/+1
|
* - Revamped the Connection memoize decorator a bit, moved to engineJason Kirtland2008-04-021-49/+53
| | | | | - MySQL character set caching is more aggressive but will invalidate the cache if a SET is issued. - MySQL connection memos are namespaced: info[('mysql', 'server_variable')]
* - reverted previous "strings instead of tuples" change due to more specific ↵Mike Bayer2008-03-301-7/+4
| | | | | | test results showing tuples faster - changed cache decorator call on default_schema_name call to a connection.info specific one
* *whistle*Jason Kirtland2008-03-301-1/+0
|
* - Removed cache decorator.Jason Kirtland2008-03-301-2/+7
|
* some cache decorator calls...Mike Bayer2008-03-301-7/+3
|
* - Added PendingDeprecationWarning supportJason Kirtland2008-03-291-1/+1
| | | | - Deprecation decorator is now a real decorator
* - Added generic func.random (non-standard SQL)Jason Kirtland2008-03-251-0/+6
|
* - Autodetect mysql's ANSI_QUOTES mode, sometimes. [ticket:845]Jason Kirtland2008-02-051-8/+67
| | | | | | | The dialect needs a hook run on first pool connect to detect this most of the time, and a refactor with Dialect-per-Connection to get it right all of the time. (It's a connection-session scoped setting with dialect-modifying behavior)
* - 2.3 fixup part three: 100% on postgres, mysqlJason Kirtland2008-01-221-1/+1
|
* - Warnings are now issued as SAWarning instead of RuntimeWarning; ↵Jason Kirtland2008-01-111-13/+8
| | | | | | util.warn() wraps this up. - SADeprecationWarning has moved to exceptions. An alias remains in logging until 0.5.
* Include column name in length-less String warning (more [ticket:912])Jason Kirtland2008-01-101-1/+2
|
* redid the _for_ddl String/Text deprecation warning correctly [ticket:912]Mike Bayer2008-01-091-1/+1
|
* Fixed reflection of mysql empty string column defaults.Jason Kirtland2008-01-081-1/+1
|
* - changed name of TEXT to Text since its a "generic" type; TEXT name isMike Bayer2008-01-051-3/+3
| | | | | | | deprecated until 0.5. The "upgrading" behavior of String to Text when no length is present is also deprecated until 0.5; will issue a warning when used for CREATE TABLE statements (String with no length for SQL expression purposes is still fine) [ticket:912]
* Added REPLACE statements to mysql autocommit list.Jason Kirtland2008-01-041-1/+1
|
View Lorry Controller Status