Improve readability of media_bookmark

[platform/core/api/media-content.git] / src / media_tag.c

diff --git a/src/media_tag.c b/src/media_tag.c
index 0a7de21..6f723b1 100755 (executable)
--- a/src/media_tag.c
+++ b/src/media_tag.c
@@ -58,7 +58,7 @@ static int __media_tag_insert_item_to_tag(int tag_id, const char *media_id)
        int ret = MEDIA_CONTENT_ERROR_NONE;
        char *query_str = NULL;
 
-       query_str = sqlite3_mprintf("INSERT INTO %q (tag_id, media_id) values (%d, '%q');", DB_TABLE_TAG_MAP, tag_id, media_id);
+       query_str = sqlite3_mprintf("INSERT OR IGNORE INTO %q (tag_id, media_id) values (%d, '%q');", DB_TABLE_TAG_MAP, tag_id, media_id);
        ret = media_svc_append_query(query_str, _content_get_uid());
 
        return _content_error_capi(ret);
@@ -97,7 +97,7 @@ static int __media_tag_get_tag_info_from_db(const char *name, media_tag_h tag)
 
        select_query = sqlite3_mprintf(SELECT_TAG_BY_NAME, name);
 
-       ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
+       ret = _content_get_result(select_query, &stmt);
        SQLITE3_SAFE_FREE(select_query);
        media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 
@@ -312,7 +312,7 @@ int media_tag_get_tag_from_db(int tag_id, media_tag_h *tag)
 
        snprintf(select_query, sizeof(select_query), SELECT_TAG_FROM_TAG, tag_id);
 
-       ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
+       ret = _content_get_result(select_query, &stmt);
        media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 
        media_tag_s *_tag = NULL;