1. Michael Bayer
  2. sqlalchemy
  3. Branches

Branches

rel_0_8

View source
rel_0_8
  • Contributors
    1. Loading...
Author Commit Message Date Builds
250+ commits behind master.
Ville Skyttä
Fix some broken links in docs (cherry picked from commit b1c9b3bd384fc40e1c411abef12eaf04b574612f)
Michael Bayer
- update oracle JDBC driver URL, fixes #3554 (cherry picked from commit 24dba714cb56e1f5a4dca5453cc5f442e6ee08ab)
peterdemin
Update base.py Docstring typo keysowrds => keywords (cherry picked from commit f8eb7c2858443649190b735c587c190ae90b6106)
Michael Bayer
- remove ambiguous use of the phrase "joined together by AND" as this may be construed as the Python "and" keyword - add notes to ORM tutorial for beginners that Python "and" keyword is not to be used fixes #3545 (cherry picked from commit ac08920284935e7e7519ce77ba369703390155dc)
Jason Myers
Correcting the Hybrid Property Example Fixes #3528 Signed-off-by: Jason Myers <jason@jasonamyers.com> Conflicts: lib/sqlalchemy/ext/hybrid.py
yan zhu
fix typo int->into (cherry picked from commit 51870ddaef8abf61ee4c8d6337a72db5395a0a85)
Michael Bayer
fdb drivers seem to be no longer available (cherry picked from commit 422fca43f8af1bfba0c2a2d24aa2eca7fc3bd558)
Michael Bayer
- fix typo, fixes #3325 (cherry picked from commit 138293c246fbf8c6693044a89fe788d0d0446113)
Michael Bayer
- remove now-misleading comment that SQLite doesn't support MATCH, since they've apparently added something for it
Michael Bayer
- call this 1.0.0b1 (cherry picked from commit 64b7a50cbd64b44fa8ee8413213e9eae73483515) (cherry picked from commit 601e16daf30a00dd049507cb8bfa4931013c2e46)
Michael Bayer
- fix quantize recipe, fixes #3322
Michael Bayer
- backport the latest version of scrolling
Michael Bayer
- merge the safari-related changes to init.js from zzzeeksphinx
Priit Laes
Maul the evaulate & friends typo this is only a small part of the cherry-pick as the docs have been reorganized since 0.8 (cherry picked from commit 8ae47dc6e0a98b359247040236be0810b9086f40) Conflicts: doc/build/changelog/changelog_10.rst doc/build/changelog/migration_10.rst lib/sqlalchemy/ext/declarative/base.py (cherry picked from commit 6e7701d534141ed8c4cba668792f2bb528a5af61) Conflicts: doc/build/changelog/changelog_…
mozillazg
Fixed typo Conflicts: lib/sqlalchemy/sql/schema.py
Jim Hokanson
Updated documenation for engines.rst Clarified connecting to absolute path for sqlite using Windows.
Michael Bayer
- for whatever reason, Insert.values() with multi values wasn't in the 0.8 migration, so let's just add that
Michael Bayer
- mako_layout isn't used, remove it - to check for epub look at "builder"
simon klemenc
Docs: use the base layout when mako_layout=='epub' - https://readthedocs.org/projects/sqlalchemy/downloads/epub/latest/ renders with the full template which is unreadable on e-readers - in the makefile the template-variable mako_layout is set for target: epub which makes mako use only the base layout. - this is the more elegant solution as proposed to #133
Michael Bayer
- clarify docs that contains_eager() is included in the of_type() system, fix #2438
Michael White
fix typo in cascade documentation
Michael Bayer
0.8.7
Michael Bayer
- backport 0.9-related updates
Michael Bayer
- ticket inline
Michael Bayer
- backport #3093 to 0.8, fixes #3093
Michael Bayer
- need Integer here as #1765 is in 0.9
Michael Bayer
- Added statement encoding to the "SET IDENTITY_INSERT" statements which operate when an explicit INSERT is being interjected into an IDENTITY column, to support non-ascii table identifiers on drivers such as pyodbc + unix + py2k that don't support unicode statements. ref #3091 as this fix is also in that issue's patch, but is a different issue.
Michael Bayer
- In the SQL Server pyodbc dialect, repaired the implementation for the ``description_encoding`` dialect parameter, which when not explicitly set was preventing cursor.description from being parsed correctly in the case of result sets that contained names in alternate encodings. This parameter shouldn't be needed going forward. fixes #3091 Conflicts: test/sql/test_unicode.py
Michael Bayer
- add some order bys
Michael Bayer
- adjust this to work on PG also
Michael Bayer
- Fixed bug in :class:`.Enum` and other :class:`.SchemaType` subclasses where direct association of the type with a :class:`.MetaData` would lead to a hang when events (like create events) were emitted on the :class:`.MetaData`. fixes #3124 Conflicts: lib/sqlalchemy/sql/sqltypes.py test/sql/test_types.py
Michael Bayer
- Fixed a bug within the custom operator plus :meth:`.TypeEngine.with_variant` system, whereby using a :class:`.TypeDecorator` in conjunction with variant would fail with an MRO error when a comparison operator was used. fixes #3102 Conflicts: lib/sqlalchemy/sql/type_api.py
Michael Bayer
wrong version number
Michael Bayer
- MySQL error 2014 "commands out of sync" appears to be raised as a ProgrammingError, not OperationalError, in modern MySQL-Python versions; all MySQL error codes that are tested for "is disconnect" are now checked within OperationalError and ProgrammingError regardless. fixes #3101
Michael Bayer
additional version notes
Michael Bayer
- Fixed bug where column names added to ``mysql_length`` parameter on an index needed to have the same quoting for quoted names in order to be recognized. The fix makes the quotes optional but also provides the old behavior for backwards compatibility with those using the workaround. fixes #3085
Michael Bayer
- The ``__mapper_args__`` dictionary is copied from a declarative mixin or abstract class when accessed, so that modifications made to this dictionary by declarative itself won't conflict with that of other mappings. The dictionary is modified regarding the ``version_id_col`` and ``polymorphic_on`` arguments, replacing the column within with the one that is officially mapped to the local class/table. fixes #3062
Michael Bayer
relative here
Michael Bayer
- all new approach which allows the main text to be on the top
Michael Bayer
- disable the scrolling layout, anchors for code/params are not working, and the current approach used for sections is not able to work for fine-grained anchors like these, another approach needs to be taken.
Michael Bayer
- a rework of doc layout and nav: - reduce the real estate for the top nav; move the search box into the top yellow box, close in space - use a new CSS/js approach such that the top toolbar freezes from scrolling at the top of the page. The left nav scrolls independently of the content pane so that the local contents remain visible regardless of scrolling. this approach is disabled on mobile where the dual s…
Michael Bayer
- Fixed bug in INSERT..FROM SELECT construct where selecting from a UNION would wrap the union in an anonymous (e.g. unlabled) subquery. fixes #3044
Michael Bayer
- Added the ``hashable=False`` flag to the PG :class:`.HSTORE` type, which is needed to allow the ORM to skip over trying to "hash" an ORM-mapped HSTORE column when requesting it in a mixed column/entity list. Patch courtesy Gunnlaugur Þór Briem. Fixes #3053
Michael Bayer
- Fixed bug in subquery eager loading where a long chain of eager loads across a polymorphic-subclass boundary in conjunction with polymorphic loading would fail to locate the subclass-link in the chain, erroring out with a missing property name on an :class:`.AliasedClass`. fixes #3055 - adjust the test from 1.0/0.9 to not use chained eager load style
Michael Bayer
- hyperlink all the column operators listed in the ORM tutorial common filter operators section - add language to MATCH explicitly stating this operator varies by backend and is not available on SQLite, as the tutorial defaults to SQLite to start with, fix #3059 - on the actual match() documentation fix this up to be more accurate, list some example renderings for different backends. again mention SQLite not supported
Michael Bayer
typo
Michael Bayer
- add lots more to the profiling section - add the query profiling recipe, fix it with a stack as we now nest those calls occasionally - tabs to spaces Conflicts: doc/build/faq.rst
Gunnlaugur Þór Briem
Add note on PostgreSQL config for test runs Several tests on PostgreSQL depend on English-language text search config being the default in the test DB. This adds a note about that. Conflicts: README.unittests.rst
Michael Bayer
- Fixed bug in mutable extension where :class:`.MutableDict` did not report change events for the ``setdefault()`` dictionary operation. fixes #3051
Michael Bayer
- add a new FAQ section "performance", put the profiling article there, move the insert rows article there as well
Wieland Hoffmann
Posgtresql -> PostgreSQL
Michael Bayer
changelog for pullreq bitbucket:15
Sean McGivern
Added optional '=' to MySQL KEY_BLOCK_SIZE regex
Matthias Urlichs
Documentation fix-up: "its" vs. "it's" Removed ungrammatical apostrophes from documentation, replacing "it's" with "its" where appropriate (but in a few cases with "it is" when that read better). While doing that, I also fixed a couple of minor typos etc. as I noticed them.
Michael Bayer
- Fixed ORM bug where the :func:`.class_mapper` function would mask AttributeErrors or KeyErrors that should raise during mapper configuration due to user errors. The catch for attribute/keyerror has been made more specific to not include the configuration step. fixes #3047
Michael Bayer
- Fixed bug where :meth:`.Table.update` and :meth:`.Table.delete` would produce an empty WHERE clause when an empty :func:`.and_()` or :func:`.or_()` or other blank expression were applied. This is now consistent with that of :func:`.select`. fixes #3045
Alex Gaynor
Fix many typos throughout the codebase cherry pick of those parts of 1caa7fa which went in without issue Found using: https://github.com/intgr/topy
Michael Bayer
- add a note about versioning only applying to flushes
Michael Bayer
- document that joinedload/eagerload work with of_type() + with_polymoprhic()
Bérenger Enselme
Added some links in session docs
Michael Bayer
0.8.7
Michael Bayer
- Added a new "disconnect" message "connection has been closed unexpectedly". This appears to be related to newer versions of SSL. Pull request courtesy Antti Haapala.
Antti Haapala
added an SSL related connection error
Daniel Smith
Fixed bug in example code.
Michael Bayer
repair erroneous whitespace in autodoc directives, preventing members from being documented
Michael Bayer
- add some docs for the instancestate linkage to the inspection system
Michael Bayer
- reverse order of columns in sample CTEs as this is a UNION and the cols need to line up - alter this in the unit tests as well as these queries were just copied from the tests - remove the included_parts.join(parts) from the core CTE doc (also just copied from the test, where we want to make sure joins don't get screwed up with the CTE) as it doesn't contribute to the query itself fixes #3014
Michael Bayer
0.8.6
Michael Bayer
this doesnt need sane multi row now...
Michael Bayer
- revert part of c01558ae7f4a for now as we also test that a DELETE of two rows where one is to be deleted from ON DELETE CASCADE succeeds; the check here makes that fail. We will need to add an option to enable/disable this check per mapping, will likely do this in next version
Michael Bayer
revert inadvertent pdb
Michael Bayer
- the rewording of orderinglist docs got committed by accident, finish it up
Michael Bayer
- Fixed ORM bug where changing the primary key of an object, then marking it for DELETE would fail to target the correct row for DELETE. Then to compound matters, basic "number of rows matched" checks were not being performed. Both issues are fixed, however note that the "rows matched" check requires so-called "sane multi-row count" functionality; the DBAPI's executemany() method must count up the rows matched by individual statements and SQLAlchemy's dialect must mark this feature as supported, currently applies to some mysql dialects, psycopg2, sqlite only. fixes #3006 - Enabled "sane multi-row count" checking for the psycopg2 DBAPI, as this seems to be supported as of psycopg2 2.0.9. Conflicts: test/orm/test_naturalpks.py test/requirements.py
Stefan Reich
Added missing text_type requirement to TextTest
Michael Bayer
- Fixed regression caused by release 0.8.5 / 0.9.3's compatibility enhancements where index reflection on Postgresql versions specific to only the 8.1, 8.2 series again broke, surrounding the ever problematic int2vector type. While int2vector supports array operations as of 8.1, apparently it only supports CAST to a varchar as of 8.3. fix #3000
Michael Bayer
- Fixed regression from 0.8.3 as a result of 🎫`2818` where :meth:`.Query.exists` wouldn't work on a query that only had a :meth:`.Query.select_from` entry but no other entities. re: #2818 fixes #2995
Michael Bayer
- Adjusted ``setup.py`` file to support the possible future removal of the ``setuptools.Feature`` extension from setuptools. If this keyword isn't present, the setup will still succeed with setuptools rather than falling back to distutils. C extension building can be disabled now also by setting the DISABLE_SQLALCHEMY_CEXT environment variable. This variable works whether or not setuptools is even available. fixes #2986 - using platform.python_implementa…
Michael Bayer
- reword the paragraph which talks about web framework integration for sessions: 1. fix the typo in the paragraph, fixes #2998 2. as zope-sqlalchemy only provides transaction integration and not session scoping, dial back the language here as people are probably using scoped_session with pyramid anyway 3. as I'm going to again start recommending people don't cling to flask-sqlalchemy so hard, take out the word "strongly" from the recommendation. 4. as flask is the only framewo…
Michael Bayer
fix assertion
Michael Bayer
- Fixed bug in mutable extension as well as :func:`.attributes.flag_modified` where the change event would not be propagated if the attribute had been reassigned to itself. fixes #2997 Conflicts: lib/sqlalchemy/orm/state.py test/orm/test_attributes.py
Charles-Axel Dein
Add is_ and isnot filter to the tutorial Most linter complain when comparing with None.
Michael Bayer
- Improved an error message which would occur if a query() were made against a non-selectable, such as a :func:`.literal_column`, and then an attempt was made to use :meth:`.Query.join` such that the "left" side would be determined as ``None`` and then fail. This condition is now detected explicitly.
Michael Bayer
typo
Michael Bayer
- fairly epic rework of the cascade documentation Conflicts: lib/sqlalchemy/orm/relationships.py
Michael Bayer
Merge pull request #79 from nibrahim/master Fixes argument number in docs
Michael Bayer
merge new links to rel_0_8
Michael Bayer
cut out the BS as far as MySQLdb urls, put the one url everyone should be using
Michael Bayer
- Fixed bug in :func:`.tuple_` construct where the "type" of essentially the first SQL expression would be applied as the "comparison type" to a compared tuple value; this has the effect in some cases of an inappropriate "type coersion" occurring, such as when a tuple that has a mix of String and Binary values improperly coerces target values to Binary even though that's not what they are on the left side. :func:`.tuple_` now expects heterogeneous types within its list of values. fixes #2977 Conflicts: lib/sqlalchemy/sql/elements.py test/sql/test_operators.py
Michael Bayer
0.8.6
Michael Bayer
- Removed stale names from ``sqlalchemy.orm.interfaces.__all__`` and refreshed with current names, so that an ``import *`` from this module again works. fixes #2975
Michael Bayer
0.8.5
Michael Bayer
2014
Michael Bayer
- isolate this failure as only on 0.8, only in py3.3, just comment it out, not really worth tracking down
Michael Bayer
- Added an additional message to psycopg2 disconnect detection, "could not send data to server", which complements the existing "could not receive data from server" and has been observed by users, fixes #2936
Michael Bayer
- add a topological rule here to place PARTITIONS after PARTITION_BY, for output consistency within the tests as well as in practice
Michael Bayer
restore check ahead of the lock to avoid locking when not needed
Michael Bayer
- add improved support here for string parsing of predicates, backport from 0.9
Michael Bayer
- Support has been improved for Postgresql reflection behavior on very old (pre 8.1) versions of Postgresql, and potentially other PG engines such as Redshift (assuming Redshift reports the version as < 8.1). The query for "indexes" as well as "primary keys" relies upon inspecting a so-called "int2vector" datatype, which refuses to coerce to an array prior to 8.1 causing failures regarding the "ANY()" operator used in the query. Extensive googling has located the very hacky, but recommended-by-PG-core-developer query to use when PG version < 8.1 is in use, so index and primary key constraint reflection now work on these versions. Conflicts: doc/build/changelog/changelog_09.rst test/dialect/postgresql/test_types.py
Michael Bayer
- Added new MySQL-specific :class:`.mysql.DATETIME` which includes fractional seconds support; also added fractional seconds support to :class:`.mysql.TIMESTAMP`. DBAPI support is limited, though fractional seconds are known to be supported by MySQL Connector/Python. Patch courtesy Geert JM Vanderkelen. #2941
Michael Bayer
changelog for pullreq 12
Marcus McCurdy
Fixes MySQL dialect partitioning
Michael Bayer
- Fixed bug where calling :meth:`.Insert.values` with an empty list or tuple would raise an IndexError. It now produces an empty insert construct as would be the case with an empty dictionary. Conflicts: lib/sqlalchemy/sql/dml.py
Michael Bayer
- Fixed a critical regression caused by 🎫`2880` where the newly concurrent ability to return connections from the pool means that the "first_connect" event is now no longer synchronized either, thus leading to dialect mis-configurations under even minimal concurrency situations. Conflicts: lib/sqlalchemy/event/attr.py
Michael Bayer
- update mysql connector python link, #2938
Michael Bayer
- changelog for pullreq github:72.
Michael Bayer
Merge branch 'fix_sqlite_uc_reflection' of https://github.com/malor/sqlalchemy into t
Michael Bayer
- extensive cross-linking of relationship options with their documentation sections - convert all paramter references in relationship documentation to :paramref: Conflicts: doc/build/orm/relationships.rst lib/sqlalchemy/ext/declarative/__init__.py lib/sqlalchemy/orm/relationships.py
Michael Bayer
- add cross-linking for passive_deletes / passive_updates
Michael Bayer
- add documentation regarding native hstore flag, psycopg2 hstore extension. #2959
Michael Bayer
- expand docs on MySQL table arguments beyond just storage engines - clarify section on "foreign key reflection" and group this in a section that refers to foreign keys.
Michael Bayer
- Revised this very old issue where the Postgresql "get primary key" reflection query were updated to take into account primary key constraints that were renamed; the newer query fails on very old versions of Postgresql such as version 7, so the old query is restored in those cases when server_version_info < (8, 0) is detected. #2291
Roman Podoliaka
Fix unique constraints reflection in SQLite Reflection of unique constraints didn't work properly, if reserved identifiers had been used as column names. In this case column names would be put in double quotes (e.g. the name of column asc would be returned as "asc"). This issue is only present in 0.8.4 and not in 0.9.x.
Michael Bayer
- Fixed bug where :meth:`.in_()` would go into an endless loop if erroneously passed a column expression whose comparator included the ``__getitem__()`` method, such as a column that uses the :class:`.postgresql.ARRAY` type. [ticket:2957]
Michael Bayer
this example doesn't work, we don't really have a solution for this as far as automating this pattern
Michael Bayer
- dont need these extra conditions from the previous test
Michael Bayer
- Fixed bug where :meth:`.Query.get` would fail to consistently raise the :class:`.InvalidRequestError` that invokes when called on a query with existing criterion, when the given identity is already present in the identity map. [ticket:2951]
Michael Bayer
- this seems to be the best string for pymysql
Michael Bayer
- Fixed bug which prevented MySQLdb-based dialects (e.g. pymysql) from working in Py3K, where a check for "connection charset" would fail due to Py3K's more strict value comparison rules. The call in question wasn't taking the database version into account in any case as the server version was still None at that point, so the method overall has been simplified to rely upon connection.character_set_name(). [ticket:2933]
Michael Bayer
- add a few missing methods to the cymysql dialect
Michael Bayer
- don't duplicate docs for Pool within QueuePool - add huge warning regarding how use_threadlocal probably not what you want
Michael Bayer
changelog
Michael Bayer
no Binary here if we are running a test with no DBAPI
Michael Bayer
Merge branch 'fix-convenience-import' of github.com:witsch/sqlalchemy into t
Michael Bayer
- add a test for pullreq github:63
Andreas Zeidler
expose `binary_type` in `util` module it is used in `sql/compiler.py(849)render_literal_value()`
Michael Bayer
- add a test for [ticket:2927], which is an 0.9 issue but only because 0.8 isn't annotating correctly
Michael Bayer
- repair the fixture/test here to make sure state isn't left over causing other tests to fail
Michael Bayer
docs
Michael Bayer
updates
Michael Bayer
tweak text
Michael Bayer
seealsos in the tutorial Conflicts: lib/sqlalchemy/sql/selectable.py
Michael Bayer
imports
Michael Bayer
case
Michael Bayer
- start building out very comprehensive docstrings for core functions
Michael Bayer
docuemnt join
Michael Bayer
- doc updates, include links to create_engine from tutorials, cleanup and modernize the engines chapter a bit Conflicts: doc/build/changelog/changelog_09.rst doc/build/orm/tutorial.rst
Michael Bayer
- add tests for [ticket:2918], confirm this is an 0.9 regression
Wichert Akkerman
Remove uneeded import from code example This had me reread the code twice to see if I missed why the import was present.
Michael Bayer
fix typo
Wichert Akkerman
Fix a typo in the relationship docs The text refers to ``boston_addresses``, while the code sample uses ``addresses``.
Michael Bayer
attic
Michael Bayer
akiban-> foundationdb Conflicts: doc/build/dialects/index.rst
Michael Bayer
- changelog + test for pullreq github 58
Kyle Stark
Fix TypeError for class_mapper called w/ iterable When the class_ passed is not a mapped class but is actually an iterable, the string formatting operation fails with a TypeError, and the expected ArgumentError is not raised. Calling code which is using reflection and expects this error will fail (e.g. the sadisplay module). Conflicts: lib/sqlalchemy/orm/base.py
Michael Bayer
pyo
Michael Bayer
- add paramlinks and external changelog ext to 0.8
Michael Bayer
- support addition of fails_if()/only_on(), just wraps the decorators - update a few exclusions to support current pymssql. passes all of test_suite and dialect/mssql
Michael Bayer
- apply a similar fix for floats to mssql+pyodbc as we did to firebird - wrangle through osx+pyodbc+freetds to get at least test_suite to pass again with mssql+pyodbc. invovled adding some silly requirements
Michael Bayer
- fix the insert from select test to use a non-autoinc table
Ben Alpert
session docs: Change `object` to `someobject` This makes the code block more consistent with the preceding one and also prevents the variable from being colored as a builtin (which `object` is) during syntax highlighting.
Michael Bayer
- actually check the list of views!
Michael Bayer
fix 2.5-ism
Michael Bayer
test hanging on 0.8, suspecting the test framework. this feature is tested on 0.9 successfully
Michael Bayer
- add an exclusion for "floats to four decimals", backported from 0.9 and applies to firebird
Michael Bayer
- The firebird dialect will quote identifiers which begin with an underscore. Courtesy Treeve Jelbert. [ticket:2897]
Michael Bayer
- add a test which creates tables and views at the same time, then tests that the lists of each can be reflected independently. Testing [ticket:2898] at the moment.
Michael Bayer
- Fixed bug in Firebird index reflection where the columns within the index were not sorted correctly; they are now sorted in order of RDB$FIELD_POSITION.
Michael Bayer
- The "asdecimal" flag used with the :class:`.Float` type will now work with Firebird dialects; previously the decimal conversion was not occurring. - scale back some firebird FP numeric tests Conflicts: test/requirements.py
Michael Bayer
- repair some suite tests for firebird
Michael Bayer
changelog, will merge to 0.8
sontek
Remove terminated connections from the pool. In pymssql, if you terminate a long running query manually it will give you a connection reset by peer message, but this connection remains in the pool and will be re-used.
Michael Bayer
- Fixed issue where a primary key column that has a Sequence on it, yet the column is not the "auto increment" column, either because it has a foreign key constraint or ``autoincrement=False`` set, would attempt to fire the Sequence on INSERT for backends that don't support sequences, when presented with an INSERT missing the primary key value. This would take place on non-sequence backends like SQLite, MySQL. [ticket:2896]
Michael Bayer
- Fixed bug with :meth:`.Insert.from_select` method where the order of the given names would not be taken into account when generating the INSERT statement, thus producing a mismatch versus the column names in the given SELECT statement. Also noted that :meth:`.Insert.from_select` implies that Python-side insert defaults cannot be used, since the statement has no VALUES clause. [ticket:2895]
Michael Bayer
autoincrement here
Michael Bayer
- for [ticket:2651], leaving CheckConstraint alone, preferring to keep backwards compatibility. A note about backslashing escapes is added. Because the Text() construct now supports bind params better, the example given in the code raises an exception now, so that should cover us. The exception itself has been enhanced to include the key name of the bound param. We're backporting this to 0.8 but 0.8 doesn't have the text->bind behavior that raises. Conflicts: lib/sqlalchemy/sql/schema.py
Michael Bayer
- An adjustment to the :func:`.subqueryload` strategy which ensures that the query runs after the loading process has begun; this is so that the subqueryload takes precedence over other loaders that may be hitting the same attribute due to other eager/noload situations at the wrong time. [ticket:2887]
Michael Bayer
- fix up the FAQ regarding the "foo_id" issue - add session object states to the glossary Conflicts: doc/build/glossary.rst
Michael Bayer
- Fixed bug when using joined table inheritance from a table to a select/alias on the base, where the PK columns were also not same named; the persistence system would fail to copy primary key values from the base table to the inherited table upon INSERT. [ticket:2885]
Michael Bayer
wrong method name...
Michael Bayer
load_on_pending is different from enable_relationship_loading and should not be superseded. both have a potential use. Conflicts: lib/sqlalchemy/orm/relationships.py
Michael Bayer
make the error message for [ticket:2889] more accurate, as we support composites to many-to-ones now also
Michael Bayer
- :func:`.composite` will raise an informative error message when the columns/attribute (names) passed don't resolve to a Column or mapped attribute (such as an erroneous tuple); previously raised an unbound local. [ticket:2889] Conflicts: test/orm/test_composites.py
Michael Bayer
- Error message when a string arg sent to :func:`.relationship` which doesn't resolve to a class or mapper has been corrected to work the same way as when a non-string arg is received, which indicates the name of the relationship which had the configurational error. [ticket:2888] Conflicts: lib/sqlalchemy/orm/relationships.py
Michael Bayer
sqlany dialect moves to github Conflicts: doc/build/dialects/index.rst
Michael Bayer
Merge branch 'rel_0_8' of /Users/classic/dev/sqlalchemy into rel_0_8
Michael Bayer
forgot authors!!
Michael Bayer
0.8.4 prep
Michael Bayer
python2.5 fix
Michael Bayer
- documentation cleanup in ORM including [ticket:2816] Conflicts: lib/sqlalchemy/orm/mapper.py
Michael Bayer
specify run as module here
Michael Bayer
- remove verbiage about "namespaces" from the dogpile example, [ticket:2862] - fix broken py2k/py3k isms
Michael Bayer
- A DBAPI that raises an error on ``connect()`` which is not a subclass of dbapi.Error (such as ``TypeError``, ``NotImplementedError``, etc.) will propagate the exception unchanged. Previously, the error handling specific to the ``connect()`` routine would both inappropriately run the exception through the dialect's :meth:`.Dialect.is_disconnect` routine as well as wrap it in a :class:`sqlalchemy.exc.DBAPIError`. It is now propagated unchanged in the same way as occ…
Michael Bayer
- restore having the connection closed before decrementing the overflow counter
Michael Bayer
- The :class:`.QueuePool` has been enhanced to not block new connection attempts when an existing connection attempt is blocking. Previously, the production of new connections was serialized within the block that monitored overflow; the overflow counter is now altered within it's own critical section outside of the connection process itself. [ticket:2880]
Michael Bayer
- Made a slight adjustment to the logic which waits for a pooled connection to be available, such that for a connection pool with no timeout specified, it will every half a second break out of the wait to check for the so-called "abort" flag, which allows the waiter to break out in case the whole connection pool was dumped; normally the waiter should break out due to a notify_all() but it's possible this notify_all() is missed in very slim cases. This is an ext…
Michael Bayer
- changelog + test for pullreq #7, MSSQL dialect for DROP INDEX
Derek Harland
Fix MSSQL dialects visit_drop_index to use the correct DDL
Michael Bayer
fix for 2.5
Michael Bayer
- move tests for unique constraints to dialect suite, including requirements etc., just like 0.9
Roman Podoliaka
- backport unique constraints reflection to 0.8.4, thereby assisting with alembic installations that have upgraded and are dealing with PG index/unique constraint reflection. Inspection API already supports reflection of table indexes information and those also include unique constraints (at least for PostgreSQL and MySQL). But it could be actually useful to distinguish between indexes and plain unique constraints (though both are implemented in the same way internally in RDBMS). This change adds a new method to Inspection API - get_unique_constraints() and implements…
Michael Bayer
- Added ORA-02396 "maximum idle time" error code to list of "is disconnect" codes with cx_oracle. [ticket:2864]
Michael Bayer
- the pronoun removal commit. there was only one instance of a standalone gendered pronoun with a gender-neutral subject, but also have replaced all occurences of "his/her", "his or her", etc. The docs have always strived to account for both genders in any non-specific singular pronoun, however recent controversy in the community suggests that a zero-gendered-pronoun policy is probably best going forward.
Michael Bayer
- reduce verbiage in mutation.py regarding legacy style, place under versionadded Conflicts: lib/sqlalchemy/ext/mutable.py
Michael Bayer
Merge pull request #47 from yoloseem/patch-2 Fixed a syntax error in example code.
Michael Bayer
-be more agnostic of quotes here Conflicts: test/engine/test_execute.py
Michael Bayer
- Fixed bug where SQL statement would be improperly ASCII-encoded when a pre-DBAPI :class:`.StatementError` were raised within :meth:`.Connection.execute`, causing encoding errors for non-ASCII statements. The stringification now remains within Python unicode thus avoiding encoding errors. [ticket:2871] Conflicts: test/engine/test_execute.py
Michael Bayer
Fixed bug where Oracle ``VARCHAR`` types given with no length (e.g. for a ``CAST`` or similar) would incorrectly render ``None CHAR`` or similar. [ticket:2870]
Michael Bayer
- cleanup
Michael Bayer
disable this test for py3k, this is better fixed in 0.9
Michael Bayer
py3k fix for non-ascii SQL strings
Michael Bayer
- Fixed bug which prevented the ``serializer`` extension from working correctly with table or column names that contain non-ASCII characters. [ticket:2869] Conflicts: lib/sqlalchemy/ext/serializer.py lib/sqlalchemy/sql/selectable.py lib/sqlalchemy/testing/assertions.py
Michael Bayer
- add a sanity-check test for repr(), comparing against what we get in 0.9 for [ticket:2868]
Hyunjun Kim
Fixed a syntax error in example code.
Michael Bayer
- apply a timeout to all join() calls for test_pool - use thread.join() for waiters_handled test Conflicts: test/engine/test_pool.py
Michael Bayer
sync up some changes for #2604 and #2607 from 0.7.10, 0.8.0b2
Michael Bayer
sync up the 07/08 changelogs from master
Michael Bayer
add start-line here to avoid RST parse errors
vrajmohan
Fix cross references
vrajmohan
Add undocumented members to resolve cross references
vrajmohan
Ensure API generation
vrajmohan
Ensure API generation and fix cross references
vrajmohan
Ensure API doc for make_url and resolve references
vrajmohan
Suppress warnings about files not being included in any toctree
vrajmohan
Fix indentation and escape *args and **kwargs
vrajmohan
Fix indentation and escape *args and **kwargs
Michael Bayer
add sap sqlanywhere
Michael Bayer
css updates to better work with RTD badge
Michael Bayer
- add a section re: using column_reflect for mapping, link to it from the "naming columns distinctly" and "column_prefix" sections since this is often what ppl are looking for. [ticket:2856] is related.
Michael Bayer
- Fixed a regression introduced by 🎫`2818` where the EXISTS query being generated would produce a "columns being replaced" warning for a statement with two same-named columns, as the internal SELECT wouldn't have use_labels set.
Michael Bayer
merge the same fix from master
Michael Bayer
no such thing as default_strategy()...
Michael Bayer
fix to the changelog system for when there's no change recs in the body
Michael Bayer
- Fixed bug where index reflection would mis-interpret indkey values when using the pypostgresql adapter, which returns these values as lists vs. psycopg2's return type of string. [ticket:2855] Conflicts: doc/build/changelog/changelog_09.rst lib/sqlalchemy/__init__.py
Michael Bayer
- farm out everthing to do with rtd out to the sqlalchemy.org site
Michael Bayer
0.8.3 release
Michael Bayer
- Fixed bug where Oracle table reflection using synonyms would fail if the synonym and the table were in different remote schemas. Patch to fix courtesy Kyle Derr. [ticket:2853]
Michael Bayer
- The regexp used by the :func:`.url.make_url` function now parses ipv6 addresses, e.g. surrounded by brackets. [ticket:2851]
Michael Bayer
- Fixed bug where :func:`.type_coerce` would not interpret ORM elements with a ``__clause_element__()`` method properly. [ticket:2849] Conflicts: lib/sqlalchemy/sql/elements.py
Michael Bayer
fix python 2.5 ism
Michael Bayer
- add a type_coerce() step within Enum, Boolean to the CHECK constraint, so that the custom type isn't exposed to an operation that is against the "impl" type's constraint, [ticket:2842] - this change showed up as some recursion overflow in pickling with labels, add a __reduce__() there....pickling of expressions is less and less something that's very viable... Conflicts: lib/sqlalchemy/sql/elements.py lib/sqlalchemy/sql/sqltypes.py
Michael Bayer
- attempt to clarify what mutable extension does for HSTORE, [ticket:2803]
Michael Bayer
- add a "limitations of reflection" section, [ticket:2233] Conflicts: doc/build/core/reflection.rst
Michael Bayer
use sets here to eliminate ordering as a factor
Michael Bayer
- Removed a 128-character truncation from the reflection of the server default for a column; this code was original from PG system views which truncated the string for readability. [ticket:2844]
Michael Bayer
- The change in 🎫`2721`, which is that the ``deferrable`` keyword of :class:`.ForeignKeyConstraint` is silently ignored on the MySQL backend, will be reverted as of 0.9; this keyword will now render again, raising errors on MySQL as it is not understood - the same behavior will also apply to the ``initially`` keyword. In 0.8, the keywords will remain ignored but a warning is emitted. Additionally, the ``match`` keyword now raises a :class:`.CompileError` on 0.9 and emits a warning on 0.8; this keyword is not only silently ignored by MySQL but also breaks the ON UPDATE/ON DELETE options. To use a :class:`.ForeignKeyConstraint` that does not render or renders differently on MySQL, use a custom compilation option. An example of this usage has been added to the documentation, see :ref:`mysql_foreign_keys`. [ticket:2721] [ticket:2839]
Michael Bayer
The ``.unique`` flag on :class:`.Index` could be produced as ``None`` if it was generated from a :class:`.Column` that didn't specify ``unique`` (where it defaults to ``None``). The flag will now always be ``True`` or ``False``. [ticket:2825] Conflicts: lib/sqlalchemy/sql/schema.py
Michael Bayer
workaround for #2838 here. still need to figure out why an ENUM test is suddenly hitting this.
Michael Bayer
alphabetical ordering
Michael Bayer
- Added new option to :func:`.relationship` ``distinct_target_key``. This enables the subquery eager loader strategy to apply a DISTINCT to the innermost SELECT subquery, to assist in the case where duplicate rows are generated by the innermost query which corresponds to this relationship (there's not yet a general solution to the issue of dupe rows within subquery eager loading, however, when joins outside of the innermost subquery produce dupes). When the flag is set to ``True``, the DISTINCT is rendered unconditionally, and when it is set to ``None``, DISTINCT is rendered if the innermost relationship targets columns that do not comprise a full primary key. The option defaults to False in 0.8 (e.g. off by default in all cases), None in 0.9 (e.g. automatic by default). Thanks to Alex… Conflicts: lib/sqlalchemy/orm/relationships.py
Michael Bayer
MySQL-connector dialect now allows options in the create_engine query string to override those defaults set up in the connect, including "buffered" and "raise_on_warnings". [ticket:2515]
Michael Bayer
Parenthesis will be applied to a compound SQL expression as rendered in the column list of a CREATE INDEX statement. [ticket:2742]
Michael Bayer
- Fixed bug in default compiler plus those of postgresql, mysql, and mssql to ensure that any literal SQL expression values are rendered directly as literals, instead of as bound parameters, within a CREATE INDEX statement. [ticket:2742] - don't need expression_as_ddl(); literal_binds and include_table take care of this functionality. Conflicts: lib/sqlalchemy/sql/util.py
Michael Bayer
A :func:`.select` that is made to refer to itself in its FROM clause, typically via in-place mutation, will raise an informative error message rather than causing a recursion overflow. [ticket:2815] Conflicts: lib/sqlalchemy/sql/selectable.py
Michael Bayer
Fixed bug where using an annotation such as :func:`.remote` or :func:`.foreign` on a :class:`.Column` before association with a parent :class:`.Table` could produce issues related to the parent table not rendering within joins, due to the inherent copy operation performed by an annotation. [ticket:2813] Conflicts: lib/sqlalchemy/sql/elements.py
Michael Bayer
Non-working "schema" argument on :class:`.ForeignKey` is deprecated; raises a warning. Removed in 0.9. [ticket:2831]
Michael Bayer
Merge pull request #32 from yoloseem/patch-1 Fix a typo: evaluted -> evaluated.
Hyunjun Kim
Fix a typo: evaluted -> evaluated.
Michael Bayer
- add monetdb - break out into "production" and "experimental"
Michael Bayer
- put exact version string in the test - use match with a .* preceding instead of search
Michael Bayer
changelog
166 commits not shown.