Python 实现两个服务器之间文件的上传方法

如下所示：

# 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()

来源：https://blog.csdn.net/lzbhnr/article/details/78499427