| OLD | NEW |
| 1 # coding: utf-8 | |
| 2 | |
| 3 # This file is part of the Adblock Plus web scripts, | 1 # This file is part of the Adblock Plus web scripts, |
| 4 # Copyright (C) 2006-2016 Eyeo GmbH | 2 # Copyright (C) 2006-2016 Eyeo GmbH |
| 5 # | 3 # |
| 6 # 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 |
| 7 # 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 |
| 8 # published by the Free Software Foundation. | 6 # published by the Free Software Foundation. |
| 9 # | 7 # |
| 10 # 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, |
| 11 # but WITHOUT ANY WARRANTY; without even the implied warranty of | 9 # but WITHOUT ANY WARRANTY; without even the implied warranty of |
| 12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | 10 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
| 13 # GNU General Public License for more details. | 11 # GNU General Public License for more details. |
| 14 # | 12 # |
| 15 # 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 |
| 16 # 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/>. |
| 17 | 15 |
| 18 import MySQLdb | 16 import MySQLdb |
| 19 from sitescripts.utils import setupStderr | 17 from sitescripts.utils import setupStderr |
| 20 from sitescripts.reports.utils import get_db, executeQuery, removeReport | 18 from sitescripts.reports.utils import get_db, executeQuery, removeReport |
| 21 | 19 |
| 22 | 20 |
| 23 def removeOldReports(days=30): | 21 def removeOldReports(days=30): |
| 24 cursor = get_db().cursor(MySQLdb.cursors.DictCursor) | 22 cursor = get_db().cursor(MySQLdb.cursors.DictCursor) |
| 25 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) |
| 26 for report in cursor: | 24 for report in cursor: |
| 27 removeReport(report['guid']) | 25 removeReport(report['guid']) |
| 28 | 26 |
| 29 if __name__ == '__main__': | 27 if __name__ == '__main__': |
| 30 setupStderr() | 28 setupStderr() |
| 31 removeOldReports() | 29 removeOldReports() |
| OLD | NEW |