def get_build_log(**kwargs):
"""
获取构建日志
:return:
"""
if kwargs:
data = get_data_base_filter('B_T_L_DB', **kwargs)
else:
data = get_data_base_filter('B_T_L_DB')
if type(data) is str:
data = []
return data
def get_tag_info(**kwargs):
"""
获取代码版本
:return:
"""
if kwargs:
data = get_data_base_filter('S_O_T_DB', **kwargs)
else:
data = get_data_base_filter('S_O_T_DB')
if type(data) is str:
return None
return data
def get_pack_default_configure(**kwargs):
"""
获取默认打包配置数据
:param kwargs:
:return:
"""
if kwargs:
proxy_ver = get_data_base_filter('PackDefaultConfigure', **kwargs)
else:
proxy_ver = get_data_base_filter('PackDefaultConfigure')
if type(proxy_ver) is str:
return None
return proxy_ver
def get_proxy_version_info(**kwargs):
"""
获取反向代理信息 proxyVersion
:param kwargs:
:return:
"""
if kwargs:
proxy_ver = get_data_base_filter('R_P_DB', **kwargs)
else:
proxy_ver = get_data_base_filter('R_P_DB')
if type(proxy_ver) is str:
return None
return proxy_ver
def get_dpi_config_all(**kwargs):
"""
D_M_DB 表数据表
S_D_C_F_DB 表数据表
Device Model Data Base
Deep Packet Inspection Config Version Data Base
:return:
"""
if kwargs:
dpi_config = get_data_base_filter('dpiConfigVersion', **kwargs)
else:
dpi_config = get_data_base_filter('dpiConfigVersion')
if type(dpi_config) is str:
return None
return dpi_config
def get_super_tack_data(tn, dev_id):
"""
S_T_V_DB 表数据表
SuperTack Version Data Base
:return:
"""
if tn == c_sapiloader:
ty = 'supertack'
elif tn == shell_sapiloader:
ty = 'superctl'
else:
return '参数错误'
info = dict()
data = list()
dev_model = get_data_base_filter('D_M_DB', id=dev_id)
if type(dev_model) != str:
if dev_model:
super_tack = get_data_base_filter(
'S_T_V_DB',
supertack_type=tn,
dev_model=dev_model[0]['oem_model'])
if type(super_tack) != str:
for i in super_tack[:5]:
info['id'] = i['id']
info['version'] = i['supertack_version']
info['comment'] = i['comment']
info['update_time'] = i['update_time']
info['type'] = ty
data.append(info)
else:
return super_tack
else:
super_tack = get_data_base_filter('S_T_V_DB', supertack_type=tn)
if type(super_tack) != str:
for i in super_tack[:10]:
info['id'] = i['id']
info['version'] = i['supertack_version']
info['comment'] = i['comment']
info['update_time'] = i['update_time']
info['type'] = ty
data.append(info)
else:
return super_tack
return data
def get_info_online_log(**kwargs):
"""
获取上线日志
:param kwargs:
:return:
"""
if kwargs:
data = get_data_base_filter('R_O_P_L_DB', **kwargs)
if type(data) is str:
log.warning(f'插件打包信息获取失败，原因：{data}')
else:
return data
else:
data = get_data_base_filter('R_O_P_L_DB')
if type(data) is str:
log.warning(f'插件打包信息获取失败，原因：{data}')
else:
return data
def get_info_super_data_package(**kwargs):
"""
获取插件打包信息
:param kwargs:
:return:
"""
if kwargs:
data = get_data_base_filter('B_P_R_DB', **kwargs)
if type(data) is str:
log.warning(f'插件打包信息获取失败，原因：{data}')
else:
return data
else:
data = get_data_base_filter('B_P_R_DB')
if type(data) is str:
log.warning(f'插件打包信息获取失败，原因：{data}')
else:
return data
def get_info_super_api_loader_package(**kwargs):
"""
sapiloader 打包数据存储
:param kwargs:
:return:
"""
if kwargs:
data = get_data_base_filter('S_A_L_P_DB', **kwargs)
if type(data) is str:
log.warning(f'查询sapiloader 包失败，原因：{data}')
return None
else:
data = get_data_base_filter('S_A_L_P_DB')
if type(data) is str:
log.warning(f'查询sapiloader 包失败，原因：{data}')
return None
return data
def get_super_api_loader_data(**kwargs):
"""
获取sapiloder 信息
:return:
"""
if kwargs:
data = get_data_base_filter('S_A_L_DB', **kwargs)
else:
data = get_data_base('S_A_L_DB')
return data
def get_super_data(**kwargs):
"""
D_M_DB 表数据表
S_D_DB 表数据表
Device Model Data Base
SuperD Data BaseB
:return:
"""
superdinfo = None
device_model = get_data_base_filter('D_M_DB', **kwargs)
if 'error' not in str(device_model):
superdinfo = get_data_base_filter(
'S_D_DB', dev_model=device_model[0]['zy_model'])
if 'error' in str(superdinfo):
superdinfo = None
data = {
'superdInfo': superdinfo,
}
return data
def get_super_d_config_data(**kwargs):
"""
D_M_DB 表数据表
S_D_C_F_DB 表数据表
Device Model Data Base
SuperD Config File Data Base
:return:
"""
if kwargs:
device_model = get_data_base_filter('D_M_DB', **kwargs)
if type(device_model) is str:
return None
superdcf = get_data_base_filter('S_D_C_F_DB',
dev_model=device_model[0]['zy_model'])
if type(superdcf) is str:
return None
return superdcf
else:
superdcf = get_data_base('S_D_C_F_DB')
return superdcf
def get_build_package_info(ids=''):
"""
查询结果包
:param ids:
:return:
"""
if ids:
data = get_data_base_filter('B_P_R_DB', id=ids)
else:
data = get_data_base('B_P_R_DB')
if type(data) is str:
log.warning(f'pg包数据查询失败，原因{data}')
return {}
return data
def get_map_dev_model(dev_model):
"""
由于cbild.sh 文件写的是非标准型号，故需要做个映射进行适配,如果不需要映射则原样输出
:return:
"""
data = get_data_base_filter('M_D_M_DB', dev_model=dev_model)
if type(data) is str:
log.warning('未找到该型号【{}】的map关系,将使用原始型号进行构建'.format(dev_model))
map_dev_model = dev_model
else:
if len(data) > 0:
map_dev_model = data[0]['map_dev_model']
log.debug('dev_model:{} map_dev_model:{}'.format(
dev_model, map_dev_model))
else:
log.warning('未找到该型号【{}】的map关系,将使用原始型号进行构建'.format(dev_model))
map_dev_model = dev_model
return map_dev_model
def get_super_d_all(branch='', build_type=None):
"""
获取superD插件信息
:param branch:
:param build_type:
:return:
"""
if not branch:
branch = config_branch['superd_branch']
git = GitProcess(superd_project_path)
git._init_directoy(branch)
if build_type is 'test':
data = get_data_base_filter('S_D_DB', build_type=build_type)
if type(data) is str:
return []
return data[:100]
else:
data = exclude_data_base('S_D_DB', build_type='test')
if type(data) is str:
return []
return data[:100]
def inset_into_dev_model(*args):
"""
新增设备数据
:param args:
:return:
"""
if len(args) != 7:
return '参数错误'
oem = get_data_base_filter('O_E_M_DB', id=int(args[0]))[0]
log.debug(oem)
if type(oem) == str:
return '未找到oem数据'
rdata = sp_api.adddev_model(type=args[3],
dev_model=args[4],
oem_model=args[6],
old_model='',
oem_name=oem['oem_name'],
comment=args[1],
user=args[2])
rapdata = ap_api.add_dev_model(cate_name=args[3],
model_name=args[4],
salscom=oem['oem_name'],
oem_name=oem['oem_name'])
log.debug(rdata)
log.debug(rapdata)
data = insert_into_data('D_M_DB',
comment=args[1],
user=args[2],
type=args[3],
zy_model=args[4],
oem_id=args[5],
oem_name=oem['oem_name'],
oem_code=oem['oem_code'],
oem_model=args[6])
log.debug(data)
return data
