you'd want to hook this in using a Python standard deviation function with
sqlite3's create_aggregate():
http://docs.python.org/library/sqlite3.html#sqlite3.Connection.create_aggregate
SQLAlchemy can pass you the connection when first created via poollistener:
http://www.sqlalchemy.org/docs/core/interfaces.html?highlight=poollistener#sqlalchemy.interfaces.PoolListener
Then call any function with SQLA using func.name.
func.my_standard_deviation_function(xyz)
On Mar 28, 2011, at 7:51 AM, Massi wrote:
Hi everyone, I'm using sqlalchemy 0.6.6 with SQLite...my problem is
simple, is there a way to compute standard deviation in sqlalchemy
with SQlite as a backend? I googled and found that native SQLite does
not support any aggregate function like MySQL 'stdev', but there exist
some extensions which could make it available. Does sqlalchemy support
something similar? Or can anyone point me out some (even ugly) hack to
work around the problem?
Thanks in advance!
--
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, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
--
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, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.