sqlalchemy-tickets — trac tickets and updates forwarded to this list

Re: [Sqlalchemy-tickets] [sqlalchemy] #2717: AbstractConcreteBase class provides incorrect example

[sqlalchemy <mi...@zz...>]

#2717: AbstractConcreteBase class provides incorrect example
-----------------------------------+-----------------------------------
      Reporter:  markhildreth      |      Owner:  diana
          Type:  defect            |     Status:  new
      Priority:  low               |  Milestone:  0.8.xx
     Component:  documentation     |   Severity:  trivial - <10 minutes
    Resolution:                    |   Keywords:
Progress State:  completed/closed  |
-----------------------------------+-----------------------------------
Changes (by diana):

 * owner:  zzzeek => diana
 * status_field:  in queue => completed/closed


--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2717#comment:3>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #2717: AbstractConcreteBase class provides incorrect example

[sqlalchemy <mi...@zz...>]

#2717: AbstractConcreteBase class provides incorrect example
--------------------------------+-----------------------------------
      Reporter:  markhildreth   |      Owner:  zzzeek
          Type:  defect         |     Status:  new
      Priority:  low            |  Milestone:  0.8.xx
     Component:  documentation  |   Severity:  trivial - <10 minutes
    Resolution:                 |   Keywords:
Progress State:  in queue       |
--------------------------------+-----------------------------------

Comment (by diana):

 fixed in master, 0.8, and 0.9.

 r792facf539a5a79cff19f7475fb9b9feb0abb3d0,
 rcee8418899259e141f0059c86a32844c49f37118,
 r07d200166aa44532e41ac82640eb372f92b00b9f

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2717#comment:2>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] #2733: using backref raises AttributeError when querying column-based entities [declarative extension]

[sqlalchemy <mi...@zz...>]

#2733: using backref raises AttributeError when querying column-based entities
[declarative extension]
-------------------------+-----------------------------------------
 Reporter:  andrija      |           Owner:  zzzeek
     Type:  defect       |          Status:  new
 Priority:  lowest       |       Milestone:
Component:  declarative  |        Severity:  no triage selected yet
 Keywords:               |  Progress State:  awaiting triage
-------------------------+-----------------------------------------
 [both sqlalchemy 0.8.1 and default branch / Python 2.7.3 / Ubuntu 12.04]

 Addressing "backref" attribute will raise an !AttributeError in case of
 querying column-based entities (`Child.parents` is specified with backref
 in `Parent` class):

 {{{session.query(Child.id).join(Child.parents)}}}

 This will not raise exception if `Child` or `Parent` entities are used in
 a query before.

 See the attached code for the full example.

 I'm not sure if this is a bug or should be expected behaviour. I haven't
 tried to reproduce it without declarative extension.

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2733>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #2732: bug in get_cls_kwargs, affects sybase dialect

[sqlalchemy <mi...@zz...>]

#2732: bug in get_cls_kwargs, affects sybase dialect
-----------------------------------+----------------------------------
      Reporter:  zzzeek            |      Owner:  zzzeek
          Type:  defect            |     Status:  closed
      Priority:  highest           |  Milestone:  0.8.xx
     Component:  engine            |   Severity:  minor - half an hour
    Resolution:  fixed             |   Keywords:
Progress State:  completed/closed  |
-----------------------------------+----------------------------------
Changes (by zzzeek):

 * status:  new => closed
 * resolution:   => fixed
 * status_field:  in queue => completed/closed


Comment:

 r1162b831c2d2

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2732#comment:3>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #2730: MutableDict does not detect clear() call

[sqlalchemy <mi...@zz...>]

#2730: MutableDict does not detect clear() call
---------------------------+----------------------------------
      Reporter:  wichert   |      Owner:  zzzeek
          Type:  defect    |     Status:  new
      Priority:  medium    |  Milestone:  0.8.xx
     Component:  ext       |   Severity:  minor - half an hour
    Resolution:            |   Keywords:
Progress State:  in queue  |
---------------------------+----------------------------------
Changes (by zzzeek):

 * milestone:   => 0.8.xx
 * severity:  no triage selected yet => minor - half an hour
 * status_field:  awaiting triage => in queue


Comment:

 there's probably a lot it doesn't detect...

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2730#comment:1>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #2732: bug in get_cls_kwargs, affects sybase dialect

[sqlalchemy <mi...@zz...>]

#2732: bug in get_cls_kwargs, affects sybase dialect
---------------------------+----------------------------------
      Reporter:  zzzeek    |      Owner:  zzzeek
          Type:  defect    |     Status:  new
      Priority:  highest   |  Milestone:  0.8.xx
     Component:  engine    |   Severity:  minor - half an hour
    Resolution:            |   Keywords:
Progress State:  in queue  |
---------------------------+----------------------------------

Comment (by zzzeek):

 work in progress
 {{{
 #!diff
 diff -r e57b8df1f95e lib/sqlalchemy/util/langhelpers.py
 --- a/lib/sqlalchemy/util/langhelpers.py        Wed May 15 15:46:29 2013
 -0400
 +++ b/lib/sqlalchemy/util/langhelpers.py        Wed May 22 18:11:31 2013
 -0400
 @@ -163,9 +163,11 @@

      """

 -    for c in cls.__mro__:
 +    mro = list(cls.__mro__)
 +    while mro:
 +        c = mro.pop(0)
          if '__init__' in c.__dict__:
 -            stack = set([c])
 +            stack = set([c])  # for very liberal, say set([cls]) here
              break
      else:
          return []
 @@ -187,6 +189,8 @@
          args.update(names)
          if has_kw:
              stack.update(class_.__bases__)
 +            if mro:
 +                stack.add(mro.pop(0))
      args.discard('self')
      return args

 diff -r e57b8df1f95e test/base/test_utils.py
 --- a/test/base/test_utils.py   Wed May 15 15:46:29 2013 -0400
 +++ b/test/base/test_utils.py   Wed May 22 18:11:31 2013 -0400
 @@ -1084,6 +1084,10 @@
              def __init__(self, b1, **kw):
                  pass

 +        class B2(B):
 +            def __init__(self, b2):
 +                pass
 +
          class AB(A, B):
              def __init__(self, ab):
                  pass
 @@ -1101,15 +1105,24 @@
          class CBA(B, A):
              pass

 +        class CB1A1(B1, A1):
 +            pass
 +
          class CAB1(A, B1):
              pass

          class CB1A(B1, A):
              pass

 +        class CB2A(B2, A):
 +            pass
 +
          class D(object):
              pass

 +        class E(B, A):
 +            pass
 +
          def test(cls, *expected):
              eq_(set(util.get_cls_kwargs(cls)), set(expected))

 @@ -1122,10 +1135,13 @@
          test(BA, 'ba', 'b', 'a')
          test(BA1, 'ba', 'b', 'a')
          test(CAB, 'a')
 -        test(CBA, 'b')
 +        test(CBA, 'b', 'a')
          test(CAB1, 'a')
 -        test(CB1A, 'b1', 'b')
 +        test(CB1A, 'b1', 'b', 'a')
 +        test(CB2A, 'b2')
 +        test(CB1A1, "a1", "b1", "b")
          test(D)
 +        test(E, "a", "b")

      def test_get_func_kwargs(self):

 }}}

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2732#comment:2>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #2732: bug in get_cls_kwargs, affects sybase dialect

[sqlalchemy <mi...@zz...>]

#2732: bug in get_cls_kwargs, affects sybase dialect
---------------------------+----------------------------------
      Reporter:  zzzeek    |      Owner:  zzzeek
          Type:  defect    |     Status:  new
      Priority:  highest   |  Milestone:  0.8.xx
     Component:  engine    |   Severity:  minor - half an hour
    Resolution:            |   Keywords:
Progress State:  in queue  |
---------------------------+----------------------------------
Description changed by zzzeek:

Old description:

> {{{
> #!python
> from sqlalchemy.util import get_cls_kwargs
> from sqlalchemy.connectors import pyodbc
>
> class A(object):
>     def __init__(self, arg1=None, arg2=None):
>         pass
>
> class B(pyodbc.PyODBCConnector, A):
>     pass
>
> class C(pyodbc.PyODBCConnector, A):
>     def __init__(self, **kw):
>         pass
>
> print get_cls_kwargs(B)
> print get_cls_kwargs(C)
> }}}

New description:

 {{{
 #!python
 from sqlalchemy.util import get_cls_kwargs
 from sqlalchemy.connectors import pyodbc

 class A(object):
     def __init__(self, arg1=None, arg2=None):
         pass

 class B(pyodbc.PyODBCConnector, A):
     pass

 class C(pyodbc.PyODBCConnector, A):
     def __init__(self, **kw):
         pass

 print get_cls_kwargs(B)
 print get_cls_kwargs(C)
 }}}

 output:

 {{{
 set(['supports_unicode_binds'])
 set(['arg1', 'arg2', 'supports_unicode_binds'])
 }}}

--

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2732#comment:1>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] #2732: bug in get_cls_kwargs, affects sybase dialect

[sqlalchemy <mi...@zz...>]

#2732: bug in get_cls_kwargs, affects sybase dialect
---------------------+---------------------------------------
 Reporter:  zzzeek   |           Owner:  zzzeek
     Type:  defect   |          Status:  new
 Priority:  highest  |       Milestone:  0.8.xx
Component:  engine   |        Severity:  minor - half an hour
 Keywords:           |  Progress State:  in queue
---------------------+---------------------------------------
 {{{
 #!python
 from sqlalchemy.util import get_cls_kwargs
 from sqlalchemy.connectors import pyodbc

 class A(object):
     def __init__(self, arg1=None, arg2=None):
         pass

 class B(pyodbc.PyODBCConnector, A):
     pass

 class C(pyodbc.PyODBCConnector, A):
     def __init__(self, **kw):
         pass

 print get_cls_kwargs(B)
 print get_cls_kwargs(C)
 }}}

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2732>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #2731: for_update=whatever always creates a "FOR UPDATE" query

[sqlalchemy <mi...@zz...>]

#2731: for_update=whatever always creates a "FOR UPDATE" query
----------------------------------+------------------------------------
      Reporter:  fayaz            |      Owner:  zzzeek
          Type:  defect           |     Status:  closed
      Priority:  medium           |  Milestone:
     Component:  sql              |   Severity:  no triage selected yet
    Resolution:  worksforme       |   Keywords:
Progress State:  awaiting triage  |
----------------------------------+------------------------------------
Changes (by zzzeek):

 * status:  new => closed
 * resolution:   => worksforme


Comment:

 the docs state here that these behaviors are dialect specific:

 http://docs.sqlalchemy.org/en/rel_0_8/core/expression_api.html?highlight=for_update#sqlalchemy.sql.expression.select

    for_update=False –

    when True, applies FOR UPDATE to the end of the resulting statement.

     Certain database dialects also support alternate values for this
 parameter:

         With the MySQL dialect, the value "read" translates to LOCK IN
 SHARE MODE.
         With the Oracle and Postgresql dialects, the value "nowait"
 translates to FOR UPDATE NOWAIT.
         With the Postgresql dialect, the values “read” and "read_nowait"
 translate to FOR SHARE and FOR SHARE NOWAIT, respectively.

 so here the behavior requires a mysql dialect:

 {{{
 #!python
 from sqlalchemy import *
 from sqlalchemy.dialects import mysql

 def test():
     table = Table('user', MetaData(), Column('id', Integer,
 primary_key=True))
     query = table.select(for_update='read')
     assert "LOCK IN SHARE MODE" in
 str(query.compile(dialect=mysql.dialect()))


 if __name__ == '__main__':
     test()
 }}}

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2731#comment:1>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] #2731: for_update=whatever always creates a "FOR UPDATE" query

[sqlalchemy <mi...@zz...>]

#2731: for_update=whatever always creates a "FOR UPDATE" query
--------------------+-----------------------------------------
 Reporter:  fayaz   |           Owner:  zzzeek
     Type:  defect  |          Status:  new
 Priority:  medium  |       Milestone:
Component:  sql     |        Severity:  no triage selected yet
 Keywords:          |  Progress State:  awaiting triage
--------------------+-----------------------------------------
 When using
 {{{
 table.select(for_update='read')
 }}}

 The query string representation is still
 {{{
 SELECT "user".id
 FROM "user" FOR UPDATE
 }}}

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2731>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] #2730: MutableDict does not detect clear() call

[sqlalchemy <mi...@zz...>]

#2730: MutableDict does not detect clear() call
---------------------+-----------------------------------------
 Reporter:  wichert  |           Owner:  zzzeek
     Type:  defect   |          Status:  new
 Priority:  medium   |       Milestone:
Component:  ext      |        Severity:  no triage selected yet
 Keywords:           |  Progress State:  awaiting triage
---------------------+-----------------------------------------
 Seen with SQLAlchemy 0.8.1.

 {{{
 >>> article.aspects
 {'colour': 'black'}
 >>> article.aspects.clear()
 >>> article in meta.Session.dirty
 True
 >>> meta.Session.is_modified(article)
 False
 }}}

 Rewriting the code to use {{{article.aspects = {} }}} is a possible
 workaround.

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2730>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #2729: metadata.create_all do not create Enum in postgre ARRAY

[sqlalchemy <mi...@zz...>]

#2729: metadata.create_all do not create Enum in postgre ARRAY
--------------------------------+-------------------------------------
      Reporter:  sowingsadness  |      Owner:  zzzeek
          Type:  defect         |     Status:  new
      Priority:  medium         |  Milestone:  0.8.xx
     Component:  postgres       |   Severity:  minor - half an hour
    Resolution:                 |   Keywords:  create_all, enum, ARRAY
Progress State:  in queue       |
--------------------------------+-------------------------------------

Comment (by sowingsadness):

 thx for elegant solution -))

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2729#comment:2>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #2729: metadata.create_all do not create Enum in postgre ARRAY

[sqlalchemy <mi...@zz...>]

#2729: metadata.create_all do not create Enum in postgre ARRAY
--------------------------------+-------------------------------------
      Reporter:  sowingsadness  |      Owner:  zzzeek
          Type:  defect         |     Status:  new
      Priority:  medium         |  Milestone:  0.8.xx
     Component:  postgres       |   Severity:  minor - half an hour
    Resolution:                 |   Keywords:  create_all, enum, ARRAY
Progress State:  in queue       |
--------------------------------+-------------------------------------
Changes (by zzzeek):

 * severity:  no triage selected yet => minor - half an hour
 * status_field:  awaiting triage => in queue


Comment:

 good catch.  Here is a better workaround for now:

 {{{
 #!python
 from sqlalchemy import event

 Base = declarative_base()

 enum = Enum('manager', 'place_admin', 'carwash_admin',
                               'parking_admin', 'service_admin',
 'tire_admin',
                               'mechanic', 'carwasher', 'tire_mechanic',
 name="work_place_roles")
 class WorkPlacement(Base):
     __tablename__ = 'work_placement'
     id = Column(Integer, primary_key=True)
     roles = Column(ARRAY(enum))

 @event.listens_for(Base.metadata, "before_create")
 def _create_enum(metadata, conn, **kw):
     enum.create(conn, checkfirst=True)
 }}}

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2729#comment:1>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] #2729: metadata.create_all do not create Enum in postgre ARRAY

[sqlalchemy <mi...@zz...>]

#2729: metadata.create_all do not create Enum in postgre ARRAY
---------------------------------+-----------------------------------------
 Reporter:  sowingsadness        |           Owner:  zzzeek
     Type:  defect               |          Status:  new
 Priority:  medium               |       Milestone:  0.8.xx
Component:  postgres             |        Severity:  no triage selected yet
 Keywords:  create_all, enum,    |  Progress State:  awaiting triage
  ARRAY                          |
---------------------------------+-----------------------------------------
 metadata.create_all do not create work_place_roles if Enum in
 sqlalchemy.dialects.postgresql.ARRAY
 {{{
 class WorkPlacement(Base):
     __tablename__ = 'work_placement'

     roles = Column(ARRAY(Enum('manager', 'place_admin', 'carwash_admin',
                                       'parking_admin', 'service_admin',
 'tire_admin',
                                       'mechanic', 'carwasher',
 'tire_mechanic', name="work_place_roles")))
 }}}

 i need do so:
 {{{
 class WorkPlacement(Base):
     __tablename__ = 'work_placement'


     tmp_role = Column(Enum('manager', 'place_admin', 'carwash_admin',
                                       'parking_admin', 'service_admin',
 'tire_admin',
                                       'mechanic', 'carwasher',
 'tire_mechanic', name="work_place_roles"))
     roles = Column(ARRAY(Enum(name="work_place_roles")))
 }}}

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2729>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #2355: implement pyodbc + mssql + py3k

[sqlalchemy <mi...@zz...>]

#2355: implement pyodbc + mssql + py3k
------------------------------+-------------------------------
      Reporter:  guest        |      Owner:
          Type:  enhancement  |     Status:  new
      Priority:  high         |  Milestone:  0.8.xx
     Component:  mssql        |   Severity:  major - 1-3 hours
    Resolution:               |   Keywords:
Progress State:  in queue     |
------------------------------+-------------------------------

Comment (by zzzeek):

 test change

--
Ticket URL: <http://www.sqlalchemy.org/xyzz/ticket/2355#comment:7>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] New user registration: foobar3

[sqlalchemy <mi...@zz...>]

New user registration for user foobar3

--
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] New user registration: foobar2

[sqlalchemy <mi...@zz...>]

New user registration for user foobar2

--
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] New user registration: foobar

[sqlalchemy <mi...@zz...>]

New user registration for user foobar

--
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] Deleted User: xenbyionznn

[sqlalchemy <mi...@zz...>]

Deleted User for user xenbyionznn

--
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] Deleted User: williamfume

[sqlalchemy <mi...@zz...>]

Deleted User for user williamfume

--
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] Deleted User: shuvro

[sqlalchemy <mi...@zz...>]

Deleted User for user shuvro

--
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] Deleted User: xenbyiosicl

[sqlalchemy <mi...@zz...>]

Deleted User for user xenbyiosicl

--
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] Deleted User: rndtrust

[sqlalchemy <mi...@zz...>]

Deleted User for user rndtrust

--
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] Deleted User: reiftinue

[sqlalchemy <mi...@zz...>]

Deleted User for user reiftinue

--
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

[Sqlalchemy-tickets] [sqlalchemy] Deleted User: ryhamrodne

[sqlalchemy <mi...@zz...>]

Deleted User for user ryhamrodne

--
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python