Hi, I'm having some trouble with connection management in sqlalchemy.
In my environment I have an already created connection with psycopg2, and
some other components are still using it outside sqlalchemy.
I'd like create a new engine for sqlalchemy using the already created
connection; without
What is the proper way to use a subquery as the FROM clause, while
being able to use the Query.join() method?
Here is an example of what I mean: http://pastebin.com/RUktuZZm
The docs at
http://www.sqlalchemy.org/docs/orm/query.html#sqlalchemy.orm.query.Query.subquery
state: Eager JOIN
Dear Mr. Bayer,
I'm impressed by such a fast response and fix, thank you!
On 13 Ott, 16:55, Michael Bayer mike...@zzzcomputing.com wrote:
hi Daniele -
You're in luck because I saw you ask this on IRC yesterday. Using a
non-mapped selectable as the thing to select from in Query wasn't
a reason to take a look inside.
Actually sane_rowcount is an effect: the cause is that the table is
partitioned. Would partitioned be a better name for the flag?
Regards,
Daniele
--~--~-~--~~~---~--~~
You received this message because you are subscribed
it. Furthermore i didn't check for inserts and deletes (if
you wish i could: i just set up the reported db schema: i can ask the
OP a complete example of partitioned table).
Cheers,
-- Daniele
--- sqlalchemy/databases/postgres.py.bak 2007-06-14 12:02:40 +0200
+++ sqlalchemy/databases/postgres.py
,
-- Daniele
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more
something wrong in setting up the mappers?
-- Daniele
from sqlalchemy import *
metadata = BoundMetaData('sqlite://')
# Database metadata
employees = Table('employees', metadata,
Column('person_id', Integer, primary_key=True),
Column('name', String(50)),
Column('type', String(30