查找目录中的所有.sql文件并使用sqlcmd执行它们

import os

def find_sql_files(directory):
    sql_files = []
    for root, dirs, files in os.walk(directory):
        for file in files:
            if file.endswith(".sql"):
                sql_files.append(os.path.join(root, file))
    return sql_files

directory = "/path/to/directory"
sql_files = find_sql_files(directory)

sqlcmd -S <server_name> -d <database_name> -U <username> -P <password> -i <sql_file>

import os

def find_sql_files(directory):
    sql_files = []
    for root, dirs, files in os.walk(directory):
        for file in files:
            if file.endswith(".sql"):
                sql_files.append(os.path.join(root, file))
    return sql_files

def execute_sql_files(sql_files):
    for sql_file in sql_files:
        command = f"sqlcmd -S <server_name> -d <database_name> -U <username> -P <password> -i {sql_file}"
        os.system(command)

directory = "/path/to/directory"
sql_files = find_sql_files(directory)
execute_sql_files(sql_files)