katicas 0.1.0

Reusable Python templates for demo exam CRUD applications with PostgreSQL and Tkinter.

demexam-kit

demexam-kit is a PyPI-ready helper library for building demo exam desktop apps in Python. It is domain-neutral: the same code can become a shoe store, restaurant, zoo, library, hotel, clinic, or warehouse app by changing a JSON specification.

What it gives you

• PostgreSQL connection helper for pgAdmin-created databases.
• Login by login and password from a users table.
• Role-based access: guest, client, manager, administrator.
• Tkinter UI with required exam-style screens: login, entity list, search, filtering, sorting, CRUD.
• SQL generator for users, roles and your main entities.
• Project generator: demexam-new.

Russian documentation:

• GUIDE_RU.md - detailed usage, exam workflow and PyPI notes.
• MODULES_RU.md - explanation of every module.
• examples/custom_template.json - blank domain template.

Install locally while testing

pip install -e .

After publishing to PyPI:

pip install demexam-kit

Generate an exam project

demexam-new --preset store --out my_exam_app
cd my_exam_app
python app.py

Or use your own domain file:

demexam-new --spec restaurant.json --out restaurant_app

The generated project is standalone: it contains a local examlib folder, so the app does not break after removing the installed generator package.

Database environment variables

set DEMEXAM_DB_NAME=demo_exam
set DEMEXAM_DB_USER=postgres
set DEMEXAM_DB_PASSWORD=postgres
set DEMEXAM_DB_HOST=localhost
set DEMEXAM_DB_PORT=5432

On PowerShell:

$env:DEMEXAM_DB_NAME="demo_exam"
$env:DEMEXAM_DB_USER="postgres"
$env:DEMEXAM_DB_PASSWORD="postgres"

Run generated SQL in pgAdmin first:

python app.py --print-sql

Before leaving the exam computer, if required by the rules:

pip uninstall demexam-kit -y

Do not delete the generated project files you wrote for the solution.

Domain idea

The task changes words, not the architecture:

• Store: products, orders, clients.
• Restaurant: dishes, tables, bookings/orders.
• Zoo: animals, enclosures, visits.
• Library: books, readers, loans.

Change spec.json, keep the code.

Important

No package can guarantee passing an exam by itself. This library is meant to save time on repetitive CRUD, auth, PostgreSQL and Tkinter structure so you can adapt the app quickly to the exact task.