sqlalchemy-commits

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

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/4b51c49dcd56/
Changeset:   4b51c49dcd56
Branch:      None
User:        zzzeek
Date:        2014-08-09 19:53:21
Summary:     - rewrite all the sqlite/pysqlite transaction isolation docs

Affected #:  4 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/cca4d8fc73df/
Changeset:   cca4d8fc73df
Branch:      None
User:        zzzeek
Date:        2014-08-09 20:03:17
Summary:     - add tests for the savepoint recipe

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/34fbeaa2146f/
Changeset:   34fbeaa2146f
Branch:      None
User:        zzzeek
Date:        2014-08-09 20:03:41
Summary:     - rewrite all the sqlite/pysqlite transaction isolation docs

Affected #:  4 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/9215c0a7532b/
Changeset:   9215c0a7532b
Branch:      rel_0_9
User:        zzzeek
Date:        2014-08-09 20:03:48
Summary:     - add tests for the savepoint recipe

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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/ad8f921e969b/
Changeset:   ad8f921e969b
Branch:      None
User:        mdiarra
Date:        2014-08-09 21:43:32
Summary:     Providing an autoload_with info automatically sets autoload to True

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/ae441810e0bc/
Changeset:   ae441810e0bc
Branch:      None
User:        zzzeek
Date:        2014-08-10 00:08:05
Summary:     - rework documentation for reflection flags; also include
information regarding #3027.

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/2c9ff9115c72/
Changeset:   2c9ff9115c72
Branch:      None
User:        zzzeek
Date:        2014-08-10 00:10:38
Summary:     - changelog, fixes #3027

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/68a7876bc35a/
Changeset:   68a7876bc35a
Branch:      rel_0_9
User:        zzzeek
Date:        2014-08-10 00:14:45
Summary:     - rework documentation for reflection flags, backport from
1.0

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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/10bb97e89a5b/
Changeset:   10bb97e89a5b
Branch:      None
User:        Ilya Pekelny
Date:        2014-08-08 09:00:17
Summary:     DropEnumType class available from postgres dialect

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/a0e0f4c289b4/
Changeset:   a0e0f4c289b4
Branch:      pr/126
User:        Ilya Pekelny
Date:        2014-08-08 09:05:30
Summary:     Public inspector method to load enum list

Provide opportunity to get enums list via an inspector instance public
interface.

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/f39767ad727f/
Changeset:   f39767ad727f
Branch:      pr126
User:        zzzeek
Date:        2014-08-13 23:42:33
Summary:     - public method name is get_enums()
- return a list of dicts like other methods do
- don't combine 'schema' with 'name', leave them separate
- support '*' argument so that we can retrieve cross-schema
if needed
- remove "conn" argument
- use bound parameters for 'schema' in SQL
- order by schema, name, label
- adapt _load_enums changes to column reflection
- changelog
- module docs for get_enums()
- add drop of enums to --dropfirst

Affected #:  4 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/190961157d0e/
Changeset:   190961157d0e
Branch:      None
User:        zzzeek
Date:        2014-08-13 23:50:50
Summary:     Merge branch 'pr126'

Conflicts:
	doc/build/changelog/changelog_10.rst

Affected #:  5 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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/38cb9bf78454/
Changeset:   38cb9bf78454
Branch:      None
User:        zzzeek
Date:        2014-08-14 00:46:44
Summary:     flake8 cleanup

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/44d21de45742/
Changeset:   44d21de45742
Branch:      None
User:        zzzeek
Date:        2014-08-14 00:47:52
Summary:     - rename _InspectionAttr to InspectionAttr

Affected #:  10 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/ea85c7053dc9/
Changeset:   ea85c7053dc9
Branch:      None
User:        zzzeek
Date:        2014-08-14 01:20:44
Summary:     - The :meth:`.InspectionAttr.info` collection is now moved down to
:class:`.InspectionAttr`, where in addition to being available
on all :class:`.MapperProperty` objects, it is also now available
on hybrid properties, association proxies, when accessed via
:attr:`.Mapper.all_orm_descriptors`.
fixes #2971

