import paramiko
import time

ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
privkey = paramiko.RSAKey.from_private_key_file('/home/edynson/.ssh/2019_cloud.pem')
ssh.connect('18.204.229.140', username='ubuntu', pkey=privkey)
# stdin, stdout, stderr = ssh.exec_command('PGPASSWORD="odoo" pg_dump -U odoo -h localhost -d BD_FE > BD_FE.sql')
ssh.exec_command('PGPASSWORD="odoo" pg_dump -U odoo -h localhost -d BD_FE > BD_FE.sql')
print("BACKUP GENERADO")
ssh.exec_command('PGPASSWORD=odoo psql -U odoo -d BD_FE -c "create database company1 with owner odoo;"')
print("BD CREADO EN LOCALHOST")
(stdin, stdout, stderr) = ssh.exec_command('PGPASSWORD=odoo psql -U odoo -h localhost -d company1 < BD_FE.sql')
time.sleep(120)
print("BD REASTUARADA")

# stdin.channel.recv_exit_status()
print(stdout)
for line in stdout:
    print(line)
print("BD RESTAURADA")
"""
stdout.channel.recv_exit_status()
lines = stdout.readlines()

for line in lines:
    print(line)
"""
ssh.close()