Date: Monday, March 25, 2019 @ 18:39:50 Author: arojas Revision: 443476
Fix migration with recent sqlite (FS#61940) Added: skrooge/trunk/skrooge-sqlite-migration.patch Modified: skrooge/trunk/PKGBUILD --------------------------------+ PKGBUILD | 18 ++++++++++++------ skrooge-sqlite-migration.patch | 25 +++++++++++++++++++++++++ 2 files changed, 37 insertions(+), 6 deletions(-) Modified: PKGBUILD =================================================================== --- PKGBUILD 2019-03-25 16:16:43 UTC (rev 443475) +++ PKGBUILD 2019-03-25 18:39:50 UTC (rev 443476) @@ -5,7 +5,7 @@ pkgname=skrooge pkgver=2.18.0 -pkgrel=2 +pkgrel=3 pkgdesc="A personal finances manager for KDE" arch=('x86_64') url="https://skrooge.org/" @@ -17,15 +17,21 @@ options=('!emptydirs') install=$pkgname.install changelog=$pkgname.changelog -source=(https://download.kde.org/stable/$pkgname/$pkgname-$pkgver.tar.xz{,.sig}) +source=(https://download.kde.org/stable/$pkgname/$pkgname-$pkgver.tar.xz{,.sig} + skrooge-sqlite-migration.patch) validpgpkeys=('103DC6D087B3A4A2ED975D7EF0C8CED3382A5C4D') #Stephane MANKOWSKI (Perso) <steph...@mankowski.fr> sha256sums=('4671dfe736d92c2de51a872b49bfbdc251e7e869b5672b6546b85aca4409f303' - 'SKIP') + 'SKIP' + '94a3065deb5d925ca1e2dbeb081a989cdd8183387b26c28535b4b9fa13f4cc22') +prepare() { + cd $pkgname-$pkgver + patch -p1 -i ../skrooge-sqlite-migration.patch # Fix migration failure with sqlite 3.25.0 +} + build() { - cd "${srcdir}"/$pkgname-$pkgver + cd $pkgname-$pkgver -# export cmake . -DCMAKE_BUILD_TYPE=Release \ -DCMAKE_INSTALL_PREFIX=/usr \ -DKDE_INSTALL_LIBDIR=/usr/lib \ @@ -34,7 +40,7 @@ } package() { - cd "${srcdir}"/$pkgname-$pkgver + cd $pkgname-$pkgver make DESTDIR="${pkgdir}" install } Added: skrooge-sqlite-migration.patch =================================================================== --- skrooge-sqlite-migration.patch (rev 0) +++ skrooge-sqlite-migration.patch 2019-03-25 18:39:50 UTC (rev 443476) @@ -0,0 +1,25 @@ +From ed442747240d4f14d275890f4a327a1bb6675af7 Mon Sep 17 00:00:00 2001 +From: Stephane MANKOWSKI <steph...@mankowski.fr> +Date: Thu, 7 Mar 2019 19:00:20 +0100 +Subject: Migration failure with sqlite >= 3.25.0 due to ALTER TABLE behavior + modification + +--- + skgbasemodeler/skgdocument.cpp | 2 +- + 1 file changed, 1 insertion(+), 1 deletion(-) + +diff --git a/skgbasemodeler/skgdocument.cpp b/skgbasemodeler/skgdocument.cpp +index 01cdcf6..fe8fa03 100644 +--- a/skgbasemodeler/skgdocument.cpp ++++ b/skgbasemodeler/skgdocument.cpp +@@ -1524,6 +1524,7 @@ SKGError SKGDocument::load(const QString& iName, const QString& iPassword, bool + << QStringLiteral("PRAGMA temp_store=MEMORY") + // << QStringLiteral("PRAGMA locking_mode=EXCLUSIVE") + << QStringLiteral("PRAGMA synchronous = OFF") ++ << QStringLiteral("PRAGMA legacy_alter_table=ON") // For migration on sqlite >=3.25 (see https://sqlite.org/lang_altertable.html) + << QStringLiteral("PRAGMA recursive_triggers=true"); + IFOKDO(err, executeSqliteOrders(optimization)) + +-- +cgit v1.1 +