Brother PTouch6 using database

The post can be read in English down below, I created this post mostly for myself and my colleagues.

Publishing new post to Mkdocs

There are a few things that needs to be done when you want to update your site, for example upload a new post, or update an existing post. I had some trouble getting back to it after not doing it for a few weeks, so here is a detailed instruction, for myself but also for you.

Deleting the old files

Login to your webserver with for example winscp for filetransfer, or how you transfer your updated files.

Go to the folder that your mkdocs or zensical configuration is in. I have mine installed at '/root/blog/'. Delete the folder named 'site'.

Go to '/var/www/html/' and delete the same folder named 'site'.

Building the site

Open the command line on your webserver, in the site folder where the mkdocs or zensical configuration file is. Go ahead and build the site with the following command.

zensical build

Restarting the site

Run the following command to restart the site.

systemctl restart nginx

Creating a script to update automatically

It's not so much work to do it all manually, but I have noticed that if you update the site multiple times a day, it gets annoying to do and I started to make mistakes after a few hours. So I thought, what if I just automate it. Well, here we are!

The script

First create an upload folder, for the updated files. My upload folder is in the root directory, as seen below. Create the script with the following command.

cd /root/
mkdir upload-blog
nano update-blog.sh

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48

#!/bin/bash

# --- PATHS  ---
UPLOAD_SOURCE="/root/blog-upload"
POSTS_TARGET="/root/blog/docs/blog/posts"
BLOG_FOLDER="/root/blog"
WEB_FOLDER="/var/www/html"

echo -e "\e[32mStart update proces...\e[0m"

# 1. Updating files in /root/blog/docs/posts
# We check what files are in the upload-folder and overwrite these in the posts-folder
if [ -d "$UPLOAD_SOURCE" ] && [ "$(ls -A $UPLOAD_SOURCE)" ]; then
    echo -e "\e[32mUpdating files in $POSTS_TARGET...\e[0m"
    cp -v "$UPLOAD_SOURCE"/* "$POSTS_TARGET/"
else
    echo -e "\e[31mNo new files found in $UPLOAD_SOURCE. Build will stop.\e[0m"
    exit 1
fi

# 2. Removing old 'site' files
echo -e "\e[32mRemoving old site files...\e[0m"
rm -rf "$BLOG_FOLDER/site"
rm -rf "$WEB_FOLDER/site"

# 3. Building new site
echo -e "\e[32mExecuting zensical build...\e[0m"
cd "$BLOG_FOLDER" || exit
zensical build

# 4. Copy newly build site to the web-folder
if [ -d "$BLOG_FOLDER/site" ]; then
    echo -e "\e[32mUploading new site to $WEB_FOLDER...\e[0m"
    cp -r "$BLOG_FOLDER/site" "$WEB_FOLDER/"
else
    echo -e "\e[31mError: The folder $BLOG_FOLDER/site is not created by the build!\e[0m"
    exit 1
fi

# 5. Restart Nginx
echo -e "\e[32mRestarting Nginx...\e[0m"
systemctl restart nginx

# 6. Empty the blog-upload folder
echo -e "\e[32mEmptying the blog-upload folder...\e[0m"
rm -rfv /root/blog-upload/*

echo -e "\e[32mUpdate completed!\e[0m"

chmod +x update-blog.sh

Run the script

If you want to run the script, add your files you want to update to the upload-blog folder and run the following command.

sudo ./update-blog.sh

Installing Docker

Starting

Maybe you have never used docker before, I did (ofcourse). But each time I use it again, I have to lookup how to exactly install it, because there are some commands. Personally I always use docker-compose, why? Because I never need the regular docker. This post will also be my new guide, as I normally use a link from my bookmarks. For this whole post I'm going to assume you have sudo rights.

Installing MkDocs

Starting

This will be my first blog post, and I think it would be suitable to tell you how I installed MkDocs.

First of all make sure you have an environment you will run MkDocs on, maybe a computer with multiple services, or a separate vm/container. I prefer a separate container, so I have made one on my proxmox server. I couldn't find minimum specs so I gave my container: