def get_category_data(request):
"""
获取分类菜单的数据
return:
"""
result = {}
try:
cate_list = Category.objects.all()
#轮播图
banners = Banner.qs_to_dict(Banner.objects.all())
#result字典中新增banner属性
result.update(banners=banners)
li = []
for cate in cate_list:
#select * from categorysub where cid=60,关联查询
#利用外键关联, 查询子菜单数据
sub_list = Categorysub.objects.filter(cid=cate.id)
#将queryset对象转化成列表套字典的数据类型
cate.subs = Category.qs_to_dict(sub_list)
temp = cate.to_dict()
li.append(temp)
result.update(state=200, msg='success', data=li)
except:
#拼接数据
result.update(state=404, msg="查询失败")
return HttpResponse(json.dumps(result), content_type='Application/json')
def get_context_data(self, *, object_list=None, **kwargs):
context = super(HomeView, self).get_context_data(object_list=None,
**kwargs)
if 'slug' in self.kwargs:
context['slug'] = self.kwargs['slug']
context['default_categories'] = Category.get_default_category_names()
context['shared_child'] = "shared_child"
context['logged_user'] = self.request.user.pk
obj = Child.objects.filter(pk=self.kwargs['pk']).first()
context['chosen_child'] = obj
sections = Section.objects.filter(child=obj).order_by('pk')
context['chosen_child_sections'] = sections
photo = Photo.objects.filter(child=obj).first()
context['chosen_child_photo'] = photo
size_filter = SharedSizeFilter.objects.filter(
child=obj, user=self.request.user.pk).first()
context['size_filter'] = size_filter
if obj is not None and obj.age is None:
context['not_born_yet'] = True
else:
context['not_born_yet'] = False
return context
def import_categories(self, reader):
self.stdout.write(self.style.SUCCESS("Importing categories"))
Category.objects.bulk_create(
Category(title=row["category"], color=row["color"])
for row in reader)
self.stdout.write(self.style.SUCCESS("Categories imported"))
def post(self):
err = CategorySchema().validate(request.json)
if err:
return err
category = Category.create(**request.get_json())
category.reload()
return CategorySchema().dump(category)
def get_category_data(reqeust):
"""
获取分类菜单的数据
:return:
"""
result = {}
try:
cate_list = Category.objects.all()
banners = Banner.qs_to_dict(Banner.objects.all())
result.update(banners=banners)
li = []
for cate in cate_list:
# select * from categorysub where cid=60
# 获取一级菜单对应的二级菜单的数据 [cate_sub]
sub_list = CategorySub.objects.filter(cid=cate.id)
# 将queryset对象转化成 列表套字典
cate.subs = Category.qs_to_dict(sub_list)
li.append(cate.to_dict())
result.update(state=200, msg='success', data=li)
except:
result.update(state=200, msg='查询失败')
return HttpResponse(json.dumps(result), content_type='Application/json')
def category(request):
s = request.session.get('users_id', None)
if not s:
return HttpResponseRedirect('/auth')
if request.method == 'POST':
form = CategoryForm(request.POST)
if form.is_valid():
newdoc = Category()
newdoc.users_id = request.POST['users']
newdoc.name = request.POST['name']
newdoc.description = request.POST['description']
request.session['users_id'] = newdoc.users_id
newdoc.save()
return HttpResponseRedirect('/category')
else:
form = CategoryForm()
categorys = Category.objects.all()
return render_to_response('home/category.html', {
'categorys': categorys,
'form': form
},
context_instance=RequestContext(request))
def category(request):
s = request.session.get('users_id', None)
if not s:
return HttpResponseRedirect('/auth')
if request.method == 'POST':
form = CategoryForm(request.POST)
if form.is_valid():
newdoc = Category()
newdoc.users_id = request.POST['users']
newdoc.name = request.POST['name']
newdoc.description = request.POST['description']
request.session['users_id'] = newdoc.users_id
newdoc.save()
return HttpResponseRedirect('/category')
else:
form = CategoryForm()
categorys = Category.objects.all()
return render_to_response(
'home/category.html',
{'categorys': categorys, 'form': form},
context_instance=RequestContext(request)
)
fh = open('whc-sites-2018-small.csv')
rows = csv.reader(fh)
next(rows, None)
Site.objects.all().delete()
Category.objects.all().delete()
Iso.objects.all().delete()
Region.objects.all().delete()
States.objects.all().delete()
for row in rows:
try:
c = Category.objects.get(name=row[7])
except:
print("Inserting category", row[7])
c = Category(name=row[7])
c.save()
try:
i = Iso.objects.get(name=row[10])
except:
print("Inserting iso", row[10])
i = Iso(name=row[10])
i.save()
try:
r = Region.objects.get(name=row[9])
except:
print("Inserting region", row[9])
r = Region(name=row[9])
r.save()
def get(self):
categories = Category.objects()
return CategorySchema().dump(categories, many=True)
def delete(self):
category = Category.objects(id=request.get_json()["id"])
category.delete()
return CategorySchema().dump(category)
def add_category(self, cat):
new_cat = Category(name=cat)
new_cat.save()