[Sqlalchemy-users] Re: intro to the 0.2 series

Michael Bayer wrote: hi Jürgen - I checked in a fix which allows your test program to work. Thanks for the quick change. It works now. im still playing with interfaces a lot in 0.2 so expect it to be pretty unstable until i move it to the trunk. No problem. The new version makes it much s

[Sqlalchemy-users] BUG: having clause for postgresql

Hi, "Having" clause needs to be before "Order by" for postgresql. Index: ansisql.py === --- ansisql.py (revision 1387) +++ ansisql.py (working copy) @@ -371,15 +371,15 @@ if group_by: text += " GROUP BY " + gr

[Sqlalchemy-users] SQLAlchemy 0.2 docs preview

I have been trying to work on these as much as possible in the past two weeks as many of the pages had to be almost totally rewritten. still not done, "advanced datamapping", "types", "pooling" and the docstrings are still pretty out of whack, and theres nothing yet about the new inheritan

[Sqlalchemy-users] SQLAlchemy tutorial

I was recommending SQLAlchemy to several of my co-workers, and someone asked me if I could write up a short introduction to SQLAlchemy. Well, my short introduction turned into a full-blown tutorial. I've put it on the Web at http://www.rmunn.com/sqlalchemy-tutorial/tutorial.html, and I'd be more t

Re: [Sqlalchemy-users] Reflection with Subselect Running Astray of convert_unicode=True

This has been fixed and committed, according to Mike. -G On Wednesday, May 3, 2006, 1:58:40 PM, you wrote: > Hey All, > I'm running into an interesting problem. There's a quick obvious solution, > but I think it's a placebo, so I want to run this by everyone else first. > In this case (attached

Re: [Sqlalchemy-users] Re: intro to the 0.2 series

hi Jürgen - I checked in a fix which allows your test program to work. im still playing with interfaces a lot in 0.2 so expect it to be pretty unstable until i move it to the trunk. - mike On May 3, 2006, at 9:57 AM, j.kartnaller wrote: Hello Michael. Actually I'm trying to integrate S

Re: [Sqlalchemy-users] object leak with objectstore.clear on linux

i guess its looking that way, huh.  On May 3, 2006, at 11:30 AM, Jonathan Ellis wrote:On 5/3/06, Michael Bayer <[EMAIL PROTECTED]> wrote: if you want to fix the memory leak directly in the non-trunk, iveattached a patch which is essentially just "lib/sqlalchemy/attributes.py" diffed from 0.1.6 to t

Re: [Sqlalchemy-users] session context proposal

On May 2, 2006, at 10:13 PM, Daniel Miller wrote: If you're interested, I have lot's of comments like this on various parts of the SQLAlchemy API. im sure you do, but one thorny issue of SA is that it supports multiple programming styles, particularly in 0.2, where you can use an expli

Re: [Sqlalchemy-users] object leak with objectstore.clear on linux

On 5/3/06, Michael Bayer <[EMAIL PROTECTED]> wrote: if you want to fix the memory leak directly in the non-trunk, iveattached a patch which is essentially just "lib/sqlalchemy/attributes.py" diffed from 0.1.6 to the trunk.Out of curiosity, do you plan to do a 0.1.7 bugfix release at some point?--

Re: [Sqlalchemy-users] object leak with objectstore.clear on linux

if you want to fix the memory leak directly in the non-trunk, ive attached a patch which is essentially just "lib/sqlalchemy/ attributes.py" diffed from 0.1.6 to the trunk. attributes.py.patch Description: Binary data if you want to look into the types thing, custom types that extend th

[Sqlalchemy-users] Re: intro to the 0.2 series

Hello Michael. Actually I'm trying to integrate SA into zope 3. It seems as if 0.2 would simplify the integration. But I have a problem with this test program : import sqlalchemy aTable = sqlalchemy.Table( 'aTable', sqlalchemy.MetaData(), sqlalchemy.Column('id', sqlalchemy.Integer,

[Sqlalchemy-users] rowid issue

Hi, On the current trunk (r1377) a specific usage constelation the query goes awry on an oracle error message: sqlalchemy.exceptions.SQLError: (DatabaseError) ORA-00904: "CONTENT_TYPE"."ROWID": invalid identifier The test and complete traceback are in the atachement. See also the ticket http://ww

Re: [Sqlalchemy-users] session context proposal

> Right? Yes, that's fine. That (the first version) will work with > either classmethod or instance method. I don't see much use in an > instance method ATM, but you're right why not allow it? It will allow > (tempt?) people to do things they shouldn't do, but hey this is Python > and we're consent

Re: [Sqlalchemy-users] object leak with objectstore.clear on linux

I'm somewhat in a tight spot here, is there any specific change which I can get without all the rest that fixes the object issue? (i.e. I don't really have time to go chasing after trunk problems on general principle at the moment) Quoting Michael Bayer <[EMAIL PROTECTED]>: > ah...are you using an

Re: [Sqlalchemy-users] object leak with objectstore.clear on linux

A-ha providing the copy method for a type somewhat solves the issue. However I've got at least 2 new issues now, analyzing. Quoting Michael Bayer <[EMAIL PROTECTED]>: > ah...are you using any custom types ? unfornately I had to shake up > the interface for the TypeEngine object again. otherwise

[Sqlalchemy-users] Reflection with Subselect Running Astray of convert_unicode=True

Hey All, I'm running into an interesting problem. There's a quick obvious solution, but I think it's a placebo, so I want to run this by everyone else first. In this case (attached .sql creates the necessary schema) I have three interconnected tables that I'm viewing using reflection. This is m

Re: [Sqlalchemy-users] object leak with objectstore.clear on linux

Yes, I'm using custom types. Two basically, one who wraps unicode strings and converts them to hex escaped utf-8 and back, and another who always evaluates to the current date/time. Quoting Michael Bayer <[EMAIL PROTECTED]>: > ah...are you using any custom types ? unfornately I had to shake up