~ubuntu-branches/ubuntu/precise/unity-lens-music/precise-proposed

« back to all changes in this revision

Viewing changes to src/banshee-collection.c

  • Committer: Bazaar Package Importer
  • Author(s): Didier Roche
  • Date: 2011-08-11 19:37:31 UTC
  • Revision ID: james.westby@ubuntu.com-20110811193731-0dym5igg8sfanj5z
Tags: upstream-0.1.0
ImportĀ upstreamĀ versionĀ 0.1.0

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
/* banshee-collection.c generated by valac 0.12.1, the Vala compiler
 
2
 * generated from banshee-collection.vala, do not modify */
 
3
 
 
4
/*
 
5
 * Copyright (C) 2011 Canonical Ltd
 
6
 *
 
7
 * This program is free software: you can redistribute it and/or modify
 
8
 * it under the terms of the GNU General Public License version 3 as
 
9
 * published by the Free Software Foundation.
 
10
 *
 
11
 * This program is distributed in the hope that it will be useful,
 
12
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 
13
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 
14
 * GNU General Public License for more details.
 
15
 *
 
16
 * You should have received a copy of the GNU General Public License
 
17
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 
18
 *
 
19
 * Authored by Alex Launi <alex.launi@canonical.com>
 
20
 *
 
21
 */
 
22
 
 
23
#include <glib.h>
 
24
#include <glib-object.h>
 
25
#include <sqlite3.h>
 
26
#include <stdlib.h>
 
27
#include <string.h>
 
28
#include <unity.h>
 
29
#include <dee.h>
 
30
#include <gee.h>
 
31
 
 
32
 
 
33
#define UNITY_MUSIC_LENS_TYPE_COLUMNS (unity_music_lens_columns_get_type ())
 
34
 
 
35
#define UNITY_MUSIC_LENS_TYPE_BANSHEE_COLLECTION (unity_music_lens_banshee_collection_get_type ())
 
36
#define UNITY_MUSIC_LENS_BANSHEE_COLLECTION(obj) (G_TYPE_CHECK_INSTANCE_CAST ((obj), UNITY_MUSIC_LENS_TYPE_BANSHEE_COLLECTION, UnityMusicLensBansheeCollection))
 
37
#define UNITY_MUSIC_LENS_BANSHEE_COLLECTION_CLASS(klass) (G_TYPE_CHECK_CLASS_CAST ((klass), UNITY_MUSIC_LENS_TYPE_BANSHEE_COLLECTION, UnityMusicLensBansheeCollectionClass))
 
38
#define UNITY_MUSIC_LENS_IS_BANSHEE_COLLECTION(obj) (G_TYPE_CHECK_INSTANCE_TYPE ((obj), UNITY_MUSIC_LENS_TYPE_BANSHEE_COLLECTION))
 
39
#define UNITY_MUSIC_LENS_IS_BANSHEE_COLLECTION_CLASS(klass) (G_TYPE_CHECK_CLASS_TYPE ((klass), UNITY_MUSIC_LENS_TYPE_BANSHEE_COLLECTION))
 
40
#define UNITY_MUSIC_LENS_BANSHEE_COLLECTION_GET_CLASS(obj) (G_TYPE_INSTANCE_GET_CLASS ((obj), UNITY_MUSIC_LENS_TYPE_BANSHEE_COLLECTION, UnityMusicLensBansheeCollectionClass))
 
41
 
 
42
typedef struct _UnityMusicLensBansheeCollection UnityMusicLensBansheeCollection;
 
43
typedef struct _UnityMusicLensBansheeCollectionClass UnityMusicLensBansheeCollectionClass;
 
44
typedef struct _UnityMusicLensBansheeCollectionPrivate UnityMusicLensBansheeCollectionPrivate;
 
45
#define _sqlite3_close0(var) ((var == NULL) ? NULL : (var = (sqlite3_close (var), NULL)))
 
46
#define _g_free0(var) (var = (g_free (var), NULL))
 
47
#define _g_object_unref0(var) ((var == NULL) ? NULL : (var = (g_object_unref (var), NULL)))
 
48
 
 
49
#define UNITY_MUSIC_LENS_TYPE_FILTER_PARSER (unity_music_lens_filter_parser_get_type ())
 
50
#define UNITY_MUSIC_LENS_FILTER_PARSER(obj) (G_TYPE_CHECK_INSTANCE_CAST ((obj), UNITY_MUSIC_LENS_TYPE_FILTER_PARSER, UnityMusicLensFilterParser))
 
