Extract timestamps for files in a folder and compare them against date field in Database

Question

I have written a script which will run periodically. The program will rename a given file based on complex logic and move it to another folder.

This script would be run by an Oracle Concurrent program who's last run date can be extracted from a database table.

The issue is to extract the file creation date for the file currently in the loop and compare it with last run date of Concurrent Program and only perform actions if the file was created after last run timestamp of the concurrent program.

I have also given code for my shell script for better understanding : https://pastebin.com/6P52BYP3

I'm facing issues in extracting creation timestamp for a given file and comparing it with last run date of program.

Thanks, Shubham

John C · Answer 1 · 2017-04-05T07:39:13.523

0

You can extract the creation time with the stat command.

Eg on OSX:

$ stat -f "%B" a_file
1491371944

%B is time in seconds since epoch when the inode was born.

Some versions of stat would work like this:

# stat --format=%Z file
1491073904

%Z is time of last change in seconds since Epoch.

I can't see a creation date option on solaris.

edited Apr 05 '17 at 07:39

answered Apr 05 '17 at 07:06

John C

4,276
2
17
28

Thanks, but -s doesn't seem to be a valid operator for stat command. – Shubham Gupta Apr 05 '17 at 07:14
Try looking at the man page for stat. You obviously have a slightly different implementation. – John C Apr 05 '17 at 07:16
Thanks, I have posted the solution to the question. – Shubham Gupta Apr 06 '17 at 05:17

score 0 · Answer 2 · edited Apr 06 '17 at 08:36

This is how I achieved the solution :

l_file_date=stat -c %y $l_fileinput | cut -d'.' -f1

l_program_date=sqlplus -s $FCP_LOGIN <<EOF
    set pagesize 0;
    SELECT *
        FROM (  SELECT TO_CHAR (fcr.request_date, 'yyyy-mm-dd hh24:mi:ss')
                FROM fnd_concurrent_requests fcr, fnd_concurrent_programs fcpt
                WHERE     fcpt.concurrent_program_id = fcr.concurrent_program_id
                        AND fcpt.concurrent_program_name = 'XXEFTFILENAMECHANGE'
                        AND fcr.phase_code = 'C'
                        AND fcr.status_code = 'C'
            ORDER BY request_date DESC)
        WHERE ROWNUM = 1;
    EXIT;
EOF

l_file_date_u=$(date -d "$l_file_date" "+%s")

l_program_date_u=$(date -d "$l_program_date" "+%s")

if expr "$l_file_date_u" ">=" "$l_program_date_u" > /dev/null; then

<CODE>

fi

Extract timestamps for files in a folder and compare them against date field in Database

2 Answers2