Modify to use sqlite3_free in each functions

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

diff --git a/src/media-svc-media.c b/src/media-svc-media.c
index ee7a737..a24bdab 100755 (executable)
--- a/src/media-svc-media.c
+++ b/src/media-svc-media.c
@@ -42,6 +42,7 @@ int _media_svc_check_data_by_path(sqlite3 *handle, const char *path)
 
        sql = sqlite3_mprintf("SELECT 1 FROM %q WHERE media_path=%Q", DB_TABLE_MEDIA, path);
        ret = _media_svc_sql_prepare_to_step(handle, sql, &sql_stmt);
+       SQLITE3_SAFE_FREE(sql);
        media_svc_retv_if(ret != MS_MEDIA_ERR_NONE, ret);
        SQLITE3_FINALIZE(sql_stmt);
 
@@ -58,6 +59,7 @@ int _media_svc_get_modified_time(sqlite3 *handle, const char *path, int *modifie
 
        sql = sqlite3_mprintf("SELECT media_modified_time FROM %q WHERE media_path=%Q", DB_TABLE_MEDIA, path);
        ret = _media_svc_sql_prepare_to_step(handle, sql, &sql_stmt);
+       SQLITE3_SAFE_FREE(sql);
        media_svc_retv_if(ret != MS_MEDIA_ERR_NONE, ret);
 
        *modified_time = sqlite3_column_int(sql_stmt, 0);
@@ -166,7 +168,7 @@ int _media_svc_get_thumbnail_path_by_path(sqlite3 *handle, const char *path, cha
        sql = sqlite3_mprintf("SELECT media_thumbnail_path FROM %q WHERE media_path=%Q", DB_TABLE_MEDIA, path);
 
        ret = _media_svc_sql_prepare_to_step(handle, sql, &sql_stmt);
-
+       SQLITE3_SAFE_FREE(sql);
        if (ret != MS_MEDIA_ERR_NONE) {
                if (ret == MS_MEDIA_ERR_DB_NO_RECORD)
                        media_svc_debug("there is no thumbnail.");
@@ -313,6 +315,7 @@ int _media_svc_get_noti_info(sqlite3 *handle, const char *path, media_svc_noti_i
 
        sql = sqlite3_mprintf("SELECT media_id, media_type, media_mime_type FROM %q WHERE media_path=%Q", DB_TABLE_MEDIA, path);
        ret = _media_svc_sql_prepare_to_step(handle, sql, &sql_stmt);
+       SQLITE3_SAFE_FREE(sql);
        media_svc_retvm_if(ret != MS_MEDIA_ERR_NONE, ret, "_media_svc_sql_prepare_to_step() failed [%d]", ret);
 
        *item = g_new0(media_svc_noti_item, 1);