51
#define UNITY_MUSIC_LENS_FILTER_PARSER_CLASS(klass) (G_TYPE_CHECK_CLASS_CAST ((klass), UNITY_MUSIC_LENS_TYPE_FILTER_PARSER, UnityMusicLensFilterParserClass))
 
52
#define UNITY_MUSIC_LENS_IS_FILTER_PARSER(obj) (G_TYPE_CHECK_INSTANCE_TYPE ((obj), UNITY_MUSIC_LENS_TYPE_FILTER_PARSER))
 
53
#define UNITY_MUSIC_LENS_IS_FILTER_PARSER_CLASS(klass) (G_TYPE_CHECK_CLASS_TYPE ((klass), UNITY_MUSIC_LENS_TYPE_FILTER_PARSER))
 
54
#define UNITY_MUSIC_LENS_FILTER_PARSER_GET_CLASS(obj) (G_TYPE_INSTANCE_GET_CLASS ((obj), UNITY_MUSIC_LENS_TYPE_FILTER_PARSER, UnityMusicLensFilterParserClass))
 
55
 
 
56
typedef struct _UnityMusicLensFilterParser UnityMusicLensFilterParser;
 
57
typedef struct _UnityMusicLensFilterParserClass UnityMusicLensFilterParserClass;
 
58
 
 
59
#define UNITY_MUSIC_LENS_TYPE_ALBUM (unity_music_lens_album_get_type ())
 
60
#define UNITY_MUSIC_LENS_ALBUM(obj) (G_TYPE_CHECK_INSTANCE_CAST ((obj), UNITY_MUSIC_LENS_TYPE_ALBUM, UnityMusicLensAlbum))
 
61
#define UNITY_MUSIC_LENS_ALBUM_CLASS(klass) (G_TYPE_CHECK_CLASS_CAST ((klass), UNITY_MUSIC_LENS_TYPE_ALBUM, UnityMusicLensAlbumClass))
 
62
#define UNITY_MUSIC_LENS_IS_ALBUM(obj) (G_TYPE_CHECK_INSTANCE_TYPE ((obj), UNITY_MUSIC_LENS_TYPE_ALBUM))
 
63
#define UNITY_MUSIC_LENS_IS_ALBUM_CLASS(klass) (G_TYPE_CHECK_CLASS_TYPE ((klass), UNITY_MUSIC_LENS_TYPE_ALBUM))
 
64
#define UNITY_MUSIC_LENS_ALBUM_GET_CLASS(obj) (G_TYPE_INSTANCE_GET_CLASS ((obj), UNITY_MUSIC_LENS_TYPE_ALBUM, UnityMusicLensAlbumClass))
 
65
 
 
66
typedef struct _UnityMusicLensAlbum UnityMusicLensAlbum;
 
67
typedef struct _UnityMusicLensAlbumClass UnityMusicLensAlbumClass;
 
68
#define _sqlite3_finalize0(var) ((var == NULL) ? NULL : (var = (sqlite3_finalize (var), NULL)))
 
69
 
 
70
#define UNITY_MUSIC_LENS_TYPE_TRACK (unity_music_lens_track_get_type ())
 
71
#define UNITY_MUSIC_LENS_TRACK(obj) (G_TYPE_CHECK_INSTANCE_CAST ((obj), UNITY_MUSIC_LENS_TYPE_TRACK, UnityMusicLensTrack))
 
72
#define UNITY_MUSIC_LENS_TRACK_CLASS(klass) (G_TYPE_CHECK_CLASS_CAST ((klass), UNITY_MUSIC_LENS_TYPE_TRACK, UnityMusicLensTrackClass))
 
73
#define UNITY_MUSIC_LENS_IS_TRACK(obj) (G_TYPE_CHECK_INSTANCE_TYPE ((obj), UNITY_MUSIC_LENS_TYPE_TRACK))
 
74
#define UNITY_MUSIC_LENS_IS_TRACK_CLASS(klass) (G_TYPE_CHECK_CLASS_TYPE ((klass), UNITY_MUSIC_LENS_TYPE_TRACK))
 
75
#define UNITY_MUSIC_LENS_TRACK_GET_CLASS(obj) (G_TYPE_INSTANCE_GET_CLASS ((obj), UNITY_MUSIC_LENS_TYPE_TRACK, UnityMusicLensTrackClass))
 
76
 
 
77
typedef struct _UnityMusicLensTrack UnityMusicLensTrack;
 
