Ok I'm beginning to understand the SQL Model now and I am able to run
a query using
records =
SubDivision.query().join('divisionJoin').select()
However I am not getting all the fields from both tables, only from
SubDivision. Going back to my model:
class Division(Entity):
has_field('Division_id', Integer, primary_key=True)
has_field('Name', String(45), unique=True)
using_options(tablename='division')
class SubDivision(Entity):
has_field('Subdivision_id', Integer, primary_key=True)
has_field('Name', String(45), unique=True)
has_field('DisplayOrder', Integer)
belongs_to('divisionJoin', of_kind='Division',
colname='Division_id', use_alter=True)
using_options(tablename='subdivision')
@classmethod
def by_Name(klass, Name):
return klass.get_by(subdivision_table.c.Name==Name)
When I perform
records =
SubDivision.query().join('divisionJoin').select(Division.c.Division_id==2,order_by=[SubDivision.c.DisplayOrder])
Why does it not return the fields in Division?
This is what the trace shows as the Select clause that is built:
SELECT subdivision.`Division_id` AS `subdivision_Division_id`,
subdivision.`Name` AS `subdivision_Name`, subdivision.`DisplayOrder`
AS `subdivision_DisplayOrder`, subdivision.`Subdivision_id` AS
`subdivision_Subdivision_id`
FROM subdivision JOIN division ON subdivision.`Division_id` =
division.`Division_id`
WHERE division.`Division_id` = %s ORDER BY subdivision.`DisplayOrder`
but when i run it through MySQL I get:
>>> r = subdivision_table.join(division_table).select()
>>> s = r.execute()
2007-05-23 06:39:35,992 INFO sqlalchemy.engine.base.Engine.0x..0c
SELECT subdivision.`Subdivision_id`, subdivision.`Division_id`,
subdivision.`Name`, subdivision.`DisplayOrder`,
division.`Division_id`, division.`Name`
FROM subdivision JOIN division ON division.`Division_id` =
subdivision.`Division_id`
Is there a limitation or a method I missed?
Thanks,
Mel
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
