Re: [sqlalchemy] SQLite supports generated column, but SQLAlchemy doesn't seem to know this

2020-05-01 Thread bb1898
Am Freitag, 1. Mai 2020 17:05:27 UTC+2 schrieb Mike Bayer: > > > > OK well, 2020-1-22 was just four months ago, so SQLAlchemy certainly needs > some time to add support for new database features. Please open an issue > at github.com/sqlalchemy/sqlalchemy/issues . > > True - moreover I just saw

Re: [sqlalchemy] SQLite supports generated column, but SQLAlchemy doesn't seem to know this

2020-05-01 Thread Mike Bayer
On Fri, May 1, 2020, at 10:55 AM, bb1898 wrote: > Using Python 3.8.2, SQLAlchemy 1.3.16 on Windows 10. > > From version 3.31.0 (2020-01-22) SQLite supports generated columns; > documentation: https://sqlite.org/gencol.html > So I tried to create a table in a SQLite database using this table

Re: [sqlalchemy] Join while filtering on M2M

2020-05-01 Thread Mike Bayer
On Thu, Apr 30, 2020, at 8:17 AM, Marat Sharafutdinov wrote: > from sqlalchemy import Column, ForeignKey, Integer, create_engine > from sqlalchemy.ext.declarative import declarative_base > from sqlalchemy.orm import relationship, sessionmaker > > Base = declarative_base() > > class User(Base):

[sqlalchemy] SQLite supports generated column, but SQLAlchemy doesn't seem to know this

2020-05-01 Thread bb1898
Using Python 3.8.2, SQLAlchemy 1.3.16 on Windows 10. >From version 3.31.0 (2020-01-22) SQLite supports generated columns; documentation: https://sqlite.org/gencol.html So I tried to create a table in a SQLite database using this table definition: class MieterRechnung(Base):