flask_sqlalchemy和salalchemy 每张表创建包含相同的字段

数据库每张表有相同的字段处理

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)