In older Android Studio versions: Emulator -> Android Studio -> Device File Explorer -> /data/data/{$packageId}/databases/ -> Save As -> https://sqlitebrowser.org/ In later Android Studio versions (3.5+): View -> Tool Windows -> Device File Explorer -> /data/data/{$packageId}/databases/ -> Save As -> https://sqlitebrowser.org/
Type Converter are made specifically for that. In your case, you can use code snippet given below to store data in DB. public class Converters { @TypeConverter public static ArrayList<String> fromString(String value) { Type listType = new TypeToken<ArrayList<String>>() {}.getType(); return new Gson().fromJson(value, listType); } @TypeConverter public static String fromArrayList(ArrayList<String> list) { Gson gson = new … Read more
Perhaps you can make your BaseDao like this. secure the upsert operation with @Transaction, and try to update only if insertion is failed. @Dao public abstract class BaseDao<T> { /** * Insert an object in the database. * * @param obj the object to be inserted. * @return The SQLite row id */ @Insert(onConflict = … Read more
When you first come across this message, you will most likely be working against an unreleased version of the database. If that is the case, most likely you should not increment the database version. Simply clearing app data will move you passed the exception. If you do not increment the database (recommended): You should clear … Read more
Room does NOT have a good Migration System, at least not until 2.1.0-alpha03. So, until we have better Migration System, there are some workarounds to have easy Migrations in the Room. As there is no such method as @Database(createNewTables = true) or MigrationSystem.createTable(User::class), which there should be one or other, the only possible way is … Read more
You can just concat using SQLite string concatenation. @Query(“SELECT * FROM hamster WHERE name LIKE ‘%’ || :search || ‘%'”) fun loadHamsters(search: String?): Flowable<List<Hamster>>
According to SQLite Update Docs : <!– language: lang-java –> @Query(“UPDATE tableName SET field1 = :value1, field2 = :value2, … //some more fields to update … field_N= :value_N WHERE id = :id) int updateTour(long id, Type value1, Type value2, … , // some more values here … , Type value_N); Example: Entity: @Entity(tableName = “orders”) … Read more
Just add this line to you gradle.properties: kapt.incremental.apt=true
It’s not recommended but you can access to database on main thread with allowMainThreadQueries() MyApp.database = Room.databaseBuilder(this, AppDatabase::class.java, “MyDatabase”).allowMainThreadQueries().build()
Based on the documentation here (below the code snippet) A method annotated with the @Insert annotation can return: long for single insert operation long[] or Long[] or List<Long> for multiple insert operations void if you don’t care about the inserted id(s)