blob: 06ce3b6089fb1c73e81977a6081094069d4f1292 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
#
# This query properly handles calls that span from the
# previous reset period into the current period but
# involves more work for the SQL server than those
# below
#
query = "\
SELECT SUM(acctsessiontime - GREATEST((%%b - strftime('%%s', acctstarttime)), 0)) \
FROM radacct \
WHERE username = '%{${key}}' \
AND (strftime('%%s', acctstarttime) + acctsessiontime) > %%b"
|