[root@data table]# ls
20230717  20230725  20230802  20230810  20230818  20230826  20230903  20230911  20230919  20230927  20231005  20231013  20231021  20231029  20231106
20230718  20230726  20230803  20230811  20230819  20230827  20230904  20230912  20230920  20230928  20231006  20231014  20231022  20231030  20231107
20230719  20230727  20230804  20230812  20230820  20230828  20230905  20230913  20230921  20230929  20231007  20231015  20231023  20231031  20231108
20230720  20230728  20230805  20230813  20230821  20230829  20230906  20230914  20230922  20230930  20231008  20231016  20231024  20231101  20231109
20230721  20230729  20230806  20230814  20230822  20230830  20230907  20230915  20230923  20231001  20231009  20231017  20231025  20231102  20231110
20230722  20230730  20230807  20230815  20230823  20230831  20230908  20230916  20230924  20231002  20231010  20231018  20231026  20231103  20231111

#!/bin/bash

# 指定根目录路径
root_directory="/data/table"

# 遍历根目录下的目录
for directory in "$root_directory"/*/
do
    if [[ -d "$directory" ]]; then
        # 进入目录
        cd "$directory"

        # 获取当前目录路径
        current_path=$(pwd)

        # 获取当前目录名称
        current_directory=$(basename "$current_path")

        # 扫描目录下的文件并生成 SQL 输出
        cat table* | awk -F "," '{print $4" "$10" "int($46/1000)}' | sort -k 3 -n | awk '{print "("$1","$2","$3"),"}' > "/data/table/$current_directory.sql"

        echo "在目录 $directory 中生成 $current_directory.sql"

        # 返回上一级目录
        cd ..
    fi
done