78
typedef struct _UnityMusicLensTrackClass UnityMusicLensTrackClass;
 
79
#define _g_string_free0(var) ((var == NULL) ? NULL : (var = (g_string_free (var, TRUE), NULL)))
 
80
 
 
81
typedef enum  {
 
82
        UNITY_MUSIC_LENS_DATABASE_ERROR_FAILED_TO_OPEN
 
83
} UnityMusicLensDatabaseError;
 
84
#define UNITY_MUSIC_LENS_DATABASE_ERROR unity_music_lens_database_error_quark ()
 
85
typedef enum  {
 
86
        UNITY_MUSIC_LENS_COLUMNS_TRACK_TITLE,
 
87
        UNITY_MUSIC_LENS_COLUMNS_TRACK_URI,
 
88
        UNITY_MUSIC_LENS_COLUMNS_TRACK_MIMETYPE,
 
89
        UNITY_MUSIC_LENS_COLUMNS_ALBUM_TITLE,
 
90
        UNITY_MUSIC_LENS_COLUMNS_ARTIST_NAME
 
91
} UnityMusicLensColumns;
 
92
 
 
93
struct _UnityMusicLensBansheeCollection {
 
94
        GObject parent_instance;
 
95
        UnityMusicLensBansheeCollectionPrivate * priv;
 
96
};
 
97
 
 
98
struct _UnityMusicLensBansheeCollectionClass {
 
99
        GObjectClass parent_class;
 
100
};
 
101
 
 
102
struct _UnityMusicLensBansheeCollectionPrivate {
 
103
        sqlite3* db;
 
104
};
 
105
 
 
106
 
 
107
static gpointer unity_music_lens_banshee_collection_parent_class = NULL;
 
108
 
 
109
GQuark unity_music_lens_database_error_quark (void);
 
110
GType unity_music_lens_columns_get_type (void) G_GNUC_CONST;
 
111
GType unity_music_lens_banshee_collection_get_type (void) G_GNUC_CONST;
 
112
#define UNITY_MUSIC_LENS_BANSHEE_COLLECTION_GET_PRIVATE(o) (G_TYPE_INSTANCE_GET_PRIVATE ((o), UNITY_MUSIC_LENS_TYPE_BANSHEE_COLLECTION, UnityMusicLensBansheeCollectionPrivate))
 
113
enum  {
 
114
        UNITY_MUSIC_LENS_BANSHEE_COLLECTION_DUMMY_PROPERTY
 
115
};
 
116
#define UNITY_MUSIC_LENS_BANSHEE_COLLECTION_MAX_RESULTS 100
 
117
UnityMusicLensBansheeCollection* unity_music_lens_banshee_collection_new (GError** error);
 
118
UnityMusicLensBansheeCollection* unity_music_lens_banshee_collection_construct (GType object_type, GError** error);
 
119
GType unity_music_lens_filter_parser_get_type (void) G_GNUC_CONST;
 
120
void unity_music_lens_banshee_collection_search (UnityMusicLensBansheeCollection* self, UnityLensSearch* search, DeeModel* results_model, GList* filters, gint max_results);
 
121
GType unity_music_lens_album_get_type (void) G_GNUC_CONST;
 
122
static gchar* unity_music_lens_banshee_collection_build_sql_from_filters (UnityMusicLensBansheeCollection* self, GList* filters);
 
123
UnityMusicLensTrack* unity_music_lens_track_new (void);
 
124
UnityMusicLensTrack* unity_music_lens_track_construct (GType object_type);
 
125
GType unity_music_lens_track_get_type (void) G_GNUC_CONST;
 
126
void unity_music_lens_track_set_Title (UnityMusicLensTrack* self, const gchar* value);
 
127
void unity_music_lens_track_set_Artist (UnityMusicLensTrack* self, const gchar* value);
 
128
void unity_music_lens_track_set_Uri (UnityMusicLensTrack* self, const gchar* value);
 
129
void unity_music_lens_track_set_MimeType (UnityMusicLensTrack* self, const gchar* value);
 
130
UnityMusicLensAlbum* unity_music_lens_album_new (void);
 
131
UnityMusicLensAlbum* unity_music_lens_album_construct (GType object_type);
 
132
void unity_music_lens_album_set_Title (UnityMusicLensAlbum* self, const gchar* value);
 
133
void unity_music_lens_album_set_Artist (UnityMusicLensAlbum* self, const gchar* value);
 