Affected #:  4 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/7fc08fe89af9/
Changeset:   7fc08fe89af9
Branch:      None
User:        zzzeek
Date:        2014-08-14 01:45:34
Summary:     - The ``info`` parameter has been added to the constructor for
:class:`.SynonymProperty` and :class:`.ComparableProperty`.
- The ``info`` parameter has been added as a constructor argument
to all schema constructs including :class:`.MetaData`,
:class:`.Index`, :class:`.ForeignKey`, :class:`.ForeignKeyConstraint`,
:class:`.UniqueConstraint`, :class:`.PrimaryKeyConstraint`,
:class:`.CheckConstraint`.

fixes #2963

Affected #:  6 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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/191fd3e27e3e/
Changeset:   191fd3e27e3e
Branch:      None
User:        zzzeek
Date:        2014-08-15 21:52:35
Summary:     - proof of concept

Affected #:  4 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/6bc676f56d57/
Changeset:   6bc676f56d57
Branch:      None
User:        zzzeek
Date:        2014-08-15 21:53:12
Summary:     dev

Affected #:  5 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/591f2e4ed2d4/
Changeset:   591f2e4ed2d4
Branch:      None
User:        zzzeek
Date:        2014-08-15 21:53:38
Summary:     - change to be represented as two very fast bulk_insert() and bulk_update() methods

Affected #:  6 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/877330725755/
Changeset:   877330725755
Branch:      ticket_3100
User:        zzzeek
Date:        2014-08-16 00:22:08
Summary:     - refine this enough so that _collect_insert_commands() seems
to be more than twice as fast now (.039 vs. .091); bulk_insert()
and bulk_update() do their own collection but now both call into
_emit_insert_statements() / _emit_update_statements(); the approach
seems to have no impact on insert speed, still .85 for the
insert test

Affected #:  2 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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/06dec268e53e/
Changeset:   06dec268e53e
Branch:      None
User:        zzzeek
Date:        2014-08-18 22:32:59
Summary:     - organize persistence methods in terms of generators,
narrow down argument lists and generator items for each function
down to just what each function needs.   This will help for them
to be of more multipurpose use for bulk operations

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/4ade138769a7/
Changeset:   4ade138769a7
Branch:      None
User:        zzzeek
Date:        2014-08-18 22:44:07
Summary:     - further reorganize collect_insert_commands to distinguish between
setting up given values vs. defaults.  again trying to shoot for
making this of more general use

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/4ed640ba907b/
Changeset:   4ed640ba907b
Branch:      None
User:        zzzeek
Date:        2014-08-18 23:02:52
Summary:     - move out checks for table in mapper._pks_by_table

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/399c03939768/
Changeset:   399c03939768
Branch:      None
User:        zzzeek
Date:        2014-08-18 23:15:04
Summary:     - optimize collection of cols we insert as none

Affected #:  2 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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/ce0fee6993ee/
Changeset:   ce0fee6993ee
Branch:      None
User:        zzzeek
Date:        2014-09-02 00:23:19
Summary:     Merge branch 'master' into ticket_2992

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/3bffd139fe69/
Changeset:   3bffd139fe69
Branch:      None
User:        zzzeek
Date:        2014-09-02 01:26:15
Summary:     - this is all tests passing with new behavior + tests for warnings
in core/ORM + tests for order_by behavior

Affected #:  13 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/aa22eb9a4ffd/
Changeset:   aa22eb9a4ffd
Branch:      ticket_2992
User:        zzzeek
Date:        2014-09-02 02:13:18
Summary:     - changelog, migration

Affected #:  7 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/7c6a45c480a8/
Changeset:   7c6a45c480a8
Branch:      None
User:        zzzeek
Date:        2014-09-02 02:19:54
Summary:     - The :func:`~.expression.column` and :func:`~.expression.table`
constructs are now importable from the "from sqlalchemy" namespace,
just like every other Core construct.
- The implicit conversion of strings to :func:`.text` constructs
when passed to most builder methods of :func:`.select` as
well as :class:`.Query` now emits a warning with just the
plain string sent.   The textual conversion still proceeds normally,
however.  The only method that accepts a string without a warning
are the "label reference" methods like order_by(), group_by();
these functions will now at compile time attempt to resolve a single
string argument to a column or label expression present in the
selectable; if none is located, the expression still renders, but
you get the warning again. The rationale here is that the implicit
conversion from string to text is more unexpected than not these days,
and it is better that the user send more direction to the Core / ORM
when passing a raw string as to what direction should be taken.
Core/ORM tutorials have been updated to go more in depth as to how text
is handled.
fixes #2992

