Flask sqlite3 服务器脚本

初始化数据库信息

# coding:utf-8
import sqlite3

# 没有就建立数据库 有的话就打开
conn = sqlite3.connect('wulian.db')
cursor = conn.cursor()

cursor.execute('create table tempbiao (id varchar(20) primary key, tempvalue float(32),kaiguan int(16))')
cursor.execute('insert into tempbiao (id, tempvalue,kaiguan) values (\'1\', \'2.365\', \'0\')')

cursor.close()
conn.commit()
conn.close()

开启服务

# coding:utf-8
from flask import Flask
from gevent.pywsgi import WSGIServer
import sqlite3

app = Flask(__name__)


# 接受浮点数字 传感器访问
@app.route('/mcum/<float:revNo>')
def mcum(revNo):
    # 没有就建立数据库 有的话就打开
    conn = sqlite3.connect('wulian.db')
    cursor = conn.cursor()
    sql = "Update tempbiao Set tempvalue='{0}' Where ID='{1}'".format(revNo, '1')
    cursor.execute(sql)
    conn.commit()
    cursor.close()
    conn.close()
    return '写入的结果是 %f' % revNo

@app.route('/androidm/<int:NO>')
def androidmodifykaiguan(NO):
    # 没有就建立数据库 有的话就打开
    conn = sqlite3.connect('wulian.db')
    cursor = conn.cursor()
    sql = "Update tempbiao Set kaiguan='{0}' Where ID='{1}'".format(NO, '1')
    cursor.execute(sql)
    conn.commit()
    cursor.close()
    conn.close()
    return "OK"


# 手机查询数据库变量 返回回去
@app.route('/androidcheck')
def checkdata():
    # 没有就建立数据库 有的话就打开
    conn = sqlite3.connect('wulian.db')
    cursor = conn.cursor()
    cursor.execute('select * from tempbiao where id=?', ('1',))
    checkresult = cursor.fetchall()
    cursor.close()
    conn.close()
    checkresult=str(list(checkresult[0])[1])
    return checkresult


@app.route('/mcucheck')
def mcugetkaigaun():
    # 没有就建立数据库 有的话就打开
    conn = sqlite3.connect('wulian.db')
    cursor = conn.cursor()
    cursor.execute('select * from tempbiao where id=?', ('1',))
    checkresult = cursor.fetchall()
    print(checkresult)
    cursor.close()
    conn.close()
    checkresult=str(list(checkresult[0])[2])
    return checkresult

if __name__ == '__main__':
    # http_server = WSGIServer(('0.0.0.0', 5000), app)
    # http_server.serve_forever()
    app.run(port=5000)