def labView():
labs = []
labs.append(Lab('rmre', '文本去重复工具'))
labs.append(Lab('xsspayload', 'xss常用payload'))
labs.append(Lab('xsshex', 'xss编码工具'))
labs.append(Lab('base64', 'base64编解码工具'))
labs.append(Lab('ujscanner', '扫描器web UI'))
return render_template("lab.html", labs=labs)
def post(self):
name = self.request.get('name')
owner = self.request.get('owner')
collaborators = self.request.get('emails') + ',' + owner
private = self.request.get('private')
if private.lower() == 'true':
private = True
else:
private = False
lab = Lab(name = name,
owner = owner,
private = private,
collaborators = collaborators.split(","))
lab.put()
time.sleep(0.1)
self.redirect(self.uri_for('home'))
async def post(self, request):
req = request.form
try:
with db_session:
if Lab.exists(email=req.get('email')):
return self.response_status(409)
Lab(**self.not_null_data(
id=uuid4().hex,
name=req.get('name'),
email=req.get('email'),
web=req.get('web'),
phone=req.get('phone'),
department=req.get('department'),
city=req.get('city'),
address=req.get('address'),
fertilizers=[],
))
except Exception as e:
raise e
return self.response_status(201)
def load_order():
tests = ['ldl']
for t in tests:
for f in glob.glob(os.path.join(data_dir, '{}*.csv'.format(t))):
df = pd.read_csv(f)
for ix, row in df.iterrows():
order = session.query(Order).filter(
Order.order_id == row['orderid']).first()
if order:
print(order.order_id)
test = session.query(Test).filter(
Test.test_code == row['testid']).first()
orderDateTime = datetime.strptime(
'{} {}'.format(row['orderdate'], row['ordertime']),
'%m/%d/%Y %I:%M %p')
recvDateTime = orderDateTime + timedelta(
minutes=randint(10, 50))
reportDateTime = recvDateTime + timedelta(
minutes=randint(10, 50))
lab = Lab(
lab_id=row['labid'],
test_id=test.test_code,
recv_date=recvDateTime.date(),
recv_time=recvDateTime.time(),
report_date=reportDateTime.date(),
report_time=reportDateTime.time(),
results=str(row['results']),
)
if not order:
order = Order(
order_id=row['orderid'],
orderdate=parse_date(row['orderdate']),
ordertime=parse_time(row['ordertime']),
doctor=row['doctor'],
)
order.labs.append(lab)
session.add(lab)
session.add(order)
session.commit()
