File: cache_intern.c

package info (click to toggle)
glyr 1.0.6+git20140423-1
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 1,724 kB
  • ctags: 1,275
  • sloc: ansic: 13,062; python: 1,052; ruby: 75; makefile: 15
file content (72 lines) | stat: -rw-r--r-- 2,735 bytes parent folder | download | duplicates (2)
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 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 General Public License for more details.
*
* You should have received a copy of the GNU 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;
}

/////////////////////////////////
/////////////////////////////////
/////////////////////////////////