File: mysql_retention.lua

package info (click to toggle)
ntopng 5.2.1%2Bdfsg1-2
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 121,832 kB
  • sloc: javascript: 143,431; cpp: 71,175; ansic: 11,108; sh: 4,687; makefile: 911; python: 587; sql: 512; pascal: 234; perl: 118; ruby: 52; exp: 4
file content (27 lines) | stat: -rw-r--r-- 900 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
--
-- (C) 2013-22 - ntop.org
--

local dirs = ntop.getDirs()
package.path = dirs.installdir .. "/scripts/lua/modules/?.lua;" .. package.path
package.path = dirs.installdir .. "/scripts/lua/modules/timeseries/?.lua;" .. package.path

local scripts_triggers = require "scripts_triggers"

-- ########################################################

local verbose = ntop.verboseTrace()

-- ###########################################

if scripts_triggers.isDumpFlowToSQLEnabled(ifstats) then
   local db_utils = require "db_utils"
   local data_retention_utils = require "data_retention_utils"
   local iface_names = interface.getIfNames()
   local data_retention = data_retention_utils.getDataRetentionDays()
   local mysql_retention = os.time() - 86400 * data_retention
   
   for _,ifname in pairs(iface_names) do
      db_utils.harverstExpiredMySQLFlows(ifname, mysql_retention, verbose)
   end
end