| /* |
| * Copyright (C) 2016 The Android Open Source Project |
| * |
| * 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. |
| */ |
| |
| package foo.bar; |
| import com.android.support.room.*; |
| import java.util.List; |
| @Dao |
| abstract class ComplexDao { |
| @Query("SELECT * FROM user where uid = :id") |
| abstract public User getById(int id); |
| |
| @Query("SELECT * FROM user where name LIKE :name AND lastName LIKE :lastName") |
| abstract public User findByName(String name, String lastName); |
| |
| @Query("SELECT * FROM user where uid IN (:ids)") |
| abstract public List<User> loadAllByIds(int... ids); |
| |
| @Query("SELECT age FROM user where id = :id") |
| abstract int getAge(int id); |
| |
| @Query("SELECT age FROM user where id = IN(:ids)") |
| abstract public int[] getAllAges(int... ids); |
| |
| @Query("SELECT age FROM user where id = IN(:ids)") |
| abstract public List<Integer> getAllAgesAsList(List<Integer> ids); |
| } |