def post(self): self.response.headers['Content-Type'] = 'text/html' if self.request.get('button') == 'Add': user = users.get_current_user() if user: EletronicVehicle_key = ndb.Key('EleVhe', user.user_id()) eletronicvehicle = EletronicVehicle_key.get() eletronicvehicle = EleVhe( name=self.request.get('name').strip(), manufacturer=self.request.get('manufacturer').strip(), year=int(self.request.get('year').strip()), btrysize=int(self.request.get('btrysize').strip()), wltprng=int(self.request.get('wltprng').strip()), power=int(self.request.get('power').strip()), cost=int(self.request.get('cost').strip()), email_address=user.email().strip()) #query = eletronicvehicle.all().filter("email_address="user.email()).filter("name=",self.request.get('name')).filter("manufacturer=",self.request.get('manufacturer')).filter("year=",self.request.get('year')) #query=EleVhe.query(ndb.AND(EleVhe.email_address==user.email(),EleVhe.name==eletronicvehicle.name,EleVhe.manufacturer==eletronicvehicle.manufacturer,EleVhe.year==eletronicvehicle.year)) query = EleVhe.query( ndb.AND( EleVhe.name == eletronicvehicle.name, EleVhe.manufacturer == eletronicvehicle.manufacturer, EleVhe.year == eletronicvehicle.year)) if query.count() == 0: welcome = "Details Entered" eletronicvehicle.put() else: #Code to display error box to user Using Ctypes Library Which Comes with Python Installation print("Details Found") self.redirect('/') elif self.request.get('button') == 'Cancel': self.redirect('/')
def get(self): self.response.headers['Content-Type'] = 'text/html' url = '' url_string = '' list1 = '' eletronicvehicle = '' EletronicVehicle_key = '' user = users.get_current_user() #list1=self.request.get('key').strip("Key()").split(",") list1 = int(self.request.get('key')) if (self.request.get('message') != ''): message = self.request.get('message') else: message = '' list = '' listr = '' avgl = [] avg = 0.0 EletronicVehicle_key = ndb.Key('EleVhe', list1) list = EleVhe.query(EleVhe.key == EletronicVehicle_key).fetch() listr = Reviews.query( Reviews.vehicle_id == list1).order(-Reviews.sequence).fetch() for i in listr: avgl.append(i.rating) avg += int(i.rating) if len(avgl) > 0: avg = avg / len(avgl) else: avg = 0 if user: EletronicVehicle_key1 = ndb.Key('EleVhe', user.user_id()) eletronicvehicle = EletronicVehicle_key1.get() eletronicvehicle = EleVhe(email_address=user.email()) url = users.create_logout_url(self.request.uri) url_string = 'logout' #list1=eletronicvehicle else: url = users.create_login_url(self.request.uri) url_string = 'login' template_values = { 'url': url, 'url_string': url_string, 'user': user, 'showList': list, 'Review': listr, 'Avg': avg, 'message': message, 'list1': list1, 'eletronicvehicle': eletronicvehicle } template = JINJA_ENVIRONMENT.get_template('Review.html') self.response.write(template.render(template_values))
def get(self): self.response.headers['Content-Type'] = 'text/html' # URL that will contain a login or logout link # and also a string to represent this url = '' url_string = '' welcome = 'Welcome back' eletronicvehicle = '' template_values = '' list = '' # pull the current user from the request user = users.get_current_user() # determine if we have a user logged in or not if user: url = users.create_logout_url(self.request.uri) url_string = 'logout' #list = EleVhe.query(EleVhe.email_address == user.email()).fetch() EletronicVehicle_key = ndb.Key('EleVhe', user.user_id()) eletronicvehicle = EletronicVehicle_key.get() query = EleVhe.query(EleVhe.email_address == user.email()).get() #Query To GetUser Email Address if eletronicvehicle == '' and query== None: welcome = 'Welcome to the Application' eletronicvehicle = EleVhe(id=user.user_id()) eletronicvehicle = EleVhe(email_address=user.email()) #eletronicvehicle.put() else: welcome = 'Welcome Back' eletronicvehicle = EleVhe(email_address=user.email()) else: url = users.create_login_url(self.request.uri) url_string = 'login' list = EleVhe.query().fetch() # generate a map that contains everything that we need to pass to the template template_values = { 'url' : url, 'url_string' : url_string, 'user' : user, 'welcome' : welcome, 'eletronicvehicle' : eletronicvehicle, 'showList' : list } # pull the template file and ask jinja to render # it with the given template values template = JINJA_ENVIRONMENT.get_template('search.html') #template = JINJA_ENVIRONMENT.get_template('addEVDetails.html') self.response.write(template.render(template_values))
def get(self): self.response.headers['Content-Type'] = 'text/html' url = '' url_string = '' eletronicvehicle = '' user = users.get_current_user() if user: EletronicVehicle_key = ndb.Key('EleVhe', user.user_id()) eletronicvehicle = EletronicVehicle_key.get() eletronicvehicle = EleVhe(email_address=user.email()) url = users.create_logout_url(self.request.uri) url_string = 'logout' else: url = users.create_login_url(self.request.uri) url_string = 'login' template_values = { 'url': url, 'url_string': url_string, 'user': user, 'eletronicvehicle': eletronicvehicle } template = JINJA_ENVIRONMENT.get_template('addEVDetails.html') self.response.write(template.render(template_values))
def post(self): self.response.headers['Content-Type'] = 'text/html' if self.request.get('button') == 'Save': url = '' url_string = '' list1 = '' eletronicvehicle = '' EletronicVehicle_key = '' message = '' review = '' user = users.get_current_user() #list1=self.request.get('key').strip("Key()").split(",") list1 = int(self.request.get('hiddenid').strip()) message = self.request.get('message') message = '' list = '' listr = '' avgl = [] avg = 0 rcnt = '' EletronicVehicle_key = ndb.Key('EleVhe', list1) list = EleVhe.query(EleVhe.key == EletronicVehicle_key).fetch() user = users.get_current_user() if user: EletronicVehicle_key = ndb.Key('EleVhe', user.user_id()) eletronicvehicle = EletronicVehicle_key.get() eletronicvehicle = EleVhe(email_address=user.email()) listr = Reviews.query(Reviews.vehicle_id == list1) rcnt = listr.count() review = Reviews( review=self.request.get('review').strip(), rating=int(self.request.get('rating').strip()), vehicle_id=int(self.request.get('hiddenid').strip()), email_address=user.email().strip(), sequence=rcnt) if len(self.request.get('review').strip()) <= 1000: review.put() else: self.redirect('/?message=Review Length Exceeds') else: url = users.create_login_url(self.request.uri) url_string = 'login' self.redirect('/') elif self.request.get('button') == 'Cancel': self.redirect('/')
def get(self): self.response.headers['Content-Type'] = 'text/html' url='' url_string='' list1='' eletronicvehicle='' EletronicVehicle_key='' user = users.get_current_user() #list1=self.request.get('key').strip("Key()").split(",") list1=int(self.request.get('key')) list='' if user: EletronicVehicle_key = ndb.Key('EleVhe',list1 ) EletronicVehicle_key1 = ndb.Key('EleVhe', user.user_id()) eletronicvehicle = EletronicVehicle_key1.get() eletronicvehicle=EleVhe(email_address=user.email()) url=users.create_logout_url(self.request.uri) url_string='logout' list=EleVhe.query(EleVhe.key==EletronicVehicle_key).fetch() #list1=eletronicvehicle else: url = users.create_login_url(self.request.uri) url_string = 'login' template_values = { 'url':url, 'url_string':url_string, 'user' : user, 'showList':list, 'list1':EletronicVehicle_key, 'eletronicvehicle' : eletronicvehicle } template = JINJA_ENVIRONMENT.get_template('delete.html') self.response.write(template.render(template_values))
def post(self): self.response.headers['Content-Type'] = 'text/html' if self.request.get('button') == 'Update': user = users.get_current_user() url = '' url_string = '' list1 = '' eletronicvehicle = '' emial_address = '' EletronicVehicle_key = '' if user: EletronicVehicle_key = ndb.Key( 'EleVhe', int(self.request.get('edit_key'))) eletronicvehicle = EletronicVehicle_key.get() name = self.request.get('name') manufacturer = self.request.get('manufacturer') year = int(self.request.get('year')) btrysize = int(self.request.get('btrysize')) wltprng = int(self.request.get('wltprng')) power = int(self.request.get('power')) cost = int(self.request.get('cost')) email_address = self.request.get('email_address') eletronicvehicle.name = self.request.get('name') eletronicvehicle.manufacturer = self.request.get( 'manufacturer') eletronicvehicle.year = int(self.request.get('year')) eletronicvehicle.btrysize = int(self.request.get('btrysize')) eletronicvehicle.wltprng = int(self.request.get('wltprng')) eletronicvehicle.power = int(self.request.get('power')) eletronicvehicle.cost = int(self.request.get('cost')) #eletronicvehicle.email_address = self.request.get('email_address') #query = eletronicvehicle.all().filter("email_address="user.email()).filter("name=",self.request.get('name')).filter("manufacturer=",self.request.get('manufacturer')).filter("year=",self.request.get('year')) #query=EleVhe.query(ndb.AND(EleVhe.email_address==email_address,EleVhe.name==name,EleVhe.manufacturer==manufacturer,EleVhe.year==year,EleVhe.key!=EletronicVehicle_key)) query = EleVhe.query( ndb.AND(EleVhe.name == name, EleVhe.manufacturer == manufacturer, EleVhe.year == year, EleVhe.key != EletronicVehicle_key)) if query.count() >= 1: welcome = "Details Already Entered" #eletronicvehicle.put() else: #Code to display error box to user Using Ctypes Library Which Comes with Python Installation #print("Details Found") eletronicvehicle.put() self.redirect('/') elif self.request.get('button') == 'Cancel': self.redirect('/')
def post(self): self.response.headers['Content-Type'] = "text/html" if self.request.get('button') =="Search": url = '' url_string = '' welcome = 'Welcome back' eletronicvehicle = '' list = '' list1='' name='' email_address='' manufacturer='' year=0 #min value of year year1=0 #max value of year btrysize=0 #min value of betery size btrysize1=0 #max value of betery size wltprng=0 #min value of WLTP range wltprng1=0 #max value of WLTP range cost=0 #min value of cost cost1=0 #max value of cost1 power=0 #min value of Power power1=0 #max value of Power template_values='' user = users.get_current_user() if user: url = users.create_logout_url(self.request.uri) url_string = 'logout' EletronicVehicle_key = ndb.Key('EleVhe', user.user_id()) eletronicvehicle = EletronicVehicle_key.get() query = EleVhe.query(EleVhe.email_address == user.email()).get() if eletronicvehicle == '' and query== None: welcome = 'Welcome to the Application' eletronicvehicle = EleVhe(id=user.user_id()) eletronicvehicle = EleVhe(email_address=user.email()) else: welcome = 'Welcome Back' eletronicvehicle = EleVhe(email_address=user.email()) else: url = users.create_login_url(self.request.uri) url_string = 'login' #print("--------"+self.request.get('name')) list = EleVhe.query() if(self.request.get('name').strip() != '' and self.request.get('name').strip() != None): name = self.request.get('name').strip() if(self.request.get('manufacturer').strip() !='' and self.request.get('manufacturer').strip() != None ): manufacturer = self.request.get('manufacturer').strip() if(self.request.get('year').strip() !='' and self.request.get('year').strip() != None ): year = int(self.request.get('year')) if(self.request.get('year1').strip() !='' and self.request.get('year1').strip() != None ): year1 = int(self.request.get('year1')) if(self.request.get('btrysize').strip() != '' and self.request.get('btrysize').strip() != None): btrysize = int(self.request.get('btrysize')) if(self.request.get('btrysize1').strip() != '' and self.request.get('btrysize1').strip() != None): btrysize1 = int(self.request.get('btrysize1')) if(self.request.get('wltprng').strip() != '' and self.request.get('wltprng').strip() != None): wltprng = int(self.request.get('wltprng')) if(self.request.get('wltprng1').strip() != '' and self.request.get('wltprng1').strip() != None): wltprng1 = int(self.request.get('wltprng1')) if(self.request.get('power').strip() != '' and self.request.get('power').strip() != None): power = int(self.request.get('power')) if(self.request.get('power1').strip() != '' and self.request.get('power1').strip() != None): power1 = int(self.request.get('power1')) if(self.request.get('cost').strip() != '' and self.request.get('cost').strip() != None): cost = int(self.request.get('cost')) if(self.request.get('cost1').strip() != '' and self.request.get('cost1').strip() != None): cost1 = int(self.request.get('cost1')) if(self.request.get('email_address').strip() != '' and self.request.get('email_address').strip() != None): email_address = self.request.get('email_address').strip() if( name=='' and manufacturer == '' and email_address =='' and year == 0 and year1 == 0 and btrysize == 0 and btrysize1 == 0 and wltprng == 0 and wltprng1 == 0 and power == 0 and power1 == 0 and cost == 0 and cost1 == 0 ): #list1 = type(cost) list = list.filter() else: #list1= cost list = list.filter(ndb.OR(EleVhe.name == name,EleVhe.manufacturer == manufacturer,ndb.AND(EleVhe.year >= year,EleVhe.year <= year1),ndb.AND(EleVhe.btrysize >= btrysize,EleVhe.btrysize <= btrysize1),ndb.AND(EleVhe.wltprng >= wltprng,EleVhe.wltprng <= wltprng1),ndb.AND(EleVhe.power >= power,EleVhe.power <= power1),ndb.AND(EleVhe.cost >= cost,EleVhe.cost <= cost1),EleVhe.email_address == email_address)) #list1 = list list = list.fetch() #list1 = list template_values={ 'url' : url, 'url_string' : url_string, 'user' : user, 'welcome' : welcome, 'eletronicvehicle' : eletronicvehicle, 'showList' : list, 'list1' : list1 } template = JINJA_ENVIRONMENT.get_template('search.html') self.response.write(template.render(template_values))
def post(self): self.response.headers['Content-Type'] = 'text/html' ids='' list1='' listr='' l1=[] l2=[] cost=[] maxcost=0 wltp=[] maxwltp=0 power=[] maxpower=0 btrysize=[] avgrating=[] maxavg=0 maxbtry=0 list2='' list = EleVhe.query() if self.request.get('button') == 'Compare': for i in range(list.count()): if(self.request.get("check_"+str(i))): #l1.append(ndb.Key('EleVhe', self.request.get("check_"+str(i)).strip())) l1.append(int(self.request.get("check_"+str(i)).strip())) if len(l1)<2: self.redirect('/') else: for j in range(len(l1)): list1=EleVhe.query(EleVhe.key==ndb.Key('EleVhe',l1[j])) c=0 avg=0.0 listr=Reviews.query(Reviews.vehicle_id==l1[j]).fetch() for m in listr: c+=1 avg+=int(m.rating) if c>0: avg=avg/c else: avg=0 avgrating.append(avg) l2.append(list1.fetch()) #l2.append(avg) for k in l2: for l in k: cost.append(l.cost) wltp.append(l.wltprng) power.append(l.power) btrysize.append(l.btrysize) maxcost=max(cost) maxwltp=max(wltp) maxpower=max(power) maxbtry=max(btrysize) maxavg=max(avgrating) template_values={ 'showList':l2, 'cost':maxcost, 'list1':list2, 'wltp': maxwltp, 'power':maxpower, 'btrysize':maxbtry, 'avgrat':maxavg, 'avgratl':avgrating } template = JINJA_ENVIRONMENT.get_template('compare.html') #template = JINJA_ENVIRONMENT.get_template('addEVDetails.html') self.response.write(template.render(template_values))