[sqlalchemy] Re: duplicating relation()s

2008-12-16 Thread az
mmh. maybe something around cascades? your 'links' are also not an asociation. On Tuesday 16 December 2008 17:09:49 Julien Cigar wrote: Hi svil, OK, I found back http://groups.google.com/group/sqlalchemy/browse_thread/thread/c1bd 8cfe862441d6/83f3d5d6fde74b89 It seems that the way I

[sqlalchemy] Re: [SA0.5b4/Postgres 7.4] ValueError: 'need more than 0 values to unpack'

2008-12-16 Thread Michael Bayer
your mappers are failing to compile (i.e. if you were to call compile_mappers() manually), and the stack trace is specific to a relation(), which you haven't illustrated in your setup. On Dec 16, 2008, at 7:31 AM, Andreas Jung wrote: Hi, I have a fairly complex model using the

[sqlalchemy] Re: [SA0.5b4/Postgres 7.4] ValueError: 'need more than 0 values to unpack'

2008-12-16 Thread Andreas Jung
There is no relation() involved here. Every relation() related code is commented right now. (see attachment). Andreas On Tue, Dec 16, 2008 at 4:48 PM, Michael Bayer mike...@zzzcomputing.comwrote: your mappers are failing to compile (i.e. if you were to call compile_mappers() manually), and

[sqlalchemy] Re: Mapping an array of strings?

2008-12-16 Thread Joril
Michael Bayer ha scritto: hibernate-style custom types are documented here: http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/types.html?highlight=typeengine#custom-types or you can use PickleType. Perfect, many thanks! --~--~-~--~~~---~--~~ You

[sqlalchemy] duplicating relation()s

2008-12-16 Thread Julien Cigar
Dear SQLAlchemy users, I have a mapped object called Species with a lot of relation() in it. The user wants to have a duplicate function, so for a given Species a new exact copy should be created, with all the relation(). I have pasted a copy of my code here : http://pastebin.com/f3e50a4fa As

[sqlalchemy] Re: Abstract base class

2008-12-16 Thread Michael Bayer
an abstract base class isn't going to set up the same fields on all descendants since the mapper()/Table() setup occurs during the creation of the individual class using the non-inherited class dict, and unique instances of each of the Column, etc. elements are required as well. concrete

[sqlalchemy] [SA0.5b4/Postgres 7.4] ValueError: 'need more than 0 values to unpack'

2008-12-16 Thread Andreas Jung
Hi, I have a fairly complex model using the declarative layer. For a simple table 'fassung' Toolbox2=# \d fassung Table public.fassung Column| Type | Modifiers

[sqlalchemy] Re: duplicating relation()s

2008-12-16 Thread Julien Cigar
Hi svil, OK, I found back http://groups.google.com/group/sqlalchemy/browse_thread/thread/c1bd8cfe862441d6/83f3d5d6fde74b89 It seems that the way I planned to do it is the right way to do it if I understood well. I added the lines 113-117 at http://pastebin.com/f17e29b0f but it gives me an error

[sqlalchemy] Vague InterfaceError (threading issue?) running normal query

2008-12-16 Thread Ken
I'm using CherryPy with SQLAlchemy. I've tried this with both SQLAlchemy's scoped_session thread-local sessions, as well as (also local-to-thread) sessions I create in my web code manually. 2008-12-16 11:51:14,524 DEBUG cherrypy.error.140068141119376: [16/Dec/ 2008:11:51:14] HTTP Traceback (most

[sqlalchemy] is eager loading unidirectional when using backrefs?

2008-12-16 Thread tobin
I've ran into this and i'm not sure if this is a bug or a feature, but I haven't read anything about this. I had: two tables: groups and group_types, where groups had an fk to group_types groups: id, name, group_type_id group_types: id, name two mappers: group_mapper: lazy=False

[sqlalchemy] Re: is eager loading unidirectional when using backrefs?

2008-12-16 Thread Michael Bayer
On Dec 16, 2008, at 1:58 PM, tobin wrote: I've ran into this and i'm not sure if this is a bug or a feature, but I haven't read anything about this. I had: two tables: groups and group_types, where groups had an fk to group_types groups: id, name, group_type_id group_types: id, name

[sqlalchemy] Polymorphic Identity and declarative base

2008-12-16 Thread vctr...@gmail.com
A newbie question: Is there a way to define a subclass using declarative base which defined the polymorphic identity on more than one value? Is there a way to do it outside the declarative base? A bane example: In subclass Citrus I would like to be able to declare several types of fruits