diff options
Diffstat (limited to 'internal/store/users.go')
| -rw-r--r-- | internal/store/users.go | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/internal/store/users.go b/internal/store/users.go index 0c47c24..3edc7a9 100644 --- a/internal/store/users.go +++ b/internal/store/users.go @@ -90,13 +90,14 @@ func (s *Store) DeleteUser(ctx context.Context, id int64) error { // UserWithBlog is a row for the admin overview. type UserWithBlog struct { User - BlogID *int64 - Subdomain *string + BlogID *int64 + Subdomain *string + MaxUploadBytes int64 // 0 = server default } func (s *Store) ListUsers(ctx context.Context) ([]UserWithBlog, error) { rows, err := s.db.Query(ctx, `SELECT u.id, u.username, u.password_hash, u.role, u.disabled, u.token_version, u.created_at, - b.id, b.subdomain + b.id, b.subdomain, COALESCE(b.max_upload_bytes, 0) FROM users u LEFT JOIN blogs b ON b.owner_id = u.id ORDER BY u.role, u.username`) if err != nil { @@ -107,7 +108,7 @@ func (s *Store) ListUsers(ctx context.Context) ([]UserWithBlog, error) { for rows.Next() { var r UserWithBlog if err := rows.Scan(&r.ID, &r.Username, &r.PasswordHash, &r.Role, &r.Disabled, &r.TokenVersion, &r.CreatedAt, - &r.BlogID, &r.Subdomain); err != nil { + &r.BlogID, &r.Subdomain, &r.MaxUploadBytes); err != nil { return nil, err } out = append(out, r) |