--On 14. Juni 2007 14:13:47 -0400 Michael Bayer <[EMAIL PROTECTED]> wrote:
On Jun 14, 2007, at 9:16 AM, Andreas Jung wrote:This happens when _convert_key() is called with key='arbeitsmittelhierarchy_arbeitsmittel_view.stammdatenverwaltung_ta uglich'im confused. are you passing that string directly to row[<some key>] ? result column names cant have periods in them.
For course not. As you can see from the traceback this happens on the SA level (using a self-referential mapper).
When I look at the self._ResultProxy__keys then the key cache contains shortend col names: (Pdb) for x in self._ResultProxy__keys:print x arbeitsmittelhierarchy_arbeitsmittel_view_idautor arbeitsmittelhierarchy_arbeitsmittel_view_idsachgebiet arbeitsmittelhierarchy_arbeitsmittel_view_num_hre arbeitsmittelhierarchy_arbeitsmittel_view_bemerkung arbeitsmittelhierarchy_arbeitsmittel_view_versionsnr arbeitsmittelhierarchy_arbeitsmittel_view_idzielgruppe arbeitsmittelhierarchy_arbeitsmittel_view_idfassung arbeitsmittelhierarchy_arbeitsmittel_view_dateiname arbeitsmittelhierarchy_arbeitsmittel_view_originalname arbeitsmittelhierarchy_arbeitsmittel_view_rechnerstand arbeitsmittelhierarchy_arbeitsmittel_view_id arbeitsmittelhierarchy_arbeitsmittel_view_hidx_master arbeitsmittelhierarchy_arbeitsmittel_view_stammdatenverwaltung_ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Using SA 0.3.8 and Postgres 7.4.7...what's the suggested way to get around this issue (shortening the column names isn't an option).using column labels or using Column objects to get at the value. result = select([table.c.longcolumnname.label('foo')]).execute() result.fetchone()['foo']
No chance. As I wrote above the main mapper is a mapper for a self-referential where which an additional property where the table tp be join it the view above. So there is basically no chance for defining an alias, or?
-aj
pgpc8hERmJ2qo.pgp
Description: PGP signature