3 # Copyright (C) 2000-2015 Kern Sibbald
4 # License: BSD 2-Clause; see file LICENSE-FOSS
8 # This script will test object deletion
12 TestName="delete-test"
16 scripts/copy-test-confs
20 echo $PWD/build/po > tmp/file-list
22 cat <<EOF > ${cwd}/tmp/bconcmds
26 label storage=File volume=TestVolume001
27 run job=$JobName level=full yes
30 @exec "touch $cwd/build/po/fr.po"
31 run job=$JobName level=incremental yes
34 @exec "touch $cwd/build/po/de.po"
35 run job=$JobName level=incremental yes
41 SELECT 'FOUND 1' FROM File WHERE JobId=3;
42 SELECT 'FOUND 2' FROM JobMedia WHERE JobId=3;
43 SELECT 'FOUND 3' FROM Log WHERE JobId=3;
44 SELECT 'FOUND 4' FROM BaseFiles WHERE JobId=3;
47 delete volume=TestVolume001 yes
49 SELECT 'FOUND 1' FROM File WHERE JobId IN (1,2);
50 SELECT 'FOUND 2' FROM JobMedia WHERE JobId IN (1,2);
51 SELECT 'FOUND 3' FROM Log WHERE JobId IN (1,2);
52 SELECT 'FOUND 4' FROM BaseFiles WHERE JobId IN (1,2);
64 grep -v SELECT $tmp/log2.out | grep FOUND > /dev/null
66 print_debug "Found orphan records in $tmp/log2.out"
70 grep -v SELECT $tmp/log3.out | grep FOUND > /dev/null
72 print_debug "Found orphan records in $tmp/log3.out"