diff options
| author | gennyble <gen@nyble.dev> | 2025-02-16 16:45:30 -0600 |
|---|---|---|
| committer | gennyble <gen@nyble.dev> | 2025-02-16 16:45:30 -0600 |
| commit | 8f882903748f187565a2894106c33cdbf0862998 (patch) | |
| tree | a751f7b9c388864d99b270658bfa70df737d0bdb /src/db.rs | |
| parent | 0c5986851dee23e09751ae594d8a43a84a0dab61 (diff) | |
| download | awake-8f882903748f187565a2894106c33cdbf0862998.tar.gz awake-8f882903748f187565a2894106c33cdbf0862998.zip | |
statistics work better :)
Diffstat (limited to 'src/db.rs')
| -rw-r--r-- | src/db.rs | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/db.rs b/src/db.rs index 6edeba1..d0a2c7d 100644 --- a/src/db.rs +++ b/src/db.rs @@ -59,7 +59,7 @@ impl Database { pub fn get_last_n_host_meminfo(&self, count: usize) -> Vec<DbMeminfo> { let conn = self.conn.lock().unwrap(); let mut stmt = conn - .prepare("SELECT * FROM stats_hostmem ORDER BY stamp ASC LIMIT ?1") + .prepare("SELECT * FROM stats_hostmem ORDER BY stamp DESC LIMIT ?1") .unwrap(); stmt.query_map(params![count], |row| { @@ -82,7 +82,7 @@ impl Database { ) -> Vec<DbMeminfo> { let conn = self.conn.lock().unwrap(); let mut stmt = conn - .prepare("SELECT * FROM stats_hostmem WHERE stamp > ?1 AND stamp < ?2 ORDER BY stamp ASC LIMIT ?3") + .prepare("SELECT * FROM stats_hostmem WHERE stamp > ?1 AND stamp < ?2 ORDER BY stamp DESC LIMIT ?3") .unwrap(); stmt.query_map(params![since, until, count], |row| { @@ -110,7 +110,7 @@ impl Database { pub fn get_last_n_hostnet(&self, count: usize) -> Vec<DbNetinfo> { let conn = self.conn.lock().unwrap(); let mut stmt = conn - .prepare("SELECT * FROM stats_hostnet ORDER BY stamp ASC LIMIT ?1") + .prepare("SELECT * FROM stats_hostnet ORDER BY stamp DESC LIMIT ?1") .unwrap(); stmt.query_map(params![count], |row| { |