I learnt about 'sqlpython' recently. There was a talk on this at PyCon2010.
See if that serves your purpose.
It seems to be connected to Oracle/MySql/PostGres etc...
https://twiki.cern.ch/twiki/bin/view/PDBService/SqlPython
https://twiki.cern.ch/twiki/bin/view/PDBService/SqlPythonVishal
On Tue, Mar 9, 2010 at 7:24 PM, Baishampayan Ghose b.gh...@gmail.comwrote:
I am looking for a a way to generate optimised queries in SQL (or
SQL-like languages like Hadoop Pig) by chaining clauses such as where,
group by, order by etc based on a set of (optimising) rules. Is there
any such library in python which would let me do that. Example
approach would be create a query object and then use some inbuilt
method to generate the actual query before executing it.
I will probably have to change whatever alternatives are so a good
starting point would be helpful.
Take something like Django's ORM or SQLAlchemy and hack it until you
are satisfied :)
Regards,
BG
--
Baishampayan Ghose
b.ghose at gmail.com
___
BangPypers mailing list
BangPypers@python.org
http://mail.python.org/mailman/listinfo/bangpypers
--
Thanks and best regards,
Vishal Sapre
---
So say...Day by day, in every way, I am getting better, better and better
!!!
A Strong and Positive attitude creates more miracles than anything else.
Because...Life is 10% how you make it, and 90% how you take it
Diamond is another piece of coal that did well under pressureā
May we do good and not evil. May we find forgiveness for ourself and
forgive others. May we share freely, never taking more than we give.
___
BangPypers mailing list
BangPypers@python.org
http://mail.python.org/mailman/listinfo/bangpypers