| | |
| | | |
| | | import com.dayu.pipirrapp.bean.db.DivideBean; |
| | | import com.dayu.pipirrapp.bean.db.MarkerBean; |
| | | import com.dayu.pipirrapp.bean.db.SearchResultBean; |
| | | |
| | | import java.util.List; |
| | | |
| | | import io.reactivex.rxjava3.core.Completable; |
| | | import io.reactivex.rxjava3.core.Single; |
| | | import io.reactivex.rxjava3.core.Maybe; |
| | | |
| | | /** |
| | | * DivideDao - |
| | | * DivideDao -分水房 |
| | | * |
| | | * @author zuoxiao |
| | | * @version 1.0 |
| | |
| | | |
| | | @Query("select * from DivideBean") |
| | | Single<List<DivideBean>> findAllToSingle(); |
| | | |
| | | @Query("SELECT * FROM DivideBean") |
| | | Maybe<List<DivideBean>> getAll(); // 改为返回Maybe<List<DivideBean>> |
| | | |
| | | @Query("SELECT * FROM DivideBean WHERE divideName LIKE '%' || :name || '%'") |
| | | Single<List<DivideBean>> findByDivideNameLike(String name); |
| | | |
| | | @Query("SELECT divideName as name, 'divide' as type, lat, lng, address, divideId as id FROM DivideBean " + |
| | | "WHERE divideName LIKE '%' || :keyword || '%' " + |
| | | "UNION " + |
| | | "SELECT name, 'marker' as type, lat, lng, address, id FROM MarkerBean " + |
| | | "WHERE name LIKE '%' || :keyword || '%'") |
| | | Single<List<SearchResultBean>> searchAllByKeyword(String keyword); |
| | | } |