Modify to use sqlite3_free in each functions

[platform/core/multimedia/libmedia-service.git] / src / media-svc.c

diff --git a/src/media-svc.c b/src/media-svc.c
index 74a2bb2..61eb839 100755 (executable)
--- a/src/media-svc.c
+++ b/src/media-svc.c
@@ -677,15 +677,12 @@ int media_svc_get_book_by_keyword(sqlite3 *handle, const char *keyword, uid_t ui
        int ret = MS_MEDIA_ERR_NONE;
        GList *item_list = NULL;
        GList *iter = NULL;
-       char *query = NULL;
+       const char *query = "SELECT media_path FROM media WHERE media_type=5 AND validity=1;";
 
        media_svc_retvm_if(!handle, MS_MEDIA_ERR_INVALID_PARAMETER, "db handle is NULL");
        media_svc_retvm_if(!keyword, MS_MEDIA_ERR_INVALID_PARAMETER, "keyword is NULL");
        media_svc_retvm_if(!result, MS_MEDIA_ERR_INVALID_PARAMETER, "result is NULL");
 
-       query = sqlite3_mprintf("SELECT media_path FROM %q WHERE media_type=%d AND validity=1;",
-                                                       DB_TABLE_MEDIA, MEDIA_SVC_MEDIA_TYPE_BOOK);
-
        ret = _media_svc_get_media(handle, query, &item_list);
        media_svc_retvm_if(ret != MS_MEDIA_ERR_NONE, ret, "_media_svc_get_media failed");