Skip to content

How to migrate from previous flask_sqlalchemy.SQLAlchemy().Model.query to quart-sqlalchemy sqlalchemy.orm? #18

@khteh

Description

@khteh

Previous:

db = flask_sqlalchemy.SQLAlchemy()
class User(db.Model):
    @staticmethod
    def get_user(id):
        return UserModel.query.get(id)
    @staticmethod
    def get_user_by_email(email):
        return UserModel.query.filter_by(email=email).first()
    @staticmethod
    def isExistingUser(email):
        return UserModel.query.filter_by(email = email).count() > 0
    @staticmethod
    def get_users():
        return UserModel.query.all()

After migrating to quart-sqlalchemy:

import sqlalchemy.orm
from src.models.Database import engine
from sqlalchemy.orm import declarative_base, sessionmaker
Base = declarative_base()
class UserModel(Base):

it throws:

  File "/usr/src/Python/PythonRestAPI/src/models/UserModel.py", line 83, in get_users
    return UserModel.query.all()
           ^^^^^^^^^^^^^^^
AttributeError: type object 'UserModel' has no attribute 'query'

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions