Side by Side Diff: sitescripts/filterhits/web/common.py
Issue 4615801646612480:
Issue 395 - Filter hits statistics backend (Closed)
Patch Set: Make sure the temporary log directory is recreated for each test.
Created March 30, 2015, 7:26 p.m.
| Left: | ||
| Right: |
Use n/p to move between diff chunks;
N/P to move between comments.
« sitescripts/filterhits/test/test_helpers.py ('K')
|
« sitescripts/filterhits/web/__init__.py ('k')
|
sitescripts/filterhits/web/query.py » ('j')
|
sitescripts/filterhits/web/submit.py » ('J')
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 # coding: utf-8 | 1 # coding: utf-8 |
| 2 | 2 |
| 3 # This file is part of the Adblock Plus web scripts, | 3 # This file is part of the Adblock Plus web scripts, |
| 4 # Copyright (C) 2006-2015 Eyeo GmbH | 4 # Copyright (C) 2006-2015 Eyeo GmbH |
| 5 # | 5 # |
| 6 # Adblock Plus is free software: you can redistribute it and/or modify | 6 # 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 | 7 # it under the terms of the GNU General Public License version 3 as |
| 8 # published by the Free Software Foundation. | 8 # published by the Free Software Foundation. |
| 9 # | 9 # |
| 10 # Adblock Plus is distributed in the hope that it will be useful, | 10 # Adblock Plus is distributed in the hope that it will be useful, |
| 11 # but WITHOUT ANY WARRANTY; without even the implied warranty of | 11 # but WITHOUT ANY WARRANTY; without even the implied warranty of |
| 12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | 12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
| 13 # GNU General Public License for more details. | 13 # GNU General Public License for more details. |
| 14 # | 14 # |
| 15 # You should have received a copy of the GNU General Public License | 15 # 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/>. | 16 # along with Adblock Plus. If not, see <http://www.gnu.org/licenses/>. |
| 17 | 17 |
| 18 from sitescripts.utils import setupStderr | 18 def show_error(message, start_response, status="400 Processing Error"): |
| 19 from sitescripts.reports.utils import get_db, executeQuery | 19 start_response(status, [("Content-Type", "text/plain; charset=utf-8")]) |
| 20 | 20 return [message.encode("utf-8")] |
| 21 def removeOldUsers(months=4): | |
| 22 cursor = get_db().cursor() | |
| 23 executeQuery(cursor, | |
| 24 '''DELETE FROM #PFX#users WHERE ADDDATE(mtime, INTERVAL %s MONTH) < NOW ()''', | |
| 25 (months)) | |
| 26 get_db().commit() | |
| 27 | |
| 28 if __name__ == '__main__': | |
| 29 setupStderr() | |
| 30 removeOldUsers() | |
| OLD | NEW |
