X-Git-Url: http://review.tizen.org/git/?a=blobdiff_plain;f=src%2Finclude%2Fcommon%2Fmedia-svc-env.h;h=0ea36291aff9b33a40a66de0d2bea7a20a7aaca0;hb=9999ab8dec056a7325449cde40fbfc9ac98c5dc6;hp=669515751b064019cebfd3fdb9ac8afbb30d702c;hpb=0bafaa865e082013d6e31fbffdaf24a1a493d24e;p=platform%2Fcore%2Fmultimedia%2Flibmedia-service.git diff --git a/src/include/common/media-svc-env.h b/src/include/common/media-svc-env.h index 6695157..0ea3629 100755 --- a/src/include/common/media-svc-env.h +++ b/src/include/common/media-svc-env.h @@ -3,8 +3,6 @@ * * Copyright (c) 2000 - 2011 Samsung Electronics Co., Ltd. All rights reserved. * - * Contact: Hyunjun Ko , Haejeong Kim - * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at @@ -24,173 +22,104 @@ #ifndef _MEDIA_SVC_ENV_H_ #define _MEDIA_SVC_ENV_H_ -#include - #ifdef __cplusplus extern "C" { #endif /** - * DB information - */ - -#define LATEST_VERSION_NUMBER 8 - -/** - * Notice : New table user version -1 : alter table issue - */ -#define USER_V1 1 -#define USER_V2 2 -#define USER_V3 3 /** Tizen 2.3*/ -#define USER_V4 4 /** Tizen 2.4*/ -#define USER_V5 5 /** Tizen 3.0*/ -#define USER_V6 6 /** Tizen 4.0*/ -#define USER_V7 7 /** Tizen 5.0*/ -#define USER_V8 8 /** Tizen 5.5*/ - - -/** * DB table information */ /** * Table Name */ -#define MEDIA_SVC_DB_TABLE_MEDIA "media" /**< media table*/ -#define MEDIA_SVC_DB_TABLE_FOLDER "folder" /**< media_folder table*/ -#define MEDIA_SVC_DB_TABLE_PLAYLIST "playlist" /**< playlist table*/ -#define MEDIA_SVC_DB_TABLE_PLAYLIST_MAP "playlist_map" /**< playlist_map table*/ -#define MEDIA_SVC_DB_TABLE_ALBUM "album" /**< album table*/ -#define MEDIA_SVC_DB_TABLE_TAG "tag" /**< tag table*/ -#define MEDIA_SVC_DB_TABLE_TAG_MAP "tag_map" /**< tag_map table*/ -#define MEDIA_SVC_DB_TABLE_BOOKMARK "bookmark" /**< bookmark table*/ -#define MEDIA_SVC_DB_TABLE_STORAGE "storage" /**< storage table*/ -#define MEDIA_SVC_DB_TABLE_TMP_TABLE "tmp" /**< tmp table for backup*/ -#define MEDIA_SVC_DB_TABLE_FACE "face" /**< face table*/ -#define MEDIA_SVC_DB_TABLE_FACE_SCAN_LIST "face_scan_list" /**< face_scan_list table*/ +#define DB_TABLE_MEDIA "media" /**< media table*/ +#define DB_TABLE_FOLDER "folder" /**< media_folder table*/ +#define DB_TABLE_PLAYLIST "playlist" /**< playlist table*/ +#define DB_TABLE_PLAYLIST_MAP "playlist_map" /**< playlist_map table*/ +#define DB_TABLE_ALBUM "album" /**< album table*/ +#define DB_TABLE_TAG "tag" /**< tag table*/ +#define DB_TABLE_TAG_MAP "tag_map" /**< tag_map table*/ +#define DB_TABLE_BOOKMARK "bookmark" /**< bookmark table*/ +#define DB_TABLE_STORAGE "storage" /**< storage table*/ +#define DB_TABLE_FACE "face" /**< face table*/ +#define DB_TABLE_FACE_SCAN_LIST "face_scan_list" /**< face_scan_list table*/ /** * View Name */ -#define MEDIA_SVC_DB_VIEW_MEDIA "media_view" /**< media_view(For upgrade func) */ -#define MEDIA_SVC_DB_VIEW_PLAYLIST "playlist_view" /**< playlist_view*/ -#define MEDIA_SVC_DB_VIEW_TAG "tag_view" /**< tag_view*/ +#define DB_VIEW_PLAYLIST "playlist_view" /**< playlist_view*/ +#define DB_VIEW_TAG "tag_view" /**< tag_view*/ /** * Trigger Name */ -#define MEDIA_SVC_DB_TRIGGER_FOLDER "folder_cleanup" -#define MEDIA_SVC_DB_TRIGGER_PLAYLIST_MAP "playlist_map_cleanup" /**< media to map*/ -#define MEDIA_SVC_DB_TRIGGER_PLAYLIST_MAP1 "playlist_map_cleanup_1" /**< playlist to map*/ -#define MEDIA_SVC_DB_TRIGGER_ALBUM "album_cleanup" -#define MEDIA_SVC_DB_TRIGGER_TAG_MAP "tag_map_cleanup" /**< media to map*/ -#define MEDIA_SVC_DB_TRIGGER_TAG_MAP1 "tag_map_cleanup_1" /**< tag to map*/ -#define MEDIA_SVC_DB_TRIGGER_BOOKMARK "bookmark_cleanup" -#define MEDIA_SVC_DB_TRIGGER_STORAGE "storage_folder_cleanup" -#define MEDIA_SVC_DB_TRIGGER_FACE_SCAN_LIST "face_scan_list_cleanup" -#define MEDIA_SVC_DB_TRIGGER_FACE "face_cleanup" +#define DB_TRIGGER_PLAYLIST_MAP "playlist_map_cleanup" /**< media to map*/ +#define DB_TRIGGER_PLAYLIST_MAP1 "playlist_map_cleanup_1" /**< playlist to map*/ +#define DB_TRIGGER_ALBUM "album_cleanup" +#define DB_TRIGGER_TAG_MAP "tag_map_cleanup" /**< media to map*/ +#define DB_TRIGGER_TAG_MAP1 "tag_map_cleanup_1" /**< tag to map*/ +#define DB_TRIGGER_BOOKMARK "bookmark_cleanup" +#define DB_TRIGGER_FACE_SCAN_LIST "face_scan_list_cleanup" +#define DB_TRIGGER_FACE "face_cleanup" /** - * Trigger Name + * Column Name for view */ -#define MEDIA_SVC_DB_COLUMN_THUMBNAIL "thumbnail_path" -#define MEDIA_SVC_DB_COLUMN_MAP_ID "_id" +#define DB_COLUMN_THUMBNAIL "thumbnail_path" +#define DB_COLUMN_MAP_ID "_id" /** * option */ -#define MEDIA_SVC_DB_TYPE_TEXT "TEXT" -#define MEDIA_SVC_DB_TYPE_INT "INTEGER" -#define MEDIA_SVC_DB_TYPE_DOUBLE "DOUBLE" +#define DB_TYPE_TEXT "TEXT" +#define DB_TYPE_INT "INTEGER" +#define DB_TYPE_DOUBLE "DOUBLE" /** * Query form */ -#define MEDIA_SVC_DB_QUERY_TABLE_WITH_UNIQUE "CREATE TABLE IF NOT EXISTS '%s' (%s, unique(%s));" -#define MEDIA_SVC_DB_QUERY_TABLE "CREATE TABLE IF NOT EXISTS '%s' (%s);" -#define MEDIA_SVC_DB_QUERY_INDEX "CREATE INDEX IF NOT EXISTS %s on '%s' (%s);" -#define MEDIA_SVC_DB_QUERY_TRIGGER "CREATE TRIGGER IF NOT EXISTS '%s' DELETE ON '%s' BEGIN DELETE FROM %s WHERE %s=old.%s;END;" -#define MEDIA_SVC_DB_QUERY_TRIGGER_WITH_COUNT "CREATE TRIGGER IF NOT EXISTS '%s' DELETE ON '%s' BEGIN DELETE FROM %s WHERE (SELECT count(*) FROM '%s' WHERE %s=old.%s)=1 AND %s=old.%s;END;" -#define MEDIA_SVC_DB_QUERY_VIEW_PLAYLIST "CREATE VIEW IF NOT EXISTS %s AS SELECT %s FROM playlist \ +#define DB_QUERY_TABLE_WITH_UNIQUE "CREATE TABLE IF NOT EXISTS '%s' (%s, unique(%s));" +#define DB_QUERY_TABLE "CREATE TABLE IF NOT EXISTS '%s' (%s);" +#define DB_QUERY_TRIGGER "CREATE TRIGGER IF NOT EXISTS '%s' DELETE ON '%s' BEGIN DELETE FROM %s WHERE %s=old.%s;END;" +#define DB_QUERY_TRIGGER_WITH_COUNT "CREATE TRIGGER IF NOT EXISTS '%s' DELETE ON '%s' BEGIN DELETE FROM %s WHERE (SELECT count(*) FROM '%s' WHERE %s=old.%s)=1 AND %s=old.%s;END;" +#define DB_QUERY_VIEW_PLAYLIST "CREATE VIEW IF NOT EXISTS %s AS SELECT %s FROM playlist \ LEFT OUTER JOIN playlist_map ON playlist.playlist_id = playlist_map.playlist_id \ LEFT OUTER JOIN media ON (playlist_map.media_id = media.media_id AND media.validity=1) \ LEFT OUTER JOIN (SELECT count(playlist_id) as playlist_media_count, playlist_id FROM playlist_map group by playlist_id) as cnt_tbl ON (cnt_tbl.playlist_id=playlist_map.playlist_id AND media.validity=1);" -#define MEDIA_SVC_DB_QUERY_VIEW_TAG "CREATE VIEW IF NOT EXISTS %s AS SELECT %s FROM tag \ +#define DB_QUERY_VIEW_TAG "CREATE VIEW IF NOT EXISTS %s AS SELECT %s FROM tag \ LEFT OUTER JOIN tag_map ON tag.tag_id=tag_map.tag_id \ LEFT OUTER JOIN media ON (tag_map.media_id = media.media_id AND media.validity=1) \ LEFT OUTER JOIN (SELECT count(tag_id) as tag_media_count, tag_id FROM tag_map group by tag_id) as cnt_tbl ON (cnt_tbl.tag_id=tag_map.tag_id AND media.validity=1);" -#define MEDIA_SVC_DB_QUERY_ALTER_TABLE "ALTER TABLE %s ADD COLUMN %s;" - -#define MEDIA_SVC_METADATA_LEN_MAX 512 /**< Length of metadata*/ -#define MEDIA_SVC_PATHNAME_SIZE 4096 /**< Length of Path name. */ -#define MEDIA_SVC_UUID_SIZE 36 /**< Length of UUID*/ -#define MEDIA_SVC_QUERY_LEN_MAX 4096*2 /**< Max Query length*/ -#define MEDIA_SVC_QUERY_LEN_NORMAL 4096 /**< Normal Query length*/ +#define MEDIA_SVC_METADATA_LEN_MAX 512 /**< Length of metadata*/ +#define MEDIA_SVC_PATHNAME_SIZE 4096 /**< Length of Path name. */ +#define MEDIA_SVC_UUID_SIZE 36 /**< Length of UUID*/ -#define MEDIA_SVC_TAG_UNKNOWN "" - -#define THUMB_EXT "jpg" -#define THUMB_MAX_ALLOWED_MEM 9000000 -#define THUMB_WIDTH 320 -#define THUMB_HEIGHT 240 - -enum Exif_Orientation { - NOT_AVAILABLE = 0, - NORMAL = 1, - HFLIP = 2, - ROT_180 = 3, - VFLIP = 4, - TRANSPOSE = 5, - ROT_90 = 6, - TRANSVERSE = 7, - ROT_270 = 8 -}; +#define MEDIA_SVC_TAG_UNKNOWN "" typedef enum { - MEDIA_SVC_QUERY_INSERT_ITEM, - MEDIA_SVC_QUERY_SET_ITEM_VALIDITY, - MEDIA_SVC_QUERY_MOVE_ITEM, - MEDIA_SVC_QUERY_UPDATE_ITEM, + MEDIA_SVC_QUERY_SCANNER, MEDIA_SVC_QUERY_UPDATE_COMMON, } media_svc_query_type_e; typedef enum { - MEDIA_SVC_DB_LIST_MEDIA = 0, - MEDIA_SVC_DB_LIST_FOLDER, - MEDIA_SVC_DB_LIST_PLAYLIST_MAP, - MEDIA_SVC_DB_LIST_PLAYLIST, - MEDIA_SVC_DB_LIST_ALBUM, - MEDIA_SVC_DB_LIST_TAG_MAP, - MEDIA_SVC_DB_LIST_TAG, - MEDIA_SVC_DB_LIST_BOOKMARK, - MEDIA_SVC_DB_LIST_STORAGE, - MEDIA_SVC_DB_LIST_FACE_SCAN_LIST, - MEDIA_SVC_DB_LIST_FACE, - MEDIA_SVC_DB_LIST_MAX, + DB_LIST_MEDIA = 0, + DB_LIST_FOLDER, + DB_LIST_PLAYLIST_MAP, + DB_LIST_PLAYLIST, + DB_LIST_ALBUM, + DB_LIST_TAG_MAP, + DB_LIST_TAG, + DB_LIST_BOOKMARK, + DB_LIST_STORAGE, + DB_LIST_FACE_SCAN_LIST, + DB_LIST_FACE, + DB_LIST_MAX, } media_svc_table_slist_e; -typedef struct { - char *trigger_name; - char *view_name; - char *event_table; - char *action_table; -} table_info_s; - -typedef struct { - char *name; - char *type; - char *option; - int version; - char *index_name; - bool is_unique; - bool is_trigger; - bool is_view; -} column_info_s; - - #ifdef __cplusplus } #endif