[day10] Flask Python API Service

安装Flask跟套件

pip install flask
pip install flask-restful

设定测试API

虽然使用sqlite时应该不会有连线问题，不过在这边还是简单写一个测试执行SQL的Route，如果执行成功显示Database ONLINE

将服务器挂载在http的port 8080上，在/dbstatus以GET方式接收请求

# Server.py
import util.dbcc as dbcc

app = flask.Flask(__name__)
api = Api(app)

@app.route("/dbstatus", methods=['GET'])
def HelloWorld():
    if(dbcc.quy_dbonline(conn)):
        return "Database ONLINE"
    else:
        return "Database OFFLINE"

if __name__ == '__main__':
    env = ConfigParser()
    env.read('env.ini')
    try:
        conn = db.connect(env['SQL']['sqlite_URL'], check_same_thread=False)
        print(f"load database from {env['SQL']['sqlite_URL']} successfully")
        app.run(port = 8080, debug=True)
    except Exception as err:
        print(err)

後续将以Server.py作为整个专案的中控主程序，对接API