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