Changeset 607 in code for trunk/db_sqlite.go

Timestamp:

Oct 5, 2021, 5:31:06 PM (4 years ago)

Author:

contact

Message:

Add DB stats

File:

• trunk/db_sqlite.go (modified) (1 diff)

trunk/db_sqlite.go

@@ -206 +206 @@
 }
 
+func (db *SqliteDB) Stats() (*DatabaseStats, error) {
+        db.lock.RLock()
+        defer db.lock.RUnlock()
+
+        var stats DatabaseStats
+        row := db.db.QueryRow(`SELECT
+                (SELECT COUNT(*) FROM User) AS users,
+                (SELECT COUNT(*) FROM Network) AS networks,
+                (SELECT COUNT(*) FROM Channel) AS channels`)
+        if err := row.Scan(&stats.Users, &stats.Networks, &stats.Channels); err != nil {
+                return nil, err
+        }
+
+        return &stats, nil
+}
+
 func toNullString(s string) sql.NullString {
         return sql.NullString{