[sqlalchemy] tablet version cache

2013-05-09 Thread Treeve Jelbert
i have started having problems when casting spells. I get message: The tablet version cache is damaged, removing it! In some cases it appears multiple times. I tried 'cleanse --tablet' but it makes no difference. Any ideas? Waiting for any Solo casts to complete... Waiting for any other

Re: [sqlalchemy] ColanderAlchemy 0.2a1 released!

2013-05-09 Thread Stefano Fontanelli
Hi Lycovian, you can check Deform: https://pypi.python.org/pypi/deform/ Then use ColanderAlchemy with Deform. I also worked on a DeformAlchemy: https://github.com/stefanofontanelli/DeformAlchemy Unfortunately I have no time to complete it. I used in production but I think it needs more work to be

Re: [sqlalchemy] tablet version cache

2013-05-09 Thread Simon King
On Thu, May 9, 2013 at 9:02 AM, Treeve Jelbert tre...@scarlet.be wrote: i have started having problems when casting spells. I get message: The tablet version cache is damaged, removing it! In some cases it appears multiple times. I tried 'cleanse --tablet' but it makes no difference. Any

[sqlalchemy] Query.update() and joins

2013-05-09 Thread Tobias Bieniek
Hi guys, I have stripped down my problematic code to the following: http://pastebin.com/AvvEr103 I am trying to call the Query.update() method on a query that is using an innerjoin to load some more information that I use in a filter. If I use the same expression to query data everything

[sqlalchemy] How to use schema with DDL()

2013-05-09 Thread Wolfgang Meiners
Hi all, i have a simple database that uses a trigger. After some searching if found the following solution for my problem and everything works fine: In this database i have to tables (valid, invalid) and i can in insert a number into table valid only when this number is not in table invalid. Of

Re: [sqlalchemy] How to use schema with DDL()

2013-05-09 Thread Michael Bayer
On May 9, 2013, at 6:32 AM, Wolfgang Meiners wolfgangmeiner...@web.de wrote: Now i want to run everything inside the schema 'test'. Two questions arises: 1) How can i create schema test automatically when it does not exist? This should be somehow related to

Re: [sqlalchemy] Query.update() and joins

2013-05-09 Thread Michael Bayer
An explicit JOIN isn't supported within an UPDATE statement on the Postgresql platform, SQLAlchemy supports UPDATE..FROM but you need to set up the join condition as an implicit join, which is what mark_type_read2 is essentially doing, establishing the equality between Event and Notification

[sqlalchemy] Re: How to use schema with DDL()

2013-05-09 Thread Wolfgang Meiners
Thank you very much for your hints. They were very helpful! Am 09.05.13 16:16, schrieb Michael Bayer: On May 9, 2013, at 6:32 AM, Wolfgang Meiners wolfgangmeiner...@web.de wrote: Now i want to run everything inside the schema 'test'. Two questions arises: 1) How can i create schema test

[sqlalchemy] Re: Casting an overlap filter as an array

2013-05-09 Thread Glenn Yonemitsu
Just like to bump this issue. Is casting inside an overlap even possible? I've tried all sorts of variations of parameters to see what will stick. I either get the visit_X error or an uncasted query, which then postgresql says the (overlap) operation is not allowed. On Monday, May 6, 2013