This project provides a static site generator for kleineAnfragen.de based on flask that tries to replicate all urls, except search, email notifications, api and reporting.

Download a database dump from https://kleineanfragen.de/info/daten and import it into a locally running postgres.

Install stuff with pip install -r requirements.txt

Run development server with DATABASE_URL='postgres:https://user@localhost/kleineanfragen' FLASK_DEBUG=1 python app.py

Create static pages with python freeze.py

This project exists, because kleineAnfragen.de is going to sleep soon. Because I want to be a nice internet citizen, I'll try to respect Cool URIs don't change and want to make preperations to put all the stuff into the Internet Archive.

The first draft of this code uses database access with the available database dumps. For a later iteration it would be interesting to try if this could be replaced by consuming the OParl API of kleineAnfragen. This would make the project reusable and maybe even interesting for civic tech people and municipalities that want to replace the UI of their OParl compatible system.

Things that cannot be done with a static site generator, like search and the email notification and report forms are out of scope for this project. Returning 501 Not Implemented is fine for these urls.