import datetime
import pandas as pd
import pymysql
from sqlalchemy import create_engine
from sshtunnel import SSHTunnelForwarder
from log_config.record_log import RecordLog
log = RecordLog()
class QuerySql:
def __init__(self, host, port, user, pwd, db):
self.host = host
self.port = port
self.user = user
self.pwd = pwd
self.db = db
self.tunnel = None
# 数据库连接配置,host默认127.0.0.1不用修改
self.conn = None
self.cursor = None
def query_sql_df(self, sql=""):
# 跳板机SSH连接
start = datetime.datetime.now()
log.log_debug("-------------跳板机SSH连接%s的%s库"%(self.host,self.db))
try:
with SSHTunnelForwarder(
('跳板机地址', 22),
ssh_username="xxxxxx",
ssh_pkey="C:/Users/Carry/.ssh/id_rsa", # 本机的公钥路径
remote_bind_address=(self.h