Skip to content

Speakr is a personal, self-hosted web application designed for transcribing audio recordings

Python
3.4 KB
Raw Blame
"""
SystemSetting model for application configuration.

This module defines the SystemSetting model for storing
dynamic system configuration in the database.
"""

from datetime import datetime
from src.database import db


class SystemSetting(db.Model):
    """Stores system-wide configuration settings."""

    id = db.Column(db.Integer, primary_key=True)
    key = db.Column(db.String(100), unique=True, nullable=False)
    value = db.Column(db.Text, nullable=True)
    description = db.Column(db.Text, nullable=True)
    setting_type = db.Column(db.String(50), nullable=False, default='string')  # string, integer, boolean, float
    created_at = db.Column(db.DateTime, default=datetime.utcnow)
    updated_at = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)

    def to_dict(self):
        """Convert model to dictionary representation."""
        return {
            'id': self.id,
            'key': self.key,
            'value': self.value,
            'description': self.description,
            'setting_type': self.setting_type,
            # ISO 8601 strings (naive UTC) so the frontend parses them the same
            # way as every other timestamp. Returning raw datetimes makes Flask
            # emit RFC-1123 HTTP-date strings, which the client's parser cannot
            # read (it rendered as "Invalid Date").
            'created_at': self.created_at.isoformat() if self.created_at else None,
            'updated_at': self.updated_at.isoformat() if self.updated_at else None
        }

    @staticmethod
    def get_setting(key, default_value=None):
        """Get a system setting value by key, with optional default."""
        setting = SystemSetting.query.filter_by(key=key).first()
        if setting:
            # Convert value based on type
            if setting.setting_type == 'integer':
                try:
                    return int(setting.value) if setting.value is not None else default_value
                except (ValueError, TypeError):
                    return default_value
            elif setting.setting_type == 'boolean':
                return setting.value.lower() in ('true', '1', 'yes') if setting.value else default_value
            elif setting.setting_type == 'float':
                try:
                    return float(setting.value) if setting.value is not None else default_value
                except (ValueError, TypeError):
                    return default_value
            else:  # string
                return setting.value if setting.value is not None else default_value
        return default_value

    @staticmethod
    def set_setting(key, value, description=None, setting_type='string'):
        """Set a system setting value."""
        setting = SystemSetting.query.filter_by(key=key).first()
        if setting:
            setting.value = str(value) if value is not None else None
            setting.updated_at = datetime.utcnow()
            if description:
                setting.description = description
            if setting_type:
                setting.setting_type = setting_type
        else:
            setting = SystemSetting(
                key=key,
                value=str(value) if value is not None else None,
                description=description,
                setting_type=setting_type
            )
            db.session.add(setting)
        db.session.commit()
        return setting