Remove duplicated memory setting
[platform/core/api/media-content.git] / src / media_playlist.c
index 06353a8..172bbbb 100755 (executable)
 #include <media_filter.h>
 #include <media_info.h>
 #include <media_info_private.h>
-#include <media_playlist.h>
+#include <media_util_private.h>
 
-
-static __thread GList *g_playlist_item_list = NULL;
-
-static void __media_playlist_item_add(media_playlist_item_s *item_s);
-static void __media_playlist_item_release(void);
-static int __media_playlist_insert_playlist_record(const char *playlist_name, int *playlist_id);
-static int __media_playlist_insert_item_to_playlist(int playlist_id, const char *media_id);
-static int __media_playlist_remove_item_from_playlist(int playlist_id, int playlist_member_id);
-static int __media_playlist_update_playlist_name(int playlist_id, const char *playlist_name);
-static int __media_playlist_update_thumbnail_path(int playlist_id, const char *path);
-static int __media_playlist_update_play_order(int playlist_id, int playlist_member_id, int play_order);
-
-static void __media_playlist_item_add(media_playlist_item_s *item_s)
+static void __media_playlist_item_free(gpointer item)
 {
-       g_playlist_item_list = g_list_append(g_playlist_item_list, item_s);
+       media_playlist_item_s *_item = (media_playlist_item_s *)item;
+       SAFE_FREE(_item->media_id);
+       SAFE_FREE(_item->playlist_name);
+       SAFE_FREE(_item->thumbnail_path);
+       SAFE_FREE(_item);
 }
 
