summaryrefslogtreecommitdiff
path: root/src/auditor/test-sync.sh
blob: 3ab6fa1e40c164d44fe4edcab7a225c44e166d9e (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
43
#!/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

# cs_nonce_locks excluded: no point
for table in denominations denomination_revocations wire_targets reserves reserves_in reserves_close reserves_out auditors auditor_denom_sigs exchange_sign_keys signkey_revocations extensions extension_details 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 exchange.$table" | psql talercheck-in -Aqt`
    COUT=`echo "SELECT COUNT(*) FROM exchange.$table" | psql talercheck-out -Aqt`

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

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

echo "PASS"
exit 0