134
const gchar* unity_music_lens_track_get_Artist (UnityMusicLensTrack* self);
 
135
const gchar* unity_music_lens_track_get_Title (UnityMusicLensTrack* self);
 
136
const gchar* unity_music_lens_track_get_Uri (UnityMusicLensTrack* self);
 
137
const gchar* unity_music_lens_track_get_MimeType (UnityMusicLensTrack* self);
 
138
const gchar* unity_music_lens_album_get_Artist (UnityMusicLensAlbum* self);
 
139
const gchar* unity_music_lens_album_get_Title (UnityMusicLensAlbum* self);
 
140
gchar* unity_music_lens_filter_parser_parse (UnityMusicLensFilterParser* self);
 
141
static void unity_music_lens_banshee_collection_finalize (GObject* obj);
 
142
 
 
143
 
 
144
GQuark unity_music_lens_database_error_quark (void) {
 
145
        return g_quark_from_static_string ("unity_music_lens_database_error-quark");
 
146
}
 
147
 
 
148
 
 
149
GType unity_music_lens_columns_get_type (void) {
 
150
        static volatile gsize unity_music_lens_columns_type_id__volatile = 0;
 
151
        if (g_once_init_enter (&unity_music_lens_columns_type_id__volatile)) {
 
152
                static const GEnumValue values[] = {{UNITY_MUSIC_LENS_COLUMNS_TRACK_TITLE, "UNITY_MUSIC_LENS_COLUMNS_TRACK_TITLE", "track-title"}, {UNITY_MUSIC_LENS_COLUMNS_TRACK_URI, "UNITY_MUSIC_LENS_COLUMNS_TRACK_URI", "track-uri"}, {UNITY_MUSIC_LENS_COLUMNS_TRACK_MIMETYPE, "UNITY_MUSIC_LENS_COLUMNS_TRACK_MIMETYPE", "track-mimetype"}, {UNITY_MUSIC_LENS_COLUMNS_ALBUM_TITLE, "UNITY_MUSIC_LENS_COLUMNS_ALBUM_TITLE", "album-title"}, {UNITY_MUSIC_LENS_COLUMNS_ARTIST_NAME, "UNITY_MUSIC_LENS_COLUMNS_ARTIST_NAME", "artist-name"}, {0, NULL, NULL}};
 
153
                GType unity_music_lens_columns_type_id;
 
154
                unity_music_lens_columns_type_id = g_enum_register_static ("UnityMusicLensColumns", values);
 
155
                g_once_init_leave (&unity_music_lens_columns_type_id__volatile, unity_music_lens_columns_type_id);
 
156
        }
 
157
        return unity_music_lens_columns_type_id__volatile;
 
158
}
 
159
 
 
160
 
 
161
UnityMusicLensBansheeCollection* unity_music_lens_banshee_collection_construct (GType object_type, GError** error) {
 
162
        UnityMusicLensBansheeCollection * self = NULL;
 
163
        const gchar* _tmp0_ = NULL;
 
164
        gchar* _tmp1_ = NULL;
 
165
        gchar* _tmp2_;
 
166
        sqlite3* _tmp3_ = NULL;
 
167
        gint _tmp4_;
 
168
        gint _tmp5_;
 
169
        gint rc;
 
170
        GError * _inner_error_ = NULL;
 
171
        self = (UnityMusicLensBansheeCollection*) g_object_new (object_type, NULL);
 
172
        _tmp0_ = g_get_user_config_dir ();
 
173
        _tmp1_ = g_strdup_printf ("%s/banshee-1/banshee.db", _tmp0_);
 
174
        _tmp2_ = _tmp1_;
 
175
        _tmp4_ = sqlite3_open (_tmp2_, &_tmp3_);
 
176
        _sqlite3_close0 (self->priv->db);
 
177
        self->priv->db = _tmp3_;
 
178
        _tmp5_ = _tmp4_;
 
179
        _g_free0 (_tmp2_);
 
180
        rc = _tmp5_;
 
181
        if (rc != SQLITE_OK) {
 
182
                const gchar* _tmp6_ = NULL;
 
183
                GError* _tmp7_ = NULL;
 
184
                _tmp6_ = sqlite3_errmsg (self->priv->db);
 
185
                g_printerr ("failed to open db, %d, %s\n", rc, _tmp6_);
 
186
                _tmp7_ = g_error_new_literal (UNITY_MUSIC_LENS_DATABASE_ERROR, UNITY_MUSIC_LENS_DATABASE_ERROR_FAILED_TO_OPEN, "Failed to open banshee database");
 
187
                _inner_error_ = _tmp7_;
 
188
                if (_inner_error_->domain == UNITY_MUSIC_LENS_DATABASE_ERROR) {
 
189
                        g_propagate_error (error, _inner_error_);
 
190
                        _g_object_unref0 (self);
 
191
                        return NULL;
 
192
                } else {
 
193
                        g_critical ("file %s: line %d: uncaught error: %s (%s, %d)", __FILE__, __LINE__, _inner_error_->message, g_quark_to_string (_inner_error_->domain), _inner_error_->code);
 
194
                        g_clear_error (&_inner_error_);
 
195
                        return NULL;
 
196
                }
 
197
        }
 
198
        return self;
 
199
}
 
