Rietveld Code Review Tool
Help | Bug tracker | Discussion group | Source code

Side by Side Diff: sitescripts/reports/bin/removeOldReports.py

Issue 29569566: Noissue - Replace flake8-putty with flake8-per-file-ignores, update to flake8 3 (sitescripts) (Closed)
Patch Set: Created Oct. 8, 2017, 6:02 p.m.
Left:
Right:
Use n/p to move between diff chunks; N/P to move between comments.
Jump to:
View unified diff | Download patch
« no previous file with comments | « sitescripts/reports/bin/processReports.py ('k') | sitescripts/reports/bin/removeOldUsers.py » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
1 # This file is part of the Adblock Plus web scripts, 1 # This file is part of the Adblock Plus web scripts,
2 # Copyright (C) 2006-present eyeo GmbH 2 # Copyright (C) 2006-present eyeo GmbH
3 # 3 #
4 # Adblock Plus is free software: you can redistribute it and/or modify 4 # Adblock Plus is free software: you can redistribute it and/or modify
5 # it under the terms of the GNU General Public License version 3 as 5 # it under the terms of the GNU General Public License version 3 as
6 # published by the Free Software Foundation. 6 # published by the Free Software Foundation.
7 # 7 #
8 # Adblock Plus is distributed in the hope that it will be useful, 8 # Adblock Plus is distributed in the hope that it will be useful,
9 # but WITHOUT ANY WARRANTY; without even the implied warranty of 9 # but WITHOUT ANY WARRANTY; without even the implied warranty of
10 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 10 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
11 # GNU General Public License for more details. 11 # GNU General Public License for more details.
12 # 12 #
13 # You should have received a copy of the GNU General Public License 13 # You should have received a copy of the GNU General Public License
14 # along with Adblock Plus. If not, see <http://www.gnu.org/licenses/>. 14 # along with Adblock Plus. If not, see <http://www.gnu.org/licenses/>.
15 15
16 import MySQLdb 16 import MySQLdb
17 from sitescripts.utils import setupStderr 17 from sitescripts.utils import setupStderr
18 from sitescripts.reports.utils import get_db, executeQuery, removeReport 18 from sitescripts.reports.utils import get_db, executeQuery, removeReport
19 19
20 20
21 def removeOldReports(days=30): 21 def removeOldReports(days=30):
22 cursor = get_db().cursor(MySQLdb.cursors.DictCursor) 22 cursor = get_db().cursor(MySQLdb.cursors.DictCursor)
23 executeQuery(cursor, 'SELECT guid FROM #PFX#reports WHERE ADDDATE(ctime, INT ERVAL %s DAY) < NOW()', days) 23 executeQuery(cursor, 'SELECT guid FROM #PFX#reports WHERE ADDDATE(ctime, INT ERVAL %s DAY) < NOW()', days)
24 for report in cursor: 24 for report in cursor:
25 removeReport(report['guid']) 25 removeReport(report['guid'])
26 26
27
27 if __name__ == '__main__': 28 if __name__ == '__main__':
28 setupStderr() 29 setupStderr()
29 removeOldReports() 30 removeOldReports()
OLDNEW
« no previous file with comments | « sitescripts/reports/bin/processReports.py ('k') | sitescripts/reports/bin/removeOldUsers.py » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld