aboutsummaryrefslogtreecommitdiffstats
path: root/src/acit/pagegenerator.py
blob: 939d00be0399d6933845f4ba75274468ee46436e (about) (plain)
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
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
from cherrypy.process import plugins
import cherrypy

from queue import Queue, Empty
import threading
from collections import Counter, defaultdict

from imap_tools.errors import MailboxFolderSelectError

from .imapplugin import ImapPlugin
from .types import Site
from .db import DBPoolManager

from . import html

class Generator(plugins.SimplePlugin):
	def __init__(self,bus,imap:ImapPlugin,site:Site,dbpool:DBPoolManager):
		plugins.SimplePlugin.__init__(self,bus)

		self.imap=imap
		self.site=site
		self.dbpool=dbpool

		self.queue=Queue()
		self.stopping=threading.Event()
		self.thread=None

		cherrypy.engine.subscribe("regen",self.enqueue_update)
		cherrypy.engine.subscribe("generate::projectpage",self.generate_project_page_dynamically)

		self.statcache:dict[str,Counter]=defaultdict(lambda:Counter())

	def enqueue_update(self,project,bugid):
		self.queue.put((project,bugid),block=True)

	def start(self):
		self.mlog("Starting...")
		self.thread=threading.Thread(target=self.worker)
		self.thread.start()
	
	
	def worker(self):
		"""
		Listens to a queue and calls the page regenerator when requested via the queue.
		Use by putting a tuple `(project,bugid)` in :attr:`queue`
		"""
		threading.current_thread().setName("PageGenerator")
		dolog=True
		while not self.stopping.is_set():
			if dolog and self.queue.empty():
				self.mlog("Ready, waiting for items to enter queue...")
			try:
				proj,bug=self.queue.get(timeout=1)
			except Empty:
				dolog=False
				continue

			#self.mlog("Starting regen for %s/%s"%(proj or "",bug or ""))
			self.generate_page(project=proj,bug=bug)
			dolog=True


	def generate_page(self,project=None,bug=None):
		"Responsible for regenerating pages. Only generates bug pages, forwards any request to generate project pages to that function."
		if not bug and not project:
			return
		if project and not bug:
			return self.generate_project_page(project)

		try:
			bugobj=self.site.getbug(tracker=project,bugid=bug)
			with self.imap.get_MailBox() as mailbox:
				# cd into mailbox folder
				mailbox.folder.set(self.imap.get_bug_folder(mailbox,project,bug))
				pagelimit=25 # confusingly sets the limit on how many emails per page.
				currentpage=""
				pagenr=1
				emailsonpage=0

				from .util import (
					lookahead, # this allows us to detect when we reached the last message in the mailbox
					email2html
					)

				totalemails=mailbox.folder.status()["MESSAGES"] # only used for displaying to user and providing a `last page` link
				#totalemails=30*totalemails # again, for testing purposes
				totalpages=totalemails//pagelimit + min(totalemails%pagelimit,1)
				self.mlog("Generating %d pages from %d emails for %s/%d"%(totalpages,totalemails,project,bug))

				#mails=[i for i in mailbox.fetch()]*30 # DON'T UNCOMMENT, for testing purposes.
				# when using above line, change ``mailbox.fetch()`` below for ``mails``

				for msg, last in lookahead(mailbox.fetch()):
					# block: allow showing bug description
					# show an expandable thing with the original thing at the top of every page
					if emailsonpage==0:
						currentpage+='<details class="bugdesc"'
						if pagenr==1:
							currentpage+=' open'
						currentpage+='><summary>Click to expand bug description</summary>'
						currentpage+=email2html(bugobj.description)
						currentpage+='</details>'
					# end block

					# block: page generation
					currentpage+='<div class="emailheader" id="{n}"><a href="#{n}">#{n}</a> On {date}, {from_} wrote,<br>'.format(
						n=(pagenr-1)*25 +emailsonpage,
						date=msg.date_str,
						from_=msg.from_)
					currentpage+='with Subject: <i>%s</i></div>'%msg.subject
					currentpage+=email2html(msg.text)
					# end block
					emailsonpage+=1

					pageswitcher=''
					if pagenr>=2:
						pageswitcher+='<a href="/%s/%d/1">&lt;&lt;first</a> | '%(project,bug)
					if pagenr>=3:
						pageswitcher+='<a href="/%s/%d/%d">&lt;prev</a> | '%(project,bug,pagenr-1)
					pageswitcher+="[page %d/%d]"%(pagenr,totalpages)
					if totalpages-pagenr>1: # if more than 2 pages left
						pageswitcher+=' | <a href="/%s/%d/%d">next&gt;</a>'%(project,bug,pagenr+1)
					if totalpages-pagenr>0: # if more than 1 pages left
						pageswitcher+=' | <a href="/%s/%d/%d">last&gt;&gt;</a>'%(project,bug,totalpages)

					# block: complete page formatting, register page
					if emailsonpage>=pagelimit or last:

						#first=(pagenr-1)*25
						#jumptos="| jump: "+", ".join([
						#	'<a href="#%d">#%d</a>'%(i,i) for i in range(first, first+emailsonpage+1)
						#	])


						resultingpage=html.mailpage.format(
								emailaddr=self.imap.format_emailaddr(project,bug,subject="RE: "+bugobj.subject),
								subscribe=self.imap.format_emailaddr(project,bug,subject="SUBSCRIBE"),
								status=bugobj.status,
								bugtype=bugobj.type,
								project=project,
								bug=bug,
								subject=bugobj.subject,
								content=currentpage,
								pagenr=pagenr,
								pageswitcher=pageswitcher,
								jumptos=""
								)

						# subblock: register page
						path="%s/%d/%d"%(project,bug,pagenr)
						cherrypy.engine.publish(
							"newpage",
							path=path,
							content=resultingpage
							)
						# also register without page number if first page
						if pagenr==1:
							cherrypy.engine.publish(
								"newpage",
								path="%s/%d"%(project,bug),
								content=resultingpage
								)
						# end subblock

						# reset page-specific trackers
						currentpage=""
						emailsonpage=0
						pagenr+=1
					# end block

		except Exception:
			self.mlog("Error occured generating bug page for %s/%d"%(project,bug),traceback=True)
	
	def generate_project_page_dynamically(self,path='',**kwargs):
		if not path:
			return
		return self.generate_project_page(mailbox=None,proj=path,register=False,**kwargs)

	def generate_project_page(self,proj,register=True,**kwargs):
		from .html import projectpage
		from datetime import datetime, timedelta

		statc=self.statcache[proj]
		if register:
			statc.clear()

		self.mlog("Generating projectpage %s"%proj)
		
		if register:
			with self.imap.get_MailBox() as mailbox:
				self.mlog("Updating statcounter for %s"%proj)
				for folder in mailbox.folder.list(self.imap.get_bug_folder(mailbox,proj)):
					try:
						mailbox.folder.set(folder.name)
						for email in mailbox.fetch():
							statc["total"]+=1
							if email.date>datetime.now(tz=email.date.tzinfo)-timedelta(hours=24):
								statc["today"]+=1
							#self.mlog("%d: %s"%(statc["today"],email.subject))
					except MailboxFolderSelectError:
						pass

		with self.dbpool.get_connection() as conn, conn.cursor() as cur:
			args=[proj]
			extraquery=''
			if kwargs and not register:

				for bugtype in ["bug","patch","discus"]:
					if bugtype in kwargs:
						kwargs.setdefault("types",[]).append(bugtype.upper())
				for status in ["open","closed","reject","upstrm","unconf"]:
					if status in kwargs:
						kwargs.setdefault("status",[]).append(status.upper())

				if 'subject' in kwargs:
					extraquery+="AND LOWER(subject) LIKE LOWER(?)"
					args.append("%"+kwargs["subject"]+"%")
				if 'types' in kwargs:
					extraquery+="AND type IN ("+",".join("?"*len(kwargs["types"]))+")"
					args.extend(kwargs["types"])
				if 'status' in kwargs:
					extraquery+="AND status IN ("+",".join("?"*len(kwargs["status"]))+")"
					args.extend(kwargs["status"])

			filter_subject=kwargs.get("subject","")
			filter_by=kwargs.get("by","")
				
			def default_kws(*keys):
				for key in keys:
					if key in kwargs:
						break
				else:
					for key in keys:
						kwargs[key]="true"

			default_kws("bug","patch","discus")
			filter_bug=kwargs.get("bug")
			filter_patch=kwargs.get("patch")
			filter_discus=kwargs.get("discus")

			default_kws("open","closed","reject","upstrm","unconf")
			filter_open=kwargs.get("open")
			filter_closed=kwargs.get("closed")
			filter_reject=kwargs.get("reject")
			filter_upstrm=kwargs.get("upstrm")
			filter_unconf=kwargs.get("unconf")


			sql="SELECT bugid,subject,status,type FROM bugs WHERE tracker=? "+\
				extraquery+\
				" ORDER BY FIELD(status,'OPEN') DESC"
			#self.mlog(sql,args)

			cur.execute(sql,args)

			tabledata=""

			for id,subject,status,bugtype in cur:
				if register:
					statc[bugtype+status]+=1
					statc[bugtype]+=1

				tabledata+='<tr>'
				tabledata+='<td class="bugnr" id="bugid">%d</td>'%id
				tabledata+='<td id="subject"><a href="/%s/%d">%s</a></td>'%(proj,id,subject)
				tabledata+='<td id="status" class=".status-{status}">{status}</td>'.format(status=status)
				tabledata+='<td id="type">%s</td>'%bugtype
				tabledata+='</tr>'



		result=projectpage.format(
			project=proj,
			emailaddr=self.imap.format_emailaddr(project=proj),
			readme="TODO",

			mailtoday=statc["today"],mailtotal=statc["total"],

			bugstotal=statc["BUG"],
			bugsopen=statc["BUGOPEN"],
			bugsclosed=statc["BUGCLOSED"],

			patchestotal=statc["PATCH"],
			patchesopen=statc["PATCHOPEN"],
			patchesclosed=statc["PATCHCLOSED"],
			patchesrejected=statc["PATCHREJECT"],

			filter_subject=filter_subject,
			filter_by=filter_by,

			filter_bug="checked" if filter_bug else "",
			filter_patch="checked" if filter_patch else "",
			filter_discus="checked" if filter_discus else "",

			filter_open="checked" if filter_open else "",
			filter_closed="checked" if filter_closed else "",
			filter_reject="checked" if filter_reject else "",
			filter_upstrm="checked" if filter_upstrm else "",
			filter_unconf="checked" if filter_unconf else "",

			maillist=tabledata
			)
		if register:
			cherrypy.engine.publish(
				"newpage",
				path=proj,
				content=result,
				regentoken="projectpage"
				)
		else:
			return result
	
	def stop(self):
		if not self.thread or not self.thread.is_alive():
			return
		self.mlog("Signalling stop to page generator")
		self.stopping.set()
		self.thread.join()
		self.mlog("Stopped")

	
	def mlog(self,*msg,**kwargs):
		import traceback
		function=traceback.extract_stack(limit=2)[0].name
		cherrypy.log(context="%s>>REGEN:%s"%(threading.current_thread().name, function), msg=" ".join([str(i) for i in msg]),**kwargs)