Hey guys
I was wondering if you could give me a hand with an SO problem I've run in to.
I'm building a search
mechanism for my database. This is what my model (essentially) looks like:
class Player(SQLObject):
firstname = StringCol(length=255)
lastname = StringCol(length=255)
fullname = DatabaseIndex("firstname", "lastname", unique=True)
# ..snip..
passing = IntCol()
forsale = SingleJoin("PlayerForSale") # Don't really want this here,
thought I might as well
class PlayerForSale(SQLObject):
player = ForeignKey("Player", alternateID=True)
askingprice = IntCol()
Anyway I'm trying to do .select to get some data, but I can't seem to make
comparisons properly.
Some examples:
>>> list(PlayerForSale.select(AND(PlayerForSale.q.player_id == Player.q.id,
>>> Player.q.passing > 1)))
Traceback (most recent call last):
File "<console>", line 1, in ?
File
"/usr/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1675-py2.4.egg/sqlobject/sqlbuilder.py",
line
350, in __getattr__
raise AttributeError("%s instance has no attribute '%s'" %
(self.soClass.__name__, attr))
AttributeError: PlayerForSale instance has no attribute 'player_id'
>>> list(PlayerForSale.select(AND(PlayerForSale.q.player == Player.q.id,
>>> Player.q.passing > 1)))
Traceback (most recent call last):
File "<console>", line 1, in ?
File
"/usr/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1675-py2.4.egg/sqlobject/sqlbuilder.py",
line
350, in __getattr__
raise AttributeError("%s instance has no attribute '%s'" %
(self.soClass.__name__, attr))
AttributeError: PlayerForSale instance has no attribute 'player'
>>>
As you can see there are no PlayerForSale.q.* attributes for my ForeignKey,
which is a real bummer.
I can see this field in the database as well, so it's noting to do with that
The closest I got was this:
>>> len(list(Player.select(AND(Player.q.passing >= 1, Player.forsale > 0))))
34
But that's not even nearly close as:
>>> len(list(PlayerForSale.select()))
13
I think that's just plain way off
Can anyone help me with this? I'm totally stumped and a bit disappointed :-/
Cheers
-Rob
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to turbogears@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/turbogears
-~----------~----~----~----~------~----~------~--~---
