[patch] me-tv-sqlite-fix.patch for my ebuild

me-tv-sqlite-fix.patch (text/plain), 1.63 KB, created by Sven on 2012-06-10 02:33:34 UTC

=== modified file 'configure.ac'
--- configure.ac	2012-03-19 22:21:54 +0000
+++ configure.ac	2012-06-03 11:58:32 +0000
@@ -119,7 +119,7 @@
 IT_PROG_INTLTOOL([0.35.0])
 
 # required versions
-SQLITE_REQUIRED=3.0
+SQLITE_REQUIRED=3.7.0
 GTKMM_REQUIRED=2.12.0
 GLIBMM_REQUIRED=2.12.0
 GIOMM_REQUIRED=2.10.0

=== modified file 'control'
--- control	2012-03-11 22:20:20 +0000
+++ control	2012-06-03 11:51:58 +0000
@@ -4,7 +4,7 @@
 Maintainer: me-tv team <https://launchpad.net/~me-tv-administration>
 Build-Depends: debhelper (>= 7.0.50~), autotools-dev, pkg-config, intltool,
                libgtkmm-2.4-dev (>=2.12), libx11-dev,
-               libsqlite3-dev, libgconfmm-2.6-dev, libunique-dev,
+               libsqlite3-dev (>=3.7.0), libgconfmm-2.6-dev, libunique-dev,
                libdbus-glib-1-dev, libxml++2.6-dev, libvlc-dev,
                libgstreamer0.10-dev, libgstreamer-plugins-base0.10-dev
 Standards-Version: 3.9.1

=== modified file 'server/data.cc'
--- server/data.cc	2012-03-19 22:21:54 +0000
+++ server/data.cc	2012-06-03 11:53:34 +0000
@@ -74,6 +74,8 @@
 	{
 		throw SQLiteException(connection, _("Failed to finalise statement"));
 	}
+
+	statement = NULL;
 }
 
 void Statement::reset()
@@ -178,6 +180,21 @@
 	}
 	
 	database_created = !database_exists;
+
+	// Enable WAL journal
+	Statement* stmnt = new Statement(*this, "PRAGMA journal_mode=WAL");
+	stmnt->step();
+	delete stmnt;
+
+	// Set page size
+	stmnt = new Statement(*this, "PRAGMA page_size=8192");
+	stmnt->step();
+	delete stmnt;
+
+	// Synchronous mode
+	stmnt = new Statement(*this, "PRAGMA synchronous=NORMAL");
+	stmnt->step();
+	delete stmnt;
 }
 
 Connection::~Connection()