[sqlalchemy] Re: Aggregation

2007-08-08 Thread Paul Colomiets
[EMAIL PROTECTED] wrote: hi, i have similar idea/need within dbcook, although on a somewhat higher level: pre cache_results/: (dbcook/SA) add-on for automaticaly-updated database denormalisation caches of intermediate results, each one depending on particular pattern of usage. Wishful

[sqlalchemy] Re: Aggregation

2007-08-07 Thread Paul Colomiets
Michael Bayer wrote: i wonder though if theres some way that could get out of sync with the actual number. you'd have to be careful to establish this update. if you wanted to use a mapper extension to do it, then youd have to issue the UPDATE directly, the change to the comment_count

[sqlalchemy] Re: Aggregation

2007-08-07 Thread Paul Colomiets
[EMAIL PROTECTED] wrote:= http://www.mr-pc.kiev.ua/projects/SQLAlchemyAggregation this gives me 404 Sorry: http://www.mr-pc.kiev.ua/en/projects/SQLAlchemyAggregator --~--~-~--~~~---~--~~ You received this message because you are subscribed to

[sqlalchemy] Re: Aggregation

2007-08-07 Thread Paul Colomiets
Michael Bayer wrote: On Aug 7, 1:20 pm, Paul Colomiets [EMAIL PROTECTED] wrote: 1. func.if_(...) - tries to sql function if_(...), but func._if(...) - _i(...) I believe is typo? er, probably. func is trying to sidestep various _ underscore attributes i think. do you need to say

[sqlalchemy] Atomic update error

2007-08-06 Thread Paul Colomiets
Hi! Can somebody point me why this fails? meta = MetaData(bind=sqlite:///:memory:) blocks = Table('blocks', meta, ... Column('id', Integer, primary_key=True, autoincrement=True), ... Column('lines', Integer), ... Column('lastline', Integer), ... ) blocks.create()

[sqlalchemy] Re: 'Column' object has no attribute 'tables'

2007-08-03 Thread Paul Colomiets
Dave Harrison wrote: sysMessageTable = Table( 'sysmessage', Column('id', Integer, primary_key=True), Column('timestamp', DateTime, nullable=False, default=datetime.datetime.now()), Column('summary', String(100), nullable=False), Column('message', TEXT()),

[sqlalchemy] Re: Aggregation

2007-08-03 Thread Paul Colomiets
Michael Bayer wrote: Hmmm, do you mean joining relations against a subrelation that uses an aggregate like MAX ? i'd like to see what you have in mind for this. Well, I think I've not explained it correctly. It looks quite like you're saying, but I want that aggregations to be stored

[sqlalchemy] Re: Aggregation

2007-08-03 Thread Paul Colomiets
Michael Bayer wrote: we've just added the atomic update thing to 0.4 (note the uppercase Article which produces a column expression): article.comment_count = Article.comment_count + 1 session.flush() That's great! It's quite unconvenient here, but has a lot of good use cases. i wonder

[sqlalchemy] Connection initialization

2007-07-24 Thread Paul Colomiets
Hi, How can I place some initialization code for each connection in the pool? Currently I do something like this: engine.execute(SET collation_connection=utf8_general_ci) engine.execute(SET names utf8) engine.execute(SET character_set_client=utf8) engine.execute(SET