[sqlalchemy] Re: Why isn't this Json column type working?

2010-09-19 Thread Jason Baker
On Sep 18, 9:08 pm, Michael Bayer mike...@zzzcomputing.com wrote:  You might after that also throw a pdb into the process_bind_param() method and ensure that its being called Sorry, I should have been more clear about this. If I add a print statement in process_bind_param it doesn't get

Re: [sqlalchemy] Re: internationalization of content

2010-09-19 Thread werner
Hi, Having seen Nil's elexir approach I had another go at this problem. I wanted a solution which is usable from non Python tools accessing the database, so I came up with: e.g. for countries: - Country/countries - class and table with the default language values and everything else for

[sqlalchemy] Re: internationalization of content

2010-09-19 Thread NiL
Hi, I must admit that I discovered the test I wrote to assert my approach works for polymorphic content is wrongly True. I'm working at making it reallty work but it is not that easy. Still for non polymorphic content it is quite ok of course, it is completely elixir oriented, but I'm sure it

[sqlalchemy] Re: Serializable txns not useful on sqlite because do_begin() does nothing

2010-09-19 Thread Randall Nortman
On Sep 18, 11:59 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Sep 18, 2010, at 6:52 PM, Randall Nortman wrote: In testing my code for concurrency, I discovered that transactions are not properly isolated on sqlite, even with isolation_level='SERIALIZABLE'.  It turns out that on the

[sqlalchemy] Re: Pulling objects out of SQLAlchemy object

2010-09-19 Thread cd34
On Sep 19, 12:36 pm, Michael Bayer mike...@zzzcomputing.com wrote: If I reference order_by=Block_element.sorttree, paster crashes with the same error. order_by='somestr' with declarative means the string is a Python eval.  So if you wanted to put the name of the Table here, its

[sqlalchemy] polymorphic single table inheritance with __mapper_args__ automagically set

2010-09-19 Thread Eduardo Robles Elvira
Hello everyone: I'm having some trouble with polymorphic single table inheritance. I want my subclasses (Ferrari is a subclass of Car) to have the __mapper_args__ automatically set. How could I do that. I've got this: class Car(Base): __tablename__ = 'car' id = Column(Integer,

[sqlalchemy] sqla 0.6.4, orm, problem with self-referring joins

2010-09-19 Thread me
when i apply multiple joins to orm query, one of them self-referring, using (target, property) form sqla generates the wrong join criteria by selecting aliased table for the left side of the join. tried sqla 0.5.8 and 0.6.4, same result. e.g. for sqla 0.6.4 from