2 * Copyright (c) 2011 Samsung Electronics Co., Ltd All Rights Reserved
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
8 * http://www.apache.org/licenses/LICENSE-2.0
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
18 #include <media_info_private.h>
20 static void __media_tag_item_add(media_tag_s *tag_s, media_tag_item_s *item_s);
21 static void __media_tag_item_release(media_tag_s *tag_s);
22 static int __media_tag_insert_item_to_tag(int tag_id, const char *media_id);
23 static int __media_tag_remove_item_from_tag(int tag_id, const char *media_id);
24 static int __media_tag_update_tag_name(int tag_id, const char *tag_name);
25 static int __media_tag_get_tag_info_from_db(const char *name, media_tag_h tag);
27 static void __media_tag_item_add(media_tag_s *tag_s, media_tag_item_s *item_s)
29 tag_s->item_list = g_list_append(tag_s->item_list, item_s);
32 static void __media_tag_item_release(media_tag_s *tag_s)
36 media_tag_item_s *item = NULL;
38 list_cnt = g_list_length(tag_s->item_list);
40 media_content_debug("list_cnt : [%d]", list_cnt);
42 for(idx = 0; idx < list_cnt; idx++)
44 item = (media_tag_item_s*)g_list_nth_data(tag_s->item_list, idx);
47 SAFE_FREE(item->media_id);
48 SAFE_FREE(item->tag_name);
53 g_list_free(tag_s->item_list);
54 tag_s->item_list = NULL;
58 static int __media_tag_insert_item_to_tag(int tag_id, const char *media_id)
60 int ret = MEDIA_CONTENT_ERROR_NONE;
61 char *query_str = NULL;
63 query_str = sqlite3_mprintf("INSERT INTO %q (tag_id, media_uuid) values (%d, '%q')",
64 DB_TABLE_TAG_MAP, tag_id, media_id);
65 ret = _content_query_sql(query_str);
66 SQLITE3_SAFE_FREE(query_str);
71 static int __media_tag_remove_item_from_tag(int tag_id, const char *media_id)
73 int ret = MEDIA_CONTENT_ERROR_NONE;
74 char *query_str = NULL;
76 query_str = sqlite3_mprintf(REMOVE_TAG_ITEM_FROM_TAG_MAP, tag_id, media_id);
78 ret = _content_query_sql(query_str);
79 SQLITE3_SAFE_FREE(query_str);
84 static int __media_tag_update_tag_name(int tag_id, const char *tag_name)
86 int ret = MEDIA_CONTENT_ERROR_NONE;
87 char *query_str = NULL;
89 query_str = sqlite3_mprintf(UPDATE_TAG_NAME_FROM_TAG, tag_name, tag_id);
91 ret = _content_query_sql(query_str);
92 SQLITE3_SAFE_FREE(query_str);
97 static int __media_tag_get_tag_info_from_db(const char *name, media_tag_h tag)
99 int ret = MEDIA_CONTENT_ERROR_NONE;
100 sqlite3_stmt *stmt = NULL;
101 char *select_query = NULL;
103 char *tag_name = NULL;
104 media_tag_s *_tag = (media_tag_s*)tag;
106 media_content_retvm_if(_tag == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid tag");
108 select_query = sqlite3_mprintf(SELECT_TAG_BY_NAME, name);
110 ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
111 SQLITE3_SAFE_FREE(select_query);
112 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
114 while(sqlite3_step(stmt) == SQLITE_ROW)
116 id = (int)sqlite3_column_int(stmt,0);
118 if(STRING_VALID((const char *)sqlite3_column_text(stmt, 1)))
123 tag_name = strdup((const char *)sqlite3_column_text(stmt, 1));
128 _tag->name = tag_name;
130 SQLITE3_FINALIZE(stmt);
135 int media_tag_insert_to_db(const char *tag_name, media_tag_h *tag)
137 int ret = MEDIA_CONTENT_ERROR_NONE;
138 char *query_str = NULL;
140 if(!STRING_VALID(tag_name))
142 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
143 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
146 query_str = sqlite3_mprintf(INSERT_TAG_TO_TAG, tag_name);
147 ret = _content_query_sql(query_str);
148 SQLITE3_SAFE_FREE(query_str);
150 if(ret == MEDIA_CONTENT_ERROR_NONE)
152 media_tag_s *_tag = (media_tag_s*)calloc(1, sizeof(media_tag_s));
153 media_content_retvm_if(_tag == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
155 ret = __media_tag_get_tag_info_from_db(tag_name, (media_tag_h)_tag);
156 *tag = (media_tag_h)_tag;
162 int media_tag_delete_from_db(int tag_id)
164 int ret = MEDIA_CONTENT_ERROR_NONE;
165 char *query_str = NULL;
169 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
170 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
173 query_str = sqlite3_mprintf(DELETE_TAG_FROM_TAG, tag_id);
175 ret = _content_query_sql(query_str);
177 SQLITE3_SAFE_FREE(query_str);
182 int media_tag_get_tag_count_from_db(filter_h filter, int *tag_count)
184 int ret = MEDIA_CONTENT_ERROR_NONE;
186 if(tag_count != NULL)
188 ret = _media_db_get_group_count(filter, MEDIA_GROUP_TAG, tag_count);
192 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
193 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
199 int media_tag_foreach_tag_from_db (filter_h filter, media_tag_cb callback, void *user_data)
201 int ret = MEDIA_CONTENT_ERROR_NONE;
205 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
206 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
209 ret = _media_db_get_tag(NULL, filter, callback, user_data);
214 int media_tag_get_media_count_from_db(int tag_id, filter_h filter, int *media_count)
216 int ret = MEDIA_CONTENT_ERROR_NONE;
218 if((tag_id > 0) && (media_count != NULL))
220 ret = _media_db_get_group_item_count_by_id(tag_id, filter, MEDIA_GROUP_TAG, media_count);
224 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
225 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
231 int media_tag_foreach_media_from_db(int tag_id, filter_h filter, media_info_cb callback, void *user_data)
233 int ret = MEDIA_CONTENT_ERROR_NONE;
237 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
238 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
241 ret = _media_db_get_group_item_by_id(tag_id, filter, callback, user_data, MEDIA_GROUP_TAG);
246 int media_tag_destroy(media_tag_h tag)
248 int ret = MEDIA_CONTENT_ERROR_NONE;
249 media_tag_s *_tag = (media_tag_s*)tag;
252 SAFE_FREE(_tag->name);
254 ret = MEDIA_CONTENT_ERROR_NONE;
258 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
259 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
264 int media_tag_clone(media_tag_h *dst, media_tag_h src)
266 int ret = MEDIA_CONTENT_ERROR_NONE;
267 media_tag_s *_src = (media_tag_s*)src;
268 media_tag_s *_dst = NULL;
272 _dst = (media_tag_s*)calloc(1, sizeof(media_tag_s));
273 media_content_retvm_if(_dst == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
275 _dst->tag_id = _src->tag_id;
277 if(STRING_VALID(_src->name))
279 _dst->name = strdup(_src->name);
280 if(_dst->name == NULL)
283 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
284 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
287 *dst = (media_tag_h)_dst;
288 ret = MEDIA_CONTENT_ERROR_NONE;
292 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
293 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
299 int media_tag_get_tag_id(media_tag_h tag, int *tag_id)
301 int ret = MEDIA_CONTENT_ERROR_NONE;
302 media_tag_s *_tag = (media_tag_s*)tag;
304 if((_tag != NULL) && (tag_id != NULL))
306 *tag_id = _tag->tag_id;
307 ret = MEDIA_CONTENT_ERROR_NONE;
311 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
312 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
318 int media_tag_get_name(media_tag_h tag, char **name)
320 int ret = MEDIA_CONTENT_ERROR_NONE;
321 media_tag_s *_tag = (media_tag_s*)tag;
324 if(STRING_VALID(_tag->name))
326 *name = strdup(_tag->name);
327 media_content_retvm_if(*name == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
333 ret = MEDIA_CONTENT_ERROR_NONE;
338 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
339 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
345 int media_tag_get_tag_from_db(int tag_id, media_tag_h *tag)
347 int ret = MEDIA_CONTENT_ERROR_NONE;
348 sqlite3_stmt *stmt = NULL;
349 char select_query[DEFAULT_QUERY_SIZE];
353 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
354 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
357 memset(select_query, 0x00, sizeof(select_query));
359 snprintf(select_query, sizeof(select_query), SELECT_TAG_FROM_TAG, tag_id);
361 ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
362 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
364 media_tag_s *_tag = NULL;
366 while(sqlite3_step(stmt) == SQLITE_ROW)
369 media_tag_destroy((media_tag_h)_tag);
371 _tag = (media_tag_s*)calloc(1, sizeof(media_tag_s));
374 SQLITE3_FINALIZE(stmt);
375 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
376 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
379 _tag->tag_id = (int)sqlite3_column_int(stmt, 0);
381 if(STRING_VALID((const char *)sqlite3_column_text(stmt, 1)))
383 _tag->name = strdup((const char *)sqlite3_column_text(stmt, 1));
386 *tag = (media_tag_h)_tag;
389 SQLITE3_FINALIZE(stmt);
394 int media_tag_add_media(media_tag_h tag, const char *media_id)
396 int ret = MEDIA_CONTENT_ERROR_NONE;
397 media_tag_s *_tag = (media_tag_s*)tag;
399 if((_tag != NULL) && STRING_VALID(media_id))
401 media_tag_item_s *_item = (media_tag_item_s*)calloc(1, sizeof(media_tag_item_s));
402 media_content_retvm_if(_item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
404 _item->media_id = strdup(media_id);
405 _item->function = MEDIA_TAG_ADD;
407 if(_item->media_id == NULL)
410 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
411 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
414 __media_tag_item_add(_tag, _item);
418 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
419 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
425 int media_tag_remove_media(media_tag_h tag, const char *media_id)
427 int ret = MEDIA_CONTENT_ERROR_NONE;
428 media_tag_s *_tag = (media_tag_s*)tag;
430 if(_tag != NULL && STRING_VALID(media_id))
432 media_tag_item_s *_item = (media_tag_item_s*)calloc(1, sizeof(media_tag_item_s));
433 media_content_retvm_if(_item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
435 _item->media_id = strdup(media_id);
436 _item->function = MEDIA_TAG_REMOVE;
438 if(_item->media_id == NULL)
441 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
442 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
445 __media_tag_item_add(_tag, _item);
449 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
450 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
456 int media_tag_set_name(media_tag_h tag, char *tag_name)
458 int ret = MEDIA_CONTENT_ERROR_NONE;
459 media_tag_s *_tag = (media_tag_s*)tag;
461 if(_tag != NULL && STRING_VALID(tag_name))
463 SAFE_FREE(_tag->name);
465 media_tag_item_s *_item = (media_tag_item_s*)calloc(1, sizeof(media_tag_item_s));
466 media_content_retvm_if(_item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
468 _item->tag_name = strdup(tag_name);
469 _item->function = MEDIA_TAG_UPDATE_TAG_NAME;
471 if(_item->tag_name == NULL)
474 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
475 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
478 _tag->name = strdup(tag_name);
479 if(_tag->name == NULL)
481 SAFE_FREE(_item->tag_name);
483 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
484 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
487 __media_tag_item_add(_tag, _item);
491 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
492 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
498 int media_tag_update_to_db(media_tag_h tag)
500 int ret = MEDIA_CONTENT_ERROR_NONE;
501 media_tag_s *_tag = (media_tag_s*)tag;
504 media_tag_item_s *_tag_item = NULL;
508 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
509 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
512 if(_tag->item_list != NULL) {
513 length = g_list_length(_tag->item_list);
515 media_content_debug("operation list length is 0");
516 return MEDIA_CONTENT_ERROR_NONE;
519 for (idx = 0; idx < length; idx++) {
520 _tag_item = (media_tag_item_s*)g_list_nth_data(_tag->item_list, idx);
521 if(_tag_item != NULL) {
522 switch(_tag_item->function) {
525 ret = __media_tag_insert_item_to_tag(_tag->tag_id, _tag_item->media_id);
529 case MEDIA_TAG_REMOVE:
531 ret = __media_tag_remove_item_from_tag(_tag->tag_id, _tag_item->media_id);
535 case MEDIA_TAG_UPDATE_TAG_NAME:
537 ret = __media_tag_update_tag_name(_tag->tag_id, _tag_item->tag_name);
547 __media_tag_item_release(_tag);