Re: [Sqlalchemy-users] database literature

Thanks to all for the suggestions. Feel free to keep sending more references... :) Marco Mariani wrote: I'd like to add the following books to the pile of suggestions. These are not for fresh beginners, and can be useful to many. Both are new, and available on Safari. Refactoring

Re: [Sqlalchemy-users] How ACID are SQLAlchemy transactions?

Hello, as far as basic transactional sanity, its reasonable; we imitate the constructs used by Hibernate. in a concurrent environment, I forgot to mention that what I have in mind are not several instances of SQLAlchemy, but a single instance which would be part of something like an

Re: [Sqlalchemy-users] How ACID are SQLAlchemy transactions?

On Sep 19, 2006, at 8:19 AM, Wolfgang Keller wrote: I forgot to mention that what I have in mind are not several instances of SQLAlchemy, but a single instance which would be part of something like an application server. Then all client requests would be processed by one and the

Re: [Sqlalchemy-users] Failure to compile

On Mon, 18 Sep 2006 20:19:20 -0400 Michael Bayer [EMAIL PROTECTED] wrote: somehow you have the User class getting stuck in as a column somewhere...it is probably a subtle mistake in your syntax somewhere Yeah that was exactly the problem. I was doing something like

Re: [Sqlalchemy-users] Self referencing tables

On Mon, 18 Sep 2006 20:29:22 -0400 Michael Bayer [EMAIL PROTECTED] wrote: youre looking for a self-referential mapper. there are three examples of this in... Thanks I'll check those out! My current solution is one big huge duh that I can't believe I didn't think of before. class Node:

Re: [Sqlalchemy-users] How ACID are SQLAlchemy transactions?

On Mon, 18 Sep 2006 20:09:48 +0200 Wolfgang Keller [EMAIL PROTECTED] wrote: Just because I don't want to have to take care of all this transaction management myself, as this is complete rocket-science to me... I know not of ACID, but... rocket science this is not. trans =

[Sqlalchemy-users] Postgres specific: How would i do a VACUUM?

Hello list, I want to do a VACUUM FULL ANALYZE in database maintenance code with SA. When i do: metadata.engine.execute(VACUUM FULL ANALYZE;) I get: SQLError: (ProgrammingError) VACUUM cannot run inside a transaction block 'VACUUM FULL ANALYZE;' {} Is there a workaround. How would i execute

Re: [Sqlalchemy-users] Postgres specific: How would i do a VACUUM?

we generally leave autocommit turned off on the DBAPI connections (which implies theres always a transaction in progress). you might want to see if a straight psycopg2 connection, with autocommit turned on, can even do this. through SA, you can get at the underlying connection and do the

Re: [Sqlalchemy-users] session trouble

Hello, On Mon, 2006-09-18 at 23:14, Jose Galvez wrote: snip uin = dbsession.query(model.Wsi).get_by(uin=image) if uin: xml = uin.xml else: uin=model.Wsi() uin.uin=image xml =