diff options
| author | Kyren223 <Kyren223@proton.me> | 2025-07-19 11:31:07 +0300 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2025-07-19 18:32:12 +0300 |
| commit | 24c0224dd90533bc962d5e1a198cdc464018176c (patch) | |
| tree | 89f2c400f8158e0ef83918f67d4aeb3867e2f799 /internal/data/members.sql.go | |
| parent | f793203e043aaa2db38823c84500e82756348ac0 (diff) | |
Changed session durations metric to classic histogram, added
last_activity to calculate monthly active users
Diffstat (limited to 'internal/data/members.sql.go')
| -rw-r--r-- | internal/data/members.sql.go | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/internal/data/members.sql.go b/internal/data/members.sql.go index 018d6a5..4ffd6ce 100644 --- a/internal/data/members.sql.go +++ b/internal/data/members.sql.go @@ -58,7 +58,7 @@ func (q *Queries) FilterUsersInNetwork(ctx context.Context, arg FilterUsersInNet const getBannedMembers = `-- name: GetBannedMembers :many SELECT - users.id, users.name, users.public_key, users.description, users.is_public_dm, users.is_deleted, + users.id, users.name, users.public_key, users.description, users.is_public_dm, users.is_deleted, users.last_activity, members.user_id, members.network_id, members.joined_at, members.is_member, members.is_admin, members.is_muted, members.is_banned, members.ban_reason FROM members JOIN users ON users.id = members.user_id @@ -86,6 +86,7 @@ func (q *Queries) GetBannedMembers(ctx context.Context, networkID snowflake.ID) &i.User.Description, &i.User.IsPublicDM, &i.User.IsDeleted, + &i.User.LastActivity, &i.Member.UserID, &i.Member.NetworkID, &i.Member.JoinedAt, @@ -136,7 +137,7 @@ func (q *Queries) GetMemberById(ctx context.Context, arg GetMemberByIdParams) (M const getNetworkMembers = `-- name: GetNetworkMembers :many SELECT - users.id, users.name, users.public_key, users.description, users.is_public_dm, users.is_deleted, + users.id, users.name, users.public_key, users.description, users.is_public_dm, users.is_deleted, users.last_activity, members.user_id, members.network_id, members.joined_at, members.is_member, members.is_admin, members.is_muted, members.is_banned, members.ban_reason FROM members JOIN users ON users.id = members.user_id @@ -164,6 +165,7 @@ func (q *Queries) GetNetworkMembers(ctx context.Context, networkID snowflake.ID) &i.User.Description, &i.User.IsPublicDM, &i.User.IsDeleted, + &i.User.LastActivity, &i.Member.UserID, &i.Member.NetworkID, &i.Member.JoinedAt, |