katicas 0.2.1

Шаблоны Python-приложений для демонстрационного экзамена: PostgreSQL, Tkinter, авторизация, CRUD.

katicas

katicas 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.
• Import helper for official exam .xlsx, .csv and .txt files.
• 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.

Each generated project also contains:

• 00_START_HERE_FOR_BEGINNER.md - beginner-friendly full workflow.
• 01_ALGORITHM.md - step-by-step exam workflow.
• 02_DATABASE_3NF.md - database and 3NF checklist.
• 03_AUTH.md - login window and role checklist.
• 04_IMPORT_EXCEL.md - Excel/CSV import checklist.
• 05_DB_CONNECTION.md - PostgreSQL connection checklist.
• 06_MODELS.md - models, entities and fields.
• 07_PAGES_TRANSITIONS.md - screens and navigation.
• 08_ROLE_PAGES.md - what guest/client/manager/admin see.
• 09_MODULES_MAP.md - where every module lives.
• 10_FINAL_CHECKLIST.md - final submission checklist.
• 11_FLOWCHARTS.md - flowchart templates for auth, CRUD, import and app logic.
• 12_ER_DIAGRAM.md - ER diagram checklist.
• 13_STYLE_ASSETS.md - style, logo, icon and images.
• 14_SEARCH_FILTER_SORT.md - search, filter and sort.
• 15_VALIDATION_ERRORS.md - validation and user messages.
• 16_ORDERS.md - order module checklist.
• 17_TESTING_SCREENSHOTS.md - testing and screenshot checklist.
• 18_DELIVERABLES.md - files to submit.
• 19_REQUIREMENTS_COVERAGE.md - requirement-to-guide coverage map.

Install locally while testing

pip install -e .

After publishing to PyPI:

pip install katicas

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

Then import official exam files from the Импорт folder:

python app.py --import-dir "Импорт"

The generated schema.sql does not add fake business rows. If you need quick demo rows for local testing only:

python app.py --print-sql --with-sample-data

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

pip uninstall katicas -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.