Thanks for the quick reply, this is exactly what I was looking for!
Thanks again,
Adrian
On Nov 8, 2:29 pm, Michael Bayer <mike...@zzzcomputing.com> wrote:
> On Nov 8, 2010, at 1:16 PM, Adrian wrote:
>
>
>
>
>
> > 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.
>
> The column objects are always available from table.c regardless of whether
> autoload was used or not:
>
> mapper(SpectrumView, spectrum_view, primary_key=[spectrum_view.c.somecolumn,
> spectrum_view.c.someothercolumn])
>
>
>
>
>
> > 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
> > athttp://groups.google.com/group/sqlalchemy?hl=en.
--
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.
