From Mysql query output to retrieve files in the file system and rename the files

Question

I have to call a SQL query from bash that outputs 1000 rows of two columns

1. File_Path (Eg., /opt/files/dest/2.bin)
2. Name_of_the_file (Eg., fax attachment.pdf, invoice.docx... yes, there are spaces).

The file name in the server file system is in different naming format eg: 1.bin, 22.bin. There are <1000 unique files exactly as some are missing.

Here is the Snapshot of the SQL query:

Select * from datafileinfo limit 4; 

Output:

FILEID,NAME 
/ran/file/MM/2012/04/3.bin,new_fax.pdf
/ran/file/MM/2013/06/12.bin,new_report.docx
/ran/file/MISC/2012/08/212.bin,daily_transact.jrxml
/ran/file/MONY/2013/04/122.bin,NULL

As a first step, I gathered all those files and put it in a temporary folder.

But I couldn't able to rename the files as I have to lookup the 'Name of the file' with corresponding 'File Path'. Is there any way I can perform the job?

Answer 1

1. Change IFS separator to ","
2. Iterate while loop over mysql query result
3. Extract dir from old path
4. Perform renaming

The code will be something like:

#!/bin/bash
IFS=','
mysql ...executequery... | while read oldpath newfname
do
  filedir=$(dirname $oldpath)
  mv "$oldpath" "$filedir/$newfname"
done

You didn't mention what to do with NULL query results.