python--ssh连接oracle数据库进行操作

一、ssh连接封装

使用python进行ssh远程连接时，需导入paramiko模块
可支持连接、关闭连接、上传、下载、运行命令等操作

import paramiko

class SSHConnection(object):
    def __init__(self, host, port, username, password):
        self._host = host
        self._port = port
        self._username = username
        self._password = password
        self._transport = None
        self._sftp = None
        self._client = None
        self._connect()

    def _connect(self):
        transport = paramiko.Transport((self._host, self._port))
        transport.connect(username=self._username, password=self._password)
        self._transport = transport

    # 下载
    def download(self, remotepath, localpath):
        if self._sftp is None:
            self._sftp = paramiko.SFTPClient.from_transport(self._transport)
        self._sftp.get(remotepath, localpath)
 
    # 上传
    def put(self, localpath, remotepath):
        if self._sftp is None:
            self._sftp = paramiko.SFTPClient.from_transport(self._transport)
        self._sftp.put(localpath, remotepath)

    # 执行命令
    def run(self, command):
        if self._client is None:
            self._client = paramiko.SSHClient()
            self._client._transport = self._transport
        stdin, stdout, stderr = self._client.exec_command(command)
        out_data = stdout.read().decode('utf-8').strip()
        returncode = stdout.channel.recv_exit_status()
        if len(out_data) > 0:
            return out_data
        err_data = stderr.read().decode('utf-8').strip()
        if len(err_data) > 0:
            return err_data
        return returncode

    def close(self):
        if self._transport:
            self._transport.close()
        if self._client:
            self._client.close()

二、操作oracle数据库

调用封装连接ssh的对象，即可操作Linux的命令

代码如下（示例）：

def rm_mkdir():
    host = "192.168.0.1"
    port = 22
    username = "oracle"
    password = "oracle"
    obj = SSHConnection(host, port, username, password)
    print(obj)
    #命令所执行操作：进入oracle,关闭oracle数据库连接;删除目录文件夹
    cmd = "echo 'shutdown immediate' | sqlplus '/as sysdba'; sudo rm -rf /dir/*"
    show = obj.run(cmd)
    return show