Design report connections logic.
The report connections interface will receive information on a current connection: IP, MAC, VLAN, router-name, timestamp.
The logic has to decide:
- is this a new or existing connection?
Finding a new connection requires determining that existing connections (matching IP, MAC, VLAN, router-name) have terminated.
- if this is a new connection, create the connection record, or
- if this is an existing connection, update the connection record.