7817 - 《信息技术》（必修二）P137【课件源代码】Web服务器代码

admin

1. # coding= UTF-8
   ) b. h) ], a( U
2. import json
   
3. import sqlite3
   . r" E7 s0 @& z6 q; I
4. import datetime
   7 r* A6 c7 d! l; J1 J  n- d
5. from flask import Flask,render_template, request
   " c2 F  q2 B5 V3 e9 S
6. DATABASE = 'data/data.db'
   
7. app = Flask(__name__)
   6 [* X! w: x/ R+ ]" }3 x
8. @app.route("/")
   9 _( }7 B* r6 b6 Y
9. def hello():
   
10.     db = sqlite3.connect(DATABASE)
    
11.     cur = db.cursor()
    
12.     cur.execute("SELECT * FROM sensorlog WHERE sensorid =1")
    
13.     data = cur.fetchall()
    
14.     cur.close()
    
15.     db.close()
    ) d2 X$ h; @: _3 ^
16.     temp1 = data[len(data) - 1]
    , u$ J! p. r3 g/ m& H
17.     temp=temp1[2]
    
18.     return render_template('vews.html', data=data,temp=temp)
    
19. 
    
20. #Adding data
    
21. @app.route("/input",methods=['POST','GET'])
    + g' x0 L; H  j0 I- n
22. def add_data():
    . W) X6 h9 x5 t5 W$ d9 n+ T' V9 W
23.     if request.method == 'POST':
    7 n4 }, k# @6 J% p3 \8 Z
24.         sensorid = int(request.form.get('id'))
    ' a, y$ y! ?) m
25.         sensorvalue = float(request.form.get('val'))
    % I$ q$ e6 U9 Z6 L- v, e6 Q
26.     else:
    2 ]: ]/ n/ X) P4 s) }9 h
27.         sensorid = int(request.args.get('id'))
    " S% f' Y- U1 \( \/ j( t
28.         sensorvalue = float(request.args.get('val'))
    , ?; j2 l4 f1 r! i( y$ G( y0 b
29.     nowtime = datetime.datetime.now()
    0 v+ ?2 \4 j$ p# o" V% ~& L
30.     nowtime = nowtime.strftime('%Y-%m-%d %H:%M:%S')
    
31.     db = sqlite3.connect(DATABASE)
    % x- F; O# S4 x
32.     cur = db.cursor()
    5 p7 S5 n# J1 o6 |# U# f6 s
33.     cur.execute("INSERT INTO sensorlog(sensorid,sensorvalue,updatetime) VALUES(%d,%f,'%s')" %(sensorid,sensorvalue,nowtime))
    % N4 |1 s- E+ P7 h; G+ k. Z
34.     db.commit()
    
35.     cur.execute("SELECT * FROM sensorlist where sensorid = %d"% sensorid)
    3 y6 m& I  H* C* G0 h4 A
36.     rv = cur.fetchall()
    0 o' b9 @, J& C  D; Q) @3 l- ~( k
37.     cur.close()
    
38.     db.close()
    
39.     maxrv = rv[0][2]
    8 N8 N& L/ p& d# k
40.     minrv = rv[0][3]
    6 P: x* t+ D! d2 X1 A
41.     if sensorvalue > maxrv or sensorvalue < minrv:
    
42.         return '0'
    7 z6 W( {3 V9 B+ X) s
43.     else:
    
44.         return '1'
    / X3 ^3 k$ q3 D. ~: f, ?5 Z4 _
45. 
    
46. if __name__ == "__main__":
    
47.     app.run(host="0.0.0.0", port=8080,debug=True,threaded=True)
    1 d% a# n- @* w# t5 p

复制代码