我正在嘗試在 Django 中查詢用戶,但仍然每個用戶都可以看到資料庫中的所有資料。我嘗試過使用過濾器、q 物件,但這些都沒有幫助我。
這是我的模型:
class Book(models.Model):
def __str__(self):
return f'{self.bookIdent} - belonging to: {self.user}'
user = models.OneToOneField(User, null=True, on_delete=models.CASCADE)
bookIdent = models.CharField(max_length=255)
bookshelf = models.ForeignKey(BookShelf, default='', on_delete=models.CASCADE)
@classmethod
def total_info(cls):
return cls.objects.aggregate(book_counter=Count('id'))
class Meta:
verbose_name_plural = "Books"
還有我的看法:
@login_required(login_url="/login/")
def index(request):
context = {'segment': 'index'}
html_template = loader.get_template('dashboard.html')
context.update(dict(Book.total_info()))
context['Book'] = set_pagination(request,Book.objects.all().
filter(user=request.user), item_numer=10)
return HttpResponse(html_template.render(context, request))
我想查詢只有圖書類的用戶才能看到他的書。
模板:
<div class="col-xl-3 col-md-6">
<div class="card card-stats">
<div class="card-body">
<div class="row">
<div class="col">
<h5 class="card-title text-uppercase text-muted mb-0">Book quantity:</h5>
<span class="h2 font-weight-bold mb-0">
{{ book_counter|default:0 }}
</span>
</div>
uj5u.com熱心網友回復:
在你的views.py中,你可以做
books = Book.objects.filter(user=request.user)
context['book_counter'] = books.count()
轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/416256.html
標籤:
