Hi all, This is a topic that has been discussed before, but I haven't been able to successfully implement any of the proposed solutions in my own code. I've created a few Views in my postgres database, and I'm looking for a way to simply query them from sqlalchemy. I tried just treating them as tables, but this failed when the mapper wasn't able to find a primary key (makes sense).
The code I tried was just a naive attempt: class SpectrumView(object): pass spectrum_view = Table('spectrum_view', metadata, autoload=True) mapper(SpectrumView, spectrum_view) So I read in some message that it might be possible to specify a primary key to the mapper, like mapper(SpectrumView, spectrum_view, primary_key=[..]), but the problem is I'm not defining my tables in python - they are already created, so I don't have any column objects to pass to primary_key. Anyway, I'm just curious to see if anyone has had success with an implementation of database views in sqlalchemy, and possibly examples of those cases. Thanks, Adrian -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.