echo=True showed me them issue! It was a silly transposition. Thanks for this bit of help. I have been staring at this test code for so long, I could not see this issue.
On Jan 28, 12:44 pm, [email protected] wrote: > typo - 81087 and 18087? > maybe run with echo=True and see what goes on? > does the testfile use same engine/.. setup as below? > > On Wednesday 28 January 2009 19:21:54 Gloria W wrote: > > > This is a strange problem. I'd appreciate any assistance. > > I have a class set up using the declarative_bass model, set up in > > this way: > > > member_profile_table = MemberProfile.__table__ > > metdata = Base.metadata > > engine = create_engine(config.db_conn) > > Session = sessionmaker(bind=engine) > > session = Session() > > > It works perfectly, as I expect, in the unit tests in the same > > file. I get the expected data from the unit test: > > > x.GET(81017) > > > But in this test file, which creates in instance of my wrapper file > > in it's constructor: > > > class Dispatch: > > def __init__(self): > > self.methods = ('OPTIONS','GET','HEAD','POST', > > 'PUT','DELETE','TRACE','CONNECT') > > self.mp = MemberInfo.MemberInfo() > > > I call the get method on the exact same query parameters. > > > def test(self): > > result=self.mp.GET(18087) > > return result.memberID > > > A pdb trace reveals that I get a valid query object from > > SqlAlchemy. But my data set is empty. > > > My colleague thinks it's a lazy loading issue. My model code for my > > tables appears below. > > > Thank you in advance, > > Gloria > > > import sys > > import pprint > > from sqlalchemy import * > > from sqlalchemy.ext.declarative import declarative_base > > from sqlalchemy.orm import * > > > sys.path.append('../config') > > import config > > > from Members import * > > > Base = declarative_base() > > class MemberProfile(Member): > > __tablename__ = 'member_profiles' > > > memberID = Column(Integer, ForeignKey('members.memberID'), > > primary_key=True) > > SSN = Column(String) > > DOB = Column(Date) > > industryID = Column(Integer) > > primarysectorID = Column(Integer) > > address1 = Column(String) > > address2 = Column(String) > > city = Column(String) > > state = Column(String) > > zip = Column(String) > > howhearID = Column(Integer) > > affiliationID = Column(Integer) > > incomeID = Column(Integer) > > worksituationID = Column(Integer) > > currentinsuranceID = Column(Integer) > > genderID = Column(Integer) > > referemail = Column(String) > > occupation = Column(String) > > phonehome = Column(String) > > phonework = Column(String) > > phonecell = Column(String) > > phonefax = Column(String) > > occupationID = Column(Integer) > > occupationother = Column(String) > > billing_address1 = Column(String) > > billing_address2 = Column(String) > > billing_city = Column(String) > > billing_state = Column(String) > > billing_zip = Column(String) > > member = relation(Member,lazy=False,backref=backref > > ('members',order_by=memberID)) > > > def __init__(self, memberID, SSN=None, DOB=None, industryID=None, > > primarysectorID=None, > > address1=None, address2=None, city=None, state=None, > > zip=None, howhearID=None, affiliationID=None, > > incomeID=None, worksituationID=None, currentinsuranceID=None, > > genderID=None, referemail=None, > > occupation=None, phonehome=None, phonework=None, > > phonecell=None, phonefax=None, occupationID=None, > > occupationother=None, billing_address1=None, > > billing_address2=None, billing_city=None, > > billing_state=None, billing_zip=None, member=None): > > self.memberID = memberID > > self.SSN = SSN > > self.DOB = DOB > > self.industryID = industryID > > self.primarysectorID = primarysectorID > > self.address1 = address1 > > self.address2 = address2 > > self.city = city > > self.state = state > > self.zip = zip > > self.howhearID = howhearID > > self.affiliationID = affiliationID > > self.incomeID = incomeID > > self.worksituationID = worksituationID > > self.currentinsuranceID = currentinsuranceID > > self.genderID = genderID > > self.referemail = referemail > > self.occupation = occupation > > self.phonehome = phonehome > > self.phonework = phonework > > self.phonecell = phonecell > > self.phonefax = phonefax > > self.occupationID = occupationID > > self.occupationother = occupationother > > self.billing_address1 = billing_address1 > > self.billing_address2 = billing_address2 > > self.billing_city = billing_city > > self.billing_state = billing_state > > self.billing_zip = billing_zip > > self.member = member > > > def __repr__(self): > > return "<MemberProfile > > ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s',' > >%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s' > >,'%s','%s','%s') > > > >" % (self.memberID, self.SSN, self.DOB, self.industryID, > > > self.primarysectorID, self.address1, self.address2, > > self.city, self.state, self.zip, self.howhearID, > > self.affiliationID, self.incomeID, self.worksituationID, > > self.currentinsuranceID, self.genderID, self.referemail, > > self.occupation, self.phonehome, self.phonework, self.phonecell, > > self.phonefax, > > self.occupationID, > > self.occupationother, self.billing_address1, > > self.billing_address2, > > self.billing_city, self.billing_state, self.billing_zip) > > > if __name__ == "__main__": > > member_profile_table = MemberProfile.__table__ > > metdata = Base.metadata > > engine = create_engine(config.db_conn) > > Session = sessionmaker(bind=engine) > > session = Session() > > > memberProfile = session.query(MemberProfile).filter_by > > (memberID=81017).first() > > print "\nOriginal record:" > > print memberProfile.__dict__ > > print memberProfile.member.__dict__ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
