date_to_timestamp.py

import os
import re

# 获取当前工作目录
directory = os.getcwd()

# 遍历目录及其所有子目录下的所有文件
for dirpath, dirnames, filenames in os.walk(directory):
    for filename in filenames:
        # 只处理.sql文件
        if filename.endswith('.sql'):
            filepath = os.path.join(dirpath, filename)

            # 读取文件内容
            with open(filepath, 'r') as file:
                filedata = file.read()

            # 使用正则表达式替换日期，忽略大小写
            filedata = re.sub(r"DATE\s+'([^']*)'", r"TIMESTAMP '\1'", filedata, flags=re.IGNORECASE)

            # 将修改后的内容写回文件
            with open(filepath, 'w') as file:
                file.write(filedata)