# server
HOST = '218.95.175.50'
PORT = 5000
DEBUG = False
THREADED = False

# oracle数据库参数
#USER_ORCL = 'sde'
#PASSWORD_ORCL = 'sde'
#HOST_ORCL = '192.168.0.1'
#PORT_ORCL = "1521"
#INSTANCE_ORCL = "orcl"

USER_ORCL = 'gdanalyst'
PASSWORD_ORCL = 'gdanalyst'
HOST_ORCL = '192.168.124.19'
PORT_ORCL = "1521"
INSTANCE_ORCL = "pdborcl"

# 象限计算结果图片，存放根目录路径
PHOTO_BASE_PATH = "D:/test/"

# 数据库查询中，需要查到的基站数据表名称
STATION_TABLE = {
    "2g": "sde.HXTT_STATION_2G",
    "3g": "sde.HXTT_STATION_3G",
    "4g": "sde.HXTT_STATION_4G",
    "5g": "sde.HXTT_STATION_5G"
}
# 数据库查询中，需要查到的产能数据表名称。目前就一张表
#CAPACITY_TABLE = "HXTT_STATION_CAPACITY"
CAPACITY_TABLE = "HXTT_STATION_CAP_MONTH_TEST"
# 用户产能x轴，选取字段名称
#X_FEE = "CULIANG_FEE"
#X_NUM = "CULIANG_NUM"
X_FEE = "CLUSER_FEE_DMONTH"
X_NUM = "CLUSER_DMONTH"
# 基站效率y轴，字段名称
Y_RESOURCE = "RESOURCE_USE"

# select wm_concat(to_char(t.l_id)) from HXTT_STATION_2G t where t.resource_use>30 and t.resource_use<37 or t.resource_use>60 and t.resource_use<64
# select avg(t.resource_use),avg(h.culiang_num) from HXTT_STATION_3G t,hxtt_station_capacity h where t.l_id=h.l_id
# pip3 install numpy -i https://pypi.tuna.tsinghua.edu.cn/simple