# 导入Flask类
from flask import Flask
from flask import jsonify
from flask import request
from flask_cors import CORS
import pymssql


# Flask函数接收一个参数__name__，它会指向程序所在的包
app = Flask(__name__)
CORS(app, supports_credentials=True, resources=r'/*')

server = '192.168.0.123:1433'
user='sa'
password='admin123X'
database ='microseism3'

#根据月份获取数据
def get_event_location_data(month):
     
    conn = pymssql.connect(server=server, user=user, password=password, database=database,as_dict=True)
    cursor = conn.cursor()
    res =[] 
    try:
        sqlStr = 'SELECT * FROM dbo.event_location_'+ str(month)
        # 执行查询语句或其他操作
        cursor.execute(sqlStr)
    
        # 获取结果集
        result = cursor.fetchall()
    
        for row in result:
           dic={"x":row["Event_X"],"y":row["Event_Y"],"z":row["Event_Z"],"v":row["Event_Energy"]}
           res.append(dic)
        
    except Exception as e:
        print("Error occurred:", str(e))
        return []
      
    finally:
        # 关闭连接
        cursor.close()
        conn.close()
    return res   

#根据传入的月份查询数据
@app.route('/get_event_location_data', methods=['GET'])
def event_location_data():   
    month = request.args.get('month') 
    res =  get_event_location_data(month)
    return jsonify(res)


if __name__ == '__main__':
    #app.run()    # 可以指定运行的主机IP地址，端口，是否开启调试模式
    app.run(host="192.168.0.107", port=8080)