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})
