#!/usr/bin/python3
# -*- coding: utf-8 -*-
import mod_python
from fonctions import baseHTML, connexionBD, lien
def index(req):
req.content_type="text/html"
ipdst=str()
portdst=str()
#sql part
conn=connexionBD()
cur=conn.cursor()
###
cur.execute("SELECT COUNT(*) FROM paquet")
conn.commit()
total=str(cur.fetchone()[0])
#
cur.execute("SELECT COUNT(DISTINCT ip_source) FROM paquet")
conn.commit()
total_ip_src=str(cur.fetchone()[0])
#
cur.execute("SELECT COUNT(DISTINCT ip_destination) FROM paquet")
conn.commit()
total_ip_dst=str(cur.fetchone()[0])
#
cur.execute("SELECT COUNT(DISTINCT port_source) FROM paquet")
conn.commit()
total_port_src=str(cur.fetchone()[0])
#
cur.execute("SELECT COUNT(DISTINCT port_destination) FROM paquet")
conn.commit()
total_port_dst=str(cur.fetchone()[0])
#
cur.execute("SELECT COUNT(*) FROM paquet WHERE (heure>=( SELECT LOCALTIME - interval '1 hour' ) AND heure<= (SELECT LOCALTIME));")
conn.commit()
total_uneheure=str(cur.fetchone()[0])
#
cur.execute("SELECT ip_destination, COUNT(ip_destination) FROM paquet GROUP BY ip_destination DESC")
conn.commit()
each_ip_dest=cur.fetchall()
#
cur.execute("SELECT port_destination, COUNT(port_destination) FROM paquet GROUP BY port_destination")
conn.commit()
each_port_dest=cur.fetchall()
###
conn.close()
#sql part
#loops
for i in each_ip_dest :
ipdst+=("""
""" + str(i[0]) + """ |
""" + str(i[1]) + """ |
""")
for i in each_port_dest :
portdst+=("""
""" + str(i[0]) + """ |
""" + str(i[1]) + """ |
""")
#loops
#write the html page
req.write(baseHTML("ATS-Project","""
Bilan
- Nombre total de paquets : """+total+"""
- Nombre total de paquets depuis 1h : """+total_uneheure+"""
- Nombre total d'adresses IP source differentes : """+total_ip_src+"""
- Nombre total d'adresses IP destination differentes : """+total_ip_dst+"""
- Nombre total de ports source differents : """+total_port_src+"""
- Nombre total de ports destination differents : """+total_port_dst+"""
IP destination | Recurrence |
"""+str(ipdst)+"""
Port destination | Reccurrence |
"""+str(portdst)+"""
"""
))