I'm using SQLAlchemy 0.6.3 on Python 2.6 (win32)
I have a class, Efforts, which has many splits (time and distance and
some other fluff), so for each training effort, there can be one or
more splits. It has a few other relationships as well, but this is
the important one, or at least, the one I'm stuck on at the moment!
The definition in my script :
class Efforts(Base):
__tablename__ = 'efforts'
id = Column(Integer, primary_key = True)
effortTypeId = Column(Integer, ForeignKey("effortTypes.id"),
nullable=False)
riderId = Column(Integer, ForeignKey("riders.id"), nullable=False)
sessionId = Column(Integer, ForeignKey("trainingSessions.id"),
nullable=False)
.
# stuff trimmed to save space
.
splits = relationship(Splits, backref='efforts',
order_by=Splits.sequenceNumber)
rider = relationship(Riders, backref='efforts',
order_by=Riders.id)
session = relationship(TrainingSessions, backref='efforts',
order_by= TrainingSessions.id)
def __init__(self, effortTypeId, riderId, sessionId, distance,
time, maxpower, fiveSecPower, \
maxTorque, startTime, temperature, pressure, humidity, windSpeed,
comments, timingAccuracy, \
gearInches, seated, standingStartType, startingSpeed, startingLeg,
riderWeight, bikeWeight, \
extraWeight, borgRPE):
self.effortTypeId = effortTypeId
self.riderId = riderId
self.sessionId = sessionId
# stuff trimmed ...
and the 'splits' definition :
class Splits(Base):
__tablename__ = 'splits'
id = Column(Integer, primary_key = True)
effort = Column(Integer, ForeignKey("efforts.id"), nullable=False)
sequenceNumber = Column(Integer, nullable=False, default = 1)
distance = Column(Float, nullable=False)
time = Column(Float, nullable=False)
timingAccuracy = Column(Float, default = 0.1)
def __init__(self, effort, sequenceNumber, distance, time,
timingAccuracy):
self.effort = effort
self.sequenceNumber = sequenceNumber
self.distance = distance
self.time = time
self.timingAccuracy = timingAccuracy
I've stuffed something up, because when I create an 'effort' :
trainingEffort = stDataClasses.Efforts(
effortTypeId = ChosenEffortId,\
riderId = self.rider.id,\
sessionId = self.thisSession.id,\
.
.
.
)
print trainingEffort
print "splits in trainingEffort :", trainingEffort.Splits
I should, I think, see a null array when I ask for
trainingEffort.Splits, but instead I see this :
AttributeError: 'Efforts' object has no attribue 'Splits'
Can anyone here untangle my mess? My python skill level is still very
much a novice, I've read the SQLAlchemy doco for the ORM but I think
something's just not sinking in.
Thank you for any pointers in the right direction!
Carl
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
