Attachment 2589 Details for Bug 6896 – patch making me-tv behave sanely.

[patch] patch making me-tv behave sanely.

me-tv-sqlite-fix.patch (text/plain), 993 bytes, created by Christian Lohmaier on 2012-07-29 01:33:02 CEST

(hide)

Description:

Filename:

MIME Type:

Creator: Christian Lohmaier

Created: 2012-07-29 01:33:02 CEST

Size: 993 bytes

patch

obsolete

>=== 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
> GIOMM_REQUIRED=2.10.0
> GCONF_REQUIRED=2.0
>--- src/data.cc	2012-03-19 22:21:54 +0000
>+++ src/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()
>

=== 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
 GIOMM_REQUIRED=2.10.0
 GCONF_REQUIRED=2.0
--- src/data.cc	2012-03-19 22:21:54 +0000
+++ src/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()

Actions: View | Diff

Attachments on bug 6896: 2589