class dy_value_change(Base):
__tablename__ = 'dy_value_change'
src_time = Column(Integer)
src_value = Column(String(128))
dst_value = Column(String(128))
param = Column(Text)
key_name = Column(String(64))
device_id = Column(String(64))
class dy_addr(Base):
__tablename__ = 'dy_addr'
addrCode = Column(String(128))
parentId = Column(Integer, default=-1)
addr = Column(String(128))
def __init__(self, addrCode, parentId, addr, **kwargs):
Base.__init__(self,
addrCode=addrCode,
parentId=parentId,
addr=addr,
**kwargs)
class TbWxUser(Base):
__tablename__ = 'wx_user'
userid = Column(String(128), unique=True)
password = Column(String(128), default="")
openId = Column(String(128), default="")
name = Column(String(128), default="")
mobile = Column(String(128), default="")
address = Column(String(128), default="")
service = Column(String(128), default="")
email = Column(String(128), default="")
switch = Column(Integer, default=0)
class dy_device(Base):
__tablename__ = 'dy_device'
nb_id = Column(String(128), default='')
device_id = Column(String(128), unique=True)
name = Column(String(128), default="")
type = Column(Integer, default=20)
addr = Column(String(128), default='')
dc_type = Column(String(32), default='')
stand_i = Column(Float(10, 2), default=0)
stand_bc = Column(Float(10, 2), default=0)
number = Column(String(128), default='')
station_code = Column(String(128), default='')
addr_number = Column(String(128), default='')
line_length = Column(Float(10, 2), default=0)
jb = Column(TEXT)
env = Column(Text)
class dy_record(Base):
__tablename__ = 'dy_record'
bsid = Column(String(128), default="")
deviceid = Column(String(128), default="")
dc_type = Column(String(128), default="")
line_length = Column(String(128), default="")
pictures = Column(Text, default="[]")
stand_i = Column(Float(10, 2), default=0)
stand_bc = Column(Float(10, 2), default=0)
station_id = Column(String(128), default="")
userid = Column(String(128), default="")
class dy_station(Base):
__tablename__ = 'dy_station'
station_id = Column(String(128), default='')
station_name = Column(String(128), default='')
station_addr = Column(String(128), default='')
station_code = Column(String(128), default='')
class dy_log(Base):
__tablename__ = 'dy_log'
__table_args__ = (Index('time', 'user_id', 't', unique=True), )
user_id = Column(String(64))
i = Column(TEXT)
o = Column(TEXT)
class dy_msg(Base):
__tablename__ = 'dy_msg'
msg_name = Column(String(256))
msg_value = Column(Text)
msg_type = Column(Integer)
class dy_err(Base):
__tablename__ = 'dy_err'
user_id = Column(String(64))
info = Column(Text)
data = Column(Text)
err_type = Column(String(64))