Argthtjtr

I've got 3 tables; user, location and location_favorite.
location_favorite being kind of like a association table. I'm trying to be able to create a list of favorite locations forf the user using that table.

user class looks like this:

import datetime

from sqlalchemy import Column, Integer, String, Date, ForeignKey

from sqlalchemy.orm import relationship



from model import Base

from model.address import Address

from model.group import Group

from model.location_favorite import LocationFavorite





class User(Base):

    __tablename__ = 'users'

    id = Column(Integer, nullable=False, unique=True, primary_key=True)

    username = Column(String, nullable=False, unique=True)

    password = Column(String, nullable=False)

    reset_token = Column(String, default=None)

    email = Column(String, nullable=False, unique=True)

    account_status = Column(Integer, nullable=False, default=0)

    user_group = Column(Integer, ForeignKey("user_groups.id"), 

    nullable=False, default=1)

    registration_date = Column(Date, nullable=False, 

    default=datetime.datetime.now())

    last_online = Column(Date, default=datetime.datetime.now())





    # Relationships

    address = relationship(Address, uselist=False, back_populates="user")

    group = relationship(Group, back_populates='users')

    spots = relationship("Location")

    favorite_spots = relationship('Location', secondary='location_favorite', 

    backref='favorited_by')

location class looks like this:

class Location(Base):

    __tablename__ = 'location'

    id = Column(Integer, primary_key=True, nullable=False)

    title = Column(String, unique=True)

    description = Column(String, nullable=False)

    creator_id = Column(Integer, ForeignKey('users.id'))

    latitude = Column(Float)

    longtitude = Column(Float)

    creation_date = Column(Date, default=datetime.now)



    # Relationships

    creator = relationship('User', foreign_keys=creator_id, 

    back_populates='spots')

    events = relationship('Event')

    favorited_by = relationship('User', secondary='location_favorite', 

    backref='favorite_spots')

and the location_favorite class looks like this:

class LocationFavorite(Base):

    __tablename__ = 'location_favorite'

    user_id = Column(Integer, ForeignKey('user.id'), primary_key=True)

    location_id = Column(Integer, ForeignKey('location.id'), 

    primary_key=True)

    creation_date = Column(Date, default=datetime.now)

Now that gives me the following exception:

Could not determine join condition between parent/child tables on 

relationship User.favorite_spots

I suppose that is a logical response because the user doesn't have any reference to location_favorite except for the user_id.. which is a part of a composite primary key. I just can't figure out what would be the best way to create this relationship.