Hey, I am trying to test Android room Dao function that returns a PagingSource. But following the docs, the test runs indefinitely. Check the following snippet:

is there a way to perform an operation within the DAO after getting the result from Room, something like

@Query("SELECT mutualFriends FROM friends where userId = :userId")
fun getMutualFriends(userId: String): List<Friend> {
    // do some further operation with list
    // like filter or some other
}

Hi, I am having diffulty understanding why I cannot retrieve the most upto date data from my room database when using paging3 library

Hey I have a question about

UUID

usage in ROOM database with the new built in adapter. We decided to move from

Long

@PrimaryKey

type to

UUID

because of integrity reasons. Now we need to migrate those ids. So when writing a migration we use raw SQL where we lose the ability to use built in converters (AFAIU at least) so we can’t insert it as

String

or something else (cant use the `UUIDUtil`from ROOM too). What would be the suggested way to migrate

Long

ids to

UUID

to use the build in adapter? Maybe someone else encountered a similar issue?

Hi, im trying to use room with sqlite windowing functions LAG and LEAD

I have a question, when I have entity like this:

@Entity
data class Note(
    val title: String,
    val content: String,
    val timestamp: Long,
    val color: Int,
    @PrimaryKey val id: Int? = null
)

and when I create Note object, and passing 

null

  to 

id

 , what room will assign to it? In my case it is assigning 

1, 2, 3, 4...

  like it is autoGenerating, is this correct what I am thinking? Though I am NOT having

autoGenerate = true

in

@PrimaryKey

Is the conflict between

@Transaction

and

-Xjvm-default=all

a known issue? Building on android-room-with-a-view and adding

-Xjvm-default=all

to build.gradle and then adding a @Transaction’d

deleteAllAndInsert

to WordDao.kt results in

WordDao_Impl.java:84: error: not an enclosing class: WordDao
        return WordDao.super.deleteAllAndInsert(word, __cont);

Room has some persistent cache bug or sth. I have an entity with some values, was running on a device (had a migration and json file generated already). Then i decided to rename some variables (more specifically, they were plural, i took out the ‘s’). Then the project failed to compile, in the generated dao related to that entity. Was complaining about a method name was in plural and couldn’t find. Tried everything, cleared cache, deleted build files, deletes json schema. Nothing works but rename the table. It’s weird. It seems it has a broken disk cache somehow. idk

Does using

@DatabaseView

take up additional space in app memory (not storage)? Does it generate a temporary in-memory table of the view fields, or does it perform the

SELECT

query each time you access the view?

Hi there, is it possible to check a room encrypted database’s password? Calling

databaseBuilder.openHelperFactory(SupportFactory(passPhrase)).build()

with a wrong password does not fail as it seems to be ‘lazy’. (Well, it’s a factory). The failure only happens on first access. Additionally I have read somewhere, that accessing a Room/SQLite DB with a wrong password will corrupt it. Is that true?

Is anyone aware of broken auto migrations? Looks like

RenameColumn.Entries

is not working properly if you specify more than 1 rename for the same table. Only one is picked

I store some JSON in my database. However, I changed the JSON representation. How can I migrate existing entries to the new format? I know how to generally do migrations. But I am not entirely sure how I can fetch the current entries, transform them and add them back to the database. Do I have to use raw SQL to fetch the entries or can I rely on older Room Daos during migration?

Room / Modules / architecture question... Typically with initializing Room you need a reference to Application Context. If you're building a library / SDK that needs to write to a Room database, what's the proper way to handle Room? Does the library own it's own Room instance? Do you want to create a singleton within your library to then reference Room from the library and to provide a handle to code using the library to read from the database? I found such suggestions in this SO post : https://stackoverflow.com/questions/62190220/room-database-setup-in-android-library-module but not really sure if this is actually the best or even a recommended approach.

I was trying to update to Kotlin

1.7.0

yesterday and Room started giving me issues

error: Each bind variable in the query must have a matching method parameter. Cannot find method parameters for :expiringDate. - com.project.MyDao.getAll(java.util.Date)
error: Unused parameter: arg0 - com.project.MyDao.getAll(java.util.Date)

