So if I create a ManyToMany relationship, I see it creates the intermediate
table, but now I don't know how to query, join, or even create now.
class User(Entity):
email = Field(UnicodeText)
image = ManyToMany('Image')
class Image(Entity):
url = Field(UnicodeText, unique=True)
So before I just created a relationship entity for reference from the user
to the the image. What's the syntax to do that now? Am I just using
normal sqlalchemy then on the intermediate table for inserts and queries?
If not, how do I use the user entity to add a link to a given image? And
how do I query the created links for a given user? Just use the user id?
On Saturday, January 18, 2014 9:59:42 AM UTC-8, yoav glazner wrote:
>
> Delete the 3rd class and use ManyToMany it will create the 3rd table
> automagically
> On Jan 18, 2014 10:08 AM, "Josh Stratton" <[email protected]<javascript:>>
> wrote:
>
>> I'm trying to create a simple join and after reading the docs, can't
>> understand how it's actually performed. I have a set of users and a set of
>> images. I also have a set of UserImages, where multiple users can point to
>> the same image. I've been able to do simple queries on the individual
>> tables, but I'm at a loss on how to get all the images for a given user.
>>
>> class User(Entity):
>> email = Field(UnicodeText)
>>
>> class Image(Entity):
>> url = Field(UnicodeText, unique=True)
>>
>> class UserImage(Entity):
>> user = ManyToOne('User')
>> thumbnail = ManyToOne('Image')
>>
>> I know I can do something like the following to get all the UserImages...
>>
>> UserImage.query.filter_by(user=user)
>>
>> ...but I'd like to join that with the actual list images that are linked.
>> I'm just using sqlite right now for testing if that makes a difference.
>>
>> Reading the relationship docs, I don't understand this "joined table"
>> like it's supposed to actually exist statically. Can someone give me the
>> syntax to do something like this? Would I have to end up with all the
>> Images or would I have a join of the UserImages and Images? While the
>> images are shared, I figured there might be data on the userimage later
>> like "link" date so I'd end up with a list of images a user is linked to,
>> but also a column of the creation date. Thanks, any help or even direction
>> would be appreciated.
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "SQLElixir" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> To post to this group, send email to [email protected]<javascript:>
>> .
>> Visit this group at http://groups.google.com/group/sqlelixir.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
--
You received this message because you are subscribed to the Google Groups
"SQLElixir" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlelixir.
For more options, visit https://groups.google.com/groups/opt_out.
