Re: Python library for generating SQL queries [selects, alters, inserts and commits]

2011-10-14 Thread alex23
Tim Chase wrote: > I'm not sure it can entirely be chalked up to not looking hard > enough. It's explicitly cited in the feature list: Raw SQL statement mapping SQLA's object relational query facilities can accommodate raw SQL statements as well as plain result sets, and object instances can be

Re: Python library for generating SQL queries [selects, alters, inserts and commits]

2011-10-12 Thread Tim Chase
On 10/11/11 22:13, alex23 wrote: They look good, but I'm looking for something which can "compile" down to normal SQL code. Then you're not looking hard enough. SQLAlchemy does this. I'm not sure it can entirely be chalked up to not looking hard enough. Because so many keywords of what's de

Re: Python library for generating SQL queries [selects, alters, inserts and commits]

2011-10-12 Thread Alec Taylor
That's why I said "over the next few days", because learning it for that last assignment would've been too much effort :P On Wed, Oct 12, 2011 at 3:45 PM, wu wei wrote: > Just don't use it for the first time in a demo and then blame me when it > fails ;) > > On Wed, Oct 12, 2011 at 2:05 PM, Alec

Re: Python library for generating SQL queries [selects, alters, inserts and commits]

2011-10-11 Thread Alec Taylor
Great, I'll learn how to use it over the next few days :] On Wed, Oct 12, 2011 at 2:13 PM, alex23 wrote: > On Oct 12, 1:14 am, Alec Taylor wrote: >> They look good, but I'm looking for something which can "compile" down >> to normal SQL code. > > Then you're not looking hard enough. SQLAlchemy

Re: Python library for generating SQL queries [selects, alters, inserts and commits]

2011-10-11 Thread alex23
On Oct 12, 1:14 am, Alec Taylor wrote: > They look good, but I'm looking for something which can "compile" down > to normal SQL code. Then you're not looking hard enough. SQLAlchemy does this. -- http://mail.python.org/mailman/listinfo/python-list

Re: Python library for generating SQL queries [selects, alters, inserts and commits]

2011-10-11 Thread Ben Finney
Alec Taylor writes: > I'm looking for a Python library for generating SQL queries [selects, > alters, inserts and commits]. SQLAlchemy http://www.sqlalchemy.org/> is the leader in this field. It allows your code to interact with the database at different levels: you can write ra

Re: Python library for generating SQL queries [selects, alters, inserts and commits]

2011-10-11 Thread Adam Tauno Williams
Quoting Alec Taylor They look good, but I'm looking for something which can "compile" down to normal SQL code. So that I can just plug that .sql file into any environment [i.e. non-python env] SQLalchemy will happily give you statements and argument lists if that is what you want. query =

Re: Python library for generating SQL queries [selects, alters, inserts and commits]

2011-10-11 Thread Alec Taylor
;> I'm looking for a Python library for generating SQL queries >> [selects, alters, inserts and commits]. > > The popular ones are SQLObject and SQLAlchemy, both just a web-search away. > > Additionally, if you're working with Django, it has its own built-in ORM. > &g

Re: Python library for generating SQL queries [selects, alters, inserts and commits]

2011-10-11 Thread Tim Chase
On 10/11/11 07:08, Alec Taylor wrote: I'm looking for a Python library for generating SQL queries [selects, alters, inserts and commits]. The popular ones are SQLObject and SQLAlchemy, both just a web-search away. Additionally, if you're working with Django, it has its own bu

Re: Python library for generating SQL queries [selects, alters, inserts and commits]

2011-10-11 Thread Yaşar Arabacı
Are you looking for something like this? http://www.sqlalchemy.org/ 2011/10/11 Alec Taylor > Good afternoon, > > I'm looking for a Python library for generating SQL queries [selects, > alters, inserts and commits]. > > I can write them by hand, but thought it would be mor

Python library for generating SQL queries [selects, alters, inserts and commits]

2011-10-11 Thread Alec Taylor
Good afternoon, I'm looking for a Python library for generating SQL queries [selects, alters, inserts and commits]. I can write them by hand, but thought it would be more useful writing them in Python (i.e. client-side referential integrity checking before insert commit + test data gener