Hi all,
I'm struggling to get a join to work, as below:
[...]
#Table definitions
table = Table('vends', MetaData(),
Column('mac', String(64), primary_key=True),
Column('vendor', String(20) ),
Column('vendorLong', String(30) )
table = Table('proxs', MetaData(),
Column('mac', String(64), primary_key=True),
Column('location', String(length=60)) )
.......
dbms="sqlite:///db.sql"
db = create_engine(dbms)
metadata = MetaData(db)
metadata.reflect()
proxs = metadata.tables['proxs']
vends = metadata.tables['vends']
s=select([proxs.c.mac]).outerjoin(vends, proxs.c.mac == vends.c.mac)
[...]
At this point the 's' is of type "<class
'sqlalchemy.sql.expression.Join'>". The query looks correct if I print it
out (and in fact executes if I paste it into my DB):
>>> print s
(SELECT proxs.mac AS mac
FROM proxs) LEFT OUTER JOIN vends ON proxs.mac = vends.mac
But I'm unsure of how to execute the query. I see documentation mentioning
applying the filter() or execute() function to the join object, but it has
no such functions. My questions are then:
1. How can I execute this query?
2. How can I apply a filter to it? e.g. filter(proxs.c.mac == vends.c.mac)
Best wishes,
Glenn
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
