开发笔记 -梁琳苑.md · wan/django-restframework-test

# 开发笔记 -梁琳苑

## bug修复

- #### 下载文件并打开检查，发现serializes.py中BookReadSerializer类下方有红色波浪线

解决办法：将CategorySerializer类代码移动到BookReadSerializer之前

- #### 浏览器访问books时，报错：__str__ returned non-string(type None Type)

解决方法：在 BookWriteSerializer类中添加代码：

```python
category = CategorySerializer()
author = AuthorSerializer()
```

## 功能实现

在views.py创建一个CountAPIView类，以下代码均在该类下完成

1. Total number of books owned

```python
   books = Book.objects.all()
   serializer = BookReadSerializer(books, many=True)
   
   books_count = books.count()
   ```

2. Total cost of all books

```
   for book in books:
   	total_price += books.price
   ```

3. Author with most books

```python
   all_auth = Author.objects.values("id")
           book_authors = Book.objects.values("author_id")
           count = 0
           authors_count = {}
           if book_authors.count() != 0:
               for bauth in book_authors:
                   for auth_id in all_auth:
                       if auth_id['id'] == bauth['author_id']:
                           count += 1
                       else:
                           continue
                       authors_count[auth_id['id']] = count
                   count = 0
               author_max = max(authors_count,key=authors_count.get)
           else:
               author_max = 0
   ```

4. Category with most books

```python
   all_cate = Category.objects.values("id")
   book_cate = Book.objects.values("category_id")
   count2 = 0
   cate_count = {}
   if book_cate.count() != 0:
       for bcate in book_cate:
           for cate in all_cate:
               if cate['id'] == bcate['category_id']:
                   count2 += 1
               else:
                   continue
               cate_count[cate['id']] = count2
           count2 = 0
       category_max = max(cate_count, key=cate_count.get)
   else:
       category_max = 0
   ```

## 待解决bug

- 浏览器访问books，添加数据时报错，数据无法入库

wan/django-restframework-test

简介

发行版

贡献者

近期动态