summaryrefslogtreecommitdiff
path: root/test/dialect/mysql.py
Commit message (Collapse)AuthorAgeFilesLines
* - unit tests have been migrated from unittest to nose.Mike Bayer2009-06-101-1167/+0
| | | | | See README.unittests for information on how to run the tests. [ticket:970]
* extract() is now dialect-sensitive and supports SQLite and others.Jason Kirtland2009-03-301-0/+13
|
* Accept USING as a prefix or postfix modifer when reflecting keys. [ticket:1117]Jason Kirtland2008-10-281-24/+73
|
* Mysql no longer expects include_columns to be specified in lowercase. Fixes ↵Michael Trier2008-10-281-0/+23
| | | | #1206.
* - the function func.utc_timestamp() compiles to UTC_TIMESTAMP, withoutMike Bayer2008-09-101-0/+3
| | | | | the parenthesis, which seem to get in the way when using in conjunction with executemany().
* - Added MSMediumInteger type [ticket:1146].Mike Bayer2008-08-241-0/+15
|
* - The 'length' argument to all Numeric types has been renamedMike Bayer2008-08-241-1/+1
| | | | | | | | | | | | | | | | 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-16/+33
| | | | | The change is backward compatible. Slight expansion of patch from catlee. Thanks! [ticket:1110]
* Added new basic match() operator that performs a full-text search. Supported ↵Michael Trier2008-07-131-0/+71
| | | | on PostgreSQL, SQLite, MySQL, MS-SQL, and Oracle backends.
* Columns now have default= and server_default=. PassiveDefault fades away.Jason Kirtland2008-05-141-21/+21
|
* Test suite modernization in progress. Big changes:Jason Kirtland2008-05-091-5/+5
| | | | | | | | | | | - @unsupported now only accepts a single target and demands a reason for not running the test. - @exclude also demands an exclusion reason - Greatly expanded @testing.requires.<feature>, eliminating many decorators in the suite and signficantly easing integration of multi-driver support. - New ORM test base class, and a featureful base for mapped tests - Usage of 'global' for shared setup going away, * imports as well
* MSText no longer implicitly creates TEXT for string with no lengthMike Bayer2008-05-091-3/+1
| | | | (this actually allows CAST (foo, VARCHAR) to render too)
* r4695 merged to trunk; trunk now becomes 0.5.Mike Bayer2008-05-091-3/+3
| | | | 0.4 development continues at /sqlalchemy/branches/rel_0_4
* - Revamped the Connection memoize decorator a bit, moved to engineJason Kirtland2008-04-021-0/+43
| | | | | - 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')]
* - updated the naming scheme of the base test classes in test/testlib/testing.py;Mike Bayer2008-02-111-2/+2
| | | | | tests extend from either TestBase or ORMTest, using additional mixins for special assertion methods as needed
* - testbase is gone, replaced by testenvJason Kirtland2008-01-121-31/+31
| | | | | | - Importing testenv has no side effects- explicit functions provide similar behavior to the old immediate behavior of testbase - testing.db has the configured db - Fixed up the perf/* scripts
* - Undeclared SAWarnings are now fatal to tests as well.Jason Kirtland2008-01-121-8/+3
| | | | - Fixed typo that was killing runs of individual named tests.
* Added UnicodeText aliasJason Kirtland2008-01-091-2/+14
|
* Fixed reflection of mysql empty string column defaults.Jason Kirtland2008-01-081-1/+19
|
* - Removed @testing.supported. Dialects in development or maintained outsideJason Kirtland2007-12-131-19/+6
| | | | | | | | | | | the tree can now run the full suite of tests out of the box. - Migrated most @supported to @fails_on, @fails_on_everything_but, or (last resort) @unsupported. @fails_on revealed a slew of bogus test skippage, which was corrected. - Added @fails_on_everything_but. Yes, the first usage *was* "fails_on_everything_but('postgres')". How did you guess! - Migrated @supported in dialect/* to the new test-class attribute __only_on__. - Test classes can also have __unsupported_on__ and __excluded_on__.
* Tests for mysql casts and a couple adjustments.Jason Kirtland2007-11-181-0/+93
|
* - mysql float types now do an end run around the base class and respect ↵Jason Kirtland2007-11-091-19/+26
| | | | | | | precision=None and length=None - Added the mysteriously missing mysql cast support - Added mysql REAL synonym for schema generation
* - Added support for UPDATE with LIMIT on mysql.Jason Kirtland2007-10-161-0/+31
| | | | - Added mysql dialect tests for SET columns and the in_ operator.
* Changed MySQL dialect to use the older LIMIT <offset>, <limit> syntax insteadJason Kirtland2007-09-261-2/+22
| | | | | of LIMIT <l> OFFSET <o> for folks using 3.23. ([ticket:794], thanks for the patch!)
* Fixed repr() of mysql floats [ticket:775]Jason Kirtland2007-09-071-0/+14
| | | | Added repr testing to mysql dialect
* mysql SETs and ENUMs now unescape embedded quotes before storage in .enums ↵Jason Kirtland2007-09-061-6/+6
| | | | and .values. An ancient bug.
* Fixed reflection of the empty string for mysql enums.Jason Kirtland2007-09-051-0/+25
|
* - Restored reflection for mysql VIEWs [ticket:748]Jason Kirtland2007-08-281-10/+28
| | | | | | | | | - Fixed anonymous pk reflection for mysql 5.1 - Tested table and view reflection against the 'sakila' database from MySQL AB on 3.23 - 6.0. (with some schema adjustments, obviously) Maybe this will go into the SA test suite someday. - Tweaked mysql server version tuplification, now also splitting on hyphens - Light janitorial
* fixed importsMike Bayer2007-08-211-0/+1
|
* fixed "SmallInteger"Mike Bayer2007-08-211-2/+2
|
* 1. Module layout. sql.py and related move into a package called "sql".Mike Bayer2007-08-181-3/+3
| | | | | | | | | | | | 2. compiler names changed to be less verbose, unused classes removed. 3. Methods on Dialect which return compilers, schema generators, identifier preparers have changed to direct class references, typically on the Dialect class itself or optionally as attributes on an individual Dialect instance if conditional behavior is needed. This takes away the need for Dialect subclasses to know how to instantiate these objects, and also reduces method overhead by one call for each one. 4. as a result of 3., some internal signatures have changed for things like compiler() (now statement_compiler()), preparer(), etc., mostly in that the dialect needs to be passed explicitly as the first argument (since they are just class references now). The compiler() method on Engine and Connection is now also named statement_compiler(), but as before does not take the dialect as an argument. 5. changed _process_row function on RowProxy to be a class reference, cuts out 50K method calls from insertspeed.py
* - fixed prefixes= argument to select()Jason Kirtland2007-08-181-1/+38
| | | | | | | - mysql can now generate DISTINCT or ALL for queries, select(..., distinct='ALL') - documented 'prefixes' arg to select() - rearranged doc order for select args to mirror that of a generated statement - went nutty and fixed wrapping and line length on most docstrings in sql.py
* Allow auto_increment on any pk column, not just the first.Jason Kirtland2007-08-121-0/+62
|
* by popular demand, mysql reflection is now a single round-trip and uses a ↵Jason Kirtland2007-08-111-14/+11
| | | | | | | | parse of SHOW CREATE TABLE ddl [ticket:612] the ANSI_QUOTES mode is now supported halfway there for auto_increment on secondary columns [ticket:649] indexes are now reflected [ticket:663]
* restore clipping value for YEAR DDLJason Kirtland2007-08-091-3/+6
|
* Added `set_types` to util, a tuple of available set implementations.Jason Kirtland2007-08-081-16/+263
| | | | | | Added BIT and SET ([ticket:674])- all mysql data types are now covered! Fix for YEAR DDL generation, also no longer a concatenable type. Expanded docs for some mysql column esoterica.
* - Dialects can be queried for the server version (sqlite and mysql only with ↵Jason Kirtland2007-08-031-36/+36
| | | | | | | | | | | | | | this commit) - Mark everything in a test suite as failed when setUpAll fails. - Added test coverage for Unicode table names in metadata.reflect() - @testing.exclude() filters out tests by server version - Applied exclude to the test suite, MySQL 4.1 passes again (no XA or SAVEPOINT) - Removed MySQL charset-setting pool hook- charset=utf8&use_unicode=0 works just as well. (Am I nuts? I'd swear this didn't work before.) - Finally migrated some old MySQL-tests into the dialect test module - Corrected 'commit' and 'rollback' logic (and comment) for ancient MySQL versions lacking transactions entirely - Deprecated the MySQL get_version_info in favor of server_version_info - Added a big hunk-o-doc for MySQL.
* Big MySQL dialect update, mostly efficiency and style.Jason Kirtland2007-07-291-0/+44
| | | | | | Added TINYINT [ticket:691]- whoa, how did that one go missing for so long? Added a charset-fixing pool listener. The driver-level option doesn't help everyone with this one. New reflector code not quite done and omiited from this commit.
* merging 0.4 branch to trunk. see CHANGES for details. 0.3 moves to ↵Mike Bayer2007-07-271-40/+18
| | | | maintenance branch in branches/rel_0_3.
* - Deprecated DynamicMetaData- use ThreadLocalMetaData or MetaData insteadJason Kirtland2007-07-061-2/+2
| | | | | - Deprecated BoundMetaData- use MetaData instead - Removed DMD and BMD from documentation
* - Emit BOOL rather than BOOLEAN for MySQL booleans in DDL, for old versionsJason Kirtland2007-05-311-5/+8
| | | | | | | | | | | | of MySQL (#583) - MySQL columns (such as times) with colons in their default values couldn't be roundtripped, fixed (also in Postgres, but not fixed here.) - BINARY/VARBINARY columns aren't really binary at all on ancient versions of MySQL. The type.Binary(123) passthrough now always makes BLOBs. Removed the short-lived MSBaseBinary. - Added mysql.get_version_info, given a connectable returns a tuple of server version info. - Backed off on the reflection tests for older versions of MySQL, for now.
* - Nearly all MySQL column types are now supported for declaration andJason Kirtland2007-05-251-15/+89
| | | | | | | | | | | | reflection. Added NCHAR, NVARCHAR, VARBINARY, TINYBLOB, LONGBLOB, YEAR - The sqltypes.Binary passthrough now builds a VARBINARY rather than a BINARY if given a length - Refactored the inheritance of some types with respect to sqltypes, and especially the binary types - Lots and lots of docs - MySQL unit tests now starting to adapt to known problems with alpha/beta drivers - A couple mysql unit test fix-ups and expansions
* - Expanded on the MySQL ENUM 'strict' documentation a little bit.Jason Kirtland2007-05-021-0/+1
| | | | - Oops, clean up after enum unitttest.
* - MySQL ENUM types can now optionally ensure that values are within theJason Kirtland2007-05-021-0/+268
enum's allowed range on insert and update, with strict=True - Added new 'dialect' category of unit tests, and migrated MySQL-specific dialect tests there. - Noted the max identifier length in the MySQL dialect (the max alias length, actually)
View Lorry Controller Status