Repository navigation
Expand file tree
/
Copy pathpdf_export.py
More file actions
193 lines (167 loc) · 6.42 KB
/
Copy pathpdf_export.py
File metadata and controls
193 lines (167 loc) · 6.42 KB
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
import os
import tempfile
from datetime import datetime
from typing import List, Dict, Any, Optional
from xml.sax.saxutils import escape
from reportlab.lib.pagesizes import letter
from reportlab.lib import colors
from reportlab.lib.styles import getSampleStyleSheet, ParagraphStyle
from reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer, Table, TableStyle
from database import get_session
from models import Conversation, Message, User
from sqlalchemy.orm import joinedload
def get_conversation(conversation_id: int, requesting_user_id: Optional[int] = None, allow_admin_access: bool = False) -> Optional[Conversation]:
"""Get conversation details from the database"""
session = get_session()
if not session:
return None
try:
query = session.query(Conversation).options(
joinedload(Conversation.messages).joinedload(Message.files)
).filter(Conversation.id == conversation_id)
if requesting_user_id is not None and not allow_admin_access:
query = query.filter(Conversation.user_id == requesting_user_id)
conversation = query.first()
if not conversation:
return None
return {
"id": conversation.id,
"user_id": conversation.user_id,
"title": conversation.title,
"created_at": conversation.created_at,
"updated_at": conversation.updated_at,
"messages": [
{
"role": message.role,
"content": message.content,
"files": [
{
"original_name": file.original_name,
"mime_type": file.mime_type,
}
for file in message.files
],
}
for message in conversation.messages
],
}
finally:
session.close()
def get_user(user_id: int) -> Optional[User]:
"""Get user details from the database"""
session = get_session()
if not session:
return None
try:
user = session.query(User).filter(User.id == user_id).first()
if not user:
return None
return {"id": user.id, "username": user.username}
finally:
session.close()
def export_conversation_to_pdf(conversation_id: int, requesting_user_id: Optional[int] = None, allow_admin_access: bool = False) -> str:
"""
Export a conversation to PDF
Args:
conversation_id: ID of the conversation to export
Returns:
Path to the generated PDF file
"""
# Get conversation details
conversation = get_conversation(
conversation_id,
requesting_user_id=requesting_user_id,
allow_admin_access=allow_admin_access
)
if not conversation:
raise ValueError(f"Conversation with ID {conversation_id} not found")
# Get user details
user = get_user(conversation["user_id"])
if not user:
raise ValueError(f"User with ID {conversation['user_id']} not found")
# Create temporary file
temp_dir = tempfile.gettempdir()
pdf_filename = f"conversation_{conversation_id}_{datetime.now().strftime('%Y%m%d_%H%M%S')}.pdf"
pdf_path = os.path.join(temp_dir, pdf_filename)
# Create PDF document
doc = SimpleDocTemplate(
pdf_path,
pagesize=letter,
rightMargin=72,
leftMargin=72,
topMargin=72,
bottomMargin=72
)
# Get styles
styles = getSampleStyleSheet()
title_style = styles["Title"]
heading_style = styles["Heading2"]
normal_style = styles["Normal"]
# Create custom styles
user_message_style = ParagraphStyle(
"UserMessage",
parent=normal_style,
fontName="Helvetica-Bold",
fontSize=10,
textColor=colors.blue,
spaceBefore=6,
spaceAfter=2
)
assistant_message_style = ParagraphStyle(
"AssistantMessage",
parent=normal_style,
fontName="Helvetica",
fontSize=10,
textColor=colors.black,
spaceBefore=2,
spaceAfter=6,
leftIndent=20
)
# Create document elements
elements = []
# Add title
safe_title = escape(conversation["title"] or "")
elements.append(Paragraph(f"Conversation: {safe_title}", title_style))
elements.append(Spacer(1, 12))
# Add metadata
metadata = [
["Username:", escape(user["username"] or "")],
["Created:", conversation["created_at"].strftime("%Y-%m-%d %H:%M:%S")],
["Updated:", conversation["updated_at"].strftime("%Y-%m-%d %H:%M:%S")]
]
# Create metadata table
metadata_table = Table(metadata, colWidths=[100, 300])
metadata_table.setStyle(TableStyle([
('FONT', (0, 0), (-1, -1), 'Helvetica'),
('FONT', (0, 0), (0, -1), 'Helvetica-Bold'),
('VALIGN', (0, 0), (-1, -1), 'MIDDLE'),
('GRID', (0, 0), (-1, -1), 0.25, colors.gray),
('BACKGROUND', (0, 0), (0, -1), colors.lightgrey)
]))
elements.append(metadata_table)
elements.append(Spacer(1, 24))
# Add messages
elements.append(Paragraph("Conversation", heading_style))
elements.append(Spacer(1, 12))
for message in conversation["messages"]:
if message["role"] == "user":
elements.append(Paragraph(f"User:", user_message_style))
elements.append(Paragraph(escape(message["content"] or ""), normal_style))
# Add files if any
if message["files"]:
for file in message["files"]:
elements.append(Paragraph(f"File: {escape(file['original_name'] or '')} ({escape(file['mime_type'] or '')})",
ParagraphStyle(
"FileInfo",
parent=normal_style,
fontSize=8,
textColor=colors.gray,
leftIndent=10
)))
else:
elements.append(Paragraph(f"Assistant:", assistant_message_style))
elements.append(Paragraph(escape(message["content"] or ""), normal_style))
elements.append(Spacer(1, 6))
# Build PDF
doc.build(elements)
return pdf_path