Contact person: Business Client

Phone:Show

Email:Show

Location: Samdari, India

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"PROJECT TITLE

Python + MySQL Desktop Typing Exam Software (Hindi DevLys & English) with Licensing


---

PROJECT DESCRIPTION

We are looking for an experienced Python desktop application developer to build a secure, offline typing examination system suitable for government or institutional use.

This is NOT a web application.
It must be a Windows desktop application developed using Python, with MySQL/MariaDB as the database backend.

The project scope is clearly defined and fixed.
No additional features beyond what is mentioned below.


---

TECHNOLOGY STACK (MANDATORY)

Python 3.10 or higher

Desktop GUI: PyQt5 / PyQt6 / PySide6 (preferred)

Database: MySQL / MariaDB

PDF generation: ReportLab

Licensing & cryptography: cryptography / PyOpenSSL

Packaging: PyInstaller (final EXE)

Application must work fully offline after installation



---

CORE FUNCTIONAL REQUIREMENTS

1. Licensing System (Mandatory)

Application must run only if a valid license file is present

License must be:

Time-bound (valid from / valid to)

Machine-bound (hardware or system hash)


License verification must occur:

On application startup

On admin login

Before starting an exam


License generation tool will be handled separately by the owner

Only license verification logic is required in this project

On invalid or expired license, application must block usage with a clear message



---

2. Exam Type & Typing Rules

Typing exams in:

English

Hindi (DevLys font ONLY)


Hindi typing rules:

DevLys font only

No Unicode handling

No character mapping or normalization

Typed text stored exactly as entered


Typing must be strictly line-by-line

One line visible at a time

Next line unlocks only after current line is completed


Arrow keys must be allowed

Copy/paste must be completely blocked

No quit, stop, cancel, or exit buttons for candidates

Exam ends only when:

Time expires, or

All lines are completed




---

3. Admin Features

Secure admin login with roles:

Super Admin

Admin


One-time installation wizard:

MySQL configuration

Database and table creation

First super-admin creation


Exam management:

Create exam

Set office/department header

Set exam name and exam date

Lock/unlock exam

Start practice test

Start actual exam

Force stop exam


Passage management:

Passages stored as text files

Separate files for:

English practice

English actual

Hindi (DevLys) practice

Hindi (DevLys) actual


Each line in file represents one exam line


Candidate management:

Import candidates via CSV/Excel

Mandatory fields: Roll No, Name, DOB, Language

Upload candidate photo

Edit candidate data before exam only




---

4. Candidate Features

Candidate login using:

Roll number + DOB, or

Roll number + password


Verification screen showing:

Photo

Name

Roll number

Language

Exam name


Candidate can only type

Candidates must NEVER see:

Speed

Accuracy

Errors

Results

Evaluation summary




---

5. Auto-Save & Recovery

Auto-save after each completed line

Save:

Line number

Expected line

Typed line

Keystroke count


Resume support after:

Power failure

Application crash


Resume or terminate decision taken by admin only

No data loss allowed



---

6. PDF Generation (Mandatory)

Candidate-wise PDF must be auto-generated after exam submission

Folder structure must be exactly:


For Hindi:

/exam_pdfs/hindi/YYYY-MM-DD/[login to view URL]

For English:

/exam_pdfs/english/YYYY-MM-DD/[login to view URL]

PDF content:

Admin-defined header (office name, exam name, exam date)

Candidate details

Line-by-line comparison (actual vs typed)


DevLys font must be embedded in Hindi PDFs

PDF must never be visible to candidate

Admin can access PDFs later



---

7. Reporting & Logs

Admin-only reports:

Candidate-wise report

Exam summary report


Export reports to PDF and Excel

Logs must include:

Exam start/stop

Candidate login

Submission time

System activity


Logs must be append-only (no deletion or editing)



---

DELIVERABLES

Complete Python desktop application source code

MySQL database schema

Install/setup wizard

License verification module

Packaged Windows EXE using PyInstaller

Basic usage documentation



---

IMPORTANT NOTES

This is a fixed-scope project

No Unicode Hindi support is allowed

DevLys font support is mandatory

Candidate must not see any result or statistics

Code must be clean, structured, and maintainable



---

HOW TO APPLY

Please apply only if you:

Have experience with Python desktop applications

Have worked with MySQL databases

Understand licensing and cryptographic verification

Can strictly follow specifications without scope creep


In your proposal, please mention:

Relevant experience

Similar projects (if any)

Estimated timeline

Confirmation that you understand DevLys Hindi and line-by-line typing rules." (client-provided description)