def _connect(self):
if hasattr(self, 'POOL'):
return
from AliFCWeb.constant import getConfByName, FC_ENVIRON, CONF_CENTER_NAME, MY_SQL_CONF_FILE_NAME
confCenter = getConfByName(CONF_CENTER_NAME)
from AliFCWeb.fcutils import getConfigFromConfCenter
res = getConfigFromConfCenter(confCenter['url'], MY_SQL_CONF_FILE_NAME,
confCenter['pwd'])
if res.status_code != 200:
raise Exception('读取配置中心失败！')
data = json.loads(res.text)
data.update(self.conf)
import psycopg2
from psycopg2.extras import RealDictCursor
data['creator'] = psycopg2
data['cursor_factory'] = RealDictCursor
# data['host'] = data.pop('url')
data['port'] = data.get('port', 5432)
# data['user'] = data.pop('username')
# data['database'] = data.pop('dbname')
self.POOL = PooledDB(**data)
def testFC(data):
# 先获取配置中心url
centerConfig = getConfByName(CONF_CENTER_NAME)
# 获取配置
myConf = getConfigFromConfCenter(centerConfig['url'],
['mysql', 'postgresql'],
centerConfig['pwd'])
return ResponseEntity.ok(myConf.text)
def replace(self):
from AliFCWeb.constant import getConfByName, FC_ENVIRON, CONF_CENTER_NAME, MY_SQL_CONF_FILE_NAME
confCenter = getConfByName(CONF_CENTER_NAME)
from AliFCWeb.fcutils import getConfigFromConfCenter
res = getConfigFromConfCenter(confCenter['url'], MY_SQL_CONF_FILE_NAME, confCenter['pwd'] )
if res.status_code != 200:
raise Exception('读取配置中心失败！')
data = json.loads(res.text)
import pymysql
conn = pymysql.connect(data['host'], data['user'], data['password'], data['database'],
charset = data['charset'], cursorclass=pymysql.cursors.DictCursor)
return conn
def replace(self):
from AliFCWeb.fcutils import getConfigFromConfCenter
from AliFCWeb.constant import getConfByName, FC_ENVIRON, CONF_CENTER_NAME, REDIS_CONF_FILE_NAME
confCenter = getConfByName(CONF_CENTER_NAME)
res = getConfigFromConfCenter(confCenter['url'], REDIS_CONF_FILE_NAME,
confCenter['pwd'])
if res.status_code != 200:
raise Exception('读取配置中心失败！')
data = json.loads(res.text)
import redis
conn = redis.Redis(host=data['host'],
port=data['port'],
db=0,
password=data['password'])
return conn
def replace(self):
'''@param environ: 函数计算环境变量
'''
from AliFCWeb.constant import getConfByName, FC_ENVIRON, CONF_CENTER_NAME, SQL_CONF_FILE_NAME
environ = getConfByName(FC_ENVIRON)
confCenter = getConfByName(CONF_CENTER_NAME)
res = getConfigFromConfCenter(confCenter['url'], SQL_CONF_FILE_NAME,
confCenter['pwd'])
if res.status_code != 200:
raise Exception('读取配置中心失败！')
data = json.loads(res.text)
import redis
conn = redis.Redis(host=data['host'],
port=data['port'],
db=0,
password=data['password'])
return conn
def replace(self):
'''@param environ: 函数计算环境变量
'''
from AliFCWeb.constant import getConfByName, FC_ENVIRON, CONF_CENTER_NAME, SQL_CONF_FILE_NAME
environ = getConfByName(FC_ENVIRON)
confCenter = getConfByName(CONF_CENTER_NAME)
res = getConfigFromConfCenter(confCenter['url'], SQL_CONF_FILE_NAME,
confCenter['pwd'])
if res.status_code != 200:
raise Exception('读取配置中心失败！')
data = json.loads(res.text)
conn = pymysql.connect(data['url'],
data['username'],
data['password'],
data['database'],
charset=data['charset'],
cursorclass=pymysql.cursors.DictCursor)
return conn
def _connect(self):
if hasattr(self, 'POOL'):
return
from AliFCWeb.constant import getConfByName, FC_ENVIRON, CONF_CENTER_NAME, MY_SQL_CONF_FILE_NAME
confCenter = getConfByName(CONF_CENTER_NAME)
from AliFCWeb.fcutils import getConfigFromConfCenter
res = getConfigFromConfCenter(confCenter['url'], MY_SQL_CONF_FILE_NAME,
confCenter['pwd'])
if res.status_code != 200:
raise Exception('读取配置中心失败！')
data = json.loads(res.text)
data.update(self.conf)
import pymysql
data['creator'] = pymysql
data['cursorclass'] = pymysql.cursors.DictCursor
data['port'] = data.get('port', 3306)
self.POOL = PooledDB(**data)