From d7b39d172b10d94b06d2df2abd744bf26516edad Mon Sep 17 00:00:00 2001 From: Minje Ahn Date: Wed, 17 Apr 2019 15:37:46 +0900 Subject: Match columns of media with filter keyword Change-Id: I57740641cacbd2fd2d9f7bd8b016b88e77cf6a15 Signed-off-by: Minje Ahn --- src/include/util/media-thumb-db.h | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/src/include/util/media-thumb-db.h b/src/include/util/media-thumb-db.h index e7768e1..0173034 100755 --- a/src/include/util/media-thumb-db.h +++ b/src/include/util/media-thumb-db.h @@ -29,9 +29,9 @@ #define SQLITE3_FINALIZE(x) {if (x != NULL) sqlite3_finalize(x); } #define SQLITE3_SAFE_FREE(x) {if (x != NULL) {sqlite3_free(x); x = NULL; } } -#define SELECT_THUMB_BY_PATH "SELECT thumbnail_path FROM media_view WHERE path='%q' AND thumbnail_path IS NOT NULL;" -#define SELECT_STORAGE_ID_BY_PATH "SELECT storage_uuid FROM media_view WHERE path='%q';" -#define UPDATE_THUMB_BY_PATH "UPDATE '%q' SET thumbnail_path = '%q' WHERE path='%q';" +#define SELECT_THUMB_BY_PATH "SELECT media_thumbnail_path FROM media_view WHERE media_path='%q' AND media_thumbnail_path IS NOT NULL;" +#define SELECT_STORAGE_ID_BY_PATH "SELECT storage_uuid FROM media_view WHERE media_path='%q';" +#define UPDATE_THUMB_BY_PATH "UPDATE '%q' SET media_thumbnail_path = '%q' WHERE media_path='%q';" int _media_thumb_get_thumb_from_db(const char *origin_path, char *thumb_path, int max_length, uid_t uid); int _media_thumb_update_db(const char *origin_path, char *thumb_path, uid_t uid); -- cgit v1.2.3