24 lines
668 B
Bash
24 lines
668 B
Bash
|
#!/bin/bash
|
|||
|
|
# 用于将IDEA导出的不同表sql文件，整合成一份
|
|||
|
|
|
|||
|
|
# Get the current date in the format yyyymmdd
|
|||
|
|
current_date=$(date +%Y%m%d)
|
|||
|
|
|
|||
|
|
# Create the new file name
|
|||
|
|
new_file="agileboot-${current_date}.sql"
|
|||
|
|
|
|||
|
|
# Check if the new file already exists
|
|||
|
|
if [[ -f "$new_file" ]]; then
|
|||
|
|
# Remove the existing file
|
|||
|
|
rm "$new_file"
|
|||
|
|
fi
|
|||
|
|
|
|||
|
|
# Loop through all .sql files in the current directory
|
|||
|
|
for file in *.sql
|
|||
|
|
do
|
|||
|
|
# Replace '`agileboot`.' with an empty string and append the contents to the new file with a blank line after
|
|||
|
|
sed "s/\`agileboot-pure\`\./ /g" "$file" >> "$new_file"
|
|||
|
|
echo "" >> "$new_file"
|
|||
|
|
done
|
|||
|
|
|
|||
|
|
echo "Concatenation complete. Output file: $new_file"
|