Releases · KartoffelCheetah/personal-website-001

Major update because previous databases will be incompatible.
Some changes on the front-end and a ton on the back-end:

Reworked paths so the system as a whole will be more logical and easily manageable.
This means URL inside database changed. They do not contain the repeatable information like /img/drawings,/img/photos.
Added function to delete database
It's in reality just a rename so, it wont delete the actual database.
(os.rename, it's a good idea to do so before doing the update, if you want to regenerate the whole db).
Database now contains the resolution of the images after the orientation.
Photos/drawings and the background now got low res or blurred versions which can preload before the high-res image.
Some parts of the sqlite3 code were rewritten to use row_factories instead of tuples.
It made Jinja2 templates much clearer as well.

Unless you want to update every row manually, you have to regenerate the whole db.
Do this in the following way:

generate staging file from old database
delete or rename the old database (you can use the function in main.py)
important to edit the urls in staging_file.json in the following way:
3.1. replace all /img/photos/ and /img/drawings/ statement with nothing. Ex:/img/photos/a.jpg -> a.jpg
most text editor has replace all functionality that could be useful for this
create database
use staging file
done!

Note: if you get an error message similar to permission denied to mkdir into root that means you did not changed all urls in staging file.

Provide feedback