Affected #:  33 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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/2c081f9a4af8/
Changeset:   2c081f9a4af8
Branch:      None
User:        zzzeek
Date:        2014-09-04 01:30:38
Summary:     - large resultsets

Affected #:  4 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/2b10aa45a101/
Changeset:   2b10aa45a101
Branch:      None
User:        zzzeek
Date:        2014-09-04 01:42:38
Summary:     - ensure literal_binds works with LIMIT clause, FOR UPDATE

Affected #:  10 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/84d4651f3dd8/
Changeset:   84d4651f3dd8
Branch:      None
User:        zzzeek
Date:        2014-09-04 01:44:40
Summary:     Merge branch 'master' into ticket_3100

Affected #:  15 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/cbef6a7d58ee/
Changeset:   cbef6a7d58ee
Branch:      ticket_3100
User:        zzzeek
Date:        2014-09-04 02:07:08
Summary:     refine

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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/356d6659b17d/
Changeset:   356d6659b17d
Branch:      None
User:        zzzeek
Date:        2014-09-05 22:28:20
Summary:     - tiny refactors #1-#5

Affected #:  4 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/583287259fbb/
Changeset:   583287259fbb
Branch:      None
User:        zzzeek
Date:        2014-09-05 22:28:32
Summary:     - delete the file first here so this is deterministic

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/d39daa43fe79/
Changeset:   d39daa43fe79
Branch:      ticket_3100
User:        zzzeek
Date:        2014-09-05 22:29:08
Summary:     Merge branch 'master' into ticket_3100

Affected #:  5 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/7b766591b05c/
Changeset:   7b766591b05c
Branch:      None
User:        zzzeek
Date:        2014-09-05 22:44:42
Summary:     - MySQL boolean symbols "true", "false" work again.  0.9's change
in :ticket:`2682` disallowed the MySQL dialect from making use of the
"true" and "false" symbols in the context of "IS" / "IS NOT", but
MySQL supports this syntax even though it has no boolean type.
MySQL remains "non native boolean", but the :func:`.true`
and :func:`.false` symbols again produce the
keywords "true" and "false", so that an expression like
``column.is_(true())`` again works on MySQL.
fixes #3186

Affected #:  4 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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/a8ef876f6c30/
Changeset:   a8ef876f6c30
Branch:      None
User:        hiaselhans
Date:        2014-09-07 22:55:05
Summary:     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

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/56e14e2e2829/
Changeset:   56e14e2e2829
Branch:      None
User:        zzzeek
Date:        2014-09-07 23:38:05
Summary:     Merge pull request #133 from hiaselhans/doc_epub

Docs: use layout.mako only when mako_layout=='html'
Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/e3a1d556fe7c/
Changeset:   e3a1d556fe7c
Branch:      rel_0_9
User:        hiaselhans
Date:        2014-09-07 23:39:38
Summary:     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

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/0264ab69885b/
Changeset:   0264ab69885b
Branch:      rel_0_8
User:        hiaselhans
Date:        2014-09-07 23:39:42
Summary:     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

Affected #:  2 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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/8b7f57d258e3/
Changeset:   8b7f57d258e3
Branch:      None
User:        zzzeek
Date:        2014-09-15 20:53:20
Summary:     - fix issue where nose Failure object comes into play here

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/2c46128a2ffa/
Changeset:   2c46128a2ffa
Branch:      None
User:        zzzeek
Date:        2014-09-15 20:57:41
Summary:     - use compat.u for python3.2, fixes #3198

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/5e856ed3cbaa/
Changeset:   5e856ed3cbaa
Branch:      None
User:        zzzeek
Date:        2014-09-15 20:59:27
Summary:     - fix issue where nose Failure object comes into play here

Conflicts:
	lib/sqlalchemy/testing/plugin/noseplugin.py

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/e55e5f3b7008/
Changeset:   e55e5f3b7008
Branch:      rel_0_9
User:        zzzeek
Date:        2014-09-15 20:59:32
Summary:     - use compat.u for python3.2, fixes #3198

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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/414bc1c64d05/
Changeset:   414bc1c64d05
Branch:      None
User:        zzzeek
Date:        2014-09-17 16:41:08+00:00
Summary:     - the actual round trip requires password authent set up for the user;
we don't actually need a round trip test here as we're only testing reflection.

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/27617986bbeb/
Changeset:   27617986bbeb
Branch:      None
User:        zzzeek
Date:        2014-09-17 16:41:55+00:00
Summary:     keep this off for the moment as jenkins isn't set up for this yet

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/be57def4b909/
Changeset:   be57def4b909
Branch:      pr128
User:        zzzeek
Date:        2014-09-17 17:11:22+00:00
Summary:     - repair get_foreign_table_names() for PGInsp/dialect level
- repair get_view_names()
- changelog + migration note

