错误：sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError)

最新推荐文章于 2024-08-05 09:36:57 发布

Betabetter

最新推荐文章于 2024-08-05 09:36:57 发布

阅读量3.2w

点赞数 3

分类专栏： python

本文链接：https://blog.csdn.net/u012848622/article/details/62812145

版权

本文介绍了在使用SQLAlchemy时遇到的IntegrityError，具体表现为尝试插入数据库时因键值重复导致的错误。通过分析错误信息，作者发现是尝试插入的name字段值已存在，通过修改值为'aaaaaa99'解决了问题。文章提醒读者在遇到此类问题时，要检查代码并确保数据的唯一性。

摘要由CSDN通过智能技术生成

先晒代码

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import pymysql
app=Flask(__name__)
@app.route('/')
def hello_world():
    return '11hello_world'
app.config['SECRET_KEY']='hard to guess'
app.config['SQLALCHEMY_DATABASE_URI']='mysql+pymysql://root:123456@localhost:3306/news_title'
app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN']=True
app.config['SQLALCHEMY_TRACK_MODIFICATIONS']=True
db=SQLAlchemy(app)

class Title(db.Model):
    __tablename__='title'
    id=db.Column(db.Integer,primary_key=True)
    name=db.Column(db.String(256),unique=True)
    def __ref__(self):
        return '<Title{}>'.format(self.name)
db.create_all()
title_one=Title(name='ddddddd')
title_two=Title(name='aaaaaa')
title_three=Title(name='aaaaaa')
db.session.add_all([title_one,title_two,title_three])
db.session.commit()

if __name__=='__main__':
     app.run()

运行结果显示：

JudydeMacBook-Air:python judy$ python o1.py

Traceback (most recent call last):
File "/Users/judy/anaconda/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
    context)
File "/Users/judy/anaconda/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
    cursor.execute(statement, parameters)
File "/Users/judy/anaconda/lib/python3.6/site-packages/pymysql/cursors.py", line 166, in execute
    result = self._query(query)
File "/Users/judy/anaconda/lib/python3.6/site-packages/pymysql/cursors.py", line 322, in _query
    conn.qu