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
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