200
 
 
201
 
 
202
UnityMusicLensBansheeCollection* unity_music_lens_banshee_collection_new (GError** error) {
 
203
        return unity_music_lens_banshee_collection_construct (UNITY_MUSIC_LENS_TYPE_BANSHEE_COLLECTION, error);
 
204
}
 
205
 
 
206
 
 
207
/**
 
208
 * Performs a search on the banshee db
 
209
 */
 
210
void unity_music_lens_banshee_collection_search (UnityMusicLensBansheeCollection* self, UnityLensSearch* search, DeeModel* results_model, GList* filters, gint max_results) {
 
211
        gint rc;
 
212
        sqlite3_stmt* stmt = NULL;
 
213
        GeeTreeSet* _tmp0_ = NULL;
 
214
        GeeTreeSet* albums;
 
215
        gchar* _tmp1_ = NULL;
 
216
        gchar* filters_sql;
 
217
        gint _tmp2_ = 0;
 
218
        const gchar* _tmp3_ = NULL;
 
219
        const gchar* _tmp4_ = NULL;
 
220
        const gchar* _tmp5_ = NULL;
 
221
        gchar* _tmp6_ = NULL;
 
222
        gchar* sql;
 
223
        sqlite3_stmt* _tmp7_ = NULL;
 
224
        gint _tmp8_;
 
225
        g_return_if_fail (self != NULL);
 
226
        g_return_if_fail (results_model != NULL);
 
227
        rc = 0;
 
228
        _tmp0_ = gee_tree_set_new (UNITY_MUSIC_LENS_TYPE_ALBUM, (GBoxedCopyFunc) g_object_ref, g_object_unref, NULL);
 
229
        albums = _tmp0_;
 
230
        _tmp1_ = unity_music_lens_banshee_collection_build_sql_from_filters (self, filters);
 
231
        filters_sql = _tmp1_;
 
232
        if (max_results == (-1)) {
 
233
                _tmp2_ = UNITY_MUSIC_LENS_BANSHEE_COLLECTION_MAX_RESULTS;
 
234
        } else {
 
235
                _tmp2_ = max_results;
 
236
        }
 
237
        _tmp3_ = unity_lens_search_get_search_string (search);
 
238
        _tmp4_ = unity_lens_search_get_search_string (search);
 
239
        _tmp5_ = unity_lens_search_get_search_string (search);
 
240
        _tmp6_ = g_strdup_printf ("SELECT CoreTracks.Title, CoreTracks.Uri, CoreTracks.MimeType, CoreAlbu" \
 
241
"ms.Title, CoreArtists.Name \n" \
 
242
"\t\t\t\t\t\t  \tFROM CoreTracks \n" \
 
243
"\t\t\t\t\t\t  \tCROSS JOIN CoreArtists, CoreAlbums \n" \
 
244
"\t\t\t\t\t\t  \tWHERE CoreArtists.ArtistID = CoreTracks.ArtistID AND C" \
 
245
"oreAlbums.AlbumID = CoreTracks.AlbumID \n" \
 
246
"\t\t\t\t\t\t  \t\t\t\t\t\t\t\t   AND CoreTracks.PrimarySourceID =1 \n" \
 
247
"\t\t\t\t\t\t  \t\t\t\t\t\t\t\t   AND ((CoreArtists.NameLowered LIKE '%" \
 
248
"%%s%%' ESCAPE '\\' \n" \
 
249
"\t\t\t\t\t\t  \t\t\t\t\t\t\t\t   \tAND CoreArtists.NameLowered IS NOT " \
 
250
"NULL) \n" \
 
251
"\t\t\t\t\t\t  \t\t\t\t\t\t\t\t   OR (CoreAlbums.TitleLowered LIKE '%%%" \
 
252
"s%%' ESCAPE '\\' \n" \
 
253
"\t\t\t\t\t\t  \t\t\t\t\t\t\t\t   \tAND CoreAlbums.TitleLowered IS NOT " \
 
254
"NULL) \n" \
 
255
"\t\t\t\t\t\t  \t\t\t\t\t\t\t\t   OR (CoreTracks.TitleLowered LIKE '%%%" \
 
256
"s%%' ESCAPE '\\' \n" \
 
257
"\t\t\t\t\t\t  \t\t\t\t\t\t\t\t   \tAND CoreTracks.TitleLowered IS NOT " \
 
258
"NULL))\n" \
 
259
"                                 %s\n" \
 
260
"\t\t\t\t\t\t  \tLIMIT 0, %d;", _tmp3_, _tmp4_, _tmp5_, filters_sql, _tmp2_);
 
261
        sql = _tmp6_;
 
262
        g_debug ("banshee-collection.vala:90: preparing to execute sql %s\n", sql);
 
263
        _tmp8_ = sqlite3_prepare_v2 (self->priv->db, sql, -1, &_tmp7_, NULL);
 
264
        _sqlite3_finalize0 (stmt);
 
265
        stmt = _tmp7_;
 
266
        rc = _tmp8_;
 
267
        if (rc == 1) {
 
268
                _g_free0 (sql);
 
269
                _g_free0 (filters_sql);
 
270
                _g_object_unref0 (albums);
 
271
                _sqlite3_finalize0 (stmt);
 
272
                return;
 
273
        }
 
274
        {
 
275
                gboolean _tmp9_;
 
276
                _tmp9_ = TRUE;
 
277
                while (TRUE) {
 
278
                        gint _tmp10_;
 
279
                        if (!_tmp9_) {
 
280
                                if (!(rc == SQLITE_ROW)) {
 
281
                                        break;
 
282
                                }
 
283
                        }
 
284
                        _tmp9_ = FALSE;
 
285
                        _tmp10_ = sqlite3_step (stmt);
 
286
                        rc = _tmp10_;
 
287
                        switch (rc) {
 
288
                                case SQLITE_DONE:
 
289
                                {
 
290
                                        break;
 
291
                                }
 
292
                                case SQLITE_ROW:
 
293
                                {
 
294
                                        UnityMusicLensTrack* _tmp11_ = NULL;
 
295
                                        UnityMusicLensTrack* track;
 
296
                                        const gchar* _tmp12_ = NULL;
 
297
                                        const gchar* _tmp13_ = NULL;
 
298
                                        const gchar* _tmp14_ = NULL;
 
299
                                        const gchar* _tmp15_ = NULL;
 
300
                                        UnityMusicLensAlbum* _tmp16_ = NULL;
 
301
                                        UnityMusicLensAlbum* album;
 
302
                                        const gchar* _tmp17_ = NULL;
 
303
                                        const gchar* _tmp18_ = NULL;
 
304
                                        const gchar* _tmp19_ = NULL;
 
305
                                        const gchar* _tmp20_ = NULL;
 
306
                                        const gchar* _tmp21_ = NULL;
 
307
                                        const gchar* _tmp22_ = NULL;
 
308
                                        const gchar* _tmp23_ = NULL;
 
309
                                        const gchar* _tmp24_ = NULL;
 
310
                                        gboolean _tmp25_;
 
311
                                        _tmp11_ = unity_music_lens_track_new ();
 
312
                                        track = _tmp11_;
 
313
                                        _tmp12_ = sqlite3_column_text (stmt, (gint) UNITY_MUSIC_LENS_COLUMNS_TRACK_TITLE);
 
314
                                        unity_music_lens_track_set_Title (track, _tmp12_);
 
315
                                        _tmp13_ = sqlite3_column_text (stmt, (gint) UNITY_MUSIC_LENS_COLUMNS_ARTIST_NAME);
 
316
                                        unity_music_lens_track_set_Artist (track, _tmp13_);
 
317
                                        _tmp14_ = sqlite3_column_text (stmt, (gint) UNITY_MUSIC_LENS_COLUMNS_TRACK_URI);
 
318
                                        unity_music_lens_track_set_Uri (track, _tmp14_);
 
319
                                        _tmp15_ = sqlite3_column_text (stmt, (gint) UNITY_MUSIC_LENS_COLUMNS_TRACK_MIMETYPE);
 
320
                                        unity_music_lens_track_set_MimeType (track, _tmp15_);
 
321
                                        _tmp16_ = unity_music_lens_album_new ();
 
322
                                        album = _tmp16_;
 
323
                                        _tmp17_ = sqlite3_column_text (stmt, (gint) UNITY_MUSIC_LENS_COLUMNS_ALBUM_TITLE);
 
324
                                        unity_music_lens_album_set_Title (album, _tmp17_);
 
325
                                        _tmp18_ = sqlite3_column_text (stmt, (gint) UNITY_MUSIC_LENS_COLUMNS_ARTIST_NAME);
 
326
                                        unity_music_lens_album_set_Artist (album, _tmp18_);
 
327
                                        _tmp19_ = unity_music_lens_track_get_Artist (track);
 
328
                                        _tmp20_ = unity_music_lens_track_get_Title (track);
 
329
                                        g_debug ("banshee-collection.vala:115: adding result for %s - %s\n", _tmp19_, _tmp20_);
 
330
                                        _tmp21_ = unity_music_lens_track_get_Uri (track);
 
331
                                        _tmp22_ = unity_music_lens_track_get_MimeType (track);
 
332
                                        _tmp23_ = unity_music_lens_track_get_Title (track);
 
333
                                        _tmp24_ = unity_music_lens_track_get_Artist (track);
 
334
                                        dee_model_append (results_model, _tmp21_, "audio-x-generic", 0, _tmp22_, _tmp23_, _tmp24_, NULL);
 
335
                                        _tmp25_ = gee_abstract_collection_add ((GeeAbstractCollection*) albums, album);
 
336
                                        if (_tmp25_) {
 
337
                                                const gchar* _tmp26_ = NULL;
 
338
                                                const gchar* _tmp27_ = NULL;
 
339
                                                const gchar* _tmp28_ = NULL;
 
340
                                                const gchar* _tmp29_ = NULL;
 
341
                                                _tmp26_ = unity_music_lens_album_get_Artist (album);
 
342
                                                _tmp27_ = unity_music_lens_album_get_Title (album);
 
343
                                                g_debug ("banshee-collection.vala:121: adding album result for %s - %s\n", _tmp26_, _tmp27_);
 
344
                                                _tmp28_ = unity_music_lens_album_get_Title (album);
 
345
                                                _tmp29_ = unity_music_lens_album_get_Artist (album);
 
346
                                                dee_model_append (results_model, "uri://need-to-solve-this", "audio-x-generic", 1, "need-to/solve-this", _tmp28_, _tmp29_, NULL);
 
347
                                        }
 
348
                                        _g_object_unref0 (album);
 
349
                                        _g_object_unref0 (track);
 
350
                                        break;
 
351
                                }
 
352
                                default:
 
353
                                {
 
354
                                        const gchar* _tmp30_ = NULL;
 
355
                                        _tmp30_ = sqlite3_errmsg (self->priv->db);
 
356
                                        g_printerr ("Error: %d, %s\n", rc, _tmp30_);
 
357
                                        break;
 
358
                                }
 
359
                        }
 
360
                }
 
361
        }
 
362
        _g_free0 (sql);
 
363
        _g_free0 (filters_sql);
 
364
        _g_object_unref0 (albums);
 
365
        _sqlite3_finalize0 (stmt);
 
366
}
 
