Section 4.11.8.1. Example: CloseAllSessionsQuery

Example: `CloseAllSessionsQuery`

In the following example query, bind variables marked with question marks are used with CloseAllSessionsQueryParams listed below the query.

CloseAllSessionsQuery UPDATE sessions SET \
      stop_time=? WHERE imsi=? \
      AND stop_time IS NULL
CloseAllSessionsQueryParam %t
CloseAllSessionsQueryParam %0

Instead of the updating session stop timestamp, it's also possible to remove the old sessions.

CloseAllSessionsQuery DELETE FROM sessions WHERE imsi=? AND stop_time IS NULL
CloseAllSessionsQueryParam %0