Side by Side Diff: sitescripts/reports/bin/removeOldUsers.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.
« no previous file with comments
|
« sitescripts/reports/bin/removeOldReports.py ('k')
|
sitescripts/reports/bin/updateDigests.py » ('j')
|
no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')
| OLD | NEW |
|---|---|
| 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 from sitescripts.utils import setupStderr | 16 from sitescripts.utils import setupStderr |
| 17 from sitescripts.reports.utils import get_db, executeQuery | 17 from sitescripts.reports.utils import get_db, executeQuery |
| 18 | 18 |
| 19 | 19 |
| 20 def removeOldUsers(months=4): | 20 def removeOldUsers(months=4): |
| 21 cursor = get_db().cursor() | 21 cursor = get_db().cursor() |
| 22 executeQuery(cursor, 'DELETE FROM #PFX#users WHERE ADDDATE(mtime, INTERVAL % s MONTH) < NOW()', months) | 22 executeQuery(cursor, 'DELETE FROM #PFX#users WHERE ADDDATE(mtime, INTERVAL % s MONTH) < NOW()', months) |
| 23 get_db().commit() | 23 get_db().commit() |
| 24 | 24 |
| 25 | |
| 25 if __name__ == '__main__': | 26 if __name__ == '__main__': |
| 26 setupStderr() | 27 setupStderr() |
| 27 removeOldUsers() | 28 removeOldUsers() |
| OLD | NEW |
« no previous file with comments
|
« sitescripts/reports/bin/removeOldReports.py ('k')
|
sitescripts/reports/bin/updateDigests.py » ('j')
|
no next file with comments »
