数据库每张表有相同的字段处理
1:sqlalcchemy
from sqlalchemy import (DateTime, Column)
from sqlalchemy.ext.declarative import declarative_base
class Base(object):
ctime = Column(
DateTime,
default=datetime.datetime.now,
nullable=False
)
utime = Column(
DateTime,
default=datetime.datetime.now,
onupdate=datetime.datetime.now,
nullable=False
)
DeclarativeBase = declarative_base(cls=Base)
class Model1(DeclarativeBase):
__tablename__ = 'model1'
2:flask_sqlalchemy
#flask框架中使用
from flask_sqlalchemy import Model,SQLAlchemy
import datetime
from sqlalchemy import Column,DateTime
class BaseModel(Model):
ctime = Column(
DateTime,
default=datetime.datetime.now,
nullable=False
)
utime = Column(
DateTime,
default=datetime.datetime.now,
onupdate=datetime.datetime.now,
nullable=False
)
db = SQLAlchemy(model_class=BaseModel)