def post(self, *args, **kwargs):
name = self.get_argument('name')
pwd = self.get_argument('password')
new_user = User(name=name,password=pwd)
session.add(new_user)
session.commit()
self.write('新增用户成功~')
def add(atkId, atkTime, sensorMac, atkType, srcIp, srcPort, srcLng, srcLat,
dstIp, dstPort, dstLng, dstLat, cmProtocal, trails, refer, infos):
curAtkinfo = Atkinfo(atkId, atkTime, sensorMac, atkType, srcIp,
srcPort, srcLng, srcLat, dstIp, dstPort, dstLng,
dstLat, cmProtocal, trails, refer, infos)
session.add(curAtkinfo)
session.commit()
def add2(inData):
ret=Sensor.check2(inData)
if(ret!=1):
return ret
curSensor=Sensor(inData['name'], inData['number'], inData['ip'], inData['mac'], inData['stationId'], datetime.now())
session.add(curSensor)
session.commit()
return ret
def add(userId, sensorId):
ret=1
ret=Auth.check(userId, sensorId)
if(ret!=1):
return ret
curAuth=Auth(userId, sensorId, datetime.now())
session.add(curAuth)
session.commit()
return ret
def add(userId, sensorId):
ret = 1
ret = Auth.check(userId, sensorId)
if (ret != 1):
return ret
curAuth = Auth(userId, sensorId, datetime.now())
session.add(curAuth)
session.commit()
return ret
def add_user_one(data):
model_obj = User(**data)
try:
session.add(model_obj)
session.commit()
return inspect(model_obj).identity[0]
except Exception as e:
session.rollback()
raise e
def add2(inData):
ret = Sensor.check2(inData)
if (ret != 1):
return ret
curSensor = Sensor(inData['name'], inData['number'], inData['ip'],
inData['mac'], inData['stationId'], datetime.now())
session.add(curSensor)
session.commit()
return ret
def add_user():
person = User(name='cherish002', password='******')
session.add(person) #增加单个
# session.add_all(
# [
# User(name='memeda',password='******'),
# User(name='lalala',password='******'),
# User(name='hahaha',password='******'),
# ]
# ) #增加多个
session.commit() #提交
print(person, '增加成功~')
def add_user():
person = User(username='******', password='******')
# 往表中插入一条数据
session.add(person)
# 往表中插入多条数据
# session.add_all(
# [
# User(username='******', password='******'),
# User(username='******', password='******'),
# User(username='******', password='******'),
# ]
# )
#
session.commit()
def read_hardware_info(csv_name):
import codecs
info_csv = codecs.open(csv_name, 'r', 'gbk')
start = info_csv.readlines()
data = start[2:-1] # filte export_time, column name
for each in data:
start = each.split(',')
new_hardware = Hardware(start[0], start[1], start[2], start[3],
start[4], start[5], start[6], start[7],
start[8], start[9], start[10], start[11],
start[12], start[13], start[17])
session.add(new_hardware)
session.commit()
'''
def add(name, number, ip, mac, ftime, ltime, authority, sensorMac):
'''
1: success
2: username repeat
'''
ret = 1
ret = Eqp.check(name, number, ip, mac)
if (ret != 1):
return ret
curEqp = Eqp(name, number, ip, mac, ftime, ltime, authority, sensorMac)
session.add(curEqp)
session.commit()
return ret
def add(name, number, ip, mac, stationId):
'''
1: success
2: username repeat
'''
ret = 1
ret = Sensor.check(name, number, ip, mac, stationId)
if (ret != 1):
return ret
curSensor = Sensor(name, number, ip, mac, stationId, datetime.now())
session.add(curSensor)
session.commit()
return ret
def add(username, passwd, level):
'''
1: success
2: out:two passwd are not same
3: username repeat
'''
ret = 1
tmp = User.check(username)
if (tmp == 1):
curUser = User(username, passwd, level)
session.add(curUser)
session.commit()
else:
ret = tmp
return ret
def add(name, number, ip, mac, ftime, ltime, authority, sensorMac):
'''
1: success
2: username repeat
'''
ret=1
ret=Eqp.check(name, number, ip, mac)
if(ret!=1):
return ret
curEqp=Eqp(name, number, ip, mac, ftime, ltime, authority, sensorMac)
session.add(curEqp)
session.commit()
return ret
def add(username, passwd, level):
'''
1: success
2: out:two passwd are not same
3: username repeat
'''
ret=1
tmp=User.check(username)
if(tmp==1):
curUser=User(username, passwd, level)
session.add(curUser)
session.commit()
else:
ret=tmp
return ret
def add(name, number, ip, mac, stationId):
'''
1: success
2: username repeat
'''
ret=1
ret=Sensor.check(name, number, ip, mac, stationId)
if(ret!=1):
return ret
curSensor=Sensor(name,number, ip, mac, stationId, datetime.now())
session.add(curSensor)
session.commit()
return ret
def add(name, number, supervisor, phone):
'''
:param name:
:param number:
:param supervisor:
:param phont:
:return: {1:'success', 2:'name repeat', 3:'number repeat', 4:'name is empty', 5:'number is empty'}
'''
ret=1
if(name==''):
ret=4
return ret
if(number==''):
ret=5
return ret
ret=Station.check(name, number)
if(ret!=1):
return ret
curStation=Station(name, number, supervisor, phone, datetime.now())
session.add(curStation)
session.commit()
return ret
def add(name, number, supervisor, phone):
'''
:param name:
:param number:
:param supervisor:
:param phont:
:return: {1:'success', 2:'name repeat', 3:'number repeat', 4:'name is empty', 5:'number is empty'}
'''
ret = 1
if (name == ''):
ret = 4
return ret
if (number == ''):
ret = 5
return ret
ret = Station.check(name, number)
if (ret != 1):
return ret
curStation = Station(name, number, supervisor, phone, datetime.now())
session.add(curStation)
session.commit()
return ret
def insert_data(self,datas):
try:
if "product_name" in datas:
product_name = datas["product_name"]
else:
product_name = None
if "version" in datas:
version = datas["version"]
else:
version = None
if "infos" in datas:
infos = datas["infos"]
else:
infos = None
if "pro_sys" in datas:
pro_sys = datas["pro_sys"]
else:
pro_sys = None
if "channel" in datas:
channel = datas["channel"]
else:
channel = None
if "opernation" in datas:
opernation = datas["opernation"]
else:
opernation = None
dao = ProductModel(product_name=product_name,version=version,infos=infos,pro_sys=pro_sys,channel=channel,opernation=opernation)
# session.add(add_data) # 添加一条
# session.add_all(add_datas) # 添加多条
session.add(dao)
session.commit()
print('新增成功')
return True
except:
session.rollback()
print('新增失败')
def add_eqp(name,
department,
ip,
mac,
os,
computer,
authority,
sensor_id=None):
"""
if eqp exists, update last_time return -1
else, add eqp and return eqp.id
"""
if Eqp.is_eqp_exist(mac, ip): # eqp exists
e = session.query(Eqp).filter_by(mac=mac, ip=ip).first()
e.last_time = datetime.now()
session.commit()
return -1
first_time = datetime.now()
last_time = datetime.now()
new_eqp = Eqp(name, department, ip, mac, os, computer, authority,
first_time, last_time, sensor_id)
session.add(new_eqp)
session.commit()
return new_eqp.id
def add(atkId, atkTime, sensorNumber, atkType, srcIp, srcPort, srcLng, srcLat, dstIp, dstPort, dstLng, dstLat, cmProtocal, trails, refer, infos):
curAtkinfo=Atkinfo2(atkId, atkTime, sensorNumber, atkType, srcIp, srcPort, srcLng, srcLat, dstIp, dstPort, dstLng, dstLat, cmProtocal, trails, refer, infos)
session.add(curAtkinfo)
session.commit()
def add():
stu = Student(name='么么踹', age='18', sex='男', address='上海市浦东新区')
session.add(stu)
session.commit()
print('新增记录成功~')
def add_data():
person = User(username='******', password='******')
session.add(person)
session.commit()
axs[2].plot(t, odors, lw=2)
axs[2].set_ylim(ODOR_YLIM)
axs[2].set_xlabel('t (s)')
axs[2].set_ylabel('odor (a.u.)')
# plot speed and distance to wall overlaid
axs[3].plot(t, spd, c='b', lw=2)
axs[3].set_ylim(0, 0.6)
axs[3].set_xlabel('t (s)')
axs[3].set_ylabel('speed (m/s)', color='b')
[tl.set_color('b') for tl in axs[3].get_yticklabels()]
axs[3].twin.plot(t, dist, c='r', lw=2)
axs[3].twin.set_ylabel('dist from wall (m)', color='r')
[tl.set_color('r') for tl in axs[3].twin.get_yticklabels()]
plt.draw()
command = raw_input('command [s=save, n=next odor state]: ')
if command == 's':
sample_trajectory = models.SampleTrajectory(sample_group=sample_group,
experiment_id=EXPERIMENT_ID,
odor_state=odor_state,
trajectory=traj)
session.add(sample_trajectory)
session.commit()
print('Trajectory "{}" saved in sample database.'.format(traj.id))
elif command == 'n':
print('Moving on to next odor state...')
break
def add(inData):
tmpUser=User_old(inData.username, inData.passwd, inData.level)
session.add(tmpUser)
session.commit()
def add(inData):
tmpUser = User_old(inData.username, inData.passwd, inData.level)
session.add(tmpUser)
session.commit()
def add(userId, sensorId):
ret=1
curAuth=Auth_old(userId, sensorId, datetime.now())
session.add(curAuth)
session.commit()
return ret
