summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/databases/mysql.py
Commit message (Collapse)AuthorAgeFilesLines
...
* some cleanup submitted by Lele GalifaxMike Bayer2006-10-131-3/+0
|
* - the "foreign_key" attribute on Column and ColumnElement in generalMike Bayer2006-10-081-1/+1
| | | | | | | | | is deprecated, in favor of the "foreign_keys" list/set-based attribute, which takes into account multiple foreign keys on one column. "foreign_key" will return the first element in the "foreign_keys" list/set or None if the list is empty. - added a user test to the relationships test, testing various new things this change allows
* editsMike Bayer2006-10-011-2/+3
|
* further str() on values that may come back as unicodeMike Bayer2006-10-011-1/+3
|
* [ticket:318] has a user receiving back a unicode from a SHOW CREATE TABLE ↵Mike Bayer2006-10-011-1/+3
| | | | for some reason
* - added autoincrement=True to Column; will disable schema generationMike Bayer2006-09-231-1/+1
| | | | | of SERIAL/AUTO_INCREMENT/identity seq for postgres/mysql/mssql if explicitly set to False. #303
* case sensitive function seems to return a string in some casesMike Bayer2006-09-211-1/+1
|
* - changed "for_update" parameter to accept False/True/"nowait"Mike Bayer2006-09-101-0/+6
| | | | | | | | | | and "read", the latter two of which are interpreted only by Oracle and Mysql [ticket:292] - added "lockmode" argument to base Query select/get functions, including "with_lockmode" function to get a Query copy that has a default locking mode. Will translate "read"/"update" arguments into a for_update argument on the select side. [ticket:292]
* fixed constructor on bigintMike Bayer2006-09-061-5/+0
|
* possible fix for [ticket:276]. if mysql detects case-insensitivity, convertsMike Bayer2006-09-011-3/+5
| | | | tables to lower case names
* - postgres reflection moved to use pg_schema tables, can be overriddenMike Bayer2006-08-211-3/+3
| | | | | | | | with use_information_schema=True argument to create_engine [ticket:60], [ticket:71] - added natural_case argument to Table, Column, semi-experimental flag for use with table reflection to help with quoting rules [ticket:155]
* more fixes for [ticket:269], added MSMediumBlob typeMike Bayer2006-08-181-10/+15
|
* fixes to types so that database-specific types more easily used;Mike Bayer2006-08-121-12/+4
| | | | | fixes to mysql text types to work with this methodology [ticket:269]
* quoting facilities set up so that database-specific quoting can beMike Bayer2006-08-121-1/+14
| | | | | | | turned on for individual table, schema, and column identifiers when used in all queries/creates/drops. Enabled via "quote=True" in Table or Column, as well as "quote_schema=True" in Table. Thanks to Aaron Spike for his excellent efforts. [ticket:155]
* reflected 'mediumint' typeMike Bayer2006-08-111-0/+1
|
* moved rollback catch to mysql module...Mike Bayer2006-08-101-0/+7
|
* fixed possible error in mysql reflection where certain versionsMike Bayer2006-08-071-1/+6
| | | | return an array instead of string for SHOW CREATE TABLE call
* fixed mysql reflection of default values to be PassiveDefaultMike Bayer2006-08-041-3/+5
|
* [ticket:256] propigating url.query arguments to connect() function for all db'sMike Bayer2006-07-251-0/+12
|
* fixed reflection of foreign keys to autoload the referenced tableMike Bayer2006-07-221-0/+1
| | | | | if it was not loaded already, affected postgres, mysql, oracle. fixes the latest in [ticket:105]
* overhaul to schema, addition of ForeignKeyConstraint/Mike Bayer2006-07-141-19/+12
| | | | | | | | PrimaryKeyConstraint objects (also UniqueConstraint not completed yet). table creation and reflection modified to be more oriented towards these new table-level objects. reflection for sqlite/postgres/mysql supports composite foreign keys; oracle/mssql/firebird not converted yet.
* fixed up boolean datatype for sqlite, mysql, ms-sqlMike Bayer2006-07-131-2/+15
|
* new MySQL types: MSEnum, MSTinyText, MSMediumText, MSLongText, etc.Mike Bayer2006-06-271-20/+135
| | | | | more support for MS-specific length/precision params in numeric types patch courtesy Mike Bernson
* fixed bug when specifying explicit module to mysql dialectMike Bayer2006-06-231-0/+2
|
* added *extra to mysql string type to consume extra unsupported arguments ↵Mike Bayer2006-06-221-0/+2
| | | | from reflection
* cast converted into its own ClauseElement so that it can have an explicit ↵rel_0_2_3Mike Bayer2006-06-171-1/+9
| | | | | | | | | | | compilation function in ANSICompiler MySQLCompiler then skips most CAST calls since it only seems to support the standard syntax for Date types; other types now a TODO for MySQL then, polymorphic_union() function now CASTs null()s to the type corresponding to the columns in the UNION, since postgres doesnt like mixing NULL with integer types (long road for that .....)
* added "NonExistentTable" exception throw to reflection, courtesy ↵Mike Bayer2006-06-061-4/+9
| | | | lbruno@republico.estv.ipv.pt, for [ticket:138]
* merged 0.2 branch into trunk; 0.1 now in sqlalchemy/branches/rel_0_1Mike Bayer2006-05-251-47/+40
|
* *another* big types change....the old way was still wrong...this way is ↵Mike Bayer2006-04-291-1/+5
| | | | better (still need to go through it again since i am apparently type-impaired....)
* moves the binding of a TypeEngine object from "schema/statement creation" ↵Mike Bayer2006-04-061-1/+1
| | | | time into "compilation" time
* refactor to Compiled.get_params() to return new ClauseParameters object, a ↵Mike Bayer2006-03-131-1/+1
| | | | | | | | | | | more intelligent bind parameter dictionary that does type conversions late and preserves the unconverted value; used to fix mappers not comparing correct value in post-fetch [ticket:110] removed pre_exec assertion from oracle/firebird regarding "check for sequence/primary key value" fix to Unicode type to check for null, fixes [ticket:109] create_engine() now uses genericized parameters; host/hostname, db/dbname/database, password/passwd, etc. for all engine connections fix to select([func(column)]) so that it creates a FROM clause to the column's table, fixes [ticket:111] doc updates for column defaults, indexes, connection pooling, engine params unit tests for the above bugfixes
* committed patch for MSDouble/tinyint from [ticket:106]Mike Bayer2006-03-101-1/+19
|
* took excess visit_func out, handled by ansisql compilerMike Bayer2006-03-071-6/+0
|
* removed the dependency of ANSICompiler on SQLEngine. you can now make ↵Mike Bayer2006-03-041-1/+1
| | | | ANSICompilers and compile SQL with no engine at all.
* changed ENGINE to TYPE, for mysql 4 compatibilityMike Bayer2006-03-021-1/+1
|
* Modified mysql to not add AUTOINCREMENT to the first integer primary key if ↵Robert Leftwich2006-03-011-1/+1
| | | | it is also a foreign key.
* merged sql_rearrangement branch , refactors sql package to work standalone withMike Bayer2006-02-251-17/+5
| | | | | clause elements including tables and columns, schema package deals with "physical" representations
* added indexes to schema/ansisql/engineMike Bayer2006-02-181-1/+15
| | | | | | slightly different index syntax for mysql fixed mysql Time type to convert from a timedelta to time tweaks to date unit tests for mysql
* streamlined engine.schemagenerator and engine.schemadropper methodologyMike Bayer2006-02-111-2/+12
| | | | | | added support for creating PassiveDefault (i.e. regular DEFAULT) on table columns postgres can reflect default values via information_schema added unittests for PassiveDefault values getting created, inserted, coming back in result sets
* foreign key reflection !!!!!Mike Bayer2006-02-061-1/+41
|
* table supports per-engine-type options, ansisql allows enginesMike Bayer2006-02-051-4/+12
| | | | | | to add a "post table create" string mysql gets mysql_engine argument InnoDB set as default in engines test
* writes foreign keys as individual FOREIGN KEY objects, syntax seems to work ↵Mike Bayer2006-02-051-1/+1
| | | | better
* Rick Morrison's patch adding Smallint, Date, and Time support !Mike Bayer2006-02-041-0/+15
|
* mysql table introspection uses 'describe' to work with 3/4/5Mike Bayer2006-01-131-1/+23
| | | | no foreign key introspection available, sorry !
* copyright->2005,2006Mike Bayer2006-01-031-1/+1
|
* type objects pass engine around to get a hold of DBAPI type objectsMike Bayer2006-01-031-1/+8
| | | | | | added dbapi.Binary creation to base BinaryType fixed MySQL binary type adjustment to Join._match_primaries to work better with self-referential table
* changed mysql TIMESTAMP->DATETIMEMike Bayer2006-01-021-1/+1
| | | | | fixed up date unit test RowProxy __iter__ properly routes columns through type processing
* factoring out mysql's rowid stuff since its down in the base engine class nowMike Bayer2006-01-011-19/+1
|
* license switchMike Bayer2005-12-311-13/+2
|
* refactoring of execution path, defaults, and treatment of different paramstylesMike Bayer2005-12-171-2/+1
|
View Lorry Controller Status