import sys
sys.path.append('../')
import database
from queryconstructor import QueryConstructor
from plotconstructor import LinePlot, Mapping
filename_prefix = "ping_avg_distribution"
networkcountry = "us"
filename = filename_prefix
qc = QueryConstructor()
qc.setGroupOrderSelectBy("ping", "5*cast((avg/5) as int)")
qc.addSelectField("count(*)")
qc.addWhereEqualsString("network", "connectiontype", "Mobile: 3G")
qc.addWhereEqualsString("device", "networkcountry", networkcountry)
qc.addWhereEqualsString("ping", "dstip", "www.google.com")
qc.addWhereLessThan("ping", "avg", 700)
qc.applyMobileClauses()
qc.applyLatencyClauses("www.google.com")
qc.addWhereEqualsString("device", "networkname", 'AT&T')
result = database.query(qc.toString())
qc = QueryConstructor()
qc.setGroupOrderSelectBy("ping", "5*cast((avg/5) as int)")
qc.addSelectField("count(*)")
qc.addWhereEqualsString("network", "connectiontype", "Mobile: 3G")
qc.addWhereEqualsString("device", "networkcountry", networkcountry)
qc.addWhereEqualsString("ping", "dstip", "www.google.com")
qc.addWhereLessThan("ping", "avg", 700)
qc.applyMobileClauses()
qc.applyLatencyClauses("www.google.com")
