Re: [sqlalchemy] How to reflect database with auto quote_name of __tablename__ ?

2016-11-15 Thread uralbash
Thank you, I have prepared a simple example with three tables https://gist.github.com/uralbash/a623e621093a6a10fd2ea85b5a1ee124 To avoid install FireBird in my system I use Docker + Vagrant https://github.com/uralbash/docker-template/blob/master/vagrant/databases/firebird/Vagrantfile and GUI c

[sqlalchemy] SQLAlchemy 1.1.4 Released

2016-11-15 Thread mike bayer
SQLAlchemy release 1.1.4 is now available. Release 1.1.4 includes a variety of bug fixes, some backported to the 1.0 series and others which repair minor regressions in the 1.1 series. There is also an important fix to the new Postgresql ON CONFLICT feature, as well as a new feature allowing

Re: [sqlalchemy] Specifiy columns in insert or update statement

2016-11-15 Thread mike bayer
your best bet might be to set those up as FetchedValue from sqlalchemy import FetchedValue class Foo(Base): # ... some_col = Column(Integer, server_default=FetchedValue) On 11/15/2016 06:17 AM, Julien Meyer wrote: Hello, By default, all columns are used in an insert statement. Is

Re: [sqlalchemy] Using Python 'sorted' doesn't change data?

2016-11-15 Thread TomS.
Great! Thank you for your answer and hints! Cheers On 11/08/2016 10:30 PM, mike bayer wrote: it does not, and as an exercise I'd recommend trying to theorize how sorted() *could* make such an effect - and if it did, what assumptions would it be making? Hopefully this would reveal that the a

[sqlalchemy] Specifiy columns in insert or update statement

2016-11-15 Thread Julien Meyer
Hello, By default, all columns are used in an insert statement. Is it possible to specify which columns should be used ? The problem I want to solve : I add dynamicly some columns on a mapper. This mapper is used for two databases but only one database has the dynamic fields. I used the deferr