python - Flask 和 Postgresql - sqlalchemy.exc.DataError: (psycopg2.errors.InvalidTextRepresentation) 枚举的无效输入值

Question

这是模型

from sqlalchemy.dialects import postgresql


class MyModel(db.Model):
    __tablename__ = 'mytables'

    id = db.Column(db.Integer, primary_key=True)
    datetime = db.Column(db.DateTime, nullable=False)
    option = db.Column(postgresql.ENUM('YES', 'NO', 'MAYBE', name='_option', create_type=False), nullable=False)
    data = db.Column(db.String(20))

这是我用来存储数据的类

class myList(Resource):
    parser = reqparse.RequestParser()

    def post(self):
        data = myList.parser.parse_args()

        my_json = request.get_json()
        my_data = my_schema.load(my_json)

        my_data.save()

        return my_schema.dump(my_data), 201

这是我的架构

from ma import ma
from models.mymodel import MyModel

class MySchema(ma.SQLAlchemyAutoSchema):
    class Meta:
        model = MyModel
        load_instance = True
        include_fk = True

这是完整的错误消息，假设我输入 YES

sqlalchemy.exc.DataError: (psycopg2.errors.InvalidTextRepresentation) invalid input value for enum status_option: ""YES""

标签： pythonpostgresqlflaskflask-sqlalchemy

Answer 1

最后我找到了解决方案

所以在我提出问题的模型表下面，我有这个方法

def __init__(self, datetime, option, data):
    self.datetime = datetime
    self.option = json.dumps(option)
    self.data = data

然后我把它改成这个和它的工作

def __init__(self, datetime, option, data):
    self.datetime = datetime
    self.option = option
    self.data = data