def post(self, config_name):
params = request.get_json(cache=False,silent=True)
key = []
value = []
try:
for item in params:
# print(item)
key.append(item)
value.append(params[item])
sql = "INSERT INTO " + config_name + "(`" + "`,`".join(key) + "`) VALUES(" + ",".join(['%s' for i in key]) + ")"
res = self.mysqlutil.insert(sql, value)
return utility.json_return(200, data = res)
except Exception as e:
return utility.json_return(400, message = str(e))
def post(self, source_config, target_config):
params = request.get_json(cache=False, silent=True)
key = []
value = []
# try:
conditions = []
for item in params:
print(item)
if item == 'conditions':
for condition in params[item]:
conditions.append(condition)
continue
key.append(item)
value.append(params[item])
if len(conditions) > 0:
sql = "SELECT * FROM " + source_config + " WHERE " + ','.join(
[str(a) + " = " + str(b) for a, b in zip(conditions, list(params['conditions'].values()))])
else:
sql = "SELECT * FROM " + source_config
res = self.mysqlutil.fetchall(sql)
data = json.dumps([dict(r) for r in res], default=datetime_handler)
key.append('json')
value.append(data)
sql = "INSERT INTO " + target_config + "(" + ",".join(key) + ") VALUES(" + ",".join(['%s' for i in key]) + ")"
res = self.mysqlutil.insert(sql, value)
return utility.json_return(200, data = res)
def delete(self, config_name):
params = request.get_json(cache=False,silent=True)
key = []
value = []
if 'id' not in params:
return utility.json_return(400, message = 'Params error')
for item in params:
key.append(item)
value.append(params[item])
try:
sql = "DELETE FROM " + config_name + " WHERE id = %s "
res = self.mysqlutil.update(sql, params['id'])
return utility.json_return(200, data=res)
except Exception as e:
return utility.json_return(400, message = str(e))
def post(self):
#try:
params = request.get_json(cache=False, silent=True)
# fundid 轉換成 majorfundid
major_fundid_dict, params['funds'] = self.get_major_fund_id(params['funds'])
# 檢查是否有相同的pool_name
duplicated, pool_id = self.check_pool_id(params['pool_name'])
if duplicated:
return utility.json_return(200, data={"result": 'duplicated', "pool_id": pool_id, "major_fundid": major_fundid_dict})
# 建立fund_pool
self.fundpool_creator(pool_id, params)
return utility.json_return(200, data = {"result": 'success', "pool_id": pool_id, "major_fundid": major_fundid_dict})
def get(self):
sql = "SELECT DISTINCT pool_id, pool_name FROM fund_pool WHERE enabled = 1 ORDER BY pool_id DESC"
res = self.mysqlutil.fetchall(sql)
if res is None:
return {}
data = json.dumps([dict(r) for r in res], default=datetime_handler)
return utility.json_return(200, data=json.loads(data))
def put(self, config_name):
params = request.get_json(cache=False,silent=True)
key = []
value = []
if 'id' not in params:
return utility.json_return(400, message = 'Params error')
for item in params:
key.append(item)
value.append(params[item])
try:
ts = int(str(time.time()).split('.')[0])
datestr = datetime.datetime.fromtimestamp(ts).strftime('%Y-%m-%d %H:%M:%S')
key.append('updated_at')
value.append(datestr)
value.append(params['id'])
sql = "UPDATE " + config_name + " SET " + ", ".join( ('`' + k + '` = %s') for k in key ) + " WHERE id = %s "
res = self.mysqlutil.update(sql, value)
return utility.json_return(200, data=res)
except Exception as e:
return utility.json_return(400, message = str(e))
def get(self, config_name):
try:
conditions = request.args.get('conditions')
wheres = " WHERE 1 = 1 "
if conditions != None:
params = json.loads(conditions)
for item in params:
if isinstance(params[item], list):
wheres = wheres + " AND " + item + " IN ('"
wheres = wheres + "','".join(params[item]) + "')"
else:
wheres = wheres + " AND " + item + " = '"
wheres = wheres + params[item] + "'"
# print(wheres)
sql = ("SELECT * FROM %s %s " % (config_name, wheres))
res = self.mysqlutil.fetchall(sql)
#print(res)
data = json.dumps([dict(r) for r in res], default=datetime_handler)
#print(data)
return utility.json_return(200, data=json.loads(data))
except Exception as e:
return utility.json_return(400, message = str(e))
def put(self):
#try:
params = request.get_json(cache=False, silent=True)
fund_list = "','".join([i for i in params['fund_list']])
candidated_list = "','".join([i for i in params['candidated_list']])
if len(fund_list) == 0:
return utility.json_return(400, message='fund list required.')
if len(candidated_list) < 0:
return utility.json_return(400, message='candidated list required.')
if 'pool_id' not in params:
return utility.json_return(400, message='pool_id required.')
sql = "UPDATE fund_pool SET enabled = 0, candidated = 0 WHERE pool_id = %s "
self.mysqlutil.update(sql, (params['pool_id']))
sql = ("UPDATE fund_pool SET enabled = 1 WHERE fund_id IN ('%s') AND pool_id = %s " % (fund_list, '%s'))
f = self.mysqlutil.update(sql, (params['pool_id']))
sql = ("UPDATE fund_pool SET candidated = 1 WHERE fund_id IN ('%s') AND pool_id = %s " % (candidated_list, '%s'))
c = self.mysqlutil.update(sql, (params['pool_id']))
res = f+c
return utility.json_return(200, data = {"result": 'success', "data": res})
