mark下读写操作函数,省的下次再写
#!/usr/bin/env python
# -*- coding: utf-8 -*-
'''
@File : test.py.py
@Author: Piepis
@Date : 2020/8/27 18:13
@Desc :
'''
import os
import re
# write "data" to file-filename
def writeFile(filename, data,zhuijia=False):
(Path, Name) = os.path.split(filename)
if ""==Path:
Path =os.getcwd()
else:
if not os.path.exists(Path): # 判断是否存在文件夹如果不存在则创建为文件夹
os.makedirs(Path) # makedirs 创建文件时如果路径不存在会创建这个路径
if zhuijia:
with open(filename, 'a+') as f:
# f.write(data) # 加\n换行显示
f.write(data + '\n') # 加\n换行显示
else:
with open(filename, 'w') as f:
f.write(data + '\n') # 加\n换行显示
with open(os.path.join(Path, "nameList.md"), 'a+') as t:
t.write(Name + '\n')
# read "data" from file-filename
def readFile(filename,lines=False):
if lines:
with open(filename, "r") as f:
result =f.readlines()
else:
with open(filename, "r") as f:
result =f.read()
return result
if __name__ == '__main__':
pattern= re.compile(r'handler.ksh(.*)DUAL')
result = readFile("export.xml")
tt =re.findall(pattern,result,flags=0)
t=[]
print(len(tt))
print(tt)
for i in tt:
if "&" in i:
t.append(i.replace("&","").strip())
print(t)
print(len(t))
tables_new_list = []
for i in t:
if i not in tables_new_list:
tables_new_list.append(i.strip('\n'))
else:
print(i)
result1=readFile("tmp_list.sql",True)
# all_words = list(filter(lambda text: all([word in text for word in result]), result1))
ttt=[]
for ti in result1:
tc=ti.strip('\n').replace("_tmp","")
ttt.append(tables_new_list.index(str(tc)))
print("-----------------------")
print(ttt)
ttttttttt=[]
for i in ttt:
if i not in ttttttttt:
ttttttttt.append(i)
else:
print(i)