Randy: It seems you want a sortable HTML table that talks to a back end query engine. I don't see why this needs to be specific to SQLAlchemy.
Here is a WHIFF middleware which does some of what you are talking about (the demo formatting is basic/ugly for simplicity purposes). Demo http://whiffdoc.appspot.com/tests/misc/testSortTable Demo source http://whiffdoc.appspot.com/tests/showText?path=./misc/testSortTable The documentation http://whiffdoc.appspot.com/docs/W1200_1400.stdMiddleware#Header83 is not extensive, but here is the source for the core middleware widget. http://aaron.oirt.rutgers.edu/cgi-bin/whiffRepo.cgi/file/8c031c68a5a0/whiff/middleware/sortTable.py As written it requires the whole table as a list of dictionaries and then does paging from the full list. It certainly needs generalization but maybe it's a start. Let me know if you have questions or comments. -- Aaron Watters --- On Wed, 4/7/10, Randy Syring <rsyr...@inteli-com.com> wrote: From: Randy Syring <rsyr...@inteli-com.com> Subject: Re: [Web-SIG] SQLAlchemy Queries & HTML Data Grid To: "Aaron Watters" <arw1...@yahoo.com> Cc: web-sig@python.org Date: Wednesday, April 7, 2010, 1:37 PM Aaron, Sorry, I must not really have explained clearly. This isn't an abstraction layer, but more like a UI component or widgit that facilities basic reporting. Look at these pages: http://www.redmine.org/issues http://trac.edgewall.org/query]....
_______________________________________________ Web-SIG mailing list Web-SIG@python.org Web SIG: http://www.python.org/sigs/web-sig Unsubscribe: http://mail.python.org/mailman/options/web-sig/archive%40mail-archive.com
