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