Ton Kersten

#!/bin/bash

DIRS="git.vi header makebackup mysqlbackup"

# Top of the development tree
cd ~/develop

# Process all the download directories
for dir in ${DIRS}
do
    cd ${dir}

    # First install everything
    # The Make file also installs in the blogs download dir
    echo "Processing ${dir}"
    make install
    git push

    # Process all files
    for f in *
    do
        # Get the revision number, date and size
        rev="$(grep '^# $Revision::' $f | awk '{print $3 }'"
        dt="$(stat -c '%y' $f | cut -d '.' -f1)"
        sz="$(stat -c '%s' $f)"

        # Create a MySQL update string
        cat <<- @EOF
            #
            # Update the revision
            #
            update wp_download_monitor_files
            set dlversion='${rev}'
            where filename='/var/www/blog/downloads/${dir}/${f}';

            #
            # Update the file date
            #
            update wp_download_monitor_files
            set postDate='${dt}'
            where filename='/var/www/blog/downloads/${dir}/${f}';

            #
            # Update the file size
            #
            update
                wp_download_monitor_file_meta  m,
                wp_download_monitor_files      f
                set m.meta_value = '${sz}'
                where (
                    m.download_id = f.id
                )
                    and (
                    m.meta_name = 'filesize'
                )
                and (
                    f.filename = '/var/www/blog/downloads/${dir}/${f}'
                );
        @EOF
    done
    cd ..
done | mysql -u root -p blogdb