user_skills

Function Name Operation Type Description Arguments Returns
AddSkillToUser Create (Insert) Adds a skill to a user with a specified proficiency. ctx context.Context,arg AddSkillToUserParams { UserID int64, SkillID int64, Proficiency ProficiencyLevel } UserSkill, error
GetSkillsForUser Read (Select) Retrieves all skills and proficiency levels for a specific user. ctx context.Context,userID int64 []GetSkillsForUserRow, error
GetUsersWithSkill Read (Select) Retrieves all users with a specific skill and their proficiency. ctx context.Context,skillID int64 []GetUsersWithSkillRow, error
UpdateUserSkillProficiency Update Updates a user's proficiency level for a skill. ctx context.Context,arg UpdateUserSkillProficiencyParams { UserID, SkillID, Proficiency } UserSkill, error
RemoveSkillFromUser Delete Removes a specific skill from a user. ctx context.Context,arg RemoveSkillFromUserParams { UserID int64, SkillID int64 } error