#
#  Clear out old data
#
update {
	Tmp-String-0 := "%{sql:DELETE FROM radacct WHERE AcctSessionId = '00000000'}"
}
if (!&Tmp-String-0) {
	test_fail
}
else {
	test_pass
}

sql.accounting
if (ok) {
	test_pass
}
else {
	test_fail
}

update {
	Tmp-Integer-0 := "%{sql:SELECT count(*) FROM radacct WHERE AcctSessionId = '00000000'}"
}
if (!&Tmp-Integer-0 || (&Tmp-Integer-0 != 1)) {
	test_fail
}
else {
	test_pass
}

update {
	Tmp-Integer-0 := "%{sql:SELECT acctsessiontime FROM radacct WHERE AcctSessionId = '00000000'}"
}
if (!&Tmp-Integer-0 || (&Tmp-Integer-0 != 0)) {
	test_fail
}
else {
	test_pass
}