From 24c0224dd90533bc962d5e1a198cdc464018176c Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sat, 19 Jul 2025 11:31:07 +0300 Subject: Changed session durations metric to classic histogram, added last_activity to calculate monthly active users --- internal/data/members.sql.go | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'internal/data/members.sql.go') 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, -- cgit v1.3.1