[sqlalchemy] Alembic 0.2.2 released

2012-04-04 Thread Michael Bayer
Hey all - Just had to do some Alembic stuff and noticed nine items in CHANGES unreleased, so I've pushed out 0.2.2. Alembic 0.2.2 is on Pypi: http://pypi.python.org/pypi/alembic/ CHANGES below: 0.2.2 = - [feature] Informative error message when op.XYZ directives are invoked at module im

Re: [sqlalchemy] Problem with Oracle requests

2012-04-04 Thread Borax
Le mercredi 4 avril 2012 17:55:47 UTC+2, Michael Bayer a écrit : > > On Apr 4, 2012, at 11:40 AM, Borax wrote: > > Le mercredi 4 avril 2012 16:27:39 UTC+2, Michael Bayer a écrit : >> >> this all comes down to the nature of the SQL being emitted. >> >> what is the SQL being emitted by SQLAlchemy in

Re: [sqlalchemy] Problem with Oracle requests

2012-04-04 Thread Michael Bayer
On Apr 4, 2012, at 11:40 AM, Borax wrote: > Le mercredi 4 avril 2012 16:27:39 UTC+2, Michael Bayer a écrit : > this all comes down to the nature of the SQL being emitted. > > what is the SQL being emitted by SQLAlchemy in this case, and what is the SQL > that should be emitted ? Working with SQ

Re: [sqlalchemy] Problem with Oracle requests

2012-04-04 Thread Borax
Le mercredi 4 avril 2012 16:27:39 UTC+2, Michael Bayer a écrit : > > this all comes down to the nature of the SQL being emitted. > > what is the SQL being emitted by SQLAlchemy in this case, and what is the > SQL that should be emitted ? Working with SQLAlchemy in a non-trivial way > implies you

Re: [sqlalchemy] Problem with Oracle requests

2012-04-04 Thread Michael Bayer
On Apr 4, 2012, at 10:21 AM, Borax wrote: > Hi, > > I'm using SQLAlchemy 0.7.5 in a web application accessing several tables > containing between 2.5 and 3.5 millions records; these tables are indexed > correctly. > Database is Oracle 10g (release 10.2.0.4). > > My problem is quite simple : w

Re: [sqlalchemy] "REPLACE" exists?

2012-04-04 Thread Michael Bayer
we don't support REPLACE directly as a SQL construct yet so if what you're doing with the string is fine for now, I'd stick with that. On Apr 4, 2012, at 4:41 AM, shinriyo wrote: > Hi there > > I wrote raw SQL like below. > But, I'd like to write without SQL. because, I thknk it is philosophy

[sqlalchemy] Problem with Oracle requests

2012-04-04 Thread Borax
Hi, I'm using SQLAlchemy 0.7.5 in a web application accessing several tables containing between 2.5 and 3.5 millions records; these tables are indexed correctly. Database is Oracle 10g (release 10.2.0.4). My problem is quite simple : when querying the database through SQLAlchemy (via "session.

[sqlalchemy] "REPLACE" exists?

2012-04-04 Thread shinriyo
Hi there I wrote raw SQL like below. But, I'd like to write without SQL. because, I thknk it is philosophy of SQLAlchemy. Do you know how to write instead "REPLACE"? sql = "REPLACE INTO users (id, name, profile_url, access_token) VALUES (?,?,?,?)" self.db.execute(sql,