training_01: CSV output

[Kaito-a-bit]

• 現状

  • リストのルーティング→book/book_list.htmlに変更
  • htmlの実装はまだ

• これから

  • リスト作る
  • exportボタン配置
  • csvダウンロードの関数作成

[Kaito-a-bit]

• 参考
  • Django、CSVのインポート・エクスポート

[Kaito-a-bit]

def csv_export(request):
    response = HttpResponse(content_type='text/csv')
    response['Content-Disposition'] = 'attachment; filename="books.csv"'
    writer = csv.writer(response)
    for book in Book.objects.all():
        row = [author for author in book.objects.all()]
        for author in book.coauthors.all():
            row.append(author.username)
        strAuthors = " ".join(row)
        writer.writerow([book.id, book.name, book.publisher.name, strAuthors, book.published_date])
    return response

短くする

def csv_export(request):
    response = HttpResponse(content_type='text/csv')
    response['Content-Disposition'] = 'attachment; filename="books.csv"'
    writer = csv.writer(response)
    for book in Book.objects.all():
        strAuthors = " ".join([author.username for author in book.coauthors.all()])
        writer.writerow([book.id, book.name, book.publisher.name, strAuthors, book.published_date])
    return response

参考: Djangoのクエリセットから値を取得する方法