Match columns of media with filter keyword 13/203713/1
authorMinje Ahn <minje.ahn@samsung.com>
Wed, 17 Apr 2019 06:37:46 +0000 (15:37 +0900)
committerMinje Ahn <minje.ahn@samsung.com>
Wed, 17 Apr 2019 06:37:46 +0000 (15:37 +0900)
Change-Id: I57740641cacbd2fd2d9f7bd8b016b88e77cf6a15
Signed-off-by: Minje Ahn <minje.ahn@samsung.com>
src/include/util/media-thumb-db.h

index e7768e1..0173034 100755 (executable)
@@ -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);