[sqlalchemy] Re: Problem with using global metadata/connection in a threaded context

2007-05-18 Thread Sébastien LELONG
def init_thread(): if sa.default_metadata.is_bound(): pass # ok, thread is already init' else: sa.global_connect() # assert sa.default_metadata.is_bound() == True Hope that helps. Cheers Seb -- Sébastien LELONG sebastien.lelong[at]sirloon.net http

[sqlalchemy] Re: @property

2007-04-18 Thread Sébastien LELONG
to be aware of this and work with _score. Hope that helps cheers Seb -- Sébastien LELONG http://www.sirloon.net sebastien.lelong[at]sirloon.net --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

[sqlalchemy] Re: how to do many-to-many on the same table?

2007-04-04 Thread Sébastien LELONG
have reference to A without saying B relates to A) Hope that helps Cheers, Seb -- Sébastien LELONG http://www.sirloon.net sebastien.lelong[at]sirloon.net --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy

[sqlalchemy] Re: DynamicMetaData question

2007-03-14 Thread Sébastien LELONG
was for now, only one datasource [probably due to global_connect], we'll see next release). So maybe global_connect will not even be used anymore by TG... Cheers Seb -- Sébastien LELONG sebastien.lelong[at]sirloon.net http://www.sirloon.net --~--~-~--~~~---~--~~ You

[sqlalchemy] Re: DynamicMetaData question

2007-03-13 Thread Sébastien LELONG
features in this DynamicMetaData... Seb -- Sébastien LELONG sebastien.lelong[at]sirloon.net http://www.sirloon.net --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email

[sqlalchemy] Re: Ping

2007-03-05 Thread Sébastien LELONG
. Search for MySQL has gone away, you'll have different threads talking about that. Hope it helps. Seb -- Sébastien LELONG sebastien.lelong[at]sirloon.net http://www.sirloon.net --~--~-~--~~~---~--~~ You received this message because you are subscribed

[sqlalchemy] Re: Get error: 'list' object has no attribute 'accept_visitor'

2007-02-20 Thread Sébastien LELONG
to get working is used to specify eg. where clauses, not to specify which columns to get. -- Sébastien LELONG sebastien.lelong[at]sirloon.net On Tuesday 20 February 2007 16:10, vinjvinj wrote: I'm getting the following error when I build the select clause. select_columns = [table.c.col1

[sqlalchemy] Re: improving connection resiliency

2007-02-09 Thread Sébastien LELONG
exceptions encapulsation into SA's exception has been improved since 0.2.8: some weren't caught resulting in a raise of the original, underlying database exceptions. Hope it helps, Cheers Seb -- Sébastien LELONG sebastien.lelong[at]sirloon.net --~--~-~--~~~---~--~~ You

[sqlalchemy] Re: new setuptools vs local SA copy

2007-02-07 Thread Sébastien LELONG
not the expected behavior. -- Sébastien LELONG sebastien.lelong[at]sirloon.net --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com

[sqlalchemy] Re: making crud with assign_mapper

2007-02-07 Thread Sébastien LELONG
want, since you can invoke the edit command on several python object. Give a try with: In [9]: edit mytable.__class__.columns Seb -- Sébastien LELONG sebastien.lelong[at]sirloon.net --~--~-~--~~~---~--~~ You received this message because you are subscribed

[sqlalchemy] Re: list of strings/unicode strings

2007-02-07 Thread Sébastien LELONG
model... See attachment for the pickletype col. Hope it helps. Cheers, Seb -- Sébastien LELONG sebastien.lelong[at]sirloon.net --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

[sqlalchemy] Re: got problems where map to selectable

2007-02-06 Thread Sébastien LELONG
(identity_map). Since the user was already loaded before, SA doesn't re-perform sql access to the db. You can see it by activating engine.echo = True, and selecting users by id (eg. session.query(User).get(1)) Hope it helps. Cheers, Seb -- Sébastien LELONG sebastien.lelong[at]sirloon.net

[sqlalchemy] Re: access mapper properties

2007-02-05 Thread Sébastien LELONG
() is the (almost) concatenation of table + mapper properties since: set(sorted(cl.c.keys() + cl.mapper.properties.keys())) == set(sorted(cl.mapper.props.keys())) = True Hope it helps. Cheers, Seb -- Sébastien LELONG sebastien.lelong[at]sirloon.net

[sqlalchemy] Re: Inspect and __init__ of a mapped class

2007-02-05 Thread Sébastien LELONG
as in your example. Maybe that's what you want to avoid... Seb -- Sébastien LELONG sebastien.lelong[at]sirloon.net --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send

[sqlalchemy] Re: ORM ramblings 2 - and announcing some o2r wrapper

2007-01-24 Thread Sébastien LELONG
= svn:keywords=Id Revision You can also: svn propset svn:keywords Revision the_file_you_want_to_tag avoiding the autoprop for all files. Cheers, Seb -- Sébastien LELONG [EMAIL PROTECTED] --~--~-~--~~~---~--~~ You received this message because you are subscribed

[sqlalchemy] Row attributes from a table with renamed columns

2007-01-23 Thread Sébastien LELONG
table_with_key.py, line 25, in ? print r.label: %s % r.label # won' work File build/bdist.linux-i686/egg/sqlalchemy/engine/base.py, line 730, in __getattr__ AttributeError: label Thanks Cheers Seb -- Sébastien LELONG sebastien.lelong[at]sirloon.net

[sqlalchemy] Re: count(*) function

2007-01-15 Thread Sébastien LELONG
import SelectResults SelectResults(your_session.query(YourMappedClass)).count() Cheers, Seb -- Sébastien LELONG sebastien.lelong[at]sirloon.net --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

[sqlalchemy] Re: Performance of data mapping and plain access

2006-12-28 Thread Sébastien LELONG
, -- Sébastien LELONG sebastien.lelong[at]sirloon.net --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group

[sqlalchemy] Re: Performance of data mapping and plain access

2006-12-28 Thread Sébastien LELONG
results in an evil maintainance... Cheers, -- Sébastien LELONG sebastien.lelong[at]sirloon.net --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy

[sqlalchemy] Re: SA 0.3.x: performance issues = proposal

2006-12-08 Thread Sébastien LELONG
caching, it may need to clear it... thanks much, this is the kind of user involvement i like. Well, you're very welcome ! Glad to help ! Cheers, Seb -- Sébastien LELONG sebastien.lelong[at]sirloon.net P.S: im beginning to suspect that yield introduces overhead vs. a straight list

[sqlalchemy] Re: MySQL Has Gone Away

2006-12-07 Thread Sébastien LELONG
PROTECTED] on dev blablabla Well, that's a lot of obscure observations... without a clean solution ! But maybe someone will have some ideas... Cheers, -- Sébastien LELONG sebastien.lelong[at]sirloon.net --~--~-~--~~~---~--~~ You received