# HG changeset patch
# User Goffi <goffi@goffi.org>
# Date 1582750995 -3600
# Node ID 7255286a298ae766e3899224fc674f5d4e82419b
# Parent  1c6dacbfcf271fa4cff87a76e0671c3bc5a7ecfd
memory (sqlite): don't store empty messages

diff -r 1c6dacbfcf27 -r 7255286a298a sat/memory/sqlite.py
--- a/sat/memory/sqlite.py	Wed Feb 26 22:03:15 2020 +0100
+++ b/sat/memory/sqlite.py	Wed Feb 26 22:03:15 2020 +0100
@@ -442,6 +442,9 @@
         d_list = []
         for key in ('message', 'subject'):
             for lang, value in data[key].items():
+                if not value.strip():
+                    # no need to store empty messages
+                    continue
                 d = self.dbpool.runQuery(
                     "INSERT INTO {key}(history_uid, {key}, language) VALUES (?,?,?)"
                     .format(key=key),