Michael Bayer wrote:
> first thing, "wlt" is a view? thats very surprising that "autoload"
> would work with that...but then im not so famliar with the specifics
It's working :) Views are transparent to the DB engine and should be
visible as tables.
> of postgres views.
Views are one of most important thing in DB programming.
I'm surprised that this topic isn't tested in SA :(
> mapped table, you can use the "primary_key" argument to mapper()
I've tried to do this but some errors occur on session.query
(wlt.select pass):
Wlt.mapper = mapper(Wlt, wlt, primary_key=wlt.c.id)
items = wlt.select(w, order_by=order, limit=5).execute() # OK, 5 items
items = session.query(Wlt).select(w, order_by=order, limit=5)
-> TypeError: iteration over non-sequence
-> in
-> File "build\bdist.win32\egg\sqlalchemy\orm\mapper.py", line 398, in
_compile_tables
I suppose that the problem is in limit statement but without success,
the second
query returns only 10 records instead of about 30 records:
session.query(Wlt).select(w) # Fail
> itself and force the columns that should be used for the pk.
There is a primary key defined - Column('id', String(),
primary_key=True)
It isn't enough ?
It's another strange behavior:
With "metadata.engine.echo = True" I have different queries for the
same situation:
"wlt.select" creates following SQL:
SELECT wlt.id, /*blabla*/ FROM wlt ORDER BY wlt.pat_name ASC LIMIT 5
but "session.query(Wlt).select" creates:
SELECT wlt.id AS wlt_id, /*blabla*/ FROM wlt ORDER BY wlt.pat_name ASC
LIMIT 5
In the second example, there are no primary key (id) defined but
according to definition:
wlt = Table('wlt', metadata, Column('id', String(), primary_key=True),
autoload=True)
there should be a primary key (id).
When I change definition to:
wlt = Table('wlt', metadata, Column('wlt_id', String(),
primary_key=True), autoload=True)
an error occurs:
(ProgrammingError) column wlt.wlt_id does not exist
If you want I can sent to you full DB structure to test :)
Cheers,
Artur
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/sqlalchemy
-~----------~----~----~----~------~----~------~--~---