367
 
 
368
 
 
369
static gpointer _g_object_ref0 (gpointer self) {
 
370
        return self ? g_object_ref (self) : NULL;
 
371
}
 
372
 
 
373
 
 
374
static gchar* unity_music_lens_banshee_collection_build_sql_from_filters (UnityMusicLensBansheeCollection* self, GList* filters) {
 
375
        gchar* result = NULL;
 
376
        gboolean _tmp0_ = FALSE;
 
377
        GString* _tmp3_ = NULL;
 
378
        GString* builder;
 
379
        gchar* _tmp7_;
 
380
        g_return_val_if_fail (self != NULL, NULL);
 
381
        if (filters == NULL) {
 
382
                _tmp0_ = TRUE;
 
383
        } else {
 
384
                guint _tmp1_;
 
385
                _tmp1_ = g_list_length (filters);
 
386
                _tmp0_ = _tmp1_ == 0;
 
387
        }
 
388
        if (_tmp0_) {
 
389
                gchar* _tmp2_;
 
390
                _tmp2_ = g_strdup ("");
 
391
                result = _tmp2_;
 
392
                return result;
 
393
        }
 
394
        _tmp3_ = g_string_new ("");
 
395
        builder = _tmp3_;
 
396
        {
 
397
                GList* parser_collection;
 
398
                GList* parser_it;
 
399
                parser_collection = filters;
 
400
                for (parser_it = parser_collection; parser_it != NULL; parser_it = parser_it->next) {
 
401
                        UnityMusicLensFilterParser* _tmp4_;
 
402
                        UnityMusicLensFilterParser* parser;
 
403
                        _tmp4_ = _g_object_ref0 ((UnityMusicLensFilterParser*) parser_it->data);
 
404
                        parser = _tmp4_;
 
405
                        {
 
406
                                gchar* _tmp5_ = NULL;
 
407
                                gchar* parsed;
 
408
                                gboolean _tmp6_ = FALSE;
 
409
                                _tmp5_ = unity_music_lens_filter_parser_parse (parser);
 
410
                                parsed = _tmp5_;
 
411
                                if (parsed == NULL) {
 
412
                                        _tmp6_ = TRUE;
 
413
                                } else {
 
414
                                        _tmp6_ = g_strcmp0 (parsed, "") == 0;
 
415
                                }
 
416
                                if (_tmp6_) {
 
417
                                        _g_free0 (parsed);
 
418
                                        _g_object_unref0 (parser);
 
419
                                        continue;
 
420
                                }
 
421
                                g_string_append (builder, " AND ");
 
422
                                g_string_append (builder, parsed);
 
423
                                _g_free0 (parsed);
 
424
                                _g_object_unref0 (parser);
 
425
                        }
 
426
                }
 
427
        }
 
428
        g_string_append (builder, " ");
 
429
        _tmp7_ = g_strdup (builder->str);
 
430
        result = _tmp7_;
 
431
        _g_string_free0 (builder);
 
432
        return result;
 
433
}
 
