1 数据模型编写
class TerminalObserveModel(db.Model):
__tablename__ = "ods_terminal_observe_data"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
getDatatime = db.Column(db.String(200))
addr = db.Column(db.String(200))
loadLen = db.Column(db.String(200))
BCCCheck = db.Column(db.String(200))
version = db.Column(db.String(200))
deviceID = db.Column(db.String(200))
deviceType = db.Column(db.String(200))
messageID = db.Column(db.String(200))
systemTime = db.Column(db.String(200))
CHID = db.Column(db.Text)
CHState = db.Column(db.Text)
CHPower = db.Column(db.Text)
CHTime = db.Column(db.Text)
CHTimeModify = db.Column(db.Text)
CHWaveModify = db.Column(db.Text)
CHWaveCycle = db.Column(db.Text)
CHlon = db.Column(db.Text)
CHlat = db.Column(db.Text)
CHalt = db.Co