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)