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

admin

1. # coding= UTF-8
   
2. import json
   + _( D  B3 F+ {6 E! ^4 p- F
3. import sqlite3
   
4. import datetime
   7 s* {: ?8 C( j7 q
5. from flask import Flask,render_template, request
   
6. DATABASE = 'data/data.db'
   
7. app = Flask(__name__)
   
8. @app.route("/")
   . ~3 O& j+ s4 \; ?- Z7 u5 c
9. def hello():
   4 ?' W% C: @; ?& S. `5 p, C
10.     db = sqlite3.connect(DATABASE)
    5 H3 U3 t9 w+ G& z
11.     cur = db.cursor()
    
12.     cur.execute("SELECT * FROM sensorlog WHERE sensorid =1")
    ; L2 }1 m  a- a
13.     data = cur.fetchall()
    ) `% n7 _4 i: P/ W3 T
14.     cur.close()
    
15.     db.close()
    , Y( [' ~% \$ r# V
16.     temp1 = data[len(data) - 1]
    + V1 ^( u. y  d) r: T' _
17.     temp=temp1[2]
    ( v7 L9 S  z- O8 L% `- c
18.     return render_template('vews.html', data=data,temp=temp)
    4 D( |/ z2 Y4 r' g% o9 m* V
19. 
    ) ]% ], }6 K# |' A/ ~# L
20. #Adding data
    0 W9 \# C7 o- d1 L: w/ g; C2 w9 [
21. @app.route("/input",methods=['POST','GET'])
    
22. def add_data():
    , |0 Y0 W* _0 K& k- q/ u
23.     if request.method == 'POST':
    
24.         sensorid = int(request.form.get('id'))
    
25.         sensorvalue = float(request.form.get('val'))
    3 y& p( _/ ~' F( C2 G2 r1 ]9 R7 h
26.     else:
    
27.         sensorid = int(request.args.get('id'))
    
28.         sensorvalue = float(request.args.get('val'))
    - `# X! L! d& f% Y
29.     nowtime = datetime.datetime.now()
    
30.     nowtime = nowtime.strftime('%Y-%m-%d %H:%M:%S')
    
31.     db = sqlite3.connect(DATABASE)
    
32.     cur = db.cursor()
    
33.     cur.execute("INSERT INTO sensorlog(sensorid,sensorvalue,updatetime) VALUES(%d,%f,'%s')" %(sensorid,sensorvalue,nowtime))
    
34.     db.commit()
    : o, P8 k% N" S3 B, ^9 n3 v1 q
35.     cur.execute("SELECT * FROM sensorlist where sensorid = %d"% sensorid)
    
36.     rv = cur.fetchall()
    
37.     cur.close()
    
38.     db.close()
    
39.     maxrv = rv[0][2]
    * J4 Z6 l/ {  J8 L0 Q$ y
40.     minrv = rv[0][3]
    ' }7 `8 ~& |$ E- B" Y
41.     if sensorvalue > maxrv or sensorvalue < minrv:
    
42.         return '0'
    & G2 U8 b& e2 w1 p. B
43.     else:
    6 l: Y  M3 X; n3 v" i$ u$ }  C6 b
44.         return '1'
    
45. 
    3 J$ I0 Z$ H, b* _+ w# r
46. if __name__ == "__main__":
    3 F9 f: d; M8 t6 A( E5 X* r
47.     app.run(host="0.0.0.0", port=8080,debug=True,threaded=True)
    - a) L) e% S0 x- ]1 Q0 ]

复制代码