class Player(object):

    def __init__(self, country, name, price, real_clan):
        print "Player, Realclan:", real_clan
        print "RealClan.UID", real_clan.uid
        self.country = country
        self.name = name
        self.price = price
        self.real_clan_uid = real_clan.uid

    def __repr__(self):
        return "<Player %r, Real_Clan %r>" % (self.uid, self.real_clan)

session.mapper(Real_Clan, real_clan_table, properties={"players" : relation(Player,
                                                                            backref="real_clan",
                                                                            order_by=desc(Player.score))})
--

>>> from pyfantasy.models import *
>>> realclan = Real_Clan("a", "b", "c", "d")
>>> realclan
<Real_Clan None>
>>> session.add(realclan)
>>> session.commit()
>>> realclan
<Real_Clan 1>
>>> player = Player("uk", "DR Foo", 100, realclan)
Player, Realclan: <Real_Clan 1>
RealClan.UID 1
>>> player
<Player None, Real_Clan None>
>>> session.add(player)
>>> session.commit()
>>> player
<Player 1, Real_Clan None>
>>> player.real_clan_uid
1
>>> realclan.players
[<Player 1, Real_Clan None>]
>>>