How to use Joda DateTime date as id in Room, or how to get date in query?

Question

I need to write an app that uses date as id, and I must be able to update just by comparing date

@Entity
data class DailyCount(@PrimaryKey
                  var date:DateTime,
                  var summ: Double = 0.0)

And here is the DAO

@Query("update DailyCount set summ = :sum where date = :today")
fun updateCash(today: DateTime, sum: Double)

I want to make like this :

@Entity
data class DailyCount(@PrimaryKey
                  var date:Date,//JodaTime containing only date
                  var summ: Double = 0.0)

Or like this:

@Query("update DailyCount set summ = :sum where date.today = :dateArg.today")
fun updateCash(dateArg: DateTime, sum: Double)

score 3 · Answer 1 · answered May 09 '19 at 04:38

3

Room doesn't know how to save your primary field DateTime into database.

You need to write a TypeConverter.

public class TypeConverter {
    private static Gson gson = new Gson();

    @TypeConverter
    public static DateTime stringToDate(String data) {

        Type type = new TypeToken<DateTime>() {
        }.getType();

        return gson.fromJson(data, type);
    }

    @TypeConverter
    public static String dateToString(DateTime dateTime) {
        return gson.toJson(dateTime);
    }
}

Then annotate your primary key

@PrimaryKey
@TypeConverters(TypeConverter::class.java)
var date:DateTime

answered May 09 '19 at 04:38

shb

5,957
2
15
32

question is not about it. I already made TypeConverter. but reather about getting type of DateTime Date in querry – Nurseyit Tursunkulov May 09 '19 at 06:02
Then can try converting date to long (milliseconds) instead of string – shb May 09 '19 at 06:52

score 0 · Accepted Answer · edited May 09 '19 at 19:16

0

I was needed to write this query :

@Query("update DailyCount set summ = :sum where date between  :startTimeOfDay and :endTimeOfDay")
fun updateCash(startTimeOfDay: DateTime, endTimeOfDay: DateTime, sum: Double)

I gave here a range with start and end time. This approach returns true when I want to set info in today's Id

edited May 09 '19 at 19:16

marc_s

732,580
175
1,330
1,459

answered May 09 '19 at 06:43

Nurseyit Tursunkulov

8,012
12
44
78

How to use Joda DateTime date as id in Room, or how to get date in query?

2 Answers2

Linked