SQLAlchemy学习-7.Column 设置日期时间类型

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import create_engine, Column, Integer, String, DateTime, Date
from datetime import datetime

Base = declarative_base()

class User(Base):
    """银行卡基本信息"""
    __tablename__ = 'user'  # 数据库表名

    id = Column(Integer, primary_key=True, autoincrement=True)
    name = Column(String(10), nullable=False)
    birth = Column(Date)  # 生日
    create_time = Column(DateTime, default=datetime.now)
    update_time = Column(DateTime, onupdate=datetime.now, default=datetime.now)

    def __repr__(self):
        return f"<User(id={self.id}, name={self.name}, birth={self.birth}, ...)>"

if __name__ == '__main__':
    DB_URI = 'mysql+pymysql://root:123456@localhost:3306/web'
    engine = create_engine(DB_URI)
    # Base.metadata.drop_all(engine)  # 清空了重新创建
    Base.metadata.create_all(engine)  # 将模型映射到数据库中

from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine
from xuexi.a7 import User

engine = create_engine('mysql+pymysql://root:123456@localhost:3306/web')
# 把当前的引擎绑定给这个会话
Session = sessionmaker(bind=engine)
# 实例化
session = Session()

# 新增数据
obj = User(name='yoyo2', birth='2021-01-07')
session.add(obj)  # 添加到session
session.commit()  # 提交到数据库

session.query(User).filter(User.name == 'yoyo2').update({'birth': '2021-01-08'})
session.commit()