xref: /ohos5.0/foundation/multimedia/media_library/frameworks/services/media_backup_extension/include/backup_const.h

/*
 * Copyright (C) 2023-2025 Huawei Device Co., Ltd.
 * 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
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

#ifndef OHOS_MEDIA_BACKUP_DEFINES_H
#define OHOS_MEDIA_BACKUP_DEFINES_H

#include <string>
#include <unordered_set>
#include <variant>
#include <vector>
#include <optional>

#include "photo_album_column.h"
#include "photo_map_column.h"
#include "vision_column.h"

namespace OHOS {
namespace Media {
constexpr int32_t QUERY_COUNT = 200;
constexpr int32_t PRE_CLONE_PHOTO_BATCH_COUNT = 100;
constexpr int32_t CONNECT_SIZE = 10;
constexpr int32_t MILLISECONDS = 1000;
constexpr int32_t GALLERY_HIDDEN_ID = -4;
constexpr int32_t GALLERY_TRASHED_ID = 0;
constexpr int32_t UPGRADE_RESTORE_ID = 0;
constexpr int32_t DUAL_FRAME_CLONE_RESTORE_ID = 1;
constexpr int32_t CLONE_RESTORE_ID = 2;
constexpr int32_t I_PHONE_CLONE_RESTORE = 3;
constexpr int32_t OTHERS_PHONE_CLONE_RESTORE = 4;
constexpr int32_t DEFAULT_RESTORE_ID = -1;
constexpr int32_t RETRY_TIME = 5;
constexpr int32_t SLEEP_INTERVAL = 1;
constexpr int32_t GARBAGE_PHOTO_SIZE = 2048;
constexpr int32_t LIVE_PHOTO_TYPE = 50;
constexpr int32_t LIVE_PHOTO_HDR_TYPE = 1050;
constexpr size_t GARBLE_UNIT = 2;
constexpr uint32_t COVER_URI_NUM = 3;
constexpr int32_t EXTERNAL_DB_NOT_EXIST = -3;
constexpr uint32_t UNIQUE_NUMBER_NUM = 3;
constexpr uint32_t THUMBNAIL_NUM = 500;
constexpr size_t MAX_FAILED_FILES_LIMIT = 100;
constexpr int64_t TAR_FILE_LIMIT = 2 * 1024 * 1024;
constexpr int32_t MAX_THREAD_NUM = 4;

const std::string RESTORE_FILES_CLOUD_DIR = "/storage/cloud/files/";
const std::string RESTORE_FILES_LOCAL_DIR = "/storage/media/local/files/";
const std::string RESTORE_CLOUD_DIR = "/storage/cloud/files/Photo";
const std::string RESTORE_AUDIO_CLOUD_DIR = "/storage/cloud/files/Audio";
const std::string RESTORE_LOCAL_DIR = "/storage/media/local/files/Photo";
const std::string RESTORE_AUDIO_LOCAL_DIR = "/storage/media/local/files/Audio";
const std::string RESTORE_MUSIC_LOCAL_DIR = "/storage/media/local/files/Docs/Music/";
const std::string UPGRADE_FILE_DIR = "/storage/media/local/files/data";
const std::string GARBLE_DUAL_FRAME_CLONE_DIR = "/storage/media/local/files/data/storage/emulated";
const std::string OTHER_CLONE_PATH = "/storage/media/local/files/.backup/restore/";
const std::string GARBLE = "***";
const std::string GALLERT_IMPORT = "/Pictures/cloud/Imports";
const std::string GALLERT_HIDDEN_ALBUM = "/Pictures/hiddenAlbum";
const std::string GALLERT_ROOT_PATH = "/storage/emulated/";
const std::string RESTORE_FAILED_FILES_PATH = "/storage/media/local/files/Docs/Documents/restore_failed_files";
const std::string PHOTO_FILTER_SELECTED_SIZE = "filter_selected_size";
const std::string RESTORE_SANDBOX_DIR = "/data/storage/el2/base/.backup/restore";

// DB field for update scene
const std::string GALLERY_ID = "_id";
const std::string GALLERY_LOCAL_MEDIA_ID = "local_media_id";
const std::string GALLERY_FILE_DATA = "_data";
const std::string GALLERY_TITLE = "title";
const std::string GALLERY_DISPLAY_NAME = "_display_name";
const std::string GALLERY_DESCRIPTION = "description";
const std::string GALLERY_IS_FAVORITE = "is_hw_favorite";
const std::string GALLERY_IS_BURST = "is_hw_burst";
const std::string GALLERY_RECYCLED_TIME = "recycledTime";
const std::string GALLERY_FILE_SIZE = "_size";
const std::string GALLERY_DURATION = "duration";
const std::string GALLERY_MEDIA_TYPE = "media_type";
const std::string GALLERY_SHOW_DATE_TOKEN = "showDateToken";
const std::string GALLERY_HEIGHT = "height";
const std::string GALLERY_WIDTH = "width";
const std::string GALLERY_ORIENTATION = "orientation";
const std::string GALLERY_MEDIA_BUCKET_ID = "relative_bucket_id";
const std::string GALLERY_MEDIA_SOURCE_PATH = "sourcePath";
const std::string GALLERY_RECYCLE_FLAG = "recycleFlag";
const std::string GALLERY_HASH = "hash";
const std::string GALLERY_SPECIAL_FILE_TYPE = "special_file_type";
const std::string GALLERY_FIRST_UPDATE_TIME = "first_update_time";
const std::string GALLERY_DATE_TAKEN = "datetaken";
const std::string GALLERY_DETAIL_TIME = "detail_time";

// external column
const std::string EXTERNAL_IS_FAVORITE = "is_favorite";
const std::string EXTERNAL_DATE_MODIFIED = "date_modified";
const std::string EXTERNAL_DATE_ADDED = "date_added";
const std::string EXTERNAL_FILE_DATA = "_data";
const std::string EXTERNAL_TITLE = "title";
const std::string EXTERNAL_DISPLAY_NAME = "_display_name";
const std::string EXTERNAL_FILE_SIZE = "_size";
const std::string EXTERNAL_DURATION = "duration";
const std::string EXTERNAL_MEDIA_TYPE = "media_type";
const std::string EXTERNAL_DATE_TAKEN = "datetaken";

// custom column
const std::string CUSTOM_COUNT = "count";
const std::string UNIQUE_NUMBER = "unique_number";
const std::string CUSTOM_MAX_ID = "max_id";
const std::string PRAGMA_TABLE_NAME = "name";
const std::string PRAGMA_TABLE_TYPE = "type";

// audio column
const std::string AUDIO_DATA = "_data";
const std::string AUDIO_DATE_MODIFIED = "date_modified";
const std::string AUDIO_DATE_TAKEN = "datetaken";

// statistics
const int32_t STAT_DEFAULT_ERROR_CODE_SUCCESS = 0;
const int32_t STAT_DEFAULT_ERROR_CODE_FAILED = 13500099;
const std::string STAT_KEY_RESULT_INFO = "resultInfo";
const std::string STAT_KEY_TYPE = "type";
const std::string STAT_KEY_ERROR_CODE = "errorCode";
const std::string STAT_KEY_ERROR_INFO = "errorInfo";
const std::string STAT_KEY_INFOS = "infos";
const std::string STAT_KEY_BACKUP_INFO = "backupInfo";
const std::string STAT_KEY_SUCCESS_COUNT = "successCount";
const std::string STAT_KEY_DUPLICATE_COUNT = "duplicateCount";
const std::string STAT_KEY_FAILED_COUNT = "failedCount";
const std::string STAT_KEY_DETAILS = "details";
const std::string STAT_KEY_NUMBER = "number";
const std::string STAT_KEY_PROGRESS_INFO = "progressInfo";
const std::string STAT_KEY_NAME = "name";
const std::string STAT_KEY_PROCESSED = "processed";
const std::string STAT_KEY_TOTAL = "total";
const std::string STAT_KEY_IS_PERCENTAGE = "isPercentage";
const std::string STAT_VALUE_ERROR_INFO = "ErrorInfo";
const std::string STAT_VALUE_COUNT_INFO = "CountInfo";
const std::string STAT_TYPE_PHOTO = "photo";
const std::string STAT_TYPE_VIDEO = "video";
const std::string STAT_TYPE_AUDIO = "audio";
const std::string STAT_TYPE_PHOTO_VIDEO = "photo&video";
const std::string STAT_TYPE_UPDATE = "update";
const std::string STAT_TYPE_OTHER = "other";
const std::string STAT_TYPE_ONGOING = "ongoing";
const std::vector<std::string> STAT_TYPES = { STAT_TYPE_PHOTO, STAT_TYPE_VIDEO, STAT_TYPE_AUDIO };
const std::vector<std::string> STAT_PROGRESS_TYPES = { STAT_TYPE_PHOTO_VIDEO, STAT_TYPE_AUDIO, STAT_TYPE_UPDATE,
    STAT_TYPE_OTHER, STAT_TYPE_ONGOING };

const std::string GALLERY_DB_NAME = "gallery.db";
const std::string EXTERNAL_DB_NAME = "external.db";
const std::string AUDIO_DB_NAME = "audio_MediaInfo.db";
const std::string PHOTO_SD_DB_NAME = "photo_sd_Cache.db";
const std::string VIDEO_SD_DB_NAME = "video_sd_Cache.db";

const std::string GALLERY_ALBUM = "gallery_album";
const std::string GALLERY_ALBUM_NAME = "albumName";
const std::string GALLERY_ALBUM_BUCKETID = "relativeBucketId";
const std::string GALLERY_ALBUM_IPATH = "lPath";
const std::string GALLERY_NICK_NAME = "nick_name";

/**
 * If the value of thumbnail_ready is greater than or equal to 3, the THM is generated successfully.
 * If the value of thumbnail_ready is greater than 0, the value of thumbnail_visible is 1, indicating
 * that the THM has been generated(not necessarily successfully generated).
 * If lcd_visit_time is 2, the LCD is generated successfully.
 * If lcd_visit_time is 0, the LCD is not generated or fails to be generated.
*/
const int RESTORE_THUMBNAIL_READY_SUCCESS = 3;
const int RESTORE_THUMBNAIL_READY_NO_THUMBNAIL = 0;
const int RESTORE_THUMBNAIL_VISIBLE_FALSE = 0;
const int RESTORE_THUMBNAIL_VISIBLE_TRUE = 1;
const int RESTORE_LCD_VISIT_TIME_SUCCESS = 2;
const int RESTORE_LCD_VISIT_TIME_NO_LCD = 0;

