Thread: [SQLObject] don't know how to get data from multiple table in one call
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Raju S. <raj...@gm...> - 2007-01-26 20:04:40
|
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 |
From: Oleg B. <ph...@ph...> - 2007-01-26 20:29:46
|
On Fri, Jan 26, 2007 at 12:04:32PM -0800, Raju Subban wrote: > I am looking to get the data from muliple tables. Something like this: http://sqlobject.org/FAQ.html#how-can-i-do-a-left-join PS. Please don't send three copies of the same message. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Raju S. <raj...@gm...> - 2007-01-31 23:25:46
|
Thank You On 1/26/07, Oleg Broytmann <ph...@ph...> wrote: > > On Fri, Jan 26, 2007 at 12:04:32PM -0800, Raju Subban wrote: > > I am looking to get the data from muliple tables. > > Something like this: > > http://sqlobject.org/FAQ.html#how-can-i-do-a-left-join > > PS. Please don't send three copies of the same message. > > Oleg. > -- > Oleg Broytmann http://phd.pp.ru/ ph...@ph... > Programmers don't die, they just GOSUB without RETURN. > > ------------------------------------------------------------------------- > 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 > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > -- Hemanttharaju Subbanna 408-857-9414(cell) |
From: Jorge V. <jor...@gm...> - 2007-01-31 02:49:45
|
also please don't double post, simple things like this could be answer in the TG mailing list. the unspoken rule is if your running SO on top of TG email there if noone knows forward it here. and of course search the archives/google before asking :) On 1/26/07, Raju Subban <raj...@gm...> wrote: > > 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 tur...@go... > To unsubscribe from this group, send email to > tur...@go... > For more options, visit this group at > http://groups.google.com/group/turbogears?hl=en > -~----------~----~----~----~------~----~------~--~--- > > |