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

微笑先晒代码

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

  • 3
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 4
    评论
评论 4
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值