连接oracle数据库，执行ssh命令，然后把查询结果反写数据库-批量处理管理测试设备

#-*- coding: utf-8 -*-
#!/usr/bin/python


import cx_Oracle
import paramiko
import threading
import sys
reload(sys)
sys.setdefaultencoding('utf-8')


cmdStr = ['cat /proc/meminfo |grep MemTotal ','dmidecode | grep "Product Name" | grep -v "filled"','fdisk -l |grep Disk | grep -v identifier']#你要执行的命令列表


def test(ip,username,passwd,cmd):
    try:
        ssh = paramiko.SSHClient()
        ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
        ssh.connect(ip,22,'root','iptvtest',timeout=5)
        strResult = ""
        for com in cmd:
            #print com
            stdin, stdout, stderr = ssh.exec_command(com)
            out = stdout.readlines()
            #print out