sqlalchemy-commits

[Sqlalchemy-commits] commit/sqlalchemy: 13 new changesets

[Bitbucket <com...@bi...>]

13 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/4932c7b0e31e/
Changeset:   4932c7b0e31e
Branch:      None
User:        zzzeek
Date:        2013-08-07 02:10:15
Summary:     sort of the basic idea in sql, at least break up expression, this has a super long
way to go though...

Affected #:  12 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/801bc6470864/
Changeset:   801bc6470864
Branch:      None
User:        zzzeek
Date:        2013-08-08 15:26:28
Summary:     moving around

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/6469b27702c7/
Changeset:   6469b27702c7
Branch:      None
User:        zzzeek
Date:        2013-08-08 22:40:00
Summary:     move func

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/7a9a2b1bce66/
Changeset:   7a9a2b1bce66
Branch:      None
User:        zzzeek
Date:        2013-08-10 17:46:03
Summary:     dev

Affected #:  4 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/d29f78f7ee29/
Changeset:   d29f78f7ee29
Branch:      None
User:        zzzeek
Date:        2013-08-10 17:46:14
Summary:     dev

Affected #:  6 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/ca3b620dc3f0/
Changeset:   ca3b620dc3f0
Branch:      None
User:        zzzeek
Date:        2013-08-11 19:07:19
Summary:     this version is pretty ridiculous but at the moment everything in sqlalchemy.sql is importable
with almost no "importlaters".  nothing is going to work though and this is way too many
files.

Affected #:  13 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/919f19c2ff0d/
Changeset:   919f19c2ff0d
Branch:      None
User:        zzzeek
Date:        2013-08-11 19:42:29
Summary:     rework annotations so that no import cycles are needed; clarify
class registration

Affected #:  6 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/548569c98aff/
Changeset:   548569c98aff
Branch:      None
User:        zzzeek
Date:        2013-08-11 20:24:52
Summary:     closing loops...

Affected #:  6 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/4fe06acc975d/
Changeset:   4fe06acc975d
Branch:      None
User:        zzzeek
Date:        2013-08-11 21:38:34
Summary:     working dependencies, compiler operation is back online

Affected #:  15 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/591d4efc65ec/
Changeset:   591d4efc65ec
Branch:      None
User:        zzzeek
Date:        2013-08-11 21:57:49
Summary:     - figure out operations, needed to add another intermediary.  still need to figure out how
to make BOOLEANTYPE global

Affected #:  5 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/3c8965f95bfb/
Changeset:   3c8965f95bfb
Branch:      None
User:        zzzeek
Date:        2013-08-11 22:09:40
Summary:     work out boolean

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/7140a264db52/
Changeset:   7140a264db52
Branch:      None
User:        zzzeek
Date:        2013-08-11 23:51:11
Summary:     - start doing a new approach to factory functions and documentation where
we can in many cases link to the __init__ of the class with no impact
on the API documentation.   no more need to repeat the docstrings between
the factory function and the constructor.

Affected #:  6 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/13afe281668d/
Changeset:   13afe281668d
Branch:      refactor_modules
User:        zzzeek
Date:        2013-08-12 00:36:03
Summary:     reworking...

Affected #:  19 files

Repository URL: https://bitbucket.org/zzzeek/sqlalchemy/

--

This is a commit notification from bitbucket.org. You are receiving
this because you have the service enabled, addressing the recipient of
this email.

[Sqlalchemy-commits] commit/sqlalchemy: 13 new changesets

[Bitbucket <com...@bi...>]

13 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/0cba61d150b8/
Changeset:   0cba61d150b8
Branch:      None
User:        zzzeek
Date:        2013-12-27 19:05:32
Summary:     - repair some suite tests for firebird

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/4798fd947f47/
Changeset:   4798fd947f47
Branch:      None
User:        zzzeek
Date:        2013-12-27 19:16:48
Summary:     - 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

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/545df6b39ee5/
Changeset:   545df6b39ee5
Branch:      None
User:        zzzeek
Date:        2013-12-27 19:20:58
Summary:     - 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.

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/a51c41e6305c/
Changeset:   a51c41e6305c
Branch:      None
User:        zzzeek
Date:        2013-12-27 19:28:18
Summary:     - 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.

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/92a1426c06c4/
Changeset:   92a1426c06c4
Branch:      master
User:        zzzeek
Date:        2013-12-27 19:40:27
Summary:     - The firebird dialect will quote identifiers which begin with an
underscore.  Courtesy Treeve Jelbert. [ticket:2897]

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/17f4b8f829df/
Changeset:   17f4b8f829df
Branch:      rel_0_9
User:        zzzeek
Date:        2013-12-27 19:40:55
Summary:     Merge branch 'master' into rel_0_9

