SQLAlchemy模型像Django的Save方法？ [英] SQLAlchemy Model Django like Save Method?

问题描述

我正在为项目使用sqlalchemy。但是，我更习惯Django的ORM。

I am using sqlalchemy for a project. However, I am more accustomed to Django's ORM.

我想知道在sqlachemy ORM中是否存在与Django模型的save（）方法类似的东西，我可以重写该方法以在执行时自动执行操作提交 /保存。

I would like to know if, in the sqlachemy ORM, there is anything similar to a Django models' save() method that I can overrride to implement actions automatically upon a 'commit' / 'save.'

推荐答案

您可以使用一些简单的crud方法扩展模型，以实现类似于Django ORM的功能。 / ActiveRecord：

You can extend your models with some simple crud methods to achieve something similar to Django ORM / ActiveRecord:

# SQLAlchemy db_session setup omitted
...

Model = declarative_base(name='Model')
Model.query = db_session.query_property()

class CRUD():

     def save(self):
         if self.id == None:
             db_session.add(self)
         return db_session.commit()

      def destroy(self):
          db_session.delete(self)
          return db_session.commit()

class User(Model, CRUD):
    __tablename__ = 'users'
    id = db.Column(db.integer, primary_key=True)
    email = db.Column(db.String(120), unique=True)

    def __init__(self, email):
        self.email = email

然后您可以根据需要保存或销毁模型：

You can then save or destroy the model as needed:

user = User('[e-mail]')
user.save()

这篇关于SQLAlchemy模型像Django的Save方法？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！