def __init__(self):
from flow import Flows
self.flow = Flows()
def __init__(self):
from flow import Flows
self.flow = Flows()
self.cmd = "SELECT * FROM `flows` LIMIT %s, %s"
self.cmd_total = "SELECT * FROM `flows` INNER JOIN `flow_alert` ON flows.id = flow_alert.flowid INNER JOIN `alerts` ON flow_alert.alertid = alerts.id INNER JOIN `alert_type` ON alerts.type = alert_type.id LIMIT %s, %s"
self.cmd_good = "SELECT * FROM `flows` WHERE `id` NOT IN (SELECT `flowid` FROM `flow_alert`) LIMIT %s, %s"
