diff --git a/engine/tabsqlitedb.py b/engine/tabsqlitedb.py index 258c838..b8a858a 100644 --- a/engine/tabsqlitedb.py +++ b/engine/tabsqlitedb.py @@ -566,7 +566,7 @@ class tabsqlitedb: VALUES (:tabkeys, :phrase, :freq, :user_freq); ''' %{'database': database} insert_sqlargs = [] - for (tabkeys, phrase, freq, user_freq) in phrases: + for (tabkeys, phrase, freq, user_freq) in sorted(phrases): insert_sqlargs.append({'tabkeys': tabkeys, 'phrase': phrase, 'freq': freq, 'user_freq': user_freq}) self.db.executemany(insert_sqlstr, insert_sqlargs) self.db.commit()