regarding union, maybe I am missing something basic. I use the
session.query() with the orm stuff. How do I get the selects from
those ?
On Jun 17, 8:23 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
> On Jun 17, 12:49 pm, "Moshe C." <[EMAIL PROTECTED]> wrote:
>
> > I have 3 tables:
>
> > general_product {id, name, price} mapped to GeneralProduct
> > electrical_product {id, name, price, voltage} mapped to
> > ElectricalProduct
> > food_product {id,name, price, calories} mapped to FoodProduct
>
> > 1) I want to create a union query on the above 3 selecting only id,
> > name and price (which are common fields).
> > How do I do that? Could find the doc for union only in the non-orm
> > case.
>
> unions are accomplshed using the union() function, as in
>
> union(select([table.c.x, table.c.y]), select([othertable.c.x,
> othertable.c.y]))
>
> > 2) Since this smells of inheritance, I read about class inheritance
> > mapping but couldn't decide if and which method applies here.
> > Help would be greatly appreciated.
>
> I think svil's assumption of joined table inheritance is incorrect
> here, since each table contains "name" and "price". This would be
> concrete table inheritance, described
> athttp://www.sqlalchemy.org/docs/04/mappers.html#advdatamapping_mapper_...
> .
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
