Given
class Person:
id
class Topic:
id
class Person2Topic :
id
topic_id - fkeys topic(id)
person_id - fkeys person(id)
class Message:
id
person_id_author - fkeys person(id)
topic_id - fkeys topic(id)
I wanted to select by joining the Person2Topic table directly, with a
filter
query(
On Apr 26, 2013, at 7:10 PM, Jonathan Vanasco jonat...@findmeon.com wrote:
Given
class Person:
id
class Topic:
id
class Person2Topic :
id
topic_id - fkeys topic(id)
I thought it should work too, but I'm getting:
InvalidRequestError: Could not find a FROM clause to join from. Tried
joining to class 'app.models.Person2Topic', but got: Can't find any
foreign key relationships between 'message' and 'person_2_topic'.
If i have time this weekend I'll look
well you example here seems like it's not literal, do you mean to use and_() ?
I see a tuple there and an assignment. It shouldn't be trying to do an
auto-join like that so it seems like join() isn't being called correctly.
On Apr 26, 2013, at 7:42 PM, Jonathan Vanasco jonat...@findmeon.com