Re: [Sqlalchemy-users] sharing a session between apache processes

2006-08-08 Thread Alex Greif
rom the database, even if > they haven't changed ... > > I made some basic tests with memcached and it *seems* to work ... > > Regards, > Julien > > Alex Greif wrote: > > Hi Julien, > > > > I also use mod_python in the following way: > > my handler

Re: [Sqlalchemy-users] sharing a session between apache processes

2006-08-08 Thread Alex Greif
Hi Julien, I also use mod_python in the following way: my handler that is decorated with my decorator: @orm_persistent that opens a session and eicher in finally or tin the except block always closes the session, so I can always be sure not to forget to close a session. Of cource I can forget the

[Sqlalchemy-users] query function to get all entities of table

2006-08-08 Thread Alex Greif
Is there a way to use session with query to get all entities of a table mapped to objects? I only see query select_by(...) where I have to provide atleast one keyword argument. So I need a query method that issues a "select * from table" without where statement I use SA 0.2.6 Alex.

[Sqlalchemy-users] detach/reattach objects

2006-06-02 Thread Alex Greif
Hi, is there a possibility to detach/reattache an object from/to the objectstore? Here is a small samle: objectstore.begin load an object o objectstore.flush # some time later change property of o objectstore.begin reattach o objectstore.flush thanks, ALex. ___

Re: [Sqlalchemy-users] mxDateTime problem

2006-05-21 Thread Alex Greif
installing psycopg2 solved the problem. It now works with standard datetime classes It even works fine with my psql 8.0 :) thanks for your help ALex. On 5/21/06, Robin Munn <[EMAIL PROTECTED]> wrote: On 5/21/06, Alex Greif <[EMAIL PROTECTED]> wrote: > I only found the window

Re: [Sqlalchemy-users] mxDateTime problem

2006-05-21 Thread Alex Greif
re not supported by the SA datetime objectsany reason you cant use datetime.datetime ? On May 21, 2006, at 4:18 AM, Alex Greif wrote: > The following code works on windows but crashes on linux. It uses > SA 0.1.7. > I am not sure whether the first import line makes problems, but as I > sai

Re: [Sqlalchemy-users] mxDateTime problem

2006-05-21 Thread Alex Greif
ata type for the last_entry column -- which only stores time-of-day. Don't you want a DateTime data type for that column instead? yes I want to store only the time, so it was my intention to have a date and a time column ALex. On 5/21/06, Robin Munn <[EMAIL PROTECTED]> wrote

[Sqlalchemy-users] mxDateTime problem

2006-05-21 Thread Alex Greif
The following code works on windows but crashes on linux. It uses SA 0.1.7. I am not sure whether the first import line makes problems, but as I said it works fine on windows. Both running Python-2.4.2 any help is appreciated Alex. ### code ### import mx.DateTime.DateTime as mxD

Re: [Sqlalchemy-users] getting the global proxy engine for transaction management

2006-05-20 Thread Alex Greif
I use something like this: global_connect('postgres://database=...') engine = schema.default_engine.get_engine() engine.echo = True engine.begin() objectstore.begin() ... HTH Alex. On 5/21/06, Brad Clements <[EMAIL PROTECTED]> wrote: I'm using the current svn checkout of sql

[Sqlalchemy-users] Re: setting echo for global_connect engine

2006-05-11 Thread Alex Greif
I found it myself: schema.default_engine.get_engine().echo = True Alex. On 5/11/06, Alex Greif <[EMAIL PROTECTED]> wrote: Hi I do a global_connect and access the engine afterwards via schema.default_engine. But schema.default_engine.echo = True has no effect Hi can I set the echo flag o

[Sqlalchemy-users] setting echo for global_connect engine

2006-05-11 Thread Alex Greif
Hi I do a global_connect and access the engine afterwards via schema.default_engine. But schema.default_engine.echo = True has no effect Hi can I set the echo flag on this engine? I am using 0.1.7 Alex. --- Using Tomcat but need to do more?