import sys
sys.path.append('../')
import database
import pprint
from queryconstructor import QueryConstructor
from plotconstructor import *
filename_prefix = "ping_over_carrier"
networkcountry="us"
filename=filename_prefix
qc = QueryConstructor()
qc.setGroupOrderSelectBy("device","networkname")
qc.addSelectMedian("ping","avg")
qc.addSelectPercentile("ping","avg",25)
qc.addSelectPercentile("ping","avg",75)
qc.addSelectField("count(*)")
qc.addWhereEqualsString("network","connectiontype","Mobile: 3G")
qc.addWhereNotEqualsString("device","networkname","sprint")
qc.addWhereNotEqualsString("device","networkname","cricket")
qc.addWhereNotEqualsString("device","networkname","US Cellular")
qc.addWhereNotEqualsString("device","networkname","T - Mobile")
qc.addWhereNotEqualsString("device","networkname","Simple Mobile")
qc.addWhereNotEqualsString("device","networkname","My Network")
qc.addWhereNotEqualsString("device","networkname","MetroPCS")
qc.addWhereNotEqualsString("device","networkname","HOME")
qc.addWhereNotEqualsString("device","networkname","")
qc.addWhereEqualsString("device","networkcountry",networkcountry)
qc.addWhereEqualsString("ping","dstip","www.google.com")
qc.applyMobileClauses()
import sys
sys.path.append('../')
import database, query, tuple_gen
import pprint
from queryconstructor import QueryConstructor
from plotconstructor import *
# EXAMPLE: warmup_avg_over_sequence GPRS
networktype = sys.argv[1]
filename_prefix = "warmup_over_sequence_network_" + networktype
filename = filename_prefix
qc = QueryConstructor()
qc.setGroupOrderSelectBy("warmup_ping", "sequence_count")
qc.addSelectMedian("warmup_ping", "value")
qc.addSelectPercentile("warmup_ping", "value", 25)
qc.addSelectPercentile("warmup_ping", "value", 75)
qc.addSelectField("count(*)")
qc.applyMobileClauses()
qc.applyWarmupSequenceClauses()
qc.addWhereEqualsString("network", "networktype", networktype)
qc.addWhereEqualsString("device", "networkcountry", "us")
qc.addWhereEqualsString("device", "networkname", "AT&T")
#qc.addWhereGreaterThan("warmup_ping","sequence_count",10)
result = database.query(qc.toString())
pprint.pprint(result)
plot = SimpleBarPlot()
import sys
sys.path.append('../')
import database
import pprint
from queryconstructor import QueryConstructor
from plotconstructor import *
filename_prefix = "ping_over_devicedesign"
networkcountry = "us"
filename = filename_prefix
qc = QueryConstructor()
qc.setGroupOrderSelectBy("device", "devicedesign")
qc.addSelectMedian("ping", "avg")
qc.addSelectPercentile("ping", "avg", 25)
qc.addSelectPercentile("ping", "avg", 75)
qc.addSelectField("count(*)")
qc.addWhereEqualsString("device", "networkcountry", networkcountry)
qc.addWhereNotEqualsString("network", "networktype", "")
qc.addWhereEqualsString("network", "networktype", "UMTS")
qc.addWhereEqualsString("device", "networkname", "AT&T")
qc.addWhereNotEqualsString("device", "devicedesign", "t0lteatt")
qc.addWhereNotEqualsString("device", "devicedesign", "olympus")
qc.applyMobileClauses()
qc.applyLatencyClauses("www.google.com")
#qc.addWhereEqualsString("device","networkname",'AT&T')
result = database.query(qc.toString())
sys.path.append('../')
import database, query, tuple_gen
import pprint
from queryconstructor import QueryConstructor
from plotconstructor import *
# EXAMPLE: warmup_avg_over_sequence GPRS
networktype=sys.argv[1]
filename_prefix = "warmup_over_sequence_network_"+networktype
filename=filename_prefix
qc = QueryConstructor()
qc.setGroupOrderSelectBy("warmup_ping","sequence_count")
qc.addSelectMedian("warmup_ping","value")
qc.addSelectPercentile("warmup_ping","value",25)
qc.addSelectPercentile("warmup_ping","value",75)
qc.addSelectField("count(*)")
qc.applyMobileClauses()
qc.applyWarmupSequenceClauses()
qc.addWhereEqualsString("network","networktype",networktype)
qc.addWhereEqualsString("device","networkcountry","us")
qc.addWhereEqualsString("device","networkname","AT&T")
#qc.addWhereGreaterThan("warmup_ping","sequence_count",10)
result = database.query(qc.toString())
pprint.pprint(result)
