Skip to content

ServerKit is a lightweight, modern server control panel for managing web applications, databases, and services on your VPS or dedicated server. Built with Python/Flask backend and React frontend.

2.0 KB
Raw Blame
"""
Environment Activity Model

Audit log for all environment actions (create, deploy, promote, lock, etc.).
Tracks who did what, when, and how long it took.
"""

from datetime import datetime
from app import db
from app.models.json_column_mixin import JsonColumnMixin


class EnvironmentActivity(JsonColumnMixin, db.Model):
    """Audit log for environment actions."""

    __tablename__ = 'environment_activities'

    id = db.Column(db.Integer, primary_key=True)
    site_id = db.Column(db.Integer, db.ForeignKey('wordpress_sites.id'), nullable=False, index=True)
    user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=True, index=True)

    # Action details
    action = db.Column(db.String(50), nullable=False)  # create, deploy, promote, lock, unlock, destroy
    description = db.Column(db.Text)
    activity_metadata = db.Column('metadata', db.Text)  # JSON

    # Result
    status = db.Column(db.String(20), default='completed')  # pending, running, completed, failed
    error_message = db.Column(db.Text)
    duration_seconds = db.Column(db.Float)

    # Timestamps
    created_at = db.Column(db.DateTime, default=datetime.utcnow)

    # Relationships
    site = db.relationship('WordPressSite', backref=db.backref('activities', lazy='dynamic'))
    user = db.relationship('User', backref=db.backref('environment_activities', lazy='dynamic'))

    def to_dict(self):
        return {
            'id': self.id,
            'site_id': self.site_id,
            'user_id': self.user_id,
            'action': self.action,
            'description': self.description,
            'metadata': self._json_read('activity_metadata', None),
            'status': self.status,
            'error_message': self.error_message,
            'duration_seconds': self.duration_seconds,
            'created_at': self.created_at.isoformat() if self.created_at else None,
        }

    def __repr__(self):
        return f'<EnvironmentActivity {self.id} {self.action} site={self.site_id}>'