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