const std::string MEDIA_KVSTORE_MONTH_STOREID = "medialibrary_month_astc_data";
const std::string MEDIA_KVSTORE_YEAR_STOREID = "medialibrary_year_astc_data";
const std::string CLONE_KVSTORE_MONTH_STOREID = "medialibrary_month_astc_data_clone";
const std::string CLONE_KVSTORE_YEAR_STOREID = "medialibrary_year_astc_data_clone";
const std::string MEDIA_KVDB_DIR = "/data/storage/el2/database";
const std::string CLONE_KVDB_BACKUP_DIR = "/storage/media/local/files/.backup/backup/media_temp_kvdb";

const std::string FILE_SEPARATOR = "/";

constexpr int32_t INDEX_TYPE = 0;
constexpr int32_t INDEX_CACHE_DIR = 1;
constexpr int32_t INDEX_NICK_DIR = 2;
constexpr int32_t INDEX_NICK_NAME = 3;

constexpr int32_t NICK = 0;
constexpr int32_t CACHE = 1;

constexpr int32_t DEFAULT_AREA_VERSION = -1;

enum SourceType {
    GALLERY = 0,
    EXTERNAL_CAMERA,
    EXTERNAL_OTHERS,
    PHOTOS,
    AUDIOS,
};

enum class PrefixType {
    CLOUD = 0,
    LOCAL,
    CLOUD_EDIT_DATA,
    LOCAL_EDIT_DATA,
};

enum DUAL_MEDIA_TYPE {
    IMAGE_TYPE = 1,
    AUDIO_TYPE,
    VIDEO_TYPE,
};

enum RestoreError {
    SUCCESS = 0,
    INIT_FAILED,
    FILE_INVALID,
    PATH_INVALID,
    GET_PATH_FAILED,
    INSERT_FAILED,
    MOVE_FAILED,
    MEDIA_TYPE_INVALID,
    DUPLICATE_DATA,
    SIZE_INVALID,
    MOVING_PHOTO_CONVERT_FAILED,
    CREATE_PATH_FAILED,
    PREPARE_PATH_FAILED,
    GALLERY_DATABASE_CORRUPTION,
    UPDATE_PHOTOS_FAILED,
};

enum class PhotoRelatedType {
    PHOTO_MAP = 0,
    PORTRAIT,
};

enum ProcessStatus {
    STOP = 0,
    START,
};

const std::unordered_map<int32_t, std::string> RESTORE_ERROR_MAP = {
    { RestoreError::INIT_FAILED, "RESTORE_INIT_FAILED" },
    { RestoreError::FILE_INVALID, "DEVICE_FILE_INVALID" },
    { RestoreError::PATH_INVALID, "DEVICE_PATH_INVALID" },
    { RestoreError::GET_PATH_FAILED, "RESTORE_GET_PATH_FAILED" },
    { RestoreError::INSERT_FAILED, "RESTORE_INSERT_FAILED" },
    { RestoreError::MOVE_FAILED, "RESTORE_MOVE_FAILED" },
    { RestoreError::MEDIA_TYPE_INVALID, "DEVICE_MEDIA_TYPE_INVALID" },
    { RestoreError::DUPLICATE_DATA, "DEVICE_DUPLICATE_DATA" },
    { RestoreError::SIZE_INVALID, "DEVICE_SIZE_INVALID" },
    { RestoreError::MOVING_PHOTO_CONVERT_FAILED, "DEVICE_MOVING_PHOTO_CONVERT_FAILED" },
    { RestoreError::CREATE_PATH_FAILED, "RESTORE_CREATE_PATH_FAILED" },
    { RestoreError::PREPARE_PATH_FAILED, "RESTORE_PREPARE_PATH_FAILED" },
    { RestoreError::GALLERY_DATABASE_CORRUPTION, "RESTORE_GALLERY_DATABASE_CORRUPTION" },
    { RestoreError::UPDATE_PHOTOS_FAILED, "RESTORE_UPDATE_PHOTOS_FAILED"}
};

