def checker(l):
list_values=[]
#list_values=read_file()
list_values=l
x=sample1.fetchdistance(list_values[1],list_values[2])
if(x!=None):
print "given strings in database"
fare = x[5]
avg_fare = x[4]
distance = x[3]
imp_waypoints = x[2]
counter = x[6]
rightfare_func.get_file(fare,avg_fare,list_values[0],list_values[1],list_values[2],distance,imp_waypoints)
#sample1.updatedistance(list_values[1],list_values[2],avg_fare,counter)
sys.exit()
list_values[1]= list_values[1]+ 'New Delhi'
lat_a,lng_a = gmaps.address_to_latlng(list_values[1])
list_values[2]= list_values[2]+ 'New Delhi'
lat_b,lng_b = gmaps.address_to_latlng(list_values[2])
a=sample1.fetchall(lat_a,lng_a)
b=sample1.fetchall(lat_b,lng_b)
if(a!=None and b!=None):
print "given string in database"
x = sample1.fetchdistance(a[0],b[0])
fare = x[5]
avg_fare = x[4]
distance = x[3]
imp_waypoints = x[2]
rightfare_func.get_file(fare,avg_fare,list_values[0],list_values[1],list_values[2],distance,imp_waypoints)
sys.exit()
return lat_a,lng_a,lat_b,lng_b
def callavg(l):#l contains no,userfare
list3=[]
list1=multiquery.updateuserfare(l)
source=list1[0]+"New Delhi"
print source
destination=list1[1]+"New Delhi"
print '******'
print destination
print '******'
avgfare=float(l[1])
print avgfare
print type(avgfare)
list2=sample1.fetchdistance(source,destination)
print list2
value=float(list2[4])
counter=int(list2[6])
print counter
print type(counter)
print '******'
list3=sample1.avgfarecalc(avgfare,value,counter)
print list3
avgfare=str(list3[0])
print type(avgfare)
counter=int(list3[1])
print type(counter)
counter=str(counter)
print type(counter)
sample1.updatedistance(source,destination,avgfare,counter)
def store(l):#l contains no, src, dest
#l[1]=l[1]+"New Delhi"
#l[2]=l[2]+"New Delhi"
x=sample1.fetchdistance(l[1],l[2])
if(x!=None):
print "given strings in database"
userfare.insert(l[0],x[0],x[1])
else:
userfare.insert(l[0],l[1],l[2])
def checker(l):
list_values=[]
flag1=0
flag2=0
# f1=0
# f2=0
list_values=l
x=sample1.fetchdistance(list_values[1],list_values[2])
if(x!=None):
print "given strings in database"
fare = x[5]
avg_fare = x[4]
distance = x[3]
imp_waypoints = x[2]
counter = x[6]
rightfare_func.get_file(fare,avg_fare,list_values[0],list_values[1],list_values[2],distance,imp_waypoints)
sys.exit()
a=geocode(list_values[1])
b=geocode(list_values[2])
if(a==0):
print "Checked pin code for a"
findpincode(a)
if b==0:
print "Checked pin code for b"
findpincode(b)
if(a==0) or (b==0):
sys.exit()
#x=sample.fetchdistancelatlng(a,b)#this function has to be written
'''if(x!=None):
print "given strings in database"
fare = x[5]
avg_fare = x[4]
distance = x[3]
imp_waypoints = x[2]
counter = x[6]
rightfare_func.get_file(fare,avg_fare,list_values[0],list_values[1],list_values[2],distance,imp_waypoints)
sys.exit()'''
#else:
return a[0],a[1],b[0],b[1]
import sample1 #import multiquery l=['rohiniNew Delhi','dwarkaNew Delhi'] x=sample1.fetchdistance(l[0],l[1]) print x #multiquery.store(l)
