summaryrefslogtreecommitdiff
path: root/src/auditor/test-sync.sh
blob: 156df9cc1b955fcd94ab77d7f26deae9eec89f03 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
#!/bin/sh

set -eu

echo -n "Testing synchronization logic ..."

dropdb talercheck-in 2> /dev/null || true
dropdb talercheck-out 2> /dev/null || true

createdb talercheck-in || exit 77
createdb talercheck-out || exit 77
echo -n "."

taler-exchange-dbinit -c test-sync-out.conf
echo -n "."
psql talercheck-in < auditor-basedb.sql >/dev/null 2> /dev/null

echo -n "."
taler-auditor-sync -s test-sync-in.conf -d test-sync-out.conf -t

for table in denominations denomination_revocations reserves reserves_in reserves_close reserves_out auditors auditor_denom_sigs exchange_sign_keys signkey_revocations known_coins refresh_commitments refresh_revealed_coins refresh_transfer_keys deposits refunds wire_out aggregation_tracking wire_fee recoup recoup_refresh
do
    echo -n "."
    CIN=`echo "SELECT COUNT(*) FROM $table" | psql talercheck-in -Aqt`
    COUT=`echo "SELECT COUNT(*) FROM $table" | psql talercheck-out -Aqt`

    if test ${CIN} != ${COUT}
    then
        dropdb talercheck-in
        dropdb talercheck-out
        echo "FAIL"
        echo "Record count missmatch: $CIN / $COUT in table $table"
        exit 1
    fi
done

echo -n ". "
dropdb talercheck-in
dropdb talercheck-out

echo "PASS"
exit 0