[sqlalchemy] Re: *all* *new* *tutorials* !!!!

2007-08-07 Thread Alexandre CONRAD
This *IS* some piece of work ! Mike, you are the One ! :) Regards, -- Alexandre CONRAD --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: Reverse Foreign Key

2007-08-07 Thread Dave Marsh
Yes, that is what I am looking for. Thanks On Aug 6, 6:25 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Aug 6, 1:38 pm, Dave Marsh [EMAIL PROTECTED] wrote: Currently, the solution is to query the database every time the page is reloaded so that the widget stays current. I would

[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: Microsoft Access Support

2007-08-07 Thread Michael Bayer
hi paul - thanks much for this ! are we using pyodbc for this ? On Aug 5, 7:20 pm, Paul Johnston [EMAIL PROTECTED] wrote: Hi, I have just committed Microsoft Access support in the 0.4 branch. It's pretty basic (e.g. a lot of unit tests fail) but it does have functional table reflection.

[sqlalchemy] Re: Aggregation

2007-08-07 Thread Michael Bayer
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 _if(...) ? 2. If there a

[sqlalchemy] Re: Aggregation

2007-08-07 Thread sdobrev
I've finally done first POC implementation of this feature. Basic usage looks like: import aggregator as a mapper(Line, lines, extension=a.Quick(a.Count(blocks.c.lines), a.Max(blocks.c.lastline, lines.c.id))) (You also need foreign keys) hi, i have similar idea/need within

[sqlalchemy] Re: Using SA to move data between databases

2007-08-07 Thread sdobrev
On Monday 06 August 2007 02:09:45 Paul Johnston wrote: Hi, I'm in the same process, and very interested in the answer ! I've found what I think is the best solution, and it sounds quite obvious thinking about it. Define the table, do a select on the old database and an insert on the new

[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