sqlacodegen后如何在试图函数用使用query_sqlacodegen 视图-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_40760617/article/details/89502795

在使用sqlacodegen生成ORM模型后，在视图函数尝试通过User.query获取数据时遇到AttributeError，提示User对象没有query属性。问题在于未正确初始化SQLAlchemy Session，导致无法访问数据库。解决方案是确保在调用query之前正确设置并使用Session。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

manager.py

from application import app, manager
from flask_script import Server
import www
# web server
manager.add_command("runserver",
                    Server(host='127.0.0.1', port=app.config['SERVER_PORT'], use_debugger=True, use_reloader=True))

def main():
    manager.run()

if __name__ == '__main__':
    try:
        import sys
        sys.exit(main())
    except Exception as e:
        import traceback
traceback.print_exc()

models.user.User.py 是通过sql语句映射成ORM 使用sqlacodegen

# coding: utf-8
from sqlalchemy import BigInteger, Column, DateTime, Integer, String
from sqlalchemy.schema import FetchedValue
from sqlalchemy.ext.declarative import declarative_base


Base = declarative_base()
metadata = Base.metadata
class TesUsr(Base):
    __tablename__ = 'tes_usr'

    id = Column(Integer, primary_key=True)
    name = Column(String(30), nullable=False)

class User(Base):
    __tablename__ = 'user'

    uid = Column(BigInteger, primary_key=True)
    nickname = Column(String(100), nullable=False, server_default=FetchedValue())

视图函数调用数据库中的数据

from flask import Blueprint,render_template,request,jsonify,make_response,redirect,g
import json
from application import db
from common.models.user.User import TesUsr,User

route_user = Blueprint( 'user_page',__name__ )

@route_user.route( "/" ,methods=['GET','POST'])
def login():

    user =User.query.all()
    print(user)
    return "666"