if __name__ == "__main__":
excel = ExcelUtil()
# Usage for write function
# logger.info('Startting write...')
# title = (('ID', u'中文', 'DESCRIPTION'))
# data = [(0, u'苹果', u'手机和电脑'), (1, u'微软', 'Opertion System'), (2, 'Lenove', '')]
# data = {'title': title, 'data': data}
# excel.write(filename='c:/Users/Shy/Desktop/w_test.xlsx', data=data, sheet=u'测试', is_overwrite=True)
# logger.info('Wrtie success!')
dest_file = '/mnt/c/Users/shy/OneDrive/migu/对外供数/分省/分省供数账户信息.xlsx'
ip_list = '/home/shy/projects/ip.list'
source = {}
target = {}
# # Usage for read function
logger.info('Startting read...')
data = excel.read(dest_file, sheet=1, columns=[3, 5])
for row in data:
provence_name = row[0]
if (row[1] is None):
continue
ips = row[1]
source[provence_name] = ips
# print(source)
logger.info('Read finish!')
for k, v in source.items():
target[k] = set()
not_founds = []
with open(ip_list, 'r') as f:
if __name__ == "__main__":
def split(lines):
print(lines.split('\n'))
ip = '10.25.150.193'
port = 21
user = '******'
passwd = 'migulog@123'
target = '20190810.tar.gz'
client = FtpClient(ip, port, user, passwd)
while True:
try:
logger.info('Try to login ftp: {}:{} with {} / {}'.format(
ip, port, user, passwd))
client.login()
client.set_debug()
logger.info('Ftp login success.')
# client.list_files('*')
client.set_pasv(True)
logger.info(
'Starting download file: {} using pasv mode.'.format(target))
client.download(target, os.path.join(os.getcwd(), target))
logger.info(
'Downloading file {} success using pasv mode.'.format(target))
client.set_pasv(False)
logger.info(
'Starting download file: {} using port mode.'.format(target))
client.download(target, os.path.join(os.getcwd(), target))