From: Philipp Zabel <philipp.zabel@gmail.com>
Date: Fri, 16 Jul 2010 17:02:16 +0000 (+0200)
Subject: IMDb SQLite class: set rating to -1 to indicate a NULL value in the database
X-Git-Url: http://vcs.maemo.org/git/?p=cinaest;a=commitdiff_plain;h=93f3b57e52dadc83c5751a66c5fd616aa06eefdd

IMDb SQLite class: set rating to -1 to indicate a NULL value in the database
---

diff --git a/src/imdb/imdb-sqlite.vala b/src/imdb/imdb-sqlite.vala
index 81e0672..10065c0 100644
--- a/src/imdb/imdb-sqlite.vala
+++ b/src/imdb/imdb-sqlite.vala
@@ -342,7 +342,11 @@ class IMDbSqlite : Object {
 			if (rc == Sqlite.ROW) {
 				int year = stmt.column_int (1);
 				string title = stmt.column_text (0);
-				int rating = stmt.column_int (2);
+				int rating;
+				if (stmt.column_type (2) != Sqlite.NULL)
+					rating = stmt.column_int (2);
+				else
+					rating = -1;
 				int genres = stmt.column_int (3);
 				string aka = null;
 				if (match != null && !(filter.matches_title (strip_year (title, year)))) {