const std::unordered_map<PrefixType, std::string> PREFIX_MAP = {
    { PrefixType::CLOUD, "/storage/cloud/files" },
    { PrefixType::LOCAL, "/storage/media/local/files" },
    { PrefixType::CLOUD_EDIT_DATA, "/storage/cloud/files/.editData" },
    { PrefixType::LOCAL_EDIT_DATA, "/storage/media/local/files/.editData" },
};

const std::vector<std::vector<std::string>> CLONE_TABLE_LISTS_AUDIO = {
    { AudioColumn::AUDIOS_TABLE },
};

const std::vector<std::vector<std::string>> CLONE_TABLE_LISTS_PHOTO = {
    { PhotoColumn::PHOTOS_TABLE },
    { PhotoAlbumColumns::TABLE, PhotoMap::TABLE },
    { ANALYSIS_ALBUM_TABLE, ANALYSIS_PHOTO_MAP_TABLE },
};

const std::vector<std::vector<std::string>> CLONE_TABLE_LISTS_OLD_DEVICE = {
    { PhotoColumn::PHOTOS_TABLE },
    { AudioColumn::AUDIOS_TABLE },
};

struct FileInfo {
    std::string filePath;
    std::string displayName;
    std::string title;
    std::string userComment;
    std::string relativePath;
    std::string cloudPath;
    std::string packageName;
    std::string bundleName;
    std::string oldPath;
    std::string movingPhotoVideoPath;
    std::string extraDataPath;
    std::string detailTime;
    int32_t fileIdOld {-1};
    int32_t fileIdNew {-1};
    int64_t fileSize {0};
    int64_t duration {0};
    int64_t recycledTime {0};
    int32_t hidden {0};
    int32_t isFavorite {0};
    int32_t fileType {0};
    int32_t specialFileType {0};
    int32_t subtype {0};
    int64_t showDateToken {0};
    int32_t height {0};
    int32_t width {0};
    int64_t dateAdded {0};
    int32_t orientation {0};
    int64_t dateModified {0};
    int32_t mediaAlbumId {-1};  // 单相册id
    int32_t localMediaId {-1};
    bool isNew {true};
    int64_t dateTaken {0};
    int64_t firstUpdateTime {0};
    int64_t thumbnailReady {0};
    int32_t lcdVisitTime {0};
    std::unordered_map<std::string, std::variant<int32_t, int64_t, double, std::string>> valMap;
    std::unordered_map<std::string, std::unordered_set<int32_t>> tableAlbumSetMap;
    /**
     * @brief the field data from gallery.db # gallery_media # relative_bucket_id.
     */
    std::string relativeBucketId;
    /**
     * @brief the field data from gallery.db # gallery_media # recycleFlag.
     */
    int32_t recycleFlag {0};
    /**
     * @brief the field data from gallery.db # gallery_media # is_hw_burst. 0=normal, 1=burst cover, 2=burst members.
     */
    int32_t isBurst {0};
    /**
     * @brief the field data from gallery.db # gallery_media # hash.
     */
    std::string hashCode;
    /**
     * @brief the field data for media_library.db # Photos # burst_key. 36 length of uuid.
     */
    std::string burstKey;
    /**
     *  @brief the associate file id, used for cloud enhancement pair relationship
     */
    int32_t associateFileId;

    bool needMove {true};

    std::string sourcePath;
    std::string lPath;
    int32_t ownerAlbumId;
    /**
     * @brief The PhotoMap is Deprecated. Hitory Data may still be transfered from Old Device by PhotoMap.
     *   Use the isRelatedToPhotoMap field to identify if the photo is related to PhotoMap.
     *   0 - not related, 1 - related.
     */
    int32_t isRelatedToPhotoMap = 0;
    int32_t photoQuality;
    std::string oldAstcDateKey;
    std::string newAstcDateKey;
    bool isInternal {true};
    int32_t userId {-1};
    std::unordered_map<std::string, std::string> updateMap;
};

struct AlbumInfo {
    int32_t albumIdOld {-1};
    int32_t albumIdNew {-1};
    std::string albumName;
    std::string albumBundleName;
    PhotoAlbumType albumType;
    PhotoAlbumSubType albumSubType;
    std::string lPath;
    std::unordered_map<std::string, std::variant<int32_t, int64_t, double, std::string>> valMap;
    int64_t dateModified {0};
};

struct GalleryAlbumInfo {
    int32_t mediaAlbumId {-1};  // 单相册id
    std::string albumRelativeBucketId ;  //双相册id
    std::string albumName;        //相册名称
    std::string albumNickName;   //映射表名称
    std::string albumCNName;     //映射表名称
    std::string albumENName;     //映射表名称
    std::string albumListName;      //白名单相册名称
    std::string albumBundleName;    //白名单包名
    std::string albumMediaName;     //单相册名称
    std::string albumlPath;     //相册IPath
};

struct MapInfo {
    int32_t albumId {-1};
    int32_t fileId {-1};
};

struct FailedFileInfo {
    std::string albumName;
    std::string displayName;
    std::string errorCode;
    FailedFileInfo() = default;
    FailedFileInfo(int32_t sceneCode, const FileInfo &fileInfo, int32_t givenErrorCode)
    {
        displayName = fileInfo.displayName;
        errorCode = std::to_string(givenErrorCode);
        if (fileInfo.recycledTime > 0) {
            albumName = "最近删除";
            return;
        }
        if (fileInfo.hidden > 0) {
            albumName = sceneCode == CLONE_RESTORE_ID ? "已隐藏" : "隐藏相册";
            return;
        }
        albumName = fileInfo.packageName;
    }
};

struct SubCountInfo {
    uint64_t successCount {0};
    uint64_t duplicateCount {0};
    std::unordered_map<std::string, FailedFileInfo> failedFiles;
    SubCountInfo(int64_t successCount, int64_t duplicateCount,
        const std::unordered_map<std::string, FailedFileInfo> &failedFiles)
        : successCount(successCount), duplicateCount(duplicateCount), failedFiles(failedFiles) {}
};

struct SubProcessInfo {
    uint64_t processed {0};
    uint64_t total {0};
    SubProcessInfo(uint64_t processed, uint64_t total) : processed(processed), total(total) {}
};

struct PortraitAlbumInfo {
    int32_t userOperation {0};
    int32_t renameOperation {0};
    std::string tagIdOld;
    std::string tagIdNew;
    std::string groupTagOld;
    std::string groupTagNew;
    std::string tagName;
};

