Excellent!
Michael Bayer napsal(a):
0.3.7 is out and has a huge number of improvements and fixes. some
of the highlights:
- server side cursor support for Postgres
- much improved auto-reconnect support
- informix support
- long identifier name support
- support for unicode
Hi,
I am currently working on a deeper integration of SA into Zope 2.
Is it possible to determine if an engine has open connections to a database?
Is it possible to close all connections? This is necessary since a database
adapter in Zope can be switched off in order to close connections
Hi!
I have 2 relations:
- recipes-categories (M:N)
- recipes-flags (M:N)
I'd like to get something like:
SELECT recipes.title FROM recipes
JOIN _recipes_ctgs_recipes
ON _recipes_ctgs_recipes.id_recipe = recipes.id
JOIN recipes_ctgs
ON
Hello,
I'm using selectresults and activemapper.
in version 0.3.1 if I did something like x =
Announces.select(Annonces.c.type==A) I got a SelectResults object.
Now (0.3.6) I get a list of Announces (the query is done immediately).
But if I don't specify anything in the select method
Is there any way to have sqlalchemy return the sql that it is going to
execute without actually executing it? I'm using the statement class.
Vineet
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
I have a scenario where we I need to execute SQL directly within a
transaction that is local to a Python thread. Is there some way to this in
SA? In this particular usecase there is no UOW involved. Or is it somehow
to pass a SQL statement somehow to the session and its underlaying
framework?
Just use
print your_statement_variable
Or, if you need it in a variable: str(your_statement_variable) should
do the trick.
On 4/30/07, vinjvinj [EMAIL PROTECTED] wrote:
Is there any way to have sqlalchemy return the sql that it is going to
execute without actually executing it? I'm using
Michael Bayer a écrit :
On Apr 30, 2007, at 9:42 AM, remi jolin wrote:
Hello,
I'm using selectresults and activemapper.
in version 0.3.1 if I did something like x =
Announces.select(Annonces.c.type==A) I got a SelectResults object.
Now (0.3.6) I get a list of Announces (the query is
Hey where are we with this? Does #476 fix #545, or are they unrelated? What
is the current behavior in 0.3.7 with an empty IN() list?
On 4/21/07, Michael Bayer [EMAIL PROTECTED] wrote:
On Apr 13, 2007, at 4:17 PM, Ants Aasma wrote:
I'll try to create a test suite for it next week, I
When I print the statement it just prints the query with placeholders
for the paramters (and not the actual parameters). I would like to get
the actual sql that it is going to execute.
Vineet
On Apr 30, 10:36 am, Gaetan de Menten [EMAIL PROTECTED] wrote:
Just use
print
Hi Mike,
Pursuant to our discussion on another thread regarding buildbots, I've got a
preliminary buildbot slave VM set up as follows:
Ubuntu 6.10
VMware tools
Python 2.4
Buildbot 0.7.4
Postgres 8.2.2
MySQL 5.0.37
Sqlite 3.3.17 (also known as version du semaine these days...)
FreeTDS / UnixODBC
On Apr 30, 1:11 pm, Gaetan de Menten [EMAIL PROTECTED] wrote:
There is (at least) one problem remaining though: subqueries do not
get correlated correctly. This is because the table in the main query
is aliased and the one in the subquery is not and that the
correlator in the Select class
Yes! While most *any* query can be done using sqlalchemy... and you
*should* try to use sqlalchemy because then if you change databases
you won't have to go through all your code and figure out if any of
the sql is different if you're absolutely sure you really really
need to do a bare sql
--On 30. April 2007 19:34:41 + Ian Charnas [EMAIL PROTECTED] wrote:
Yes! While most *any* query can be done using sqlalchemy... and you
*should* try to use sqlalchemy because then if you change databases
you won't have to go through all your code and figure out if any of
the sql is
On Apr 30, 2007, at 8:40 AM, ml wrote:
Hi!
I have 2 relations:
- recipes-categories (M:N)
- recipes-flags (M:N)
I'd like to get something like:
SELECT recipes.title FROM recipes
JOIN _recipes_ctgs_recipes
ON _recipes_ctgs_recipes.id_recipe = recipes.id
JOIN
#545 is all by itself. ants was going to put in the CASE idea last
we spoke.
On Apr 30, 2007, at 11:05 AM, Rick Morrison wrote:
Hey where are we with this? Does #476 fix #545, or are they
unrelated? What is the current behavior in 0.3.7 with an empty IN()
list?
On 4/21/07, Michael
the main effort here is all the familiarizing and configuration of
buildbots, which i have made great efforts to have no understanding
of whatsoever. if a buildbot master doesnt take up a lot of ram or
CPU I could run it on SA's own host.
On Apr 30, 2007, at 11:43 AM, Rick Morrison wrote:
17 matches
Mail list logo