Re: [sqlalchemy] sort/compare in synonym_for

2012-08-26 Thread jeetu
for some comparator sort of things for total_sales but I am not able to get the hang of it. On Sunday, 26 August 2012 07:32:59 UTC+5:30, Michael Bayer wrote: On Aug 25, 2012, at 4:48 PM, jeetu wrote: I have a sqlalchemy table defined like follows class Album(DeclarativeBase

[sqlalchemy] sort/compare in synonym_for

2012-08-25 Thread jeetu
traceback with statements like return getattr(self.comparator, attribute) File /home/jeetu/LEARN/turbogears/tg22_venv/local/lib/python2.7/site-packages/SQLAlchemy-0.7.8-py2.7-linux-x86_64.egg/sqlalchemy/util/langhelpers.py, line 485, in __get__ obj.__dict__[self.__name__] = result = self.fget

Re: [sqlalchemy] cumulative sum of 1-many table columns.

2012-08-16 Thread jeetu
I am not able see the total_sales column in sqlite manager plugin of firefox and sqlagrid of toscawidgets. But I can access the total_sales when I use toscawidget's dbform. Any known reasons? On Tuesday, 7 August 2012 20:56:07 UTC+5:30, jeetu wrote: Just one minor update for future reference

Re: [sqlalchemy] cumulative sum of 1-many table columns.

2012-08-07 Thread jeetu
(if the problem still remains). The code in the above post is working fine for adding new Artist and Albums. Thanks Michael for helping me out. On Tuesday, 7 August 2012 11:19:54 UTC+5:30, jeetu wrote: Thanks Michael for looking into my problem. I tried following your advice but still not able to get

Re: [sqlalchemy] cumulative sum of 1-many table columns.

2012-08-07 Thread jeetu
(artist, include_removes=True) def _update_artist(self, key, artist, is_remove): if artist is not None: artist.__dict__.pop('total_sales', None) return artist On Tuesday, 7 August 2012 17:06:25 UTC+5:30, jeetu wrote: Just ignore the above post. I am able to get

[sqlalchemy] cumulative sum of 1-many table columns.

2012-08-06 Thread jeetu
My problem scenario is analogous to the following. I have an Artist table and an Album table. Each artist can have multiple albums with sales of each album. The artist also has a total_sales column which is basically a cumulative of album's sales for that artist. I tried reading about

Re: [sqlalchemy] cumulative sum of 1-many table columns.

2012-08-06 Thread jeetu
) def _update_artist(self, key, artist, is_remove): artist.__dict__.pop('total_sales', None) return artist On Aug 6, 2012, at 4:08 AM, jeetu wrote: My problem scenario is analogous to the following. I have an Artist table and an Album table. Each artist can have

Re: [sqlalchemy] how to iterate over Enum's possible values

2012-08-01 Thread jeetu
Just for other people's reference, the working statement is Calc.choose.property.columns[0].type.enums On Wednesday, 1 August 2012 23:11:14 UTC+5:30, jeetu wrote: Thanks Michael, I actually saw that page of yours before posting this question. That is awesome work, especially