Reports - cleaning users

sitescripts/reports/bin/removeOldUsers.py

Index: sitescripts/reports/bin/removeOldUsers.py
===================================================================
new file mode 100644
--- /dev/null
+++ b/sitescripts/reports/bin/removeOldUsers.py
@@ -0,0 +1,31 @@
+# coding: utf-8
+
+# This file is part of the Adblock Plus web scripts,
+# Copyright (C) 2006-2012 Eyeo GmbH
+#
+# Adblock Plus is free software: you can redistribute it and/or modify
+# it under the terms of the GNU General Public License version 3 as
+# published by the Free Software Foundation.
+#
+# Adblock Plus is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with Adblock Plus.  If not, see <http://www.gnu.org/licenses/>.
+
+import MySQLdb

[Wladimir Palant, 2012/11/16 08:34:50]

Doesn't look like you actually need that package.

+from sitescripts.utils import setupStderr
+from sitescripts.reports.utils import get_db, executeQuery
+
+def removeOldUsers(months=4):
+  cursor = get_db().cursor()
+  executeQuery(cursor,
+         '''DELETE FROM #PFX#users WHERE ADDDATE(mtime, INTERVAL %s MONTH) < NOW()''',
+         (months))
+  get_db().commit()
+
+if __name__ == '__main__':
+  setupStderr()
+  removeOldUsers()