首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >flask sqlalchemy postgres模型问题:如何避免手动输入"id“

问flask sqlalchemy postgres模型问题:如何避免手动输入"id“
EN

Stack Overflow用户
提问于 2020-07-01 03:07:38
回答 1查看 106关注 0票数 2

我有一个模型,一个蓝图,还有一些关于这段代码我需要解决的问题。

模型

代码语言:javascript
复制
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

蓝图

代码语言:javascript
复制
@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,这并不是最优的

现在假设我尝试替换上面的代码行:

代码语言:javascript
复制
# 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

代码语言:javascript
复制
feed = FeedItem(caption=data['caption'], url=data['url'])
db.session.add(feed)
db.session.commit()

选项2

代码语言:javascript
复制
feed = FeedItem()
feed.from_dict(data)
db.session.add(feed)
db.session.commit()

选项3

代码语言:javascript
复制
feed = FeedItem()
feed.caption = data['caption']
feed.url = data['url']
db.session.add(feed)
db.session.commit()

对于所有情况,我都会得到以下错误信息:

“列"id”中的null值违反非..null约束..“

代码语言:javascript
复制
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,我应该怎么做?)最好的模式是什么?

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2020-07-01 05:41:07

要使列自动递增,请使用SQLAlchemy/flask-sqlalchemy Column()的autoincrement参数,其中类型为integer。从上面的链接:

自动增量-

为整数主键列设置“自动递增”语义。

票数 2
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/62664547

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档