device_mul.py 922 B

12345678910111213141516171819202122
  1. #!/usr/bin/env python
  2. # -*- coding: utf-8 -*-
  3. """
  4. demeter database
  5. name:device_mul.py
  6. author:rabin
  7. """
  8. from __load__ import *
  9. class Device_mul(Model):
  10. __table__ = 'device_mul'
  11. __comment__ = '设备批量控制'
  12. id = Fields(type='uuid', primaryKey=True, comment='分组ID', uuid='farm_id')
  13. farm_id = Fields(type='int', default='setting.farm', comment='园区ID', match='not')
  14. name = Fields(type='varchar(50)', comment='分组名')
  15. devices = Fields(type='text', comment='设备id,逗号隔开')
  16. oper = Fields(type='varchar(500)', comment='操作状态')
  17. value = Fields(type='varchar(10)', comment='开关状态')
  18. old = Fields(type='varchar(10)', comment='上次开关状态')
  19. device_type = Fields(type='int', comment='设备类型,1为开关2为卷帘')
  20. state = Fields(type='boolean', default='True', comment='数据存在状态')
  21. cdate = Fields(type='int', default='time', comment='创建时间')