[sqlalchemy] select .group_by

2010-04-27 Thread jo
Hi all, In version 0.6 seems the group_by property does nothing... (Pdb) sql = select([Verifica.c.codice,func.sum(Prestazione.c.importo).label('importo')]) (Pdb) print sql SELECT verifica.codice, sum(prestazione.importo) AS importo FROM verifica, prestazione (Pdb)

Re: [sqlalchemy] select .group_by

2010-04-27 Thread Lance Edgar
On 4/27/2010 5:22 AM, jo wrote: Hi all, In version 0.6 seems the group_by property does nothing... (Pdb) sql = select([Verifica.c.codice,func.sum(Prestazione.c.importo).label('importo')]) (Pdb) print sql SELECT verifica.codice, sum(prestazione.importo) AS importo FROM verifica, prestazione

Re: [sqlalchemy] select .group_by

2010-04-27 Thread jo
Lance Edgar wrote: On 4/27/2010 5:22 AM, jo wrote: Hi all, In version 0.6 seems the group_by property does nothing... (Pdb) sql = select([Verifica.c.codice,func.sum(Prestazione.c.importo).label('importo')]) (Pdb) print sql SELECT verifica.codice, sum(prestazione.importo) AS importo FROM

[sqlalchemy] database error.

2010-04-27 Thread dhanil anupurath
Am geting the error for using ORACLE database for MYSQL its fine. the out put tracebackl is geting as. Traceback (most recent call last): File /root/tg2env/bin/paster, line 7, in ? sys.exit( File /root/tg2env/lib/python2.4/site-packages/PasteScript-1.7.3-

[sqlalchemy] oracle database error.

2010-04-27 Thread dhanil anupurath
I am using Sqlalchemy with Oracle backend in my project. I am running into listener issues with the Oracle database. Here are the steps that I am following: 1. My connection string. sqlalchemy.url=oracle://root::password@localhost:1521/orcdb 2. Environment variables . export

[sqlalchemy] database error

2010-04-27 Thread dhanil anupurath
Am using the Oracle database to my project after setu is done i have an error ... The tracebacks are the following. File /root/tg2env/lib/python2.4/site-packages/SQLAlchemy-0.5.6- py2.4.egg/sqlalchemy/schema.py, line 1796, in create_all bind.create(self, checkfirst=checkfirst,

Re: [sqlalchemy] oracle database error.

2010-04-27 Thread Michael Bayer
dhanil anupurath wrote: I am using Sqlalchemy with Oracle backend in my project. I am running into listener issues with the Oracle database. Here are the steps that I am following: 1. My connection string. sqlalchemy.url=oracle://root::password@localhost:1521/orcdb 2. Environment

Re: [sqlalchemy] oracle database error.

2010-04-27 Thread dhanil anupurath
SQLPLUS shows no error . I am able to connect to oracle database. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to

Re: [sqlalchemy] oracle database error.

2010-04-27 Thread Mariano Mara
Excerpts from dhanil anupurath's message of Tue Apr 27 07:22:45 -0300 2010: I am using Sqlalchemy with Oracle backend in my project. I am running into listener issues with the Oracle database. Here are the steps that I am following: 1. My connection string.

Re: [sqlalchemy] Storing Nested Lists

2010-04-27 Thread David Gardner
What database are you using? Postgres (and possibly others) support an array type. On 04/25/2010 02:58 PM, greg wrote: Hi All, I'm new to sqlalchemy. I've been reading the documentation and group archives, but can't really find an answer to my question. I suspect it's a question of

Re: [sqlalchemy] Using SQLAlchemy to call stored procedures

2010-04-27 Thread David Gardner
Not sure about Oracle, but you should be able to do something like: from sqlalchemy import func session.query(Employee).filter(Employee.something.in_(func.retrieveList()).all() Not sure about how to get the cursor object. On 04/24/2010 10:38 AM, Mark wrote: Hi everyone, I'm currently

[sqlalchemy] setting the transaction isolation_level?

2010-04-27 Thread gary clark
Hello, I'm using SQLAlchemy with sqlite 3.6.23. I would like to know how you set the transaction isolation_level=immediate. I think this will help with the deadlocks I was having. Just dont know how to implement this. Thanks, Garyc -- You received this message because you are subscribed to

Re: [sqlalchemy] setting the transaction isolation_level?

2010-04-27 Thread Michael Bayer
gary clark wrote: Hello, I'm using SQLAlchemy with sqlite 3.6.23. I would like to know how you set the transaction isolation_level=immediate. I think this will help with the deadlocks I was having. Just dont know how to implement this. I've added ticket 1784 to document this. We support

Re: [sqlalchemy] setting the transaction isolation_level?

2010-04-27 Thread gary clark
Thanks Michael. This is like trudging through knee high mud to find a needle. oh boy. On I go. Thanks, Garyc --- On Tue, 4/27/10, Michael Bayer mike...@zzzcomputing.com wrote: From: Michael Bayer mike...@zzzcomputing.com Subject: Re: [sqlalchemy] setting the transaction isolation_level?