def my_view(request): form = first_form() preset_form = websiteform() crawl_css=crawl_url_attribute_css_sel1() prod=prodid1() searc=search1() website_map=website.objects.raw('SELECT * FROM `website`') global warning if request.method=="POST": if 'button3' in request.POST: form = first_form(request.POST or None) if form.is_valid(): save_it=form.save(commit=False) save_it.save() website_map=website.objects.raw('SELECT * FROM `website`') if 'button7' in request.POST: item_map=crawl_url.objects.filter(website_id__in=request.POST['website_id']) return render_to_response('crawl.html',{'posts2':item_map,'form1':preset_form},RequestContext(request)) if 'button4' in request.POST: preset_form = websiteform(request.POST or None) if preset_form.is_valid(): save_it=preset_form.save(commit=False) save_it.save() warning=request.POST['crawl_id'] return HttpResponseRedirect('/crawl/') if 'button5' in request.POST: x=request.POST['crawlid'] item_try=final.objects.filter(crawl_id__exact=x) z=item_try[0] cat_query=cat.objects.filter(category__exact=z.cat) scroll_first(z.parent_css,z.prod_id,z.prod_attribute,z.name,z.mrp,z.sp,x,cat_query[0].id) return HttpResponseRedirect('') if 'crawl_all' in request.POST: sql="SELECT * FROM `crawl_url`" cursor.execute(sql) lis=cursor.fetchall() for e in range(len(lis)): x=lis[e][0] item_try=final.objects.filter(crawl_id__exact=x) z=item_try[0] cat_query=cat.objects.filter(category__exact=z.cat) scroll_first(z.parent_css,z.prod_id,z.prod_attribute,z.name,z.mrp,z.sp,x,cat_query[0].id) return HttpResponseRedirect('') if 'crawl_id1' in request.POST: warning=request.POST['crawl_id1'] return HttpResponseRedirect('/crawl/') if 'search' in request.POST: return HttpResponseRedirect('/search/') return render_to_response('signup.html',{'form': first_form,'posts':website_map},RequestContext(request))
def add_details(request): crawl_css=crawl_url_attribute_css_sel1() prod=prodid1() x=crawl_url.objects.get(crawl_id__exact=warning) scro=scroll1() sql="SELECT * FROM `scroll`" cursor.execute(sql) lik=cursor.fetchall() web_ids=[] for e in range(len(lik)): web_ids.append(lik[e][4]) exist=scroll.objects.filter(web_id__in=web_ids) if request.method=="POST": if 'button1' in request.POST: scro=scroll1(request.POST or None) if scro.is_valid(): save_it=scro.save(commit=False) save_it.save() return HttpResponseRedirect('') elif 'button2' in request.POST: prod=prodid1(request.POST or None) if prod.is_valid(): save_it=prod.save(commit=False) save_it.save() return HttpResponseRedirect('') elif 'button3' in request.POST: crawl_css=crawl_url_attribute_css_sel1(request.POST or None) if crawl_css.is_valid(): css=request.POST['parent_css'] prod=request.POST['prod_id'] proda=request.POST['prod_attribute'] naam=request.POST['name'] maxrp=request.POST['mrp'] sellp=request.POST['sp'] crawl=request.POST['crawl_id'] category=request.POST['cat'] try3=final.objects.filter(crawl_id__exact=request.POST['crawl_id']) if len(try3)==0: save_it=crawl_css.save(commit=False) save_it.save() scroll_first(css,prod, proda, naam, maxrp, sellp, crawl,category) return HttpResponseRedirect('/home/') return render(request,'add.html',{'yd':x,'post':scro,'prod1':prod,'crawl':crawl_css,'exist1':exist})