4 * Copyright (c) 2000 - 2011 Samsung Electronics Co., Ltd. All rights reserved.
6 * Licensed under the Apache License, Version 2.0 (the "License");
7 * you may not use this file except in compliance with the License.
8 * You may obtain a copy of the License at
10 * http://www.apache.org/licenses/LICENSE-2.0
12 * Unless required by applicable law or agreed to in writing, software
13 * distributed under the License is distributed on an "AS IS" BASIS,
14 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
15 * See the License for the specific language governing permissions and
16 * limitations under the License.
29 #include <libexif/exif-data.h>
30 #include <uuid/uuid.h>
31 #include <media-thumbnail.h>
32 #include <media-util-user.h>
33 #include "media-svc-util.h"
34 #include "media-svc-db-utils.h"
35 #include "media-svc-debug.h"
36 #include "media-svc-env.h"
37 #include "media-svc-album.h"
38 /*For ebook metadata */
40 #include <libxml/xmlmemory.h>
41 #include <libxml/parser.h>
42 #include <libxml/HTMLparser.h>
45 #define MEDIA_SVC_FILE_EXT_LEN_MAX 6
47 #define MUSIC_MIME_NUM 29
48 #define SOUND_MIME_NUM 2
49 #define MIME_LENGTH 50
50 #define IMAGE_PREFIX "image/"
51 #define AUDIO_PREFIX "audio/"
52 #define VIDEO_PREFIX "video/"
55 #define MEDIA_SVC_PDF_TAG_TAIL_LEN 12
56 #define MEDIA_SVC_PDF_BUF_SIZE 256
58 #define MEDIA_SVC_THUMB_WIDTH 320
59 #define MEDIA_SVC_THUMB_HEIGHT 240
61 #define PATH_PLUGIN_LIB PATH_LIBDIR"/libmedia-ebook-plugin.so"
63 enum Exif_Orientation {
75 static const char music_mime_table[MUSIC_MIME_NUM][MIME_LENGTH] = {
76 /*known mime types of normal files*/
83 "x-mp3", /*alias of audio/mpeg*/
84 "x-mpeg", /*alias of audio/mpeg*/
86 "x-ogg", /*alias of audio/ogg*/
87 "vnd.ms-playready.media.pya:*.pya", /*playready*/
90 "x-m4a", /*alias of audio/mp4*/
91 /* below mimes are rare*/
100 "x-vorbis", /*alias of audio/x-vorbis+ogg*/
101 "vorbis", /*alias of audio/x-vorbis+ogg*/
103 "x-mp2", /*alias of audio/mp2*/
104 "x-pn-realaudio", /*alias of audio/vnd.rn-realaudio*/
105 "vnd.m-realaudio", /*alias of audio/vnd.rn-realaudio*/
109 static const char sound_mime_table[SOUND_MIME_NUM][MIME_LENGTH] = {
110 "application/x-smaf",
114 static char *__media_info_generate_uuid(void)
117 char uuid_unparsed[37];
120 uuid_generate(uuid_value);
121 uuid_unparse(uuid_value, uuid_unparsed);
123 if (strlen(uuid_unparsed) < 36) {
124 media_svc_debug("INVALID UUID : %s. RETRY GENERATE.", uuid_unparsed);
128 return g_strdup(uuid_unparsed);
131 static int __media_svc_get_media_type(const char *path, const char *mime_type, media_svc_media_type_e *media_type)
137 media_svc_retvm_if(!path, MS_MEDIA_ERR_INVALID_PARAMETER, "path is null");
138 media_svc_retvm_if(!mime_type, MS_MEDIA_ERR_INVALID_PARAMETER, "mime_type is null");
139 media_svc_retvm_if(!media_type, MS_MEDIA_ERR_INVALID_PARAMETER, "media_type is null");
142 if (strncmp(mime_type, IMAGE_PREFIX, PREFIX_LEN) == 0) {
143 *media_type = MEDIA_SVC_MEDIA_TYPE_IMAGE;
144 return MS_MEDIA_ERR_NONE;
148 if (strncmp(mime_type, AUDIO_PREFIX, PREFIX_LEN) == 0) {
149 *media_type = MEDIA_SVC_MEDIA_TYPE_SOUND;
151 for (idx = 0; idx < MUSIC_MIME_NUM; idx++) {
152 if (strcmp(mime_type + PREFIX_LEN, music_mime_table[idx]) == 0) {
153 *media_type = MEDIA_SVC_MEDIA_TYPE_MUSIC;
158 /* audio/x-mpegurl : .m3u file (playlist file) */
159 if (strcmp(mime_type + PREFIX_LEN, "x-mpegurl") == 0)
160 *media_type = MEDIA_SVC_MEDIA_TYPE_OTHER;
162 return MS_MEDIA_ERR_NONE;
166 if (strncmp(mime_type, VIDEO_PREFIX, PREFIX_LEN) == 0) {
167 *media_type = MEDIA_SVC_MEDIA_TYPE_VIDEO;
169 /*some video files don't have video stream. in this case it is categorize as music. */
170 if (strcmp(mime_type + PREFIX_LEN, "3gpp") == 0 ||
171 strcmp(mime_type + PREFIX_LEN, "mp4") == 0) {
172 if (mm_file_get_stream_info(path, &audio, &video) == FILEINFO_ERROR_NONE) {
173 if (audio > 0 && video == 0)
174 *media_type = MEDIA_SVC_MEDIA_TYPE_MUSIC;
178 return MS_MEDIA_ERR_NONE;
182 *media_type = MEDIA_SVC_MEDIA_TYPE_OTHER;
184 for (idx = 0; idx < SOUND_MIME_NUM; idx++) {
185 if (strcmp(mime_type, sound_mime_table[idx]) == 0) {
186 *media_type = MEDIA_SVC_MEDIA_TYPE_SOUND;
187 return MS_MEDIA_ERR_NONE;
191 /*"asf" must check video stream and then categorize in directly. */
192 if (strcmp(mime_type, "application/vnd.ms-asf") == 0) {
193 if (mm_file_get_stream_info(path, &audio, &video) == FILEINFO_ERROR_NONE) {
194 if (audio > 0 && video == 0)
195 *media_type = MEDIA_SVC_MEDIA_TYPE_MUSIC;
197 *media_type = MEDIA_SVC_MEDIA_TYPE_VIDEO;
200 return MS_MEDIA_ERR_NONE;
203 if (strcmp(mime_type, "application/epub+zip") == 0 || strcmp(mime_type, "application/pdf") == 0)
204 *media_type = MEDIA_SVC_MEDIA_TYPE_BOOK;
206 return MS_MEDIA_ERR_NONE;
209 static int __media_svc_get_mime_type(const char *path, char *mimetype)
211 media_svc_retvm_if(path == NULL, MS_MEDIA_ERR_INVALID_PARAMETER, "path is NULL");
213 if (aul_get_mime_from_file(path, mimetype, 255) < 0) {
214 media_svc_error("aul_get_mime_from_file fail");
215 return MS_MEDIA_ERR_INTERNAL;
218 return MS_MEDIA_ERR_NONE;
221 static bool __media_svc_get_file_ext(const char *file_path, char *file_ext)
225 for (i = strlen(file_path); i >= 0; i--) {
226 if (file_path[i] == '.') {
227 g_strlcpy(file_ext, &file_path[i + 1], MEDIA_SVC_FILE_EXT_LEN_MAX);
231 if (file_path[i] == '/')
237 static int __media_svc_save_image(unsigned char *image, unsigned int size, char *image_path, uid_t uid)
239 int ret = MS_MEDIA_ERR_NONE;
241 char *thumb_path = NULL;
242 long bsize_kbytes = 0;
243 GError *error = NULL;
245 media_svc_retvm_if(!image || size == 0, MS_MEDIA_ERR_INVALID_PARAMETER, "Invalid image");
246 media_svc_sec_debug("start save image, path [%s] image size [%d]", image_path, size);
248 ret = ms_user_get_root_thumb_store_path(uid, &thumb_path);
249 media_svc_retvm_if(ret != MS_MEDIA_ERR_NONE, ret, "ms_user_get_root_thumb_store_path error");
251 ret = statfs(thumb_path, &fs);
253 media_svc_retvm_if(ret == -1, MS_MEDIA_ERR_INTERNAL, "statfs failed");
255 bsize_kbytes = fs.f_bsize >> 10;
256 media_svc_retvm_if((bsize_kbytes * fs.f_bavail) < 1024, MS_MEDIA_ERR_NOT_ENOUGH_SPACE, "Not enough space");
258 if (!g_file_set_contents(image_path, (const gchar *)image, (gssize)size, &error)) {
259 media_svc_error("g_file_set_contents faild:%s", error->message);
261 return MS_MEDIA_ERR_INTERNAL;
264 return MS_MEDIA_ERR_NONE;
267 static char *__media_svc_get_title_from_filename(const char *filename)
270 char *last_dot = NULL;
272 media_svc_retvm_if(!STRING_VALID(filename), g_strdup(MEDIA_SVC_TAG_UNKNOWN), "Invalid path");
274 last_dot = strrchr(filename, '.');
276 title = g_strndup(filename, last_dot - filename);
278 title = g_strdup(filename);
281 media_svc_debug("extract title is [%s]", title);
286 void _media_svc_remove_file(const char *path)
288 if (!STRING_VALID(path))
291 if (remove(path) != 0)
292 media_svc_stderror("fail to remove file result");
295 static int __media_svc_get_thumbnail_path(char *thumb_path, const char *pathname, const char *img_format, uid_t uid)
297 int ret = MS_MEDIA_ERR_NONE;
298 char file_ext[MEDIA_SVC_FILE_EXT_LEN_MAX + 1] = {0, };
299 g_autofree gchar *hash = NULL;
300 g_autofree gchar *thumb_dir = NULL;
302 ret = ms_user_get_root_thumb_store_path(uid, &thumb_dir);
303 media_svc_retvm_if(!STRING_VALID(thumb_dir), ret, "ms_user_get_root_thumb_store_path failed");
304 media_svc_retvm_if(!g_file_test(thumb_dir, G_FILE_TEST_IS_DIR), MS_MEDIA_ERR_INTERNAL, "Not a directory");
306 memset(file_ext, 0, sizeof(file_ext));
307 if (!__media_svc_get_file_ext(pathname, file_ext))
308 media_svc_error("get file ext fail");
310 hash = g_compute_checksum_for_string(G_CHECKSUM_MD5, pathname, -1);
311 media_svc_retvm_if(!hash, MS_MEDIA_ERR_INTERNAL, "Failed to create hashname");
314 /* 'img_format' is mime-type */
315 if (!g_str_has_prefix(img_format, IMAGE_PREFIX) || strlen(img_format) == PREFIX_LEN) {
316 media_svc_error("Not proper img format");
317 return MS_MEDIA_ERR_INTERNAL;
320 snprintf(thumb_path, MEDIA_SVC_PATHNAME_SIZE, "%s/.%s-%s.%s", thumb_dir, file_ext, hash, img_format + PREFIX_LEN);
322 if (strcasecmp(file_ext, "PNG") == 0)
323 snprintf(thumb_path, MEDIA_SVC_PATHNAME_SIZE, "%s/.%s-%s.png", thumb_dir, file_ext, hash);
325 snprintf(thumb_path, MEDIA_SVC_PATHNAME_SIZE, "%s/.%s-%s.jpg", thumb_dir, file_ext, hash);
328 return MS_MEDIA_ERR_NONE;
331 int _media_svc_get_file_time(const char *full_path)
333 struct stat statbuf = { 0, };
335 if (stat(full_path, &statbuf) == -1) {
336 media_svc_stderror("stat fails.");
340 return statbuf.st_mtime;
343 int _media_svc_set_media_info(media_svc_content_info_s *content_info, const char *storage_id, const char *path, bool refresh)
345 int ret = MS_MEDIA_ERR_NONE;
346 char mime_type[256] = {0, };
347 media_svc_media_type_e media_type;
348 struct stat st = { 0, };
350 media_svc_retvm_if(!STRING_VALID(path), MS_MEDIA_ERR_INVALID_PARAMETER, "path is NULL");
352 content_info->path = g_strdup(path);
353 content_info->file_name = g_path_get_basename(path);
355 if (stat(path, &st) == 0) {
356 content_info->modified_time = st.st_mtime;
357 content_info->size = st.st_size;
359 media_svc_stderror("stat failed");
362 /* refresh is TRUE when file modified. so only modified_time and size are changed*/
364 media_svc_debug("refresh");
365 return MS_MEDIA_ERR_NONE;
368 content_info->storage_uuid = g_strdup(storage_id);
369 media_svc_retv_del_if(content_info->storage_uuid == NULL, MS_MEDIA_ERR_INTERNAL, content_info);
371 content_info->media_uuid = __media_info_generate_uuid();
372 media_svc_retv_del_if(content_info->media_uuid == NULL, MS_MEDIA_ERR_INTERNAL, content_info);
374 ret = __media_svc_get_mime_type(path, mime_type);
375 media_svc_retv_del_if(ret != MS_MEDIA_ERR_NONE, ret, content_info);
377 media_svc_debug("mime [%s]", mime_type);
379 ret = __media_svc_get_media_type(path, mime_type, &media_type);
380 media_svc_retv_del_if(ret != MS_MEDIA_ERR_NONE, ret, content_info);
382 content_info->mime_type = g_strdup(mime_type);
383 media_svc_retv_del_if(content_info->mime_type == NULL, MS_MEDIA_ERR_INTERNAL, content_info);
385 media_svc_sec_debug("path[%s], media_type[%d]", content_info->path, media_type);
387 content_info->media_type = media_type;
389 return MS_MEDIA_ERR_NONE;
392 static char * __media_svc_get_title(MMHandleType tag, const char *filename)
394 int ret = FILEINFO_ERROR_NONE;
399 ret = mm_file_get_attrs(tag, MM_FILE_TAG_TITLE, &p, &size, NULL);
400 if (ret == FILEINFO_ERROR_NONE && size > 0) {
401 while(p && isspace(*p))
408 return __media_svc_get_title_from_filename(filename);
411 char * _media_svc_get_title_from_filename(const char *filename)
413 return __media_svc_get_title_from_filename(filename);
416 static char * __media_svc_get_exif_datetaken(ExifData *ed)
419 char tmp[MEDIA_SVC_METADATA_LEN_MAX + 1] = { 0, };
421 media_svc_retv_if(!ed, NULL);
423 entry = exif_data_get_entry(ed, EXIF_TAG_DATE_TIME_ORIGINAL);
425 exif_entry_get_value(entry, tmp, MEDIA_SVC_METADATA_LEN_MAX);
427 return g_strdup(tmp);
430 entry = exif_data_get_entry(ed, EXIF_TAG_DATE_TIME);
432 exif_entry_get_value(entry, tmp, MEDIA_SVC_METADATA_LEN_MAX);
434 return g_strdup(tmp);
440 static bool __media_svc_get_exif_short(ExifData *ed, ExifTag tagtype, unsigned short *value)
444 media_svc_retv_if(!ed, false);
445 media_svc_retvm_if(!value, false, "value is NULL");
447 entry = exif_data_get_entry(ed, tagtype);
448 media_svc_retv_if(!entry, false);
449 *value = exif_get_short(entry->data, exif_data_get_byte_order(ed));
454 int _media_svc_extract_image_metadata(media_svc_content_info_s *content_info)
456 unsigned short orient_value = 0;
457 unsigned short exif_width = 0;
458 unsigned short exif_height = 0;
461 media_svc_retvm_if(!content_info, MS_MEDIA_ERR_INVALID_PARAMETER, "Invalid content_info");
462 media_svc_retvm_if(content_info->media_type != MEDIA_SVC_MEDIA_TYPE_IMAGE, MS_MEDIA_ERR_INVALID_PARAMETER, "Invalid media_type");
463 media_svc_retvm_if(!STRING_VALID(content_info->path), MS_MEDIA_ERR_INVALID_PARAMETER, "Invalid path");
465 content_info->media_meta.title = __media_svc_get_title_from_filename(content_info->file_name);
467 /* Load an ExifData object from an EXIF file */
468 ed = exif_data_new_from_file(content_info->path);
470 media_svc_sec_debug("There is no exif data in [ %s ]", content_info->path);
471 goto GET_WIDTH_HEIGHT;
474 content_info->media_meta.datetaken = __media_svc_get_exif_datetaken(ed);
475 content_info->media_meta.recorded_date = g_strdup(content_info->media_meta.datetaken);
476 if (content_info->media_meta.recorded_date == NULL)
477 content_info->media_meta.recorded_date = g_strdup(MEDIA_SVC_TAG_UNKNOWN);
479 if (__media_svc_get_exif_short(ed, EXIF_TAG_ORIENTATION, &orient_value)) {
480 if (orient_value <= ROT_270)
481 content_info->media_meta.orientation = orient_value;
484 if (__media_svc_get_exif_short(ed, EXIF_TAG_PIXEL_X_DIMENSION, &exif_width))
485 content_info->media_meta.width = (unsigned int)exif_width;
487 if (__media_svc_get_exif_short(ed, EXIF_TAG_PIXEL_Y_DIMENSION, &exif_height))
488 content_info->media_meta.height = (unsigned int)exif_height;
493 if (content_info->media_meta.width == 0 || content_info->media_meta.height == 0) {
494 /*Get image width, height*/
495 unsigned int img_width = 0;
496 unsigned int img_height = 0;
498 if (get_image_info(content_info->path, &img_width, &img_height) != THUMB_OK)
499 return MS_MEDIA_ERR_NONE;
501 if (content_info->media_meta.width == 0)
502 content_info->media_meta.width = img_width;
504 if (content_info->media_meta.height == 0)
505 content_info->media_meta.height = img_height;
508 return MS_MEDIA_ERR_NONE;
511 static char * __media_svc_get_tag_str_value(MMHandleType tag, const char *tag_name)
513 int ret = FILEINFO_ERROR_NONE;
517 ret = mm_file_get_attrs(tag, tag_name, &p, &size, NULL);
518 if (ret == FILEINFO_ERROR_NONE && size > 0)
521 return g_strdup(MEDIA_SVC_TAG_UNKNOWN);
524 static char * __media_svc_extract_albumart(MMHandleType tag, const char *path, uid_t uid)
526 int ret = FILEINFO_ERROR_NONE;
527 unsigned char *image = NULL;
528 unsigned int size = 0;
529 char *mimetype = NULL;
530 char thumb_path[MEDIA_SVC_PATHNAME_SIZE] = { 0, };
531 unsigned int mime_size = 0;
533 ret = mm_file_get_attrs(tag, MM_FILE_TAG_ARTWORK, &image, &size, NULL);
534 media_svc_retvm_if(ret != FILEINFO_ERROR_NONE, NULL, "Failed to get tag artwork[%d]", ret);
535 media_svc_retvm_if(!image || size == 0, NULL, "Invalid artwork");
537 ret = mm_file_get_attrs(tag, MM_FILE_TAG_ARTWORK_MIME, &mimetype, &mime_size, NULL);
538 media_svc_retvm_if(ret != FILEINFO_ERROR_NONE, NULL, "Failed to get tag mime[%d]", ret);
539 media_svc_retvm_if(mime_size == 0, NULL, "Invalid mimetype");
541 ret = __media_svc_get_thumbnail_path(thumb_path, path, mimetype, uid);
542 media_svc_retvm_if(ret != MS_MEDIA_ERR_NONE, NULL, "Failed to get thumbnail path");
544 ret = __media_svc_save_image(image, size, thumb_path, uid);
545 media_svc_retvm_if(ret != MS_MEDIA_ERR_NONE, NULL, "Fail to save thumbnail");
547 return g_strdup(thumb_path);
550 void _media_svc_extract_audio_metadata(sqlite3 *handle, bool is_direct, media_svc_content_info_s *content_info, uid_t uid)
552 MMHandleType tag = 0;
554 unsigned int size = 0;
555 int mmf_error = FILEINFO_ERROR_NONE;
557 int ret = MS_MEDIA_ERR_NONE;
558 bool support_albumart = ms_user_thumb_support(uid, content_info->path);
560 /*Get Content Tag attribute ===========*/
561 if (support_albumart)
562 mmf_error = mm_file_create_tag_attrs(&tag, content_info->path);
564 mmf_error = mm_file_create_tag_attrs_no_albumart(&tag, content_info->path);
566 if (mmf_error != FILEINFO_ERROR_NONE) {
567 content_info->media_meta.title = __media_svc_get_title_from_filename(content_info->file_name);
568 content_info->album_id = 0;
572 content_info->media_meta.title = __media_svc_get_title(tag, content_info->file_name);
573 content_info->media_meta.album = __media_svc_get_tag_str_value(tag, MM_FILE_TAG_ALBUM);
574 content_info->media_meta.artist = __media_svc_get_tag_str_value(tag, MM_FILE_TAG_ARTIST);
575 content_info->media_meta.album_artist = __media_svc_get_tag_str_value(tag, MM_FILE_TAG_ALBUM_ARTIST);
576 content_info->media_meta.genre = __media_svc_get_tag_str_value(tag, MM_FILE_TAG_GENRE);
577 content_info->media_meta.track_num = __media_svc_get_tag_str_value(tag, MM_FILE_TAG_TRACK_NUM);
579 mmf_error = mm_file_get_attrs(tag, MM_FILE_TAG_RECDATE, &p, &size, NULL);
580 if ((mmf_error == FILEINFO_ERROR_NONE) && (size > 0)) {
581 if (g_str_has_suffix(content_info->mime_type, "mp4") || g_str_has_suffix(content_info->mime_type, "3gpp")) {
582 /*Creation time format is 20130101 00:00:00 +0000. change it to 2013:01:01 00:00:00 +0000 like exif time format*/
583 char *p_value = g_strdelimit(g_strdup(p), "-", ':');
584 content_info->media_meta.recorded_date = g_strdup_printf("%s +0000", p_value);
587 content_info->media_meta.recorded_date = g_strdup(p);
591 if (content_info->media_meta.recorded_date == NULL)
592 content_info->media_meta.recorded_date = g_strdup(MEDIA_SVC_TAG_UNKNOWN);
593 content_info->media_meta.datetaken = g_strdup(content_info->media_meta.recorded_date);
595 mmf_error = mm_file_get_attrs(tag, MM_FILE_TAG_DATE, &p, &size, NULL);
596 if (mmf_error == FILEINFO_ERROR_NONE && size == 4)
597 content_info->media_meta.year = g_strdup(p);
599 content_info->media_meta.year = g_strdup(MEDIA_SVC_TAG_UNKNOWN);
601 /*Do not extract artwork for the USB Storage content*/
602 if (support_albumart)
603 content_info->thumbnail_path = __media_svc_extract_albumart(tag, content_info->path, uid);
605 ret = _media_svc_get_album_id(handle, content_info->media_meta.album, content_info->media_meta.artist, &album_id);
606 if (ret == MS_MEDIA_ERR_DB_NO_RECORD) {
607 media_svc_debug("album does not exist. So start to make album art");
608 if (strlen(content_info->media_meta.album) > 0 && strlen(content_info->media_meta.artist) > 0)
609 ret = _media_svc_append_album(handle, is_direct, content_info->media_meta.album, content_info->media_meta.artist, content_info->thumbnail_path, &album_id, uid);
611 ret = _media_svc_append_album(handle, is_direct, content_info->media_meta.album, content_info->media_meta.artist, NULL, &album_id, uid);
613 content_info->album_id = album_id;
615 if (mm_file_destroy_tag_attrs(tag) != FILEINFO_ERROR_NONE)
616 media_svc_error("destroy failed");
619 void _media_svc_extract_video_metadata(media_svc_content_info_s *content_info)
621 int mmf_error = FILEINFO_ERROR_NONE;
622 MMHandleType tag = 0;
624 unsigned int size = 0;
626 mmf_error = mm_file_create_tag_attrs_no_albumart(&tag, content_info->path);
627 if (mmf_error == FILEINFO_ERROR_NONE) {
628 mmf_error = mm_file_get_attrs(tag, MM_FILE_TAG_RECDATE, &p, &size, NULL);
629 if ((mmf_error == FILEINFO_ERROR_NONE) && (size > 0)) {
630 if (g_str_has_suffix(content_info->mime_type, "mp4") || g_str_has_suffix(content_info->mime_type, "3gpp")) {
631 /*Creation time format is 20130101 00:00:00 +0000. change it to 2013:01:01 00:00:00 +0000 like exif time format*/
632 char *p_value = g_strdelimit(g_strdup(p), "-", ':');
633 content_info->media_meta.recorded_date = g_strdup_printf("%s +0000", p_value);
636 content_info->media_meta.recorded_date = g_strdup(p);
639 if (content_info->media_meta.recorded_date == NULL)
640 content_info->media_meta.recorded_date = g_strdup(MEDIA_SVC_TAG_UNKNOWN);
641 content_info->media_meta.datetaken = g_strdup(content_info->media_meta.recorded_date);
643 mmf_error = mm_file_destroy_tag_attrs(tag);
644 if (mmf_error != FILEINFO_ERROR_NONE)
645 media_svc_error("fail to free tag attr - err(%x)", mmf_error);
647 /* All metadata fields must be empty strings until media_video is deleted */
648 content_info->media_meta.title = __media_svc_get_title_from_filename(content_info->file_name);
649 content_info->media_meta.album = g_strdup(MEDIA_SVC_TAG_UNKNOWN);
650 content_info->media_meta.artist = g_strdup(MEDIA_SVC_TAG_UNKNOWN);
651 content_info->media_meta.album_artist = g_strdup(MEDIA_SVC_TAG_UNKNOWN);
652 content_info->media_meta.genre = g_strdup(MEDIA_SVC_TAG_UNKNOWN);
653 content_info->media_meta.track_num = g_strdup(MEDIA_SVC_TAG_UNKNOWN);
654 content_info->media_meta.year = g_strdup(MEDIA_SVC_TAG_UNKNOWN);
655 content_info->album_id = 0;
658 static gchar * __media_svc_get_zipfile_string(zip_t *z, const char *fname)
661 zip_int64_t index_num = 0;
662 zip_file_t *file = NULL;
663 zip_stat_t sb = {0, };
666 media_svc_retvm_if(!z, NULL, "z is NULL");
667 media_svc_retvm_if(!fname, NULL, "fname is NULL");
669 index_num = zip_name_locate(z, fname, ZIP_FL_NOCASE);
670 media_svc_retvm_if(index_num == -1, NULL, "fname is not exists [%s]", fname);
672 err = zip_stat_index(z, index_num, ZIP_STAT_SIZE, &sb);
673 media_svc_retvm_if(err == -1, NULL, "zip_stat_index failed");
675 file = zip_fopen_index(z, index_num, ZIP_FL_UNCHANGED);
676 media_svc_retvm_if(!file, NULL, "zip_fopen_index failed");
678 buf = g_malloc0(sb.size + 1);
680 err = zip_fread(file, buf, sb.size);
691 static xmlNodePtr __media_svc_find_node(xmlNodePtr node, const char *key)
693 xmlNodePtr tmp = NULL;
695 media_svc_retvm_if(!node, NULL, "node is NULL");
696 media_svc_retvm_if(!key, NULL, "key is NULL");
698 for (tmp = node->children; tmp; tmp = tmp->next) {
699 if (xmlIsBlankNode(tmp))
702 if (g_str_has_suffix((gchar *)tmp->name, key))
709 static char * __media_svc_remove_escape_c(const char *value)
715 media_svc_retv_if(!value, NULL);
719 for (i = 0; i < len; i++) {
720 if (value[i] != 10 && value[i] != 32) { // 10='\n' 32=' '
728 end = end - start + 1;
730 return g_strndup(value + start, end);
733 static char * __media_svc_find_and_get_value(xmlNodePtr node, const char *key)
735 xmlNodePtr tmp = NULL;
736 char *tmp_res = NULL;
739 media_svc_retvm_if(!node, NULL, "node is NULL");
740 media_svc_retvm_if(!key, NULL, "key is NULL");
742 for (tmp = node->children; tmp; tmp = tmp->next) {
743 if (xmlIsBlankNode(tmp))
747 tmp_res = __media_svc_find_and_get_value(tmp, key);
749 res = __media_svc_remove_escape_c(tmp_res);
755 if (g_str_has_suffix((gchar *)tmp->name, key))
756 return (char *)xmlNodeGetContent(tmp);
762 static gboolean __media_svc_get_epub_root_file(zip_t *z, char **opf_file)
765 gchar *tmp_buf = NULL;
766 xmlDocPtr doc = NULL;
767 xmlNodePtr node = NULL;
769 media_svc_retvm_if(!z, FALSE, "z is NULL");
770 media_svc_retvm_if(!opf_file, FALSE, "opf_file is NULL");
772 buf = __media_svc_get_zipfile_string(z, "META-INF/container.xml");
773 media_svc_retvm_if(!buf, FALSE, "buf is NULL");
775 tmp_buf = g_strrstr(buf, ">");
777 *(tmp_buf + 1) = '\0';
779 doc = xmlParseDoc((const xmlChar *)buf);
781 media_svc_retvm_if(!doc, FALSE, "doc is NULL");
783 node = xmlDocGetRootElement(doc);
784 node = __media_svc_find_node(node, "rootfiles");
785 node = __media_svc_find_node(node, "rootfile");
787 *opf_file = (char *)xmlGetProp(node, (const xmlChar *)"full-path");
788 media_svc_sec_debug("OPF [%s]", *opf_file);
794 static gboolean __media_svc_get_xml_metadata(const xmlChar *buffer, gboolean is_pdf, media_svc_content_info_s *content_info)
796 xmlDocPtr doc = NULL;
797 xmlNodePtr root = NULL;
799 media_svc_retvm_if(!buffer, FALSE, "buffer is NULL");
800 media_svc_retvm_if(!content_info, FALSE, "content_info is NULL");
802 doc = xmlParseDoc(buffer);
803 media_svc_retv_if(!doc, FALSE);
805 root = xmlDocGetRootElement(doc);
811 content_info->media_meta.title = __media_svc_find_and_get_value(root, "title");
812 /* In the case of PDF, if there is no title, it may not be a metadata block. Search for the next xml block*/
813 if (is_pdf && !content_info->media_meta.title) {
818 content_info->media_meta.artist = __media_svc_find_and_get_value(root, "creator");
819 if (!content_info->media_meta.artist)
820 content_info->media_meta.artist = __media_svc_find_and_get_value(root, "author");
821 content_info->media_meta.genre = __media_svc_find_and_get_value(root, "subject");
828 static int __media_svc_get_epub_metadata(media_svc_content_info_s *content_info)
833 char *opf_path = NULL;
835 media_svc_retvm_if(!content_info, MS_MEDIA_ERR_INVALID_PARAMETER, "content_info is NULL");
838 z = zip_open(content_info->path, ZIP_RDONLY, &err);
839 media_svc_retvm_if(err == -1, MS_MEDIA_ERR_INTERNAL, "zip_open failed");
841 //2. find and read opf file
842 if (!__media_svc_get_epub_root_file(z, &opf_path)) {
843 media_svc_error("__media_svc_get_epub_root_file failed");
845 return MS_MEDIA_ERR_INTERNAL;
849 buf = __media_svc_get_zipfile_string(z, opf_path);
852 media_svc_retvm_if(!buf, MS_MEDIA_ERR_INTERNAL, "__media_svc_get_zipfile_string failed");
854 if (!__media_svc_get_xml_metadata((const xmlChar *)buf, FALSE, content_info))
855 media_svc_error("__media_svc_get_xml_metadata failed");
859 return MS_MEDIA_ERR_NONE;
862 static int __media_svc_get_pdf_metadata(media_svc_content_info_s *content_info)
865 size_t start_pos = 0;
868 size_t search_limit = 0;
869 char tmp[MEDIA_SVC_PDF_BUF_SIZE + 1] = {0, };
870 gchar *meta_buf = NULL;
873 media_svc_retvm_if(!content_info, MS_MEDIA_ERR_INVALID_PARAMETER, "content_info is NULL");
874 media_svc_retvm_if(content_info->size < 256, MS_MEDIA_ERR_INTERNAL, "open failed");
876 fd = open(content_info->path, O_RDONLY);
877 media_svc_retvm_if(fd < 0, MS_MEDIA_ERR_INTERNAL, "open failed");
879 search_limit = content_info->size - MEDIA_SVC_PDF_TAG_TAIL_LEN;
881 while (cur_pos <= search_limit) {
882 if (lseek(fd, cur_pos, SEEK_SET) == -1)
885 memset(&tmp, 0x00, MEDIA_SVC_PDF_BUF_SIZE + 1);
887 if (read(fd, &tmp, MEDIA_SVC_PDF_BUF_SIZE) != MEDIA_SVC_PDF_BUF_SIZE) {
888 media_svc_error("read failed");
892 //1.Find <x:xmpmeta .. </x:xmpmeta> block
893 if (start_pos == 0 && (found = strstr(tmp, "<x:xmpmeta"))) {
894 start_pos = cur_pos + (found - tmp);
895 // media_svc_error("FIND START_POS[%d]", start_pos);
899 if (start_pos > 0 && (found = strstr(tmp + ((cur_pos > start_pos) ? 0 : (start_pos - cur_pos)), "</x:xmpmeta>"))) {
900 end_pos = cur_pos + (found - tmp) + MEDIA_SVC_PDF_TAG_TAIL_LEN;
901 // media_svc_error("FIND END_POS[%d]", end_pos);
905 //2.get metadata using xml parser
906 if (start_pos && end_pos) {
907 if (lseek(fd, start_pos, SEEK_SET) == -1)
910 meta_buf = g_malloc0(end_pos - start_pos + 1);
912 if (read(fd, meta_buf, end_pos - start_pos) == end_pos - start_pos) {
913 if (__media_svc_get_xml_metadata((const xmlChar *)meta_buf, TRUE, content_info)) {
931 return MS_MEDIA_ERR_NONE;
934 int _media_svc_extract_book_metadata(media_svc_content_info_s *content_info)
936 int ret = MS_MEDIA_ERR_NONE;
938 media_svc_retvm_if(!content_info, MS_MEDIA_ERR_INVALID_PARAMETER, "content info is NULL");
940 if (g_str_has_suffix(content_info->mime_type, "epub+zip"))
941 ret = __media_svc_get_epub_metadata(content_info);
943 ret = __media_svc_get_pdf_metadata(content_info);
945 media_svc_retvm_if(ret != MS_MEDIA_ERR_NONE, ret, "failed to extract metadata");
946 if (!content_info->media_meta.title || strlen(content_info->media_meta.title) == 0) {
947 g_free(content_info->media_meta.title);
948 content_info->media_meta.title = __media_svc_get_title_from_filename(content_info->file_name);
951 return MS_MEDIA_ERR_NONE;
954 void _media_svc_destroy_content_info(media_svc_content_info_s *content_info)
956 media_svc_retm_if(!content_info, "content info is NULL");
958 /* Delete media_svc_content_info_s */
959 g_free(content_info->media_uuid);
960 g_free(content_info->path);
961 g_free(content_info->file_name);
962 g_free(content_info->mime_type);
963 g_free(content_info->thumbnail_path);
964 g_free(content_info->storage_uuid);
966 /* Delete media_svc_content_meta_s */
967 g_free(content_info->media_meta.title);
968 g_free(content_info->media_meta.album);
969 g_free(content_info->media_meta.artist);
970 g_free(content_info->media_meta.album_artist);
971 g_free(content_info->media_meta.genre);
972 g_free(content_info->media_meta.year);
973 g_free(content_info->media_meta.recorded_date);
974 g_free(content_info->media_meta.track_num);
975 g_free(content_info->media_meta.datetaken);
978 int _media_svc_create_thumbnail(const char *path, char *thumb_path, media_svc_media_type_e media_type, uid_t uid)
980 int ret = MS_MEDIA_ERR_NONE;
982 media_svc_retvm_if(!path, MS_MEDIA_ERR_INVALID_PARAMETER, "Invalid path");
983 media_svc_retvm_if(!thumb_path, MS_MEDIA_ERR_INVALID_PARAMETER, "Invalid thumb_path");
984 media_svc_retvm_if(!g_file_test(path, G_FILE_TEST_IS_REGULAR), MS_MEDIA_ERR_INVALID_PARAMETER, "File doesn't exist[%s]", path);
986 if (!ms_user_thumb_support(uid, path)) {
987 media_svc_sec_error("origin path(%s) is invalid", path);
988 return MS_MEDIA_ERR_INVALID_PARAMETER;
991 media_svc_sec_debug("Path[%s] Type[%d]", path, media_type);
994 ret = __media_svc_get_thumbnail_path(thumb_path, path, NULL, uid);
995 media_svc_retvm_if(ret != MS_MEDIA_ERR_NONE, ret, "Failed to create thumbnail path[%d]", ret);
998 if (media_type == MEDIA_SVC_MEDIA_TYPE_IMAGE)
999 ret = create_image_thumbnail_to_file(path, MEDIA_SVC_THUMB_WIDTH, MEDIA_SVC_THUMB_HEIGHT, thumb_path, true);
1001 ret = create_video_thumbnail_to_file(path, MEDIA_SVC_THUMB_WIDTH, MEDIA_SVC_THUMB_HEIGHT, thumb_path, true);
1003 return (ret == THUMB_OK) ? MS_MEDIA_ERR_NONE : MS_MEDIA_ERR_INTERNAL;
1006 int _media_svc_get_media_type(const char *path, int *mediatype)
1008 int ret = MS_MEDIA_ERR_NONE;
1009 char mime_type[256] = {0};
1010 media_svc_media_type_e media_type = MEDIA_SVC_MEDIA_TYPE_OTHER;
1012 media_svc_retvm_if(mediatype == NULL, MS_MEDIA_ERR_INVALID_PARAMETER, "mediatype is NULL");
1014 ret = __media_svc_get_mime_type(path, mime_type);
1015 if (ret == MS_MEDIA_ERR_NONE)
1016 __media_svc_get_media_type(path, mime_type, &media_type);
1018 media_svc_error("__media_svc_get_mime_type failed");
1020 *mediatype = media_type;
1025 bool _media_svc_is_keyword_included(const char *path, const char *keyword)
1028 void *handle = NULL;
1029 bool (*svc_search) (const char *, const char *);
1031 media_svc_retvm_if(!path, false, "Invalid path");
1032 media_svc_retvm_if(!keyword, false, "Invalid keyword");
1034 handle = dlopen(PATH_PLUGIN_LIB, RTLD_LAZY);
1035 media_svc_retvm_if(!handle, false, "dlopen failed");
1037 if (g_str_has_suffix(path, "epub") || g_str_has_suffix(path, "EPUB"))
1038 svc_search = dlsym(handle, "media_svc_epub_is_keyword_included");
1040 svc_search = dlsym(handle, "media_svc_pdf_is_keyword_included");
1043 media_svc_error("dlsym failed - %s", dlerror());
1048 ret = svc_search(path, keyword);
1054 static int __media_svc_create_wordbook_db(const char *path, sqlite3 **handle)
1056 int ret = SQLITE_OK;
1057 sqlite3 *db_handle = NULL;
1060 ret = sqlite3_open_v2(path, &db_handle, SQLITE_OPEN_CREATE | SQLITE_OPEN_READWRITE, NULL);
1061 media_svc_retvm_if(ret != SQLITE_OK, ret, "sqlite3_open_v2 failed : %d", ret);
1063 ret = sqlite3_exec(db_handle, "PRAGMA journal_mode = OFF;", NULL, NULL, &err);
1064 if (ret != SQLITE_OK)
1067 ret = sqlite3_exec(db_handle, "CREATE TABLE IF NOT EXISTS files(id integer primary key autoincrement, path text unique, validity integer default 1);", NULL, NULL, &err);
1068 if (ret != SQLITE_OK)
1071 ret = sqlite3_exec(db_handle, "CREATE TABLE IF NOT EXISTS words(file_id integer, word text, frequency integer default 1, unique(file_id, word));", NULL, NULL, &err);
1072 if (ret != SQLITE_OK)
1075 ret = sqlite3_exec(db_handle, "CREATE TRIGGER IF NOT EXISTS TR_files_words DELETE ON files BEGIN DELETE FROM words WHERE file_id = old.id;END;", NULL, NULL, &err);
1076 if (ret != SQLITE_OK)
1079 *handle = db_handle;
1084 media_svc_error("sqlite3_exec failed : %s", err);
1085 SQLITE3_SAFE_FREE(err);
1086 sqlite3_close_v2(db_handle);
1091 static bool __media_svc_get_wordbook_handle(uid_t uid, sqlite3 **handle)
1093 int ret = SQLITE_OK;
1094 char *db_path = NULL;
1096 ms_user_get_wordbook_db_path(uid, &db_path);
1100 ret = sqlite3_open_v2(db_path, handle, SQLITE_OPEN_READWRITE, NULL);
1101 if (ret != SQLITE_OK) {
1102 ret = __media_svc_create_wordbook_db(db_path, handle);
1104 media_svc_retvm_if(ret != SQLITE_OK, false, "__media_svc_create_wordbook_db failed : %d", ret);
1106 ret = sqlite3_exec(*handle, "PRAGMA journal_mode = OFF;", NULL, NULL, NULL);
1107 if (ret != SQLITE_OK)
1108 media_svc_error("Failed to change journal mode [%d]", ret);
1114 static bool __media_svc_is_exist_in_wordbook(sqlite3 *db_handle, const char *path)
1116 int ret = SQLITE_OK;
1120 query = sqlite3_mprintf("UPDATE files SET validity=1 WHERE path = %Q", path);
1122 ret = sqlite3_exec(db_handle, query, NULL, NULL, &err);
1123 SQLITE3_SAFE_FREE(query);
1124 if (ret != SQLITE_OK) {
1125 media_svc_error("Query failed. [%s]", err);
1126 SQLITE3_SAFE_FREE(err);
1130 return sqlite3_changes(db_handle) > 0 ? true : false;
1133 static void __media_svc_insert_to_wordbook(sqlite3 *db_handle, const char *path)
1135 void *handle = NULL;
1136 void (*svc_update) (sqlite3 *, const char *);
1139 query = sqlite3_mprintf("INSERT INTO files(path) VALUES(%Q);", path);
1140 sqlite3_exec(db_handle, query, NULL, NULL, NULL);
1141 sqlite3_free(query);
1143 handle = dlopen(PATH_PLUGIN_LIB, RTLD_LAZY);
1145 media_svc_error("dlopen failed");
1149 if (g_str_has_suffix(path, "epub") || g_str_has_suffix(path, "EPUB"))
1150 svc_update = dlsym(handle, "media_svc_epub_insert_to_db");
1152 svc_update = dlsym(handle, "media_svc_pdf_insert_to_db");
1155 media_svc_error("dlsym failed - %s", dlerror());
1160 svc_update(db_handle, path);
1164 void _media_svc_update_wordbook(const char *path, uid_t uid)
1166 sqlite3 *db_handle = NULL;
1169 media_svc_error("Invalid path");
1174 if (!__media_svc_get_wordbook_handle(uid, &db_handle))
1177 if (__media_svc_is_exist_in_wordbook(db_handle, path)) {
1178 sqlite3_close_v2(db_handle);
1182 // if no item, insert to db..
1183 __media_svc_insert_to_wordbook(db_handle, path);
1184 sqlite3_close_v2(db_handle);
1187 void _media_svc_clean_wordbook(uid_t uid)
1189 sqlite3 *db_handle = NULL;
1191 if (!__media_svc_get_wordbook_handle(uid, &db_handle))
1194 sqlite3_exec(db_handle, "DELETE FROM files where validity = 0;", NULL, NULL, NULL);
1195 sqlite3_exec(db_handle, "UPDATE files SET validity = 0;", NULL, NULL, NULL);
1196 sqlite3_close_v2(db_handle);
1199 bool _media_svc_get_matched_list(const char *keyword, uid_t uid, GList **list)
1201 int ret = SQLITE_OK;
1202 sqlite3 *handle = NULL;
1203 sqlite3_stmt *stmt = NULL;
1206 media_svc_retvm_if(!list, false, "list is NULL");
1207 media_svc_retvm_if(!keyword, false, "keyword is NULL");
1208 media_svc_retvm_if(!__media_svc_get_wordbook_handle(uid, &handle), false, "Failed to get handle");
1210 query = sqlite3_mprintf("SELECT files.path FROM files JOIN (SELECT file_id, sum(frequency) AS freq_sum FROM words WHERE word LIKE '%q%%' GROUP BY file_id ORDER BY freq_sum DESC) w ON files.id = w.file_id;", keyword);
1211 ret = sqlite3_prepare_v2(handle, query, -1, &stmt, NULL);
1212 SQLITE3_SAFE_FREE(query);
1214 if (ret != SQLITE_OK) {
1215 media_svc_error("Query failed[%d]", ret);
1216 sqlite3_close_v2(handle);
1220 while (sqlite3_step(stmt) == SQLITE_ROW)
1221 *list = g_list_append(*list, g_strdup((char *)sqlite3_column_text(stmt, 0)));
1223 sqlite3_finalize(stmt);
1224 sqlite3_close_v2(handle);