Backup

Database backup

Django shell commands

Backup the entire database:

python manage.py dumpdata > backup.json

Backup only a selected model:

python manage.py dumpdata app_fossils.DBSpecies > backup.json

Restore backup

python manage.py loaddata backup.json

---

PDF

views.py

@login_required
def print_pdf(request):
    fossils = DBFossil.objects.filter(fossil_owner=request.user)
    return render(request, "app_fossils/print_pdf.html", {"fossils": fossils})

urls.py

path('print_pdf/', print_pdf, name='print-pdf'),

Templates: print_pdf.html (remember to use base_clean.html)

{% extends 'base_clean.html' %}
{% block title %} Print PDF {% endblock %}
{% load static %}
{% block content %}

<h1 class="container text-center">Fossils</h1>

<table class="table">
    <thead>
        <tr>
        <th scope="col">Name</th>
        <th scope="col">Age</th>
        <th scope="col">Value</th>
        </tr>
    </thead>
    <tbody>
        {% for fossil in fossils %}
            <tr>
                <td>{{ fossil.fossil_name }}</td>
                <td>{{ fossil.fossil_age_mln }}</td>
                <td>{{ fossil.fossil_value|default:'' }}</td>
            </tr>
        {% endfor %}
    </tbody>
    </table>

{% endblock %}

---

CSV

views.py

import csv
from django.http import HttpResponse

@login_required
def print_csv(request):
    fossils = DBFossil.objects.filter(fossil_owner=request.user)
    response = HttpResponse(content_type='text/csv')
    response['Content-Disposition'] = 'attachment; filename="mymodel.csv"'
    writer = csv.writer(response)
    writer.writerow(['Name', 'Age', 'Value'])
    for obj in fossils:
        writer.writerow([obj.fossil_name, obj.fossil_age_mln, obj.fossil_value])
    return response

urls.py

path('print_csv/', print_csv, name='print-csv'),

---

Word

Installation

pip install python-docx

views.py

from docx import Document
from io import BytesIO
from docx.enum.text import WD_ALIGN_PARAGRAPH
from docx.shared import Pt, Mm
from docx.enum.style import WD_STYLE_TYPE
from django.utils.html import strip_tags
from docx.shared import RGBColor
import io

@login_required
def print_word(request):
    def print_fossil(selected_fossil):
        print(selected_fossil)
        fossil_name_text = document.add_paragraph(f'{selected_fossil.fossil_name}', style='title_style')
        fossil_name_text.paragraph_format.space_before = Pt(10)
        fossil_name_text.paragraph_format.space_after = Pt(0)
        fossil_name_text.alignment = WD_ALIGN_PARAGRAPH.CENTER

        table_age_value = document.add_table(rows=2, cols=2)
        header_cells = table_age_value.rows[0].cells
        header_cells[0].text = f'Age'
        header_cells[0].paragraphs[0].style='big_header_style'
        header_cells[0].paragraphs[0].paragraph_format.alignment = WD_ALIGN_PARAGRAPH.CENTER
        header_cells[0].paragraphs[0].paragraph_format.space_before = Pt(0)
        header_cells[0].paragraphs[0].paragraph_format.space_after = Pt(10)
        header_cells[1].text = f'Value'
        header_cells[1].paragraphs[0].style='big_header_style'
        header_cells[1].paragraphs[0].paragraph_format.alignment = WD_ALIGN_PARAGRAPH.CENTER
        header_cells[1].paragraphs[0].paragraph_format.space_before = Pt(0)
        header_cells[1].paragraphs[0].paragraph_format.space_after = Pt(10)

        address_cells = table_age_value.rows[1].cells
        add_age = '-'
        if selected_fossil.fossil_age_mln:
            add_age = selected_fossil.fossil_age_mln
        address_cells[0].text = add_age
        address_cells[0].paragraphs[0].style='normal_style'
        address_cells[0].paragraphs[0].paragraph_format.alignment = WD_ALIGN_PARAGRAPH.CENTER
        address_cells[0].paragraphs[0].paragraph_format.space_before = Pt(0)
        address_cells[0].paragraphs[0].paragraph_format.space_after = Pt(0)
        add_value = '-'

        if selected_fossil.fossil_value:
            add_value = str(selected_fossil.fossil_value)
        address_cells[1].text = add_value
        address_cells[1].paragraphs[0].style='normal_style'
        address_cells[1].paragraphs[0].paragraph_format.alignment = WD_ALIGN_PARAGRAPH.CENTER
        address_cells[1].paragraphs[0].paragraph_format.space_before = Pt(0)
        address_cells[1].paragraphs[0].paragraph_format.space_after = Pt(0)

        if selected_fossil.fossil_description_short:
            tx = re.sub('[\t]+', ' ', strip_tags(selected_fossil.fossil_description_short))
            tx.replace('\n ', '\n').strip()
            note_par = document.add_paragraph('', style='normal_style')
            note_par.add_run(f'Note: ').bold=True
            note_par.add_run(f'{tx}').bold=False
            note_par.paragraph_format.space_before = Pt(5)
            note_par.paragraph_format.space_after = Pt(0)

        separator_line = document.add_paragraph('________________________________________________________________________________________________________________', style='normal_style')
        separator_line.alignment = WD_ALIGN_PARAGRAPH.CENTER


    fossils = DBFossil.objects.filter(fossil_owner=request.user)
    document = Document()

    section = document.sections[0]
    section.page_height = Mm(297)
    section.page_width = Mm(210)
    section.left_margin = Mm(5)
    section.right_margin = Mm(5)
    section.top_margin = Mm(5)
    section.bottom_margin = Mm(5)
    section.header_distance = Mm(0)
    section.footer_distance = Mm(0)

    style = document.styles['Normal']
    font = style.font
    font.name = 'Times New Roman'
    font.size = Pt(9)
    styles = document.styles

    style_title = styles.add_style('title_style', WD_STYLE_TYPE.PARAGRAPH)
    font_style_title = style_title.font
    font.name = 'Times New Roman'
    font_style_title.size = Pt(18)
    font_style_title.color.rgb = RGBColor(56, 118, 29)
    font_style_title.bold = True

    style_big_header = styles.add_style('big_header_style', WD_STYLE_TYPE.PARAGRAPH)
    font_style_big_header = style_big_header.font
    font_style_big_header.name = 'Times New Roman'
    font_style_big_header.size = Pt(14)
    font_style_big_header.bold = True

    style_normal = styles.add_style('normal_style', WD_STYLE_TYPE.PARAGRAPH)
    font_style_normal = style_normal.font
    font_style_normal.name = 'Times New Roman'
    font_style_normal.size = Pt(10)
    font_style_normal.bold = False

    for fossil in fossils:
        print_fossil(fossil)

    docx_title = f'Fossils.docx'
    doc_file = io.BytesIO()
    document.save(doc_file)
    length = doc_file.tell()
    doc_file.seek(0)
    response = HttpResponse(doc_file.getvalue(), content_type='application/vnd.openxmlformats-officedocument.wordprocessingml.document')
    response['Content-Disposition'] = 'attachment; filename=' + docx_title
    response['Content-Length'] = length
    return response

urls.py

path('print_word/', print_word, name='print-word'),