Merge "Match columns of tag with filter keyword" into tizen
[platform/core/api/media-content.git] / src / media_content.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
22 static attribute_h g_attr_handle = NULL;
23 static attribute_h g_alias_attr_handle = NULL;
24 static sqlite3 *db_handle = NULL;
25 static int ref_count = 0;
26 static GMutex db_mutex;
27 static uid_t content_g_uid = 0;
28
29 static int __media_content_create_attribute_handles(void);
30 static int __media_content_destroy_attribute_handle(void);
31
32 typedef struct {
33         char *user_attr;
34         char *platform_attr;
35         char *platform_alias_attr;
36 } media_content_attribute_info_s;
37
38 static media_content_attribute_info_s g_content_attrs_info[] = {
39         /* Media Info */
40         {MEDIA_ID,                                              DB_FIELD_MEDIA_ID,                                              DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ID},
41         {MEDIA_PATH,                                    DB_FIELD_MEDIA_PATH,                                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PATH},
42         {MEDIA_DISPLAY_NAME,                    DB_FIELD_MEDIA_DISPLAY_NAME,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DISPLAY_NAME},
43         {MEDIA_TYPE,                                            DB_FIELD_MEDIA_TYPE,                                            DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TYPE},
44         {MEDIA_MIME_TYPE,                               DB_FIELD_MEDIA_MIME_TYPE,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MIME_TYPE},
45         {MEDIA_SIZE,                                            DB_FIELD_MEDIA_SIZE,                                            DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SIZE},
46         {MEDIA_ADDED_TIME,                              DB_FIELD_MEDIA_ADDED_TIME,                              DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ADDED_TIME},
47         {MEDIA_MODIFIED_TIME,                   DB_FIELD_MEDIA_MODIFIED_TIME,                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_MODIFIED_TIME},
48         {MEDIA_TIMELINE,                                        DB_FIELD_MEDIA_TIMELINE,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TIMELINE},
49         {MEDIA_THUMBNAIL_PATH,                  DB_FIELD_MEDIA_THUMBNAIL_PATH,                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_THUMBNAIL_PATH},
50         {MEDIA_TITLE,                                   DB_FIELD_MEDIA_TITLE,                                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE},
51         {MEDIA_ALBUM,                                   DB_FIELD_MEDIA_ALBUM,                                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM},
52         {MEDIA_ARTIST,                                  DB_FIELD_MEDIA_ARTIST,                                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST},
53         {MEDIA_ALBUM_ARTIST,                    DB_FIELD_MEDIA_ALBUM_ARTIST,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST},
54         {MEDIA_GENRE,                                   DB_FIELD_MEDIA_GENRE,                                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE},
55         {MEDIA_COMPOSER,                                DB_FIELD_MEDIA_COMPOSER,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER},
56         {MEDIA_YEAR,                                    DB_FIELD_MEDIA_YEAR,                                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_YEAR},
57         {MEDIA_RECORDED_DATE,                   DB_FIELD_MEDIA_RECORDED_DATE,                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RECORDED_DATE},
58         {MEDIA_COPYRIGHT,                               DB_FIELD_MEDIA_COPYRIGHT,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT},
59         {MEDIA_TRACK_NUM,                               DB_FIELD_MEDIA_TRACK_NUM,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TRACK_NUM},
60         {MEDIA_DESCRIPTION,                             DB_FIELD_MEDIA_DESCRIPTION,                             DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION},
61         {MEDIA_BITRATE,                                 DB_FIELD_MEDIA_BITRATE,                                 DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITRATE},
62         {MEDIA_BITPERSAMPLE,                    DB_FIELD_MEDIA_BITPERSAMPLE,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_BITPERSAMPLE},
63         {MEDIA_SAMPLERATE,                              DB_FIELD_MEDIA_SAMPLERATE,                              DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_SAMPLERATE},
64         {MEDIA_CHANNEL,                         DB_FIELD_MEDIA_CHANNEL,                         DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CHANNEL},
65         {MEDIA_DURATION,                                DB_FIELD_MEDIA_DURATION,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DURATION},
66         {MEDIA_LONGITUDE,                               DB_FIELD_MEDIA_LONGITUDE,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LONGITUDE},
67         {MEDIA_LATITUDE,                                DB_FIELD_MEDIA_LATITUDE,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LATITUDE},
68         {MEDIA_ALTITUDE,                                DB_FIELD_MEDIA_ALTITUDE,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALTITUDE},
69         {MEDIA_WIDTH,                                   DB_FIELD_MEDIA_WIDTH,                                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_WIDTH},
70         {MEDIA_HEIGHT,                                  DB_FIELD_MEDIA_HEIGHT,                                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_HEIGHT},
71         {MEDIA_DATETAKEN,                               DB_FIELD_MEDIA_DATETAKEN,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DATETAKEN},
72         {MEDIA_ORIENTATION,                     DB_FIELD_MEDIA_ORIENTATION,                     DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ORIENTATION},
73         {MEDIA_RATING,                                  DB_FIELD_MEDIA_RATING,                                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_RATING},
74         {MEDIA_FAVOURITE,                               DB_FIELD_MEDIA_FAVOURITE,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FAVOURITE},
75         {MEDIA_IS_DRM,                                  DB_FIELD_MEDIA_IS_DRM,                                  DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_IS_DRM},
76         {MEDIA_STORAGE_TYPE,                    DB_FIELD_MEDIA_STORAGE_TYPE,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_STORAGE_TYPE},
77         {MEDIA_360,                                             DB_FIELD_MEDIA_360,                                             DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_360},
78
79         /* Pinyin */
80         {MEDIA_FILE_NAME_PINYIN,                DB_FIELD_MEDIA_FILE_NAME_PINYIN,                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FILE_NAME_PINYIN},
81         {MEDIA_TITLE_PINYIN,                            DB_FIELD_MEDIA_TITLE_PINYIN,                            DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_TITLE_PINYIN},
82         {MEDIA_ALBUM_PINYIN,                    DB_FIELD_MEDIA_ALBUM_PINYIN,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_PINYIN},
83         {MEDIA_ARTIST_PINYIN,                   DB_FIELD_MEDIA_ARTIST_PINYIN,                   DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ARTIST_PINYIN},
84         {MEDIA_ALBUM_ARTIST_PINYIN,             DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN,             DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_ALBUM_ARTIST_PINYIN},
85         {MEDIA_GENRE_PINYIN,                    DB_FIELD_MEDIA_GENRE_PINYIN,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_GENRE_PINYIN},
86         {MEDIA_COMPOSER_PINYIN,         DB_FIELD_MEDIA_COMPOSER_PINYIN,         DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COMPOSER_PINYIN},
87         {MEDIA_COPYRIGHT_PINYIN,                DB_FIELD_MEDIA_COPYRIGHT_PINYIN,                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_COPYRIGHT_PINYIN},
88         {MEDIA_DESCRIPTION_PINYIN,              DB_FIELD_MEDIA_DESCRIPTION_PINYIN,              DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_DESCRIPTION_PINYIN},
89
90         /* Folder */
91         {FOLDER_ID,                                             NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_ID},
92         {FOLDER_PATH,                                   NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_PATH},
93         {FOLDER_NAME,                                   NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME},
94         {FOLDER_STORAGE_TYPE,                   NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_STORAGE_TYPE},
95         {FOLDER_NAME_PINYIN,                    NULL,                                                                   DB_TABLE_ALIAS_FOLDER"."DB_FIELD_FOLDER_NAME_PINYIN},
96
97         /* Playlist */
98         {MEDIA_PLAYLIST_ID,                             DB_FIELD_PLAYLIST_ID,                                   NULL},
99         {PLAYLIST_NAME,                                 DB_FIELD_PLAYLIST_NAME,                                 NULL},
100         {PLAYLIST_MEMBER_ORDER,         DB_FIELD_PLAYLIST_MEMBER_ORDER,                         NULL},
101
102         /* Playlist View */
103         {PLAYLIST_MEDIA_COUNT,                  DB_FIELD_PLAYLIST_MEDIA_COUNT,                  NULL},
104
105         /* Storage */
106         {MEDIA_STORAGE_ID,                              DB_FIELD_STORAGE_ID,                                    NULL},
107         {MEDIA_STORAGE_PATH,                    DB_FIELD_STORAGE_PATH,                                  NULL},
108
109 #ifdef _USE_SENIOR_MODE
110         {MEDIA_CONTACT,                         DB_FIELD_MEDIA_CONTACT,                         DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTACT},
111         {MEDIA_APP_DATA,                                DB_FIELD_MEDIA_APP_DATA,                                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_APP_DATA},
112 #endif
113 #ifdef _USE_TVPD_MODE
114         {MEDIA_PLAYED_COUNT,                    DB_FIELD_MEDIA_PLAYED_COUNT,                    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PLAYED_COUNT},
115         {MEDIA_LAST_PLAYED_TIME,                DB_FIELD_MEDIA_LAST_PLAYED_TIME,                DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_TIME},
116         {MEDIA_LAST_PLAYED_POSITION,    DB_FIELD_MEDIA_LAST_PLAYED_POSITION,    DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_POSITION},
117         {MEDIA_FOLDER_ID,                               DB_FIELD_MEDIA_FOLDER_ID,                               DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FOLDER_ID},
118         {MEDIA_STITCHED_INFO,                   DB_FIELD_MEDIA_STITCHED_INFO,                   NULL},
119         {MEDIA_MODIFIED_MONTH,          DB_FIELD_MEDIA_MODIFIED_MONTH,          NULL},
120         {MEDIA_MODIFIED_DATE,                   DB_FIELD_MEDIA_MODIFIED_DATE,                   NULL},
121
122         /* PVR */
123         {PVR_DURATION,                                  DB_FIELD_PVR_DURATION,                                  NULL},
124         {PVR_TIME_ZONE,                                 DB_FIELD_PVR_TIME_ZONE,                                 NULL},
125         {PVR_PTC,                                               DB_FIELD_PVR_PTC,                                               NULL},
126         {PVR_MAJOR,                                             DB_FIELD_PVR_MAJOR,                                             NULL},
127         {PVR_MINOR,                                             DB_FIELD_PVR_MINOR,                                             NULL},
128         {PVR_CHANNEL_TYPE,                              DB_FIELD_PVR_CHANNEL_TYPE,                              NULL},
129         {PVR_CHANNEL_NAME,                              DB_FIELD_PVR_CHANNEL_NAME,                      NULL},
130         {PVR_CHANNEL_NUM,                               DB_FIELD_PVR_CHANNEL_NUM,                               NULL},
131         {PVR_PROGRAM_TITLE,                             DB_FIELD_PVR_PROGRAM_TITLE,                             NULL},
132         {PVR_PROGRAM_NUM,                               DB_FIELD_PVR_PROGRAM_NUM,                               NULL},
133         {PVR_PROGRAM_CRID,                              DB_FIELD_PVR_PROGRAM_CRID,                              NULL},
134         {PVR_GUIDANCE,                                  DB_FIELD_PVR_GUIDANCE,                                  NULL},
135         {PVR_SYNOPSIS,                                  DB_FIELD_PVR_SYNOPSIS,                                  NULL},
136         {PVR_GENRE,                                             DB_FIELD_PVR_GENRE,                                             NULL},
137         {PVR_LANGUAGE,                                  DB_FIELD_PVR_LANGUAGE,                                  NULL},
138         {PVR_EMBARGO_TIME,                              DB_FIELD_PVR_EMBARGO_TIME,                              NULL},
139         {PVR_EXPIRY_TIME,                               DB_FIELD_PVR_EXPIRY_TIME,                               NULL},
140         {PVR_START_TIME,                                        DB_FIELD_PVR_START_TIME,                                        NULL},
141         {PVR_PROGRAM_START_TIME,                DB_FIELD_PVR_PROGRAM_START_TIME,                NULL},
142         {PVR_PROGRAM_END_TIME,                  DB_FIELD_PVR_PROGRAM_END_TIME,          NULL},
143         {PVR_PROGRAM_DATE,                              DB_FIELD_PVR_PROGRAM_DATE,                              NULL},
144         {PVR_PARENTAL_RATING,                   DB_FIELD_PVR_PARENTAL_RATING,                   NULL},
145         {PVR_TIMER_RECORD,                              DB_FIELD_PVR_TIMER_RECORD,                              NULL},
146         {PVR_SERIES_RECORD,                             DB_FIELD_PVR_SERIES_RECORD,                             NULL},
147         {PVR_HD,                                                        DB_FIELD_PVR_HD,                                                        NULL},
148         {PVR_SUBTITLE,                                  DB_FIELD_PVR_SUBTITLE,                                  NULL},
149         {PVR_TTX,                                               DB_FIELD_PVR_TTX,                                               NULL},
150         {PVR_AD,                                                        DB_FIELD_PVR_AD,                                                        NULL},
151         {PVR_TTX,                                               DB_FIELD_PVR_TTX,                                               NULL},
152         {PVR_DATA_SERVICE,                              DB_FIELD_PVR_DATA_SERVICE,                              NULL},
153         {PVR_CONTENT_LOCK,                              DB_FIELD_PVR_CONTENT_LOCK,                              NULL},
154         {PVR_CONTENT_WATCH,                     DB_FIELD_PVR_CONTENT_WATCH,                     NULL},
155         {PVR_CONTENT_HAS_AUDIO_ONLY,    DB_FIELD_PVR_HAS_AUDIO_ONLY,                    NULL},
156         {PVR_CONTENT_IS_LOCAL_RECORD,   DB_FIELD_PVR_IS_LOCAL_RECORD,                   NULL},
157         {PVR_CONTENT_RESOLUTION,                DB_FIELD_PVR_RESOLUTION,                                NULL},
158         {PVR_CONTENT_ASPECTRATIO,               DB_FIELD_PVR_ASPECTRATIO,                               NULL},
159         {PVR_MODIFIED_MONTH,                    DB_FIELD_PVR_MODIFIED_DATE,                             NULL},
160         {PVR_MODIFIED_DATE,                             DB_FIELD_PVR_MODIFIED_DATE,                             NULL},
161         {PVR_SPORTS_TYPE,                               DB_FIELD_PVR_SPORTS_TYPE,                               NULL},
162         {PVR_GUIDANCE_LENGTH,                   DB_FIELD_PVR_GUIDANCE_LENGTH,                   NULL},
163         {PVR_TVMODE,                                    DB_FIELD_PVR_TVMODE,                                    NULL},
164         {PVR_PLAY_COUNT,                                DB_FIELD_PVR_PLAY_COUNT,                                NULL},
165         {PVR_PRIVATE_DATA,                              DB_FIELD_PVR_PRIVATE_DATA,                              NULL},
166
167         /* UHD */
168         {UHD_CONTENT_TITLE,                             DB_FIELD_UHD_CONTENT_TITLE,                             NULL},
169         {UHD_RELEASE_DATE,                              DB_FIELD_UHD_RELEASE_DATE,                              NULL},
170         {UHD_SUB_TYPE,                                  DB_FIELD_UHD_SUB_TYPE,                                  NULL},
171         {UHD_FILE_NAME,                                 DB_FIELD_UHD_FILE_NAME,                                 NULL},
172         {UHD_FOLDER_ID,                                 DB_FIELD_FOLDER_ID,                                             NULL},
173         {UHD_PLAYED_COUNT,                              DB_FIELD_UHD_PLAYED_COUNT,                              NULL},
174 #endif
175 };
176
177 static int __media_content_create_attribute_handles(void)
178 {
179         int ret = MEDIA_CONTENT_ERROR_NONE;
180         int idx = 0;
181         int count = 0;
182         char *_attr_user = NULL;
183         char *_attr_platform = NULL;
184         char *_alias_attr_user = NULL;
185         char *_alias_attr_platform = NULL;
186         attribute_s *_attr = NULL;
187         attribute_s *_alias_attr = NULL;
188
189         ret = _media_filter_attribute_create(&g_attr_handle);
190         media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
191
192         ret = _media_filter_attribute_create(&g_alias_attr_handle);
193         if (ret != MEDIA_CONTENT_ERROR_NONE)
194                 goto ERROR;
195
196         _attr = (attribute_s*)g_attr_handle;
197         _alias_attr = (attribute_s*)g_alias_attr_handle;
198
199         count = sizeof(g_content_attrs_info) / sizeof((g_content_attrs_info)[0]);
200
201         for (idx = 0; idx < count; idx++) {
202                 _attr_user = NULL;
203                 _attr_platform = NULL;
204                 _alias_attr_user = NULL;
205                 _alias_attr_platform = NULL;
206
207                 if (STRING_VALID(g_content_attrs_info[idx].user_attr)) {
208                         /*attribute*/
209                         if (STRING_VALID(g_content_attrs_info[idx].platform_attr)) {
210                                 _attr_user = g_strdup(g_content_attrs_info[idx].user_attr);
211                                 _attr_platform = g_strdup(g_content_attrs_info[idx].platform_attr);
212
213                                 if (_attr_user == NULL || _attr_platform == NULL) {
214                                         SAFE_G_FREE(_attr_user);
215                                         SAFE_G_FREE(_attr_platform);
216                                         media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
217                                         ret = MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
218                                         goto ERROR;
219                                 }
220
221                                 g_hash_table_insert(_attr->attr_map, _attr_user, _attr_platform);
222
223                         }
224
225                         /*alias attribute*/
226                         if (STRING_VALID(g_content_attrs_info[idx].platform_alias_attr)) {
227                                 _alias_attr_user = g_strdup(g_content_attrs_info[idx].user_attr);
228                                 _alias_attr_platform = g_strdup(g_content_attrs_info[idx].platform_alias_attr);
229
230                                 if (_alias_attr_user == NULL || _alias_attr_platform == NULL) {
231                                         SAFE_G_FREE(_alias_attr_user);
232                                         SAFE_G_FREE(_alias_attr_platform);
233                                         media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
234                                         ret = MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
235                                         goto ERROR;
236                                 }
237
238                                 g_hash_table_insert(_alias_attr->attr_map, _alias_attr_user, _alias_attr_platform);
239                         }
240                 } else {
241                         media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
242                         ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
243                         goto ERROR;
244                 }
245         }
246
247         return ret;
248
249 ERROR:
250         media_content_error("Fail media_content_create_attribute_handles");
251         __media_content_destroy_attribute_handle();
252
253         return ret;
254 }
255
256 static int __media_content_destroy_attribute_handle(void)
257 {
258         int ret = MEDIA_CONTENT_ERROR_NONE;
259
260         ret = _media_filter_attribute_destory(g_attr_handle);
261         ret = _media_filter_attribute_destory(g_alias_attr_handle);
262
263         g_attr_handle = NULL;
264         g_alias_attr_handle = NULL;
265
266         return ret;
267 }
268
269 attribute_h _content_get_attirbute_handle(void)
270 {
271         return g_attr_handle;
272 }
273
274 attribute_h _content_get_alias_attirbute_handle(void)
275 {
276         /* This API use only folder query */
277         return g_alias_attr_handle;
278 }
279
280 sqlite3 * _content_get_db_handle(void)
281 {
282         return db_handle;
283 }
284
285 uid_t _content_get_uid(void)
286 {
287         if (content_g_uid == 0)
288                 return tzplatform_getuid(TZ_USER_NAME);
289         else
290                 return content_g_uid;
291 }
292
293 int _content_query_prepare(sqlite3_stmt **stmt, char *select_query, char *condition_query, char *option_query)
294 {
295         int len = 0;
296         int err = MEDIA_CONTENT_ERROR_NONE;
297         char query[MAX_QUERY_SIZE] = {0, };
298         memset(query, '\0', sizeof(query));
299
300         media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
301         media_content_retvm_if(!STRING_VALID(select_query), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query");
302
303         if (!STRING_VALID(condition_query))
304                 condition_query = (char *)" ";
305
306         if (!STRING_VALID(option_query))
307                 option_query = (char *)" ";
308
309         /*query = sqlite3_mprintf("%s %s %s", select_query, condition_query, option_query);*/
310         len = snprintf(query, sizeof(query), "%s %s %s", select_query, condition_query, option_query);
311         if (len > 0 && len < sizeof(query))
312                 query[len] = '\0';
313         else if (len >= sizeof(query))
314                 query[MAX_QUERY_SIZE -1] = '\0';
315         else {
316                 media_content_error("snprintf failed");
317                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
318         }
319
320         media_content_sec_debug("Query : [%s]", query);
321
322         err = sqlite3_prepare_v2(db_handle, query, strlen(query), stmt, NULL);
323         if (err != SQLITE_OK) {
324                 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg(db_handle));
325
326                 if (err == SQLITE_BUSY) {
327                         media_content_error(" BUSY ERROR");
328                         return MEDIA_CONTENT_ERROR_DB_BUSY;
329                 } else if (err == SQLITE_PERM) {
330                         media_content_error("PERMISSION EROR");
331                         return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
332                 } else {
333                         media_content_error("OTHER ERROR");
334                         return MEDIA_CONTENT_ERROR_DB_FAILED;
335                 }
336         }
337
338         return MEDIA_CONTENT_ERROR_NONE;
339 }
340
341 #ifdef _USE_SENIOR_MODE
342 int _content_query_prepare_by_union_select(sqlite3_stmt **stmt, char *select_query1, char *condition_query1, char *option_query1, char *select_query2, char *condition_query2, char *option_query2)
343 {
344         int len = 0;
345         int err = MEDIA_CONTENT_ERROR_NONE;
346         char query[MAX_QUERY_SIZE] = {0, };
347         memset(query, '\0', sizeof(query));
348
349         media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
350         media_content_retvm_if(!STRING_VALID(select_query1), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query1");
351         media_content_retvm_if(!STRING_VALID(select_query2), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query2");
352
353         if (!STRING_VALID(condition_query1))
354                 condition_query1 = (char *)" ";
355
356         if (!STRING_VALID(option_query1))
357                 option_query1 = (char *)" ";
358
359         if (!STRING_VALID(condition_query2))
360                 condition_query2 = (char *)" ";
361
362         if (!STRING_VALID(option_query2))
363                 option_query2 = (char *)" ";
364
365         len = snprintf(query, sizeof(query), "SELECT * FROM (%s %s %s) as table1 UNION ALL SELECT * FROM (%s %s %s) as table2",
366                         select_query1, condition_query1, option_query1, select_query2, condition_query2, option_query2);
367         if (len > 0 && len < sizeof(query)) {
368                 query[len] = '\0';
369         } else if (len >= sizeof(query)) {
370                 query[MAX_QUERY_SIZE -1] = '\0';
371         } else {
372                 media_content_error("snprintf failed");
373                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
374         }
375
376         media_content_sec_debug("Query : [%s]", query);
377
378         err = sqlite3_prepare_v2(db_handle, query, strlen(query), stmt, NULL);
379         if (err != SQLITE_OK) {
380                 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg(db_handle));
381
382                 if (err == SQLITE_BUSY) {
383                         media_content_error(" BUSY ERROR");
384                         return MEDIA_CONTENT_ERROR_DB_BUSY;
385                 } else if (err == SQLITE_PERM) {
386                         media_content_error("PERMISSION EROR");
387                         return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
388                 } else {
389                         media_content_error("OTHER ERROR");
390                         return MEDIA_CONTENT_ERROR_DB_FAILED;
391                 }
392         }
393
394         return MEDIA_CONTENT_ERROR_NONE;
395 }
396 #endif
397
398 int _content_error_capi(int type, int content_error)
399 {
400         if (content_error != MEDIA_CONTENT_ERROR_NONE)
401                 media_content_error("[type : %d] content_error : %d ", type, content_error);
402
403         /*Error None*/
404         if (content_error == MS_MEDIA_ERR_NONE)
405                 return MEDIA_CONTENT_ERROR_NONE;
406
407         /* Internal operation error*/
408         else if ((content_error == MS_MEDIA_ERR_INVALID_PARAMETER) ||
409                 (content_error == MS_MEDIA_ERR_INVALID_PATH) ||
410                 (content_error == MS_MEDIA_ERR_THUMB_DUPLICATED_REQUEST))
411                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
412
413         else if (content_error == MS_MEDIA_ERR_OUT_OF_MEMORY)
414                 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
415
416         /* DB operation error*/
417         else if (content_error == MS_MEDIA_ERR_DB_BUSY_FAIL)
418                 return MEDIA_CONTENT_ERROR_DB_BUSY;
419
420         else if ((content_error <= MS_MEDIA_ERR_DB_CONNECT_FAIL) && (content_error >= MS_MEDIA_ERR_DB_INTERNAL))
421                 return MEDIA_CONTENT_ERROR_DB_FAILED;
422
423         /* IPC operation error*/
424         else if ((content_error <= MS_MEDIA_ERR_SOCKET_CONN) && (content_error >= MS_MEDIA_ERR_SOCKET_INTERNAL))
425                 return MEDIA_CONTENT_ERROR_NETWORK;
426
427         /* MEDIA SERVER error*/
428         else if (content_error == MS_MEDIA_ERR_PERMISSION_DENIED)
429                 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
430
431         /* Thumbnail error*/
432         else if ((content_error == MS_MEDIA_ERR_THUMB_TOO_BIG) || (content_error == MS_MEDIA_ERR_THUMB_UNSUPPORTED))
433                         return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT;
434
435         /*ETC*/
436         return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
437 }
438
439 int _content_query_sql(char *query_str)
440 {
441         int ret = MEDIA_CONTENT_ERROR_NONE;
442
443         /*DB will be updated by Media Server.*/
444         ret = media_db_request_update_db(query_str, _content_get_uid());
445
446         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
447 }
448
449 int media_content_connect(void)
450 {
451         int ret = MEDIA_CONTENT_ERROR_NONE;
452
453         g_mutex_lock(&db_mutex);
454         media_content_info("ref count : %d", ref_count);
455
456         if (ref_count == 0) {
457                 if (db_handle == NULL) {
458                         ret = __media_content_create_attribute_handles();
459                         if (ret == MEDIA_CONTENT_ERROR_NONE) {
460                                 ret = media_db_connect(&db_handle, _content_get_uid(), false);
461                                 ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
462                                 if (ret == MEDIA_CONTENT_ERROR_NONE)
463                                         ref_count++;
464                                 else
465                                         __media_content_destroy_attribute_handle();
466
467                         } else {
468                                 media_content_error("Internal DB Connection Error");
469                         }
470                 } else {
471                         media_content_error("Wrong DB Connection status");
472                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
473                 }
474         } else {
475                 if (db_handle != NULL) {
476                         ref_count++;
477                 } else {
478                         media_content_error("Wrong DB Handle status");
479                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
480                 }
481         }
482
483         media_content_info("ref count changed to: %d", ref_count);
484         g_mutex_unlock(&db_mutex);
485
486         return ret;
487 }
488
489 int media_content_connect_with_uid(uid_t uid)
490 {
491         media_content_sec_debug("media_content_connect_with_uid [%d]", uid);
492         content_g_uid = uid;
493
494         return media_content_connect();
495 }
496
497 int media_content_disconnect(void)
498 {
499         int ret = MEDIA_CONTENT_ERROR_NONE;
500
501         g_mutex_lock(&db_mutex);
502         media_content_debug("ref count : %d", ref_count);
503         if (ref_count > 0) {
504                 if (db_handle != NULL) {
505                         ref_count--;
506                 } else {
507                         media_content_error("Wrong DB Handle status");
508                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
509                 }
510         } else {
511                 media_content_error("DB_FAILED(0x%08x) database is not connected", MEDIA_CONTENT_ERROR_DB_FAILED);
512                 g_mutex_unlock(&db_mutex);
513                 return MEDIA_CONTENT_ERROR_DB_FAILED;
514         }
515
516         if (ref_count == 0) {
517                 if (db_handle != NULL) {
518                         ret = media_db_disconnect(db_handle);
519                         ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
520                         if (ret == MEDIA_CONTENT_ERROR_NONE) {
521                                 ret = __media_content_destroy_attribute_handle();
522                                 db_handle = NULL;
523                         } else {
524                                 media_content_error("database disconnect fail");
525                                 ref_count++;
526                         }
527                 } else {
528                         media_content_error("Wrong DB Handle status");
529                         ret = MEDIA_CONTENT_ERROR_DB_FAILED;
530                 }
531
532                 g_mutex_unlock(&db_mutex);
533
534                 media_content_info("ref count changed to: %d", ref_count);
535
536                 return ret;
537         }
538
539         g_mutex_unlock(&db_mutex);
540
541         media_content_info("ref count changed to: %d", ref_count);
542
543         return ret;
544 }
545
546 int media_content_scan_file(const char *path)
547 {
548         int ret = MEDIA_CONTENT_ERROR_NONE;
549         bool ignore_file = FALSE;
550         bool ignore_dir = FALSE;
551         char *folder_path = NULL;
552         int check_file = MEDIA_CONTENT_ERROR_NONE;
553         char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0,};
554         char repl_path[MAX_PATH_LEN] = {0,};
555
556         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid path");
557
558         media_content_sec_debug("Path : %s", path);
559
560         memset(repl_path, 0, sizeof(repl_path));
561         ret = _media_content_replace_path(path, repl_path);
562         media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
563
564         ret = _media_util_check_ignore_file(repl_path, &ignore_file);
565         media_content_retvm_if(ignore_file == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
566
567         memset(storage_id, 0x00, sizeof(storage_id));
568         ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
569         if (ret != MS_MEDIA_ERR_NONE) {
570                 media_content_error("media_svc_get_storage_id failed : %d", ret);
571                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
572         }
573
574         check_file = _media_util_check_file_exist(repl_path);
575         if (check_file == MEDIA_CONTENT_ERROR_NONE) {
576                 /* This means this path has to be inserted or refreshed */
577                 folder_path = g_path_get_dirname(repl_path);
578                 ret = _media_util_check_ignore_dir(folder_path, &ignore_dir);
579                 SAFE_FREE(folder_path);
580
581                 media_content_retvm_if(ignore_dir == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
582                 /* check feature */
583                 media_content_retvm_if(!_media_util_check_support_media_type(repl_path), MEDIA_CONTENT_ERROR_NOT_SUPPORTED, "Unsupported media type");
584
585                 ms_user_storage_type_e storage_type;
586
587                 ret = ms_user_get_storage_type(_content_get_uid(), repl_path, &storage_type);
588                 if (ret != MS_MEDIA_ERR_NONE) {
589                         media_content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, repl_path);
590                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
591                 }
592                 ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, repl_path);
593                 if (ret == MS_MEDIA_ERR_NONE) {
594                         /* Refresh */
595                         ret = media_svc_refresh_item(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
596                         if (ret != MS_MEDIA_ERR_NONE) {
597                                 media_content_error("media_svc_refresh_item failed : %d", ret);
598                                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
599                         }
600
601                 } else if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
602                         /* Insert */
603                         ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
604                         if (ret != MS_MEDIA_ERR_NONE) {
605                                 if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) {
606                                         media_content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", repl_path);
607                                         ret = MEDIA_CONTENT_ERROR_NONE;
608                                 } else {
609                                         media_content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, repl_path);
610                                 }
611
612                                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
613                         }
614                 } else {
615                         media_content_error("media_svc_check_item_exist_by_path failed : %d", ret);
616                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
617                 }
618         } else if (check_file == MEDIA_CONTENT_ERROR_PERMISSION_DENIED) {
619                 media_content_error("You have no permission for this file %d", ret);
620                 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
621         } else {
622                 /* This means this path has to be deleted */
623                 media_content_debug("This path doesn't exists in file system... So now start to delete it from DB");
624                 ret = media_svc_delete_item_by_path(_content_get_db_handle(), storage_id, repl_path, _content_get_uid());
625                 if (ret != MS_MEDIA_ERR_NONE) {
626                         if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
627                                 media_content_error("Does not exist in media DB also... So, this is an invalid parameter");
628                                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
629                         }
630
631                         media_content_error("media_svc_delete_item_by_path failed : %d", ret);
632                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
633                 }
634         }
635
636         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
637 }
638
639 void _media_content_scan_cb(media_request_result_s* result, void *user_data)
640 {
641         int err = -1;
642         media_content_scan_cb_data *cb_data = user_data;
643
644         err = _content_error_capi(MEDIA_REGISTER_TYPE, result->result);
645 #ifdef _USE_TVPD_MODE
646         if (result->request_type != MEDIA_REQUEST_SCAN_COMPLETE &&
647                 result->request_type != MEDIA_REQUEST_SCAN_PARTIAL) {
648                 if (cb_data && cb_data->callback) {
649                         media_content_debug("begin:User callback is being called now, result=%d", err);
650                         cb_data->callback(err, cb_data->user_data);
651                         media_content_debug("end:User callback is being called now, result=%d", err);
652                 }
653
654                 SAFE_FREE(cb_data);
655         }
656 #else
657         if (cb_data && cb_data->callback) {
658                 media_content_debug("User callback is being called now");
659                 cb_data->callback(err, cb_data->user_data);
660         }
661
662         SAFE_FREE(cb_data);
663 #endif
664
665         return;
666 }
667
668 #ifdef _USE_TVPD_MODE
669 void _media_content_scan_cb_v2(media_request_result_s* result, void *user_data)
670 {
671         int err = -1;
672         media_content_scan_cb_data_v2 *cb_data = user_data;
673         media_content_complete_phase_e complete_phase = -1;
674         if (!cb_data)
675                 media_content_debug("cb_data is NULL");
676         err = _content_error_capi(MEDIA_REGISTER_TYPE, result->result);
677         media_content_debug("result is %d", err);
678
679         if (result->request_type == MEDIA_REQUEST_SCAN_PARTIAL)
680                 complete_phase = MEDIA_CONTENT_SCAN_PARTIAL_COMPLETE;
681         else if (result->request_type == MEDIA_REQUEST_SCAN_COMPLETE)
682                 complete_phase = MEDIA_CONTENT_SCAN_COMPLETE;
683         else if (result->request_type == MEDIA_REQUEST_EXTRACT_COMPLETE)
684                 complete_phase = MEDIA_CONTENT_EXTRACT_COMPLETE;
685
686         if (cb_data && cb_data->callback)
687                 cb_data->callback(err, complete_phase, cb_data->user_data);
688         else
689                 media_content_debug("run error");
690
691         if ((result->request_type != MEDIA_REQUEST_SCAN_COMPLETE) &&
692         (result->request_type != MEDIA_REQUEST_SCAN_PARTIAL))
693                 SAFE_FREE(cb_data);
694
695         return;
696 }
697 #endif
698
699 int media_content_scan_folder(const char *path, bool is_recursive, media_scan_completed_cb callback, void *user_data)
700 {
701         int ret = MEDIA_CONTENT_ERROR_NONE;
702         bool ignore_dir = FALSE;
703         char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
704         char repl_path[MAX_PATH_LEN] = {0, };
705         ms_user_storage_type_e storage_type = MS_USER_STORAGE_INTERNAL;
706
707         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
708         memset(repl_path, 0, sizeof(repl_path));
709         ret = _media_content_replace_path(path, repl_path);
710         media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
711
712         memset(storage_id, 0x00, sizeof(storage_id));
713
714         ret = _media_content_check_dir(repl_path);
715         media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
716
717         if (ret == MEDIA_CONTENT_ERROR_NONE) {
718                 /* If directory exist check that's ignore directory or not*/
719                 ret = _media_util_check_ignore_dir(repl_path, &ignore_dir);
720                 media_content_retvm_if((ignore_dir == TRUE || ret != MEDIA_CONTENT_ERROR_NONE), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
721         } else {
722                 /* This means this folder has to be deleted */
723                 /* Or, it is real invalid path.. check storage type */
724                 ret = ms_user_get_storage_type(_content_get_uid(), repl_path, &storage_type);
725                 if (ret != MS_MEDIA_ERR_NONE) {
726                         media_content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, repl_path);
727                         return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
728                 }
729
730                 media_content_debug("This path doesn't exists in file system... So will be deleted it from DB");
731         }
732
733         ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
734         if (ret != MS_MEDIA_ERR_NONE) {
735                 media_content_error("media_svc_get_storage_id failed : %d", ret);
736                 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
737         }
738
739         media_content_scan_cb_data *cb_data = NULL;
740         cb_data = (media_content_scan_cb_data *)malloc(sizeof(media_content_scan_cb_data));
741         media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
742
743         cb_data->callback = callback;
744         cb_data->user_data = user_data;
745
746         ret = media_directory_scanning_async(repl_path, storage_id, is_recursive, _media_content_scan_cb, cb_data, _content_get_uid());
747         if (ret != MS_MEDIA_ERR_NONE) {
748                 media_content_error("media_directory_scanning_async failed : %d", ret);
749                 SAFE_FREE(cb_data);
750         }
751
752         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
753 }
754
755 #ifdef _USE_TVPD_MODE
756 int media_content_scan_folder_v2(const char *path, bool is_recursive, media_scan_completed_cb_v2 callback, void *user_data)
757 {
758         int ret = MEDIA_CONTENT_ERROR_NONE;
759         bool ignore_dir = FALSE;
760         char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
761
762         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
763         memset(storage_id, 0x00, sizeof(storage_id));
764
765         ret = _media_util_check_ignore_dir(path, &ignore_dir);
766         media_content_retvm_if(ignore_dir, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
767
768         ret = _media_content_check_dir(path);
769         media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
770         media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_INVALID_PARAMETER, ret, "invalid path[%s]", path);
771
772         media_content_scan_cb_data_v2* cb_data = NULL;
773         cb_data = (media_content_scan_cb_data_v2*)malloc(sizeof(media_content_scan_cb_data_v2));
774         media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
775
776         cb_data->callback = callback;
777         cb_data->user_data = user_data;
778
779         ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid());
780         /*FIX ME. need to check ret value?*/
781
782         ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb_v2, cb_data, _content_get_uid());
783         if (ret != MS_MEDIA_ERR_NONE)
784                 media_content_error("media_directory_scanning_async failed : %d", ret);
785
786         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
787 }
788 #endif
789
790 int media_content_cancel_scan_folder(const char *path)
791 {
792         int ret = MEDIA_CONTENT_ERROR_NONE;
793         char repl_path[MAX_PATH_LEN] = {0, };
794
795         media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
796
797         memset(repl_path, 0, sizeof(repl_path));
798         ret = _media_content_replace_path(path, repl_path);
799         media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
800
801         ret = media_directory_scanning_cancel(repl_path, _content_get_uid());
802         if (ret != MS_MEDIA_ERR_NONE)
803                 media_content_error("media_directory_scanning_async failed : %d", ret);
804
805         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
806 }
807
808 void _media_content_db_update_noti_cb(
809                                                         int pid,
810                                                         media_item_type_e item,
811                                                         media_item_update_type_e update_type,
812                                                         char* path,
813                                                         char* uuid,
814                                                         media_type_e content_type,
815                                                         char *mime_type,
816                                                         void *user_data)
817 {
818         int error_value = MEDIA_CONTENT_ERROR_NONE;
819
820         media_noti_cb_s *_noti_info = (media_noti_cb_s *)user_data;
821
822         if (_noti_info != NULL) {
823                 if (_noti_info->update_noti_cb)
824                         _noti_info->update_noti_cb(error_value, pid, item, update_type, content_type, uuid, path, mime_type, _noti_info->user_data);
825         }
826
827         return;
828 }
829
830 int media_content_add_db_updated_cb(media_content_db_update_cb callback, void *user_data, media_content_noti_h *noti_handle)
831 {
832         int ret = MEDIA_CONTENT_ERROR_NONE;
833         media_noti_cb_s *noti_info = NULL;
834
835         if (noti_handle == NULL) {
836                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
837                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
838         }
839
840         if (callback == NULL) {
841                 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
842                 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
843         }
844
845         noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s));
846         if (noti_info == NULL) {
847                 media_content_error("Failed to create noti info");
848                 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
849         }
850
851         noti_info->update_noti_cb = callback;
852         noti_info->user_data = user_data;
853
854         ret = media_db_update_subscribe_internal((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info);
855
856         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
857 }
858
859 void __media_content_clear_user_data(void *user_data)
860 {
861         media_noti_cb_s *noti_info = user_data;
862
863         SAFE_FREE(noti_info);
864
865         return;
866 }
867
868 int media_content_remove_db_updated_cb(media_content_noti_h noti_handle)
869 {
870         int ret = MEDIA_CONTENT_ERROR_NONE;
871
872         ret = media_db_update_unsubscribe_internal((MediaNotiHandle)noti_handle, __media_content_clear_user_data);
873
874         return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
875 }
876 #ifdef _USE_TVPD_MODE
877 GMutex* _content_get_db_mutex(void)
878 {
879         return &db_mutex;
880 }
881 #endif