+++ /dev/null
-#
-# PRE: acct_2_stop
-#
-# Check that conflicting unique IDs triggers failover to alternative query
-#
-
-#
-# Clear out old data
-#
-update {
- Tmp-String-0 := "%{sql:DELETE FROM radacct WHERE AcctSessionId = '00000001'}"
-}
-if (!&Tmp-String-0) {
- test_fail
-}
-else {
- test_pass
-}
-
-#
-# Insert the Accounting-Request start
-#
-sql.accounting
-if (ok) {
- test_pass
-}
-else {
- test_fail
-}
-
-#
-# Check the database has at least one row
-#
-update {
- Tmp-Integer-0 := "%{sql:SELECT count(*) FROM radacct WHERE AcctSessionId = '00000001'}"
-}
-if (!&Tmp-Integer-0 || (&Tmp-Integer-0 != 1)) {
- test_fail
-}
-else {
- test_pass
-}
-
-#
-# Check acctsessiontime matches the value in the request
-#
-update {
- Tmp-Integer-0 := "%{sql:SELECT acctsessiontime FROM radacct WHERE AcctSessionId = '00000001'}"
-}
-if (!&Tmp-Integer-0 || (&Tmp-Integer-0 != 0)) {
- test_fail
-}
-else {
- test_pass
-}
-
-#
-# Change acctsessiontime and verify it's updated
-#
-update request {
- Connect-Info = 'updated'
-}
-sql.accounting
-if (ok) {
- test_pass
-}
-else {
- test_pass
-}
-update {
- Tmp-String-0 := "%{sql:SELECT connectinfo_start FROM radacct WHERE AcctSessionId = '00000001'}"
-}
-if (!&Tmp-Integer-0 || (&Tmp-String-0 != 'updated')) {
- test_fail
-}
-else {
- test_pass
-}