Forum

stat chemin/vers/image

touch -a chemin/vers/image
stat chemin/vers/image

cat /etc/fstab

man mount

#!/bin/bash
 
yesterday=`date -d 'yesterday 13:00' '+%Y-%m-%d'`
sizeArray=( sq th me la xl xx )
 
# 1
for path_to_image in `mysql --user='uuu' --password='***' --database='piwigo' -sN --execute="SELECT pwg_images.path FROM pwg_images LEFT JOIN pwg_history ON pwg_images.id = pwg_history.image_id WHERE  '$yesterday' <= pwg_history.date GROUP BY image_id;"` ; do
    for suffix in "${sizeArray[@]}" ; do
        path_to_image_suffixed=`echo "$path_to_image" | sed -e "s/\.jpg/-$suffix.jpg/"`
        touch -a -c -d $yesterday "/path/to/piwigo/cache/dir/$path_to_image_suffixed" ;
    done;
done ;
 
# 2
for useless_image in `find '/path/to/piwigo/cache/dir/' -name '*.jpg' -type f -atime +370` ; do 
    rm -f "$useless_image" ; 
done ;
 

source ~/credentials.bash
...
mysql --user=${db_user} --password="${db_pass}"
 

export db_user='uuu'
export db_pass='****'
 

#!/bin/bash
source ~/credentials.bash
# past_day=$(date --iso -d '1 year ago 1 month ago')
past_day=$(date --iso -d '370 days ago')
# 1 / 1
for path_to_image in `mysql --user="${db_user}" --password="${db_password}" --database='piwigo' -sN --execute="SELECT pwg_images.path FROM pwg_images LEFT JOIN pwg_history ON pwg_images.id = pwg_history.image_id WHERE  pwg_history.date < '$past_day' GROUP BY image_id;"` ; do
    find "path_to_piwigo_image_cache_dir" -name "${path_to_image%\.*}"'*' -delete
done ;

while IFS=' ' read -r path    date    time ; do
    echo "${time} - ${date} - ${path}"
done < $(mysql -sN --execute="SELECT ... ;")

mysql --user="${db_user}" --password="${db_password}" --database="piwigo" -sN --execute="SELECT path, date, time FROM pwg_images INNER JOIN ( SELECT temp1.image_id, temp1.date, MAX(time) AS time FROM pwg_history INNER JOIN ( SELECT image_id, MAX(date) as date FROM pwg_history WHERE SUBDATE(CURDATE(), INTERVAL 1 DAY) <= date GROUP BY image_id ) AS temp1 ON pwg_history.image_id = temp1.image_id AND pwg_history.date = temp1.date GROUP BY image_id, date ) AS temp2 ON pwg_images.id = temp2.image_id ;" | while    read    path date time ; do
    for suffix in "${sizeArray[@]}" ; do
        touch -a -c -d ${date}'T'${time} "${path_to_piwigo_image_cache_dir}/${path_to_image%\.*}-${suffix}.jpg" ;
    done;
done

#!/bin/bash
 
content=\
"+-----------------------------------------+------------+----------+
| path                                    | date       | time     |
+-----------------------------------------+------------+----------+
| ./galleries/subdir/picture0958.jpg      | 2023-03-20 | 08:35:46 |
| ./galleries/subdir/nom a la con.jpg     | 2023-03-20 | 08:35:46 |
| ./galleries/subdir/j'te jure.jpg        | 2023-03-20 | 08:35:46 |
+-----------------------------------------+------------+----------+"
 
real_content="$(echo "${content}" | sed -e '1,3d;/^+/d;s/[[:space:]]*|[[:space:]]*/|/g')"
 
IFS=$'\n'
for line in $(echo "${real_content}") ; do
    segmented_line=( $(echo "${line}" | sed -e 's/|/\n/g') )
    echo "Voici un fichier : -->${segmented_line[0]}<-- dernier accès le ${segmented_line[1]} à ${segmented_line[2]}"
done
 

real_content="$(echo "${content}" | sed -e '/^+/d;s/[[:space:]]*|[[:space:]]*/|/g;s/^|//g;s/|$//g')"
echo "${real_content}" | awk 'BEGIN {FS = "|"; printf("%40s %15s %-8s\n","path","date","time")}NR>1{printf("%40s %15s %-8s\n",$1,$2,$3)}'
 

mysql --user="${db_user}" --password="${db_password}" --database="piwigo" --execute="SELECT path, date, time FROM pwg_images INNER JOIN ( SELECT temp1.image_id, temp1.date, MAX(time) AS time FROM pwg_history INNER JOIN ( SELECT image_id, MAX(date) as date FROM pwg_history WHERE '2023-03-19' <= date GROUP BY image_id ) AS temp1 ON pwg_history.image_id = temp1.image_id AND pwg_history.date = temp1.date GROUP BY image_id, date ) AS temp2 ON pwg_images.id = temp2.image_id ;" | awk 'BEGIN{printf("%90s %10s %-8s\n","path","date","time")}NR>1{printf("%90s %s %s\n",$1,$2,$3)}'
mysql --user="${db_user}" --password="${db_password}" --database="piwigo" --execute="SELECT path, date, time FROM pwg_images INNER JOIN ( SELECT temp1.image_id, temp1.date, MAX(time) AS time FROM pwg_history INNER JOIN ( SELECT image_id, MAX(date) as date FROM pwg_history WHERE '2023-03-19' <= date GROUP BY image_id ) AS temp1 ON pwg_history.image_id = temp1.image_id AND pwg_history.date = temp1.date GROUP BY image_id, date ) AS temp2 ON pwg_images.id = temp2.image_id ;" | while read path    date    time ; do echo ${time} ${date} ${path} ; done