| | |
|---|
| | | """) |
|---|
| | | fun getByKeyword(keyword: String): List<Code> |
|---|
| | | |
|---|
| | | @Query("SELECT * FROM Code WHERE oneLevel = :content and code= :code and createTime = :dateString LIMIT 1") |
|---|
| | | fun queryByTypeAndCodeAndDate(content: String, code: String, dateString: String): Code |
|---|
| | | @Query(""" |
|---|
| | | SELECT * FROM Code |
|---|
| | | WHERE category = :category |
|---|
| | | AND code = :code |
|---|
| | | AND substr(createTime, 1, 10) = substr(:dateString, 1, 10) |
|---|
| | | LIMIT 1 |
|---|
| | | """) |
|---|
| | | fun queryByTypeAndCodeAndDate(category: String, code: String, dateString: String): Code? |
|---|
| | | |
|---|
| | | |
|---|
| | | @Query("update Code set pickup = '1' , pickuptime = CURRENT_TIMESTAMP where id=:id") |
|---|
