Python Test App

Test Application Codebase Summary

Overview

This project is a robust web application for managing and taking tests, built with Flask and integrated with Azure services. It features user authentication, test creation and management, and detailed performance tracking.

Key Components

1. Main Application (app.py)

The core of the application, handling routing and business logic.

Key features:

Flask application setup
Route definitions for various functionalities
Integration with Azure AD for authentication

Example snippet (sanitized):


@app.route('/dashboard')
def dashboard():
    user_id = flask_session.get('user_id')
    username = flask_session.get('user', {}).get('name')
    if not user_id:
        return redirect(url_for('login'))
    return render_template('dashboard.html', user_id=user_id, username=username)

2. Configuration Management

Utilizes Azure Key Vault for secure configuration management.

Example (sanitized):


from azure.identity import DefaultAzureCredential
from azure.keyvault.secrets import SecretClient

KEY_VAULT_URL = "https://[key-vault-name].vault.azure.net/"
secret_client = SecretClient(vault_url=KEY_VAULT_URL, credential=DefaultAzureCredential())

def get_secret(secret_name):
    return secret_client.get_secret(secret_name).value

3. Database Operations

Handles all database interactions using SQLAlchemy.

Key features:

User management
Test creation and retrieval
Performance tracking

Example snippet:


def get_test_questions(category, num_questions, sub_category=None):
    session = Session()
    try:
        query = session.query(Question).filter_by(Category=category)
        if sub_category:
            query = query.filter_by(sub_category=sub_category)
        questions = query.all()
        random.shuffle(questions)
        return questions[:num_questions]
    finally:
        session.close()

4. Data Models

Defines SQLAlchemy models for the application's data structure.

Example model:


class Test(Base):
    __tablename__ = 'Tests'
    TestID = Column(Integer, primary_key=True, autoincrement=True)
    UserID = Column(Integer, ForeignKey('Users.UserID'))
    TotalQuestions = Column(Integer)
    TestDateTime = Column(DateTime)
    TotalScore = Column(DECIMAL)
    Duration = Column(Integer)
    CompletionStatus = Column(String)

5. Frontend

Utilizes HTML templates, CSS, and JavaScript for a responsive user interface.

Key features:

Dynamic content loading with AJAX
Interactive test-taking interface
Data visualization for test results

JavaScript snippet:


function submitTest() {
    const testData = collectTestData();
    fetch('/submit_test', {
        method: 'POST',
        headers: { 'Content-Type': 'application/json' },
        body: JSON.stringify(testData)
    })
    .then(response => response.json())
    .then(data => displayResults(data))
    .catch(error => console.error('Error:', error));
}