attributeerror 3a type object 27user 27 has no attribute 27query 27

1import os
2import sys
3from sqlalchemy import Column, ForeignKey, Integer, String, DateTime, Boolean, Float, Date, Table
4from sqlalchemy.ext.declarative import declarative_base
5from sqlalchemy.orm import relationship
6from sqlalchemy import create_engine
7from flask_security import Security, SQLAlchemyUserDatastore, UserMixin, RoleMixin, login_required
8
9Base = declarative_base()
10
11roles_users = Table('roles_users', Base.metadata, Column('user_id', Integer, ForeignKey('user.id')), Column('role_id', Integer, ForeignKey('role.id')))
12
13class Role(Base, RoleMixin):
14    __tablename__ = 'role'
15    id = Column(Integer, primary_key=True)
16    name = Column(String(80), unique=True)
17    description = Column(String(255))
18
19class User(Base, UserMixin):
20    __tablename__ = 'user'
21
22    id = Column(Integer, primary_key=True)
23    email = Column(String(250), nullable=False)
24    password = Column(String(30))
25    last_login_at = Column(DateTime)
26    active = Column(Boolean)
27    confirmed_at = Column(DateTime)
28    current_login_at = Column(DateTime)
29    last_login_ip = Column(String(45))
30    current_login_ip = Column(String(45))
31    login_count = Column(Integer)

1from decouple import config
2from sqlalchemy import create_engine
3from sqlalchemy.orm import sessionmaker, scoped_session, declarative_base
4from types import SimpleNamespace
5
6SQLALCHEMY_DATABASE_URL = config('SQLALCHEMY_DATABASE_URL')
7engine = create_engine(SQLALCHEMY_DATABASE_URL)
8Session = sessionmaker(autocommit=False, autoflush=False, bind=engine)
9
10session = scoped_session(Session)
11Base = declarative_base()
12# Note the line below
13Base.query = session.query_property()
14
15
16class User(Base):
17    __tablename__ = 'user'
18
19    id = Column(Integer, primary_key=True)
20    email = Column(String(250), nullable=False)
21    password = Column(String(30))
22    last_login_at = Column(DateTime)
23    active = Column(Boolean)
24    confirmed_at = Column(DateTime)
25    current_login_at = Column(DateTime)
26    last_login_ip = Column(String(45))
27    current_login_ip = Column(String(45))
28    login_count = Column(Integer)