434
 
 
435
 
 
436
static void unity_music_lens_banshee_collection_class_init (UnityMusicLensBansheeCollectionClass * klass) {
 
437
        unity_music_lens_banshee_collection_parent_class = g_type_class_peek_parent (klass);
 
438
        g_type_class_add_private (klass, sizeof (UnityMusicLensBansheeCollectionPrivate));
 
439
        G_OBJECT_CLASS (klass)->finalize = unity_music_lens_banshee_collection_finalize;
 
440
}
 
441
 
 
442
 
 
443
static void unity_music_lens_banshee_collection_instance_init (UnityMusicLensBansheeCollection * self) {
 
444
        self->priv = UNITY_MUSIC_LENS_BANSHEE_COLLECTION_GET_PRIVATE (self);
 
445
}
 
446
 
 
447
 
 
448
static void unity_music_lens_banshee_collection_finalize (GObject* obj) {
 
449
        UnityMusicLensBansheeCollection * self;
 
450
        self = UNITY_MUSIC_LENS_BANSHEE_COLLECTION (obj);
 
451
        _sqlite3_close0 (self->priv->db);
 
452
        G_OBJECT_CLASS (unity_music_lens_banshee_collection_parent_class)->finalize (obj);
 
453
}
 
454
 
 
455
 
 
456
/**
 
457
 * Abstracts talking to the banshee collection database
 
458
 */
 
