Thanks for the 'heads-up' Eric :-)
! Nothing to see here, move right along !
Except... Couple of interesting additions coming up in PostgreSQL 9.1
(still in beta) for anyone who's interested. Release notes:
http://developer.postgresql.org/pgdocs/postgres/release-9-1.html A
couple of
The database is part of a desktop accounting application running on
Windows. I'm writing a program to interface with it, to automate
adding documents.
The idea was that it would be run once a month to add a bunch of
invoices. The backup would run before this operation, in case
something
Hello,
I am trying to use sqlalchemy with oracle, here is my code:
from sqlalchemy import *
from sqlalchemy.orm import sessionmaker, mapper, relationship
class Activite(object):
pass
class Famprod(object):
pass
engine = create_engine('oracle://login/paswd@db', echo=True)
metadata =
On Jul 12, 2011, at 8:27 AM, Maciej Filip Szkodziński wrote:
The database is part of a desktop accounting application running on
Windows. I'm writing a program to interface with it, to automate
adding documents.
The idea was that it would be run once a month to add a bunch of
invoices.
mik wrote:
Hello,
I am trying to use sqlalchemy with oracle, here is my code:
from sqlalchemy import *
from sqlalchemy.orm import sessionmaker, mapper, relationship
class Activite(object):
pass
class Famprod(object):
pass
engine = create_engine('oracle://login/paswd@db',
On Jul 11, 2011, at 5:46 PM, Tarek Ziadé wrote:
Hello
We're using with_hint() to add comments to sql queries, but that'll
be work only with selects.
I guess I can do a compiler extension to be able to add a /* comment
*/ in my queries, but I was wondering:
unless I missed something,
On Tue, Jul 12, 2011 at 4:46 PM, Michael Bayer mike...@zzzcomputing.com wrote:
On Jul 11, 2011, at 5:46 PM, Tarek Ziadé wrote:
Hello
We're using with_hint() to add comments to sql queries, but that'll
be work only with selects.
I guess I can do a compiler extension to be able to add a /*
Hi Krishnakant -
0.7.1 is the current stable production release which is where the focus of
development also lies. 0.6 is in maintenance releases at this point.
0.7 has numerous behavioral and performance advantages over 0.6 and is already
used in production environments.
On Jul 9, 2011, at
Hi Michael et al,
I can not find a way to express my query in SQLAlchemy. What I want to
do is to load all ORM-mapped objects for which another query can not
yield any result (not exists):
select * from entry where not exists (select 1 from lookup where
lookup.skipped_id = entry.id)
For my
Oops, I was trying it with
engine.connect().execution_options(autocommit=True).execute as well,
and didn't notice there was a difference in the echo when editing the
pastebin. There's of course no COMMIT at the end with eng.execute().
I've updated pastebin with both versions.
The behaviour
On Tue, 2011-07-12 at 17:47 +0200, Torsten Landschoff wrote:
How can I correlate the subquery in this context? There is a bunch of
correlate methods (Query.correlate, Select.correlate) but I do not
really understand how to make use of it here.
Okay, I found it: correlate does not
On Jul 12, 2011, at 12:44 PM, Maciej Filip Szkodziński wrote:
Oops, I was trying it with
engine.connect().execution_options(autocommit=True).execute as well,
and didn't notice there was a difference in the echo when editing the
pastebin. There's of course no COMMIT at the end with
On 12/07/11 20:34, Michael Bayer wrote:
Hi Krishnakant -
0.7.1 is the current stable production release which is where the focus of
development also lies. 0.6 is in maintenance releases at this point.
In that case will I have to change my code if I want to shift from 0.6
to 0.7?
I use
On Jul 12, 2011, at 1:57 PM, Krishnakant Mane wrote:
On 12/07/11 20:34, Michael Bayer wrote:
Hi Krishnakant -
0.7.1 is the current stable production release which is where the focus of
development also lies. 0.6 is in maintenance releases at this point.
In that case will I have to
On 12/07/11 23:36, Michael Bayer wrote:
On Jul 12, 2011, at 1:57 PM, Krishnakant Mane wrote:
On 12/07/11 20:34, Michael Bayer wrote:
Hi Krishnakant -
0.7.1 is the current stable production release which is where the focus of
development also lies. 0.6 is in maintenance releases at this
On Jul 12, 2011, at 2:30 PM, Krishnakant Mane wrote:
On 12/07/11 23:36, Michael Bayer wrote:
On Jul 12, 2011, at 1:57 PM, Krishnakant Mane wrote:
On 12/07/11 20:34, Michael Bayer wrote:
Hi Krishnakant -
0.7.1 is the current stable production release which is where the focus of
16 matches
Mail list logo
