File size: 1,312 Bytes
6ea020b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
# app/models/audit.py
# Audit logging, activity tracking, and archival models.

from typing import Optional
from datetime import datetime
from sqlmodel import SQLModel, Field


class AuditLog(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    table_name: str
    record_id: int
    action: str
    user_id: int = Field(foreign_key="user.id")
    username: str
    old_values: Optional[str] = None
    new_values: Optional[str] = None
    created_at: datetime = Field(default_factory=datetime.now)


class ActivityLog(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    action_type: str = Field(index=True)
    description: str
    target_type: Optional[str] = None
    target_id: Optional[int] = None
    user_id: Optional[int] = Field(default=None, foreign_key="user.id")
    username: Optional[str] = None
    created_at: datetime = Field(default_factory=datetime.now)


class DeletedRecord(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    source_table: str = Field(index=True)
    record_id: int
    record_data: str  # Full JSON snapshot
    deleted_reason: Optional[str] = None
    deleted_by: int = Field(foreign_key="user.id")
    deleted_at: datetime = Field(default_factory=datetime.now)