Affected #:  8 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/2900b6e4ece2/
Changeset:   2900b6e4ece2
Branch:      None
User:        zzzeek
Date:        2013-12-27 19:41:21
Summary:     - repair some suite tests for firebird

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/b5b84ae20d18/
Changeset:   b5b84ae20d18
Branch:      None
User:        zzzeek
Date:        2013-12-27 19:41:46
Summary:     - 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

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/320bc4861ccd/
Changeset:   320bc4861ccd
Branch:      None
User:        zzzeek
Date:        2013-12-27 19:42:28
Summary:     - 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.

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/ab1ab82f1618/
Changeset:   ab1ab82f1618
Branch:      None
User:        zzzeek
Date:        2013-12-27 19:42:36
Summary:     - 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.

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/c24e825c37d9/
Changeset:   c24e825c37d9
Branch:      None
User:        zzzeek
Date:        2013-12-27 19:42:43
Summary:     - The firebird dialect will quote identifiers which begin with an
underscore.  Courtesy Treeve Jelbert. [ticket:2897]

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/819ad89276f2/
Changeset:   819ad89276f2
Branch:      None
User:        zzzeek
Date:        2013-12-27 19:45:07
Summary:     - add an exclusion for "floats to four decimals", backported from 0.9 and applies to
firebird

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/4a4a4beffb65/
Changeset:   4a4a4beffb65
Branch:      rel_0_8
User:        zzzeek
Date:        2013-12-27 19:47:31
Summary:     test hanging on 0.8, suspecting the test framework. this feature is tested on 0.9 successfully

Affected #:  1 file

Repository URL: https://bitbucket.org/zzzeek/sqlalchemy/

--

This is a commit notification from bitbucket.org. You are receiving
this because you have the service enabled, addressing the recipient of
this email.

[Sqlalchemy-commits] commit/sqlalchemy: 13 new changesets

[Bitbucket <com...@bi...>]

13 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/338ca8e48827/
Changeset:   338ca8e48827
Branch:      None
User:        Dobes Vandermeer
Date:        2014-04-25 00:20:57
Summary:     Proof-of-concept implementation of supporting bindparam for offset and limit on a query.

Affected #:  6 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/624924d5e757/
Changeset:   624924d5e757
Branch:      None
User:        Dobes Vandermeer
Date:        2014-04-25 00:33:53
Summary:     Expand test to also test whether offset accepts a bindparam.

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/e9b398f8a6ec/
Changeset:   e9b398f8a6ec
Branch:      None
User:        Dobes Vandermeer
Date:        2014-04-25 19:22:50
Summary:     Extract limit/offset to variables

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/4af172b644d9/
Changeset:   4af172b644d9
Branch:      None
User:        Dobes Vandermeer
Date:        2014-04-25 19:42:12
Summary:     Use _offset_clause and _limit_clause, which are always Visitable and usually a BindParameter, instead of _offset and _limit in GenerativeSelect.

Affected #:  7 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/262fef0b4ac2/
Changeset:   262fef0b4ac2
Branch:      None
User:        Dobes Vandermeer
Date:        2014-04-25 19:45:38
Summary:     Remove unused import

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/a218eaee2b42/
Changeset:   a218eaee2b42
Branch:      None
User:        Dobes Vandermeer
Date:        2014-04-25 19:46:30
Summary:     Pull out offset/limit to a local variable to reduce the impact of the inefficient select._offset and select._limit operations.

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/d2643b4e5419/
Changeset:   d2643b4e5419
Branch:      None
User:        Dobes Vandermeer
Date:        2014-04-25 19:48:11
Summary:     Remove unused import

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/9f437136a36c/
Changeset:   9f437136a36c
Branch:      None
User:        Dobes Vandermeer
Date:        2014-04-25 19:48:38
Summary:     Remove unused import

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/e9ada891d825/
Changeset:   e9ada891d825
Branch:      None
User:        Dobes Vandermeer
Date:        2014-04-25 19:49:07
Summary:     Remove unused import

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/0d95386ca3ca/
Changeset:   0d95386ca3ca
Branch:      None
User:        Dobes Vandermeer
Date:        2014-04-25 19:49:39
Summary:     Remove unused import

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/9605b051b04a/
Changeset:   9605b051b04a
Branch:      None
User:        Dobes Vandermeer
Date:        2014-05-09 20:27:30
Summary:     Remove unused import

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/8414c9f00b9d/
Changeset:   8414c9f00b9d
Branch:      None
User:        zzzeek
Date:        2014-05-16 20:45:40
Summary:     Merge branch 'issue_3034' of https://bitbucket.org/dobesv/sqlalchemy/branch/issue_3034 into ticket_3034

