Python 的 Git 支持的 ORM

Python中Git支持的ORM介绍与案例代码

python
# models.py
from django.db import models
class Article(models.Model):
    title = models.CharField(max_length=200)
    content = models.TextField()
    created_at = models.DateTimeField(auto_now_add=True)
# 使用命令行创建迁移文件
python manage.py makemigrations
# 应用迁移以同步数据库
python manage.py migrate

python
# models.py
from sqlalchemy import create_engine, Column, Integer, String, DateTime
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from sqlalchemy_utils import create_database, database_exists
Base = declarative_base()
class Article(Base):
    __tablename__ = 'articles'
    id = Column(Integer, primary_key=True)
    title = Column(String(200))
    content = Column(String)
    created_at = Column(DateTime)
# 创建数据库引擎
engine = create_engine('sqlite:///example.db')
# 创建表
Base.metadata.create_all(engine)
# 创建会话
Session = sessionmaker(bind=engine)
session = Session()

python
# models.py
from pony.orm import Database, Required, db_session, commit
from pony.orm.migrate import migrate
db = Database()
class Article(db.Entity):
    title = Required(str, max_len=200)
    content = Required(str)
    created_at = Required(str)
# 进行数据库迁移
migrate()
# 示例数据插入
with db_session:
    Article(title="Sample Article", content="This is a sample article.", created_at="2023-11-20")
    commit()