1 /* 2 * Copyright (c) 2023-2024 Huawei Device Co., Ltd. 3 * Licensed under the Apache License, Version 2.0 (the "License"); 4 * you may not use this file except in compliance with the License. 5 * You may obtain a copy of the License at 6 * 7 * http://www.apache.org/licenses/LICENSE-2.0 8 * 9 * Unless required by applicable law or agreed to in writing, software 10 * distributed under the License is distributed on an "AS IS" BASIS, 11 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 12 * See the License for the specific language governing permissions and 13 * limitations under the License. 14 */ 15 16 #include "file_column.h" 17 18 namespace OHOS { 19 namespace FileManagement { 20 namespace CloudDisk { 21 const std::string FileColumn::CLOUD_ID = "cloud_id"; 22 const std::string FileColumn::IS_DIRECTORY = "isDirectory"; 23 const std::string FileColumn::FILE_NAME = "file_name"; 24 const std::string FileColumn::PARENT_CLOUD_ID = "parent_cloud_id"; 25 const std::string FileColumn::FILE_SIZE = "file_size"; 26 const std::string FileColumn::FILE_SHA256 = "sha256"; 27 const std::string FileColumn::FILE_TIME_ADDED = "time_added"; 28 const std::string FileColumn::FILE_TIME_EDITED = "time_edited"; 29 const std::string FileColumn::FILE_TIME_RECYCLED = "time_recycled"; 30 const std::string FileColumn::META_TIME_EDITED = "meta_time_edited"; 31 const std::string FileColumn::FILE_TIME_VISIT = "time_visit"; 32 const std::string FileColumn::DIRECTLY_RECYCLED = "directly_recycled"; 33 const std::string FileColumn::VERSION = "version"; 34 const std::string FileColumn::OPERATE_TYPE = "operateType"; 35 const std::string FileColumn::SYNC_STATUS = "sync_status"; 36 const std::string FileColumn::POSITION = "position"; 37 const std::string FileColumn::THM_FLAG = "thm_flag"; 38 const std::string FileColumn::LCD_FLAG = "lcd_flag"; 39 const std::string FileColumn::NO_NEED_UPLOAD = "no_need_upload"; 40 const std::string FileColumn::DIRTY_TYPE = "dirty_type"; 41 const std::string FileColumn::MIME_TYPE = "mimetype"; 42 const std::string FileColumn::FILE_TYPE = "file_type"; 43 const std::string FileColumn::FILE_CATEGORY = "file_category"; 44 const std::string FileColumn::IS_FAVORITE = "isFavorite"; 45 const std::string FileColumn::FILE_STATUS = "file_status"; 46 const std::string FileColumn::ROW_ID = "rowid"; 47 const std::string FileColumn::CHECK_FLAG = "check_flag"; 48 const std::string FileColumn::ROOT_DIRECTORY = "root_directory"; 49 const std::string FileColumn::ATTRIBUTE = "attribute"; 50 const std::string FileColumn::FILES_TABLE = "CloudDisk"; 51 const std::string FileColumn::PARENT_CLOUD_ID_INDEX = "parentCloudId_index"; 52 const std::string FileColumn::SRC_CLOUD_ID = "src_cloud_id"; 53 54 const std::string FileColumn::CREATE_FILE_TABLE = "CREATE TABLE IF NOT EXISTS " + 55 FILES_TABLE + " (" + 56 CLOUD_ID + " TEXT PRIMARY KEY NOT NULL, " + 57 IS_DIRECTORY + " INT, " + 58 FILE_NAME + " TEXT NOT NULL, " + 59 PARENT_CLOUD_ID + " TEXT NOT NULL, " + 60 FILE_SIZE + " BIGINT, " + 61 FILE_SHA256 + " TEXT, " + 62 FILE_TIME_ADDED + " BIGINT, " + 63 FILE_TIME_EDITED + " BIGINT, " + 64 FILE_TIME_RECYCLED + " BIGINT DEFAULT 0, " + 65 META_TIME_EDITED + " BIGINT, " + 66 FILE_TIME_VISIT + " BIGINT DEFAULT 0, " + 67 DIRECTLY_RECYCLED + " INT DEFAULT 0, " + 68 VERSION + " BIGINT DEFAULT 0, " + 69 OPERATE_TYPE + " BIGINT DEFAULT 0, " + 70 SYNC_STATUS + " INT DEFAULT 0, " + 71 POSITION + " INT DEFAULT 1, " + 72 DIRTY_TYPE + " INT DEFAULT 1, " + 73 MIME_TYPE + " TEXT, " + 74 FILE_TYPE + " INT, " + 75 FILE_CATEGORY + " TEXT, " + 76 IS_FAVORITE + " INT DEFAULT 0, " + 77 FILE_STATUS + " INT DEFAULT 4, " + 78 CHECK_FLAG + " INT DEFAULT 0, " + 79 ROOT_DIRECTORY + " TEXT, " + 80 ATTRIBUTE + " TEXT, " + 81 THM_FLAG + " INT DEFAULT 0, " + 82 LCD_FLAG + " INT DEFAULT 0, " + 83 NO_NEED_UPLOAD + " INT DEFAULT 0, " + 84 SRC_CLOUD_ID + " TEXT)"; 85 86 const std::string FileColumn::CREATE_PARENT_CLOUD_ID_INDEX = "CREATE INDEX IF NOT EXISTS " + 87 PARENT_CLOUD_ID_INDEX + " ON " + FILES_TABLE + 88 " (" + PARENT_CLOUD_ID + ")"; 89 90 const std::string FileColumn::ADD_IS_FAVORITE = "ALTER Table " + FILES_TABLE + 91 " ADD COLUMN " + IS_FAVORITE + " INT DEFAULT 0"; 92 93 const std::string FileColumn::ADD_FILE_STATUS = "ALTER Table " + FILES_TABLE + 94 " ADD COLUMN " + FILE_STATUS + " INT"; 95 96 const std::string FileColumn::SET_FILE_STATUS_DEFAULT = "UPDATE " + FILES_TABLE + 97 " SET " + FILE_STATUS + " = 4 WHERE " + FILE_STATUS + " IS NULL"; 98 99 const std::string FileColumn::ADD_CHECK_FLAG = "ALTER Table " + FILES_TABLE + 100 " ADD COLUMN " + CHECK_FLAG + " INT DEFAULT 0"; 101 102 const std::string FileColumn::ADD_ATTRIBUTE = "ALTER Table " + FILES_TABLE + 103 " ADD COLUMN " + ATTRIBUTE + " TEXT"; 104 105 const std::string FileColumn::ADD_THM_FLAG = "ALTER Table " + FILES_TABLE + 106 " ADD COLUMN " + THM_FLAG + " INT DEFAULT 0"; 107 108 const std::string FileColumn::ADD_LCD_FLAG = "ALTER Table " + FILES_TABLE + 109 " ADD COLUMN " + LCD_FLAG + " INT DEFAULT 0"; 110 111 const std::string FileColumn::ADD_UPLOAD_FLAG = "ALTER Table " + FILES_TABLE + 112 " ADD COLUMN " + NO_NEED_UPLOAD + " INT DEFAULT 0"; 113 114 const std::string FileColumn::ADD_SRC_CLOUD_ID = "ALTER Table " + FILES_TABLE + 115 " ADD COLUMN " + SRC_CLOUD_ID + " TEXT"; 116 117 const std::vector<std::string> FileColumn::FILE_SYSTEM_QUERY_COLUMNS = { 118 FILE_NAME, 119 CLOUD_ID, 120 PARENT_CLOUD_ID, 121 POSITION, 122 FILE_SIZE, 123 META_TIME_EDITED, 124 FILE_TIME_ADDED, 125 FILE_TIME_EDITED, 126 IS_DIRECTORY, 127 ROW_ID 128 }; 129 130 const std::vector<std::string> FileColumn::DISK_CLOUD_SYNC_COLUMNS = { 131 CLOUD_ID, 132 IS_DIRECTORY, 133 FILE_NAME, 134 PARENT_CLOUD_ID, 135 FILE_SIZE, 136 FILE_SHA256, 137 FILE_TIME_ADDED, 138 FILE_TIME_EDITED, 139 FILE_TIME_RECYCLED, 140 META_TIME_EDITED, 141 DIRECTLY_RECYCLED, 142 VERSION, 143 OPERATE_TYPE, 144 ROOT_DIRECTORY, 145 ATTRIBUTE, 146 THM_FLAG, 147 LCD_FLAG, 148 ROW_ID 149 }; 150 151 //File copy requires all fields in the database, and one is added here when adding a new column ... 152 const std::vector<std::string> FileColumn::DISK_CLOUD_FOR_COPY = { 153 CLOUD_ID, 154 IS_DIRECTORY, 155 FILE_NAME, 156 PARENT_CLOUD_ID, 157 FILE_SIZE, 158 FILE_SHA256, 159 FILE_TIME_ADDED, 160 FILE_TIME_EDITED, 161 FILE_TIME_RECYCLED, 162 META_TIME_EDITED, 163 FILE_TIME_VISIT, 164 DIRECTLY_RECYCLED, 165 VERSION, 166 OPERATE_TYPE, 167 SYNC_STATUS, 168 POSITION, 169 DIRTY_TYPE, 170 MIME_TYPE, 171 FILE_TYPE, 172 FILE_CATEGORY, 173 IS_FAVORITE, 174 FILE_STATUS, 175 CHECK_FLAG, 176 ROOT_DIRECTORY, 177 ATTRIBUTE, 178 THM_FLAG, 179 LCD_FLAG, 180 NO_NEED_UPLOAD, 181 SRC_CLOUD_ID, 182 }; 183 184 const std::vector<std::string> FileColumn::LOCAL_COLUMNS = { 185 FILE_TIME_VISIT, SYNC_STATUS, POSITION, DIRTY_TYPE, 186 MIME_TYPE, IS_DIRECTORY, FILE_TYPE, FILE_CATEGORY, 187 }; 188 189 const std::vector<std::string> FileColumn::PULL_QUERY_COLUMNS = { 190 CLOUD_ID, FILE_TIME_RECYCLED, VERSION, DIRTY_TYPE, POSITION, 191 FILE_TIME_EDITED, FILE_SHA256, FILE_SIZE, FILE_NAME, PARENT_CLOUD_ID, ROW_ID, 192 IS_DIRECTORY, FILE_TIME_ADDED, FILE_TYPE, ROOT_DIRECTORY, DIRECTLY_RECYCLED, 193 THM_FLAG, LCD_FLAG, 194 }; 195 196 const std::vector<std::string> FileColumn::DISK_ON_UPLOAD_COLUMNS = { 197 CLOUD_ID, 198 PARENT_CLOUD_ID, 199 FILE_NAME, 200 FILE_TIME_EDITED, 201 META_TIME_EDITED, 202 FILE_TIME_RECYCLED, 203 ROW_ID, 204 THM_FLAG, 205 LCD_FLAG, 206 }; 207 208 const std::vector<std::string> FileColumn::EXT_ATTR_QUERY_COLUMNS = { 209 ATTRIBUTE, 210 POSITION 211 }; 212 } // namespace CloudDisk 213 } // namespace FileManagement 214 } // namespace OHOS 215