2 * Copyright (c) 2011 Samsung Electronics Co., Ltd All Rights Reserved
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
8 * http://www.apache.org/licenses/LICENSE-2.0
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
18 #include <media_info_private.h>
19 #include <media_util_private.h>
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;
29 static int __media_content_create_attribute_handles(void);
30 static int __media_content_destroy_attribute_handle(void);
35 char *platform_alias_attr;
36 } media_content_attribute_info_s;
38 static media_content_attribute_info_s g_content_attrs_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},
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},
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},
98 {MEDIA_PLAYLIST_ID, DB_FIELD_PLAYLIST_ID, NULL},
99 {PLAYLIST_NAME, DB_FIELD_PLAYLIST_NAME, DB_TABLE_ALIAS_PLAYLIST"."DB_FIELD_PLAYLIST_NAME},
100 {PLAYLIST_MEMBER_ORDER, DB_FIELD_PLAYLIST_MEMBER_ORDER, DB_TABLE_ALIAS_PLAYLIST_MAP"."DB_FIELD_PLAYLIST_MEMBER_ORDER},
103 {PLAYLIST_MEDIA_COUNT, DB_FIELD_PLAYLIST_MEDIA_COUNT, NULL},
106 {MEDIA_TAG_ID, DB_FIELD_TAG_ID, NULL},
107 {TAG_NAME, DB_FIELD_TAG_NAME, DB_TABLE_ALIAS_TAG"."DB_FIELD_TAG_NAME},
110 {TAG_MEDIA_COUNT, DB_FIELD_TAG_MEDIA_COUNT, NULL},
113 {MEDIA_BOOKMARK_ID, DB_FIELD_BOOKMARK_ID, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_ID},
114 {BOOKMARK_MARKED_TIME, DB_FIELD_BOOKMARK_MARKED_TIME, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_MARKED_TIME},
115 {BOOKMARK_NAME, DB_FIELD_BOOKMARK_NAME, DB_TABLE_ALIAS_BOOKMARK"."DB_FIELD_BOOKMARK_NAME},
118 {MEDIA_STORAGE_ID, DB_FIELD_STORAGE_ID, NULL},
119 {MEDIA_STORAGE_PATH, DB_FIELD_STORAGE_PATH, NULL},
122 {MEDIA_FACE_ID, DB_FIELD_FACE_ID, DB_TABLE_ALIAS_FACE"."DB_FIELD_FACE_ID},
123 {MEDIA_FACE_TAG, DB_FIELD_FACE_TAG, DB_TABLE_ALIAS_FACE"."DB_FIELD_FACE_TAG},
125 #ifdef _USE_SENIOR_MODE
126 {MEDIA_CONTACT, DB_FIELD_MEDIA_CONTACT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_CONTACT},
127 {MEDIA_APP_DATA, DB_FIELD_MEDIA_APP_DATA, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_APP_DATA},
129 #ifdef _USE_TVPD_MODE
130 {MEDIA_PLAYED_COUNT, DB_FIELD_MEDIA_PLAYED_COUNT, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_PLAYED_COUNT},
131 {MEDIA_LAST_PLAYED_TIME, DB_FIELD_MEDIA_LAST_PLAYED_TIME, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_TIME},
132 {MEDIA_LAST_PLAYED_POSITION, DB_FIELD_MEDIA_LAST_PLAYED_POSITION, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_LAST_PLAYED_POSITION},
133 {MEDIA_FOLDER_ID, DB_FIELD_MEDIA_FOLDER_ID, DB_TABLE_ALIAS_MEDIA"."DB_FIELD_MEDIA_FOLDER_ID},
134 {MEDIA_STITCHED_INFO, DB_FIELD_MEDIA_STITCHED_INFO, NULL},
135 {MEDIA_MODIFIED_MONTH, DB_FIELD_MEDIA_MODIFIED_MONTH, NULL},
136 {MEDIA_MODIFIED_DATE, DB_FIELD_MEDIA_MODIFIED_DATE, NULL},
139 {PVR_DURATION, DB_FIELD_PVR_DURATION, NULL},
140 {PVR_TIME_ZONE, DB_FIELD_PVR_TIME_ZONE, NULL},
141 {PVR_PTC, DB_FIELD_PVR_PTC, NULL},
142 {PVR_MAJOR, DB_FIELD_PVR_MAJOR, NULL},
143 {PVR_MINOR, DB_FIELD_PVR_MINOR, NULL},
144 {PVR_CHANNEL_TYPE, DB_FIELD_PVR_CHANNEL_TYPE, NULL},
145 {PVR_CHANNEL_NAME, DB_FIELD_PVR_CHANNEL_NAME, NULL},
146 {PVR_CHANNEL_NUM, DB_FIELD_PVR_CHANNEL_NUM, NULL},
147 {PVR_PROGRAM_TITLE, DB_FIELD_PVR_PROGRAM_TITLE, NULL},
148 {PVR_PROGRAM_NUM, DB_FIELD_PVR_PROGRAM_NUM, NULL},
149 {PVR_PROGRAM_CRID, DB_FIELD_PVR_PROGRAM_CRID, NULL},
150 {PVR_GUIDANCE, DB_FIELD_PVR_GUIDANCE, NULL},
151 {PVR_SYNOPSIS, DB_FIELD_PVR_SYNOPSIS, NULL},
152 {PVR_GENRE, DB_FIELD_PVR_GENRE, NULL},
153 {PVR_LANGUAGE, DB_FIELD_PVR_LANGUAGE, NULL},
154 {PVR_EMBARGO_TIME, DB_FIELD_PVR_EMBARGO_TIME, NULL},
155 {PVR_EXPIRY_TIME, DB_FIELD_PVR_EXPIRY_TIME, NULL},
156 {PVR_START_TIME, DB_FIELD_PVR_START_TIME, NULL},
157 {PVR_PROGRAM_START_TIME, DB_FIELD_PVR_PROGRAM_START_TIME, NULL},
158 {PVR_PROGRAM_END_TIME, DB_FIELD_PVR_PROGRAM_END_TIME, NULL},
159 {PVR_PROGRAM_DATE, DB_FIELD_PVR_PROGRAM_DATE, NULL},
160 {PVR_PARENTAL_RATING, DB_FIELD_PVR_PARENTAL_RATING, NULL},
161 {PVR_TIMER_RECORD, DB_FIELD_PVR_TIMER_RECORD, NULL},
162 {PVR_SERIES_RECORD, DB_FIELD_PVR_SERIES_RECORD, NULL},
163 {PVR_HD, DB_FIELD_PVR_HD, NULL},
164 {PVR_SUBTITLE, DB_FIELD_PVR_SUBTITLE, NULL},
165 {PVR_TTX, DB_FIELD_PVR_TTX, NULL},
166 {PVR_AD, DB_FIELD_PVR_AD, NULL},
167 {PVR_TTX, DB_FIELD_PVR_TTX, NULL},
168 {PVR_DATA_SERVICE, DB_FIELD_PVR_DATA_SERVICE, NULL},
169 {PVR_CONTENT_LOCK, DB_FIELD_PVR_CONTENT_LOCK, NULL},
170 {PVR_CONTENT_WATCH, DB_FIELD_PVR_CONTENT_WATCH, NULL},
171 {PVR_CONTENT_HAS_AUDIO_ONLY, DB_FIELD_PVR_HAS_AUDIO_ONLY, NULL},
172 {PVR_CONTENT_IS_LOCAL_RECORD, DB_FIELD_PVR_IS_LOCAL_RECORD, NULL},
173 {PVR_CONTENT_RESOLUTION, DB_FIELD_PVR_RESOLUTION, NULL},
174 {PVR_CONTENT_ASPECTRATIO, DB_FIELD_PVR_ASPECTRATIO, NULL},
175 {PVR_MODIFIED_MONTH, DB_FIELD_PVR_MODIFIED_DATE, NULL},
176 {PVR_MODIFIED_DATE, DB_FIELD_PVR_MODIFIED_DATE, NULL},
177 {PVR_SPORTS_TYPE, DB_FIELD_PVR_SPORTS_TYPE, NULL},
178 {PVR_GUIDANCE_LENGTH, DB_FIELD_PVR_GUIDANCE_LENGTH, NULL},
179 {PVR_TVMODE, DB_FIELD_PVR_TVMODE, NULL},
180 {PVR_PLAY_COUNT, DB_FIELD_PVR_PLAY_COUNT, NULL},
181 {PVR_PRIVATE_DATA, DB_FIELD_PVR_PRIVATE_DATA, NULL},
184 {UHD_CONTENT_TITLE, DB_FIELD_UHD_CONTENT_TITLE, NULL},
185 {UHD_RELEASE_DATE, DB_FIELD_UHD_RELEASE_DATE, NULL},
186 {UHD_SUB_TYPE, DB_FIELD_UHD_SUB_TYPE, NULL},
187 {UHD_FILE_NAME, DB_FIELD_UHD_FILE_NAME, NULL},
188 {UHD_FOLDER_ID, DB_FIELD_FOLDER_ID, NULL},
189 {UHD_PLAYED_COUNT, DB_FIELD_UHD_PLAYED_COUNT, NULL},
193 static int __media_content_create_attribute_handles(void)
195 int ret = MEDIA_CONTENT_ERROR_NONE;
198 char *_attr_user = NULL;
199 char *_attr_platform = NULL;
200 char *_alias_attr_user = NULL;
201 char *_alias_attr_platform = NULL;
202 attribute_s *_attr = NULL;
203 attribute_s *_alias_attr = NULL;
205 ret = _media_filter_attribute_create(&g_attr_handle);
206 media_content_retv_if(ret != MEDIA_CONTENT_ERROR_NONE, ret);
208 ret = _media_filter_attribute_create(&g_alias_attr_handle);
209 if (ret != MEDIA_CONTENT_ERROR_NONE)
212 _attr = (attribute_s*)g_attr_handle;
213 _alias_attr = (attribute_s*)g_alias_attr_handle;
215 count = sizeof(g_content_attrs_info) / sizeof((g_content_attrs_info)[0]);
217 for (idx = 0; idx < count; idx++) {
219 _attr_platform = NULL;
220 _alias_attr_user = NULL;
221 _alias_attr_platform = NULL;
223 if (STRING_VALID(g_content_attrs_info[idx].user_attr)) {
225 if (STRING_VALID(g_content_attrs_info[idx].platform_attr)) {
226 _attr_user = g_strdup(g_content_attrs_info[idx].user_attr);
227 _attr_platform = g_strdup(g_content_attrs_info[idx].platform_attr);
229 if (_attr_user == NULL || _attr_platform == NULL) {
230 SAFE_G_FREE(_attr_user);
231 SAFE_G_FREE(_attr_platform);
232 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
233 ret = MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
237 g_hash_table_insert(_attr->attr_map, _attr_user, _attr_platform);
242 if (STRING_VALID(g_content_attrs_info[idx].platform_alias_attr)) {
243 _alias_attr_user = g_strdup(g_content_attrs_info[idx].user_attr);
244 _alias_attr_platform = g_strdup(g_content_attrs_info[idx].platform_alias_attr);
246 if (_alias_attr_user == NULL || _alias_attr_platform == NULL) {
247 SAFE_G_FREE(_alias_attr_user);
248 SAFE_G_FREE(_alias_attr_platform);
249 media_content_error("OUT_OF_MEMORY(0x%08x)", MEDIA_CONTENT_ERROR_OUT_OF_MEMORY);
250 ret = MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
254 g_hash_table_insert(_alias_attr->attr_map, _alias_attr_user, _alias_attr_platform);
257 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
258 ret = MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
266 media_content_error("Fail media_content_create_attribute_handles");
267 __media_content_destroy_attribute_handle();
272 static int __media_content_destroy_attribute_handle(void)
274 int ret = MEDIA_CONTENT_ERROR_NONE;
276 ret = _media_filter_attribute_destory(g_attr_handle);
277 ret = _media_filter_attribute_destory(g_alias_attr_handle);
279 g_attr_handle = NULL;
280 g_alias_attr_handle = NULL;
285 attribute_h _content_get_attirbute_handle(void)
287 return g_attr_handle;
290 attribute_h _content_get_alias_attirbute_handle(void)
292 return g_alias_attr_handle;
295 sqlite3 * _content_get_db_handle(void)
300 uid_t _content_get_uid(void)
302 if (content_g_uid == 0)
303 return tzplatform_getuid(TZ_USER_NAME);
305 return content_g_uid;
308 int _content_query_prepare(sqlite3_stmt **stmt, char *select_query, char *condition_query, char *option_query)
311 int err = MEDIA_CONTENT_ERROR_NONE;
312 char query[MAX_QUERY_SIZE] = {0, };
313 memset(query, '\0', sizeof(query));
315 media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
316 media_content_retvm_if(!STRING_VALID(select_query), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query");
318 if (!STRING_VALID(condition_query))
319 condition_query = (char *)" ";
321 if (!STRING_VALID(option_query))
322 option_query = (char *)" ";
324 /*query = sqlite3_mprintf("%s %s %s", select_query, condition_query, option_query);*/
325 len = snprintf(query, sizeof(query), "%s %s %s", select_query, condition_query, option_query);
326 if (len > 0 && len < sizeof(query))
328 else if (len >= sizeof(query))
329 query[MAX_QUERY_SIZE -1] = '\0';
331 media_content_error("snprintf failed");
332 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
335 media_content_sec_debug("Query : [%s]", query);
337 err = sqlite3_prepare_v2(db_handle, query, strlen(query), stmt, NULL);
338 if (err != SQLITE_OK) {
339 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg(db_handle));
341 if (err == SQLITE_BUSY) {
342 media_content_error(" BUSY ERROR");
343 return MEDIA_CONTENT_ERROR_DB_BUSY;
344 } else if (err == SQLITE_PERM) {
345 media_content_error("PERMISSION EROR");
346 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
348 media_content_error("OTHER ERROR");
349 return MEDIA_CONTENT_ERROR_DB_FAILED;
353 return MEDIA_CONTENT_ERROR_NONE;
356 #ifdef _USE_SENIOR_MODE
357 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)
360 int err = MEDIA_CONTENT_ERROR_NONE;
361 char query[MAX_QUERY_SIZE] = {0, };
362 memset(query, '\0', sizeof(query));
364 media_content_retvm_if(db_handle == NULL, MEDIA_CONTENT_ERROR_DB_FAILED, "database is not connected");
365 media_content_retvm_if(!STRING_VALID(select_query1), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query1");
366 media_content_retvm_if(!STRING_VALID(select_query2), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid select_query2");
368 if (!STRING_VALID(condition_query1))
369 condition_query1 = (char *)" ";
371 if (!STRING_VALID(option_query1))
372 option_query1 = (char *)" ";
374 if (!STRING_VALID(condition_query2))
375 condition_query2 = (char *)" ";
377 if (!STRING_VALID(option_query2))
378 option_query2 = (char *)" ";
380 len = snprintf(query, sizeof(query), "SELECT * FROM (%s %s %s) as table1 UNION ALL SELECT * FROM (%s %s %s) as table2",
381 select_query1, condition_query1, option_query1, select_query2, condition_query2, option_query2);
382 if (len > 0 && len < sizeof(query)) {
384 } else if (len >= sizeof(query)) {
385 query[MAX_QUERY_SIZE -1] = '\0';
387 media_content_error("snprintf failed");
388 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
391 media_content_sec_debug("Query : [%s]", query);
393 err = sqlite3_prepare_v2(db_handle, query, strlen(query), stmt, NULL);
394 if (err != SQLITE_OK) {
395 media_content_error("DB_FAILED(0x%08x) fail to sqlite3_prepare(), %s", MEDIA_CONTENT_ERROR_DB_FAILED, sqlite3_errmsg(db_handle));
397 if (err == SQLITE_BUSY) {
398 media_content_error(" BUSY ERROR");
399 return MEDIA_CONTENT_ERROR_DB_BUSY;
400 } else if (err == SQLITE_PERM) {
401 media_content_error("PERMISSION EROR");
402 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
404 media_content_error("OTHER ERROR");
405 return MEDIA_CONTENT_ERROR_DB_FAILED;
409 return MEDIA_CONTENT_ERROR_NONE;
413 int _content_error_capi(int type, int content_error)
415 if (content_error != MEDIA_CONTENT_ERROR_NONE)
416 media_content_error("[type : %d] content_error : %d ", type, content_error);
419 if (content_error == MS_MEDIA_ERR_NONE)
420 return MEDIA_CONTENT_ERROR_NONE;
422 /* Internal operation error*/
423 else if ((content_error == MS_MEDIA_ERR_INVALID_PARAMETER) ||
424 (content_error == MS_MEDIA_ERR_INVALID_PATH) ||
425 (content_error == MS_MEDIA_ERR_THUMB_DUPLICATED_REQUEST))
426 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
428 else if (content_error == MS_MEDIA_ERR_OUT_OF_MEMORY)
429 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
431 /* DB operation error*/
432 else if (content_error == MS_MEDIA_ERR_DB_BUSY_FAIL)
433 return MEDIA_CONTENT_ERROR_DB_BUSY;
435 else if ((content_error <= MS_MEDIA_ERR_DB_CONNECT_FAIL) && (content_error >= MS_MEDIA_ERR_DB_INTERNAL))
436 return MEDIA_CONTENT_ERROR_DB_FAILED;
438 /* IPC operation error*/
439 else if ((content_error <= MS_MEDIA_ERR_SOCKET_CONN) && (content_error >= MS_MEDIA_ERR_SOCKET_INTERNAL))
440 return MEDIA_CONTENT_ERROR_NETWORK;
442 /* MEDIA SERVER error*/
443 else if (content_error == MS_MEDIA_ERR_PERMISSION_DENIED)
444 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
447 else if ((content_error == MS_MEDIA_ERR_THUMB_TOO_BIG) || (content_error == MS_MEDIA_ERR_THUMB_UNSUPPORTED))
448 return MEDIA_CONTENT_ERROR_UNSUPPORTED_CONTENT;
451 return MEDIA_CONTENT_ERROR_INVALID_OPERATION;
454 int _content_query_sql(char *query_str)
456 int ret = MEDIA_CONTENT_ERROR_NONE;
458 /*DB will be updated by Media Server.*/
459 ret = media_db_request_update_db(query_str, _content_get_uid());
461 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
464 int media_content_connect(void)
466 int ret = MEDIA_CONTENT_ERROR_NONE;
468 g_mutex_lock(&db_mutex);
469 media_content_info("ref count : %d", ref_count);
471 if (ref_count == 0) {
472 if (db_handle == NULL) {
473 ret = __media_content_create_attribute_handles();
474 if (ret == MEDIA_CONTENT_ERROR_NONE) {
475 ret = media_db_connect(&db_handle, _content_get_uid(), false);
476 ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
477 if (ret == MEDIA_CONTENT_ERROR_NONE)
480 __media_content_destroy_attribute_handle();
483 media_content_error("Internal DB Connection Error");
486 media_content_error("Wrong DB Connection status");
487 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
490 if (db_handle != NULL) {
493 media_content_error("Wrong DB Handle status");
494 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
498 media_content_info("ref count changed to: %d", ref_count);
499 g_mutex_unlock(&db_mutex);
504 int media_content_connect_with_uid(uid_t uid)
506 media_content_sec_debug("media_content_connect_with_uid [%d]", uid);
509 return media_content_connect();
512 int media_content_disconnect(void)
514 int ret = MEDIA_CONTENT_ERROR_NONE;
516 g_mutex_lock(&db_mutex);
517 media_content_debug("ref count : %d", ref_count);
519 if (db_handle != NULL) {
522 media_content_error("Wrong DB Handle status");
523 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
526 media_content_error("DB_FAILED(0x%08x) database is not connected", MEDIA_CONTENT_ERROR_DB_FAILED);
527 g_mutex_unlock(&db_mutex);
528 return MEDIA_CONTENT_ERROR_DB_FAILED;
531 if (ref_count == 0) {
532 if (db_handle != NULL) {
533 ret = media_db_disconnect(db_handle);
534 ret = _content_error_capi(MEDIA_CONTENT_TYPE, ret);
535 if (ret == MEDIA_CONTENT_ERROR_NONE) {
536 ret = __media_content_destroy_attribute_handle();
539 media_content_error("database disconnect fail");
543 media_content_error("Wrong DB Handle status");
544 ret = MEDIA_CONTENT_ERROR_DB_FAILED;
547 g_mutex_unlock(&db_mutex);
549 media_content_info("ref count changed to: %d", ref_count);
554 g_mutex_unlock(&db_mutex);
556 media_content_info("ref count changed to: %d", ref_count);
561 int media_content_scan_file(const char *path)
563 int ret = MEDIA_CONTENT_ERROR_NONE;
564 bool ignore_file = FALSE;
565 bool ignore_dir = FALSE;
566 char *folder_path = NULL;
567 int check_file = MEDIA_CONTENT_ERROR_NONE;
568 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0,};
569 char repl_path[MAX_PATH_LEN] = {0,};
571 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "invalid path");
573 media_content_sec_debug("Path : %s", path);
575 memset(repl_path, 0, sizeof(repl_path));
576 ret = _media_content_replace_path(path, repl_path);
577 media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
579 ret = _media_util_check_ignore_file(repl_path, &ignore_file);
580 media_content_retvm_if(ignore_file == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
582 memset(storage_id, 0x00, sizeof(storage_id));
583 ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
584 if (ret != MS_MEDIA_ERR_NONE) {
585 media_content_error("media_svc_get_storage_id failed : %d", ret);
586 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
589 check_file = _media_util_check_file_exist(repl_path);
590 if (check_file == MEDIA_CONTENT_ERROR_NONE) {
591 /* This means this path has to be inserted or refreshed */
592 folder_path = g_path_get_dirname(repl_path);
593 ret = _media_util_check_ignore_dir(folder_path, &ignore_dir);
594 SAFE_FREE(folder_path);
596 media_content_retvm_if(ignore_dir == TRUE, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
598 media_content_retvm_if(!_media_util_check_support_media_type(repl_path), MEDIA_CONTENT_ERROR_NOT_SUPPORTED, "Unsupported media type");
600 ms_user_storage_type_e storage_type;
602 ret = ms_user_get_storage_type(_content_get_uid(), repl_path, &storage_type);
603 if (ret != MS_MEDIA_ERR_NONE) {
604 media_content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, repl_path);
605 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
607 ret = media_svc_check_item_exist_by_path(_content_get_db_handle(), storage_id, repl_path);
608 if (ret == MS_MEDIA_ERR_NONE) {
610 ret = media_svc_refresh_item(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
611 if (ret != MS_MEDIA_ERR_NONE) {
612 media_content_error("media_svc_refresh_item failed : %d", ret);
613 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
616 } else if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
618 ret = media_svc_insert_item_immediately(_content_get_db_handle(), storage_id, storage_type, repl_path, _content_get_uid());
619 if (ret != MS_MEDIA_ERR_NONE) {
620 if (ret == MS_MEDIA_ERR_DB_CONSTRAINT_FAIL) {
621 media_content_sec_error("This item is already inserted. This may be normal operation because other process already did this (%s)", repl_path);
622 ret = MEDIA_CONTENT_ERROR_NONE;
624 media_content_sec_error("media_svc_insert_item_immediately failed : %d (%s)", ret, repl_path);
627 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
630 media_content_error("media_svc_check_item_exist_by_path failed : %d", ret);
631 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
633 } else if (check_file == MEDIA_CONTENT_ERROR_PERMISSION_DENIED) {
634 media_content_error("You have no permission for this file %d", ret);
635 return MEDIA_CONTENT_ERROR_PERMISSION_DENIED;
637 /* This means this path has to be deleted */
638 media_content_debug("This path doesn't exists in file system... So now start to delete it from DB");
639 ret = media_svc_delete_item_by_path(_content_get_db_handle(), storage_id, repl_path, _content_get_uid());
640 if (ret != MS_MEDIA_ERR_NONE) {
641 if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
642 media_content_error("Does not exist in media DB also... So, this is an invalid parameter");
643 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
646 media_content_error("media_svc_delete_item_by_path failed : %d", ret);
647 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
651 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
654 void _media_content_scan_cb(media_request_result_s* result, void *user_data)
657 media_content_scan_cb_data *cb_data = user_data;
659 err = _content_error_capi(MEDIA_REGISTER_TYPE, result->result);
660 #ifdef _USE_TVPD_MODE
661 if (result->request_type != MEDIA_REQUEST_SCAN_COMPLETE &&
662 result->request_type != MEDIA_REQUEST_SCAN_PARTIAL) {
663 if (cb_data && cb_data->callback) {
664 media_content_debug("begin:User callback is being called now, result=%d", err);
665 cb_data->callback(err, cb_data->user_data);
666 media_content_debug("end:User callback is being called now, result=%d", err);
672 if (cb_data && cb_data->callback) {
673 media_content_debug("User callback is being called now");
674 cb_data->callback(err, cb_data->user_data);
683 #ifdef _USE_TVPD_MODE
684 void _media_content_scan_cb_v2(media_request_result_s* result, void *user_data)
687 media_content_scan_cb_data_v2 *cb_data = user_data;
688 media_content_complete_phase_e complete_phase = -1;
690 media_content_debug("cb_data is NULL");
691 err = _content_error_capi(MEDIA_REGISTER_TYPE, result->result);
692 media_content_debug("result is %d", err);
694 if (result->request_type == MEDIA_REQUEST_SCAN_PARTIAL)
695 complete_phase = MEDIA_CONTENT_SCAN_PARTIAL_COMPLETE;
696 else if (result->request_type == MEDIA_REQUEST_SCAN_COMPLETE)
697 complete_phase = MEDIA_CONTENT_SCAN_COMPLETE;
698 else if (result->request_type == MEDIA_REQUEST_EXTRACT_COMPLETE)
699 complete_phase = MEDIA_CONTENT_EXTRACT_COMPLETE;
701 if (cb_data && cb_data->callback)
702 cb_data->callback(err, complete_phase, cb_data->user_data);
704 media_content_debug("run error");
706 if ((result->request_type != MEDIA_REQUEST_SCAN_COMPLETE) &&
707 (result->request_type != MEDIA_REQUEST_SCAN_PARTIAL))
714 int media_content_scan_folder(const char *path, bool is_recursive, media_scan_completed_cb callback, void *user_data)
716 int ret = MEDIA_CONTENT_ERROR_NONE;
717 bool ignore_dir = FALSE;
718 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
719 char repl_path[MAX_PATH_LEN] = {0, };
720 ms_user_storage_type_e storage_type = MS_USER_STORAGE_INTERNAL;
722 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
723 memset(repl_path, 0, sizeof(repl_path));
724 ret = _media_content_replace_path(path, repl_path);
725 media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
727 memset(storage_id, 0x00, sizeof(storage_id));
729 ret = _media_content_check_dir(repl_path);
730 media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
732 if (ret == MEDIA_CONTENT_ERROR_NONE) {
733 /* If directory exist check that's ignore directory or not*/
734 ret = _media_util_check_ignore_dir(repl_path, &ignore_dir);
735 media_content_retvm_if((ignore_dir == TRUE || ret != MEDIA_CONTENT_ERROR_NONE), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
737 /* This means this folder has to be deleted */
738 /* Or, it is real invalid path.. check storage type */
739 ret = ms_user_get_storage_type(_content_get_uid(), repl_path, &storage_type);
740 if (ret != MS_MEDIA_ERR_NONE) {
741 media_content_sec_error("ms_user_get_storage_type failed : %d (%s)", ret, repl_path);
742 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
745 media_content_debug("This path doesn't exists in file system... So will be deleted it from DB");
748 ret = media_svc_get_storage_id(_content_get_db_handle(), repl_path, storage_id, _content_get_uid());
749 if (ret != MS_MEDIA_ERR_NONE) {
750 media_content_error("media_svc_get_storage_id failed : %d", ret);
751 return _content_error_capi(MEDIA_CONTENT_TYPE, ret);
754 media_content_scan_cb_data *cb_data = NULL;
755 cb_data = (media_content_scan_cb_data *)malloc(sizeof(media_content_scan_cb_data));
756 media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
758 cb_data->callback = callback;
759 cb_data->user_data = user_data;
761 ret = media_directory_scanning_async(repl_path, storage_id, is_recursive, _media_content_scan_cb, cb_data, _content_get_uid());
762 if (ret != MS_MEDIA_ERR_NONE) {
763 media_content_error("media_directory_scanning_async failed : %d", ret);
767 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
770 #ifdef _USE_TVPD_MODE
771 int media_content_scan_folder_v2(const char *path, bool is_recursive, media_scan_completed_cb_v2 callback, void *user_data)
773 int ret = MEDIA_CONTENT_ERROR_NONE;
774 bool ignore_dir = FALSE;
775 char storage_id[MEDIA_CONTENT_UUID_SIZE+1] = {0, };
777 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
778 memset(storage_id, 0x00, sizeof(storage_id));
780 ret = _media_util_check_ignore_dir(path, &ignore_dir);
781 media_content_retvm_if(ignore_dir, MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid folder path");
783 ret = _media_content_check_dir(path);
784 media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_PERMISSION_DENIED, ret, "Permission Denied");
785 media_content_retvm_if(ret == MEDIA_CONTENT_ERROR_INVALID_PARAMETER, ret, "invalid path[%s]", path);
787 media_content_scan_cb_data_v2* cb_data = NULL;
788 cb_data = (media_content_scan_cb_data_v2*)malloc(sizeof(media_content_scan_cb_data_v2));
789 media_content_retvm_if(cb_data == NULL, MEDIA_CONTENT_ERROR_OUT_OF_MEMORY, "OUT_OF_MEMORY");
791 cb_data->callback = callback;
792 cb_data->user_data = user_data;
794 ret = media_svc_get_storage_id(_content_get_db_handle(), path, storage_id, _content_get_uid());
795 /*FIX ME. need to check ret value?*/
797 ret = media_directory_scanning_async(path, storage_id, is_recursive, _media_content_scan_cb_v2, cb_data, _content_get_uid());
798 if (ret != MS_MEDIA_ERR_NONE)
799 media_content_error("media_directory_scanning_async failed : %d", ret);
801 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
805 int media_content_cancel_scan_folder(const char *path)
807 int ret = MEDIA_CONTENT_ERROR_NONE;
808 char repl_path[MAX_PATH_LEN] = {0, };
810 media_content_retvm_if(!STRING_VALID(path), MEDIA_CONTENT_ERROR_INVALID_PARAMETER, "Invalid path");
812 memset(repl_path, 0, sizeof(repl_path));
813 ret = _media_content_replace_path(path, repl_path);
814 media_content_retvm_if(!STRING_VALID(repl_path), MEDIA_CONTENT_ERROR_INVALID_OPERATION, "path replacement failed");
816 ret = media_directory_scanning_cancel(repl_path, _content_get_uid());
817 if (ret != MS_MEDIA_ERR_NONE)
818 media_content_error("media_directory_scanning_async failed : %d", ret);
820 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
823 void _media_content_db_update_noti_cb(
825 media_item_type_e item,
826 media_item_update_type_e update_type,
829 media_type_e content_type,
833 int error_value = MEDIA_CONTENT_ERROR_NONE;
835 media_noti_cb_s *_noti_info = (media_noti_cb_s *)user_data;
837 if (_noti_info != NULL) {
838 if (_noti_info->update_noti_cb)
839 _noti_info->update_noti_cb(error_value, pid, item, update_type, content_type, uuid, path, mime_type, _noti_info->user_data);
845 int media_content_add_db_updated_cb(media_content_db_update_cb callback, void *user_data, media_content_noti_h *noti_handle)
847 int ret = MEDIA_CONTENT_ERROR_NONE;
848 media_noti_cb_s *noti_info = NULL;
850 if (noti_handle == NULL) {
851 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
852 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
855 if (callback == NULL) {
856 media_content_error("INVALID_PARAMETER(0x%08x)", MEDIA_CONTENT_ERROR_INVALID_PARAMETER);
857 return MEDIA_CONTENT_ERROR_INVALID_PARAMETER;
860 noti_info = (media_noti_cb_s *)calloc(1, sizeof(media_noti_cb_s));
861 if (noti_info == NULL) {
862 media_content_error("Failed to create noti info");
863 return MEDIA_CONTENT_ERROR_OUT_OF_MEMORY;
866 noti_info->update_noti_cb = callback;
867 noti_info->user_data = user_data;
869 ret = media_db_update_subscribe_internal((MediaNotiHandle*)noti_handle, _media_content_db_update_noti_cb, (void *)noti_info);
871 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
874 void __media_content_clear_user_data(void *user_data)
876 media_noti_cb_s *noti_info = user_data;
878 SAFE_FREE(noti_info);
883 int media_content_remove_db_updated_cb(media_content_noti_h noti_handle)
885 int ret = MEDIA_CONTENT_ERROR_NONE;
887 ret = media_db_update_unsubscribe_internal((MediaNotiHandle)noti_handle, __media_content_clear_user_data);
889 return _content_error_capi(MEDIA_REGISTER_TYPE, ret);
891 #ifdef _USE_TVPD_MODE
892 GMutex* _content_get_db_mutex(void)