Re: [sqlalchemy] Having trouble using .update() with polymorphic classes

2015-12-15 Thread Mike Bayer
On 12/15/2015 06:26 PM, Gerald Thibault wrote: > I can't figure out the syntax to issue an update, everything I try (attr > name, column name, attribute) results in "unconsumed column names". > > Am I doing something wrong here? MoreTest is mapped using joined table inheritance, mapped to the t

[sqlalchemy] Alembic 0.8.4 Released

2015-12-15 Thread Mike Bayer
Alembic 0.8.4 is now available. Changes in this release include fixes to batch mode and autogeneration. Full changelog is at: http://alembic.readthedocs.org/en/latest/changelog.html#change-0.8.4 Download Alembic 0.8.4 at: https://pypi.python.org/pypi/alembic -- You received this message b

[sqlalchemy] Having trouble using .update() with polymorphic classes

2015-12-15 Thread Gerald Thibault
I can't figure out the syntax to issue an update, everything I try (attr name, column name, attribute) results in "unconsumed column names". Am I doing something wrong here? from sqlalchemy import * from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm.session import Sessi

Re: [sqlalchemy] Reflection of table/columns comments

2015-12-15 Thread Mike Bayer
On 12/15/2015 07:46 AM, Lele Gaifax wrote: > Hi all, > > I'd like to investigate a possible "special" usage/abuse of comments on schema > objects, available for example under PostgreSQL. > > In many applications, I use the "info" slot of table's columns to store visual > settings, mainly a "lab

Re: [sqlalchemy] Using Hybrids for encryption with varying keys

2015-12-15 Thread Mike Bayer
the hybrid method itself refers to those columns. you can put any SQL / Python expression you want inside the hybrid. There's an early intro to the hybrid concept at http://techspot.zzzeek.org/2011/10/21/hybrids-and-value-agnostic-types/ which shows some examples like this. On 12/14/2015 09:

[sqlalchemy] Reflection of table/columns comments

2015-12-15 Thread Lele Gaifax
Hi all, I'd like to investigate a possible "special" usage/abuse of comments on schema objects, available for example under PostgreSQL. In many applications, I use the "info" slot of table's columns to store visual settings, mainly a "label" and an "hint", something like class Player(Globall