# MONGO DB COPY
from sshtunnel import SSHTunnelForwarder
import pymongo
from pymongo import MongoClient

## TO CHANGE
REMOTE_HOST = "12.12.12.12"
REMOTE_USER = "username"
REMOTE_USER_PASS = "password"
## TO CHANGE


server = SSHTunnelForwarder(
    REMOTE_HOST,
    ssh_username=REMOTE_USER,
    ssh_password=REMOTE_USER_PASS,
    remote_bind_address=('127.0.0.1', 27017)
)

server.start()
print(server.local_bind_address)
client = pymongo.MongoClient('127.0.0.1', 27017) # server.local_bind_port is assigned local port
client.admin.command('copydb', fromhost='127.0.0.1:'+str(server.local_bind_port), fromdb='data_sources', todb='l_data_sources')

server.stop()

print("hi")