struct FaceInfo {
    float scaleX {0.0};
    float scaleY {0.0};
    float scaleWidth {0.0};
    float scaleHeight {0.0};
    float pitch {0.0};
    float yaw {0.0};
    float roll {0.0};
    float prob {0.0};
    int32_t albumIdNew {-1};
    int32_t fileIdNew {-1};
    int32_t totalFaces {0};
    std::string hash;
    std::string faceId;
    std::string tagIdOld;
    std::string tagIdNew;
    std::string landmarks;
};

struct AnalysisAlbumTbl {
    std::optional<int32_t> albumId;
    std::optional<int32_t> albumType;
    std::optional<int32_t> albumSubtype;
    std::optional<std::string> albumName;
    std::optional<std::string> coverUri;
    std::optional<int32_t> count;
    std::optional<int64_t> dateModified;
    std::optional<int32_t> rank;
    std::optional<std::string> tagId;
    std::optional<int32_t> userOperation;
    std::optional<std::string> groupTag;
    std::optional<int32_t> userDisplayLevel;
    std::optional<int32_t> isMe;
    std::optional<int32_t> isRemoved;
    std::optional<int32_t> renameOperation;
    std::optional<int32_t> isLocal;
    std::optional<int32_t> isCoverSatisfied;
};

struct PortraitAlbumDfx {
    std::optional<std::string> albumName;
    std::optional<std::string> coverUri;
    std::optional<std::string> tagId;
    std::optional<int32_t> count;
};

struct FaceTagTbl {
    std::optional<int32_t> id;
    std::optional<std::string> tagId;
    std::optional<std::string> tagName;
    std::optional<int32_t> userOperation;
    std::optional<std::string> groupTag;
    std::optional<int32_t> renameOperation;
    std::optional<std::string> centerFeatures;
    std::optional<std::string> tagVersion;
    std::optional<int32_t> userDisplayLevel;
    std::optional<int32_t> tagOrder;
    std::optional<int32_t> isMe;
    std::optional<std::string> coverUri;
    std::optional<int32_t> count;
    std::optional<int64_t> dateModify;
    std::optional<int32_t> albumType;
    std::optional<int32_t> isRemoved;
    std::optional<std::string> analysisVersion;
};

struct ImageFaceTbl {
    std::optional<int32_t> id;
    std::optional<int32_t> fileId;
    std::optional<std::string> faceId;
    std::optional<std::string> tagId;
    std::optional<double> scaleX;
    std::optional<double> scaleY;
    std::optional<double> scaleWidth;
    std::optional<double> scaleHeight;
    std::optional<std::string> landmarks;
    std::optional<double> pitch;
    std::optional<double> yaw;
    std::optional<double> roll;
    std::optional<double> prob;
    std::optional<int32_t> totalFaces;
    std::optional<std::string> faceVersion;
    std::optional<std::string> featuresVersion;
    std::optional<std::string> features;
    std::optional<int32_t> faceOcclusion;
    std::optional<std::string> analysisVersion;
    std::optional<double> beautyBounderX;
    std::optional<double> beautyBounderY;
    std::optional<double> beautyBounderWidth;
    std::optional<double> beautyBounderHeight;
    std::optional<double> aestheticsScore;
    std::optional<std::string> beautyBounderVersion;
    std::optional<int32_t> isExcluded;
};

struct AnalysisPhotoMapTbl {
    std::optional<int32_t> mapAlbum;
    std::optional<int32_t> mapAsset;
};

using NeedQueryMap = std::unordered_map<PhotoRelatedType, std::unordered_set<std::string>>;

// sql for external
const std::string QUERY_FILE_COLUMN = "SELECT _id, " + GALLERY_FILE_DATA + ", " + GALLERY_DISPLAY_NAME + ", " +
    EXTERNAL_IS_FAVORITE + ", " + GALLERY_FILE_SIZE + ", " + GALLERY_DURATION + ", " + GALLERY_MEDIA_TYPE + ", " +
    EXTERNAL_DATE_MODIFIED + ", " + GALLERY_HEIGHT + ", " + GALLERY_WIDTH + ", " + GALLERY_TITLE + ", " +
    GALLERY_ORIENTATION + ", " + EXTERNAL_DATE_ADDED + ", " + EXTERNAL_DATE_TAKEN + ", " +
    GALLERY_SPECIAL_FILE_TYPE + " FROM files WHERE ";

const std::string IN_CAMERA = " bucket_id IN (-1739773001, 0, 1028075469, 0) AND (is_pending = 0)";

