On Tue, 29 Aug 2006 10:28:11 -0400
Michael Bayer <[EMAIL PROTECTED]> wrote:
> youre probably looking for:
>
> self.mysession.query(Spectrometers).select(...)
>
Oops .... :-(( You are ready.
Thanks a lot.
>
> On Aug 29, 2006, at 9:46 AM, Enrico Morelli wrote:
>
> > Dear all,
> >
> > I'm writing a program using CherryPy and SQLAlchemy that works fine
> > if I don't use the SA session. When I start to use sessions I have
> > the following error:
> >
> > Traceback (most recent call last):
> > File "webnmr_sqlalchemy_psql.py", line 2392, in ?
> > cherrypy.root.HttpProtected = HttpProtected()
> > File "webnmr_sqlalchemy_psql.py", line 180, in __init__
> > self.instruments=self.mysession(Spectrometers).select
> > (spectrometer.c.tipology=='S',
> > order_by=['name'])
> > TypeError: 'Session' object is not callable
> >
> > These are some few lines from the program.
> >
> > import cherrypy
> > from sqlalchemy import *
> >
> > class HttpProtected:
> >
> > def __init__(self):
> >
> >
> > engine=create_engine('postgres://[EMAIL PROTECTED]:5432/NMR2')
> >
> > metadata = BoundMetaData(engine)
> >
> > projects=Table('projects',metadata, autoload=True)
> >
> > class Projects(object):
> > pass
> > projectmapper = mapper(Projects, projects)
> > self.mysession = create_session()
> > self.instruments=self.mysession(Spectrometers).select
> > (spectrometer.c.tipology=='S',
> > order_by=['name'])
> >
> >
> > Is it possible that the session managed by cherrypy conflicts with
> > the session used by SA? There is a solution?
> >
> > Thanks
> > --
> > -------------------------------------------------------------------
> > (o_
> > (o_ //\ Coltivate Linux che tanto Windows si pianta da solo.
> > (/)_ V_/_
> > +------------------------------------------------------------------+
> > | ENRICO MORELLI | email: [EMAIL PROTECTED] |
> > | * * * * | phone: +39 055 4574269 |
> > | University of Florence | fax : +39 055 4574253 |
> > | CERM - via Sacconi, 6 - 50019 Sesto Fiorentino (FI) - ITALY |
> > +------------------------------------------------------------------+
> >
> > ----------------------------------------------------------------------
> > ---
> > Using Tomcat but need to do more? Need to support web services,
> > security?
> > Get stuff done quickly with pre-integrated technology to make your
> > job easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache
> > Geronimo
> > http://sel.as-us.falkag.net/sel?
> > cmd=lnk&kid=120709&bid=263057&dat=121642
> > _______________________________________________
> > Sqlalchemy-users mailing list
> > Sqlalchemy-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services,
> security? Get stuff done quickly with pre-integrated technology to
> make your job easier Download IBM WebSphere Application Server
> v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________ Sqlalchemy-users
> mailing list Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
--
-------------------------------------------------------------------
(o_
(o_ //\ Coltivate Linux che tanto Windows si pianta da solo.
(/)_ V_/_
+------------------------------------------------------------------+
| ENRICO MORELLI | email: [EMAIL PROTECTED] |
| * * * * | phone: +39 055 4574269 |
| University of Florence | fax : +39 055 4574253 |
| CERM - via Sacconi, 6 - 50019 Sesto Fiorentino (FI) - ITALY |
+------------------------------------------------------------------+
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
