| # -*- text -*- |
| # |
| # cui/sqlite/queries.conf -- Queries to update a sqlite CUI table. |
| # |
| # $Id: 41741eb70ae9c428ba5230aaf9d9b84f95c050a9 $ |
| |
| post-auth { |
| query = "\ |
| INSERT OR REPLACE INTO ${..cui_table} \ |
| (clientipaddress, callingstationid, username, cui, lastaccounting) \ |
| VALUES \ |
| ('%{%{Packet-Src-IPv6-Address}:-%{Packet-Src-IP-Address}}', '%{Calling-Station-Id}', \ |
| '%{User-Name}', '%{reply:Chargeable-User-Identity}', NULL)" |
| |
| } |
| |
| accounting { |
| reference = "%{tolower:type.%{Acct-Status-Type}.query}" |
| type { |
| start { |
| query = "\ |
| UPDATE ${....cui_table} SET \ |
| lastaccounting = CURRENT_TIMESTAMP \ |
| WHERE clientipaddress = '%{%{Packet-Src-IPv6-Address}:-%{Packet-Src-IP-Address}}' \ |
| AND callingstationid = '%{Calling-Station-Id}' \ |
| AND username = '%{User-Name}' \ |
| AND cui = '%{Chargeable-User-Identity}'" |
| } |
| interim-update { |
| query ="\ |
| UPDATE ${....cui_table} SET \ |
| lastaccounting = CURRENT_TIMESTAMP \ |
| WHERE clientipaddress = '%{%{Packet-Src-IPv6-Address}:-%{Packet-Src-IP-Address}}' \ |
| AND callingstationid = '%{Calling-Station-Id}' \ |
| AND username = '%{User-Name}' \ |
| AND cui = '%{Chargeable-User-Identity}'" |
| } |
| stop { |
| query ="\ |
| DELETE FROM ${....cui_table} \ |
| WHERE clientipaddress = '%{%{Packet-Src-IPv6-Address}:-%{Packet-Src-IP-Address}}' \ |
| AND callingstationid = '%{Calling-Station-Id}' \ |
| AND username = '%{User-Name}' \ |
| AND cui = '%{Chargeable-User-Identity}'" |
| } |
| } |
| } |