含有created与updated字段时数据的导入
from sqlalchemy import *from sqlalchemy.orm import *from sqlalchemy.ext.declarative import declarative_basefrom datetime import datetimeBase = declarative_base()class MyClass(Base): __tablename__ = 'sometable' id = Column(Integer, primary_key=True) created = Column(DateTime, default=datetime.now) updated = Column(DateTime, onupdate=datetime.now)
?有如上的库设计,为了在导入数据时保持原有的create与updated的值,只要在创建MyClass的实例时,提供created与updated的实际值就行。
如:
myclass1 = MyClass()
则保存到库里时,created的值是datetime.now(),而updated则为空
如:
myclass2 = MyClass(created=datetime_vaule1,updated=datetime_value2)则保存到库里时,created的值是datetime_value1,而updated的值为datetime_value2