[sqlalchemy] Re: Performance Analysis

2009-08-15 Thread Philip Jenvey
On Aug 15, 2009, at 10:26 PM, gizli wrote: > > Turning on echo=True spits out all the queries that the application > generates. Currently I am directing this output to a file and then > looking through to derive statistics like what kind of tables are most > frequently accessed. I use this to se

[sqlalchemy] Performance Analysis

2009-08-15 Thread gizli
Hi all, This is not really a sqlalchemy question but I was wondering if anyone developing with sqlalchemy knows the answer. Turning on echo=True spits out all the queries that the application generates. Currently I am directing this output to a file and then looking through to derive statistics

[sqlalchemy] Re: Mapping to multiple tables

2009-08-15 Thread Mike Conley
Specify a relation in a mapper. Look at the examples in the ORM tutorial part of the documentation. assuming you have already defined the tables: mapper (Profile, profiles_table, properties={ 'skills':relation(skills_table, backref='user')}) This will give you a list of skills related to a p

[sqlalchemy] Re: How do I execute Oracle custom functions?

2009-08-15 Thread Philip Jenvey
On Aug 14, 2009, at 9:16 AM, Nick Martin wrote: > > Hi, > > I've been trying to get my head around how to call custom functions in > Oracle. > > In straight SQL it would usually be: > "exec blah.fishcakes(1);" > > Where blah is the package name, and fishcakes the name of the > function. > > For

[sqlalchemy] Mapping to multiple tables

2009-08-15 Thread Sid
Hi, I'm new to SQLAlchemy and ORMs in general so I have a couple of questions. Basically I have a class called Profile that contains the following members: class Profile: def __init__(self): self.user_id = none self.first_name = none self.last_name = none sel