I want my values in one row in my SQLITE Database to increase by 1 everyday at Midnight or every 24 hrs its in the Database

Question

I have a Database that has a row that needs to increase by 1 every 24 hours. I enter "19" that first day. Either at midnight or 24 hours Later I would like that value to Change to "20". Is there a way to do that?

Your help would be Appreciated. Thanks

score 1 · Answer 1 · edited May 23 '17 at 11:49

1

You can create a trigger in SQLite or you can have AlarmManager in JAVA.
For trigger you can visit SQLite trigger
For AlarmManager you can visit Alarm Manager Example

edited May 23 '17 at 11:49

Community

1
1

answered Sep 17 '13 at 04:30

Krrishnaaaa

689
11
23

score 1 · Answer 2 · answered Sep 17 '13 at 04:30

1

There are no computed columns in SQLite, and on the Android platform you can't rely on a background process. But all you have to do is add a date column "created" along with your value. Each time you query, add the day difference between now and "created" to the original column to get the value you need.

SELECT [myval] + julianday(Date('now')) - julianday([created])) FROM mytable

answered Sep 17 '13 at 04:30

McGarnagle

101,349
31
229
260

Would Insert that command into onCreate(SQLiteDatabase db)? If not would section of the database class would insert that command? – BAlvernaz Sep 17 '13 at 04:55
1

+1 That would also be my approach. Note that you can have computed columns in views! – LS_ᴅᴇᴠ Sep 17 '13 at 07:47

I want my values in one row in my SQLITE Database to increase by 1 everyday at Midnight or every 24 hrs its in the Database

2 Answers2