Affected #:  10 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/81959af6d37b/
Changeset:   81959af6d37b
Branch:      ticket_3034
User:        zzzeek
Date:        2014-05-16 21:33:39
Summary:     - more tests, including backend tests
- implement for SQL server, use window functions when simple limit/offset not available

Affected #:  7 files

Repository URL: https://bitbucket.org/zzzeek/sqlalchemy/

--

This is a commit notification from bitbucket.org. You are receiving
this because you have the service enabled, addressing the recipient of
this email.

[Sqlalchemy-commits] commit/sqlalchemy: 13 new changesets

[Bitbucket <com...@bi...>]

13 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/fc73036865a0/
Changeset:   fc73036865a0
Branch:      None
User:        Gorka Eguileor
Date:        2015-09-24 13:35:13+00:00
Summary:     Preserve order in update method

In some DBs the UPDATE operation is order dependent, so the operation
behaves differently depending on the order of the values.

As an example, imagine a volumes table with columns 'status' and
'previous_status' and we want to update a volume that has 'available' in
the status column.

If the SQL query is performed as:

 UPDATE volumes SET previous_status=status, status='new' WHERE id=1;

This will result in a volume with 'new' status and 'available'
previous_status both on SQLite and MariaDB, but if we reverse the
columns:

 UPDATE volumes SET status='new', previous_status=status WHERE id=1;

We will get the same result in SQLite but will result in a volume with
status and previous_status set to 'new' in MariaDB, which is not what we
want.

So order must be taken into consideration in some cases and it should be
allowed to ve specified via the Query update method or the values method
of an update.

This patch fixes this issue by preserving the order of parameters in
updates and allowing to receive not only dictionaries in update and
values but also ordered dictionaries and list/tuples of value pairs
(like dict and OrderedDict do).

fixes #3541

Affected #:  10 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/9fb76d759678/
Changeset:   9fb76d759678
Branch:      None
User:        Gorka Eguileor
Date:        2015-09-29 18:29:33+00:00
Summary:     Only preserve order in updates if tuple/dict

To avoid penalties for updates that do not require ordering, we will
only use OrderedDict for updates that receive a tuple or list of pairs,
and all kinds of dictionaries (dict, sqlalchemy's OrderedDict, or
collections.OrderedDict) will be treateated as unordered updates, just
like we were doing before.

This way this new feature will not change how updates behave for any
existing code and will only affect those that use the new ordered
feature.

This patch reverts update tests to how they were before as well as adds
a couple of tests to confirm that OrderedDicts are really treated like
normal dicts.

Affected #:  11 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/ddb43cebf68b/
Changeset:   ddb43cebf68b
Branch:      None
User:        Gorka Eguileor
Date:        2015-09-30 16:45:05+00:00
Summary:     Postpone parameters change in ordered updates

Postpone as much as possible the change of update parameters to
OrderedDict from list or tuple of pairs.

This way we won't have problems with query's update method.

Affected #:  5 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/ef816f23290a/
Changeset:   ef816f23290a
Branch:      None
User:        Gorka Eguileor
Date:        2015-10-02 16:22:33+00:00
Summary:     Only check once if parameters are ordered

Instead of checking multiple times if parameters are a dictionary in the
form of a tuple or list of value pairs, we check it only once and then
store it in the statement so it can be used on compilation time.

Affected #:  4 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/c6ba1a7d4c2b/
Changeset:   c6ba1a7d4c2b
Branch:      None
User:        Gorka Eguileor
Date:        2015-10-05 08:42:09+00:00
Summary:     Remove dict comprehension for py26 compatibility

Remove added dict comprehensions that make this patch set non python 2.6
compatible.

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/44e5a31ccee5/
Changeset:   44e5a31ccee5
Branch:      None
User:        Gorka Eguileor
Date:        2015-10-08 11:24:02+00:00
Summary:     Reduce the numbers of calls to isinstance

Change _process_colparams method to remove duplicate isinstance calls
and try to speed up processing of the parameters.

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/1106bd3ff270/
Changeset:   1106bd3ff270
Branch:      None
User:        zzzeek
Date:        2015-11-25 23:19:36+00:00
Summary:     Merge remote-tracking branch 'origin/pr/200' into pr200