-static void __media_playlist_item_release(void)
+static void __media_playlist_item_release(media_playlist_s *playlist)
 {
-       int idx = 0;
-       int list_cnt = 0;
-       media_playlist_item_s *item = NULL;
-
-       list_cnt = g_list_length(g_playlist_item_list);
-
-       media_content_debug("list_cnt : [%d]", list_cnt);
-
-       for(idx = 0; idx < list_cnt; idx++)
-       {
-               item = (media_playlist_item_s*)g_list_nth_data(g_playlist_item_list, idx);
-               if(item != NULL)
-               {
-                       SAFE_FREE(item->media_id);
-                       SAFE_FREE(item->playlist_name);
-                       SAFE_FREE(item->thumbnail_path);
-                       SAFE_FREE(item);
-               }
-       }
-
-       g_list_free(g_playlist_item_list);
-       g_playlist_item_list = NULL;
+       if (!playlist || !playlist->item_list)
+               return;
 
+       g_list_free_full(playlist->item_list, __media_playlist_item_free);
+       playlist->item_list = NULL;
 }
 
 static int __media_playlist_insert_playlist_record(const char *playlist_name, int *playlist_id)
 {
        int ret = MEDIA_CONTENT_ERROR_NONE;
-       char *query_str = NULL;
-       char *select_query = NULL;
+       char *query = NULL;
        sqlite3_stmt *stmt = NULL;
 
-       query_str = sqlite3_mprintf(INSERT_PLAYLIST_TO_PLAYLIST, playlist_name);
+       query = sqlite3_mprintf(INSERT_PLAYLIST_TO_PLAYLIST, playlist_name);
 
-       ret = _content_query_sql(query_str);
-       sqlite3_free(query_str);
-       media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
+       ret = _content_query_sql(query);
+       SQLITE3_SAFE_FREE(query);
+       content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 
-       select_query = sqlite3_mprintf(SELECT_PLAYLIST_ID_FROM_PLAYLIST, playlist_name);
+       query = sqlite3_mprintf(SELECT_PLAYLIST_ID_FROM_PLAYLIST, playlist_name);
 
-       ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
-       sqlite3_free(select_query);
-       media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
+       ret = _content_get_result(query, &stmt);
+       SQLITE3_SAFE_FREE(query);
+       content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 
-       while(sqlite3_step(stmt) == SQLITE_ROW)
-       {
-               *playlist_id = (int)sqlite3_column_int(stmt,0);
-       }
+       if (sqlite3_step(stmt) == SQLITE_ROW)
+               *playlist_id = sqlite3_column_int(stmt, 0);
 
        SQLITE3_FINALIZE(stmt);
 
@@ -97,33 +68,25 @@ static int __media_playlist_insert_item_to_playlist(int playlist_id, const char
 {
        int ret = MEDIA_CONTENT_ERROR_NONE;
        sqlite3_stmt *stmt = NULL;
-       char select_query[DEFAULT_QUERY_SIZE];
-       char *query_str = NULL;
+       char *query = NULL;
        int play_order = 0;
 
-       memset(select_query, 0x00, sizeof(select_query));
-
-       snprintf(select_query, sizeof(select_query), SELECT_MAX_PLAY_ORDER_FROM_PLAYLIST_VIEW, playlist_id);
+       query = sqlite3_mprintf(SELECT_MAX_PLAY_ORDER_FROM_PLAYLIST_VIEW, playlist_id);
 
        /* get the max play_order */
-       ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
-       media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
+       ret = _content_get_result(query, &stmt);
+       SQLITE3_SAFE_FREE(query);
+       content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 
-       while(sqlite3_step(stmt) == SQLITE_ROW)
-       {
-               play_order = (int)sqlite3_column_int(stmt, 0);
-       }
+       if (sqlite3_step(stmt) == SQLITE_ROW)
+               play_order = sqlite3_column_int(stmt, 0);
 
        SQLITE3_FINALIZE(stmt);
 
-       ++play_order;
-
-       query_str = sqlite3_mprintf("INSERT INTO %q (playlist_id, media_uuid, play_order) values (%d, '%q', %d)",
-                       DB_TABLE_PLAYLIST_MAP, playlist_id, media_id, play_order);
-       ret = _content_query_sql(query_str);
-       sqlite3_free(query_str);
+       query = sqlite3_mprintf(INSERT_PLAYLIST_ITEM_TO_PLAYLIST_MAP, playlist_id, media_id, ++play_order);
+       ret = media_svc_append_query(query, _content_get_uid());
 
-       return ret;
+       return _content_error_capi(ret);
 }
 
 static int __media_playlist_remove_item_from_playlist(int playlist_id, int playlist_member_id)
@@ -132,11 +95,9 @@ static int __media_playlist_remove_item_from_playlist(int playlist_id, int playl
        char *query_str = NULL;
 
        query_str = sqlite3_mprintf(REMOVE_PLAYLIST_ITEM_FROM_PLAYLIST_MAP, playlist_id, playlist_member_id);
+       ret = media_svc_append_query(query_str, _content_get_uid());
 
-       ret = _content_query_sql(query_str);
-       sqlite3_free(query_str);
-
-       return ret;
+       return _content_error_capi(ret);
 }
 
 static int __media_playlist_update_playlist_name(int playlist_id, const char *playlist_name)
@@ -145,11 +106,9 @@ static int __media_playlist_update_playlist_name(int playlist_id, const char *pl
        char *query_str = NULL;
 
        query_str = sqlite3_mprintf(UPDATE_PLAYLIST_NAME_FROM_PLAYLIST, playlist_name, playlist_id);
+       ret = media_svc_append_query(query_str, _content_get_uid());
 
-       ret = _content_query_sql(query_str);
-       sqlite3_free(query_str);
-
-       return ret;
+       return _content_error_capi(ret);
 }
 
 static int __media_playlist_update_thumbnail_path(int playlist_id, const char *path)
@@ -158,11 +117,9 @@ static int __media_playlist_update_thumbnail_path(int playlist_id, const char *p
        char *query_str = NULL;
 
        query_str = sqlite3_mprintf(UPDATE_PLAYLIST_THUMBNAIL_FROM_PLAYLIST, path, playlist_id);
+       ret = media_svc_append_query(query_str, _content_get_uid());
 
-       ret = _content_query_sql(query_str);
-       sqlite3_free(query_str);
-
-       return ret;
+       return _content_error_capi(ret);
 }
 
 static int __media_playlist_update_play_order(int playlist_id, int playlist_member_id, int play_order)
@@ -171,358 +128,285 @@ static int __media_playlist_update_play_order(int playlist_id, int playlist_memb
        char *query_str = NULL;
 
        query_str = sqlite3_mprintf(UPDATE_PLAYLIST_ORDER_FROM_PLAYLIST_MAP, play_order, playlist_id, playlist_member_id);
+       ret = media_svc_append_query(query_str, _content_get_uid());
 
-       ret = _content_query_sql(query_str);
-       sqlite3_free(query_str);
-
-       return ret;
+       return _content_error_capi(ret);
 }
 
-int media_playlist_insert_to_db(const char *name, media_playlist_h *playlist)
+static bool __media_playlist_member_cb(int playlist_member_id, media_info_h media, void *user_data)
 {
        int ret = MEDIA_CONTENT_ERROR_NONE;
-       int playlist_id = 0;
+       GList **list = (GList**)user_data;
+       char *path = NULL;
 
-       if(!STRING_VALID(name))
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
+       ret = media_info_get_file_path(media, &path);
+       content_retvm_if(ret != MEDIA_CONTENT_ERROR_NONE, FALSE, "media_info_get_file_path fail");
 
-       media_playlist_s *_playlist = (media_playlist_s*)calloc(1, sizeof(media_playlist_s));
+       *list = g_list_append(*list, path);
 
-       if(_playlist == NULL)
-       {
-               media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
-               return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
-       }
+       return TRUE;
+}
 
-       ret = __media_playlist_insert_playlist_record(name, &playlist_id);
+static int __media_playlist_reset_file(const char *playlist_path)
+{
+       FILE *fp = NULL;
 
-       if(ret != MEDIA_CONTENT_ERROR_NONE)
-       {
-               SAFE_FREE(_playlist);
-               return ret;
+       fp = fopen(playlist_path, "wb");
+       if (fp == NULL) {
+               content_stderror("fopen failed");
+               return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
        }
 
-       _playlist->playlist_id = playlist_id;
-       _playlist->name = strdup(name);
+       fputs("", fp);  /* remove previous playlist */
 
-       if(_playlist->name == NULL)
-       {
-               SAFE_FREE(_playlist);
-               media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
-               return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
+       fclose(fp);
+
+       return MEDIA_CONTENT_ERROR_NONE;
+}
+
+static int __media_playlist_append_to_file(const char *playlist_path, const char *path)
+{
+       FILE *fp = NULL;
+
+       fp = fopen(playlist_path, "a"); /* append only */
+       if (fp == NULL) {
+               content_stderror("fopen failed");
+               return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
        }
 
-       *playlist = (media_playlist_h)_playlist;
 
-       return ret;
+       fputs(path, fp);
+       fputs("\n", fp);
+
+       fclose(fp);
+
+       return MEDIA_CONTENT_ERROR_NONE;
 }
 
-int media_playlist_delete_from_db(int playlist_id)
+static int __media_playlist_import_item_from_file(const char *playlist_path, GSList **item_list)
 {
-       int ret = MEDIA_CONTENT_ERROR_NONE;
-       char *query_str = NULL;
+       int tmp_str_len = 0;
+       char tmp_str[MAX_PATH_LEN] = {0, };
+       char repl_item[MAX_PATH_LEN] = {0, };
+       FILE *fp = NULL;
 
-       if(playlist_id < 0)
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
+       fp = fopen(playlist_path, "rb");
+       if (fp == NULL) {
+               content_stderror("fopen failed");
+               return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
        }
 
-       query_str = sqlite3_mprintf(DELETE_PLAYLIST_FROM_PLAYLIST, playlist_id);
+       while (fgets(tmp_str, MAX_PATH_LEN, fp) != NULL) {
+               memset(repl_item, 0, sizeof(repl_item));
+               _media_content_replace_path(tmp_str, repl_item);
 
-       ret = _content_query_sql(query_str);
+               tmp_str_len = strlen(repl_item);
+               /* Check for empty file */
+               if (tmp_str_len <= 1)
+                       continue;
 
-       sqlite3_free(query_str);
+               if (repl_item[0] == '#')
+                       continue;
 
-       return ret;
+
+               if (repl_item[tmp_str_len - 1] == '\n')
+                       repl_item[tmp_str_len - 1] = '\0';
+
+               *item_list = g_slist_append(*item_list, g_strdup(repl_item));
+       }
+
+       fclose(fp);
+
+       return MEDIA_CONTENT_ERROR_NONE;
 }
 
-int media_playlist_get_playlist_count_from_db(filter_h filter, int *playlist_count)
+int media_playlist_insert_to_db(const char *name, media_playlist_h *playlist)
 {
        int ret = MEDIA_CONTENT_ERROR_NONE;
+       int playlist_id = 0;
 
-       media_content_debug_func();
+       content_retip_if_fail(STRING_VALID(name));
 
-       if(playlist_count != NULL)
-       {
-               ret = _media_db_get_group_count(filter, MEDIA_GROUP_PLAYLIST, playlist_count);
-       }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
+       media_playlist_s *_playlist = (media_playlist_s *)calloc(1, sizeof(media_playlist_s));
+       content_retvm_if(_playlist == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
+
+       ret = __media_playlist_insert_playlist_record(name, &playlist_id);
+       if (ret != MEDIA_CONTENT_ERROR_NONE) {
+               SAFE_FREE(_playlist);
+               return ret;
        }
 
+       _playlist->playlist_id = playlist_id;
+       _playlist->name = g_strdup(name);
+
+       *playlist = (media_playlist_h)_playlist;
+
        return ret;
 }
 
-int media_playlist_foreach_playlist_from_db(filter_h filter, media_playlist_cb callback, void *user_data)
+int media_playlist_delete_from_db(int playlist_id)
 {
        int ret = MEDIA_CONTENT_ERROR_NONE;
+       char *query_str = NULL;
 
-       media_content_debug_func();
+       content_retipm_if_fail(playlist_id >= 0, "%d", playlist_id);
 
-       if(callback == NULL)
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
+       query_str = sqlite3_mprintf(DELETE_PLAYLIST_FROM_PLAYLIST, playlist_id);
 
-       ret = _media_db_get_playlist(filter, callback, user_data);
+       ret = _content_query_sql(query_str);
+       SQLITE3_SAFE_FREE(query_str);
 
        return ret;
 }
 
-int media_playlist_get_media_count_from_db(int playlist_id, filter_h filter, int *media_count)
+int media_playlist_get_playlist_count_from_db(filter_h filter, int *playlist_count)
 {
-       int ret = MEDIA_CONTENT_ERROR_NONE;
+       content_retip_if_fail(playlist_count);
 
-       media_content_debug_func();
+       return _media_db_get_group_count(filter, MEDIA_GROUP_PLAYLIST, playlist_count);
+}
 
-       if((playlist_id > 0) && (media_count != NULL))
-       {
-               ret = _media_db_get_group_item_count_by_id(playlist_id, filter, MEDIA_GROUP_PLAYLIST, media_count);
-       }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
+int media_playlist_foreach_playlist_from_db(filter_h filter, media_playlist_cb callback, void *user_data)
+{
+       content_retip_if_fail(callback);
 
-       return ret;
+       return _media_db_get_playlist(filter, callback, user_data);
 }
 
-int media_playlist_foreach_media_from_db(int playlist_id, filter_h filter, playlist_member_cb callback, void *user_data)
+int media_playlist_get_media_count_from_db(int playlist_id, filter_h filter, int *media_count)
 {
-       int ret = MEDIA_CONTENT_ERROR_NONE;
+       content_retip_if_fail(media_count);
+       content_retipm_if_fail(playlist_id > 0, "%d", playlist_id);
 
-       media_content_debug_func();
+       return _media_db_get_group_item_count_by_id(playlist_id, filter, MEDIA_GROUP_PLAYLIST, media_count);
+}
 
-       if((playlist_id > 0) && (callback != NULL))
-       {
-               //ret = _media_db_get_group_item_by_id(playlist_id, filter, callback, user_data, MEDIA_GROUP_PLAYLIST);
-               ret = _media_db_get_playlist_item(playlist_id, filter, callback, user_data);
-       }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
+int media_playlist_foreach_media_from_db(int playlist_id, filter_h filter, playlist_member_cb callback, void *user_data)
+{
+       content_retip_if_fail(callback);
+       content_retipm_if_fail(playlist_id > 0, "%d", playlist_id);
 
-       return ret;
+       return _media_db_get_playlist_item(playlist_id, filter, callback, user_data);
 }
 
 int media_playlist_destroy(media_playlist_h playlist)
 {
-       int ret = MEDIA_CONTENT_ERROR_NONE;
-       media_playlist_s *_playlist = (media_playlist_s*)playlist;
+       media_playlist_s *_playlist = (media_playlist_s *)playlist;
+       content_retip_if_fail(playlist);
 
-       if(_playlist)
-       {
-               SAFE_FREE(_playlist->name);
-               SAFE_FREE(_playlist);
+       SAFE_FREE(_playlist->name);
+       SAFE_FREE(_playlist->thumbnail_path);
+       SAFE_FREE(_playlist);
 
-               ret = MEDIA_CONTENT_ERROR_NONE;
-       }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
-
-       return ret;
+       return MEDIA_CONTENT_ERROR_NONE;
 }
 
 int media_playlist_clone(media_playlist_h *dst, media_playlist_h src)
 {
-       int ret = MEDIA_CONTENT_ERROR_NONE;
-       media_playlist_s *_src = (media_playlist_s*)src;
-
-       if(_src != NULL)
-       {
-               media_playlist_s *_dst = (media_playlist_s*)calloc(1, sizeof(media_playlist_s));
-               if(_dst == NULL)
-               {
-                       media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
-                       return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
-               }
-
-               _dst->playlist_id = _src->playlist_id;
+       media_playlist_s *_src = (media_playlist_s *)src;
+       content_retip_if_fail(_src);
 
-               if(STRING_VALID(_src->name))
-               {
-                       _dst->name = strdup(_src->name);
-                       if(_dst->name == NULL)
-                       {
-                               media_playlist_destroy((media_playlist_h)_dst);
-                               media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
-                               return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
-                       }
-               }
+       media_playlist_s *_dst = (media_playlist_s *)calloc(1, sizeof(media_playlist_s));
+       content_retvm_if(_dst == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
 
-               *dst = (media_playlist_h)_dst;
+       _dst->playlist_id = _src->playlist_id;
+       _dst->name = g_strdup(_src->name);
 
-               ret = MEDIA_CONTENT_ERROR_NONE;
-       }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
+       *dst = (media_playlist_h)_dst;
 
-       return ret;
+       return MEDIA_CONTENT_ERROR_NONE;
 }
 
 int media_playlist_get_playlist_from_db(int playlist_id, media_playlist_h *playlist)
 {
        int ret = MEDIA_CONTENT_ERROR_NONE;
        sqlite3_stmt *stmt = NULL;
-       char select_query[DEFAULT_QUERY_SIZE];
-
-       if(playlist_id > 0)
-       {
-               memset(select_query, 0x00, sizeof(select_query));
+       char *query = NULL;
 
-               snprintf(select_query, sizeof(select_query), SELECT_PLAYLIST_FROM_PLAYLIST, playlist_id);
+       content_retipm_if_fail(playlist_id > 0, "%d", playlist_id);
 
-               ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
-               media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
+       query = sqlite3_mprintf(SELECT_PLAYLIST_FROM_PLAYLIST, playlist_id);
 
-               while(sqlite3_step(stmt) == SQLITE_ROW)
-               {
-                       media_playlist_s *_playlist = (media_playlist_s*)calloc(1, sizeof(media_playlist_s));
+       ret = _content_get_result(query, &stmt);
+       SQLITE3_SAFE_FREE(query);
+       content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 
-                       _playlist->playlist_id = (int)sqlite3_column_int(stmt, 0);
-                       if(STRING_VALID((const char *)sqlite3_column_text(stmt, 1)))
-                               _playlist->name = strdup((const char *)sqlite3_column_text(stmt, 1));
-                       if(STRING_VALID((const char *)sqlite3_column_text(stmt, 2)))
-                               _playlist->thumbnail_path = strdup((const char *)sqlite3_column_text(stmt, 2));
+       media_playlist_s *_playlist = NULL;
 
-                       *playlist = (media_playlist_h)_playlist;
+       if (sqlite3_step(stmt) == SQLITE_ROW) {
+               _playlist = (media_playlist_s *)calloc(1, sizeof(media_playlist_s));
+               if (_playlist == NULL) {
+                       content_error("Out of memory");
+                       SQLITE3_FINALIZE(stmt);
+                       return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
                }
 
-               SQLITE3_FINALIZE(stmt);
-       }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
+               _playlist->playlist_id = playlist_id;
+               _playlist->name = g_strdup((const char *)sqlite3_column_text(stmt, 0));
+               _playlist->thumbnail_path = g_strdup((const char *)sqlite3_column_text(stmt, 1));
+
+               *playlist = (media_playlist_h)_playlist;
+       } else {
+               content_error("Nonexistent playlist id[%d]", playlist_id);
                ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
        }
 
+       SQLITE3_FINALIZE(stmt);
+
        return ret;
 }
 
 int media_playlist_get_playlist_id(media_playlist_h playlist, int *playlist_id)
 {
-       int ret = MEDIA_CONTENT_ERROR_NONE;
+       media_playlist_s *_playlist = (media_playlist_s *)playlist;
+       content_retip_if_fail(playlist);
+       content_retip_if_fail(playlist_id);
 
-       media_playlist_s *_playlist = (media_playlist_s*)playlist;
+       *playlist_id = _playlist->playlist_id;
 
-       if((_playlist != NULL) && (playlist_id != NULL))
-       {
-               *playlist_id = _playlist->playlist_id;
-       }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
-
-       return ret;
+       return MEDIA_CONTENT_ERROR_NONE;
 }
 
 int media_playlist_get_name(media_playlist_h playlist, char **name)
 {
-       int ret = MEDIA_CONTENT_ERROR_NONE;
-       media_playlist_s *_playlist = (media_playlist_s*)playlist;
-       if(_playlist)
-       {
-               if(STRING_VALID(_playlist->name))
-               {
-                       *name = strdup(_playlist->name);
-                       if(*name == NULL)
-                       {
-                               media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
-                               return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
-                       }
-               }
-               else
-               {
-                       *name = NULL;
-               }
+       media_playlist_s *_playlist = (media_playlist_s *)playlist;
+       content_retip_if_fail(playlist);
+       content_retip_if_fail(name);
 
-               ret = MEDIA_CONTENT_ERROR_NONE;
-       }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
+       *name = g_strdup(_playlist->name);
 
-       return ret;
+       return MEDIA_CONTENT_ERROR_NONE;
 }
 
 int media_playlist_get_thumbnail_path(media_playlist_h playlist, char **path)
 {
-       int ret = MEDIA_CONTENT_ERROR_NONE;
-       media_playlist_s *_playlist = (media_playlist_s*)playlist;
-       if(_playlist)
-       {
-               if(STRING_VALID(_playlist->thumbnail_path))
-               {
-                       *path = strdup(_playlist->thumbnail_path);
-                       if(*path == NULL)
-                       {
-                               media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
-                               return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
-                       }
-               }
-               else
-               {
-                       *path = NULL;
-               }
+       media_playlist_s *_playlist = (media_playlist_s *)playlist;
+       content_retip_if_fail(playlist);
+       content_retip_if_fail(path);
 
-               ret = MEDIA_CONTENT_ERROR_NONE;
-       }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
+       *path = g_strdup(_playlist->thumbnail_path);
 
-       return ret;
+       return MEDIA_CONTENT_ERROR_NONE;
 }
 
 int media_playlist_get_play_order(media_playlist_h playlist, int playlist_member_id, int *play_order)
 {
        int ret = MEDIA_CONTENT_ERROR_NONE;
-       media_playlist_s *_playlist = (media_playlist_s*)playlist;
-       int playlist_id = 0;
+       media_playlist_s *_playlist = (media_playlist_s *)playlist;
        sqlite3_stmt *stmt = NULL;
-       char select_query[DEFAULT_QUERY_SIZE];
-
-       if((_playlist == NULL) || (playlist_member_id < 0) || (play_order == NULL))
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
-
-       playlist_id = _playlist->playlist_id;
+       char *query = NULL;
 
-       memset(select_query, 0x00, sizeof(select_query));
+       content_retip_if_fail(playlist);
+       content_retipm_if_fail(playlist_member_id >= 0, "%d", playlist_member_id);
+       content_retip_if_fail(play_order);
 
-       snprintf(select_query, sizeof(select_query), SELECT_PLAY_ORDER_FROM_PLAYLIST_VIEW, playlist_id, playlist_member_id);
+       query = sqlite3_mprintf(SELECT_PLAY_ORDER_FROM_PLAYLIST_VIEW, _playlist->playlist_id, playlist_member_id);
+       ret = _content_get_result(query, &stmt);
+       SQLITE3_SAFE_FREE(query);
+       content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
 
-       ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
-       media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
-
-       while(sqlite3_step(stmt) == SQLITE_ROW)
-       {
-               *play_order = (int)sqlite3_column_int(stmt, 0);
-       }
+       if (sqlite3_step(stmt) == SQLITE_ROW)
+               *play_order = sqlite3_column_int(stmt, 0);
 
        SQLITE3_FINALIZE(stmt);
 
@@ -531,216 +415,343 @@ int media_playlist_get_play_order(media_playlist_h playlist, int playlist_member
 
 int media_playlist_set_name(media_playlist_h playlist, const char *playlist_name)
 {
-       int ret = MEDIA_CONTENT_ERROR_NONE;
-       media_playlist_s *_playlist = (media_playlist_s*)playlist;
+       media_playlist_s *_playlist = (media_playlist_s *)playlist;
+       media_playlist_item_s *item = NULL;
 
-       if(_playlist != NULL && STRING_VALID(playlist_name))
-       {
-               SAFE_FREE(_playlist->name);
+       content_retip_if_fail(playlist);
+       content_retip_if_fail(STRING_VALID(playlist_name));
 
-               media_playlist_item_s *item = (media_playlist_item_s*)calloc(1, sizeof(media_playlist_item_s));
+       SAFE_FREE(_playlist->name);
 
-               item->playlist_name = strdup(playlist_name);
-               item->function = MEDIA_PLAYLIST_UPDATE_PLAYLIST_NAME;
-               if(item->playlist_name == NULL)
-               {
-                       SAFE_FREE(item);
-                       media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
-                       return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
-               }
+       item = (media_playlist_item_s *)calloc(1, sizeof(media_playlist_item_s));
+       content_retvm_if(item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
 
-               _playlist->name = strdup(playlist_name);
-               if(_playlist->name == NULL)
-               {
-                       SAFE_FREE(item->playlist_name);
-                       SAFE_FREE(item);
-                       media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
-                       return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
-               }
+       item->playlist_name = g_strdup(playlist_name);
+       item->function = MEDIA_PLAYLIST_UPDATE_PLAYLIST_NAME;
 
-               __media_playlist_item_add(item);
-       }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
+       _playlist->name = g_strdup(playlist_name);
+       _playlist->item_list = g_list_append(_playlist->item_list, item);
 
-       return ret;
+       return MEDIA_CONTENT_ERROR_NONE;
 }
 
 int media_playlist_set_thumbnail_path(media_playlist_h playlist, const char *path)
 {
-       int ret = MEDIA_CONTENT_ERROR_NONE;
-       media_playlist_s *_playlist = (media_playlist_s*)playlist;
+       media_playlist_s *_playlist = (media_playlist_s *)playlist;
+       media_playlist_item_s *item = NULL;
 
-       if(_playlist != NULL && STRING_VALID(path))
-       {
-               SAFE_FREE(_playlist->thumbnail_path);
+       content_retip_if_fail(playlist);
+       content_retip_if_fail(STRING_VALID(path));
 
-               media_playlist_item_s *item = (media_playlist_item_s*)calloc(1, sizeof(media_playlist_item_s));
+       SAFE_FREE(_playlist->thumbnail_path);
 
-               item->thumbnail_path = strdup(path);
-               item->function = MEDIA_PLAYLIST_UPDATE_THUMBNAIL_PATH;
-               if(item->thumbnail_path == NULL)
-               {
-                       SAFE_FREE(item);
-                       media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
-                       return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
-               }
+       item = (media_playlist_item_s *)calloc(1, sizeof(media_playlist_item_s));
+       content_retvm_if(item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
 
-               _playlist->thumbnail_path = strdup(path);
-               if(_playlist->thumbnail_path == NULL)
-               {
-                       SAFE_FREE(item->thumbnail_path);
-                       SAFE_FREE(item);
-                       media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
-                       return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
-               }
+       item->thumbnail_path = g_strdup(path);
+       item->function = MEDIA_PLAYLIST_UPDATE_THUMBNAIL_PATH;
 
-               __media_playlist_item_add(item);
-       }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
+       _playlist->thumbnail_path = g_strdup(path);
+       _playlist->item_list = g_list_append(_playlist->item_list, item);
 
-       return ret;
+       return MEDIA_CONTENT_ERROR_NONE;
 }
 
 int media_playlist_set_play_order(media_playlist_h playlist, int playlist_member_id, int play_order)
 {
-       int ret = MEDIA_CONTENT_ERROR_NONE;
-       media_playlist_s *_playlist = (media_playlist_s*)playlist;
+       media_playlist_s *_playlist = (media_playlist_s *)playlist;
+       media_playlist_item_s *item = NULL;
 
-       if((_playlist != NULL) && (playlist_member_id > 0) && (play_order >= 0))
-       {
-               media_playlist_item_s *item = (media_playlist_item_s*)calloc(1, sizeof(media_playlist_item_s));
+       content_retip_if_fail(playlist);
+       content_retipm_if_fail(playlist_member_id > 0, "%d", playlist_member_id);
+       content_retipm_if_fail(play_order >= 0, "%d", play_order);
 
-               item->playlist_member_id = playlist_member_id;
-               item->function = MEDIA_PLAYLIST_UPDATE_PLAY_ORDER;
-               item->play_order = play_order;
+       item = (media_playlist_item_s *)calloc(1, sizeof(media_playlist_item_s));
+       content_retvm_if(item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
 
-               __media_playlist_item_add(item);
-       }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
-       }
+       item->playlist_member_id = playlist_member_id;
+       item->function = MEDIA_PLAYLIST_UPDATE_PLAY_ORDER;
+       item->play_order = play_order;
 
-       return ret;
+       _playlist->item_list = g_list_append(_playlist->item_list, item);
+
+       return MEDIA_CONTENT_ERROR_NONE;
 }
 
 int media_playlist_add_media(media_playlist_h playlist, const char *media_id)
 {
+       media_playlist_s *_playlist = (media_playlist_s *)playlist;
+       media_playlist_item_s *item = NULL;
+
+       content_retip_if_fail(playlist);
+       content_retip_if_fail(STRING_VALID(media_id));
+
+       item = (media_playlist_item_s *)calloc(1, sizeof(media_playlist_item_s));
+       content_retvm_if(item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
+
+       item->media_id = g_strdup(media_id);
+       item->function = MEDIA_PLAYLIST_ADD;
+
+       _playlist->item_list = g_list_append(_playlist->item_list, item);
+
+       return MEDIA_CONTENT_ERROR_NONE;
+}
+
+int media_playlist_remove_media(media_playlist_h playlist, int playlist_member_id)
+{
+       media_playlist_s *_playlist = (media_playlist_s *)playlist;
+       media_playlist_item_s *item = NULL;
+
+       content_retip_if_fail(playlist);
+       content_retipm_if_fail(playlist_member_id > 0, "%d", playlist_member_id);
+
+       item = (media_playlist_item_s *)calloc(1, sizeof(media_playlist_item_s));
+       content_retvm_if(item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
+
+       item->playlist_member_id = playlist_member_id;
+       item->function = MEDIA_PLAYLIST_REMOVE;
+
+       _playlist->item_list = g_list_append(_playlist->item_list, item);
+
+       return MEDIA_CONTENT_ERROR_NONE;
+}
+
+void __media_playlist_foreach_request(gpointer data, gpointer user_data)
+{
        int ret = MEDIA_CONTENT_ERROR_NONE;
-       media_playlist_s *_playlist = (media_playlist_s*)playlist;
+       media_playlist_item_s *_playlist_item = (media_playlist_item_s *)data;
+       int playlist_id = *((int *)user_data);
 
-       if(_playlist != NULL && STRING_VALID(media_id))
-       {
-               media_playlist_item_s *item = (media_playlist_item_s*)calloc(1, sizeof(media_playlist_item_s));
+       if (!_playlist_item)
+               return;
 
-               item->media_id = strdup(media_id);
-               item->function = MEDIA_PLAYLIST_ADD;
+       switch (_playlist_item->function) {
+       case MEDIA_PLAYLIST_ADD:
+               ret = __media_playlist_insert_item_to_playlist(playlist_id, _playlist_item->media_id);
+               break;
 
-               if(item->media_id == NULL)
-               {
-                       SAFE_FREE(item);
-                       media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
-                       return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
-               }
+       case MEDIA_PLAYLIST_REMOVE:
+               ret = __media_playlist_remove_item_from_playlist(playlist_id, _playlist_item->playlist_member_id);
+               break;
 
-               __media_playlist_item_add(item);
-       }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
+       case MEDIA_PLAYLIST_UPDATE_PLAYLIST_NAME:
+               ret = __media_playlist_update_playlist_name(playlist_id, _playlist_item->playlist_name);
+               break;
+
+       case MEDIA_PLAYLIST_UPDATE_THUMBNAIL_PATH:
+               ret = __media_playlist_update_thumbnail_path(playlist_id, _playlist_item->thumbnail_path);
+               break;
+
+       case MEDIA_PLAYLIST_UPDATE_PLAY_ORDER:
+               ret = __media_playlist_update_play_order(playlist_id, _playlist_item->playlist_member_id, _playlist_item->play_order);
+               break;
+
+       default:
+               break;
        }
 
-       return ret;
+       if (ret != MEDIA_CONTENT_ERROR_NONE)
+               content_error("Failed some operation[%d]", _playlist_item->function);
 }
 
+int media_playlist_update_to_db(media_playlist_h playlist)
+{
+       int ret = MEDIA_CONTENT_ERROR_NONE;
+       media_playlist_s *_playlist = (media_playlist_s *)playlist;
+
+       content_retip_if_fail(playlist);
+       content_retvm_if(!_playlist->item_list, MEDIA_CONTENT_ERROR_NONE, "operation list length is 0");
 
-int media_playlist_remove_media(media_playlist_h playlist, int playlist_member_id)
+       g_list_foreach(_playlist->item_list, __media_playlist_foreach_request, &(_playlist->playlist_id));
+
+       ret = media_svc_send_query(_content_get_uid());
+
+       __media_playlist_item_release(_playlist);
+
+       return _content_error_capi(ret);
+}
+
+static int __media_playlist_get_media_id_by_path(const char *path, char **media_id)
 {
        int ret = MEDIA_CONTENT_ERROR_NONE;
-       media_playlist_s *_playlist = (media_playlist_s*)playlist;
+       char *query = NULL;
+       sqlite3_stmt *stmt = NULL;
+       content_retip_if_fail(path);
 
-       if((_playlist != NULL) && (playlist_member_id > 0))
-       {
-               media_playlist_item_s *item = (media_playlist_item_s*)calloc(1, sizeof(media_playlist_item_s));
+#ifdef _USE_TVPD_MODE
+       query = sqlite3_mprintf("SELECT media_id FROM '%q' WHERE media_path='%q'", DB_VIEW_MEDIA, path);
+#else
+       query = sqlite3_mprintf("SELECT media_id FROM '%q' WHERE media_path='%q'", DB_TABLE_MEDIA, path);
+#endif
+       ret = _content_get_result(query, &stmt);
+       SQLITE3_SAFE_FREE(query);
+       content_retvm_if(ret != MEDIA_CONTENT_ERROR_NONE, ret, "Failed to get media_id");
 
-               item->playlist_member_id = playlist_member_id;
-               item->function = MEDIA_PLAYLIST_REMOVE;
+       if (sqlite3_step(stmt) == SQLITE_ROW)
+               *media_id = g_strdup((const char *)sqlite3_column_text(stmt, 0));
+
+       SQLITE3_FINALIZE(stmt);
 
-               __media_playlist_item_add(item);
+       return ret;
+}
+
+static void __media_playlist_foreach_item(gpointer item, gpointer user_data)
+{
+       int ret = MEDIA_CONTENT_ERROR_NONE;
+       char *path = (char *)item;
+       media_playlist_h *playlist = (media_playlist_h *)user_data;
+       char *media_id = NULL;
+
+       ret = __media_playlist_get_media_id_by_path(path, &media_id);
+       if (ret != MEDIA_CONTENT_ERROR_NONE) {
+               content_sec_error("Fail to get media_id [%s]", path);
+               return;
        }
-       else
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
+
+       ret = media_playlist_add_media(*playlist, media_id);
+       g_free(media_id);
+       if (ret != MEDIA_CONTENT_ERROR_NONE) {
+               content_sec_error("Fail to add media [%s]", path);
+               return;
        }
+}
+
+int media_playlist_import_from_file(const char *path, const char *playlist_name, media_playlist_h *playlist)
+{
+       int ret = MEDIA_CONTENT_ERROR_NONE;
+       GSList *item_list = NULL;
+       char repl_path[MAX_PATH_LEN] = {0, };
+
+       content_retip_if_fail(STRING_VALID(path));
+       content_retip_if_fail(STRING_VALID(playlist_name));
+
+       ret = _media_content_replace_path(path, repl_path);
+       content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
+
+       ret = media_playlist_insert_to_db(playlist_name, playlist);
+       content_retvm_if(ret != MEDIA_CONTENT_ERROR_NONE, ret, "media_playlist_insert_to_db fail");
+
+       ret = __media_playlist_import_item_from_file(repl_path, &item_list);
+       content_retvm_if(ret != MEDIA_CONTENT_ERROR_NONE, ret, "Fail to get playlist from file");
+
+       g_slist_foreach(item_list, __media_playlist_foreach_item, playlist);
+
+       ret = media_playlist_update_to_db(*playlist);
+       g_slist_free_full(item_list, g_free);
 
        return ret;
 }
 
-int media_playlist_update_to_db(media_playlist_h playlist)
+int media_playlist_export_to_file(media_playlist_h playlist, const char *path)
 {
        int ret = MEDIA_CONTENT_ERROR_NONE;
-       media_playlist_s *_playlist = (media_playlist_s*)playlist;
-       int idx = 0;
-       int length = 0;
-       media_playlist_item_s *_playlist_item = NULL;
-
-       if(_playlist == NULL)
-       {
-               media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
-               return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
+       media_playlist_s *_playlist = (media_playlist_s *)playlist;
+       GList *item_list = NULL;
+       unsigned int idx = 0;
+       char repl_path[MAX_PATH_LEN] = {0, };
+
+       content_retip_if_fail(STRING_VALID(path));
+       content_retip_if_fail(playlist);
+       content_retipm_if_fail(_playlist->playlist_id > 0, "%d", _playlist->playlist_id);
+
+       ret = _media_content_replace_path(path, repl_path);
+       content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
+
+       ret = _media_db_get_playlist_item(_playlist->playlist_id, NULL, __media_playlist_member_cb, &item_list);
+       content_retvm_if(ret != MEDIA_CONTENT_ERROR_NONE, ret, "_media_db_get_playlist_item fail");
+
+       ret = __media_playlist_reset_file(repl_path);
+       if (ret != MEDIA_CONTENT_ERROR_NONE) {
+               g_list_free_full(item_list, g_free);
+               content_error("Fail to init playlist file");
+               return ret;
        }
 
-       length = g_list_length(g_playlist_item_list);
-
-       for (idx = 0; idx < length; idx++) {
-               _playlist_item = (media_playlist_item_s*)g_list_nth_data(g_playlist_item_list, idx);
-               if(_playlist_item != NULL) {
-                       switch(_playlist_item->function) {
-                               case MEDIA_PLAYLIST_ADD:
-                               {
-                                       ret = __media_playlist_insert_item_to_playlist(_playlist->playlist_id, _playlist_item->media_id);
-                               }
-                               break;
-
-                               case MEDIA_PLAYLIST_REMOVE:
-                               {
-                                       ret = __media_playlist_remove_item_from_playlist(_playlist->playlist_id, _playlist_item->playlist_member_id);
-                               }
-                               break;
-
-                               case MEDIA_PLAYLIST_UPDATE_PLAYLIST_NAME:
-                               {
-                                       ret = __media_playlist_update_playlist_name(_playlist->playlist_id, _playlist_item->playlist_name);
-                               }
-                               break;
-
-                               case MEDIA_PLAYLIST_UPDATE_THUMBNAIL_PATH:
-                               {
-                                       ret = __media_playlist_update_thumbnail_path(_playlist->playlist_id, _playlist_item->thumbnail_path);
-                               }
-                               break;
-
-                               case MEDIA_PLAYLIST_UPDATE_PLAY_ORDER:
-                               {
-                                       ret = __media_playlist_update_play_order(_playlist->playlist_id, _playlist_item->playlist_member_id, _playlist_item->play_order);
-                               }
-                               break;
+       for (idx = 0; idx < g_list_length(item_list); idx++) {
+               char *item = g_list_nth_data(item_list, idx);
+               if (STRING_VALID(item)) {
+                       ret = __media_playlist_append_to_file(repl_path, item);
+                       if (ret != MEDIA_CONTENT_ERROR_NONE) {
+                               g_list_free_full(item_list, g_free);
+                               content_error("Fail to export paths into file");
+                               return ret;
                        }
                }
        }
 
-       __media_playlist_item_release();
+       g_list_free_full(item_list, g_free);
+
+       return ret;
+}
+
+int media_playlist_create(media_playlist_h *playlist)
+{
+       content_retip_if_fail(playlist);
+
+       media_playlist_s *_playlist = (media_playlist_s *)calloc(1, sizeof(media_playlist_s));
+       content_retvm_if(_playlist == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
+
+       _playlist->playlist_id = -1;
+       _playlist->name = NULL;
+       _playlist->thumbnail_path = NULL;
+       _playlist->item_list = NULL;
+
+       *playlist = (media_playlist_h)_playlist;
+
+       return MEDIA_CONTENT_ERROR_NONE;
+}
+
+int media_playlist_get_play_order_v2(int playlist_id, int playlist_member_id, int *play_order)
+{
+       int ret = MEDIA_CONTENT_ERROR_NONE;
+       sqlite3_stmt *stmt = NULL;
+       char *query = NULL;
+
+       content_retipm_if_fail(playlist_id >= 0, "%d", playlist_id);
+       content_retipm_if_fail(playlist_member_id >= 0, "%d", playlist_member_id);
+       content_retip_if_fail(play_order);
+
+       query = sqlite3_mprintf(SELECT_PLAY_ORDER_FROM_PLAYLIST_VIEW, playlist_id, playlist_member_id);
+
+       ret = _content_get_result(query, &stmt);
+       SQLITE3_SAFE_FREE(query);
+       content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
+
+       if (sqlite3_step(stmt) == SQLITE_ROW)
+               *play_order = sqlite3_column_int(stmt, 0);
+
+       SQLITE3_FINALIZE(stmt);
 
        return ret;
 }
+
+int media_playlist_insert_to_db_v2(media_playlist_h playlist)
+{
+       int ret = MEDIA_CONTENT_ERROR_NONE;
+       media_playlist_s *_playlist = (media_playlist_s *)playlist;
+       int playlist_id = 0;
+
+       content_retip_if_fail(playlist);
+       content_retipm_if_fail(_playlist->playlist_id == -1, "%d", _playlist->playlist_id);
+
+       ret = __media_playlist_insert_playlist_record(_playlist->name, &playlist_id);
+       if (ret != MEDIA_CONTENT_ERROR_NONE) {
+               __media_playlist_item_release(_playlist);
+               content_error("Insert playlist Fail");
+               return ret;
+       }
+
+       _playlist->playlist_id = playlist_id;
+
+       return media_playlist_update_to_db(playlist);
+}
+
+int media_playlist_update_to_db_v2(int playlist_id, media_playlist_h playlist)
+{
+       media_playlist_s *_playlist = (media_playlist_s *)playlist;
+       content_retip_if_fail(playlist);
+
+       _playlist->playlist_id = playlist_id;
+
+       return media_playlist_update_to_db(playlist);
+}