[sqlalchemy] foreign key relations

[nathan]

Hi,

I have 3 tables and I'm concerned about possible issues with foreign key 
relations and how they might impact my code and its behavior. Maybe there's a 
circular reference issue or other concern I should know about with the tables 
below?

A player and a song are both created separately and associated with a client.

class Client(Base):
    __tablename__ = 'client'
    id = Column(Integer, primary_key=True)

class Player(Base):
    __tablename__ = 'player'
    id = Column(Integer, primary_key=True)
    clientid = Column(Integer, ForeignKey('client.id'), nullable=False, 
index=True)
    client = relationship('Client', lazy='select')

class Song(Base):
    __tablename__ = 'song'
    id = Column(Integer, primary_key=True)
    clientid = Column(Integer, ForeignKey('client.id'), nullable=False, 
index=True)
    client = relationship('Client', lazy='select')
    name = Column(Unicode(50), nullable=False, index=True)

I now need to modify the above tables/relations so I can assign one song to 
each player.

To accomplish this, would it be ok to add the following to Player?

    songid = Column(Integer, ForeignKey('song.id'))
    song = relationship('Song', lazy='select')

Or maybe I should add an association table for Song and Player?

As a follow-up question, what should I do if need to be able to assign more 
than one song to a player?

Thanks

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.