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 content_debug("list_cnt : [%d]", list_cnt);
42 for (idx = 0; idx < list_cnt; idx++) {
43 item = (media_tag_item_s*)g_list_nth_data(tag_s->item_list, idx);
45 SAFE_FREE(item->media_id);
46 SAFE_FREE(item->tag_name);
51 g_list_free(tag_s->item_list);
52 tag_s->item_list = NULL;
56 static int __media_tag_insert_item_to_tag(int tag_id, const char *media_id)
58 int ret = MEDIA_CONTENT_ERROR_NONE;
59 char *query_str = NULL;
61 query_str = sqlite3_mprintf("INSERT OR IGNORE INTO %q (tag_id, media_id) values (%d, '%q');", DB_TABLE_TAG_MAP, tag_id, media_id);
62 ret = media_svc_append_query(query_str, _content_get_uid());
64 return _content_error_capi(ret);
67 static int __media_tag_remove_item_from_tag(int tag_id, const char *media_id)
69 int ret = MEDIA_CONTENT_ERROR_NONE;
70 char *query_str = NULL;
72 query_str = sqlite3_mprintf(REMOVE_TAG_ITEM_FROM_TAG_MAP, tag_id, media_id);
73 ret = media_svc_append_query(query_str, _content_get_uid());
75 return _content_error_capi(ret);
78 static int __media_tag_update_tag_name(int tag_id, const char *tag_name)
80 int ret = MEDIA_CONTENT_ERROR_NONE;
81 char *query_str = NULL;
83 query_str = sqlite3_mprintf(UPDATE_TAG_NAME_FROM_TAG, tag_name, tag_id);
84 ret = media_svc_append_query(query_str, _content_get_uid());
86 return _content_error_capi(ret);
89 static int __media_tag_get_tag_info_from_db(const char *name, media_tag_h tag)
91 int ret = MEDIA_CONTENT_ERROR_NONE;
92 sqlite3_stmt *stmt = NULL;
93 char *select_query = NULL;
94 media_tag_s *_tag = (media_tag_s*)tag;
96 content_retvm_if(_tag == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid tag");
98 select_query = sqlite3_mprintf(SELECT_TAG_BY_NAME, name);
100 ret = _content_get_result(select_query, &stmt);
101 SQLITE3_SAFE_FREE(select_query);
102 content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
104 if (sqlite3_step(stmt) == SQLITE_ROW) {
105 _tag->tag_id = (int)sqlite3_column_int(stmt, 0);
106 _tag->name = g_strdup(name);
108 content_error("Nonexistent tag name[%s]", name);
109 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
112 SQLITE3_FINALIZE(stmt);
117 int media_tag_insert_to_db(const char *tag_name, media_tag_h *tag)
119 int ret = MEDIA_CONTENT_ERROR_NONE;
120 char *query_str = NULL;
122 if (!STRING_VALID(tag_name)) {
123 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
124 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
127 query_str = sqlite3_mprintf(INSERT_TAG_TO_TAG, tag_name);
128 ret = _content_query_sql(query_str);
129 SQLITE3_SAFE_FREE(query_str);
131 if (ret == MEDIA_CONTENT_ERROR_NONE) {
132 media_tag_s *_tag = (media_tag_s*)calloc(1, sizeof(media_tag_s));
133 content_retvm_if(_tag == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
135 ret = __media_tag_get_tag_info_from_db(tag_name, (media_tag_h)_tag);
136 *tag = (media_tag_h)_tag;
142 int media_tag_delete_from_db(int tag_id)
144 int ret = MEDIA_CONTENT_ERROR_NONE;
145 char *query_str = NULL;
148 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
149 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
152 query_str = sqlite3_mprintf(DELETE_TAG_FROM_TAG, tag_id);
154 ret = _content_query_sql(query_str);
156 SQLITE3_SAFE_FREE(query_str);
161 int media_tag_get_tag_count_from_db(filter_h filter, int *tag_count)
163 int ret = MEDIA_CONTENT_ERROR_NONE;
165 if (tag_count != NULL) {
166 ret = _media_db_get_group_count(filter, MEDIA_GROUP_TAG, tag_count);
168 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
169 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
175 int media_tag_foreach_tag_from_db(filter_h filter, media_tag_cb callback, void *user_data)
177 int ret = MEDIA_CONTENT_ERROR_NONE;
179 if (callback == NULL) {
180 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
181 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
184 ret = _media_db_get_tag(NULL, filter, callback, user_data);
189 int media_tag_get_media_count_from_db(int tag_id, filter_h filter, int *media_count)
191 int ret = MEDIA_CONTENT_ERROR_NONE;
193 if ((tag_id > 0) && (media_count != NULL)) {
194 ret = _media_db_get_group_item_count_by_id(tag_id, filter, MEDIA_GROUP_TAG, media_count);
196 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
197 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
203 int media_tag_foreach_media_from_db(int tag_id, filter_h filter, media_info_cb callback, void *user_data)
205 int ret = MEDIA_CONTENT_ERROR_NONE;
207 if (callback == NULL) {
208 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
209 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
212 ret = _media_db_get_group_item_by_id(tag_id, filter, callback, user_data, MEDIA_GROUP_TAG);
217 int media_tag_destroy(media_tag_h tag)
219 int ret = MEDIA_CONTENT_ERROR_NONE;
220 media_tag_s *_tag = (media_tag_s*)tag;
222 SAFE_FREE(_tag->name);
224 ret = MEDIA_CONTENT_ERROR_NONE;
226 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
227 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
233 int media_tag_clone(media_tag_h *dst, media_tag_h src)
235 int ret = MEDIA_CONTENT_ERROR_NONE;
236 media_tag_s *_src = (media_tag_s*)src;
237 media_tag_s *_dst = NULL;
239 if ((_src != NULL)) {
240 _dst = (media_tag_s*)calloc(1, sizeof(media_tag_s));
241 content_retvm_if(_dst == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
243 _dst->tag_id = _src->tag_id;
245 if (STRING_VALID(_src->name)) {
246 _dst->name = strdup(_src->name);
247 if (_dst->name == NULL) {
249 content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
250 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
253 *dst = (media_tag_h)_dst;
254 ret = MEDIA_CONTENT_ERROR_NONE;
256 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
257 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
263 int media_tag_get_tag_id(media_tag_h tag, int *tag_id)
265 int ret = MEDIA_CONTENT_ERROR_NONE;
266 media_tag_s *_tag = (media_tag_s*)tag;
268 if ((_tag != NULL) && (tag_id != NULL)) {
269 *tag_id = _tag->tag_id;
270 ret = MEDIA_CONTENT_ERROR_NONE;
272 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
273 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
279 int media_tag_get_name(media_tag_h tag, char **name)
281 int ret = MEDIA_CONTENT_ERROR_NONE;
282 media_tag_s *_tag = (media_tag_s*)tag;
284 if (STRING_VALID(_tag->name)) {
285 *name = strdup(_tag->name);
286 content_retvm_if(*name == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
290 ret = MEDIA_CONTENT_ERROR_NONE;
293 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
294 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
300 int media_tag_get_tag_from_db(int tag_id, media_tag_h *tag)
302 int ret = MEDIA_CONTENT_ERROR_NONE;
303 sqlite3_stmt *stmt = NULL;
304 char select_query[DEFAULT_QUERY_SIZE] = {0, };
307 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
308 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
311 memset(select_query, 0x00, sizeof(select_query));
313 snprintf(select_query, sizeof(select_query), SELECT_TAG_FROM_TAG, tag_id);
315 ret = _content_get_result(select_query, &stmt);
316 content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
318 media_tag_s *_tag = NULL;
320 if (sqlite3_step(stmt) == SQLITE_ROW) {
321 _tag = (media_tag_s*)calloc(1, sizeof(media_tag_s));
323 SQLITE3_FINALIZE(stmt);
324 content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
325 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
328 _tag->tag_id = tag_id;
329 _tag->name = g_strdup((const char *)sqlite3_column_text(stmt, 0));
331 *tag = (media_tag_h)_tag;
333 content_error("Nonexistent tag id[%d]", tag_id);
334 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
337 SQLITE3_FINALIZE(stmt);
342 int media_tag_add_media(media_tag_h tag, const char *media_id)
344 int ret = MEDIA_CONTENT_ERROR_NONE;
345 media_tag_s *_tag = (media_tag_s*)tag;
347 if ((_tag != NULL) && STRING_VALID(media_id)) {
348 media_tag_item_s *_item = (media_tag_item_s*)calloc(1, sizeof(media_tag_item_s));
349 content_retvm_if(_item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
351 _item->media_id = strdup(media_id);
352 _item->function = MEDIA_TAG_ADD;
354 if (_item->media_id == NULL) {
356 content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
357 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
360 __media_tag_item_add(_tag, _item);
362 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
363 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
369 int media_tag_remove_media(media_tag_h tag, const char *media_id)
371 int ret = MEDIA_CONTENT_ERROR_NONE;
372 media_tag_s *_tag = (media_tag_s*)tag;
374 if (_tag != NULL && STRING_VALID(media_id)) {
375 media_tag_item_s *_item = (media_tag_item_s*)calloc(1, sizeof(media_tag_item_s));
376 content_retvm_if(_item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
378 _item->media_id = strdup(media_id);
379 _item->function = MEDIA_TAG_REMOVE;
381 if (_item->media_id == NULL) {
383 content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
384 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
387 __media_tag_item_add(_tag, _item);
389 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
390 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
396 int media_tag_set_name(media_tag_h tag, const char *tag_name)
398 int ret = MEDIA_CONTENT_ERROR_NONE;
399 media_tag_s *_tag = (media_tag_s*)tag;
401 if (_tag != NULL && STRING_VALID(tag_name)) {
402 SAFE_FREE(_tag->name);
404 media_tag_item_s *_item = (media_tag_item_s*)calloc(1, sizeof(media_tag_item_s));
405 content_retvm_if(_item == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
407 _item->tag_name = strdup(tag_name);
408 _item->function = MEDIA_TAG_UPDATE_TAG_NAME;
410 if (_item->tag_name == NULL) {
412 content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
413 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
416 _tag->name = strdup(tag_name);
417 if (_tag->name == NULL) {
418 SAFE_FREE(_item->tag_name);
420 content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
421 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
424 __media_tag_item_add(_tag, _item);
426 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
427 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
433 int media_tag_update_to_db(media_tag_h tag)
435 int ret = MEDIA_CONTENT_ERROR_NONE;
436 media_tag_s *_tag = (media_tag_s*)tag;
439 media_tag_item_s *_tag_item = NULL;
442 content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
443 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
446 if (_tag->item_list != NULL) {
447 length = g_list_length(_tag->item_list);
449 content_debug("operation list length is 0");
450 return MEDIA_CONTENT_ERROR_NONE;
453 for (idx = 0; idx < length; idx++) {
454 _tag_item = (media_tag_item_s*)g_list_nth_data(_tag->item_list, idx);
455 if (_tag_item != NULL) {
456 switch (_tag_item->function) {
459 ret = __media_tag_insert_item_to_tag(_tag->tag_id, _tag_item->media_id);
463 case MEDIA_TAG_REMOVE:
465 ret = __media_tag_remove_item_from_tag(_tag->tag_id, _tag_item->media_id);
469 case MEDIA_TAG_UPDATE_TAG_NAME:
471 ret = __media_tag_update_tag_name(_tag->tag_id, _tag_item->tag_name);
479 if (ret != MEDIA_CONTENT_ERROR_NONE)
480 content_error("Failed some operation[%d]", _tag_item->function);
484 ret = media_svc_send_query(_content_get_uid());
486 __media_tag_item_release(_tag);
488 return _content_error_capi(ret);
491 int media_tag_create(media_tag_h *tag)
493 int ret = MEDIA_CONTENT_ERROR_NONE;
495 content_retvm_if(tag == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid tag");
497 media_tag_s *_tag = (media_tag_s*)calloc(1, sizeof(media_tag_s));
498 content_retvm_if(_tag == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
502 _tag->item_list = NULL;
504 *tag = (media_tag_h)_tag;
509 int media_tag_insert_to_db_v2(media_tag_h tag)
511 int ret = MEDIA_CONTENT_ERROR_NONE;
512 media_tag_s *_tag = (media_tag_s*)tag;
516 content_retvm_if(_tag == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid tag");
517 content_retvm_if(!STRING_VALID(_tag->name), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid tag name");
518 content_retvm_if(_tag->tag_id != -1, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid tag insert");
520 ret = media_tag_insert_to_db(_tag->name, &tag_1);
521 if (ret != MEDIA_CONTENT_ERROR_NONE) {
522 content_error("fail media_tag_insert_to_db");
526 ret = media_tag_get_tag_id(tag_1, &tag_id);
527 if (ret != MEDIA_CONTENT_ERROR_NONE) {
528 content_error("fail media_tag_get_tag_id");
532 _tag->tag_id = tag_id;
534 ret = media_tag_update_to_db(tag);
537 __media_tag_item_release(_tag);
538 media_tag_destroy(tag_1);
543 int media_tag_update_to_db_v2(int tag_id, media_tag_h tag)
545 media_tag_s *_tag = (media_tag_s*)tag;
547 content_retvm_if(_tag == NULL, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid tag");
548 content_retvm_if(tag_id == -1, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid tag update");
550 _tag->tag_id = tag_id;
552 return media_tag_update_to_db(tag);