Re: [BangPypers] Query generation engine/library
Yeah that was my fallback option. Was just checking if there is something more sophisticated. Looks like I will have to combine parsing with something like spark or some other code generation engine. -- Vinayak On Tue, Mar 9, 2010 at 7:24 PM, Baishampayan Ghose b.gh...@gmail.com wrote: 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 ___ BangPypers mailing list BangPypers@python.org http://mail.python.org/mailman/listinfo/bangpypers
Re: [BangPypers] Query generation engine/library
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
[BangPypers] Query generation engine/library
unlurk from lurking mode 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. -- Vinayak ___ BangPypers mailing list BangPypers@python.org http://mail.python.org/mailman/listinfo/bangpypers
Re: [BangPypers] Query generation engine/library
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