def put(self):
args = alarm_put_parser.parse_args()
model_id = args['id']
if model_id:
model = VarAlarmLog.query.get(model_id)
if not model:
return err_not_found()
if args['alarm_id']:
model.alarm_id = args['alarm_id']
if args['status']:
model.status = args['status']
if args['time']:
model.time = args['time']
db.session.add(model)
db.session.commit()
return rp_modify()
else:
model = VarAlarmLog(
alarm_id=args['alarm_id'],
status=args['status'],
time=args['time'],
)
db.session.add(model)
db.session.commit()
return rp_create()
def put(self, model_id=None):
args = alarm_info_put_parser.parse_args()
if not model_id:
model_id = args['id']
if model_id:
model = VarAlarmInfo.query.get(model_id)
if not model:
return err_not_found()
if args['variable_id']:
model.variable_id = args['variable_id']
if args['alarm_type']:
model.alarm_type = args['alarm_type']
if args['note']:
model.note = args['note']
db.session.add(model)
db.session.commit()
return rp_modify()
else:
model = VarAlarmInfo(variable_id=args['variable_id'],
alarm_type=args['alarm_type'],
note=args['note'])
db.session.add(model)
db.session.commit()
return rp_create()
def delete(self, model_id=None):
models = self.search(model_id)
count = len(models)
if not models:
return err_not_found()
if self.args['variable_id']:
for m in models:
delete_models = YjVariableInfo.query.filter(
YjVariableInfo.id.in_(self.args['variable_id']))
for var in delete_models:
try:
m.vars.remove(var)
except ValueError:
return err_not_contain()
db.session.commit()
return rp_delete_ration()
else:
for m in models:
db.session.delete(m)
db.session.commit()
return rp_delete(count)
def delete(self, model_id=None):
models = self.search(model_id)
count = len(models)
if not models:
return err_not_found()
if self.args['role']:
for m in models:
delete_models = Role.query.filter(
Role.name.in_(self.args['role']))
for role in delete_models:
try:
m.roles.remove(role)
except ValueError:
return err_not_contain()
db.session.commit()
return rp_delete_ration()
else:
for m in models:
db.session.delete(m)
db.session.commit()
return rp_delete(count)
def put(self):
if self.model_id:
model = Parameter.query.get(self.model_id)
if not model:
return err_not_found()
if self.param_name:
model.param_name = self.param_name
if self.variable_id:
model.variable_id = self.variable_id
if self.unit:
model.unit = self.unit
db.session.add(model)
db.session.commit()
return rp_modify()
else:
model = Parameter(variable_id=self.variable_id,
param_name=self.param_name,
unit=self.unit)
db.session.add(model)
db.session.commit()
return rp_create()
def put(self):
args = value_put_parser.parse_args()
value_id = args['id']
if value_id:
value = Value.query.get(value_id)
if not value:
return err_not_found()
if args['variable_id']:
value.variable_id = args['variable_id']
if args['value']:
value.value = args['value']
if args['time']:
value.time = args['time']
db.session.add(value)
db.session.commit()
return rp_modify()
else:
value = Value(variable_id=args['variable_id'],
value=args['value'],
time=args['time'])
db.session.add(value)
db.session.commit()
return rp_create()
def information(self, group):
if not group:
return err_not_found()
info = []
for g in group:
data = dict()
data['id'] = g.id
data['group_name'] = g.group_name
data['plc_id'] = g.plc_id
data['upload_cycle'] = g.upload_cycle
data['note'] = g.note
data['ten_id'] = g.ten_id
data['item_id'] = g.item_id
data['upload'] = g.upload
plc = g.yjplcinfo
if plc:
data['plc_name'] = plc.plc_name
else:
data['plc_name'] = None
info.append(data)
response = jsonify({'ok': 1, "data": info})
response.status_code = 200
return response
def put(self, model_id=None):
args = user_parser.parse_args()
if not model_id:
model_id = args['id']
if model_id:
model = User.query.get(model_id)
if not model:
return err_not_found()
if args['username']:
model.username = args['username']
if args['email']:
model.email = args['email']
if args['role']:
role_models = Role.query.filter(Role.name.in_(
args['role'])).all()
model.roles += role_models
db.session.add(model)
db.session.commit()
return rp_modify()
def information(self, models):
if not models:
return err_not_found()
info = []
for m in models:
data = dict()
data['id'] = m.id
data['name'] = m.name
variable_list = [
dict(var_id=v.id, var_name=v.variable_name) for v in m.vars
]
# value_list = []
#
# for var in m.vars:
# if self.args['min_time'] and self.args['max_time']:
# values = Value.query.filter_by(variable_id=var.id).filter(Value.time > self.args['min_time']).filter(Value.time < self.args['max_time']).all()
# value_list += values
# else:
# value = Value.query.filter_by(variable_id=var.id).order_by(Value.time.desc()).all()
# value_list += (value)
#
# value_info = [
# dict(
# id=value.id,
# value=value.value,
# time=value.time,
# variable_id=value.variable_id
# )
# for value in value_list
# ]
# data['value'] = value_info
data['variable'] = variable_list
info.append(data)
# info = [
# dict(id=m.id,
# name=m.name,
# variable=[
# dict(
# id=v.id,
# value=v.values,
# time=v.time,
# variable_id=v.variable_id
# )
# for v in m.vars
# ]
# )
# for m in models
# ]
response = jsonify({"ok": 1, "data": info})
return response
def put(self):
args = station_put_parser.parse_args()
station_id = args['id']
if station_id:
station = YjStationInfo.query.get(station_id)
if not station:
return err_not_found()
if args['station_name']:
station.station_name = args['station_name']
if args['mac']:
station.mac = args['mac']
if args['ip']:
station.ip = args['ip']
if args['note']:
station.note = args['note']
if args['id_num']:
station.id_num = args['id_num']
if args['plc_count']:
station.plc_count = args['plc_count']
if args['ten_id']:
station.ten_id = args['ten_id']
if args['item_id']:
station.item_id = args['item_id']
if args['modification']:
station.modification = args['modification']
db.session.add(station)
db.session.commit()
return rp_modify()
else:
station = YjStationInfo(station_name=args['station_name'],
mac=args['mac'],
ip=args['ip'],
note=args['note'],
id_num=args['id_num'],
plc_count=args['plc_count'],
ten_id=args['ten_id'],
item_id=args['item_id'],
modification=args['modification'])
db.session.add(station)
db.session.commit()
return rp_create()
def delete(self):
models = self.search()
count = len(models)
if not models:
return err_not_found()
for m in models:
db.session.delete(m)
db.session.commit()
return rp_delete(count)
def put(self):
args = group_put_parser.parse_args()
group_id = args['id']
if group_id:
group = YjGroupInfo.query.get(group_id)
if not group:
return err_not_found()
if args['group_name']:
group.group_name = args['group_name']
if args['plc_id']:
group.plc_id = args['plc_id']
if args['note']:
group.note = args['note']
if args['upload_cycle']:
group.upload_cycle = args['upload_cycle']
if args['ten_id']:
group.ten_id = args['ten_id']
if args['item_id']:
group.item_id = args['item_id']
if args['upload']:
group.item_id = args['upload']
db.session.add(group)
db.session.commit()
return rp_modify()
else:
group = YjGroupInfo(group_name=args['group_name'],
plc_id=args['plc_id'],
note=args['note'],
upload_cycle=args['upload_cycle'],
ten_id=args['ten_id'],
item_id=args['item_id'],
upload=args['upload'])
db.session.add(group)
db.session.commit()
return rp_create()
def information(self, models):
if not models:
return err_not_found()
info = [
dict(id=m.id,
station_id=m.station_id,
level=m.level,
note=m.note,
time=m.time) for m in models
]
response = jsonify({"ok": 1, "data": info})
return response
def information(self, models):
if not models:
return err_not_found()
info = [
dict(username=m.username,
email=m.email,
login_count=m.login_count,
last_login_ip=m.last_login_ip,
last_login_time=m.last_login_time,
role=[role.name for role in m.roles]) for m in models
]
response = jsonify({"ok": 1, "data": info})
return response
def information(self, models):
if not models:
return err_not_found()
info = [
dict(
id=m.id,
plc_id=m.yjvariableinfo.yjgroupinfo.plc_id
if m.yjvariableinfo and m.yjvariableinfo.yjgroupinfo else None,
variable_id=m.variable_id,
variable_name=m.yjvariableinfo.variable_name
if m.yjvariableinfo else None,
alarm_type=m.alarm_type,
note=m.note,
) for m in models
]
response = jsonify({"ok": 1, "data": info})
return response
def put(self):
if self.model_id:
model = InterfaceLog.query.get(self.model_id)
if not model:
return err_not_found()
if self.username:
model.username = self.username
if self.host_url:
model.host_url = self.host_url
if self.method:
model.method = self.method
db.session.add(model)
db.session.commit()
return rp_modify()
def information(self, models):
if not models:
return err_not_found()
info = list()
for m in models:
data = dict()
data['id'] = m.id
data['alarm_id'] = m.alarm_id
data['time'] = m.time
data['status'] = m.status
alarm_info = m.var_alarm_info
data['note'] = m.var_alarm_info.note if alarm_info else None
data[
'alarm_type'] = m.var_alarm_info.alarm_type if alarm_info else None
data[
'variable_id'] = m.var_alarm_info.variable_id if alarm_info else None
var = m.var_alarm_info.yjvariableinfo if alarm_info else None
data[
'variable_name'] = m.var_alarm_info.yjvariableinfo.variable_name if var else None
group = m.var_alarm_info.yjvariableinfo.yjgroupinfo if var else None
data['plc_id'] = group.plc_id if group else None
plc = m.var_alarm_info.yjvariableinfo.yjgroupinfo.yjplcinfo if group else None
data['plc_name'] = plc.plc_name if plc else None
data['station_id'] = plc.station_id if plc else None
station = plc.yjstationinfo if plc else None
data['station_name'] = station.station_name if station else None
info.append(data)
response = jsonify({"ok": 1, "data": info})
return response
def put(self, model_id=None):
args = status_put_parser.parse_args()
if not model_id:
model_id = args['id']
if model_id:
model = TransferLog.query.get(model_id)
if not model:
return err_not_found()
if args['station_id']:
model.station_name = args['station_id']
if args['level']:
model.level = args['level']
if args['time']:
model.time = args['time']
if args['note']:
model.note = args['note']
db.session.add(model)
db.session.commit()
return rp_modify()
else:
model = TransferLog(
station_id=args['station_id'],
level=args['level'],
time=args['time'],
note=args['note'],
)
db.session.add(model)
db.session.commit()
return rp_create()
def put(self, model_id=None):
args = query_put_parser.parse_args()
if not model_id:
model_id = args['id']
if model_id:
model = QueryGroup.query.get(model_id)
if not model:
return err_not_found()
if args['name']:
model.name = args['name']
if args['variable_id']:
var_models = YjVariableInfo.query.filter(
YjVariableInfo.id.in_(args['variable_id'])).all()
model.vars += var_models
db.session.add(model)
db.session.commit()
return rp_modify()
else:
if args['variable_id']:
var_models = YjVariableInfo.query.filter(
YjVariableInfo.id.in_(args['variable_id'])).all()
else:
var_models = []
model = QueryGroup(name=args['name'], vars=var_models)
db.session.add(model)
db.session.commit()
return rp_create()
def information(self, models):
if not models:
return err_not_found()
info = []
for m in models:
station = m.yjstationinfo
data = dict()
data['id'] = m.id
data['plc_name'] = m.plc_name
data['station_id'] = m.station_id
data['note'] = m.note
data['ip'] = m.ip
data['mpi'] = m.mpi
data['type'] = m.type
data['plc_type'] = m.plc_type
data['ten_id'] = m.ten_id
data['item_id'] = m.item_id
data['rack'] = m.rack
data['slot'] = m.slot
data['tcp_port'] = m.tcp_port
if station:
data['station_id_num'] = station.id_num
data['station_name'] = station.station_name
else:
data['station_id_num'] = None
data['station_name'] = None
info.append(data)
response = jsonify({'ok': 1, "data": info})
response.status_code = 200
return response
def information(self, models):
if not models:
return err_not_found()
info = []
for m in models:
data = dict()
data['id'] = m.id
data['station_name'] = m.station_name
data['mac'] = m.mac
data['ip'] = m.ip
data['note'] = m.note
data['id_num'] = m.id_num
data['plc_count'] = m.plc_count
data['ten_id'] = m.ten_id
data['item_id'] = m.item_id
data['modification'] = m.modification
info.append(data)
response = jsonify({'ok': 1, "data": info})
response.status_code = 200
return response
def put(self):
args = plc_put_parser.parse_args()
plc_id = args['id']
if plc_id:
plc = YjPLCInfo.query.get(plc_id)
self.query = [].append(plc)
print self.query
if not plc:
return err_not_found()
if args['plc_name']:
plc.plc_name = args['plc_name']
if args['station_id']:
plc.station_id = args['station_id']
if args['note']:
plc.note = args['note']
if args['ip']:
plc.ip = args['ip']
if args['mpi']:
plc.mpi = args['mpi']
if args['type']:
plc.type = args['type']
if args['plc_type']:
plc.plc_type = args['plc_type']
if args['ten_id']:
plc.ten_id = args['ten_id']
if args['item_id']:
plc.item_id = args['item_id']
if args['rack']:
plc.rack = args['rack']
if args['slot']:
plc.slot = args['slot']
if args['tcp_port']:
plc.tcp_port = args['tcp_port']
db.session.add(plc)
db.session.commit()
return rp_modify()
else:
self.query = []
plc = YjPLCInfo(plc_name=args['plc_name'],
station_id=args['station_id'],
note=args['note'],
ip=args['ip'],
mpi=args['mpi'],
type=args['type'],
plc_type=args['plc_type'],
ten_id=args['ten_id'],
item_id=args['item_id'],
rack=args['rack'],
slot=args['slot'],
tcp_port=args['tcp_port'])
db.session.add(plc)
db.session.commit()
self.new_id = plc.id
return rp_create()
def information(self, value):
if not value:
return err_not_found()
# info = [
# dict(
# id=v.id,
# variable_id=v.variable_id,
# value=v.value,
# time=v.time,
# variable_name=v.yjvariableinfo.variable_name
# if v.yjvariableinfo else None,
# plc_id=v.yjvariableinfo.yjgroupinfo.yjplcinfo.id
# if (v.yjvariableinfo and v.yjvariableinfo.yjgroupinfo and v.yjvariableinfo.yjgroupinfo.yjplcinfo)
# else None,
# plc_name=v.yjvariableinfo.yjplcinfo.plc_name
# if (v.yjvariableinfo and v.yjvariableinfo.yjgroupinfo and v.yjvariableinfo.yjgroupinfo.yjplcinfo)
# else None,
# group_id=v.yjvariableinfo.yjgroupinfo.id
# if v.yjvariableinfo and v.yjvariableinfo.yjgroupinfo else None,
# group_name=v.yjvariableinfo.yjgroupinfo.group_name
# if v.yjvariableinfo and v.yjvariableinfo.yjgroupinfo else None
# )
# for v in value
# ]
info = []
for v in value:
data = dict()
data['id'] = v.id
data['variable_id'] = v.variable_id
data['value'] = v.value
data['time'] = v.time
variable = v.yjvariableinfo
if variable:
data['variable_name'] = variable.variable_name
group = variable.yjgroupinfo
else:
data['variable_name'] = None
group = None
if group:
data['group_id'] = group.id
data['group_name'] = group.group_name
data['plc_id'] = group.plc_id
plc = group.yjplcinfo
else:
data['group_id'] = None
data['group_name'] = None
data['plc_id'] = None
plc = None
if plc:
data['plc_name'] = plc.plc_name
else:
data['plc_name'] = None
info.append(data)
response = jsonify({"ok": 1, "data": info})
return response
def put(self, variable_id=None):
args = variable_put_parser.parse_args()
if not variable_id:
variable_id = args['id']
if variable_id:
variable = YjVariableInfo.query.get(variable_id)
if not variable:
return err_not_found()
if args['variable_name'] is not None:
variable.variable_name = args['variable_name']
if args['group_id'] is not None:
variable.group_id = args['group_id']
if args['db_num'] is not None:
variable.db_num = args['db_num']
if args['address'] is not None:
variable.address = args['address']
if args['data_type'] is not None:
variable.data_type = args['data_type']
if args['rw_type'] is not None:
variable.rw_type = args['rw_type']
if args['upload'] is not None:
variable.upload = args['upload']
if args['acquisition_cycle'] is not None:
variable.acquisition_cycle = args['acquisition_cycle']
if args['server_record_cycle'] is not None:
variable.server_record_cycle = args['server_record_cycle']
if args['note'] is not None:
variable.note = args['note']
if args['ten_id'] is not None:
variable.ten_id = args['ten_id']
if args['item_id'] is not None:
variable.item_id = args['item_id']
if args['write_value'] is not None:
variable.write_value = args['write_value']
if args['area'] is not None:
variable.area = args['area']
db.session.add(variable)
db.session.commit()
return rp_modify()
else:
variable = YjVariableInfo(
variable_name=args['variable_name'],
group_id=args['group_id'],
db_num=args['db_num'],
address=args['address'],
area=args['area'],
data_type=args['data_type'],
rw_type=args['rw_type'],
upload=args['upload'],
acquisition_cycle=args['acquisition_cycle'],
server_record_cycle=args['server_record_cycle'],
note=args['note'],
ten_id=args['ten_id'],
item_id=args['item_id'],
write_value=args['write_value'])
db.session.add(variable)
db.session.commit()
return rp_create()
def information(self, models):
if not models:
return err_not_found()
# time1 = time.time()
# info = [
# dict(
# id=m.id,
# variable_name=m.variable_name,
# group_id=m.group_id,
# db_num=m.db_num,
# address=m.address,
# area=m.area,
# write_value=m.write_value,
# data_type=m.data_type,
# rw_type=m.rw_type,
# upload=m.upload,
# acquisition_cycle=m.acquisition_cycle,
# server_record_cycle=m.server_record_cycle,
# note=m.note,
# ten_id=m.ten_id,
# item_id=m.item_id,
# group_name=m.yjgroupinfo.group_name if m.yjgroupinfo else None,
# plc_id=m.yjgroupinfo.yjplcinfo.id if m.yjgroupinfo and m.yjgroupinfo.yjplcinfo else None,
# plc_name=m.yjgroupinfo.yjplcinfo.plc_name if m.yjgroupinfo and m.yjgroupinfo.yjplcinfo else None,
# )
# for m in models
# ]
# time2 = time.time()
# print(time2 - time1)
time1 = time.time()
info = []
for m in models:
data = dict()
data['id'] = m.id
data['variable_name'] = m.variable_name
data['group_id'] = m.group_id
data['db_num'] = m.db_num
data['address'] = m.address
data['data_type'] = m.data_type
data['rw_type'] = m.rw_type
data['upload'] = m.upload
data['acquisition_cycle'] = m.acquisition_cycle
data['server_record_cycle'] = m.server_record_cycle
data['note'] = m.note
data['ten_id'] = m.ten_id
data['item_id'] = m.item_id
data['write_value'] = m.write_value
group = m.yjgroupinfo
if group:
data['group_name'] = group.group_name
data['plc_id'] = group.plc_id
plc = group.yjplcinfo
else:
data['group_name'] = None
data['plc_id'] = None
plc = None
if plc:
data['plc_name'] = plc.plc_name
else:
data['plc_name'] = None
info.append(data)
time2 = time.time()
print(time2 - time1)
response = jsonify({'ok': 1, "data": info})
response.status_code = 200
return response