Affected #:  6 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/3a6cd72beaee/
Changeset:   3a6cd72beaee
Branch:      None
User:        zzzeek
Date:        2014-09-17 17:11:49+00:00
Summary:     Merge branch 'pr128'

Affected #:  6 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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/7fa21b22989f/
Changeset:   7fa21b22989f
Branch:      None
User:        jerdfelt
Date:        2014-09-17 20:19:50+00:00
Summary:     Reflect unique constraints when reflecting a Table object

Calls to reflect a table did not create any UniqueConstraint objects.
The reflection core made no calls to get_unique_constraints and as
a result, the sqlite dialect would never reflect any unique constraints.

MySQL transparently converts unique constraints into unique indexes, but
SQLAlchemy would reflect those as an Index object and as a
UniqueConstraint. The reflection core will now deduplicate the unique
constraints.

PostgreSQL would reflect unique constraints as an Index object and as
a UniqueConstraint object. The reflection core will now deduplicate
the unique indexes.

Affected #:  6 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/f7dee1380c40/
Changeset:   f7dee1380c40
Branch:      None
User:        zzzeek
Date:        2014-10-04 21:47:53+00:00
Summary:     Merge branch 'reflect-unique-constraints' of https://bitbucket.org/jerdfelt/sqlalchemy into pr30

Affected #:  6 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/b510b990947c/
Changeset:   b510b990947c
Branch:      None
User:        zzzeek
Date:        2014-10-04 23:06:35+00:00
Summary:     - use provide_metadata for new unique constraint / index tests
- add a test for PG reflection of unique index without any unique
constraint
- for PG, don't include 'duplicates_constraint' in the entry
if the index does not actually mirror a constraint
- use a distinct method for unique constraint reflection within table
- catch unique constraint not implemented condition; this may
be within some dialects and also is expected to be supported by
Alembic tests
- migration + changelogs for #3184
- add individual doc notes as well to MySQL, Postgreql
fixes #3184

Affected #:  7 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/c4dee4cbb7aa/
Changeset:   c4dee4cbb7aa
Branch:      None
User:        zzzeek
Date:        2014-10-04 23:10:23+00:00
Summary:     - move some things that are features to the features

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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/cc29c4afff20/
Changeset:   cc29c4afff20
Branch:      None
User:        zzzeek
Date:        2014-10-11 22:25:21+00:00
Summary:     - Fixed long-standing bug in Oracle dialect where bound parameter
names that started with numbers would not be quoted, as Oracle
doesn't like numerics in bound parameter names.
fixes #2138

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/d2997166ee07/
Changeset:   d2997166ee07
Branch:      None
User:        zzzeek
Date:        2014-10-11 22:25:54+00:00
Summary:     - Fixed long-standing bug in Oracle dialect where bound parameter
names that started with numbers would not be quoted, as Oracle
doesn't like numerics in bound parameter names.
fixes #2138

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/83e465633793/
Changeset:   83e465633793
Branch:      None
User:        zzzeek
Date:        2014-10-11 22:35:12+00:00
Summary:     - embedding an existing predicate into a new one only
seems to be used by test_oracle->test_coerce_to_unicode().  The
predicate here should treat as a lambda based on enabled_for_config.
not sure why this test is not failing on jenkins

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/19b375579e65/
Changeset:   19b375579e65
Branch:      rel_0_9
User:        zzzeek
Date:        2014-10-11 22:36:04+00:00
Summary:     - embedding an existing predicate into a new one only
seems to be used by test_oracle->test_coerce_to_unicode().  The
predicate here should treat as a lambda based on enabled_for_config.
not sure why this test is not failing on jenkins

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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/e04b693e7c7c/
Changeset:   e04b693e7c7c
Branch:      None
User:        zzzeek
Date:        2014-10-13 16:34:41+00:00
Summary:     - this test passes now in more recent mysqlconnector

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/fe0a97972624/
Changeset:   fe0a97972624
Branch:      None
User:        zzzeek
Date:        2014-10-13 16:35:02+00:00
Summary:     - this test passes now in more recent mysqlconnector

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/97553f301529/
Changeset:   97553f301529
Branch:      rel_0_9
User:        zzzeek
Date:        2014-10-13 16:37:29+00:00
Summary:     - additional issues fixed in mysqlconnector 2.0.1

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/198917237e60/
Changeset:   198917237e60
Branch:      None
User:        zzzeek
Date:        2014-10-13 16:37:42+00:00
Summary:     - additional issues fixed in mysqlconnector 2.0.1

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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/b19252373f16/
Changeset:   b19252373f16
Branch:      None
User:        zzzeek
Date:        2014-10-18 22:16:41+00:00
Summary:     - wip

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/a7c1258d0340/
Changeset:   a7c1258d0340
Branch:      None
User:        zzzeek
Date:        2014-10-19 02:32:07+00:00
Summary:     - flake8

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/ff596ddfe35d/
Changeset:   ff596ddfe35d
Branch:      rel_0_9
User:        zzzeek
Date:        2014-10-19 02:33:05+00:00
Summary:     - flake8

