[sqlalchemy] Re: Running initialization code after creating/loading an object

2007-03-02 Thread Sanjay
Hi Rick, This was exactly what I needed. Thanks a lot! Sanjay (I think I wrote this message yesterday also, which did not appear. Might have pressed the discard button?!) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[sqlalchemy] Re: SQA failing on table creation

2007-03-02 Thread King Simon-NFHD78
percious wrote: Here is the dump: ...snip... sqlalchemy.exceptions.SQLError: (OperationalError) (1071, 'Specified key was too long; max key length is 999 bytes') '\nCREATE TABLE `Album` (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tname VARCHAR(128), \n\tdirectory VARCHAR(512),

[sqlalchemy] Re: prettyprint sql

2007-03-02 Thread svilen
done, ticket 497 are we talking about adding a couple of \ns around ansicompiler ? sure. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: How do you execute pure SQL against placeholders?

2007-03-02 Thread metaperl
Yes Mike, thanks for the link. Am I to understand that SA does not figure out whether to quote the placeholder based on the type of the data? I was hoping if the data supplied was a string, that it would quote the data. On Mar 1, 3:30 pm, Michael Bayer [EMAIL PROTECTED] wrote: text(select *

[sqlalchemy] Re: query on self-referencing polymorphic mapper

2007-03-02 Thread svilen
hi. i have the case of polymorphic mapper referencing itself (or other of it's sub-class objects), and i want to query/filter on a value of the referenced object. e.g. all people who have friends of age 25. these are highly highly complex queries and im not sure if the Query SQL

[sqlalchemy] Re: How do you execute pure SQL against placeholders?

2007-03-02 Thread Michael Bayer
its a bind parameter, no quoting is required. On Mar 2, 2007, at 9:26 AM, metaperl wrote: Yes Mike, thanks for the link. Am I to understand that SA does not figure out whether to quote the placeholder based on the type of the data? I was hoping if the data supplied was a string, that it

[sqlalchemy] Re: query on self-referencing polymorphic mapper

2007-03-02 Thread Michael Bayer
not like ive been digging into your specific issues recently, but i added a flag that made the new abc tests a lot easier, for this PG issue in particular. the polymorphic unions look like this now: abcjoin = polymorphic_union( {a:ta.select(tb.c.id==None,