Changeset 598 in code for trunk/db_sqlite.go

Timestamp:

Oct 5, 2021, 9:10:48 AM (4 years ago)

Author:

contact

Message:

db_sqlite: fix realname not fetched in ListUsers

This fixes per-user realname not being used on bouncer startup.

File:

• trunk/db_sqlite.go (modified) (2 diffs)

trunk/db_sqlite.go

@@ -217 +217 @@
         defer db.lock.RUnlock()
 
-        rows, err := db.db.Query("SELECT id, username, password, admin FROM User")
+        rows, err := db.db.Query("SELECT id, username, password, admin, realname FROM User")
         if err != nil {
                 return nil, err
@@ -226 +226 @@
         for rows.Next() {
                 var user User
-                var password sql.NullString
-                if err := rows.Scan(&user.ID, &user.Username, &password, &user.Admin); err != nil {
+                var password, realname sql.NullString
+                if err := rows.Scan(&user.ID, &user.Username, &password, &user.Admin, &realname); err != nil {
                         return nil, err
                 }
                 user.Password = password.String
+                user.Realname = realname.String
                 users = append(users, user)
         }