sitescripts/reports/utils.py - Issue 5694484511719424: Issue 1569 - Issue report digest update is inefficient

Keyboard Shortcuts

	File
u :	up to issue
m :	publish + mail comments
M :	edit review message
j / k :	jump to file after / before current file
J / K :	jump to next file with a comment after / before current file
	Side-by-side diff
i :	toggle intra-line diffs
e :	expand all comments
c :	collapse all comments
s :	toggle showing all comments
n / p :	next / previous diff chunk or comment
N / P :	next / previous comment
<Up> / <Down> :	next / previous line
<Enter> :	respond to / edit current comment
d :	mark current comment as done

	Issue
u :	up to list of issues
m :	publish + mail comments
j / k :	jump to patch after / before current patch
o / <Enter> :	open current patch in side-by-side view
i :	open current patch in unified diff view

	Issue List
j / k :	jump to issue after / before current issue
o / <Enter> :	open current issue
# :	close issue

	Comment/message editing
<Ctrl> + s or <Ctrl> + Enter :	save comment
<Esc> :	cancel edit

Unified Diff: sitescripts/reports/utils.py

Issue 5694484511719424: Issue 1569 - Issue report digest update is inefficient (Closed)

Patch Set: Created Nov. 13, 2014, 8:14 p.m.

Use n/p to move between diff chunks; N/P to move between comments.

Jump to:

Index: sitescripts/reports/utils.py

===================================================================

--- a/sitescripts/reports/utils.py

+++ b/sitescripts/reports/utils.py

@@ -25,17 +25,17 @@ def getReportSubscriptions(guid):

#PFX#subscriptions ON (#PFX#sublists.list = #PFX#subscriptions.id)

WHERE report = %s''',

(guid))

rows = cursor.fetchall()

cursor.close()

return rows

def getReports(startTime):

- count = 1000

+ count = 10000

offset = 0

while True:

cursor = get_db().cursor(MySQLdb.cursors.DictCursor)

executeQuery(cursor,

'''SELECT guid, type, UNIX_TIMESTAMP(ctime) AS ctime, status, site, contact,

comment, hasscreenshot, knownissues

FROM #PFX#reports WHERE ctime >= FROM_UNIXTIME(%s) LIMIT %s OFFSET %s''',

(startTime, count, offset))

« no previous file with comments | « no previous file | no next file » | no next file with comments »