I tried disabling incremental room with no effect, only updating to the newest Room alpha fixed the issue (which isn’t an option for us, we don’t use alphas)

Hi does room support customisations to Dao generation that can resolve these build errors?

Error:Not sure how to convert a Cursor to this method's return type

Hi, I have been trying to test a database query which returns a PagingSource<>. Issue is how do I collect the value or list of data from the get query as the return type of query is pagingSource? I have tried the solution mentioned here -: https://stackoverflow.com/a/68320495/9607296 But the problem is this test keeps on running and never stops

Does any one know why a ‘group by’ query in Room returns a Map<Key, List<Values>> as it’s supposed to, but List<Values> always has a size of 1?

Hey, is room KSP meant to be faster than with KAPT? I ran some benchmarks with gradle profiler using the latest version of room (2.5.0-alpha03) and the results are inconclusive for me...

Hey, Is there any way to programmatically set the room db version number programmatically, at runtime? It seems like thats not possible based on the message im getting when i try

An annotation argument must be a compile-time constant

I’m just wondering if there’s another api that could help with this?

Anyone seen this error before? I’m getting this after upgrading my kotlin and gradle plugin:

> java.lang.IllegalStateException: org.gradle.android.workarounds.RoomSchemaLocationWorkaround cannot be used with an explicit 'room.schemaLocation' annotation processor argument.  Please change this to configure the schema location directory via the 'room' project extension:
         room {
             schemaLocationDir.set(file("roomSchemas"))
         }

every bit of developer documentation i can find suggests that this it eh right right way to configure it:

defaultConfig {
        javaCompileOptions {
            annotationProcessorOptions {
                arguments += mapOf(
                    "room.schemaLocation" to "$projectDir/schemas",
                    "room.incremental" to "true",
                    "room.expandProjection" to "true"
                )
            }
        }
    }

Hey guys, since KSP can be multiplatform, can Room with KSP be used to share multiplatform SQLite logic?

[ksp] [MissingType]: Element 'com.project.db.converter.KotlinLocalDateTimeConverters' references a type that is not present. Any idea why this happens. seems to be working fine on version 2.4.3-alpha05 but having issue trying to update to 2.5.0-alpha03. The typeconverter is for kotlinx.datetime.LocalDateTime

Hi everyone, how to get max value using room? More details in thread

I'll try to make this my only question - how do I update the primary key, or return the newly generated table row, after an insert? Code samples in thread... ``````

How do you fetch an initial value from the database when the viewmodel is first constructed? I'm happy to block the UI, I'm only trying to fetch a single Integer value. Because I can't do `val initialOdometerReading = vehicleRepository.getCurrentOdometer(_selectedVehicle)`because

getCurrentOdometer

is a suspend function (because, I think, all repository functions which call the DB are supposed to be suspend?) Note that I don't want a LiveData result - it's not going to change value suddenly!

Hi is it possible to have Room report when an Insert statement annotated with

@Insert(onConflict = OnConflictStrategy.REPLACE)

actually replaces an existing row? or do i have to do something "clever" myself?

How would I write a room query over a complex data type (like

LocalDateTime

). I'm trying to write a query which would return all events in the last X number of days:

fun getEventsWithin(days: Int): Flow<List<Event>>

I'm really struggling to work out what the SQL would be. The

Event

entity has a column called

dateTime

of type

LocalDateTime

and I have written two

@TypeConverter

functions which convert between

LocalDateTime

and

Long

values.

Any help with custom Type converters using koline serialization?

Hi, I was trying to return a multimap from a query to have a

Map<CategoryEntity, List<CategoryEntity>>

. So, making a query joining on the same table :

@Query(
    "SELECT * FROM category as parent" +
    "JOIN category as child ON parent.id = child.parent_id"
)
fun loadCategoriesAndSubCategories(): Map<CategoryEntity, List<CategoryEntity>>

It's not working because it's mapping with the column name. I tried to rename all the columns, but it doesn't work too. Someone knows if it's possible to do it ?