Affected #:  8 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/ab0874e893af/
Changeset:   ab0874e893af
Branch:      None
User:        zzzeek
Date:        2015-11-26 00:39:17+00:00
Summary:     - work from an "explicit is better than implicit" perspective
here and require a flag on update() to use parameter ordering
rather than table ordering.   more docs/changelog notes are needed

Affected #:  5 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/b8a825978e79/
Changeset:   b8a825978e79
Branch:      None
User:        zzzeek
Date:        2015-11-28 17:23:21+00:00
Summary:     - add tests for ordered params with onupdates

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/e9dfcd83ef43/
Changeset:   e9dfcd83ef43
Branch:      None
User:        zzzeek
Date:        2015-11-28 18:32:30+00:00
Summary:     - docs plus changelog for parameter ordered updates

Affected #:  4 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/3635408cd62a/
Changeset:   3635408cd62a
Branch:      pr200_updated
User:        zzzeek
Date:        2015-11-28 19:21:35+00:00
Summary:     - unfortunately, these are not the query.update() tests, these are
just session bind tests.  move / rework the preserve_parameter_order
tests to the appropriate module

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/b0308a7b3af9/
Changeset:   b0308a7b3af9
Branch:      None
User:        zzzeek
Date:        2015-11-29 16:42:55+00:00
Summary:     - Fixed an issue in baked queries where the .get() method, used either
directly or within lazy loads, didn't consider the mapper's "get clause"
as part of the cache key, causing bound parameter mismatches if the
clause got re-generated.  This clause is cached by mappers
on the fly but in highly concurrent scenarios may be generated more
than once when first accessed.
fixes #3597

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/670fd506fe4c/
Changeset:   670fd506fe4c
Branch:      rel_1_0
User:        zzzeek
Date:        2015-11-29 16:43:30+00:00
Summary:     - Fixed an issue in baked queries where the .get() method, used either
directly or within lazy loads, didn't consider the mapper's "get clause"
as part of the cache key, causing bound parameter mismatches if the
clause got re-generated.  This clause is cached by mappers
on the fly but in highly concurrent scenarios may be generated more
than once when first accessed.
fixes #3597

(cherry picked from commit b0308a7b3af91cc61fbe3347376024ad8b7be019)

Affected #:  3 files

Repository URL: https://bitbucket.org/zzzeek/sqlalchemy/

--

This is a commit notification from bitbucket.org. You are receiving
this because you have the service enabled, addressing the recipient of
this email.

[Sqlalchemy-commits] commit/sqlalchemy: 13 new changesets

[Bitbucket <com...@bi...>]

13 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/84974cf09220/
Changeset:   84974cf09220
Branch:      pr_github_284
User:        RazerM
Date:        2016-06-13 14:31:18+00:00
Summary:     Comment support

