Android-room Questions

I'm considering creating a schema with both one-to-many and many-to-many elements. as i am a bit of a novice in this matter, i searched some

How do i create a query to my room database from example the sum of a database column then convert it to a string to then populate text fields in

What is the reason behind it ? is it for performance or compulsion? please explain

I'm trying to get livedata from room. so my recycleview can have live updates if anything in database is changed i have tried with out

I'm trying to save my recordings to the room database and this is almost fine, but i don't know how to create my own file path to save more than

I am using room on top of sqlite for android, and i have the following two pojo entities: @entity public class event {

I am using from room and i am using from addmigrations from 1 to 2 but say me: expected:

I have the following class: package com.mikhailovskii.trakttv.data.entity import androidx.room.entity import androidx.room.ignore

I want to display a toast only if a row is successfully been deleted from room database and also when deletion is not successful. row is

I am going to data/data/mypackage in emulator and download these three files about my apps database :

I have a two tables and i want to get one java objects. this is my table one: @primarykey(autogenerate = false)

I want to be sure that i can save data offline. how to synchronize data in room with firestore? when something inserted to room firestore must be

The application has a database with items that have columns of locations marked as integers which are displayed in a recyclerview. if any

I would know if that is possible to create a possible null reference on foreign key with room. for now my database structure is like this

I have developed one application in android using kotlin and it is available on playstore. i have used room database to store the values. i have

I use livedata to display the count of records in a table in room. i call a function that retrieves this count and upon receiving it the observer

I am using retrofit2 and rxjava2 in my android app as a networking library and nodejs and mongodb as a backend service.i want to fetch data from

I'm working with room persistance databases in android but i get this error error: type of the parameter must be a class annotated with

I'm using room and i have a method to update a line into database: @query("update packs set is_opened = 1 where pack_id in

I have updated one of my room entities to include a foreign key. i must now include this change in my data migration but unsure on the sql

I am working on room livedata databinding concept. i am setting list to spinner using custom binding adapter. but i am getting null livedata while

I follow the architecture pattern laid out in

I need to request to the server and pass data from my local database whenever the app is started again. now the problem is that when opening the

I am using paging (part of android jetpack ) to retrieve data from my room db. i wanted to fetch 50 records on each page. but

I have following database relationship:

In my dao i have this method: @query("select category, group_concat(type) as types" + "from type" + "group

Am using room persistence library for my android application i want to get last id that is generated(primary key auto generated) when i am

There must be a better way of doing this. i want to create a database table with all my clothing and have subcategories of clothing, like

My question is similar with android room: insert relation entities using room but with little

I created a room database following this

I can not install an app on my phone because i see this error : error: cannot figure out how to save this field into the

I am stuck at the conversion of json response into livedata. this can be possible using room. but i am not using room in my app.

I want to return count of rows from a certain query to my view ,i'm using view model this is my dao class:

Following some articles, i am trying to create an android app with the following: a recyclerview which fetches data from

In my mvvm app, i am extending androidviewmodel and through a repository class, i am trying to get an instance of a db (in a separate

I have an application that has a remote database(firebase) and local database(room). i get my data from firebase and save it in android room.

My project basically allows the user to create a list of products, where different products can be added. so in my case, the relation existing

What is a result of this dao method after inserting some messages in the database: @query("select * from

I am doing a map activity, on marker click, i would display the information on a textview. the information is saved in android room database

I want ask about my code. error does not show when i insert data in the database, but when i try to getall i just get empty array. i don't know

In an app i'm working on, i need to very simply fetch data from a room database. there are relations involved. everything was working perfectly

I try to build offline support for my app. here is exception error when i run the app : 2019-04-19 13:44:44.768

I'm trying to get all today's expenses divided by type (bills, food etc.) from the room database, but my query doesn't work. how to change

I trying to implement a relational database using room database in android. for example in below json how can i create a entity for

I've been following several guides most recently this one from

I have livedata for books in viewmodel's constructor: livedata<list<book>> books; public

This function is used to login the user. i am using data binding and rxjava public void loginuser(string idnumber, string

I want to get kotlin coroutnies deffered from dao @query("select * from gameprocess where cabinid = :cabinid ") fun

I am trying to save a base64 value into my sqlite database using room and for some reason it's not saving. well, i'm assuming it's not saving

I'm trying to get data from current week and month in room. i've created a current day query and it works, but the others do not work. day

So i'm using android room library to perform requests on a sqlite db. i can't make requests on the ui thread, so i'm using asynctask.

I have a component in my app that performs specific work when the database gets updated. in order to observe room table, i need to use livedata

I have two tables in room and i need to get from them two sums. i know how to get it from one table, but i can't find the solution of my problem.

I'm writing chat app. messages are load by pages (item keyed - message_id) using android paging library. also there is "reply" feature, which mean

Iam following mvvm tutorial and when adding

I'm trying to make a @query function in my @dao interface which has a boolean parameter, isasc to determine

I followed this room with a

I have this constructor... public shiftlog(string companyname, boolean workedforagent, string agentname, date

Yesterday i tested my app in some virtual devices in genymotion, and i realized some times, app sends infinite sync requests to the server on some

I keep getting this error. i am working on a project and in the middle of development, i decided to migrate to android x. i get the

When you click on the search button, it activity with a full list of items. at the top is edittext and when the user starts typing the name, the

I am currently developing a small android application and i am facing a problem about using a same typeconverters on two fields. here

I was trying to upgrade my database version and in last version the table had a unique index created upon migration room gave me the following

I created a databaseview, to join two tables. when i am doing my query, i am not being able to select from the database view table. but it can be

I was wondering if anyone found a way to use kotlins extension functions as typeconverter methods when using room database. the code

I have a simple insertion in room but for a weird reason my insertion aren't working in my app after two or three insert. there is another weird

When i launch my app, i should select start activity, depending on room data. like this: if there is no user (by login string,

Suppose we'd like to replace all items in android room db in the simplest possible way. what would be the approach to this

I'm using a custom repository to get observables for data in a room database, e.g: fun getusers():

I wrote an app that saves and uses data in/from a cloud firestore database. i would want to organize more clearly than for the moment my files,

I want to insert some data to my db in android room. the problem is, that everytime i request my data, the result is null. this is

I need when refresh page make request to api and insert getting data to my room database. but when i try to insert data i get

I have table with composite primary key. can i make one of the filed as auto generated. secenario : i have a teacher table

I have recently taken over a project that uses android's room persistence library as well as retrofit. unfortunately i am not very knowledgeable

Maybe this is a tiny bit stupid to ask but i am just stuck with this: i have my room database + entities + daos. the entities have

I would like to update some fields from table 1 to be the same as the values from another table (or even a subquery).

I have a problem with my onpostexecute() method in asynctask class. i have an

I retrieve json data that i have created and uploaded to the internet using retrofit. i can successfully retrieve and

I have a widget which i want to update every time i update my database and want to show the content from the database on the widget even when the

I have an abstract class like this: public abstract class notificationparent { @serializedname(sercons.c_notification_id)

I am trying to implement room in my android application. i am trying to get data from api and save them in local database. but when i run the

I am trying to get a map of messages, with an author id key like this: map<long, collection<message>>

My database contains a list of these "movement" class: @primarykey (autogenerate = true) private int numerodeoperacion; private

App database has items table with a column price with datatype long. db version = 1

I was working on old android studio with gradle plugin 3.2.0 with koin and room in mvvm design pattern. yesterday i had updated my android

I'm querying for a pojo using room persistance library (v2.0.0). i've all those entities in different tables (bookentries, categories,...). i'm

Where is located an app sqlite database created by room library on a device? context: i have an app which create and use

I am trying to use room for my local db and my problem is that my first screen of app show the list of devices saved in room library, but room

I am trying to save a spinner selection to an android room database, but every time i run the code, the spinner onselect listener keeps getting

I have a room database project which has a dao and a repository (mediator between different data sources) for each table in the database. it is a

I have a room database version a and need to migrate to version b. the migration will create a new table with. the table must be prepopulated a

I recently added jobscheduler to my app via a jobservice. i use the jobservice to sync with my database periodically in the background and update

I am getting a complex json from an api and i am saving the values with architect component(room).

I have bellow model: @entity(foreignkeys = @foreignkey( entity = classmodel.class, childcolumns = "classmodelid",

I have a table with two foreign key into two different tables this is my table : @entity( tablename =

I didn't find any answer to what i'm searching for so i'm sending this question. i am using room for android. i have an entity

The

I would like to update multiple rows in a room database. but i don't have the objects - i have only the ids. if i update one row i write

I need to populate an expandablelistview whose data is fetched from room database. there are answers on how to

Question i wish to add additional functionality to my project, a room based instantapp, and i'm uncertain on