I'm trying to get all the .sql files from my project and change the extension to .md .
I've already been able to do this, however, the files are being moved to the root of the system, which is the path where the shell script is. How to rename keeping the original file in the same directory?
#!/bin/bash
shopt -s globstar
for file in ./**/*.sql; do
mv "$file" "$(basename "$file" .sql).md"
done
You could probably use $(dirname $file) to get the folder path of the current file in the loop
for file in ./**/*.sql; do
mv "$file" "$(dirname "$file")/$(basename "$file" .sql).md"
done
The problem is that basename takes the information out of the folder and returns only the file name. So the idea is not to use it, so this information is not lost.
To manipulate the filename, you can use the ${var%pattern} syntax, remove pattern from the value of var :
for file in ./**/*.sql; do
mv $file "${file%.sql}.md"
done
${file%.sql} removes the ".sql" strand from the file name and then .md adds this string to the name. That is, the extension is changed from .sql to .md .