fee_calculations_in_c-lightning.sh

# starting from `listtransactions` the script collects the inputs and
# the output amounts to calculate the fees.
# the inputs are collected with a SQL statement inside outputs table.

lightning-cli listtransactions| jq -c '.transactions[]' | while read object
    do export hash=$(jq '.hash'<<<$object) 
    export inputs=$(jq '.inputs'<<<$object)  
    export outputs=$(jq '[.outputs[]]'<<<$object)
    export satoshis=$(jq '[.[].satoshis[0:-4] |tonumber / 1000]| add' <<< $outputs)
    export block=$(jq '.blockheight' <<< $object)
    export new_total=0
    export totals=$(jq -c '.[]' <<<$inputs|while read input
        do export input_hash=$(jq -r '.txid' <<< $input)
        export new_input_hash=$(printf %s "$input_hash" | dd conv=swab 2> /dev/null | rev)
        export index=$(jq '.index' <<< $input)
        export new_total_query="select sum(value) from outputs where prev_out_tx =$(echo \'\\x$new_input_hash\') and prev_out_index = $(jq '.index' <<< $input)"
        export new_total=$(psql -U postgres --host=localhost --port=5432 "dbname=lightningd" -q -t -c "$new_total_query")
        echo $new_total
    done)
    export total=$(echo $totals |jq -s '. | add')
    echo $block,$hash, $total, $satoshis
done