有时候Jenkins涉及的操作太多，真的不知道是谁干的，我内网的slave 就是突然连不上了。报错： ERROR: Failed to authenticate as jenkins. Wrong password. (credentialId:slave-ssh/method:password)提示密码错误，但是真的谁都没改过！于是我登录内网虚拟机[root@localhost init.d]#

1.切分包含数组和json字符串#1.原始info字段的数据:[{"num":1,"name":"Lisa","score":90},{"num":2,"name":"Melody","score":80}]#2.解析代码:select distinctb.id,b.info,GET_JSON_OBJECT(b.info,'$.id') as id,GET_JSON_OBJECT(b.info,'

#!/usr/bin/python# -*- coding: UTF-8 -*-import sys, osimport commandsimport urllibdef download(url_str,save_path,filename):full_path = save_path + '/' + filenameLog.i("full_path:"+full_path)try:urllib

#!/usr/bin/python# -*- coding: UTF-8 -*-import subprocessimport sys, osimport commandsimport oss2def upload_to_update_oss(oss_src,file_path,file_name):# 上传json到OSSauth = oss2.Auth('名称', '密码')bucket =

#!/usr/bin/python# -*- coding: UTF-8 -*-import sys, osimport commandsdef Touch(file_name,file_path):os.chdir(file_path)if file_name in os.listdir('.'):print("file exist!")else:print("creating %s" %fil

#!/usr/bin/python# -*- coding: UTF-8 -*-import sys, osimport commandsimport urllibdef get_filename(url_str):url = urlparse(url_str)i = len(url.path) - 1while i > 0:if url.path[i] == '/':breaki = i

#!/usr/bin/env python# -*- coding: utf-8 -*-import reimport argparseimport osimport commandsimport hashlibimport subprocessimport sysimport shutilimport MySQLdbimport MySQLdb.cursorsreload(sys)sys.set

表名采用26个英文字母（区分大小写）和0-9自然数（一般不需要）加上下划线“_”组成，多个单词用下划线“_”分隔1.表名的格式一般为【模块名称-详细信息】2.全部小写命令，禁止出现大写3.表的名称一般使用名词或者动宾短语4.建议不适用缩写，填写完整单词5.表的名字不能取太长，一般不超过三个英文单词，不推荐中文拼音6.多对多的连接表可以使用两个表的前缀作为表名7.表名的单词一般都为单数（例：推荐Em