def updateSpeedInfo(n_clicks, oldSpeed, newSpeed):
if n_clicks != None:
conn = proj.openConnection(r"proj.sqlite")
nclicks = None
print("Speeds Updated")
with conn:
proj.updatespeed(conn, oldSpeed, newSpeed)
proj.closeConnection(conn, r"proj.sqlite")
def addIspInfo(n_clicks, isp):
if n_clicks != None:
conn = proj.openConnection(r"proj.sqlite")
nclicks = None
print("ISP Added")
with conn:
proj.insertisp(conn, isp)
proj.closeConnection(conn, r"proj.sqlite")
def deleteContractInfo(n_clicks, addr):
if n_clicks != None:
conn = proj.openConnection(r"proj.sqlite")
nclicks = None
print("Deleted Contract")
with conn:
proj.endcontract(conn, addr)
proj.closeConnection(conn, r"proj.sqlite")
def insertInfo(n_clicks, loc, num, addr):
if n_clicks != None:
conn = proj.openConnection(r"proj.sqlite")
nclicks = None
print("Inserted")
with conn:
proj.inserthouse(conn, "Address___#" + str(addr), num, loc)
proj.closeConnection(conn, r"proj.sqlite")
def updateSpeedDropDown(n_intervals):
conn = proj.openConnection(r"proj.sqlite")
c = conn.cursor()
speeds = "SELECT DISTINCT s_speed FROM speed ORDER BY s_speed"
c.execute(speeds)
speeds = [{
'label': str(i[0]) + " mbps",
'value': i[0]
} for i in c.fetchall()]
proj.closeConnection(conn, r"proj.sqlite")
return [speeds]
#!/usr/bin/python3
import dash
import dash_core_components as dcc
import dash_html_components as html
import sqlite3
import numpy as np
import pandas as pd
from dash.dependencies import Input, Output, State
import proj
app = dash.Dash()
conn = proj.openConnection(r"proj.sqlite")
#make just a list of addresses #kinda pointless
allAddresses = "SELECT n_address FROM network ORDER BY n_address"
c = conn.cursor()
c.execute(allAddresses)
allAddresses = []
addrOptions = []
for i in c.fetchall():
allAddresses.append(i[0])
for i in allAddresses:
addrOptions.append({'label': i, 'value': i})
speeds = "SELECT DISTINCT s_speed FROM speed ORDER BY s_speed"
c.execute(speeds)
speeds = []
speedOptions = []
for i in c.fetchall():
speeds.append(i[0])
