#!/bin/bash
USER='radio'
SERVER=""
LOCATION="kampala"
HOSTNAME=`hostname`
PATH_TO_FREQS_FILE_FOLDER=""
PATH_TO_FREQS_FILE_FOLDER_BKUP=""
COUNTRY="uganda"

if [ $# -lt 5 ]
then
	echo "Radio Frequency Configurator"
	echo "Illegal number of parameters passed. $# files recieved"
	echo "arg 1: MySQL server address"
	echo "arg 2: Path to frequency files folder"
	echo "arg 3: Path to frequency files backup folder"
	echo "arg 4: Recording country name"
	echo "arg 5: Recording location"
	echo "Using defaults"
else
	SERVER=$1
	PATH_TO_FREQS_FILE_FOLDER=$2
	PATH_TO_FREQS_FILE_FOLDER_BKUP=$3
	COUNTRY=$4
	LOCATION=$5
fi

QUERY="select b.frequency_id, b.freq_filename, b.frequency, b.freq_offset, b.is_center_freq \
	   from recording_locations a, frequency_configs b \
	   where a.location_id=b.recording_locations_id \
	   and a.country_name='"$COUNTRY"' \
	   and a.location_name='"$LOCATION"' \
	   and b.is_active='1' \
	   and b.device_hostname='"$HOSTNAME"'"
	   #and b.device_hostname='kampala-02'"
	   
#echo $QUERY
	   
FILE_COUNT=`ls $PATH_TO_FREQS_FILE_FOLDER | wc -l`
if [ $FILE_COUNT -gt 0 ]
then
	rm /home/radio/radio/new_scripts/freq_files/*.txt
	mv $PATH_TO_FREQS_FILE_FOLDER* $PATH_TO_FREQS_FILE_FOLDER_BKUP
fi


EXIT_CODE=`expr $?`
if [ $EXIT_CODE -eq 0 ]
then
	ROW_COUNT=0
	#echo "">"/home/radio/radio/new_scripts/freq_files/"$freq_filename".txt"
	while read frequency_id freq_filename frequency freq_offset is_center_freq
	do
		if [ $ROW_COUNT == 0 ]
		then
			ROW_COUNT=$((ROW_COUNT + 1))
			continue
		fi
		echo "Appending "$frequency"|"$freq_offset"|"$is_center_freq"|"$frequency_id" to "$PATH_TO_FREQS_FILE_FOLDER$freq_filename
		echo $frequency"|"$freq_offset"|"$is_center_freq>>$PATH_TO_FREQS_FILE_FOLDER$freq_filename
		m_freq=$(echo $frequency | cut -d'e' -f1)
		m_offset=$(echo $freq_offset | cut -d'e' -f1)
		true_freq=$(echo ${m_freq} + ${m_offset} | bc)
		echo "mapping==>" $frequency"|"$true_freq"|"$frequency_id
		echo $frequency"|"$true_freq"|"$frequency_id>>"/home/radio/radio/new_scripts/freq_files/"$freq_filename".txt"
		#echo "${freq_filename} : ${frequency} : ${freq_offset}"
	done < <(echo "$QUERY" | mysql -u $USER -h $SERVER radio)
	#(echo "SELECT A, B, C FROM table_a" | mysql database -u $user -p $password)
else
	echo "Frequency files backup failed"
fi

EXIT_CODE=`expr $?`
if [ $EXIT_CODE -eq 0 ]
then
	FILE_COUNT=`ls $PATH_TO_FREQS_FILE_FOLDER | wc -l`
	if [ $FILE_COUNT -gt 0 ]
	then
		rm $PATH_TO_FREQS_FILE_FOLDER_BKUP*
	else
		FILE_COUNT=`ls $PATH_TO_FREQS_FILE_FOLDER_BKUP | wc -l`
		if [ $FILE_COUNT -gt 0 ]
		then
			mv $PATH_TO_FREQS_FILE_FOLDER_BKUP* $PATH_TO_FREQS_FILE_FOLDER
		fi
	fi
fi