459
GType unity_music_lens_banshee_collection_get_type (void) {
 
460
        static volatile gsize unity_music_lens_banshee_collection_type_id__volatile = 0;
 
461
        if (g_once_init_enter (&unity_music_lens_banshee_collection_type_id__volatile)) {
 
462
                static const GTypeInfo g_define_type_info = { sizeof (UnityMusicLensBansheeCollectionClass), (GBaseInitFunc) NULL, (GBaseFinalizeFunc) NULL, (GClassInitFunc) unity_music_lens_banshee_collection_class_init, (GClassFinalizeFunc) NULL, NULL, sizeof (UnityMusicLensBansheeCollection), 0, (GInstanceInitFunc) unity_music_lens_banshee_collection_instance_init, NULL };
 
463
                GType unity_music_lens_banshee_collection_type_id;
 
464
                unity_music_lens_banshee_collection_type_id = g_type_register_static (G_TYPE_OBJECT, "UnityMusicLensBansheeCollection", &g_define_type_info, 0);
 
465
                g_once_init_leave (&unity_music_lens_banshee_collection_type_id__volatile, unity_music_lens_banshee_collection_type_id);
 
466
        }
 
467
        return unity_music_lens_banshee_collection_type_id__volatile;
 
468
}
 
469
 
 
470
 
 
471