Date: Friday, January 13, 2017 @ 07:42:33 Author: heftig Revision: 286184
1.5.16-2 Modified: ibus-typing-booster/trunk/0001-Unbreak-sqlite-on-Python-3.6.patch ibus-typing-booster/trunk/PKGBUILD -----------------------------------------+ 0001-Unbreak-sqlite-on-Python-3.6.patch | 37 ++++++++++++++++++++++++++---- PKGBUILD | 4 +-- 2 files changed, 35 insertions(+), 6 deletions(-) Modified: 0001-Unbreak-sqlite-on-Python-3.6.patch =================================================================== --- 0001-Unbreak-sqlite-on-Python-3.6.patch 2017-01-13 03:32:32 UTC (rev 286183) +++ 0001-Unbreak-sqlite-on-Python-3.6.patch 2017-01-13 07:42:33 UTC (rev 286184) @@ -1,4 +1,4 @@ -From 0f8b5572de64a3e1a68d20975dffffadd6452c9a Mon Sep 17 00:00:00 2001 +From 2e665e9f51e44808a472a8e7fd13edb205ba5ba7 Mon Sep 17 00:00:00 2001 From: "Jan Alexander Steffens (heftig)" <[email protected]> Date: Fri, 13 Jan 2017 00:21:52 +0100 Subject: [PATCH] Unbreak sqlite on Python 3.6 @@ -11,11 +11,11 @@ anymore is a possible workaround. However, using executescript() seems like a better idea; it always commits any open transaction first. --- - engine/tabsqlitedb.py | 42 ++++++++++++++++++++++-------------------- - 1 file changed, 22 insertions(+), 20 deletions(-) + engine/tabsqlitedb.py | 60 +++++++++++++++++++++++++++------------------------ + 1 file changed, 32 insertions(+), 28 deletions(-) diff --git a/engine/tabsqlitedb.py b/engine/tabsqlitedb.py -index 4ff7f020ecf9dd40..beac0f82ce3ea885 100755 +index 4ff7f020ecf9dd40..9d3b576ba84723d1 100755 --- a/engine/tabsqlitedb.py +++ b/engine/tabsqlitedb.py @@ -205,16 +205,17 @@ class tabsqlitedb: @@ -74,6 +74,35 @@ self.create_tables() if self.old_phrases: sqlargs = [] +@@ -657,18 +659,20 @@ class tabsqlitedb: + return + if not path.exists(self.user_db_file): + db = sqlite3.connect(self.user_db_file) +- db.execute('PRAGMA encoding = "UTF-8";') +- db.execute('PRAGMA case_sensitive_like = true;') +- db.execute('PRAGMA page_size = 4096;') + # a database containing the complete German Hunspell + # dictionary has less then 6000 pages. 20000 pages + # should be enough to cache the complete database + # in most cases. +- db.execute('PRAGMA cache_size = 20000;') +- db.execute('PRAGMA temp_store = MEMORY; ') +- db.execute('PRAGMA journal_mode = WAL;') +- db.execute('PRAGMA journal_size_limit = 1000000;') +- db.execute('PRAGMA synchronous = NORMAL;') ++ self.db.executescript(''' ++ PRAGMA encoding = "UTF-8"; ++ PRAGMA case_sensitive_like = true; ++ PRAGMA page_size = 4096; ++ PRAGMA cache_size = 20000; ++ PRAGMA temp_store = MEMORY; ++ PRAGMA journal_mode = WAL; ++ PRAGMA journal_size_limit = 1000000; ++ PRAGMA synchronous = NORMAL; ++ ''') + db.commit() + + def get_database_desc(self, db_file): -- 2.11.0 Modified: PKGBUILD =================================================================== --- PKGBUILD 2017-01-13 03:32:32 UTC (rev 286183) +++ PKGBUILD 2017-01-13 07:42:33 UTC (rev 286184) @@ -3,7 +3,7 @@ pkgname=ibus-typing-booster pkgver=1.5.16 -pkgrel=1 +pkgrel=2 pkgdesc="Predictive input method for the IBus platform" url="https://fedorahosted.org/ibus-typing-booster/"; arch=(any) @@ -14,7 +14,7 @@ source=("git+https://git.fedorahosted.org/git/ibus-typing-booster#commit=$_commit"; 0001-Unbreak-sqlite-on-Python-3.6.patch) sha512sums=('SKIP' - '4c1a6a4789a372f3fb8f9cdb76b3cba75006e2163e48d24bd8e9785700a71eb9db4dad1560f05a9ca1086095de624de5be8f030de837dcfab1d669aef5fce167') + '86a0a24baa2f55a3140bcd98e5d442ec823e4032cc5069357d7be76b2d1bf58eb73ea4b464fdc92bf2b98f42e3f12559da715374e06de8173da0f5dc6c02b15d') pkgver() { cd $pkgname
