117ea1ef |
(defun log-to-sqlite (db severity facility tag pid message host)
(let* ((query (dbi:prepare db "insert into messages (severity, facility, tag, pid, message, host) values (?,?,?,?,?,?)"))
(result (dbi:execute query severity facility tag pid message host)))
result))
|
117ea1ef |
(defun log-dnsquery-to-sqlite (db &key query-type query from)
(let* ((db-query (dbi:prepare db "insert into dns_query (query_type, request, requester) values (?,?,?)"))
(result (dbi:execute db-query query-type query from)))
result))
(defun log-dnsreply-to-sqlite (db &key query reply)
(let* ((db-query (dbi:prepare db "insert into dns_reply (query, reply) values (?,?)"))
(result (dbi:execute db-query query reply)))
result))
|