Implementation of [#1546 (BitBucket)](https://bitbucket.org/zzzeek/sqlalchemy/issues/1546).

Very unfinished but I have reflection and setting after table creation working for PostgreSQL.

If you're not opposed, perhaps best to continue discussion on Gerrit?

Change-Id: Ib90683850805a2b4ee198e420dc294f32f15d35d
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/284

Affected #:  9 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/bb74ce0a2d13/
Changeset:   bb74ce0a2d13
Branch:      pypy_run
User:        zzzeek
Date:        2016-06-17 15:27:07+00:00
Summary:     Get pypy to run

Change-Id: Idf8d66c5d65ca7cadf1d04d04441c957f5dc8f51

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/ae41612744a5/
Changeset:   ae41612744a5
Branch:      ticket_3730
User:        zzzeek
Date:        2016-06-23 23:42:56+00:00
Summary:     Make boolean processors consistent between Py/C; coerce to 1/0

The processing performed by the :class:`.Boolean` datatype for backends
that only feature integer types has been made consistent between the
pure Python and C-extension versions, in that the C-extension version
will accept any integer value from the database as a boolean, not just
zero and one; additionally, non-boolean integer values being sent to
the database are rejected if they are outside of the range 1 / 0,
without requiring the use of a CHECK constraint.

Change-Id: I01e647547fd7047bd549dd70e1fa202c51e8328b
Fixes: #3730

Affected #:  6 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/b867915cd02f/
Changeset:   b867915cd02f
Branch:      pr_github_285
User:        huhushow
Date:        2016-06-27 14:40:30+00:00
Summary:     add bind processor and result prosseor for DATETIMEOFFSET

datetimeoffset is timezone aware type of mssql
this is simple version of ms datetimeoffset support

Change-Id: I8fba989355903935ce72598b16447925648f1002
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/285

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/20fe9ad17131/
Changeset:   20fe9ad17131
Branch:      None
User:        pieterproigia
Date:        2016-06-29 15:15:44+00:00
Summary:     Fix #3728 Pickle of Properties object fails

Change-Id: I01ebd425bbfe145747fea2edd0d2d412c74fd84d
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/286

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/cab57e9bab04/
Changeset:   cab57e9bab04
Branch:      ticket_3728
User:        pieterproigia
Date:        2016-06-29 19:46:40+00:00
Summary:     Repair pickling for Properties object

Fixed bug whereby the ``__getstate__`` / ``__setstate__``
methods for sqlalchemy.util.Properties were
non-working due to the transition in the 1.0 series to ``__slots__``.
The issue potentially impacted some third-party applications.
Pull request courtesy Pieter Mulder.

Fixes: #3728
Change-Id: I01ebd425bbfe145747fea2edd0d2d412c74fd84d
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/286

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/8feba9a25f48/
Changeset:   8feba9a25f48
Branch:      ticket_3737
User:        zzzeek
Date:        2016-07-04 20:10:47+00:00
Summary:     Double percent signs based on paramstyle, not dialect

This patch moves the "doubling" of percent signs into
the base compiler and makes it completely a product
of whether or not the paramstyle is format/pyformat or
not.   Without this paramstyle, percent signs
are not doubled across text(), literal_column(), and
column().

Change-Id: Ie2f278ab1dbb94b5078f85c0096d74dbfa049197
Fixes: #3740

Affected #:  4 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/d23797943786/
Changeset:   d23797943786
Branch:      ticket_3741
User:        zzzeek
Date:        2016-07-05 16:56:50+00:00
Summary:     Adapt "FOR UPDATE OF" with Oracle limit/offset

This modifies the Oracle ROWNUM limit/offset approach
to accommodate for the "OF" clause in a "FOR UPDATE"
phrase.  The column expressions must be added to the selected
subquery if necessary and adapted on the outside.

Change-Id: Ia71b5fc4df6d326e73863f8ae9f96e8f1a5acfc1
Fixes: #3741

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/271d4e9e712b/
Changeset:   271d4e9e712b
Branch:      ticket_3741_10
User:        zzzeek
Date:        2016-07-05 16:58:51+00:00
Summary:     Adapt "FOR UPDATE OF" with Oracle limit/offset

This modifies the Oracle ROWNUM limit/offset approach
to accommodate for the "OF" clause in a "FOR UPDATE"
phrase.  The column expressions must be added to the selected
subquery if necessary and adapted on the outside.

Change-Id: Ia71b5fc4df6d326e73863f8ae9f96e8f1a5acfc1
Fixes: #3741
(cherry picked from commit d23797943786914cced58ed71ffb7b749e64c449)

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/65c8929aae61/
Changeset:   65c8929aae61
Branch:      review/jeong_yunwon/index-property-default
User:        youknowone
Date:        2016-07-05 22:21:47+00:00
Summary:     Add `default` parameter for `index_property`

And force to use keyword arguments for trivial parameters in index_property

Change-Id: I12a178128182f77a2d06b52d7e36f59a36b45a33

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/a7d95ba956ee/
Changeset:   a7d95ba956ee
Branch:      ticket_3058
User:        zzzeek
Date:        2016-07-06 19:35:45+00:00
Summary:     Support per-query expressions in column properties

Adds an option to undefer() and the corresponding strategy
to pull in an ad-hoc, per query expression in for a column
based on options.

Still to be determined is if column_property() itself, or
some variant, would be allowed to have a dynamically generated
expression at the class level as well; use case here are exotic
expressions such as those using CTEs which benefit from
being generated on demand.

This is a WIP with no tests or documentation as of yet.

Change-Id: Ibe22daeb7959395af36ea01299e29c89c1c8687f
Fixes: #3058

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/e9a1d7bc6a0a/
Changeset:   e9a1d7bc6a0a
Branch:      rel_1_0
User:        zzzeek
Date:        2016-07-06 21:10:19+00:00
Summary:     - 1.0.14

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/9f98070a589c/
Changeset:   9f98070a589c
Branch:      None
User:        zzzeek
Date:        2016-07-06 21:27:47+00:00
Summary:     - 1.0.14 changelog update

(cherry picked from commit e9a1d7bc6a0ae4ec09b6431d23d201654013c6a7)

Change-Id: I5bab3fd6f2ec4986fd6b1049844f3851958d0c66

Affected #:  1 file

Repository URL: https://bitbucket.org/zzzeek/sqlalchemy/

--

This is a commit notification from bitbucket.org. You are receiving
this because you have the service enabled, addressing the recipient of
this email.