#!/bin/bash


auto=0


dir="test"


user="user"
pass="fuck"
databse="nfodb"


for name in $( find $dir -iname "*.nfo") ; do
        echo "adding $name ..."
        file="$name"

        release_name=$( dirname $file | sed -e "s/$dir\///g")
        file_name=$(basename $file)
        file_size=$(du -b $file)
        file_size=$(echo $file_size | cut -d " " -f 1)
        file_raw=$(cat $file)

        echo "rel: $release_name"
        echo "file: $file_name"
        echo "size: $file_size"
        echo "raw: $file_raw"

        if [ "$auto" = "1" ] ; then
                echo ""
        else
                read y

        fi

        echo "mysql ..."
        #mysql  i

mysql -u $user -p$pass $database << EOF
                INSERT INTO nfodb (rlsname,filename,rawnfo,size) VALUES ( '$release_name' , '$file_name' , '$file_raw' , '$file_size' );
EOF


echo "... done"

done