def up_pack9_default(exlPath="", type=0):
"""
打包内置资源
"""
resource_name = []
m = MyExcelUtil(exlPath)
for j in range(0, 7):
for i in range(1, m.get_row_num(j)):
# print m.get_rowCol_data(i, 5, j)
resource_name.append(m.get_rowCol_data(i, 5, j).strip())
# mydb = MysqldbHelper(host='10.10.19.117', port=3306, user='******', password='******', db='store')
# resource_dict = mydb.executeSql(
# 'SELECT slug from wx_pack_9_resource where resource_status = 3')
# for name in resource_dict:
# resource_name.append(name["slug"])
resource_name = list(set(resource_name))
# print len(resource_name)
try:
print "内置资源个数：" + str(len(resource_name))
if type == 0:
resText = reqApi.post_Pack9Add("DefaultPackage 93", "", "DefaultPackage_93", resource_name)
else:
resText = reqApi.post_shenCutPackAdd("DefaultPackage", "", "DefaultPackage_33", resource_name)
if resText.find(u"操作成功") >= 0:
print("操作成功 ")
except Exception as err:
print err
print("操作失败")
def up_pack9(exlPath, type=0):
"""
打包pack
:param exlPath:
"""
m = MyExcelUtil(exlPath)
pack_name = []
for j in range(0, 6):
for i in range(1, m.get_row_num(j)):
# print m.get_rowCol_data(i, 6, j)
# if m.get_rowCol_data(i, 6, j).upper() == "Y":
data = m.get_rowCol_data(i, 4, j)
pack_name.append(data)
pack_name = list(set(pack_name))
print pack_name
time = 0
for name in pack_name:
resource_name = []
for j in range(0, 6):
for i in range(1, m.get_row_num(j)):
if m.get_rowCol_data(i, 6, j).upper() == "Y" and m.get_rowCol_data(i, 4, j) == name:
resource_name.append(m.get_rowCol_data(i, 3, j))
MyExcelUtil(exlPath).write_rowNum_data(i, 6,
MyExcelUtil.set_style(3),
j, "N", "PASS")
# print resource_name
# jp = convert_jp(name)
jp = ""
print(name, "", replace_space(name), resource_name)
def copy_id(exlPath, exlPath2):
dict_data = get_condict()
for j in range(0, 6):
print MyExcelUtil(exlPath2).get_row_num(j)
for i in range(1, MyExcelUtil(exlPath2).get_row_num(j)):
d = MyExcelUtil(exlPath2).get_rowCol_data(i, 10, j)
print d
for key, value in dict_data.items():
if (d == key):
MyExcelUtil(exlPath2).write_data(i, 11, value,
MyExcelUtil.set_style(2),
j)
continue
def get_condict():
"""
获取excel前两列数据
:return: 元组
"""
exlPath = r"E:\work\python\UI-Project\req\upload\pack_language.xls"
data = []
for i in range(1, MyExcelUtil(exlPath).get_row_num()):
key = MyExcelUtil(exlPath).get_rowCol_data(i, 0)
val = MyExcelUtil(exlPath).get_rowCol_data(i, 1)
data.append((key, val))
dict_data = dict(data)
return dict_data
def find_id(exlPath):
m = MyExcelUtil(exlPath)
mydb = MysqldbHelper(host='10.10.19.117', port=3306, user='******', password='******', db='filmora_es_admin')
for j in range(4, 6):
name = m.get_sheet_names()
for i in range(1, m.get_row_num(j)):
d = m.get_rowCol_data(i, 1, j)
if name[j] == "MUSIC":
value = 'sound_' + replace_space2(d).lower()
elif name[j] == "TEXT":
value = 'text_' + replace_space2(d).lower()
elif name[j] == "TRANSITIONS":
value = 'trans_' + replace_space2(d).lower()
elif name[j] == "FILTERS":
value = 'effect_' + replace_space2(d).lower()
elif name[j] == "OVERLAYS":
value = 'overlay_' + replace_space2(d).lower()
elif name[j] == "ELEMENTS":
value = 'element_' + replace_space2(d).lower()
elif name[j] == "SPLIT":
value = 'split_' + replace_space2(d).lower()
if m.get_rowCol_data(i, 8, j).upper() == "Y":
print value
result = mydb.executeSqlOne(
'SELECT id,catdir from wx_resource_category where child = 0 and catdir = \"{}\"'.format(value))
if result is not None:
print result["id"]
MyExcelUtil(exlPath).write_data(i, 5, result["id"], MyExcelUtil.set_style(8), j)
def get_store_excelValue(exlPath, val, n):
"""
获取商城资源名称
:param exlPath:
:param val:
:param n:sheet页
:return:
"""
m = MyExcelUtil(exlPath)
for i in range(1, m.get_row_num(n)):
d = m.get_rowCol_data(i, 3, n)
# print d
if d.lower() == val.lower():
return m.get_rowCol_data(i, 6, n)
def sql_filmora9(exlPath):
# mydb = MysqldbHelper(host='10.10.19.117', port=3306, user='******', password='******', db='filmora_es_admin')
# mydb = MysqldbHelper(host='10.10.18.252', port=33064, user='******', password='******', db='f_common')
mydb = MysqldbHelper(host='192.168.11.82',
port=3307,
user='******',
password='******',
db='filmora_es_admin')
m = MyExcelUtil(exlPath)
pack_name = []
for j in range(0, 6):
for i in range(1, m.get_row_num(j)):
# print m.get_rowCol_data(i, 6, j)
if m.get_rowCol_data(i, 5, j).upper() == "Y":
data = m.get_rowCol_data(i, 4, j)
pack_name.append(data)
pack_name = list(set(pack_name))
# print pack_name
for name in pack_name:
sql = 'SELECT pack9_id,pack9_slug,pack9_url from wx_pack WHERE title="{}" and siteid =1'.format(
name)
r = mydb.executeSqlOne(sql)
# print r
# sql_siteid = 'SELECT siteid from wx_pack WHERE title="{}"'.format(name)
# print sql_siteid
# result_siteid = mydb.executeSqlOne(sql_siteid)
# print result_siteid
if r is not None and len(r["pack9_url"]) > 1:
# print r["pack9_url"]
for i in range(2, 21):
sql3 = 'SELECT pack9_id,pack9_slug,pack9_url from wx_pack WHERE title="{}" and siteid ={}'.format(
name, i)
result3 = mydb.executeSqlOne(sql3)
if result3 is not None:
sql2 = 'UPDATE wx_pack SET pack9_id = {},pack9_slug="{}",pack9_url="{}" WHERE title="{}" and siteid ={};'.format(
r["pack9_id"], r["pack9_slug"], r["pack9_url"], name,
i)
print sql2
mydb2 = MysqldbHelper(host='192.168.11.82',
port=3307,
user='******',
password='******',
db='filmora_es_admin')
def sql_filmora9_JP(exlPath):
"""
配置多语言（日语）
:param exlPath:
"""
# mydb = MysqldbHelper(host='10.10.19.117', port=3306, user='******', password='******', db='filmora_es_admin')
# mydb = MysqldbHelper(host='10.10.18.252', port=33064, user='******', password='******', db='f_common')
mydb = MysqldbHelper(host='192.168.11.82', port=3307, user='******', password='******',
db='filmora_es_admin')
m = MyExcelUtil(exlPath)
pack_name = []
# 获取pack name
# for j in range(0, 6):
# for i in range(1, m.get_row_num(j)):
# # print m.get_rowCol_data(i, 6, j)
# if m.get_rowCol_data(i, 6, j).upper() == "Y":
# data = m.get_rowCol_data(i, 4, j)
# pack_name.append(data)
# pack_name = list(set(pack_name))
# 获取set name
for i in range(1, m.get_row_num(6)):
if m.get_rowCol_data(i, 2, 6).upper() == "Y":
data = m.get_rowCol_data(i, 1, 6)
pack_name.append(data)
pack_name = list(set(pack_name))
# print pack_name
for name in pack_name:
sql_jp = 'SELECT pack9_id,pack9_slug,pack9_url from wx_pack WHERE slug="{}" and siteid =3 and status=99'.format(
name.replace(" ", "-"))
# print sql_jp
r = mydb.executeSqlOne(sql_jp)
# print r
# sql_siteid = 'SELECT siteid from wx_pack WHERE title="{}"'.format(name)
# print sql_siteid
# result_siteid = mydb.executeSqlOne(sql_siteid)
# print result_siteid
if r is not None and int(r["pack9_id"]) == 0:
sql_jp2 = 'SELECT pack9_id,pack9_slug,pack9_url from wx_pack WHERE title="{}" and siteid =1'.format(name)
r2 = mydb.executeSqlOne(sql_jp2)
# print r["pack9_url"]
sql2 = 'UPDATE wx_pack SET pack9_id = {},pack9_slug="{}",pack9_url="{}" WHERE slug="{}" and siteid =3;'.format(
r2["pack9_id"], r2["pack9_slug"], r2["pack9_url"], name.replace(" ", "-"))
print sql2
def write_video(path, excelPath, cname):
root = get_doc_root(path)
Name = root.xpath("//FormatInfo/Name/text()")
# print Name
for index, name in enumerate(Name):
# print index, name
if name == cname:
video = get_video(path, index + 1)
audio = get_audio(path, index + 1)
j = len(video) + 1
i = 1
for v in video:
v_list = v.split(",")
if v_list[0] == "Xvid" or v_list[0] == "MP4V":
v_list[0] = "MPEG-4"
elif v_list[0] == "MJPG":
v_list[0] = "MJPEG"
elif v_list[0] == "H264":
v_list[0] = "H.264"
elif v_list[0] == "MP2V":
v_list[0] = "MPEG-2"
elif v_list[0] == "H263":
v_list[0] = "H.263"
print v_list
MyExcelUtil(excelPath).write_rowNum_data2(
i, 3, MyExcelUtil.set_style(8), index, v_list)
i = i + 1
for a in audio:
a_list = a.split(",")
if a_list[0] == "MP2A":
a_list[0] = "MPEG-2 audio"
elif a_list[0] == "VBIS":
a_list[0] = "Vorbis"
if a_list[1] == "1":
a_list[1] = "Mono"
elif a_list[1] == "2":
a_list[1] = "Stereo"
else:
a_list[1] = "5.1 Surround Sound"
print a_list
MyExcelUtil(excelPath).write_rowNum_data2(
j, 7, MyExcelUtil.set_style(8), index, a_list)
j = j + 1
def sql_filmora9(exlPath):
import json
"""
配置多语言
:param exlPath:
"""
mydb = MysqldbHelper(host='10.10.19.117', port=3306, user='******', password='******', db='store')
# mydb = MysqldbHelper(host='10.10.18.252', port=33064, user='******', password='******', db='f_common')
# mydb = MysqldbHelper(host='192.168.11.82', port=3307, user='******', password='******',
# db='filmora_es_admin')
sql = 'SELECT * from wx_resource_category'
r_list = mydb.executeSql(sql)
# print r_list
m = MyExcelUtil(exlPath)
pack_name = []
name = {}
# 获取pack name
for i in range(1, m.get_row_num()):
# print m.get_rowCol_data(i, 6, j)
for r in r_list:
# print r["catname"]
# print json.loads(r["catname"])["en"]
catname = {}
catname["zh"] = json.loads(r["catname"])["zh"]
if catname["zh"] == m.get_rowCol_data(i, 0):
name[catname["zh"]] = m.get_rowCol_data(i, 1)
# print catname["zh"]
print name
# name = json.dumps(name,ensure_ascii=False)
# print name
for k, v in name.items():
catkey = {}
catkey["zh"] = k,
catkey = json.dumps(catkey)
catname = {}
catname["zh"] = v
catname = json.dumps(catname, ensure_ascii=False)
sql = "UPDATE wx_resource_category SET catname = '{}' where catname = '{}';".format(catname, catkey)
print sql
def conver_to_mysql(exlPath):
mydb = MysqldbHelper(host='192.168.11.83',
port=3306,
user='******',
password='******',
db='Wang_Test')
m = MyExcelUtil(exlPath)
for j in range(0, 1):
for i in range(1, m.get_row_num(j)):
# categoryExcel = m.get_rowCol_data(i, 0, j)
enExcel = m.get_rowCol_data(i, 0, j)
# print enExcel
# print unicode(enExcel, "utf8")
jpExcel = m.get_rowCol_data(i, 1, j)
deExcel = m.get_rowCol_data(i, 2, j)
frExcel = m.get_rowCol_data(i, 3, j)
ptExcel = m.get_rowCol_data(i, 4, j)
esExcel = m.get_rowCol_data(i, 5, j)
itExcel = m.get_rowCol_data(i, 6, j)
# print enExcel, frExcel, deExcel, esExcel, itExcel, ptExcel, jpExcel
sql = 'INSERT INTO pack9_multi_language(en,fr,de,es,it,pt,jp) VALUES (\"{}\",\"{}\",\"{}\",\"{}\",\"{}\",\"{}\",\"{}\")'.format(
enExcel, frExcel, deExcel, esExcel, itExcel, ptExcel, jpExcel)
print sql
mydb.executeCommentSqlOnce(sql)
def edit(n):
"""
修改文件，同步修改excel状态，清空文件夹
:param filepath:修改文件的目录
:param exlPath:excel文件的目录
:param n:excel修改的sheet页
"""
files = os.listdir(filepath)
m = MyExcelUtil(exlPath)
print files
j = 0
for f in files:
for i in range(1, m.get_row_num(n)):
# 匹配对应资源包名称
d = m.get_rowCol_data(i, 2, n)
if f == d:
j = j + 1
print d, j
MyExcelUtil(exlPath).write_rowNum_data(i, 8,
MyExcelUtil.set_style(2),
n, "Y", "")
def edit_default_resource(exlPath):
dir = r"C:\Users\ws\Desktop\20181208"
listDir = list_dir(dir)
i = 1
for d in listDir:
zip_dir(d)
m = MyExcelUtil(exlPath)
time = 0
for j in range(0, 7):
for i in range(1, m.get_row_num(j)):
if m.get_rowCol_data(i, 6, j).upper() == "Y":
zipDir = dir + "\\" + m.get_rowCol_data(
i, 2, j) + "\\" + m.get_rowCol_data(i, 4, j) + ".zip"
# print zipDir
if os.path.exists(zipDir):
print zipDir
if m.get_rowCol_data(i, 2, j).lower() == "title":
resource_type = 1
elif m.get_rowCol_data(i, 2, j).lower() == "transition":
resource_type = 2
elif m.get_rowCol_data(i, 2, j).lower() == "filter":
resource_type = 3
elif m.get_rowCol_data(i, 2, j).lower() == "overlay":
resource_type = 4
elif m.get_rowCol_data(i, 2, j).lower() == "splitscreen":
resource_type = 5
elif m.get_rowCol_data(i, 2, j).lower() == "audio":
resource_type = 6
elif m.get_rowCol_data(i, 2, j).lower() == "element":
resource_type = 7
try:
resUrl = reqApi.post_files(zipDir, 2)
print resUrl
resText = reqApi.post_ResourceEdit(
m.get_rowCol_data(i, 8, j), resUrl,
m.get_rowCol_data(i, 5, j),
m.get_rowCol_data(i, 1, j),
m.get_rowCol_data(i, 0, j), resource_type,
"default Edit")
if resText.find(u"操作成功") >= 0:
time = time + 1
print("操作成功 " + str(time))
MyExcelUtil(exlPath).write_rowNum_data(
i, 6, MyExcelUtil.set_style(3), j, "N", "PASS")
else:
print("操作失败")
MyExcelUtil(exlPath).write_data(
i, 7, "FAIL", MyExcelUtil.set_style(2), j)
except Exception as err:
print err
MyExcelUtil(exlPath).write_data(
i, 7, "FAIL", MyExcelUtil.set_style(2), j)
def up_store_resource(exlPath):
"""
上传商城资源
:param exlPath:
"""
dir = r"E:\Filmore\package\Filmaro9.X-FX-Vault\Resource Packs"
m = MyExcelUtil(exlPath)
listDir = list_dir(dir)
for d in listDir:
zip_dir(d)
time = 0
for j in range(0, 6):
for i in range(1, m.get_row_num(j)):
if m.get_rowCol_data(i, 8, j).upper() == "Y":
zipDir = dir + "\\" + m.get_rowCol_data(i, 7, j) + "\\" + m.get_rowCol_data(i, 2, j) + ".zip"
print zipDir
if os.path.exists(zipDir):
# print zipDir
# import shutil
# zipDir2 = r"C:\Users\ws\Desktop\2\\" + m.get_rowCol_data(i, 3, j) + ".zip"
# shutil.copy(zipDir,zipDir2)
# print type(zipDir)
if m.get_rowCol_data(i, 7, j).lower() == "title":
resource_type = 1
elif m.get_rowCol_data(i, 7, j).lower() == "transition":
resource_type = 2
elif m.get_rowCol_data(i, 7, j).lower() == "filter":
resource_type = 3
elif m.get_rowCol_data(i, 7, j).lower() == "overlay":
resource_type = 4
elif m.get_rowCol_data(i, 7, j).lower() == "audio":
resource_type = 6
elif m.get_rowCol_data(i, 7, j).lower() == "element":
resource_type = 7
try:
if "Filmora" in exlPath:
resUrl = reqApi.post_files(zipDir, 2)
print resUrl
resText = reqApi.post_ResourceAdd(m.get_rowCol_data(i, 6, j), resUrl,
m.get_rowCol_data(i, 3, j),
m.get_rowCol_data(i, 4, j), m.get_rowCol_data(i, 5, j),
resource_type, "store auto")
else:
resUrl = reqApi.post_shenCut_files(zipDir)
print resUrl
# resUrl = ""
resText = reqApi.post_shenCutAdd(m.get_rowCol_data(i, 6, j), resUrl,
m.get_rowCol_data(i, 3, j),
m.get_rowCol_data(i, 4, j), m.get_rowCol_data(i, 5, j),
resource_type, "shenCut store auto")
if resText.find(u"操作成功") >= 0:
time = time + 1
print("操作成功 " + str(time))
MyExcelUtil(exlPath).write_rowNum_data(i, 8,
MyExcelUtil.set_style(3),
j, "N", "PASS")
elif resText.find(u"唯一标识不能重复") >= 0:
print("唯一标识不能重复")
MyExcelUtil(exlPath).write_data(i, 9, "FAIL",
MyExcelUtil.set_style(2),
j)
else:
print("操作失败")
MyExcelUtil(exlPath).write_data(i, 9, "FAIL",
MyExcelUtil.set_style(2),
j)
except Exception as err:
print err
MyExcelUtil(exlPath).write_data(i, 9, "FAIL",
MyExcelUtil.set_style(2),
j)
def up_store_resource(exlPath):
dir = r"C:\Users\ws\Desktop\9.0_pack"
m = MyExcelUtil(exlPath)
listDir = list_dir(dir)
for d in listDir:
zip_dir(d)
time = 0
for j in range(0, 6):
for i in range(1, m.get_row_num(j)):
if m.get_rowCol_data(i, 8, j).upper() == "Y":
zipDir = dir + "\\" + m.get_rowCol_data(
i, 7, j) + "\\" + m.get_rowCol_data(i, 2, j) + ".zip"
# print zipDir
if os.path.exists(zipDir):
print zipDir
# print type(zipDir)
if m.get_rowCol_data(i, 7, j).lower() == "title":
resource_type = 1
elif m.get_rowCol_data(i, 7, j).lower() == "transition":
resource_type = 2
elif m.get_rowCol_data(i, 7, j).lower() == "filter":
resource_type = 3
elif m.get_rowCol_data(i, 7, j).lower() == "overlay":
resource_type = 4
elif m.get_rowCol_data(i, 7, j).lower() == "audio":
resource_type = 6
elif m.get_rowCol_data(i, 7, j).lower() == "element":
resource_type = 7
try:
resUrl = reqApi.post_files(zipDir, 2)
print resUrl
resText = reqApi.post_ResourceAdd(
m.get_rowCol_data(i, 6, j), resUrl,
m.get_rowCol_data(i, 3, j),
m.get_rowCol_data(i, 4, j),
m.get_rowCol_data(i, 5, j), resource_type,
"store auto")
if resText.find(u"操作成功") >= 0:
time = time + 1
print("操作成功 " + str(time))
MyExcelUtil(exlPath).write_rowNum_data(
i, 8, MyExcelUtil.set_style(3), j, "N", "PASS")
elif resText.find(u"唯一标识不能重复") >= 0:
print("唯一标识不能重复")
MyExcelUtil(exlPath).write_data(
i, 9, "FAIL", MyExcelUtil.set_style(2), j)
else:
print("操作失败")
MyExcelUtil(exlPath).write_data(
i, 9, "FAIL", MyExcelUtil.set_style(2), j)
except Exception as err:
print err
MyExcelUtil(exlPath).write_data(
i, 9, "FAIL", MyExcelUtil.set_style(2), j)
def up_store_resource(exlPath, j):
m = MyExcelUtil(exlPath)
listDir = list_dir(r"E:\work\Filmora9\package\packs")
n = -1
for d in listDir:
i = 1
n = n + 1
childDir = list_dir(d)
for dd in childDir:
i = i + 1
zipDir = dd + '.zip'
if os.path.exists(zipDir):
pass
else:
zip_ya(dd, zipDir)
dir = r"E:\work\Filmora9\package\packs\\"
time = 0
for i in range(1, m.get_row_num(j)):
if m.get_rowCol_data(i, 8, j).upper() == "Y":
zipDir = dir + m.get_rowCol_data(
i, 7, j) + "\\" + m.get_rowCol_data(i, 6, j) + ".zip"
# print zipDir
if os.path.exists(zipDir):
print zipDir
if m.get_rowCol_data(i, 7, j).lower() == "title":
resource_type = 1
elif m.get_rowCol_data(i, 7, j).lower() == "transition":
resource_type = 2
elif m.get_rowCol_data(i, 7, j).lower() == "filter":
resource_type = 3
elif m.get_rowCol_data(i, 7, j).lower() == "overlay":
resource_type = 4
elif m.get_rowCol_data(i, 7, j).lower() == "audio":
resource_type = 6
elif m.get_rowCol_data(i, 7, j).lower() == "element":
resource_type = 7
MyExcelUtil(exlPath).write_rowNum_data(
i, 8, MyExcelUtil.set_style(3), j, "N", "PASS")
def up_pack9(exlPath):
m = MyExcelUtil(exlPath)
pack_name = []
for j in range(0, 6):
for i in range(1, m.get_row_num(j)):
# print m.get_rowCol_data(i, 6, j)
if m.get_rowCol_data(i, 5, j).upper() == "Y":
data = m.get_rowCol_data(i, 4, j)
pack_name.append(data)
pack_name = list(set(pack_name))
print pack_name
time = 0
for name in pack_name:
resource_name = []
for j in range(0, 6):
for i in range(1, m.get_row_num(j)):
if m.get_rowCol_data(i, 5,
j).upper() == "Y" and m.get_rowCol_data(
i, 4, j) == name:
resource_name.append(m.get_rowCol_data(i, 3, j))
MyExcelUtil(exlPath).write_rowNum_data(
i, 5, MyExcelUtil.set_style(3), j, "N", "PASS")
# print resource_name
# jp = convert_jp(name)
jp = ""
print(name, "", replace_space(name), resource_name)
try:
if len(resource_name) > 0:
resText = reqApi.post_Pack9Add(name, jp, replace_space(name),
resource_name)
if resText.find(u"操作成功") >= 0:
time = time + 1
print("操作成功 " + str(time))
except Exception as err:
print err
print("操作失败")
def edit_store_resource(exlPath, e=1):
path = r"C:\Users\ws\Desktop\20181208"
#当e的值不为1时，代表不需要重新上传资源
m = MyExcelUtil(exlPath)
listDir = list_dir(path)
for d in listDir:
zip_dir(d)
dir = path + "\\"
time = 0
for j in range(0, 6):
for i in range(1, m.get_row_num(j)):
if m.get_rowCol_data(i, 8, j).upper() == "Y":
zipDir = dir + m.get_rowCol_data(
i, 7, j) + "\\" + m.get_rowCol_data(i, 2, j) + ".zip"
print zipDir
if os.path.exists(zipDir):
# print zipDir
if m.get_rowCol_data(i, 7, j).lower() == "title":
resource_type = 1
elif m.get_rowCol_data(i, 7, j).lower() == "transition":
resource_type = 2
elif m.get_rowCol_data(i, 7, j).lower() == "filter":
resource_type = 3
elif m.get_rowCol_data(i, 7, j).lower() == "overlay":
resource_type = 4
elif m.get_rowCol_data(i, 7, j).lower() == "audio":
resource_type = 6
elif m.get_rowCol_data(i, 7, j).lower() == "element":
resource_type = 7
try:
if e == 1:
resUrl = reqApi.post_files(zipDir, 2)
print resUrl
else:
resUrl = ""
print "资源不用上传"
resText = reqApi.post_ResourceEdit(
m.get_rowCol_data(i, 6, j), resUrl,
m.get_rowCol_data(i, 3, j),
m.get_rowCol_data(i, 4, j),
m.get_rowCol_data(i, 5, j), resource_type,
"store Edit")
if resText.find(u"操作成功") >= 0:
time = time + 1
print("操作成功 " + str(time))
MyExcelUtil(exlPath).write_rowNum_data(
i, 8, MyExcelUtil.set_style(3), j, "N", "PASS")
else:
print("操作失败")
MyExcelUtil(exlPath).write_data(
i, 9, "FAIL", MyExcelUtil.set_style(2), j)
except Exception as err:
print err
MyExcelUtil(exlPath).write_data(
i, 9, "FAIL", MyExcelUtil.set_style(2), j)
def up_set9(exlPath):
m = MyExcelUtil(exlPath)
set_dict = {}
set_dict2 = {}
for i in range(1, m.get_row_num(6)):
if m.get_rowCol_data(i, 2, 6).upper() == "Y":
setName = m.get_rowCol_data(i, 1, 6)
packName = m.get_rowCol_data(i, 0, 6)
set_dict[packName] = setName
set_dict2.update({setName: []})
# print set_dict2
for k, v in set_dict.items():
if set_dict2.has_key(v):
set_dict2[v].append(k)
else:
set_dict2[v] = []
# print set_dict2
time = 0
for s, p in set_dict2.items():
print p
resource_name = []
for j in range(0, 6):
for i in range(1, m.get_row_num(j)):
if m.get_rowCol_data(i, 4, j) in p:
resource_name.append(m.get_rowCol_data(i, 3, j))
MyExcelUtil(exlPath).write_data(i, 5, "PASS",
MyExcelUtil.set_style(3),
j)
# print resource_name
print(s, "", replace_space(s), resource_name)
try:
if len(resource_name) > 0:
resText = reqApi.post_Pack9Add(s, "", replace_space(s),
resource_name)
if resText.find(u"操作成功") >= 0:
time = time + 1
print("操作成功 " + str(time))
except Exception as err:
print err
def up_set9(exlPath, type=0):
"""
打包set
:param exlPath:
"""
mydb = MysqldbHelper(host='192.168.11.43', port=3306, user='******', password='******', db='store')
m = MyExcelUtil(exlPath)
set_dict = {}
set_dict2 = {}
for i in range(1, m.get_row_num(6)):
if m.get_rowCol_data(i, 2, 6).upper() == "Y":
setName = m.get_rowCol_data(i, 1, 6)
packName = m.get_rowCol_data(i, 0, 6)
sql = 'SELECT id from wx_pack9 where slug = \"{}\"'.format(
replace_space(setName))
result = mydb.executeSqlOne(sql)
if result is None:
set_dict[packName] = setName
set_dict2.update({setName: []})
print set_dict2
for k, v in set_dict.items():
if set_dict2.has_key(v):
set_dict2[v].append(k.lower())
else:
set_dict2[v] = []
print set_dict2
time = 0
for s, p in set_dict2.items():
print p
resource_name = []
for j in range(0, 6):
for i in range(1, m.get_row_num(j)):
if m.get_rowCol_data(i, 4, j).lower() in p:
resource_name.append(m.get_rowCol_data(i, 3, j))
MyExcelUtil(exlPath).write_data(i, 5, "PASS",
MyExcelUtil.set_style(3),
j)
# print resource_name
print(s, "", replace_space(s), resource_name)
try:
if len(resource_name) > 0:
if type == 0:
resText = reqApi.post_Pack9Add(s, "", replace_space(s), resource_name)
else:
resText = reqApi.post_shenCutPackAdd(s, "", replace_space(s), resource_name)
if resText.find(u"操作成功") >= 0:
time = time + 1
print("操作成功 " + str(time))
except Exception as err:
print err
def edit_default_resource(exlPath, type=0):
"""
编辑内置资源
:param exlPath:
"""
dir = r"E:\Filmore\package\Filmaro9.X-FX-Vault\Default"
listDir = list_dir(dir)
i = 1
for d in listDir:
zip_dir(d)
m = MyExcelUtil(exlPath)
time = 0
for j in range(0, 8):
for i in range(1, m.get_row_num(j)):
if m.get_rowCol_data(i, 6, j).upper() == "Y":
zipDir = dir + "\\" + m.get_rowCol_data(i, 2, j) + "\\" + m.get_rowCol_data(i, 4, j) + ".zip"
print zipDir
if os.path.exists(zipDir):
# print zipDir
if m.get_rowCol_data(i, 2, j).lower() == "title":
resource_type = 1
elif m.get_rowCol_data(i, 2, j).lower() == "transition":
resource_type = 2
elif m.get_rowCol_data(i, 2, j).lower() == "filter":
resource_type = 3
elif m.get_rowCol_data(i, 2, j).lower() == "overlay":
resource_type = 4
elif m.get_rowCol_data(i, 2, j).lower() == "splitscreen":
resource_type = 5
elif m.get_rowCol_data(i, 2, j).lower() == "audio":
resource_type = 6
elif m.get_rowCol_data(i, 2, j).lower() == "element":
resource_type = 7
elif m.get_rowCol_data(i, 2, j).lower() == "media":
resource_type = 8
elif m.get_rowCol_data(i, 2, j).lower() == "sfx":
resource_type = 10
try:
if type == 0:
resUrl = reqApi.post_files(zipDir, 2)
print resUrl
# resUrl = ""
resText = reqApi.post_ResourceEdit(m.get_rowCol_data(i, 8, j), resUrl,
m.get_rowCol_data(i, 5, j),
m.get_rowCol_data(i, 1, j), m.get_rowCol_data(i, 0, j),
resource_type, "default Edit"
)
else:
# resUrl = reqApi.post_shenCut_files(zipDir)
# print resUrl
resUrl = ""
# print "资源不用上传"
resText = reqApi.post_shenCutEdit(m.get_rowCol_data(i, 8, j), resUrl,
m.get_rowCol_data(i, 5, j),
m.get_rowCol_data(i, 1, j), m.get_rowCol_data(i, 0, j),
resource_type, "shenCut Edit"
)
if resText.find(u"操作成功") >= 0:
time = time + 1
print("操作成功 " + str(time))
MyExcelUtil(exlPath).write_rowNum_data(i, 6,
MyExcelUtil.set_style(3),
j, "N", "PASS")
import time as t
t.sleep(200)
else:
print("操作失败")
MyExcelUtil(exlPath).write_data(i, 7, "FAIL",
MyExcelUtil.set_style(2),
j)
except Exception as err:
print err
MyExcelUtil(exlPath).write_data(i, 7, "FAIL",
MyExcelUtil.set_style(2),
j)
return dir
def write_exl(i, num, *data):
exlPath = r"C:\Users\ws\Desktop\filmora9.0_pack\pack.xls"
MyExcelUtil(exlPath).write_rowNum_data(i, 2,
MyExcelUtil.set_style(0),
int(num), *data)
if __name__ == '__main__':
exlPath = r"C:\Users\ws\Desktop\filmora9.0_pack\pack.xls"
path = r"C:\Users\ws\Desktop\filmora9.0_pack"
# 前置把excel为空行
m = MyExcelUtil(exlPath)
for j in range(0, 6):
print m.get_row_num(j)
if m.get_row_num(j) > 1:
for i in range(1, m.get_row_num(j)):
write_exl(i, j, "", "", "", "", "")
# 循环遍历目录获取资源名称
dir_list = list_dir(path)
print dir_list
i, j, k, l = 1, 1, 1, 1
for dir_child in dir_list:
dir_child_list = os.listdir(dir_child)
print dir_child_list
for dir_child_zipName in dir_child_list:
if "1_" in dir_child_zipName and 'lowerthird' in dir_child_zipName.lower() or 'opener' in dir_child_zipName.lower() or 'title' in dir_child_zipName.lower():
# -*-coding:utf-8-*-s
from req.utils.sqldb import Database
from req.utils.ExcelUtil import MyExcelUtil
if __name__ == '__main__':
mydb = Database('192.168.11.83', 3306, 'root', 'root', 'Wang_Test')
m = MyExcelUtil(r"E:\work\python\UI-Project\req\upload\file\language.xls")
for i in range(1, m.get_row_num()):
en, de, es, fr, it, jp, pt = m.get_rowCol_data(i, 0).strip(), m.get_rowCol_data(i,
5).strip(), m.get_rowCol_data(i,
3).strip(), m.get_rowCol_data(
i, 2).strip(), m.get_rowCol_data(i, 4).strip(), m.get_rowCol_data(i, 1).strip(), m.get_rowCol_data(i,
6).strip()
print en, de, es, fr, it, jp, pt
sql = 'INSERT INTO pack9_multi_language(en, de, es, fr, it, jp, pt) VALUES("{}","{}","{}","{}","{}","{}","{}")'.format(
en, de, es, fr, it, jp, pt)
print sql
mydb.execNoQuery(sql)
# rows = mydb.execQuery(
# "SELECT name,SUM(testsRun),SUM(successes),SUM(failures),SUM(errors),date_format(create_time, '%Y%m%d') AS day from webinterface_Reports where date_format(create_time, '%Y%m%d') = date_format(NOW(), '%Y%m%d') GROUP BY NAME ORDER BY name")
def write_exl(i, num, *data):
exlPath = r"C:\Users\ws\Desktop\filmora9.0_pack\pack.xls"
MyExcelUtil(exlPath).write_rowNum_data(i, 2,
MyExcelUtil.set_style(0),
int(num), *data)
def edit_store_resource(exlPath, e=1):
"""
编辑商城资源
:param exlPath:
:param e: 为1时需要上传资源，其余不需要上传
"""
path = r"E:\Filmore\package\Filmaro9.X-FX-Vault\Resource Packs"
# 当e的值不为1时，代表不需要重新上传资源
m = MyExcelUtil(exlPath)
listDir = list_dir(path)
for d in listDir:
zip_dir(d)
dir = path + "\\"
time = 0
for j in range(0, 6):
for i in range(1, m.get_row_num(j)):
if m.get_rowCol_data(i, 8, j).upper() == "Y":
zipDir = dir + m.get_rowCol_data(i, 7, j) + "\\" + m.get_rowCol_data(i, 2, j) + ".zip"
print zipDir
if os.path.exists(zipDir):
# print zipDir
if m.get_rowCol_data(i, 7, j).lower() == "title":
resource_type = 1
elif m.get_rowCol_data(i, 7, j).lower() == "transition":
resource_type = 2
elif m.get_rowCol_data(i, 7, j).lower() == "filter":
resource_type = 3
elif m.get_rowCol_data(i, 7, j).lower() == "overlay":
resource_type = 4
elif m.get_rowCol_data(i, 7, j).lower() == "audio":
resource_type = 6
elif m.get_rowCol_data(i, 7, j).lower() == "element":
resource_type = 7
try:
if e == 1:
if "Filmora" in exlPath:
resUrl = reqApi.post_files(zipDir, 2)
print resUrl
else:
resUrl = reqApi.post_shenCut_files(zipDir)
print resUrl
else:
resUrl = ""
print "资源不用上传"
if "Filmora" in exlPath:
resText = reqApi.post_ResourceEdit(m.get_rowCol_data(i, 6, j), resUrl,
m.get_rowCol_data(i, 3, j),
m.get_rowCol_data(i, 4, j), m.get_rowCol_data(i, 5, j),
resource_type, "store Edit")
else:
import time as t
if time > 0:
t.sleep(120)
resText = reqApi.post_shenCutEdit(m.get_rowCol_data(i, 6, j), resUrl,
m.get_rowCol_data(i, 3, j),
m.get_rowCol_data(i, 4, j), m.get_rowCol_data(i, 5, j),
resource_type, "shencut store Edit")
if resText.find(u"操作成功") >= 0:
time = time + 1
print("操作成功 " + str(time))
MyExcelUtil(exlPath).write_rowNum_data(i, 8,
MyExcelUtil.set_style(3),
j, "N", "PASS")
else:
print("操作失败")
MyExcelUtil(exlPath).write_data(i, 9, "FAIL",
MyExcelUtil.set_style(2),
j)
except Exception as err:
print err
MyExcelUtil(exlPath).write_data(i, 9, "FAIL",
MyExcelUtil.set_style(2),
j)