U $ec @sddlZddlZddlZddlZddlZddlmZddlZejddddeZ e ej dZ dZ d Zd Zd Zd Zd Zd dZddZddZedS)N)SSHTunnelForwarderzconnection.logz%(asctime)s %(message)sw)filenameformatfilemodez 210.56.21.197ZdevuserZ ubuntuhasrootZ smarthome_db 127.0.0.1c CsTz tjdtttdatdWn.tk rN}zt d|W5d}~XYnXdS)z|Connect to a MySQL server using the SSH tunnel connection :return connection: Global MySQL database connection r)hostuserpasswddbzmysql connected successfulyzError while connecting to MySQLN) pymysqlconnectdatabase_usernamedatabase_password database_name connectionloggerdebug BaseExceptionerror)er%/var/www/html/flasktest/connection.py mysql_connect*srcCs t|tS)N)pdZread_sql_queryr)Zsqlrrr run_query?srcCs tdS)z*Closes the MySQL database connection. N)rcloserrrrmysql_disconnectBsr)Zpandasrtimer loggingZ sshtunnelr basicConfig getLoggerrsetLevelDEBUGZssh_hostZ ssh_usernameZ ssh_passwordrrr localhostrrrrrrrs,