Menu
Having a Android Room with three tables timestamp, index, details, and all three have
@PrimaryKey @ColumnInfo(name = "id") var id: Int = 0
having fun clearDataByID(idList: List<Int>) to clear data from all three tables by the id in the idList
Dao as:
@Dao
interface DataDAO {
@Transaction
fun clearDataByID(idList: List<Int>) {
deleteDataInTimestamp(idList)
deleteDataIndex(idList)
deleteDataDetails(idList)
}
@Query("delete from timestamp where id in :idList")
fun deleteDataInTimestamp(idList: List<Int>)
@Query("delete from index where id in :idList")
fun deleteDataIndex(idList: List<Int>)
@Query("delete from details where id in :idList")
fun deleteDataDetails(idList: List<Int>)
}
but it gets compiler error (similar for all three)
error: no viable alternative at input 'delete from timestamp where id in :idList'
public abstract void deleteDataInTimestamp(@org.jetbrains.annotations.NotNull()
if delete by single id it worked.
How to delete by a list of ids?
@Query("delete from timestamp where id = :id")
fun deleteSingleTimestamp(id: Int)
468
As of Room 1.1. 0 you can use clearAllTables() which "deletes all rows from all the tables that are registered to this database as entities()." I've included this as an answer below, but am reproducing here for visibility.
3.1 Add the Clear all data menu optionIn the Options menu, select Clear all data. All words should disappear. Restart the app. (Restart it from your device or the emulator; don't run it again from Android Studio) You should see the initial set of words.
Actually, you can use @Query to perform a delete. @Query("DELETE FROM users WHERE user_id = :userId") abstract void deleteByUserId(long userId); Extracted from Query javadoc: UPDATE or DELETE queries can return void or int.
execSQL("DROP TABLE my_table"); // Use the right table name // OR: We could update it, by using an ALTER query // OR: If needed, we can create the table again with the required settings // database. execSQL("CREATE TABLE IF NOT EXISTS my_table (id INTEGER, PRIMARY KEY(id), ...)") } };
Thanks Simon points to the similar question, it should be done like:
@Query("delete from timestamp where id in (:idList)")
fun deleteDataInTimestamp(idList: List<Int>)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With