app/src/main/java/com/example/firstapp/database/dao/CodeDao.kt
@@ -62,10 +62,10 @@ SELECT * FROM Code WHERE category = :category AND code = :code AND substr(createTime, 1, 10) = substr(:dateString, 1, 10) AND (smsTimestamp = :smsTimestamp ) LIMIT 1 """) fun queryByTypeAndCodeAndDate(category: String, code: String, dateString: String): Code? fun queryByTypeAndCodeAndDate(category: String, code: String, smsTimestamp: Long): Code? @Query("update Code set pickup = '1' , pickuptime = CURRENT_TIMESTAMP where id=:id")