The script needs:
1 - Check a folder and verify if the SOURCE file is newer
2 - If the SOURCE file is the same, just send an email. If it is newer, the flow will be:
3 - read the file and extract the numbers from the file. These numbers will build a MYSQL REPLACE command into a pinsets table.
The source file has these informations:
I will need a MYSQL STRING like this:
REPLACE into pinsets VALUES ('1','000111\n233901\n234567','pinsetname-2','1','');
So, the script needs to analyse the SOURCE FILE, create a MYSQL REPLACE (and run it!), or, if the source file has not change... just send an email.
We will discard all other informations about the SOURCE file. The first number sequence, and the text after the second number sequence. I really need the SECOND number sequence.
And, in MYSQL REPLACE, the numbers need to have \n between all of them because they will be in the same cell.
The source file has around 900 thousand lines.
I want to run this script for all time with one hour intervals (cron), ok!?
Hello Sir, We read that you need a bash script but the description of project seems to require a most complex script (like in python). It is necessary that all the part that you described is implemented by bash?