From 0cf0870889d65f5d11d0b2c8af7bca9442a7ba19 Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期一, 21 四月 2025 17:14:50 +0800
Subject: [PATCH] Merge branch 'master' of http://47.96.225.205:8888/r/FirstApp2
---
app/src/main/java/com/example/firstapp/model/DailyStat.kt | 14 +++++++++-----
1 files changed, 9 insertions(+), 5 deletions(-)
diff --git a/app/src/main/java/com/example/firstapp/model/DailyStat.kt b/app/src/main/java/com/example/firstapp/model/DailyStat.kt
index dc61551..1ff696f 100644
--- a/app/src/main/java/com/example/firstapp/model/DailyStat.kt
+++ b/app/src/main/java/com/example/firstapp/model/DailyStat.kt
@@ -1,16 +1,20 @@
package com.example.firstapp.model
import androidx.room.DatabaseView
+import androidx.room.ColumnInfo
+import androidx.room.Ignore
@DatabaseView(
"""
- SELECT date(receivedTime/1000, 'unixepoch', 'localtime') as date,
+ SELECT substr(createTime, 1, 10) as date,
COUNT(*) as count
- FROM packages
- GROUP BY date(receivedTime/1000, 'unixepoch', 'localtime')
+ FROM code
+ GROUP BY substr(createTime, 1, 10)
"""
)
data class DailyStat(
val date: String,
- val count: Int
-)
\ No newline at end of file
+ val count: Int,
+ @ColumnInfo(name = "weekStart")
+ val weekStart: String? = null
+)
\ No newline at end of file
--
Gitblit v1.9.3