首页 > 解决方案 > 当我插入管理员或角色时,我得到'在此声明性基础的注册表中找到路径“用户日志”的多个类'?

问题描述

我正在使用db.metadata.clear()清除数据库映射,当我插入管理员或角色时,我收到错误:

sqlalchemy.exc.InvalidRequestError: Multiple classes found for path "Userlogs" in the registry of this declarative base. Please use a fully module-qualified path.
from app import db
from datetime import datetime

db.metadata.clear()


class User(db.Model):
    """
    会员, info简介, face图像, add_time注册时间, uuid唯一标识
    """
    __tablename__ = 'user'

    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100), unique=True)
    pwd = db.Column(db.String(100))
    email = db.Column(db.String(100), unique=True)
    phone = db.Column(db.String(11), unique=True)
    info = db.Column(db.Text)
    face = db.Column(db.String(255), unique=True)
    add_time = db.Column(db.DateTime, index=True, default=datetime.now)
    uuid = db.Column(db.String(255), unique=True)
    user_logs = db.relationship('Userlogs', backref='user')  # 会员日志外键关联
    comments = db.relationship('Comment', backref='user')
    moviecols = db.relationship('Moviecol', backref='user')

    def __repr__(self):
        return '<User %r>' % self.name


class Userlogs(db.Model):
    """
    会员登录日志
    """
    __tablename__ = 'user_logs'

    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))  # db.ForeignKey()创建外键
    ip = db.Column(db.String(100))
    add_time = db.Column(db.DateTime, index=True, default=datetime.now)

    def __repr__(self):
        return '<Userlogs %r>' % self.id

烧瓶:1.1.2

神社2:2.11.1

标签: pythonflask

解决方案


推荐阅读