[sqlalchemy] Re: Trac feed broken

2009-02-17 Thread Gaetan de Menten
On Tue, Feb 17, 2009 at 03:14, Michael Bayer mike...@zzzcomputing.com wrote: it says to me: Congratulations! [Valid RSS] This is a valid RSS feed. im not able to reproduce any issue in the straight FF reader. Seems like somebody else fixed it, because it works today. -- Gaëtan de

[sqlalchemy] Infinite recursion trying to deserialize any restriction

2009-02-17 Thread Joril
Hi everyone! I have a simple one-to-many relation between two classes, and I'm trying to serialize/deserialize an any restriction on them.. My problem is that deserialization fails with maximum recursion depth exceeded. Am I doing something wrong? Here's my testcase: from sqlalchemy import

[sqlalchemy] Re: A question about best practices after the Object Relational Tutorial

2009-02-17 Thread Ants Aasma
I have written a descriptor for implementing hashed storage of passwords. I added some documentation and added it to the wiki as a recipe: http://www.sqlalchemy.org/trac/wiki/UsageRecipes/HashProperty It doesn't depend on anything in SQLAlchemy and works with any object persistence framework.

[sqlalchemy] Re: Infinite recursion trying to deserialize any restriction

2009-02-17 Thread Michael Bayer
that was a bug, fixed in 5802. On Feb 17, 2009, at 5:48 AM, Joril wrote: from sqlalchemy import Column, Integer, String, ForeignKey from sqlalchemy.ext import serializer from sqlalchemy.orm import relation from sqlalchemy.ext.declarative import declarative_base # Tables definition Base =

[sqlalchemy] TimeoutError: QueuePool limit of size 5 overflow 10 reached, connection timed out, timeout 30

2009-02-17 Thread jo
Hi all, I wonder what this message mean: TimeoutError: QueuePool limit of size 5 overflow 10 reached, connection timed out, timeout 30 any ideas? jo --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy

[sqlalchemy] Auto-loading With Relationships

2009-02-17 Thread Gp
We have sets of databases with several hundred tables per database. Most of these tables are linked using various foreign key relationships. Is there any sort of automatic SQL Alchemy generation? Either SQL Soup like loading or a script that gets run once that generates code for use. -Gp

[sqlalchemy] Re: Auto-loading With Relationships

2009-02-17 Thread Michael Trier
Hi, On Tue, Feb 17, 2009 at 2:50 PM, Gp gpm...@gmail.com wrote: We have sets of databases with several hundred tables per database. Most of these tables are linked using various foreign key relationships. Is there any sort of automatic SQL Alchemy generation? Either SQL Soup like loading or

[sqlalchemy] Specifying descending order_by on a backref

2009-02-17 Thread Ken
I'm using the declarative extension. When I specify a backref on a relation, I see the order_by argument and I'm pointing it to the column object. That works, but I need to sort the backref descendingly, not ascendingly. I don't see an option for that in the Relation()/backref() arguments. What

[sqlalchemy] Re: Specifying descending order_by on a backref

2009-02-17 Thread Michael Trier
On Tue, Feb 17, 2009 at 5:03 PM, Ken kkin...@gmail.com wrote: I'm using the declarative extension. When I specify a backref on a relation, I see the order_by argument and I'm pointing it to the column object. That works, but I need to sort the backref descendingly, not ascendingly. I don't

[sqlalchemy] Re: Specifying descending order_by on a backref

2009-02-17 Thread Ken
On Feb 17, 3:13 pm, Michael Trier mtr...@gmail.com wrote: backref supports the same arguments as relation(), which include an order_by argument. http://www.sqlalchemy.org/docs/05/reference/orm/mapping.html?highligh... Michael, I'm using the order_by argument. The problem is that it's sorting

[sqlalchemy] Re: Specifying descending order_by on a backref

2009-02-17 Thread Michael Trier
Hi, On Tue, Feb 17, 2009 at 5:22 PM, Ken kkin...@gmail.com wrote: On Feb 17, 3:13 pm, Michael Trier mtr...@gmail.com wrote: backref supports the same arguments as relation(), which include an order_by argument. http://www.sqlalchemy.org/docs/05/reference/orm/mapping.html?highligh...

[sqlalchemy] Re: Specifying descending order_by on a backref

2009-02-17 Thread Ken
On Feb 17, 3:29 pm, Michael Trier mtr...@gmail.com wrote: Sorry, I misunderstood. You should be able to do a order_by=field.desc(). Ah, that answers my question. Thanks! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[sqlalchemy] Re: Auto-loading With Relationships

2009-02-17 Thread Gp
According to Autocode's readme it doesn't support relationships. The major reason that Soup won't work for me is it doesn't support relationships between tables. I'm still going to take a closer look at Autocode. Thanks for the suggestion. -Paul On Feb 17, 4:09 pm, Michael Trier mtr...@gmail.com