1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
/***********************************************************
* This file is part of glyr
* + a commnadline tool and library to download various sort of music related metadata.
* + Copyright (C) [2011] [Christopher Pahl]
* + Hosted at: https://github.com/sahib/glyr
*
* glyr is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* glyr is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with glyr. If not, see <http://www.gnu.org/licenses/>.
**************************************************************/
#include "core.h"
#include "glyr.h"
#include "cache.h"
#include "cache_intern.h"
#include <glib.h>
/////////////////////////////////
/////////////////////////////////
/////////////////////////////////
/* Check if a cache is already in the db, by cheskum or source_url */
gboolean db_contains (GlyrDatabase * db, GlyrMemCache * cache)
{
gboolean result = FALSE;
if (db && cache)
{
gchar * sql = sqlite3_mprintf (
"SELECT source_url,data_checksum,data_size,data_type FROM metadata AS m "
"WHERE (m.data_type = %d AND m.data_size = %d AND m.data_checksum = '?') "
"OR (m.source_url LIKE '%q' AND m.source_url IS NOT NULL AND data_type = %d) "
"LIMIT 1; ",
cache->type,
cache->size,
cache->dsrc,
cache->type);
if (sql != NULL)
{
sqlite3_stmt * stmt = NULL;
sqlite3_prepare_v2 (db->db_handle, sql, strlen (sql) + 1, &stmt, NULL);
sqlite3_bind_blob (stmt, 1, cache->md5sum, sizeof cache->md5sum, SQLITE_TRANSIENT);
int err = sqlite3_step (stmt);
if (err == SQLITE_ROW)
{
result = TRUE;
}
else if (err != SQLITE_DONE)
{
glyr_message (-1,NULL,"db_contains: error message: %s\n", sqlite3_errmsg (db->db_handle) );
}
sqlite3_finalize (stmt);
sqlite3_free (sql);
}
}
return result;
}
/////////////////////////////////
/////////////////////////////////
/////////////////////////////////
|
