Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 1 | #!/bin/sh |
| 2 | srcdir="${1:-.}" |
| 3 | builddir="${2:-.}" |
| 4 | do_equivalence_test="$3" |
| 5 | |
| 6 | set -e |
| 7 | |
| 8 | db="$builddir/test.db" |
| 9 | osmo_hlr="$builddir/../../src/osmo-hlr" |
| 10 | cfg="$srcdir/osmo-hlr.cfg" |
| 11 | |
| 12 | dump_sorted_schema(){ |
| 13 | db_file="$1" |
Neels Hofmeyr | 7143f3a | 2019-11-11 00:09:16 +0100 | [diff] [blame] | 14 | tables="$(sqlite3 -batch -noheader "$db_file" "SELECT name FROM sqlite_master WHERE type = 'table' order by name")" |
Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 15 | for table in $tables; do |
| 16 | echo |
| 17 | echo "Table: $table" |
Neels Hofmeyr | 7143f3a | 2019-11-11 00:09:16 +0100 | [diff] [blame] | 18 | sqlite3 -batch -header "$db_file" "SELECT name,type,\"notnull\",dflt_value,pk FROM PRAGMA_TABLE_INFO('$table') order by name;" |
Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 19 | echo |
| 20 | echo "Table $table contents:" |
Neels Hofmeyr | 7143f3a | 2019-11-11 00:09:16 +0100 | [diff] [blame] | 21 | columns="$(sqlite3 -batch -noheader "$db_file" "SELECT name FROM PRAGMA_TABLE_INFO('$table') order by name;")" |
| 22 | sqlite3 -batch -header "$db_file" "SELECT $(echo $columns | sed 's/ /,/g') from $table;" |
Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 23 | done |
| 24 | } |
| 25 | |
| 26 | rm -f "$db" |
| 27 | echo "Creating db in schema version 0" |
Neels Hofmeyr | 7143f3a | 2019-11-11 00:09:16 +0100 | [diff] [blame] | 28 | sqlite3 -batch "$db" < "$srcdir/hlr_db_v0.sql" |
Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 29 | |
| 30 | echo |
| 31 | echo "Version 0 db:" |
| 32 | dump_sorted_schema "$db" |
| 33 | |
| 34 | set +e |
| 35 | |
| 36 | echo |
| 37 | echo "Launching osmo-hlr to upgrade db:" |
| 38 | echo osmo-hlr --database '$db' --db-upgrade --db-check --config-file '$srcdir/osmo-hlr.cfg' |
| 39 | "$osmo_hlr" --database "$db" --db-upgrade --db-check --config-file "$cfg" >log 2>&1 |
| 40 | echo "rc = $?" |
| 41 | cat log | sed 's@[^ "]*/@<PATH>@g' |
| 42 | |
| 43 | echo |
| 44 | echo "Resulting db:" |
| 45 | dump_sorted_schema "$db" |
| 46 | |
| 47 | echo |
| 48 | echo "Verify that osmo-hlr can open it:" |
| 49 | echo osmo-hlr --database '$db' --db-check --config-file '$srcdir/osmo-hlr.cfg' |
| 50 | "$osmo_hlr" --database "$db" --db-check --config-file "$cfg" >log 2>&1 |
| 51 | echo "rc = $?" |
| 52 | cat log | sed 's@[^ "]*/@<PATH>@g' |
| 53 | |
| 54 | if [ -n "$do_equivalence_test" ]; then |
| 55 | # this part requires osmo_interact_vty.py, so this test is not part of the normal run |
| 56 | set -e -x |
| 57 | mint_db="$builddir/mint.db" |
| 58 | rm -f "$mint_db" |
| 59 | |
| 60 | osmo_verify_transcript_vty.py -v \ |
| 61 | -n OsmoHLR -p 4258 \ |
| 62 | -r "$osmo_hlr -c $cfg -l $mint_db" \ |
| 63 | "$srcdir/create_subscribers.vty" |
Neels Hofmeyr | 7143f3a | 2019-11-11 00:09:16 +0100 | [diff] [blame] | 64 | sqlite3 -batch "$mint_db" < "$srcdir/create_subscribers_step2.sql" |
Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 65 | |
| 66 | set +x |
| 67 | test_dump="$builddir/test.dump" |
| 68 | mint_dump="$builddir/mint.dump" |
| 69 | |
| 70 | dump_sorted_schema "$db" > "$test_dump" |
| 71 | dump_sorted_schema "$mint_db" > "$mint_dump" |
| 72 | |
| 73 | echo |
| 74 | echo "Newly created sorted schema is:" |
| 75 | cat "$mint_dump" |
| 76 | echo |
| 77 | echo "Diff to upgraded schema:" |
| 78 | diff -u "$mint_dump" "$test_dump" |
| 79 | echo "rc=$?" |
| 80 | fi |
| 81 | |
| 82 | rm -f log |
| 83 | rm -f "$db" |