Kapalı

Bash script Linux CentOS -- 2

Bu proje 35$ USD karşılığında arrowsoftSrls adlı kullanıcıya verildi.

Bunun gibi bir proje için ücretsiz teklifler alın
Proje Bütçesi
$10 - $30 USD
Toplam Teklif
13
Proje Açıklaması

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:

0123=000111=BLABLABALABLA=A

0987=233901=TTTTTTTAAA=A

8765=234567=YYYYYAKAA=A

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!?

Seçilen:

Biraz para kazanmak mı istiyorsunuz?

  • Bütçe ve zaman çerçevenizi belirleyin
  • Teklifinizin anahatlarını verin
  • Çalışmanız için ödeme alın

Bu projeye de teklif veren Freelancerları işe alın

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online