Re: [sqlalchemy] bulk update with inheritance : weird behavior

2017-05-04 Thread yoch . melka
Thank you Mike for this clear explanation ! Le jeudi 4 mai 2017 16:41:37 UTC+3, Mike Bayer a écrit : > > > > > > In my real use case, we have to update both parent and child columns, so > > I want to use the Children class. > > so SQLite won't support that (nor will Postgresql or most other DBs

Re: [sqlalchemy] bulk update with inheritance : weird behavior

2017-05-04 Thread mike bayer
On 05/04/2017 09:29 AM, yoch.me...@gmail.com wrote: Le jeudi 4 mai 2017 16:07:22 UTC+3, Mike Bayer a écrit : On 05/04/2017 08:41 AM, yoch@gmail.com wrote: > Hi, > > I'm facing to a strange behavior with bulk update on inherited class. > > Is this a bug

Re: [sqlalchemy] bulk update with inheritance : weird behavior

2017-05-04 Thread yoch . melka
Le jeudi 4 mai 2017 16:07:22 UTC+3, Mike Bayer a écrit : > > > > On 05/04/2017 08:41 AM, yoch@gmail.com wrote: > > Hi, > > > > I'm facing to a strange behavior with bulk update on inherited class. > > > > Is this a bug ? > > it's not. > > > http://docs.sqlalchemy.org/en/latest/orm/quer

Re: [sqlalchemy] bulk update with inheritance : weird behavior

2017-05-04 Thread mike bayer
On 05/04/2017 08:41 AM, yoch.me...@gmail.com wrote: Hi, I'm facing to a strange behavior with bulk update on inherited class. These two queries work differently : # raise : Unconsumed column names: name try: session.query(Engineer).filter(Engineer.name=='bar').update({'name':'baz'}

[sqlalchemy] bulk update with inheritance : weird behavior

2017-05-04 Thread yoch . melka
Hi, I'm facing to a strange behavior with bulk update on inherited class. These two queries work differently : from sqlalchemy import Column, Integer, String, ForeignKey, create_engine from sqlalchemy.orm import relationship, Session from sqlalchemy.ext.declarative import declarative_base Base