db_interface/WINDOWS_README.md

Windows Setup Instructions

Prerequisites

1. Python 3.8 or higher
2. MariaDB or MySQL server (local or remote)

Installation Steps

1. Install Python

• Download from: https://www.python.org/downloads/
• During installation, check "Add Python to PATH"

2. Setup the Application

Open Command Prompt in the application folder and run:

# Create virtual environment
python -m venv venv

# Activate virtual environment
venv\Scripts\activate

# Install dependencies
pip install -r requirements.txt

3. Database Setup (if using local database)

• Install MariaDB or MySQL
• Run the setup script:

  mysql -u root -p < setup_user.sql
  

4. Run the Application

Option A: Using the batch file

Simply double-click run_app.bat

Option B: Using command line

venv\Scripts\activate
python main.py

Configuration

• Use the Settings button in the app to configure the database server IP address
• Default connection:
  • Host: localhost
  • Database: cantare_injectie
  • User: omron
  • Password: Initial01!

Troubleshooting

Missing modules error

venv\Scripts\activate
pip install -r requirements.txt

Database connection error

• Check if MariaDB/MySQL service is running
• Verify database credentials
• Use Settings button to update server IP address

Kivy installation issues

pip install --upgrade pip
pip install kivy --pre --extra-index-url https://kivy.org/downloads/simple/

Features

• Fullscreen mode: App starts in fullscreen by default
• Search: Enter ID and press Enter
• Add/Update: Click Add/Update button to enable editing
• Delete: Use Delete button in update section
• Reset: Clear all fields with Reset Values button
• Settings: Configure database server IP address

Keyboard Shortcuts

• F11 or Esc: Exit fullscreen
• Enter: Search for ID (when in ID field)