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)