Python sql_execute_by_file Beispiele

Beispiel #1

Datei: master.py Projekt: rui-machado/dev

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) 

Beispiel #2

Datei: executing_sql_by_file.py Projekt: rui-machado/dev

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