Conflicts:
	test/orm/test_relationships.py

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/6f35c37de31b/
Changeset:   6f35c37de31b
Branch:      ticket_3230
User:        zzzeek
Date:        2014-10-19 02:33:55+00:00
Summary:     Merge branch 'master' into ticket_3230

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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/98a011453537/
Changeset:   98a011453537
Branch:      None
User:        jona
Date:        2014-09-12 19:14:52+00:00
Summary:     add failing test

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/ba951b99a6f3/
Changeset:   ba951b99a6f3
Branch:      None
User:        jona
Date:        2014-09-16 18:19:03+00:00
Summary:     change functions

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/233d9c1bc0d3/
Changeset:   233d9c1bc0d3
Branch:      None
User:        zzzeek
Date:        2014-10-21 21:24:14+00:00
Summary:     Merge remote-tracking branch 'origin/pr/137' into pr137

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/fee776dde052/
Changeset:   fee776dde052
Branch:      None
User:        zzzeek
Date:        2014-10-21 21:27:37+00:00
Summary:     - changelog

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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/d5ecd473aeac/
Changeset:   d5ecd473aeac
Branch:      None
User:        ndparker
Date:        2014-09-23 20:52:14+00:00
Summary:     allow Table.tometadata changing the table name

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/7e0835409cf5/
Changeset:   7e0835409cf5
Branch:      None
User:        ndparker
Date:        2014-10-03 22:51:01+00:00
Summary:     add simple tests for new name argument for Table.tometadata()

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/0ae140aa989e/
Changeset:   0ae140aa989e
Branch:      None
User:        zzzeek
Date:        2014-10-21 21:29:40+00:00
Summary:     Merge remote-tracking branch 'origin/pr/139' into pr139

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/56d5732fbdf0/
Changeset:   56d5732fbdf0
Branch:      None
User:        zzzeek
Date:        2014-10-21 21:58:51+00:00
Summary:     - changelog for pullreq github:139
- add support for self-referential foreign keys to move over as well when
the table name is changed.

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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/a19b2f419cd8/
Changeset:   a19b2f419cd8
Branch:      None
User:        zzzeek
Date:        2014-11-10 22:37:26+00:00
Summary:     - The :attr:`.Column.key` attribute is now used as the source of
anonymous bound parameter names within expressions, to match the
existing use of this value as the key when rendered in an INSERT
or UPDATE statement.   This allows :attr:`.Column.key` to be used
as a "substitute" string to work around a difficult column name
that doesn't translate well into a bound parameter name.   Note that
the paramstyle is configurable on :func:`.create_engine` in any case,
and most DBAPIs today support a named and positional style.
fixes #3245

