Sorry about that, here is the code that does not work, either with a
regular account or a supersuer account
import sqlalchemy
db =
sqlalchemy.create_engine('postgres://user=bigeddie&passwd=rats&dbname=mystuff')
People = sqlalchemy.Table('people', db,
sqlalchemy.Column('id', sqlalchemy.Integer, primary_key=True),
sqlalchemy.Column('person', sqlalchemy.String(100)),
)
Things = sqlalchemy.Table('things', db,
sqlalchemy.Column('id', sqlalchemy.Integer, primary_key=True),
sqlalchemy.Column('thing', sqlalchemy.String(200)),
sqlalchemy.Column('person', sqlalchemy.Integer,
sqlalchemy.ForeignKey('People.id')),
)
print sqlalchemy.join(Things, People).select().execute().fetchall()
Thanks for any and all help
Jose
Michael Bayer wrote:
> can you please post a working test case for this. I think im about ready
> to make that an auto-reply.
>
> I made one, and it works:
>
> from sqlalchemy import *
>
> e = create_engine('sqlite://', echo=True)
> table1 = Table('mytable', e, Column('col1', Integer)).create()
> table2 = Table('mytable2', e, Column('col2', Integer,
> ForeignKey('mytable.col1'))).create()
>
> join(table1, table2).select().execute().fetchall()
>
> result:
>
> [2006-03-24 19:31:58,241] [engine]:
> CREATE TABLE mytable(
> col1 INTEGER
> )
>
>
> [2006-03-24 19:31:58,243] [engine]: None
> [2006-03-24 19:31:58,248] [engine]:
> CREATE TABLE mytable2(
> col2 INTEGER REFERENCES mytable(col1)
> )
>
>
> [2006-03-24 19:31:58,249] [engine]: None
> [2006-03-24 19:31:58,254] [engine]: SELECT mytable.col1, mytable2.col2
> FROM mytable JOIN mytable2 ON mytable.col1 = mytable2.col2
> [2006-03-24 19:31:58,255] [engine]: []
>
>
> Jose Galvez wrote:
>
>> from the documentation shouldn't this work?
>>
>> join(table1, table2).select().execute().fetchall()
>>
>> When I jun that code I get the error None.table1 not defined
>>
>> however if I run
>> join(table1, table2,
>> table1.c.id==table2.c.fk).select().execute().fetchall()
>>
>> Then I get the expected results.
>>
>> shouldn't the above code work if I've defined the foreign key
>> relationship correctly?
>> jose
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by xPML, a groundbreaking scripting
>> language
>> that extends applications into web and mobile media. Attend the live
>> webcast
>> and join the prime developer group breaking into this new coding
>> territory!
>> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
>> _______________________________________________
>> Sqlalchemy-users mailing list
>> Sqlalchemy-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
>>
>>
>
>
>
>
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
