From: Andreas Jung <[EMAIL PROTECTED]>
To: sqlalchemy@googlegroups.com
Subject: engine.base._convert_key() fails with long col names
Date-Sent: 14. Juni 2007 15:14:37

Hi,

I am getting the following traceback

   *  Module toolbox.product.export_bauplan2, line 96, in export_bauplan
   * Module toolbox.product.export_bauplan2, line 69, in xml_builder
   * Module toolbox.product.export_bauplan2, line 27, in xml_builder
   * Module toolbox.database.model, line 60, in tools
   * Module sqlalchemy.orm.attributes, line 53, in __get__
   * Module sqlalchemy.orm.attributes, line 208, in get
   * Module sqlalchemy.orm.strategies, line 226, in lazyload
   * Module sqlalchemy.orm.query, line 326, in select_whereclause
   * Module sqlalchemy.orm.query, line 955, in _select_statement
   * Module sqlalchemy.orm.query, line 857, in execute
   * Module sqlalchemy.orm.query, line 916, in instances
   * Module sqlalchemy.orm.mapper, line 1471, in _instance
   * Module sqlalchemy.orm.mapper, line 1508, in populate_instance
   * Module sqlalchemy.orm.interfaces, line 163, in execute
   * Module sqlalchemy.orm.strategies, line 39, in process_row
   * Module sqlalchemy.engine.base, line 1174, in __getitem__
   * Module sqlalchemy.engine.base, line 995, in _get_col
   * Module sqlalchemy.engine.base, line 932, in _convert_key

NoSuchColumnError: "Could not locate column in row for column 'Column(u'stammdatenverwaltung_tauglich',PGBoolean())'"


This happens when _convert_key() is called with
key='arbeitsmittelhierarchy_arbeitsmittel_view.stammdatenverwaltung_tauglich'

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).

Andreas


--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK
------------------------------------------------------------------------
E-Publishing, Python, Zope & Plone development, Consulting

Attachment: pgp3TcNEphdFD.pgp
Description: PGP signature

Reply via email to