Hi,
I am looking to get the data from muliple tables.
Currently I am get Qualifier.select() and for each value init I get
Process.id(),BondWire.id().
If i my SQL I can do it in call. (shown below). How can I accomplish the
same ??
------------------------------------------
mysql> select process.process , qualifier.id,bond_wire.type from
process,bond_wire, qualifier where process.id=qualifier.process_id and
bond_wire.id=qualifier.bondwire_id;
+---------+----+--------+
| process | id | type |
+---------+----+--------+
| VIP11 | 1 | Copper |
| ABCD5 | 2 | Copper |
+---------+----+--------+
2 rows in set (0.00 sec)
I want to be able to do. How can I perform this?
My model simplified looks like this
----------------------------------------------------------
class Process(SQLObject):
process = StringCol(length=50, alternateID=True)
class BondWire(SQLObject):
type = StringCol(length=50, alternateID=True)
class Qualifier(SQLObject):
qual = StringCol(length=3, notNull=True)
process = ForeignKey('Process')
bondwire = ForeignKey('BondWire')
-------------------------------------------
Thank you
Raju
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
