[Sqlalchemy-tickets] [sqlalchemy] #1302: _label expected on Function objects | since SA 0.5.0

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

#1302: _label expected on Function objects | since SA 0.5.0
--------------------+-------------------------------------------------------
 Reporter:  guest   |          Owner:  zzzeek                
     Type:  defect  |         Status:  new                   
 Priority:  medium  |      Milestone:                        
Component:  (none)  |       Severity:  no triage selected yet
 Keywords:          |   Status_field:  awaiting triage       
--------------------+-------------------------------------------------------
 {{{
 # The last line (query) fails with 0.5.0 - 0.5.2 and todays Mercurial
 trunk.
 # Works well with 0.4.8,0.4.7p1 (at least)
 # Tractrace Tip with 0.5.2:
 #  File
 "/home/rr/dev/fremd/SQLAlchemy-0.5.2/lib/sqlalchemy/sql/compiler.py", line
 460, in #label_select_column
 #    if select.use_labels and column._label:
 #AttributeError: 'Function' object has no attribute '_label'
 #
 # Environment: CPython 2.5 on AMD64 Linux
 # EMail: tm...@re...
 #
 # (Or did I miss an API change with 0.5, requiring me
 # to respect the new label functionality ?? Sorry in this case. )
 # Ruben

 from sqlalchemy import *
 from sqlalchemy.orm import *


 class User(object):
     def __init__(self, sicher, unsicher):
         self.sicher = sicher
     def _get_sicher(self):
         return self._func_sicher
     def _set_sicher(self, value):
         self._sicher = func.AES_ENCRYPT(value, "aeskey")
     sicher = property(_get_sicher, _set_sicher)


 # the AES_ENCRYPT function is MySQL only :-|
 # but to demonstrate the bug, sqlite is sufficient:
 #db = create_engine("sqlite:///:memory:",assert_unicode=True,echo=True)
 db =
 create_engine("mysql://spam@localhost/satest1",assert_unicode=True,echo=True)

 session = sessionmaker(autoflush=False)()
 metadata = MetaData(db)
 t_user = Table("user",metadata,
     Column("id",Integer,primary_key=True),
     Column("sicher",Text),
     )
 metadata.drop_all()
 metadata.create_all()
 mapper(User, t_user, properties={
         '_sicher':t_user.c.sicher,
         '_func_sicher':column_property(func.AES_DECRYPT(t_user.c.sicher,
 "aeskey")),
         'sicher':synonym('_func_sicher'),
         }
     )
 session.query(User).all()

 }}}

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