#v+
accounting {
        reference = "%{tolower:type.%{%{Acct-Status-Type}:-none}.query}"


        type {
                start {
                        query = "UPDATE nodes SET lastonline = EXTRACT(EPOCH FROM now()) WHERE name='%{SQL-User-Name}'; \
                        INSERT INTO nodesessions (customerid,nodeid,ipaddr,mac,start,stop,tag,type) VALUES \
                                ((SELECT ownerid FROM nodes WHERE name='%{SQL-User-Name}'),\
                                (SELECT id FROM nodes WHERE name='%{SQL-User-Name}'),\
                                INET_ATON('%{Framed-IP-Address}'),\
                                '%{Calling-Station-Id}',\
                                '%{integer:Event-Timestamp}',\
                                '%{integer:Event-Timestamp}',\
                                '%{Acct-Session-Id}',\
                                '1')"
                }

                interim-update {
                        query = "UPDATE nodes SET lastonline = EXTRACT(EPOCH FROM now()) WHERE name='%{User-Name}';\
                                UPDATE nodesessions \
                                SET     \
                                        download = (('%{%{Acct-Output-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Output-Octets}:-0}'::bigint), \
                                        upload = (('%{%{Acct-Input-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Input-Octets}:-0}'::bigint), \
                                        stop = '%{integer:Event-Timestamp}' \
                                WHERE tag = '%{Acct-Session-Id}'"
                }

                stop {
                        query = "UPDATE nodes SET lastonline = EXTRACT(EPOCH FROM now()) WHERE name='%{User-Name}';\
                                UPDATE nodesessions \
                                SET     \
                                        download = (('%{%{Acct-Output-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Output-Octets}:-0}'::bigint), \
                                        upload = (('%{%{Acct-Input-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Input-Octets}:-0}'::bigint), \
                                        stop = '%{integer:Event-Timestamp}', \
                                        terminatecause = '%{Acct-Terminate-Cause}' \
                                WHERE tag = '%{Acct-Session-Id}'"
                }
 #
                #  No Acct-Status-Type == ignore the packet
                #
                none {
                     query = "SELECT true"
                }
        }
}