328edebe3c
- Optimized delete modal for light/dark modes with modern gradients - Added edit_count tracking to media library with warnings in delete confirmation - Enhanced PlayerEdit model with CASCADE delete on foreign keys - Improved player management page to show latest 3 edited files with image previews - Created new edited_media route and template with full version history - Implemented horizontal expandable cards with two-column layout - Added interactive version selection with thumbnail grid - Included original file in versions list with source badge - Fixed deletion workflow to clean up PlayerEdit records and edited_media folders - Enhanced UI with smooth animations, hover effects, and dark mode support
61 lines
2.7 KiB
Python
61 lines
2.7 KiB
Python
"""Player edit model for tracking media edited on players."""
|
|
from datetime import datetime
|
|
from typing import Optional
|
|
|
|
from app.extensions import db
|
|
|
|
|
|
class PlayerEdit(db.Model):
|
|
"""Player edit model for tracking media files edited on player devices.
|
|
|
|
Attributes:
|
|
id: Primary key
|
|
player_id: Foreign key to player
|
|
content_id: Foreign key to content that was edited
|
|
original_name: Original filename
|
|
new_name: New filename after editing
|
|
version: Edit version number (v1, v2, etc.)
|
|
user: User who made the edit (from player)
|
|
time_of_modification: When the edit was made
|
|
metadata_path: Path to the metadata JSON file
|
|
edited_file_path: Path to the edited file
|
|
created_at: Record creation timestamp
|
|
"""
|
|
__tablename__ = 'player_edit'
|
|
|
|
id = db.Column(db.Integer, primary_key=True)
|
|
player_id = db.Column(db.Integer, db.ForeignKey('player.id', ondelete='CASCADE'), nullable=False, index=True)
|
|
content_id = db.Column(db.Integer, db.ForeignKey('content.id', ondelete='CASCADE'), nullable=False, index=True)
|
|
original_name = db.Column(db.String(255), nullable=False)
|
|
new_name = db.Column(db.String(255), nullable=False)
|
|
version = db.Column(db.Integer, default=1, nullable=False)
|
|
user = db.Column(db.String(255), nullable=True)
|
|
time_of_modification = db.Column(db.DateTime, nullable=True)
|
|
metadata_path = db.Column(db.String(512), nullable=True)
|
|
edited_file_path = db.Column(db.String(512), nullable=False)
|
|
created_at = db.Column(db.DateTime, default=datetime.utcnow, nullable=False, index=True)
|
|
|
|
# Relationships
|
|
player = db.relationship('Player', backref=db.backref('edits', lazy='dynamic', cascade='all, delete-orphan'))
|
|
content = db.relationship('Content', backref=db.backref('edits', lazy='dynamic', cascade='all, delete-orphan'))
|
|
|
|
def __repr__(self) -> str:
|
|
"""String representation of PlayerEdit."""
|
|
return f'<PlayerEdit {self.original_name} v{self.version} by {self.user or "unknown"}>'
|
|
|
|
def to_dict(self) -> dict:
|
|
"""Convert to dictionary for API responses."""
|
|
return {
|
|
'id': self.id,
|
|
'player_id': self.player_id,
|
|
'player_name': self.player.name if self.player else None,
|
|
'content_id': self.content_id,
|
|
'original_name': self.original_name,
|
|
'new_name': self.new_name,
|
|
'version': self.version,
|
|
'user': self.user,
|
|
'time_of_modification': self.time_of_modification.isoformat() if self.time_of_modification else None,
|
|
'created_at': self.created_at.isoformat() if self.created_at else None,
|
|
'edited_file_path': self.edited_file_path
|
|
}
|