1 /*
2  * Copyright (C) 2022 The Android Open Source Project
3  *
4  * Licensed under the Apache License, Version 2.0 (the "License");
5  * you may not use this file except in compliance with the License.
6  * You may obtain a copy of the License at
7  *
8  *      http://www.apache.org/licenses/LICENSE-2.0
9  *
10  * Unless required by applicable law or agreed to in writing, software
11  * distributed under the License is distributed on an "AS IS" BASIS,
12  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13  * See the License for the specific language governing permissions and
14  * limitations under the License.
15  */
16 
17 package com.android.settingslib.mobile.dataservice;
18 
19 import java.util.List;
20 
21 import androidx.lifecycle.LiveData;
22 import androidx.room.Dao;
23 import androidx.room.Insert;
24 import androidx.room.OnConflictStrategy;
25 import androidx.room.Query;
26 
27 @Dao
28 public interface UiccInfoDao {
29 
30     @Insert(onConflict = OnConflictStrategy.REPLACE)
insertUiccInfo(UiccInfoEntity... uiccInfo)31     void insertUiccInfo(UiccInfoEntity... uiccInfo);
32 
33     @Query("SELECT * FROM " + DataServiceUtils.UiccInfoData.TABLE_NAME + " ORDER BY "
34             + DataServiceUtils.UiccInfoData.COLUMN_ID)
queryAllUiccInfos()35     LiveData<List<UiccInfoEntity>> queryAllUiccInfos();
36 
37     @Query("SELECT * FROM " + DataServiceUtils.UiccInfoData.TABLE_NAME + " WHERE "
38             + DataServiceUtils.UiccInfoData.COLUMN_ID + " = :subId")
queryUiccInfoById(String subId)39     LiveData<UiccInfoEntity> queryUiccInfoById(String subId);
40 
41     @Query("SELECT * FROM " + DataServiceUtils.UiccInfoData.TABLE_NAME + " WHERE "
42             + DataServiceUtils.UiccInfoData.COLUMN_IS_EUICC + " = :isEuicc")
queryUiccInfosByEuicc(boolean isEuicc)43     LiveData<List<UiccInfoEntity>> queryUiccInfosByEuicc(boolean isEuicc);
44 
45     @Query("SELECT COUNT(*) FROM " + DataServiceUtils.UiccInfoData.TABLE_NAME)
count()46     int count();
47 
48     @Query("DELETE FROM " + DataServiceUtils.UiccInfoData.TABLE_NAME + " WHERE "
49             + DataServiceUtils.UiccInfoData.COLUMN_ID + " = :id")
deleteBySubId(String id)50     void deleteBySubId(String id);
51 }
52