Compare commits

..

8 commits

Author SHA1 Message Date
447c577a2a style: cargo clippy & fmt
All checks were successful
ci/woodpecker/push/build-and-publish Pipeline was successful
ci/woodpecker/push/publish-docs Pipeline was successful
2025-08-05 03:28:35 +02:00
5b24d0052b feat: return member with messages 2025-08-05 03:28:24 +02:00
8a7711cabc feat: Make me optional in Member::fetch_one() 2025-08-05 03:28:02 +02:00
4cb89645fe Merge pull request 'Member Improvements' (#44) from wip/member-improvements into main
All checks were successful
ci/woodpecker/push/publish-docs Pipeline was successful
ci/woodpecker/push/build-and-publish Pipeline was successful
Reviewed-on: #44
2025-08-05 00:09:19 +02:00
946085a18f Merge pull request 'Online status' (#43) from wip/status into main
All checks were successful
ci/woodpecker/push/build-and-publish Pipeline was successful
ci/woodpecker/push/publish-docs Pipeline was successful
Reviewed-on: #43
2025-08-04 19:22:59 +00:00
53451e67c7 fix: 4 is always bigger than 0
All checks were successful
ci/woodpecker/push/build-and-publish Pipeline was successful
ci/woodpecker/pr/build-and-publish Pipeline was successful
ci/woodpecker/pull_request_closed/build-and-publish Pipeline was successful
2025-08-04 20:52:19 +02:00
027649a060 feat: added online status
All checks were successful
ci/woodpecker/push/build-and-publish Pipeline was successful
ci/woodpecker/pr/build-and-publish Pipeline was successful
2025-08-04 20:46:49 +02:00
314b9ee011 feat: added online_status column to users table
All checks were successful
ci/woodpecker/push/build-and-publish Pipeline was successful
2025-08-04 20:07:46 +02:00
8 changed files with 82 additions and 10 deletions

View file

@ -0,0 +1,2 @@
-- This file should undo anything in `up.sql`
ALTER TABLE users DROP COLUMN online_status;

View file

@ -0,0 +1,2 @@
-- Your SQL goes here
ALTER TABLE users ADD COLUMN online_status INT2 NOT NULL DEFAULT 0;

View file

@ -49,6 +49,7 @@ struct NewInfo {
email: Option<String>,
pronouns: Option<String>,
about: Option<String>,
online_status: Option<i16>,
}
pub async fn update(
@ -110,5 +111,10 @@ pub async fn update(
.await?;
}
if let Some(online_status) = &json.online_status {
me.set_online_status(&mut conn, &app_state.cache_pool, *online_status)
.await?;
}
Ok(StatusCode::OK)
}

View file

@ -29,6 +29,7 @@ pub struct Me {
avatar: Option<String>,
pronouns: Option<String>,
about: Option<String>,
online_status: i16,
pub email: String,
pub email_verified: bool,
}
@ -277,6 +278,35 @@ impl Me {
Ok(())
}
pub async fn set_online_status(
&mut self,
conn: &mut Conn,
cache_pool: &redis::Client,
new_status: i16,
) -> Result<(), Error> {
if !(0..=4).contains(&new_status) {
return Err(Error::BadRequest("Invalid status code".to_string()));
}
self.online_status = new_status;
use users::dsl;
update(users::table)
.filter(dsl::uuid.eq(self.uuid))
.set(dsl::online_status.eq(new_status))
.execute(conn)
.await?;
if cache_pool
.get_cache_key::<User>(self.uuid.to_string())
.await
.is_ok()
{
cache_pool.del_cache_key(self.uuid.to_string()).await?
}
Ok(())
}
pub async fn friends_with(
&self,
conn: &mut Conn,

View file

@ -107,7 +107,7 @@ impl MemberBuilder {
}
}
#[derive(Serialize, Deserialize)]
#[derive(Serialize, Deserialize, Clone)]
pub struct Member {
pub uuid: Uuid,
pub nickname: Option<String>,
@ -150,14 +150,17 @@ impl Member {
pub async fn fetch_one(
conn: &mut Conn,
cache_pool: &redis::Client,
me: &Me,
me: Option<&Me>,
user_uuid: Uuid,
guild_uuid: Uuid,
) -> Result<Self, Error> {
let member: MemberBuilder;
let user: UserBuilder;
let friend: Option<Friend>;
use friends::dsl as fdsl;
use guild_members::dsl;
let (member, user, friend): (MemberBuilder, UserBuilder, Option<Friend>) =
dsl::guild_members
if let Some(me) = me {
(member, user, friend) = dsl::guild_members
.filter(dsl::guild_uuid.eq(guild_uuid))
.filter(dsl::user_uuid.eq(user_uuid))
.inner_join(users::table)
@ -174,6 +177,17 @@ impl Member {
))
.get_result(conn)
.await?;
} else {
(member, user) = dsl::guild_members
.filter(dsl::guild_uuid.eq(guild_uuid))
.filter(dsl::user_uuid.eq(user_uuid))
.inner_join(users::table)
.select((MemberBuilder::as_select(), UserBuilder::as_select()))
.get_result(conn)
.await?;
friend = None;
}
member
.build_with_parts(conn, cache_pool, user, friend)

View file

@ -1,10 +1,15 @@
use diesel::{Insertable, Queryable, Selectable};
use diesel::{ExpressionMethods, Insertable, QueryDsl, Queryable, Selectable};
use diesel_async::RunQueryDsl;
use serde::Serialize;
use uuid::Uuid;
use crate::{Conn, error::Error, schema::messages};
use crate::{
Conn,
error::Error,
schema::{channels, guilds, messages},
};
use super::User;
use super::Member;
#[derive(Clone, Queryable, Selectable, Insertable)]
#[diesel(table_name = messages)]
@ -23,7 +28,16 @@ impl MessageBuilder {
conn: &mut Conn,
cache_pool: &redis::Client,
) -> Result<Message, Error> {
let user = User::fetch_one(conn, cache_pool, self.user_uuid).await?;
use channels::dsl;
let guild_uuid = dsl::channels
.filter(dsl::uuid.eq(self.channel_uuid))
.inner_join(guilds::table)
.select(guilds::uuid)
.get_result(conn)
.await?;
let member = Member::fetch_one(conn, cache_pool, None, self.user_uuid, guild_uuid).await?;
Ok(Message {
uuid: self.uuid,
@ -31,7 +45,7 @@ impl MessageBuilder {
user_uuid: self.user_uuid,
message: self.message.clone(),
reply_to: self.reply_to,
user,
member,
})
}
}
@ -43,5 +57,5 @@ pub struct Message {
user_uuid: Uuid,
message: String,
reply_to: Option<Uuid>,
user: User,
member: Member,
}

View file

@ -18,6 +18,7 @@ pub struct UserBuilder {
avatar: Option<String>,
pronouns: Option<String>,
about: Option<String>,
online_status: i16,
}
impl UserBuilder {
@ -29,6 +30,7 @@ impl UserBuilder {
avatar: self.avatar,
pronouns: self.pronouns,
about: self.about,
online_status: self.online_status,
friends_since: None,
}
}
@ -42,6 +44,7 @@ pub struct User {
avatar: Option<String>,
pronouns: Option<String>,
about: Option<String>,
online_status: i16,
pub friends_since: Option<DateTime<Utc>>,
}

View file

@ -157,6 +157,7 @@ diesel::table! {
pronouns -> Nullable<Varchar>,
#[max_length = 200]
about -> Nullable<Varchar>,
online_status -> Int2,
}
}