Affected #:  4 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/21022f9760e3/
Changeset:   21022f9760e3
Branch:      None
User:        zzzeek
Date:        2014-11-10 22:58:09+00:00
Summary:     - in lieu of adding a new system of translating bound parameter names
for psycopg2 and others, encourage users to take advantage of positional
styles by documenting "paramstyle".   A section is added to psycopg2
specifically as this is a pretty common spot for named parameters
that may be unusually named.  fixes #3246.

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/d6da110c8135/
Changeset:   d6da110c8135
Branch:      None
User:        zzzeek
Date:        2014-11-10 22:59:27+00:00
Summary:     - in lieu of adding a new system of translating bound parameter names
for psycopg2 and others, encourage users to take advantage of positional
styles by documenting "paramstyle".   A section is added to psycopg2
specifically as this is a pretty common spot for named parameters
that may be unusually named.  fixes #3246.

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/c5d2f0999b15/
Changeset:   c5d2f0999b15
Branch:      rel_0_9
User:        zzzeek
Date:        2014-11-10 23:02:14+00:00
Summary:     - we aren't changing .key behavior yet here, this is just documentation

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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/16d9d366bd80/
Changeset:   16d9d366bd80
Branch:      None
User:        jvanasco
Date:        2014-10-03 17:15:52+00:00
Summary:     * adding 'isouter=False' to sqlalchemy.orm.query.Query (https://bitbucket.org/zzzeek/sqlalchemy/issue/3217/make-join-more-standard-or-improve-error)

$ python setup.py develop
$ pip install nose
$ pip install mock
$ ./sqla_nose.py test.orm.test_joins
.....................................................................................................
----------------------------------------------------------------------
Ran 101 tests in 1.222s

OK

$ ./sqla_nose.py test.orm
..............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
 ........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................S......................................................................................................................................................................................................................................................................................................................S.............................................................................................................................................................................................................
 ..........................................................................................................................................S.......S..S.SSS.SS...............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................S................................S..S........................S...........................................................................................SSS.S.........SSSSSSSS......SSSSSSSSS........SS...SS...............S.............................S......................................
 ........................SS..SS..............................................................................................................S.
----------------------------------------------------------------------
Ran 3103 tests in 82.607s

OK (SKIP=46)

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/55ad1d915908/
Changeset:   55ad1d915908
Branch:      None
User:        zzzeek
Date:        2014-11-26 18:45:25+00:00
Summary:     Merge branch 'issue_bb_3217' of https://bitbucket.org/jvanasco/sqlalchemy-alt into pr32

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/99e51151244c/
Changeset:   99e51151244c
Branch:      None
User:        zzzeek
Date:        2014-11-26 18:50:43+00:00
Summary:     - changelog, improve docstring/test for #3217.  fixes #3217

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/028f7b8a8688/
Changeset:   028f7b8a8688
Branch:      None
User:        zzzeek
Date:        2014-11-26 18:51:39+00:00
Summary:     - set default dialect here

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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/6e53e866dea4/
Changeset:   6e53e866dea4
Branch:      None
User:        zzzeek
Date:        2014-12-05 16:35:42+00:00
Summary:     - pep8 cleanup

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/41e7253dee16/
Changeset:   41e7253dee16
Branch:      None
User:        zzzeek
Date:        2014-12-05 17:12:44+00:00
Summary:     - The engine-level error handling and wrapping routines will now
take effect in all engine connection use cases, including
when user-custom connect routines are used via the
:paramref:`.create_engine.creator` parameter, as well as when
the :class:`.Connection` encounters a connection error on
revalidation.
fixes #3266

Affected #:  8 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/92d10130aca4/
Changeset:   92d10130aca4
Branch:      rel_0_9
User:        zzzeek
Date:        2014-12-05 17:13:14+00:00
Summary:     - pep8 cleanup

(cherry picked from commit 6e53e866dea4eba630128e856573ca1076b91611)

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/d204e61f6375/
Changeset:   d204e61f6375
Branch:      None
User:        zzzeek
Date:        2014-12-05 17:18:11+00:00
Summary:     - document / work around that dialect_options isn't necessarily there

Affected #:  2 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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/95cd2003bbe1/
Changeset:   95cd2003bbe1
Branch:      None
User:        zzzeek
Date:        2014-12-06 17:39:18+00:00
Summary:     pep8

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/c24423bc2e3f/
Changeset:   c24423bc2e3f
Branch:      None
User:        zzzeek
Date:        2014-12-06 18:33:57+00:00
Summary:     - enhance only_on() to work with compound specs
- fix "temporary_tables" requirement

Affected #:  4 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/c8817e608788/
Changeset:   c8817e608788
Branch:      None
User:        zzzeek
Date:        2014-12-06 18:43:39+00:00
Summary:     - SQL Server 2012 now recommends VARCHAR(max), NVARCHAR(max),
VARBINARY(max) for large text/binary types.  The MSSQL dialect will
now respect this based on version detection, as well as the new
``deprecate_large_types`` flag.
fixes #3039

Affected #:  8 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/7ee91e3b8a25/
Changeset:   7ee91e3b8a25
Branch:      rel_0_9
User:        zzzeek
Date:        2014-12-06 18:45:13+00:00
Summary:     pep8

(cherry picked from commit 95cd2003bbe1b5da2d3c78ac845855126e03de2f)

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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/094657ed555e/
Changeset:   094657ed555e
Branch:      None
User:        zzzeek
Date:        2014-12-06 21:10:27+00:00
Summary:     Merge branch 'master' into ticket_3054

Conflicts:
	lib/sqlalchemy/orm/loading.py

Affected #:  217 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/c834f630d95a/
Changeset:   c834f630d95a
Branch:      None
User:        zzzeek
Date:        2014-12-06 21:10:57+00:00
Summary:     pep8

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/59a302b90d6c/
Changeset:   59a302b90d6c
Branch:      None
User:        zzzeek
Date:        2014-12-06 22:32:33+00:00
Summary:     - extract the baked system from the lazy strategy, and make it such that
it can be invoked as an explicit strategy, as well as that it can be optionally
patched across the board
- refine the approach we use to get fixed bound parameters into the lazy clause,
and adapt this part to the strategies.LazyLoader.   This way the baked loader
and the plain one are extremely similar, at least.

Affected #:  3 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/1e7846be8865/
Changeset:   1e7846be8865
Branch:      ticket_3054
User:        zzzeek
Date:        2014-12-06 23:48:28+00:00
Summary:     - factor lazy_clause() into properties, simplify for the query-only use case
- factor strategies.LazyLoader to use the simple lazy loader, don't need the
"lexical freeze" thing
- implement first-class get() and first() for baked

Affected #:  6 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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/06738f665ea9/
Changeset:   06738f665ea9
Branch:      None
User:        zzzeek
Date:        2014-12-08 20:15:02+00:00
Summary:     - identify another spot where _handle_dbapi_error() needs to do something
differently for the case where it is called in an already-invalidated state;
don't call upon self.connection

Affected #:  2 files

https://bitbucket.org/zzzeek/sqlalchemy/commits/c86c593ec3b9/
Changeset:   c86c593ec3b9
Branch:      None
User:        yuvallanger
Date:        2014-12-09 02:19:18+00:00
Summary:     Removing unneeded space.
Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/295092db545c/
Changeset:   295092db545c
Branch:      None
User:        zzzeek
Date:        2014-12-09 03:59:54+00:00
Summary:     Merge remote-tracking branch 'origin/pr/153'

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/d065481bcd95/
Changeset:   d065481bcd95
Branch:      rel_0_9
User:        yuvallanger
Date:        2014-12-09 04:00:15+00:00
Summary:     Removing unneeded space.
(cherry picked from commit c86c593ec3b913361999a1970efae3e6f3d831fa)

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: 4 new changesets

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

4 new commits in sqlalchemy:

https://bitbucket.org/zzzeek/sqlalchemy/commits/91af73378786/
Changeset:   91af73378786
Branch:      None
User:        jon_nelson
Date:        2014-12-13 23:34:50+00:00
Summary:     - fix unique constraint parsing for sqlite -- may return '' for name, however

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/85c04dd0bb9d/
Changeset:   85c04dd0bb9d
Branch:      None
User:        jon_nelson
Date:        2014-12-13 23:34:50+00:00
Summary:     - add test_get_unnamed_unique_constraints to SQLite reflection tests

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/5b146e1bab7b/
Changeset:   5b146e1bab7b
Branch:      None
User:        jon_nelson
Date:        2014-12-13 23:34:51+00:00
Summary:     - add tentative 'changelog' documentation on #3244

Affected #:  1 file

https://bitbucket.org/zzzeek/sqlalchemy/commits/468db416dbf2/
Changeset:   468db416dbf2
Branch:      None
User:        zzzeek
Date:        2014-12-14 00:24:56+00:00
Summary:     - rework sqlite FK and unique constraint system to combine both PRAGMA
and regexp parsing of SQL in order to form a complete picture of
constraints + their names.  fixes #3244 fixes #3261
- factor various PRAGMA work to be centralized into one call

Affected #:  5 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.