Re: [Sqlalchemy-users] [bug] index name conflicts when two tables have the same column name

2006-05-23 Thread Sean Cazzell
I'm seeing the same problem with postgresql and SA 0.2. Currently indexes are getting named like ux_column/ix_column - is there any reason this couldn't be changed to ux_table_column? I've made the change to schema.py and it works for me. Attached diff is for the 0.2 branch. Sean Cazzell On

[Sqlalchemy-users] 0.2 single table inheritance broken?

2006-05-23 Thread Vladimir Iliev
Hi, I'm trying the single table inheritance example (see the attachment) from the 0.2 docs, and it fails with the following traceback: Traceback (most recent call last): File single.py, line 37, in ? manager_mapper = mapper(Manager, inherits=employee_mapper, polymorphic_identity='manager')

Re: [Sqlalchemy-users] [bug] index name conflicts when two tables have the same column name

2006-05-23 Thread Michael Bayer
thanksin fact i used something less documented, column._label, since that includes logic for truncating the size down if over 30 chars in length. this is committed to 0.1 and 0.2. On May 23, 2006, at 4:12 AM, Sean Cazzell wrote: I'm seeing the same problem with postgresql and SA 0.2.

Re: [Sqlalchemy-users] 0.2 single table inheritance broken?

2006-05-23 Thread Michael Bayer
sorry, i hadnt yet gotten the examples/polymorph/single.py example working, i just committed a small change to 0.2 to recognize an incoming None for the table argument and fixed the single.py example. On May 23, 2006, at 5:13 AM, Vladimir Iliev wrote: Hi, I'm trying the single table

[Sqlalchemy-users] normalization and orm tools

2006-05-23 Thread Julien Cigar
Hello, I have a question which haunts me for some time now, since I'm testing ORM tools in fact. Let's take and example: I have Objects which have a name which could be in multiples languages. I usually do a third party table like the following: - a table Objects - a table Languages - a

Re: [Sqlalchemy-users] normalization and orm tools

2006-05-23 Thread Luís Bruno
Hello, Julien Cigar wrote: I have Objects which have a name which could be in multiple languages. I usually do a third table like the following: - a table Objects - a table Languages - a table ObjectNames with a foreign key to Objects, a foreign key to Languages _and_ the translated name.

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

2006-05-23 Thread Brad Clements
On 23 May 2006 at 21:01, Luís Bruno wrote: class DatabaseMiddleware(object): def __init__(self, application, global_conf, db_uri=None, echo=False, **kw): This looks very much like the paste.filter_app_factory protocol, don't you agree? You might as well move the

[Sqlalchemy-users] Postgres injection attack

2006-05-23 Thread Michael Bayer
just saw this today and thought it was interestinga postgres injection attack that *only* bind parameters protects against: http://www.newsforge.com/article.pl?sid=06/05/23/2141246 --- All the advantages of Linux Managed