def etl_process_pre(path): scripts = fs.get_folder_files(path) for sc in scripts: print mysql.sql_execute_by_file(config.SRC_CONNECTION_STRING,sc,False)
import Helpers.hp_pandas as pd import Helpers.hp_mysql as mysql import math CONNECTION_STRING = "DRIVER={SQL Server};SERVER=10.0.0.170;DATABASE=SSISDB;Trusted_Connection=yes;" 'Execute mysql get data' data_set_result = mysql.sql_execute_by_file(CONNECTION_STRING,"./package-kpi.sql",False) print data_set_result