Code migration
[platform/core/api/media-content.git] / src / media_folder.c
1  /*
2  * Copyright (c) 2011 Samsung Electronics Co., Ltd All Rights Reserved
3  *
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
7  *
8  * http://www.apache.org/licenses/LICENSE-2.0
9  *
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.
15  */
16
17
18 #include <media_info_private.h>
19 #include <media_util_private.h>
20
21 static char *g_src_path = NULL;
22
23 int media_folder_get_folder_count_from_db(filter_h filter, int *folder_count)
24 {
25         int ret = MEDIA_CONTENT_ERROR_NONE;
26
27         if (!folder_count) {
28                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
29                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
30         }
31
32         ret = _media_db_get_group_count(filter, MEDIA_GROUP_FOLDER, folder_count);
33
34         return ret;
35 }
36
37 int media_folder_foreach_folder_from_db(filter_h filter, media_folder_cb callback, void *user_data)
38 {
39         int ret = MEDIA_CONTENT_ERROR_NONE;
40
41         if (callback == NULL) {
42                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
43                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
44         }
45
46         ret = _media_db_get_folder(filter, callback, user_data);
47
48         return ret;
49 }
50
51 int media_folder_get_media_count_from_db(const char *folder_id, filter_h filter, int *media_count)
52 {
53         int ret = MEDIA_CONTENT_ERROR_NONE;
54
55         if (STRING_VALID(folder_id) && media_count) {
56                 ret = _media_db_get_group_item_count(folder_id, filter, MEDIA_GROUP_FOLDER, media_count);
57         } else {
58                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
59                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
60         }
61
62         return ret;
63 }
64
65 int media_folder_foreach_media_from_db(const char *folder_id, filter_h filter, media_info_cb callback, void *user_data)
66 {
67         int ret = MEDIA_CONTENT_ERROR_NONE;
68
69         if ((callback != NULL) && STRING_VALID(folder_id)) {
70                 ret = _media_db_get_group_item(folder_id, filter, callback, user_data, MEDIA_GROUP_FOLDER);
71         } else {
72                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
73                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
74         }
75
76         return ret;
77 }
78
79 #ifdef _USE_SENIOR_MODE
80 int media_folder_foreach_media_from_db_by_union_select(const char* folder_id, filter_h filter1, filter_h filter2, media_info_cb callback, void* user_data)
81 {
82         int ret = MEDIA_CONTENT_ERROR_NONE;
83
84         if ((callback != NULL) && STRING_VALID(folder_id)) {
85                 ret = _media_db_get_group_item_by_union_select(folder_id, filter1, filter2, callback, user_data);
86         } else {
87                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
88                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
89         }
90
91         return ret;
92 }
93 #endif
94
95 int media_folder_destroy(media_folder_h folder)
96 {
97         int ret = MEDIA_CONTENT_ERROR_NONE;
98         media_folder_s *_folder = (media_folder_s*)folder;
99         if (_folder) {
100                 SAFE_FREE(_folder->path);
101                 SAFE_FREE(_folder->name);
102                 SAFE_FREE(_folder->folder_id);
103                 SAFE_FREE(_folder->parent_folder_id);
104                 SAFE_FREE(_folder->storage_uuid);
105                 SAFE_FREE(_folder);
106                 ret = MEDIA_CONTENT_ERROR_NONE;
107         } else {
108                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
109                 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
110         }
111
112         return ret;
113 }
114 int media_folder_clone(media_folder_h *dst, media_folder_h src)
115 {
116         int ret = MEDIA_CONTENT_ERROR_NONE;
117         media_folder_s *_src = (media_folder_s*)src;
118
119         if (_src != NULL) {
120                 media_folder_s *_dst = (media_folder_s*)calloc(1, sizeof(media_folder_s));
121                 media_content_retvm_if(_dst == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
122
123                 if (STRING_VALID(_src->folder_id)) {
124                         _dst->folder_id = strdup(_src->folder_id);
125                         if (_dst->folder_id == NULL) {
126                                 SAFE_FREE(_dst);
127                                 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
128                                 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
129                         }
130                 }
131
132                 if (STRING_VALID(_src->parent_folder_id)) {
133                         _dst->parent_folder_id = strdup(_src->parent_folder_id);
134                         if (_dst->parent_folder_id == NULL) {
135                                 media_folder_destroy((media_folder_h)_dst);
136                                 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
137                                 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
138                         }
139                 }
140
141                 if (STRING_VALID(_src->name)) {
142                         _dst->name = strdup(_src->name);
143                         if (_dst->name == NULL) {
144                                 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
145                                 media_folder_destroy((media_folder_h)_dst);
146                                 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
147                         }
148                 }
149
150                 if (STRING_VALID(_src->path)) {
151                         _dst->path = strdup(_src->path);
152                         if (_dst->path == NULL) {
153                                 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
154                                 media_folder_destroy((media_folder_h)_dst);
155                                 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
156                         }
157                 }
158
159                 if (STRING_VALID(_src->storage_uuid)) {
160                         _dst->storage_uuid = strdup(_src->storage_uuid);
161                         if (_dst->storage_uuid == NULL) {
162                                 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
163                                 media_folder_destroy((media_folder_h)_dst);
164                                 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
165                         }
166                 }
167
168                 _dst->storage_type = _src->storage_type;
169                 _dst->modified_time = _src->modified_time;
170                 _dst->folder_order = _src->folder_order;
171
172                 *dst = (media_folder_h)_dst;
173
174                 ret = MEDIA_CONTENT_ERROR_NONE;
175         } else {
176                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
177                 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
178         }
179
180         return ret;
181 }
182
183 int media_folder_get_folder_id(media_folder_h folder, char **folder_id)
184 {
185         int ret = MEDIA_CONTENT_ERROR_NONE;
186         media_folder_s *_folder = (media_folder_s*)folder;
187
188         if (_folder) {
189                 if (STRING_VALID(_folder->folder_id)) {
190                         *folder_id = strdup(_folder->folder_id);
191                         media_content_retvm_if(*folder_id == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
192                 } else {
193                         *folder_id = NULL;
194                 }
195                 ret = MEDIA_CONTENT_ERROR_NONE;
196         } else {
197                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
198                 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
199         }
200
201         return ret;
202 }
203
204 int media_folder_get_parent_folder_id(media_folder_h folder, char **parent_folder_id)
205 {
206         int ret = MEDIA_CONTENT_ERROR_NONE;
207         media_folder_s *_folder = (media_folder_s*)folder;
208
209         if (_folder) {
210                 if (STRING_VALID(_folder->parent_folder_id)) {
211                         *parent_folder_id = strdup(_folder->parent_folder_id);
212                         media_content_retvm_if(*parent_folder_id == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
213                 } else {
214                         *parent_folder_id = NULL;
215                 }
216                 ret = MEDIA_CONTENT_ERROR_NONE;
217         } else {
218                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
219                 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
220         }
221
222         return ret;
223 }
224
225 int media_folder_get_path(media_folder_h folder, char **path)
226 {
227         int ret = MEDIA_CONTENT_ERROR_NONE;
228         media_folder_s *_folder = (media_folder_s*)folder;
229
230         if (_folder) {
231                 if (STRING_VALID(_folder->path)) {
232                         *path = strdup(_folder->path);
233                         media_content_retvm_if(*path == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
234                 } else {
235                         *path = NULL;
236                 }
237                 ret = MEDIA_CONTENT_ERROR_NONE;
238
239         } else {
240                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
241                 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
242         }
243
244         return ret;
245
246 }
247
248 int media_folder_get_name(media_folder_h folder, char **name)
249 {
250         int ret = MEDIA_CONTENT_ERROR_NONE;
251         media_folder_s *_folder = (media_folder_s*)folder;
252
253         if (_folder) {
254                 if (STRING_VALID(_folder->name)) {
255                         *name = strdup(_folder->name);
256                         media_content_retvm_if(*name == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
257                 } else {
258                         *name = NULL;
259                 }
260                 ret = MEDIA_CONTENT_ERROR_NONE;
261
262         } else {
263                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
264                 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
265         }
266
267         return ret;
268 }
269
270 int media_folder_get_modified_time(media_folder_h folder, time_t* time)
271 {
272         int ret = MEDIA_CONTENT_ERROR_NONE;
273         media_folder_s *_folder = (media_folder_s*)folder;
274
275         if (_folder) {
276                 *time = _folder->modified_time;
277                 ret = MEDIA_CONTENT_ERROR_NONE;
278         } else {
279                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
280                 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
281         }
282
283         return ret;
284 }
285
286 int media_folder_get_storage_type(media_folder_h folder, media_content_storage_e* storage_type)
287 {
288         int ret = MEDIA_CONTENT_ERROR_NONE;
289         media_folder_s *_folder = (media_folder_s*)folder;
290
291         if (_folder) {
292                 *storage_type = _folder->storage_type;
293                 ret = MEDIA_CONTENT_ERROR_NONE;
294         } else {
295                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
296                 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
297         }
298
299         return ret;
300 }
301
302 int media_folder_get_storage_id(media_folder_h folder, char **storage_id)
303 {
304         int ret = MEDIA_CONTENT_ERROR_NONE;
305         media_folder_s *_folder = (media_folder_s*)folder;
306
307         if (_folder) {
308                 if (STRING_VALID(_folder->storage_uuid)) {
309                         *storage_id = strdup(_folder->storage_uuid);
310                         media_content_retvm_if(*storage_id == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
311                 } else {
312                         *storage_id = NULL;
313                 }
314                 ret = MEDIA_CONTENT_ERROR_NONE;
315
316         } else {
317                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
318                 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
319         }
320
321         return ret;
322 }
323
324 int media_folder_get_order(media_folder_h folder, int *order)
325 {
326         int ret = MEDIA_CONTENT_ERROR_NONE;
327         media_folder_s *_folder = (media_folder_s*)folder;
328
329         if (_folder) {
330                 *order = _folder->folder_order;
331                 ret = MEDIA_CONTENT_ERROR_NONE;
332         } else {
333                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
334                 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
335         }
336
337         return ret;
338 }
339
340
341 int media_folder_get_folder_from_db(const char *folder_id, media_folder_h *folder)
342 {
343         int ret = MEDIA_CONTENT_ERROR_NONE;
344         sqlite3_stmt *stmt = NULL;
345         char select_query[DEFAULT_QUERY_SIZE];
346
347         if (!STRING_VALID(folder_id)) {
348                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
349                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
350         }
351
352         memset(select_query, 0x00, sizeof(select_query));
353
354         snprintf(select_query, sizeof(select_query), SELECT_FOLDER_FROM_FOLDER, folder_id);
355
356         ret = _content_query_prepare(&stmt, select_query, NULL, NULL);
357         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
358
359         media_folder_s *_folder = NULL;
360
361         while (sqlite3_step(stmt) == SQLITE_ROW) {
362                 if (_folder)
363                         media_folder_destroy((media_folder_h)_folder);
364
365                 _folder = (media_folder_s*)calloc(1, sizeof(media_folder_s));
366                 if (_folder == NULL) {
367                         media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
368                         SQLITE3_FINALIZE(stmt);
369                         return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
370                 }
371
372                 media_content_error("folder handle %x", _folder);
373
374                 _folder->folder_id = g_strdup((const char *)sqlite3_column_text(stmt, 0));
375                 _folder->path = g_strdup((const char *)sqlite3_column_text(stmt, 1));
376                 _folder->name = g_strdup((const char *)sqlite3_column_text(stmt, 2));
377                 _folder->modified_time = (int)sqlite3_column_int(stmt, 3);
378                 _folder->storage_type = (int)sqlite3_column_int(stmt, 5);
379                 _folder->storage_uuid = g_strdup((const char *)sqlite3_column_text(stmt, 6));
380                 _folder->folder_order = (int)sqlite3_column_int(stmt, 7);
381                 _folder->parent_folder_id = g_strdup((const char *)sqlite3_column_text(stmt, 8));
382
383                 *folder = (media_folder_h)_folder;
384         }
385
386         SQLITE3_FINALIZE(stmt);
387
388         return ret;
389 }
390
391 int media_folder_update_to_db(media_folder_h folder)
392 {
393         int ret = MEDIA_CONTENT_ERROR_NONE;
394         media_folder_s *_folder = (media_folder_s*)folder;
395         char *sql = NULL;
396
397         if ((_folder == NULL) || (_folder->folder_id == NULL)) {
398                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
399                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
400         }
401
402         /* Update folder order */
403         sql = sqlite3_mprintf(UPDATE_FOLDER_ORDER, _folder->folder_order, _folder->folder_id);
404
405         ret = _content_query_sql(sql);
406         SQLITE3_SAFE_FREE(sql);
407
408         if (STRING_VALID(_folder->folder_id) && g_src_path) {
409                 char *name_pinyin = NULL;
410                 bool pinyin_support = FALSE;
411
412                 /* Set modified time */
413                 time_t date;
414                 time(&date);
415                 _folder->modified_time = date;
416
417                 /*Update Pinyin If Support Pinyin*/
418                 media_svc_check_pinyin_support(&pinyin_support);
419                 if (pinyin_support)
420                         media_svc_get_pinyin(_folder->name, &name_pinyin);
421
422                 sql = sqlite3_mprintf("UPDATE %Q SET path='%q', name='%q', modified_time=%d, name_pinyin='%q' WHERE folder_uuid=%Q",
423                                                 DB_TABLE_FOLDER, _folder->path, _folder->name, _folder->modified_time, name_pinyin, _folder->folder_id);
424
425                 ret = _content_query_sql(sql);
426                 SQLITE3_SAFE_FREE(sql);
427                 if (ret != MEDIA_CONTENT_ERROR_NONE) {
428                         SAFE_FREE(g_src_path);
429                         return ret;
430                 }
431
432                 /* Update all folder record's path, which are matched by old parent path */
433                 char *update_folder_path_sql = NULL;
434                 char src_path_slash[MAX_QUERY_SIZE + 1] = {0, };
435                 char dst_path_slash[MAX_QUERY_SIZE + 1] = {0, };
436
437                 snprintf(src_path_slash, sizeof(src_path_slash), "%s/", g_src_path);
438                 snprintf(dst_path_slash, sizeof(dst_path_slash), "%s/", _folder->path);
439
440                 update_folder_path_sql = sqlite3_mprintf("UPDATE folder SET path = REPLACE( path, '%q', '%q');", src_path_slash, dst_path_slash);
441
442                 ret = _content_query_sql(update_folder_path_sql);
443                 SQLITE3_SAFE_FREE(update_folder_path_sql);
444                 if (ret != MEDIA_CONTENT_ERROR_NONE) {
445                         SAFE_FREE(g_src_path);
446                         return ret;
447                 }
448
449                 ret = media_svc_rename_folder(_content_get_db_handle(), _folder->storage_uuid, g_src_path, _folder->path, tzplatform_getuid(TZ_USER_NAME));
450                 SAFE_FREE(g_src_path);
451
452                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
453         }
454
455         return ret;
456 }
457
458 int media_folder_set_name(media_folder_h folder, const char *name)
459 {
460         int ret = MEDIA_CONTENT_ERROR_NONE;
461         media_folder_s *_folder = (media_folder_s*)folder;
462
463         if (_folder != NULL && STRING_VALID(name)) {
464                 if (STRING_VALID(_folder->path) && STRING_VALID(_folder->name)) {
465                         char *folder_path = NULL;
466                         char new_folder_path[MAX_QUERY_SIZE] = {0,};
467                         bool ignore_dir = FALSE;
468
469                         folder_path = g_path_get_dirname(_folder->path);
470                         media_content_sec_debug("Existed Folder Path : %s", _folder->path);
471                         snprintf(new_folder_path, sizeof(new_folder_path), "%s/%s", folder_path, name);
472                         media_content_sec_debug("New Path : %s", new_folder_path);
473
474                         ret = _media_util_check_ignore_dir(new_folder_path, &ignore_dir);
475                         if (ignore_dir == TRUE) {
476                                 media_content_error("Invalid folder path");
477                                 SAFE_FREE(folder_path);
478                                 return ret;
479                         }
480
481                         SAFE_FREE(g_src_path);
482                         g_src_path = strdup(_folder->path);
483
484                         SAFE_FREE(_folder->path);
485                         SAFE_FREE(_folder->name);
486                         SAFE_FREE(folder_path);
487                         _folder->path = strdup(new_folder_path);
488                         media_content_retvm_if(_folder->path == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
489                 }
490
491                 _folder->name = strdup(name);
492                 media_content_retvm_if(_folder->name == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
493         } else {
494                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
495                 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
496         }
497
498         return ret;
499 }
500
501 int media_folder_set_order(media_folder_h folder, int order)
502 {
503         int ret = MEDIA_CONTENT_ERROR_NONE;
504         media_folder_s *_folder = (media_folder_s*)folder;
505
506         if (_folder != NULL && order >= 0) {
507                 _folder->folder_order = order;
508         } else {
509                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
510                 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
511         }
512
513         return ret;
514 }
515 #ifdef _USE_TV_PROFILE
516 int media_folder_get_scan_status(const char *storage_uuid, char* path, media_folder_scan_status_e *scan_status)
517 {
518         int ret = MEDIA_CONTENT_ERROR_NONE;
519         int status = MEDIA_DIR_SCAN_NONE;
520
521         if (STRING_VALID(storage_uuid) && STRING_VALID(path)) {
522                 ret = media_svc_get_folder_scan_status(_content_get_db_handle(), storage_uuid, path, &status);
523                 if (ret != MS_MEDIA_ERR_NONE) {
524                         media_content_error("media_svc_get_folder_scan_status failed");
525                         ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
526                 } else {
527                         *scan_status = status;
528                 }
529         } else {
530                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
531                 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
532         }
533
534         return ret;
535 }
536 #endif