我有一个模型,一个蓝图,还有一些关于这段代码我需要解决的问题。
模型
from datetime import datetime
from app import db
class FeedItem(db.Model):
__tablename__ = "feed_item"
id = db.Column(db.Integer, primary_key=True)
caption = db.Column(db.String(255), index=True, unique=True, primary_key=True)
url = db.Column(db.String(255), index=True, unique=True, primary_key=True)
createdAt = db.Column(db.DateTime, index=True, default=datetime.utcnow)
updatedAt = db.Column(db.DateTime, index=True, default=datetime.utcnow)
def from_dict(self, data):
for field in ['caption', 'url']:
if field in data:
setattr(self, field, data[field])
def addNewFeed(feed):
"""Add a new test (test)"""
db.session.add(feed)
db.session.commit()
@classmethod
def createFeed(cls, caption, url):
"""Create a new feed (caption, url)"""
newFeed = cls(
caption=caption,
url=url
)
db.session.add(newFeed)
db.session.commit()
return newFeed蓝图
@v1.route("/feed", methods=["POST"])
@v0.route("/feed", methods=["POST"])
def post_feed():
data = request.get_json() or {}
if 'caption' not in data or 'url' not in data:
return bad_request('must include caption and url fields')
# Code that needs to be fixed
feed = FeedItem()
feed.caption = data['caption']
feed.url = data['url']
feed.id = random.randint(100, 99999)
db.session.add(feed)
db.session.commit()
# End of code that needs to be fixed
feed.url = create_presigned_url(feed.url)
return jsonify({
"caption": feed.caption,
"url": feed.url
})问题:
上面的蓝图效果很好。但是,正如您所看到的,我自己创建了feed.id,这并不是最优的
现在假设我尝试替换上面的代码行:
# Code that needs to be fixed
FeedItem()
feed.caption = data['caption']
feed.url = data['url']
feed.id = random.randint(100, 99999)
db.session.add(feed)
db.session.commit()
# End of code that needs to be fixed使用以下3个选项中的任意一个:
选项1
feed = FeedItem(caption=data['caption'], url=data['url'])
db.session.add(feed)
db.session.commit()选项2
feed = FeedItem()
feed.from_dict(data)
db.session.add(feed)
db.session.commit()选项3
feed = FeedItem()
feed.caption = data['caption']
feed.url = data['url']
db.session.add(feed)
db.session.commit()对于所有情况,我都会得到以下错误信息:
“列"id”中的null值违反非..null约束..“
sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) null value in column "id" violates not-null constraint
DETAIL: Failing row contains (null, DogPicture34, my_small_dog34jpg, 2020-06-30 18:51:00.679511, 2020-06-30 18:51:00.679518).
[SQL: INSERT INTO feed_item (caption, url, "createdAt", "updatedAt") VALUES (%(caption)s, %(url)s, %(createdAt)s, %(updatedAt)s)]
[parameters: {'caption': 'DogPicture34', 'url': 'my_small_dog34jpg', 'createdAt': datetime.datetime(2020, 6, 30, 18, 51, 0, 679511), 'updatedAt': datetime.datetime(2020, 6, 30, 18, 51, 0, 679518)}]
(Background on this error at: http://sqlalche.me/e/13/gkpj)问题
1 -What是解决这个问题的最好方法(为了不需要手动输入id,我应该怎么做?)最好的模式是什么?
发布于 2020-07-01 05:41:07
要使列自动递增,请使用SQLAlchemy/flask-sqlalchemy Column()的autoincrement参数,其中类型为integer。从上面的链接:
自动增量-
为整数主键列设置“自动递增”语义。
https://stackoverflow.com/questions/62664547
复制相似问题