Re: [sqlalchemy] Error: ORA-01036: illegal variable name/number

2014-04-04 Thread Matteo Boscolo
Il 03/04/2014 16:27, Simon King ha scritto: On Thu, Apr 3, 2014 at 2:54 PM, Matteo Boscolo wrote: Il 03/04/2014 15:26, Matteo Boscolo ha scritto: Hi All, i got this function to make a query: def getTypeFromId(self,tmm_id): """ get the tipe

Re: [sqlalchemy] Error: ORA-01036: illegal variable name/number

2014-04-03 Thread Matteo Boscolo
Il 03/04/2014 15:26, Matteo Boscolo ha scritto: Hi All, i got this function to make a query: def getTypeFromId(self,tmm_id): """ get the tipe from a given id """ flt="TMM_ID='%s'"%str(tmm_id) for en

[sqlalchemy] Error: ORA-01036: illegal variable name/number

2014-04-03 Thread Matteo Boscolo
;TMM_REVENTITY".plockdate AS "TMM_REVENTITY_plockdate", "TMM_REVENTITY".plockcounter AS "TMM_REVENTITY_plockcounter", "TMM_REVENTITY".revname AS "TMM_REVENTITY_revname", "TMM_REVENTITY".revlabel AS "TMM_REVENTITY_revlabel"

Re: [sqlalchemy] Mandatory fields in tables referencing each other

2013-01-30 Thread Matteo
Alright, many thanks. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@goog

[sqlalchemy] Mandatory fields in tables referencing each other

2013-01-30 Thread Matteo
Hello everybody, I'm currently using PostgreSQL 8.4.9 and SQLAlchemy 0.7.9, and there's an issue I just can't seem to solve. There are 2 tables, User and People. The idea behind this is to have User's "people_id" column point to that user's personal data, and People's "user_id" point to the use

R: Re: [sqlalchemy] dialect sensible declaration

2012-07-16 Thread matteo . boscolo
TIM: la tua mail in mobilità con il BlackBerry® -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.c

R: Re: [sqlalchemy] dialect sensible declaration

2012-07-16 Thread matteo . boscolo
W TIM: la tua mail in mobilità con il BlackBerry® -Original Message- From: alex bodnaru Sender: sqlalchemy@googlegroups.com Date: Mon, 16 Jul 2012 18:51:28 To: Reply-To: sqlalchemy@googlegroups.com Subject: Re: [sqlalchemy] dialect sensible declaration thank you very much michael. bo

[sqlalchemy] Best and easy web framwork for sqlalchemy

2012-05-17 Thread Matteo Boscolo
experience ? regards, Matteo -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more

[sqlalchemy] multi table but single object

2012-04-27 Thread Matteo Boscolo
the fields like in example below.. class table_sum(Base,table_1,table_2,table_3): __tablename__='table_sum' any idea in how to do it or what is the best way to manage this structure ? regards, Matteo -- You received this message because you are subscribed to the Goo

Re: [sqlalchemy] Re: Rollback raises "connection already closed"

2012-04-24 Thread Matteo Boscolo
ix to the 0.6 series. The as-yet-unreleased 0.6.9 is available directly from mercurial: http://hg.sqlalchemy.org/sqlalchemy/archive/rel_0_6.tar.gz -- *OmniaSolutions* /*Matteo Boscolo* Technical Manager/ Cell. +39.327.1525045 Fax. +39.041.8623730 t...@omniasolutions.eu Skype: matteo.boscolo -

Re: [sqlalchemy] Unable to access a dns via sqlalchemy

2012-04-24 Thread Matteo Boscolo
Il 24/04/2012 16:46, Michael Bayer ha scritto: On Apr 24, 2012, at 10:26 AM, Matteo Boscolo wrote: Hi all, I got this pice of code and I'm not able to make it work because it returns: ProgrammingError: (ProgrammingError) ('42000', "[42000] [Microsoft] [Driver ODBC Micros

[sqlalchemy] Unable to access a dns via sqlalchemy

2012-04-24 Thread Matteo Boscolo
") 'SELECT user_name() as user_name;' () code: import sqlalchemy import pyodbc from sqlalchemy import * engine = create_engine('mssql+pyodbc://tmm2011-1') engine.connect() the db = pyodbc.connect('DSN=tmm2011-1') works fine .. any idea ?? regards, Matteo