def home():
if request.method == 'POST':
entry_content = request.form.get("content")
database.create_entry(entry_content,
datetime.datetime.today().strftime("%b %d"))
return render_template("home.html", entries=database.retrieve_entries())
def home():
if request.method == "POST":
entry_content = request.form.get("message")
database.create_entry(
entry_content,
datetime.datetime.today().strftime("%m.%d.%Y, %H:%M"))
return render_template("home.html", entries=database.retrieve_entries())
def blog():
if request.method == "POST":
entry_content = request.form.get("content")
database.create_entry(entry_content,
datetime.today().strftime("%b %d"))
return render_template("blog.html",
entries=database.retrieve_entries(),
title="Blog")
def home():
if request.method == "POST":
try:
entry_content = request.form.get("message")
current_time = datetime.datetime.today() + datetime.timedelta(
hours=3)
database.create_entry(entry_content,
current_time.strftime("%m.%d.%Y, %H:%M"))
except Exception as e:
pass
return render_template("home.html", entries=database.retrieve_entries())
def home():
if request.method == "POST":
entry_content = request.form.get("content")
entry_content1 = request.form.get("content1")
database.create_entry_video(entry_content, datetime.datetime.today().strftime("%b %d"))
res = entry_content1.strip('][').split(', ')
for words in res:
video = getYT.searchVideoForKeyword(words)
for indivvideo in video:
database.create_entry(entry_content, datetime.datetime.today().strftime("%b %d"), indivvideo)
videos.append(f'{indivvideo}')
return render_template("home.html")
def add_button():
room = addRoom.get()
if room == '':
addStatusLabelText.set("Room cant be left empty")
return
room = room.upper()
rack = addRack.get()
if rack == '':
addStatusLabelText.set("Rack cant be left empty")
return
rack = rack.upper()
tray = addTray.get()
if tray == '':
addStatusLabelText.set("Tray cant be left empty")
return
tray = tray.upper()
oppositeRoom = addOppositeRoom.get()
if oppositeRoom == '':
addStatusLabelText.set("Opposite Room cant be left empty")
return
oppositeRoom = oppositeRoom.upper()
oppositeRack = addOppositeRack.get()
if oppositeRack == '':
addStatusLabelText.set("Opposite Rack cant be left empty")
return
oppositeRack = oppositeRack.upper()
oppositeTray = addOppositeTray.get()
if oppositeTray == '':
addStatusLabelText.set("Opposite Tray cant be left empty")
return
oppositeTray = oppositeTray.upper()
portState = {}
for item in portsAdd:
portState[item] = portsAdd[item]['var'].get()
addStatusLabelText.set(database.create_entry(room, rack, tray, oppositeRoom, oppositeRack, oppositeTray, portState))
for item in portsAdd:
portsAdd[item]['item'].deselect()
addRoom.delete(0, END)
addRack.delete(0, END)
addTray.delete(0, END)
addOppositeRoom.delete(0, END)
addOppositeRack.delete(0, END)
addOppositeTray.delete(0, END)
refresh_rooms_button
import sys
import database
conn = database.create_connection("./network_data.db")
table_name = "pcap_data"
sql_str = """
CREATE TABLE IF NOT EXISTS {} (
id integer PRIMARY KEY,
protocol text NOT NULL,
epoch_time text NOT NULL
);
""".format(table_name)
database.create_table(conn, sql_str)
for row in sys.stdin:
if row != "Capturing on 'Wi-Fi'\n" and "packets" not in row:
entry = row.replace("\n", "").split(",")
fields = ['protocol', 'epoch_time']
entry_id = database.create_entry(conn, table_name, fields, entry)
database.select_all(conn, table_name)
