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>
21 static __thread GList *g_tag_item_list = NULL;
23 static void __media_tag_item_add(media_tag_item_s *item_s);
24 static void __media_tag_item_release(void);
25 static int __media_tag_insert_item_to_tag(int tag_id, const char *media_id);
26 static int __media_tag_remove_item_from_tag(int tag_id, const char *media_id);
27 static int __media_tag_update_tag_name(int tag_id, const char *tag_name);
28 static int __media_tag_get_tag_info_from_db(const char *name, media_tag_h tag);
30 static void __media_tag_item_add(media_tag_item_s *item_s)
32 g_tag_item_list = g_list_append(g_tag_item_list, item_s);
35 static void __media_tag_item_release(void)
39 media_tag_item_s *item = NULL;
41 list_cnt = g_list_length(g_tag_item_list);
43 media_content_debug("list_cnt : [%d]", list_cnt);
45 for(idx = 0; idx < list_cnt; idx++)
47 item = (media_tag_item_s*)g_list_nth_data(g_tag_item_list, idx);
50 SAFE_FREE(item->media_id);
51 SAFE_FREE(item->tag_name);
56 g_list_free(g_tag_item_list);
57 g_tag_item_list = NULL;
61 static int __media_tag_insert_item_to_tag(int tag_id, const char *media_id)
63 int ret = MEDIA_CONTENT_ERROR_NONE;
64 char *query_str = NULL;
66 query_str = sqlite3_mprintf("INSERT INTO %q (tag_id, media_uuid) values (%d, '%q')",
67 DB_TABLE_TAG_MAP, tag_id, media_id);
68 ret = _content_query_sql(query_str);
69 sqlite3_free(query_str);
74 static int __media_tag_remove_item_from_tag(int tag_id, const char *media_id)
76 int ret = MEDIA_CONTENT_ERROR_NONE;
77 char *query_str = NULL;
79 query_str = sqlite3_mprintf(REMOVE_TAG_ITEM_FROM_TAG_MAP, tag_id, media_id);
81 ret = _content_query_sql(query_str);
82 sqlite3_free(query_str);
87 static int __media_tag_update_tag_name(int tag_id, const char *tag_name)
89 int ret = MEDIA_CONTENT_ERROR_NONE;
90 char *query_str = NULL;
92 query_str = sqlite3_mprintf(UPDATE_TAG_NAME_FROM_TAG, tag_name, tag_id);
94 ret = _content_query_sql(query_str);
95 sqlite3_free(query_str);
100 static int __media_tag_get_tag_info_from_db(const char *name, media_tag_h tag)
102 int ret = MEDIA_CONTENT_ERROR_NONE;
103 sqlite3_stmt *stmt = NULL;
104 char *select_query = NULL;
105 media_tag_s *_tag = (media_tag_s*)tag;
109 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
110 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
113 select_query = sqlite3_mprintf(SELECT_TAG_BY_NAME, name);
115 ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
116 sqlite3_free(select_query);
117 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
119 while(sqlite3_step(stmt) == SQLITE_ROW)
121 _tag->tag_id = (int)sqlite3_column_int(stmt,0);
123 if(STRING_VALID((const char *)sqlite3_column_text(stmt, 1)))
125 _tag->name = strdup((const char *)sqlite3_column_text(stmt, 1));
129 SQLITE3_FINALIZE(stmt);
134 int media_tag_insert_to_db(const char *tag_name, media_tag_h *tag)
136 int ret = MEDIA_CONTENT_ERROR_NONE;
137 char *query_str = NULL;
139 if(!STRING_VALID(tag_name))
141 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
142 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
145 query_str = sqlite3_mprintf(INSERT_TAG_TO_TAG, tag_name);
146 ret = _content_query_sql(query_str);
147 sqlite3_free(query_str);
149 if(ret == MEDIA_CONTENT_ERROR_NONE)
151 media_tag_s *_tag = (media_tag_s*)calloc(1, sizeof(media_tag_s));
154 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
155 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
158 ret = __media_tag_get_tag_info_from_db(tag_name, (media_tag_h)_tag);
159 *tag = (media_tag_h)_tag;
165 int media_tag_delete_from_db(int tag_id)
167 int ret = MEDIA_CONTENT_ERROR_NONE;
168 char *query_str = NULL;
172 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
173 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
176 query_str = sqlite3_mprintf(DELETE_TAG_FROM_TAG, tag_id);
178 ret = _content_query_sql(query_str);
180 sqlite3_free(query_str);
185 int media_tag_get_tag_count_from_db(filter_h filter, int *tag_count)
187 int ret = MEDIA_CONTENT_ERROR_NONE;
189 if(tag_count != NULL)
191 ret = _media_db_get_group_count(filter, MEDIA_GROUP_TAG, tag_count);
195 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
196 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
202 int media_tag_foreach_tag_from_db (filter_h filter, media_tag_cb callback, void *user_data)
204 int ret = MEDIA_CONTENT_ERROR_NONE;
208 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
209 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
212 ret = _media_db_get_tag(NULL, filter, callback, user_data);
217 int media_tag_get_media_count_from_db(int tag_id, filter_h filter, int *media_count)
219 int ret = MEDIA_CONTENT_ERROR_NONE;
221 if((tag_id > 0) && (media_count != NULL))
223 ret = _media_db_get_group_item_count_by_id(tag_id, filter, MEDIA_GROUP_TAG, media_count);
227 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
228 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
234 int media_tag_foreach_media_from_db(int tag_id, filter_h filter, media_info_cb callback, void *user_data)
236 int ret = MEDIA_CONTENT_ERROR_NONE;
240 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
241 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
244 ret = _media_db_get_group_item_by_id(tag_id, filter, callback, user_data, MEDIA_GROUP_TAG);
249 int media_tag_destroy(media_tag_h tag)
251 int ret = MEDIA_CONTENT_ERROR_NONE;
252 media_tag_s *_tag = (media_tag_s*)tag;
255 SAFE_FREE(_tag->name);
257 ret = MEDIA_CONTENT_ERROR_NONE;
261 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
262 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
267 int media_tag_clone(media_tag_h *dst, media_tag_h src)
269 int ret = MEDIA_CONTENT_ERROR_NONE;
270 media_tag_s *_src = (media_tag_s*)src;
271 media_tag_s *_dst = NULL;
275 _dst = (media_tag_s*)calloc(1, sizeof(media_tag_s));
279 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
280 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
283 _dst->tag_id = _src->tag_id;
285 if(STRING_VALID(_src->name))
287 _dst->name = strdup(_src->name);
288 if(_dst->name == NULL)
291 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
292 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
295 *dst = (media_tag_h)_dst;
296 ret = MEDIA_CONTENT_ERROR_NONE;
300 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
301 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
307 int media_tag_get_tag_id(media_tag_h tag, int *tag_id)
309 int ret = MEDIA_CONTENT_ERROR_NONE;
310 media_tag_s *_tag = (media_tag_s*)tag;
312 if((_tag != NULL) && (tag_id != NULL))
314 *tag_id = _tag->tag_id;
315 ret = MEDIA_CONTENT_ERROR_NONE;
319 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
320 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
326 int media_tag_get_name(media_tag_h tag, char **name)
328 int ret = MEDIA_CONTENT_ERROR_NONE;
329 media_tag_s *_tag = (media_tag_s*)tag;
332 if(STRING_VALID(_tag->name))
334 *name = strdup(_tag->name);
337 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
338 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
345 ret = MEDIA_CONTENT_ERROR_NONE;
350 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
351 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
357 int media_tag_get_tag_from_db(int tag_id, media_tag_h *tag)
359 int ret = MEDIA_CONTENT_ERROR_NONE;
360 sqlite3_stmt *stmt = NULL;
361 char select_query[DEFAULT_QUERY_SIZE];
365 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
366 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
369 memset(select_query, 0x00, sizeof(select_query));
371 snprintf(select_query, sizeof(select_query), SELECT_TAG_FROM_TAG, tag_id);
373 ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
374 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
376 while(sqlite3_step(stmt) == SQLITE_ROW)
378 media_tag_s *_tag = (media_tag_s*)calloc(1, sizeof(media_tag_s));
382 SQLITE3_FINALIZE(stmt);
383 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
384 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
387 _tag->tag_id = (int)sqlite3_column_int(stmt, 0);
389 if(STRING_VALID((const char *)sqlite3_column_text(stmt, 1)))
391 _tag->name = strdup((const char *)sqlite3_column_text(stmt, 1));
394 *tag = (media_tag_h)_tag;
397 SQLITE3_FINALIZE(stmt);
402 int media_tag_add_media(media_tag_h tag, const char *media_id)
404 int ret = MEDIA_CONTENT_ERROR_NONE;
405 media_tag_s *_tag = (media_tag_s*)tag;
407 if((_tag != NULL) && STRING_VALID(media_id))
409 media_tag_item_s *_item = (media_tag_item_s*)calloc(1, sizeof(media_tag_item_s));
412 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
413 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
416 _item->media_id = strdup(media_id);
417 _item->function = MEDIA_TAG_ADD;
419 if(_item->media_id == NULL)
422 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
423 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
426 __media_tag_item_add(_item);
430 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
431 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
437 int media_tag_remove_media(media_tag_h tag, const char *media_id)
439 int ret = MEDIA_CONTENT_ERROR_NONE;
440 media_tag_s *_tag = (media_tag_s*)tag;
442 if(_tag != NULL && STRING_VALID(media_id))
444 media_tag_item_s *_item = (media_tag_item_s*)calloc(1, sizeof(media_tag_item_s));
447 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
448 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
451 _item->media_id = strdup(media_id);
452 _item->function = MEDIA_TAG_REMOVE;
454 if(_item->media_id == NULL)
457 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
458 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
461 __media_tag_item_add(_item);
465 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
466 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
472 int media_tag_set_name(media_tag_h tag, char *tag_name)
474 int ret = MEDIA_CONTENT_ERROR_NONE;
475 media_tag_s *_tag = (media_tag_s*)tag;
477 if(_tag != NULL && STRING_VALID(tag_name))
479 SAFE_FREE(_tag->name);
481 media_tag_item_s *_item = (media_tag_item_s*)calloc(1, sizeof(media_tag_item_s));
484 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
485 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
488 _item->tag_name = strdup(tag_name);
489 _item->function = MEDIA_TAG_UPDATE_TAG_NAME;
491 if(_item->tag_name == NULL)
494 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
495 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
498 _tag->name = strdup(tag_name);
499 if(_tag->name == NULL)
501 SAFE_FREE(_item->tag_name);
503 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
504 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
507 __media_tag_item_add(_item);
511 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
512 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
518 int media_tag_update_to_db(media_tag_h tag)
520 int ret = MEDIA_CONTENT_ERROR_NONE;
521 media_tag_s *_tag = (media_tag_s*)tag;
524 media_tag_item_s *_tag_item = NULL;
528 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
529 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
532 length = g_list_length(g_tag_item_list);
534 for (idx = 0; idx < length; idx++) {
535 _tag_item = (media_tag_item_s*)g_list_nth_data(g_tag_item_list, idx);
536 if(_tag_item != NULL) {
537 switch(_tag_item->function) {
540 ret = __media_tag_insert_item_to_tag(_tag->tag_id, _tag_item->media_id);
544 case MEDIA_TAG_REMOVE:
546 ret = __media_tag_remove_item_from_tag(_tag->tag_id, _tag_item->media_id);
550 case MEDIA_TAG_UPDATE_TAG_NAME:
552 ret = __media_tag_update_tag_name(_tag->tag_id, _tag_item->tag_name);
559 __media_tag_item_release();