1 /*
2  * Copyright (C) 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 "media_app_uri_permission_column.h"
17 #include "media_column.h"
18 #include "base_column.h"
19 
20 namespace OHOS {
21 namespace Media {
22 
23 const std::string AppUriPermissionColumn::ID = "id";
24 const std::string AppUriPermissionColumn::APP_ID = "appid";
25 const std::string AppUriPermissionColumn::FILE_ID = "file_id";
26 const std::string AppUriPermissionColumn::URI_TYPE = "uri_type";
27 const std::string AppUriPermissionColumn::PERMISSION_TYPE = "permission_type";
28 const std::string AppUriPermissionColumn::DATE_MODIFIED = "date_modified";
29 
30 const int AppUriPermissionColumn::URI_PHOTO = 1;
31 const int AppUriPermissionColumn::URI_AUDIO = 2;
32 const std::set<int> AppUriPermissionColumn::URI_TYPES_ALL = {
33     AppUriPermissionColumn::URI_PHOTO, AppUriPermissionColumn::URI_AUDIO};
34 
35 const int AppUriPermissionColumn::PERMISSION_TEMPORARY_READ = 0;
36 const int AppUriPermissionColumn::PERMISSION_PERSIST_READ = 1;
37 const int AppUriPermissionColumn::PERMISSION_TEMPORARY_WRITE = 2;
38 const int AppUriPermissionColumn::PERMISSION_TEMPORARY_READ_WRITE = 3;
39 const int AppUriPermissionColumn::PERMISSION_PERSIST_READ_WRITE = 4;
40 const std::set<int> AppUriPermissionColumn::PERMISSION_TYPES_ALL = {
41     AppUriPermissionColumn::PERMISSION_TEMPORARY_READ, AppUriPermissionColumn::PERMISSION_PERSIST_READ,
42     AppUriPermissionColumn::PERMISSION_TEMPORARY_WRITE, AppUriPermissionColumn::PERMISSION_TEMPORARY_READ_WRITE,
43     AppUriPermissionColumn::PERMISSION_PERSIST_READ_WRITE};
44 const std::set<int> AppUriPermissionColumn::PERMISSION_TYPES_PICKER = {
45     AppUriPermissionColumn::PERMISSION_TEMPORARY_READ, AppUriPermissionColumn::PERMISSION_PERSIST_READ};
46 const std::set<int> AppUriPermissionColumn::PERMISSION_TYPES_TEMPORARY = {
47     AppUriPermissionColumn::PERMISSION_TEMPORARY_READ, AppUriPermissionColumn::PERMISSION_TEMPORARY_WRITE,
48     AppUriPermissionColumn::PERMISSION_TEMPORARY_READ_WRITE};
49 const std::set<int> AppUriPermissionColumn::PERMISSION_TYPES_PERSIST = {
50     AppUriPermissionColumn::PERMISSION_PERSIST_READ, AppUriPermissionColumn::PERMISSION_PERSIST_READ_WRITE};
51 
52 const std::string AppUriPermissionColumn::URI_URITYPE_APPID_INDEX = "uri_uritype_appid_index";
53 
54 const std::string AppUriPermissionColumn::APP_URI_PERMISSION_TABLE = "UriPermission";
55 
56 const std::set<std::string> AppUriPermissionColumn::DEFAULT_FETCH_COLUMNS = {AppUriPermissionColumn::ID};
57 
58 const std::string AppUriPermissionColumn::CREATE_APP_URI_PERMISSION_TABLE =
59     "CREATE TABLE IF NOT EXISTS " + AppUriPermissionColumn::APP_URI_PERMISSION_TABLE + "(" +
60     AppUriPermissionColumn::ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
61     AppUriPermissionColumn::APP_ID + " TEXT, " + AppUriPermissionColumn::FILE_ID + " INTEGER, " +
62     AppUriPermissionColumn::URI_TYPE + " INTEGER, " + AppUriPermissionColumn::PERMISSION_TYPE + " INTEGER, " +
63     AppUriPermissionColumn::DATE_MODIFIED + " BIGINT)";
64 
65 const std::string AppUriPermissionColumn::CREATE_URI_URITYPE_APPID_INDEX = BaseColumn::CreateIndex() +
66     AppUriPermissionColumn::URI_URITYPE_APPID_INDEX + " ON " +
67     AppUriPermissionColumn::APP_URI_PERMISSION_TABLE + " (" +
68     AppUriPermissionColumn::FILE_ID + " DESC," +
69     AppUriPermissionColumn::URI_TYPE + "," +
70     AppUriPermissionColumn::APP_ID + " DESC)";
71 
72 const std::set<std::string> AppUriPermissionColumn::ALL_COLUMNS = {
73     AppUriPermissionColumn::ID, AppUriPermissionColumn::APP_ID, AppUriPermissionColumn::FILE_ID,
74     AppUriPermissionColumn::URI_TYPE, AppUriPermissionColumn::PERMISSION_TYPE,
75     AppUriPermissionColumn::DATE_MODIFIED
76 };
77 } // namespace Media
78 } // namespace OHOS