Modify to use sqlite3_free in each functions

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

diff --git a/src/media-svc-media-folder.c b/src/media-svc-media-folder.c
index e594cc2..f679826 100755 (executable)
--- a/src/media-svc-media-folder.c
+++ b/src/media-svc-media-folder.c
@@ -30,11 +30,10 @@ static int __media_svc_get_folder_id(sqlite3 *handle, const char *path, long lon
 {
        int ret = MS_MEDIA_ERR_NONE;
        sqlite3_stmt *sql_stmt = NULL;
-       char *sql = NULL;
-
-       sql = sqlite3_mprintf("SELECT folder_id FROM %q WHERE folder_path=%Q", DB_TABLE_FOLDER, path);
+       char *sql = sqlite3_mprintf("SELECT folder_id FROM %q WHERE folder_path=%Q", DB_TABLE_FOLDER, 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);
 
        *folder_id = sqlite3_column_int64(sql_stmt, 0);
@@ -184,6 +183,7 @@ int _media_svc_check_folder_by_path(sqlite3 *handle, const char *path)
 
        sql = sqlite3_mprintf("SELECT 1 FROM %q WHERE folder_path=%Q", DB_TABLE_FOLDER, 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);