From febb5289e82c4424cdbcc2297e967bd894cbc8cf Mon Sep 17 00:00:00 2001
From: Barry Warsaw
Date: Fri, 29 Jul 2016 19:28:46 -0400
Subject: MySQL is now an officially supported database.

Given by Abhilash Raj.
---
 src/mailman/database/mysql.py | 34 ++++++++++++++++++++++++++++++++++
 1 file changed, 34 insertions(+)
 create mode 100644 src/mailman/database/mysql.py

(limited to 'src/mailman/database/mysql.py')

diff --git a/src/mailman/database/mysql.py b/src/mailman/database/mysql.py
new file mode 100644
index 000000000..0c0de54a9
--- /dev/null
+++ b/src/mailman/database/mysql.py
@@ -0,0 +1,34 @@
+# Copyright (C) 2016 by the Free Software Foundation, Inc.
+#
+# This file is part of GNU Mailman.
+#
+# GNU Mailman is free software: you can redistribute it and/or modify it under
+# the terms of the GNU General Public License as published by the Free
+# Software Foundation, either version 3 of the License, or (at your option)
+# any later version.
+#
+# GNU Mailman 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
+# GNU Mailman.  If not, see <http://www.gnu.org/licenses/>.
+
+"""MySQL database support"""
+
+from mailman import public
+from mailman.database.base import SABaseDatabase
+from mailman.database.model import Model
+
+
+@public
+class MySQLDatabase(SABaseDatabase):
+    """Database class for MySQL."""
+
+    def _post_reset(self, store):
+        """Reset AUTO_INCREMENT counters for all the tables."""
+        super()._post_reset(store)
+        tables = reversed(Model.metadata.sorted_tables)
+        for table in tables:
+            store.execute('ALTER TABLE {} AUTO_INCREMENT = 1;'.format(table))
-- 
cgit v1.2.3-70-g09d2