[gentoo-commits] proj/chromium-tools:master commit in: /

["Paweł Hajdan" <phajdan.jr@gentoo.org>]

commit:     31e12833015525826359340f568b2b6fad783203
Author:     Pawel Hajdan, Jr <phajdan.jr <AT> gentoo <DOT> org>
AuthorDate: Mon Jun 18 07:37:23 2012 +0000
Commit:     Paweł Hajdan <phajdan.jr <AT> gentoo <DOT> org>
CommitDate: Mon Jun 18 07:37:23 2012 +0000
URL:        http://git.overlays.gentoo.org/gitweb/?p=proj/chromium-tools.git;a=commit;h=31e12833

Add sqlite-vacuum script, bug #413295.

---
 sqlite-vacuum.py |   26 ++++++++++++++++++++++++++
 1 files changed, 26 insertions(+), 0 deletions(-)

diff --git a/sqlite-vacuum.py b/sqlite-vacuum.py
new file mode 100755
index 0000000..03b610a
--- /dev/null
+++ b/sqlite-vacuum.py
@@ -0,0 +1,26 @@
+#!/usr/bin/env python
+
+import os.path
+
+import magic
+import sqlite3
+
+home = os.path.expanduser('~')
+
+try:
+	m = magic.open(magic.MAGIC_NONE)
+	m.load()
+
+	for root, dirs, files in os.walk(os.path.join(home, '.config', 'chromium')):
+		for f in files:
+			path = os.path.join(root, f)
+			magic_type = m.file(path)
+			if magic_type and 'SQLite' in magic_type:
+				try:
+					c = sqlite3.connect(path)
+					c.execute('VACUUM')
+					c.execute('REINDEX')
+				finally:
+					c.close()
+finally:
+	m.close()