const std::string NOT_IN_CAMERA = " bucket_id NOT IN (-1739773001, 0, 1028075469, 0 ) AND is_pending = 0";

const std::string IS_PENDING = " is_pending = 0";

const std::string QUERY_NOT_SYNC = " _id < 1000000000 AND media_type IN (1, 3) AND _size > 0 ";

const std::string IMAGE_AND_VIDEO_TYPE = " media_type IN (1, 3) AND _size > 0";

const std::string GROUP_BY_MEIDA_TYPE = " group by media_type";

const std::string COMPARE_ID = " _id > ";

const std::string QUERY_COUNT_FROM_FILES = "SELECT count(1) AS count FROM files WHERE";

const std::string QUERY_MEDIA_TYPE_AND_COUNT_FROM_FILES = "SELECT media_type,count(1) AS count FROM files WHERE";

// sql for gallery
const std::string QUERY_GARBAGE_ALBUM = "SELECT type, cache_dir, nick_dir, nick_name FROM garbage_album";

const std::string QUERY_MAX_ID_CAMERA_SCREENSHOT = "SELECT max(local_media_id) AS max_id FROM gallery_media \
    WHERE local_media_id > 0 AND bucket_id IN (-1739773001, 0, 1028075469, 0) AND \
    (recycleFlag NOT IN (2, -1, 1, -2, -4) OR recycleFlag IS NULL) AND \
    (storage_id IN (0, 65537) or storage_id IS NULL) AND _size > 0 "; // only in upgrade external

const std::string QUERY_MAX_ID_OTHERS = "SELECT max(local_media_id) AS max_id FROM gallery_media \
    WHERE local_media_id > 0 AND bucket_id NOT IN (-1739773001, 0, 1028075469, 0) AND \
    (recycleFlag NOT IN (2, -1, 1, -2, -4) OR recycleFlag IS NULL) AND \
    (storage_id IN (0, 65537) or storage_id IS NULL) AND _size > 0 "; // only in upgrade external

const std::string QUERY_MAX_ID_ALL = "SELECT max(local_media_id) AS max_id FROM gallery_media \
    WHERE local_media_id > 0 AND (recycleFlag NOT IN (2, -1, 1, -2, -4) OR recycleFlag IS NULL) AND \
    (storage_id IN (0, 65537) or storage_id IS NULL) AND _size > 0 "; // only in upgrade external

const std::string ALL_PHOTOS_WHERE_CLAUSE = " (local_media_id != -1) AND (relative_bucket_id IS NULL OR \
    relative_bucket_id NOT IN (SELECT DISTINCT relative_bucket_id FROM garbage_album WHERE type = 1)) AND _size > 0 \
    AND _data NOT LIKE '/storage/emulated/0/Pictures/cloud/Imports%' ";

const std::string ALL_PHOTOS_ORDER_BY = " ORDER BY showDateToken ASC ";

const std::string EXCLUDE_SD = " (storage_id IN (0, 65537)) ";

const std::string DUAL_CLONE_AUDIO_FULL_TABLE = "mediainfo INNER JOIN mediafile ON mediainfo." + AUDIO_DATA +
    " = '/storage/emulated/0'||mediafile.filepath";

const std::string QUERY_ALL_AUDIOS_FROM_AUDIODB = "SELECT " + AUDIO_DATA + "," + AUDIO_DATE_MODIFIED + "," +
    AUDIO_DATE_TAKEN + " FROM " + DUAL_CLONE_AUDIO_FULL_TABLE;

const std::string QUERY_DUAL_CLONE_AUDIO_COUNT = "SELECT count(1) as count FROM " + DUAL_CLONE_AUDIO_FULL_TABLE;

const std::vector<std::string> EXCLUDED_PORTRAIT_COLUMNS = {"album_id", "count", "rank"};
const std::vector<std::string> EXCLUDED_FACE_TAG_COLUMNS = {"id", "user_operation", "rename_operation", "group_tag",
    "user_display_level", "tag_order", "is_me", "cover_uri", "count", "date_modify", "album_type", "is_removed"};
const std::vector<std::string> EXCLUDED_IMAGE_FACE_COLUMNS = {"id"};
} // namespace Media
} // namespace OHOS

#endif  // OHOS_MEDIA_BACKUP_DEFINES_H