Updating a Single Column In Room Database

See also questions close to this topic

• Using EdittextPreference for Goto search

  sorry for my poor English. I want to use EditTextPreference in my bottom nav like the pic below, ![screenshot][1]

  I have recycleview xml in my project with in many sub cardview layouts(which is scrollable) and I want to create item in the bottom nav which is called "Goto". When the "Goto" item is clicked i want it to pop-up like the screenshot. And when user enters a number(according to the cardviews i.e if the number of cardview is 40 user must enter 1-40) I want to search the cardview by its ID. Thank you and I hope u got it, If u have any questions let me know [1]: https://i.stack.imgur.com/grK8P.jpg

  My xml format look like this. As you see in the blow since the cardviews are huge in number it is not cool to scroll all the way down that is why i need Goto item in the bottom nav to search it by its ID when the user click number in the EditTextPreference as u see in the screenshot. i.e The screenshot is not from my app

  <LinearLayout>
   <LinearLayout>
    <androidx.cardview.widget.CardView>
      <RealtiveLayout>
         <Textview/>
      <RealtiveLayout>
   </androidx.cardview.widget.CardView>
   </LinearLayout>
  
   <LinearLayout>
    <androidx.cardview.widget.CardView>
      <RealtiveLayout>
         <Textview/>
      <RealtiveLayout>
   </androidx.cardview.widget.CardView>
   </LinearLayout>
  
  <LinearLayout>
    <androidx.cardview.widget.CardView>
      <RealtiveLayout>
         <Textview/>
      <RealtiveLayout>
   </androidx.cardview.widget.CardView>
   </LinearLayout>
  
    <LinearLayout>
    <androidx.cardview.widget.CardView>
      <RealtiveLayout>
         <Textview/>
      <RealtiveLayout>
   </androidx.cardview.widget.CardView>
   </LinearLayout>
   
    ..
    ..
  
    ..
    ..
    many more..
  
• IOS Launcher in android studio

  I'm trying to change the whole Android OS installed app icons into IOS icons, please help me with the proper code or library for android kotlin
• Kotlin Coroutines Unit Testing

  Im trying to test this suspend function:

  suspend fun <T> getResult(call: suspend () -> Response<T>): Resource<T> {
  
    val response = call()
    val body = response.body()
    val code = response.code()
  
    if (response.isSuccessful) {
  
      Log.d(Cybrid.instance.tag, "Data: ${response.code()} - ${response.body()}")
      return Resource.success(body!!, code)
  
    } else if (response.code() == HTTP_UNAUTHORIZED || response.code() == HTTP_FORBIDDEN) {
  
      Cybrid.instance.let { cybrid ->
        cybrid.listener.let {
          cybrid.invalidToken = true
          it?.onTokenExpired()
        }
      }
      Log.e(Cybrid.instance.tag, "Error - Something wrong with TOKEN : ${response.code()} ${response.message()}")
      return Resource.error(response.message(), code=response.code())
    } else {
      Log.e(Cybrid.instance.tag, "Error - Other: ${response.code()} ${response.message()} :: ${response.raw()}")
      return Resource.error(message = response.message(), data= response.body(), code= response.code())
    }
  }
  

  With this Unit Test Case, all it cover except line 13 , I dont know how to cover the line!!!

  @ExperimentalCoroutinesApi
  @Test
  fun get400ErrorServerTest() = runBlocking {
  
      Cybrid.instance.setBearer("Bearer")
      val pricesService = AppModule.getClient().createService(PricesApi::class.java)
      val result = getResult { pricesService.listPrices() }
  
      Assert.assertNotNull(result)
      Assert.assertEquals(result.code, 400)
      Assert.assertNull(result.data)
  }
  

  The coverage report says:

  

  Some idea to get coverage for line 13 ??? Thnanks
• Android ZoneDateTime.withHour always sets hour to 8

  So I am tring to schedule alarm at a particular time on current day using AlarmManager. To do that I am using ZoneDateTime to get current time and then updating it to the hour at which I need to set the alarm. But for some reason time.withHour is giving me 8pm or 8am no matter what hour I am passing to it. Am I doing something wrong here?

  var time = ZonedDateTime.now()    //getting current time at my timezone
  time = time.withHour(22).withMinute(8).withSecond(0)
  print(time)                       //getting 8am/8pm at my timezone
  val timeMilis = time.toInstant().toEpochMilli()
  
• Livedata with large dataset in Room DB - Does the whole dataset get loaded from database when onChanged() gets called?

  I have a Room entity as so:

  @Entity(tableName = "user")
  public class User {
  
      @PrimaryKey
      @ColumnInfo(name = "id")
      private int id;
  
      @ColumnInfo(name = "name")
      private String name;
  
      @ColumnInfo(name = "age")
      private int age;
  
      public User() {}
  
      public User(int id, String name, int age) {
          this.id = id;
          this.name = name;
          this.age = age;
      }
  
      public int getId() {
          return id;
      }
  
      public void setId(int id) {
          this.id = id;
      }
  
      public String getName() {
          return name;
      }
  
      public void setName(String name) {
          this.name = name;
      }
  
      public int getAge() {
          return age;
      }
  
      public void setAge(int age) {
          this.age = age;
      }
  }
  

  and ViewModel as so:

  public class MainViewModel extends AndroidViewModel {
      
      public MainViewModel(@NonNull @NotNull Application application) {
          super(application);
      }
  
      public LiveData<List<User>> fetchLiveUsers() {
          return repository.fetchUsers();
      }
      
  }
  

  and observing the LiveData as so:

  mainViewModel
          .fetchLiveUsers()
          .observe(getViewLifecycleOwner(), new Observer<List<User>>() {
              @Override
              public void onChanged(List<User> userList) {
                  if(userList != null)
                      usersAdapter.setModelsList(userList);
              }
          });
  

  When I have a large dataset of users, such as 1000+ users, and I'm observing this live data, any changes in the database will trigger the onChanged() method.

  Does this mean that each time onChanged() is called, the 1000+ users get loaded from the Room database, or does the updated user only get loaded from the database to update the current User list being observed by livedata?
• How to return multimap type with 3 tables (Android Room Databases)

  I am trying to do a 3 way JOIN in my query for my Android Room Database.

  My tables relationships are:

  1. Table1 has a 1 to 1 relationship with Table2
  2. Table2 has a 1 to many relationship with Table3 (Table3 is the many)

  I'm currently having issues with my return type on my dao method.

  I wish to use the newer method doing JOINs, which is returning a multimap instead of creating a data class defining the relationship (https://developer.android.com/training/data-storage/room/accessing-data#multimap).

  I'm not sure what the return type should be.

  I currently have Flow<Map<Table1, Pair<Table2, Table3>>> which gives me an error saying Not sure how to convert a Cursor to thsi method's return type.

  There's probably some data structure I don't know about that can let me return the data of a 3 way JOIN?