src/include/common/media-svc-env.h

   1 /*
   2  * libmedia-service
   3  *
   4  * Copyright (c) 2000 - 2011 Samsung Electronics Co., Ltd. All rights reserved.
   5  *
   6  * Contact: Hyunjun Ko <zzoon.ko@samsung.com>, Haejeong Kim <backto.kim@samsung.com>
   7  *
   8  * Licensed under the Apache License, Version 2.0 (the "License");
   9  * you may not use this file except in compliance with the License.
  10  * You may obtain a copy of the License at
  11  *
  12  * http://www.apache.org/licenses/LICENSE-2.0
  13  *
  14  * Unless required by applicable law or agreed to in writing, software
  15  * distributed under the License is distributed on an "AS IS" BASIS,
  16  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  17  * See the License for the specific language governing permissions and
  18  * limitations under the License.
  19  *
  20  */
  21
  22
  23
  24 #ifndef _MEDIA_SVC_ENV_H_
  25 #define _MEDIA_SVC_ENV_H_
  26
  27 #include <time.h>
  28 #include <media-util.h>
  29 #include <tzplatform_config.h>
  30
  31 #ifdef __cplusplus
  32 extern "C" {
  33 #endif
  34
  35 /**
  36  * DB information
  37  */
  38
  39 #define LATEST_VERSION_NUMBER                                   6
  40
  41 /**
  42  * Notice : New table user version -1 : alter table issue
  43  */
  44 #define USER_V1                                                                 1
  45 #define USER_V2                                                                 2
  46 #define USER_V3                                                                 3
  47 #define USER_V4                                                                 4
  48 #define USER_V5                                                                 5
  49 #define USER_V6                                                                 6
  50
  51
  52 /**
  53  * DB table information
  54  */
  55
  56 /**
  57  * Table Name
  58  */
  59 #define MEDIA_SVC_DB_TABLE_MEDIA                                "media"                         /**< media table*/
  60 #define MEDIA_SVC_DB_TABLE_FOLDER                               "folder"                        /**< media_folder table*/
  61 #define MEDIA_SVC_DB_TABLE_PLAYLIST                             "playlist"                      /**< playlist table*/
  62 #define MEDIA_SVC_DB_TABLE_PLAYLIST_MAP                 "playlist_map"          /**< playlist_map table*/
  63 #define MEDIA_SVC_DB_TABLE_ALBUM                                "album"                         /**< album table*/
  64 #define MEDIA_SVC_DB_TABLE_TAG                                  "tag"                           /**< tag table*/
  65 #define MEDIA_SVC_DB_TABLE_TAG_MAP                              "tag_map"                       /**< tag_map table*/
  66 #define MEDIA_SVC_DB_TABLE_BOOKMARK                             "bookmark"                      /**< bookmark table*/
  67 #define MEDIA_SVC_DB_TABLE_STORAGE                              "storage"                       /**< storage table*/
  68 #define MEDIA_SVC_DB_TABLE_TMP_TABLE                            "tmp"                   /**< tmp table for backup*/
  69 #define MEDIA_SVC_DB_TABLE_FACE                                 "face"                  /**< face table*/
  70 #define MEDIA_SVC_DB_TABLE_FACE_SCAN_LIST                       "face_scan_list"        /**< face_scan_list table*/
  71 #define MEDIA_SVC_DB_TABLE_UHD                                  "uhd"                           /**<  uhd table*/
  72 #define MEDIA_SVC_DB_TABLE_PVR                                  "pvr"                           /**<  pvr table*/
  73
  74 /**
  75  * View Name
  76  */
  77 #define MEDIA_SVC_DB_VIEW_MEDIA                                 "media_view"            /**< media_view*/
  78 #define MEDIA_SVC_DB_VIEW_PLAYLIST                              "playlist_view"         /**< playlist_view*/
  79 #define MEDIA_SVC_DB_VIEW_TAG                                   "tag_view"              /**< tag_view*/
  80
  81 /**
  82  * Trigger Name
  83  */
  84 #define MEDIA_SVC_DB_TRIGGER_FOLDER                             "folder_cleanup"
  85 #define MEDIA_SVC_DB_TRIGGER_PLAYLIST_MAP                       "playlist_map_cleanup"          /**< media to map*/
  86 #define MEDIA_SVC_DB_TRIGGER_PLAYLIST_MAP1                      "playlist_map_cleanup_1"        /**< playlist to map*/
  87 #define MEDIA_SVC_DB_TRIGGER_ALBUM                              "album_cleanup"
  88 #define MEDIA_SVC_DB_TRIGGER_TAG_MAP                    "tag_map_cleanup"               /**< media to map*/
  89 #define MEDIA_SVC_DB_TRIGGER_TAG_MAP1                   "tag_map_cleanup_1"             /**< tag to map*/
  90 #define MEDIA_SVC_DB_TRIGGER_BOOKMARK                   "bookmark_cleanup"
  91 #define MEDIA_SVC_DB_TRIGGER_STORAGE                    "storage_folder_cleanup"
  92 #define MEDIA_SVC_DB_TRIGGER_FACE_SCAN_LIST     "face_scan_list_cleanup"
  93 #define MEDIA_SVC_DB_TRIGGER_FACE                               "face_cleanup"
  94 #define MEDIA_SVC_DB_TRIGGER_PVR                            "pvr_item_cleanup"
  95 #define MEDIA_SVC_DB_TRIGGER_UHD                            "uhd_item_cleanup"
  96
  97 /**
  98  * Trigger Name
  99  */
 100 #define MEDIA_SVC_DB_COLUMN_THUMBNAIL                   "thumbnail_path"
 101 #define MEDIA_SVC_DB_COLUMN_MAP_ID                              "_id"
 102
 103
 104 /**
 105  * option
 106  */
 107 #define MEDIA_SVC_DB_TYPE_TEXT                                  "TEXT"
 108 #define MEDIA_SVC_DB_TYPE_INT                                   "INTEGER"
 109 #define MEDIA_SVC_DB_TYPE_DOUBLE                                "DOUBLE"
 110
 111 /**
 112  * Query form
 113  */
 114 #define MEDIA_SVC_DB_QUERY_TABLE_WITH_UNIQUE    "CREATE TABLE IF NOT EXISTS '%s' (%s, unique(%s));"
 115 #define MEDIA_SVC_DB_QUERY_TABLE                                "CREATE TABLE IF NOT EXISTS '%s' (%s);"
 116 #define MEDIA_SVC_DB_QUERY_INDEX                                "CREATE INDEX IF NOT EXISTS %s on '%s' (%s);"
 117 #define MEDIA_SVC_DB_QUERY_TRIGGER                              "CREATE TRIGGER IF NOT EXISTS '%s' DELETE ON '%s' BEGIN DELETE FROM %s WHERE %s=old.%s;END;"
 118 #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;"
 119 #define MEDIA_SVC_DB_QUERY_VIEW_MEDIA                   "CREATE VIEW IF NOT EXISTS %s AS SELECT * from %s;"
 120 #define MEDIA_SVC_DB_QUERY_VIEW_PLAYLIST                "CREATE VIEW IF NOT EXISTS %s AS SELECT %s FROM playlist \
 121                                                                                                 LEFT OUTER JOIN playlist_map ON playlist.playlist_id = playlist_map.playlist_id \
 122                                                                                                 LEFT OUTER JOIN media ON (playlist_map.media_uuid = media.media_uuid AND media.validity=1) \
 123                                                                                                 LEFT OUTER JOIN (SELECT count(playlist_id) as 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);"
 124 #define MEDIA_SVC_DB_QUERY_VIEW_TAG                             "CREATE VIEW IF NOT EXISTS %s AS SELECT %s FROM tag \
 125                                                                                                 LEFT OUTER JOIN tag_map ON tag.tag_id=tag_map.tag_id \
 126                                                                                                 LEFT OUTER JOIN media ON (tag_map.media_uuid = media.media_uuid AND media.validity=1) \
 127                                                                                                 LEFT OUTER JOIN (SELECT count(tag_id) as 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);"
 128 #define MEDIA_SVC_DB_QUERY_ALTER_TABLE                  "ALTER TABLE %s ADD COLUMN %s;"
 129 #define MEDIA_SVC_DB_QUERY_DROP_VIEW                    "DROP VIEW IF EXISTS %s;"
 130
 131
 132
 133 #define MEDIA_SVC_METADATA_LEN_MAX                      128                                             /**< Length of metadata*/
 134 #define MEDIA_SVC_METADATA_DESCRIPTION_MAX      512                                             /**< Length of description*/
 135 #define MEDIA_SVC_PATHNAME_SIZE                         4096                                    /**< Length of Path name. */
 136 #define MEDIA_SVC_UUID_SIZE                                             36                                              /**< Length of UUID*/
 137 #define MEDIA_SVC_QUERY_LEN_MAX                         4096*2                                  /**< Max Query length*/
 138
 139 #define MEDIA_SVC_TAG_UNKNOWN                           ""
 140 #define MEDIA_SVC_MEDIA_PATH                                    tzplatform_mkpath(TZ_USER_SHARE, "media")                       /**< Media path*/
 141 #define MEDIA_SVC_THUMB_PATH_PREFIX                     tzplatform_mkpath(TZ_USER_SHARE, "media/.thumb")                        /**< Thumbnail path prefix*/
 142 #define MEDIA_SVC_THUMB_INTERNAL_PATH           tzplatform_mkpath(TZ_USER_SHARE, "media/.thumb/phone")  /**< Phone thumbnail path*/
 143 #define MEDIA_SVC_THUMB_EXTERNAL_PATH           tzplatform_mkpath(TZ_USER_SHARE, "media/.thumb/mmc")            /**< MMC thumbnail path*/
 144 #define MEDIA_SVC_THUMB_DEFAULT_PATH            tzplatform_mkpath(TZ_USER_SHARE, "media/.thumb/thumb_default.png") /**< default thumbnail */
 145
 146 #define THUMB_EXT               "jpg"
 147
 148 enum Exif_Orientation {
 149         NOT_AVAILABLE = 0,
 150         NORMAL = 1,
 151         HFLIP = 2,
 152         ROT_180 = 3,
 153         VFLIP = 4,
 154         TRANSPOSE = 5,
 155         ROT_90 = 6,
 156         TRANSVERSE = 7,
 157         ROT_270 = 8
 158 };
 159
 160 typedef enum {
 161         MEDIA_SVC_QUERY_INSERT_ITEM,
 162         MEDIA_SVC_QUERY_SET_ITEM_VALIDITY,
 163         MEDIA_SVC_QUERY_MOVE_ITEM,
 164         MEDIA_SVC_QUERY_UPDATE_ITEM,
 165         MEDIA_SVC_QUERY_INSERT_FOLDER,
 166         MEDIA_SVC_QUERY_UPDATE_COMMON,
 167 } media_svc_query_type_e;
 168
 169 typedef enum {
 170         MEDIA_SVC_DB_LIST_MEDIA = 0,
 171         MEDIA_SVC_DB_LIST_FOLDER,
 172         MEDIA_SVC_DB_LIST_PLAYLIST_MAP,
 173         MEDIA_SVC_DB_LIST_PLAYLIST,
 174         MEDIA_SVC_DB_LIST_ALBUM,
 175         MEDIA_SVC_DB_LIST_TAG_MAP,
 176         MEDIA_SVC_DB_LIST_TAG,
 177         MEDIA_SVC_DB_LIST_BOOKMARK,
 178         MEDIA_SVC_DB_LIST_STORAGE,
 179         MEDIA_SVC_DB_LIST_UHD,
 180         MEDIA_SVC_DB_LIST_PVR,
 181         MEDIA_SVC_DB_LIST_FACE_SCAN_LIST,
 182         MEDIA_SVC_DB_LIST_FACE,
 183         MEDIA_SVC_DB_LIST_MAX,
 184 } media_svc_table_slist_e;
 185
 186 typedef struct {
 187         char *trigger_name;
 188         char *view_name;
 189         char *event_table;
 190         char *action_table;
 191 } table_info_s;
 192
 193 typedef struct {
 194         char *name;
 195         char *type;
 196         bool has_option;
 197         char *option;
 198         int version;
 199         bool is_index;
 200         char *index_name;
 201         bool is_unique;
 202         bool is_trigger;
 203         bool is_view;
 204 } column_info_s;
 205
 206
 207 #ifdef __cplusplus
 208 }
 209 #endif
 210
 211 #endif /*_MEDIA_SVC_ENV_H_*/