From 78c931962726c369c51ec1dac623b57647a4227d Mon Sep 17 00:00:00 2001 From: Philipp Zabel Date: Wed, 25 Nov 2009 17:05:30 +0100 Subject: [PATCH] IMDb plugin: use the limit given by cinaest as SQL limit --- src/imdb/imdb-sqlite.vala | 4 ++-- src/plugins/imdb-plugin.vala | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/src/imdb/imdb-sqlite.vala b/src/imdb/imdb-sqlite.vala index 431807f..b489fdb 100644 --- a/src/imdb/imdb-sqlite.vala +++ b/src/imdb/imdb-sqlite.vala @@ -163,7 +163,7 @@ class IMDbSqlite : Object { } private Cancellable? _cancellable; - public async int query (MovieFilter filter, ReceiveMovieFunction receive_movie, Cancellable? cancellable) { + public async int query (MovieFilter filter, ReceiveMovieFunction receive_movie, int limit, Cancellable? cancellable) { var sql = "SELECT Title, Year, Rating, Genres FROM Movies"; var sep = " WHERE "; Statement stmt; @@ -195,7 +195,7 @@ class IMDbSqlite : Object { if (filter.genres.field != 0) { sql += sep + "Genres&%d = %d".printf (filter.genres.field, filter.genres.field); } - sql += " ORDER BY Votes DESC LIMIT %d;".printf (100); + sql += " ORDER BY Votes DESC LIMIT %d;".printf (limit); stdout.printf("SQL: \"%s\"\n", sql); diff --git a/src/plugins/imdb-plugin.vala b/src/plugins/imdb-plugin.vala index fb0c32a..f3cf05f 100644 --- a/src/plugins/imdb-plugin.vala +++ b/src/plugins/imdb-plugin.vala @@ -165,7 +165,7 @@ class IMDBSource : MovieSource { "cinaest", "imdb.db", null)); _get_callback = callback; - yield sqlite.query (filter, receive_movie, cancellable); + yield sqlite.query (filter, receive_movie, limit, cancellable); } private void receive_movie (string title, int year, int rating, int genres) { -- 1.7.9.5