#!/bin/bash

config=/home/cobra/bin/dbscraper.ini
dbscraper.pl --config=$config --interactive --verbose --debug

path=$(grep path $config | awk '{split($0, a, "="); print a[2]}')
file=$(grep csvfile $config | awk '{split($0, a, "="); print a[2]}')
full_transactions=$path/$file
short_transactions=/home/cobra/banking/balance.dat

sed 's/EUR//g' $full_transactions | awk '{ print $1, $NF }' > $short_transactions

date=$(sed q $short_transactions |  awk '{print $1}')
amount=$(sed q $short_transactions |  awk '{print $2}')
#set the following number (123...) to match the actual one ;)
corrected=$(bc <<< "123456789 + $amount")
sed "/$date/{s/$amount/$corrected/}" -i $short_transactions

gnuplot balance.plt