tests/lnttool/PostgresDB.shtest

# RUN: rm -rf "%t.install"
# RUN: mkdir -p "%t.install"
# RUN: %{utils}/with_postgres.sh %t.log bash %s "%t.install" "%{shared_inputs}"
set -eux

TESTDIR="$1"
SHARED_INPUTS="$2"

lnt create "${TESTDIR}/instance" --db-dir ${LNT_TEST_DB_URI} --default-db ${LNT_TEST_DB_NAME}

# Import a test set.
lnt import "${TESTDIR}/instance" "${SHARED_INPUTS}/sample-a-small.plist" --show-sample-count

# Import a test set.
lnt import "${TESTDIR}/instance" "${SHARED_INPUTS}/sample-b-small.plist" --show-sample-count

# Check that we remove both the sample and the run, and that we don't commit by
# default.
#
lnt updatedb "${TESTDIR}/instance" --testsuite nts --delete-run 1 \
	--show-sql >& "${TESTDIR}/runrm.out"
# RUN: filecheck --check-prefix CHECK-RUNRM %s < "%t.install/runrm.out"

# CHECK-RUNRM: DELETE FROM "NT_Sample" WHERE "NT_Sample"."ID" = %(ID)s
# CHECK-RUNRM-NEXT: ({'ID': 1}, {'ID': 2})
# CHECK-RUNRM: DELETE FROM "NT_Run" WHERE "NT_Run"."ID" = %(ID)s
# CHECK-RUNRM-NEXT: {'ID': 1}
# CHECK-RUNRM: COMMIT

# Import a test set.
lnt import "${TESTDIR}/instance" "${SHARED_INPUTS}/sample-a-small.plist" --show-sample-count

# Check that we remove runs when we remove a machine.
#
lnt updatedb "${TESTDIR}/instance" --testsuite nts \
	--delete-machine "LNT SAMPLE MACHINE" \
	--show-sql >& "${TESTDIR}/machinerm.out"
# RUN: filecheck --check-prefix CHECK-MACHINERM %s < "%t.install/machinerm.out"

# CHECK-MACHINERM: DELETE FROM "NT_Sample" WHERE "NT_Sample"."ID" = %(ID)s
# CHECK-MACHINERM-NEXT: ({'ID': 3}, {'ID': 4}, {'ID': 5})
# CHECK-MACHINERM: DELETE FROM "NT_Run" WHERE "NT_Run"."ID" = %(ID)s
# CHECK-MACHINERM-NEXT: {'ID': 2}
# CHECK-MACHINERM: DELETE FROM "NT_Machine" WHERE "NT_Machine"."ID" = %(ID)s
# CHECK-MACHINERM-NEXT: {'ID': 1}
# CHECK-MACHINERM: COMMIT

# Import a test set so we can test --delete-order.
lnt import "${TESTDIR}/instance" "${SHARED_INPUTS}/sample-a-small.plist" --show-sample-count

# Check that we remove both the samples and the run associated with that order
# when we delete an order.
#
lnt updatedb "${TESTDIR}/instance" --testsuite nts --delete-order 1 \
	--show-sql >& "${TESTDIR}/orderrm.out"
# RUN: filecheck --check-prefix CHECK-ORDERRM %s < "%t.install/orderrm.out"

# CHECK-ORDERRM: DELETE FROM "NT_Sample" WHERE "NT_Sample"."ID" = %(ID)s
# CHECK-ORDERRM-NEXT: {{'ID': [0-9]+}}
# CHECK-ORDERRM: DELETE FROM "NT_Run" WHERE "NT_Run"."ID" = %(ID)s
# CHECK-ORDERRM-NEXT: {{'ID': [0-9]+}}
# CHECK-ORDERRM: COMMIT