summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy
Commit message (Collapse)AuthorAgeFilesLines
...
* | - replace mssql_ordering with generalized #695 solutionMike Bayer2013-01-202-16/+61
| | | | | | | | - documentation for mssql index options plus changelog and fixes
* | Merged in dharland/sqlalchemy (pull request #35)Mike Bayer2013-01-201-0/+37
|\ \ | | | | | | | | | Add extra mssql dialect options to Index
| * | Add mssql_include option for mssql dialectDerek Harland2013-01-141-0/+10
| | |
| * | Add mssql_ordering option for mssql dialectDerek Harland2013-01-141-3/+10
| | |
| * | Add mssql_clustered option for mssql dialectDerek Harland2013-01-141-0/+20
| |/
* | Removes an errant space character that caused a newline break in the sphinx ↵Taavi Burns2013-01-171-1/+1
| | | | | | | | output.
* | fix incorrect quoting in mysql indexesMike Bayer2013-01-171-3/+1
| |
* | - fix a format issue in the create indexMike Bayer2013-01-171-1/+1
| |
* | MutableDict.__delitem__ should require only 'key' argumentAudrius Kažukauskas2013-01-171-2/+2
| |
* | :class:`.Index` now supports arbitrary SQL expressions and/orMike Bayer2013-01-167-55/+87
| | | | | | | | | | | | | | | | functions, in addition to straight columns. Common modifiers include using ``somecolumn.desc()`` for a descending index and ``func.lower(somecolumn)`` for a case-insensitive index, depending on the capabilities of the target backend. [ticket:695]
* | - preparing for #695, modernize constraint/index testsMike Bayer2013-01-161-4/+9
|/
* Added a py3K conditional around unnecessary .decode()Mike Bayer2013-01-121-0/+2
| | | | | call in mssql information schema, fixes reflection in Py3K. Also in 0.7.10. [ticket:2638]
* remove all specifics from the "supported features" section as thisMike Bayer2013-01-121-21/+3
| | | | is not maintainable
* - add workaround for sqlite memusage tests, so no longer need to count to ↵Mike Bayer2013-01-121-4/+13
| | | | | | | | | | | | | 220/skip tests - Fixed potential memory leak which could occur if an arbitrary number of :class:`.sessionmaker` objects were created. The anonymous subclass created by the sessionmaker, when dereferenced, would not be garbage collected due to remaining class-level references from the event package. This issue also applies to any custom system that made use of ad-hoc subclasses in conjunction with an event dispatcher. Also in 0.7.10. [ticket:2650]
* - changelog for pullreq 32Mike Bayer2013-01-121-124/+10
| | | | | | | | | | | - Fixed a regression whereby the "collation" parameter of the character types CHAR, NCHAR, etc. stopped working, as "collation" is now supported by the base string types. The TEXT, NCHAR, CHAR, VARCHAR types within the MSSQL dialect are now synonyms for the base types. - move out the type rendering tests into DB-agnostic tests and remove some of the old "create" statements. tests here are still very disorganized.
* Merged in dharland/sqlalchemy (pull request #32: Allow the MSSQL dialect to ↵Mike Bayer2013-01-121-12/+11
|\ | | | | | | support identity columns that are not part of the primary key)
| * MSSQL Dialect should set sequence columns to be non nullDerek Harland2012-12-041-1/+2
| |
| * Merge changes from official sqlalchemy repoDerek Harland2012-12-0413-188/+327
| |\
| * | Allow the MSSQL dialect to support identity columns that are not part of the ↵Derek Harland2012-12-041-11/+9
| | | | | | | | | | | | primary key
* | | :meth:`.Query.merge_result` can now load rows from an outer joinMike Bayer2013-01-081-4/+5
| | | | | | | | | | | | | | | where an entity may be ``None`` without throwing an error. [ticket:2640]
* | | Tweaked the "REQUIRED" symbol used by the compiler to identifyMike Bayer2013-01-081-5/+14
| | | | | | | | | | | | | | | | | | INSERT/UPDATE bound parameters that need to be passed, so that it's more easily identifiable when writing custom bind-handling code. [ticket:2648]
* | | - remove the test against bindparam('x') for the bind/result SQL expressionsMike Bayer2013-01-021-8/+45
| | | | | | | | | | | | - apply a consistent approach to the "see if method X is implemented" conditionals
* | | Fixed bug in :func:`.postgresql.array` construct whereby using itMike Bayer2013-01-021-1/+1
| | | | | | | | | | | | | | | inside of an :func:`.expression.insert` construct would produce an error regarding a parameter issue in the ``self_group()`` method.
* | | happy new year (see #2645)Diana Clarke2013-01-015-5/+5
| | |
* | | happy new year (see #2645)Diana Clarke2013-01-013-3/+3
| | |
* | | happy new year (see #2645)Diana Clarke2013-01-01120-120/+120
| | |
* | | Fixes grammar in docstring.Taavi Burns2012-12-311-1/+1
| | |
* | | Extended the :doc:`/core/inspection` system so that all Python descriptorsMike Bayer2012-12-296-9/+191
| | | | | | | | | | | | | | | | | | | | | | | | associated with the ORM or its extensions can be retrieved. This fulfills the common request of being able to inspect all :class:`.QueryableAttribute` descriptors in addition to extension types such as :class:`.hybrid_property` and :class:`.AssociationProxy`. See :attr:`.Mapper.all_orm_descriptors`.
* | | Fixes issue where GAE error handling can cause AttributeError: 'NoneType' ↵Owen Nelson2012-12-281-1/+3
| | | | | | | | | | | | object has no attribute 'group'
* | | GAE dialect now supports the use of credentialsOwen Nelson2012-12-281-1/+3
| | |
* | | - add tests to ensure SELECT of dynamic collection not emittedMike Bayer2012-12-222-1/+3
| | | | | | | | | | | | | | | | | | on regular append/remove history - fix the real cause of the original #2637 issue, backrefs call upon the "pop()" method now which wasn't implemented for Dynamic
* | | - revert the full iteration of the collection for a passive history event; ↵Mike Bayer2012-12-221-5/+11
| | | | | | | | | | | | | | | | | | | | | that's the wrong behavior, and for the original #2637 issue we will have to fix the association proxy, which is #2642
* | | - significantly rework the approach to collection events and history within ↵Mike Bayer2012-12-212-63/+86
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | DynamicAttributeImpl - Fixes to the "dynamic" loader on :func:`.relationship`, includes that backrefs will work properly even when autoflush is disabled, history events are more accurate in scenarios where multiple add/remove of the same object occurs, as can often be the case in conjunction with the association proxy. [ticket:2637]
* | | - cleanup on these testsMike Bayer2012-12-211-0/+6
| | | | | | | | | | | | - add "extend()" to AppenderQuery
* | | this comment is entirely from some ancient version of the codeMike Bayer2012-12-141-2/+0
| | |
* | | More adjustment to this SQLite related issue which was released inMike Bayer2012-12-141-28/+39
| | | | | | | | | | | | | | | | | | | | | 0.7.9, to intercept legacy SQLite quoting characters when reflecting foreign keys. In addition to intercepting double quotes, other quoting characters such as brackets, backticks, and single quotes are now also intercepted. [ticket:2568]
* | | The :meth:`.Query.select_from` method can now be used with aMike Bayer2012-12-131-18/+18
| | | | | | | | | | | | | | | :func:`.aliased` construct without it interfering with the entities being selected. [ticket:2635]
* | | Fixed a regression caused by :ticket:`2410` whereby aMike Bayer2012-12-112-13/+28
| | | | | | | | | | | | | | | | | | | | | | | | | | | :class:`.CheckConstraint` would apply itself back to the original table during a :meth:`.Table.tometadata` operation, as it would parse the SQL expression for a parent table. The operation now copies the given expression to correspond to the new table. [ticket:2633]
* | | Fixed table reflection for Oracle when accessing a synonym that refersMike Bayer2012-12-092-60/+101
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | to a DBLINK remote database; while the syntax has been present in the Oracle dialect for some time, up until now it has never been tested. The syntax has been tested against a sample database linking to itself, however there's still some uncertainty as to what should be used for the "owner" when querying the remote database for table information. Currently, the value of "username" from user_db_links is used to match the "owner". [ticket:2619]
* | | - documentation and changelog for [ticket:2601]Mike Bayer2012-12-091-9/+57
| | |
* | | Fixed bug where using server_onupdate=<FetchedValue|DefaultClause>Mike Bayer2012-12-081-2/+15
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | without passing the "for_update=True" flag would apply the default object to the server_default, blowing away whatever was there. The explicit for_update=True argument shouldn't be needed with this usage (especially since the documentation shows an example without it being used) so it is now arranged internally using a copy of the given default object, if the flag isn't set to what corresponds to that argument. Also in 0.7.10. [ticket:2631]
* | | Fixed bug whereby using a label_length on dialect that was smallerMike Bayer2012-12-082-8/+15
| | | | | | | | | | | | | | | | | | than the size of actual column identifiers would fail to render the columns correctly in a SELECT statement. [ticket:2610]
* | | - version check for sqlite on multivalues is 3.7.11Mike Bayer2012-12-081-0/+3
| | |
* | | internally at least refer to multirow as "multivalues", to distinguish betweenMike Bayer2012-12-086-7/+7
| | | | | | | | | | | | | | | an INSERT that's used in executemany() as opposed to one which has a VALUES clause with multiple entries.
* | | - multivalued inserts, [ticket:2623]Mike Bayer2012-12-083-125/+249
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - update "not supported" messages for empty inserts, mutlivalue inserts - rework the ValuesBase approach for multiple value sets so that stmt.parameters does store a list for multiple values; the _has_multiple_parameters flag now indicates which of the two modes the statement is within. it now raises exceptions if a subsequent call to values() attempts to call a ValuesBase with one mode in the style of the other mode; that is, you can't switch a single- or multi- valued ValuesBase to the other mode, and also if a multiple value is passed simultaneously with a kwargs set. Added tests for these error conditions - Calling values() multiple times in multivalue mode now extends the parameter list to include the new parameter sets. - add error/test if multiple *args were passed to ValuesBase.values() - rework the compiler approach for multivalue inserts, back to where _get_colparams() returns the same list of (column, value) as before, thereby maintaining the identical number of append() and other calls when multivalue is not enabled. In the case of multivalue, it makes a last-minute switch to return a list of lists instead of the single list. As it constructs the additional lists, the inline defaults and other calculated default parameters of the first parameter set are copied into the newly generated lists so that these features continue to function for a multivalue insert. Multivalue inserts now add no additional function calls to the compilation for regular insert constructs. - parameter lists for multivalue inserts now includes an integer index for all parameter sets. - add detailed documentation for ValuesBase.values(), including careful wording to describe the difference between multiple values and an executemany() call. - add a test for multivalue insert + returning - it works ! - remove the very old/never used "postgresql_returning"/"firebird_returning" flags.
* | | merge latest defaultMike Bayer2012-12-0818-224/+408
|\ \ \
| * | | fixing sessionmaker linkDiana Clarke2012-12-071-1/+1
| | | |
| * | | The Oracle LONG type, while an unbounded text type, does not appearMike Bayer2012-12-061-0/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | to use the cx_Oracle.LOB type when result rows are returned, so the dialect has been repaired to exclude LONG from having cx_Oracle.LOB filtering applied. Also in 0.7.10. [ticket:2620]
| * | | merge danceMike Bayer2012-12-066-39/+39
| |\ \ \
| | * | | fixing broken links (see #2625)Diana Clarke2012-12-063-17/+18
| | | | |