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]> 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].
> 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.
>
--
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.
