# coding: utf-8
import paramiko
import MySQLdb
def main(): connection=MySQLdb.connect(host='10.10.41.22',user='root',passwd='root',db='Trojan',port=3306)
cur=connection.cursor()
sql ='select count(*) from blacklist;'
cur.execute(sql)
count = cur.fetchone()[0]
print '一共有%s个应用需要上传'%(count)
sql = 'select path from blacklist;'
cur.execute(sql)
host = '10.10.41.22'
port = 22
username = 'remote2'
password = 'userforremote'
t = paramiko.Transport((host,port))
t.connect(username=username,password=password)
sftp = paramiko.SFTPClient.from_transport(t)
i=0
for path in cur.fetchall():
bendiPath = "/home/wcloud/apk_baseinfo_mounted_point/apk%s"%path
apkName =bendiPath.split("/")[-1]
servicePath = '/home/remote2/blacklist_wandoujia/%s'%apkName
print bendiPath
print servicePath
sftp.put(bendiPath,servicePath)
i=i+1
print '已经上传%s个应用,还有%d个应用没有上传'%(i,(count-i))
if __name__ == '__main__':
main()
Python如何实现两个服务器之间文件的上传
最新推荐文章于 2024-04-25 10:41:50 发布