Verifies if a user is in an organization This function checks if the user is a member of the specified organisation. # Arguments `user_id` - The ID

Checks if an application exists for a given campaign and user. # Arguments `campaign_id` - ID of the campaign to check `user_id` - ID of the user to

Checks if an application exists for a given campaign and user. # Arguments `campaign_id` - ID of the campaign to check `user` - The authenticated us

Checks if a campaign slug is available. This handler allows organisation admins to check slug availability. # Arguments `organisation_id` - The ID

Checks if an organisation slug is available. This handler allows super users to check slug availability. # Arguments `state` - The application stat

Checks if a slug is available for a new campaign. # Arguments `organisation_id` - ID of the organization creating the campaign `slug` - Slug to chec

Checks if a slug is available for use. # Arguments `slug` - The slug to check `pool` - A reference to the database connection pool # Returns Returns

Returns a presigned GET URL for the banner object at `/banner/{campaign_id}/{cover_image}`, if any.

Creates a new role in a campaign. # Arguments `campaign_id` - The ID of the campaign to create the role in `role_data` - The data for the new role `t

Creates a new comment for an application. # Arguments `body` - The comment body. `author_id` - The authenticated user creating the comment. `applicat

Creates a new application in the system. # Arguments `campaign_id` - ID of the campaign to apply to `user_id` - ID of the user submitting the applic

Creates a new offer. # Arguments `campaign_id` - The ID of the campaign `application_id` - The ID of the application `email_template_id` - The ID of

Creates a new answer. # Arguments `application_id` - ID of the application this answer belongs to `question_id` - ID of the question being answered

Creates a new organisation. # Arguments `admin_id` - The ID of the user who will be the initial administrator `slug` - The URL-friendly identifier fo

Creates a new answer for an application. This handler allows application owners to create answers for their application. The application must be open

Creates a new organisation. This handler allows super users to create new organisations. # Arguments `state` - The application state `_user` - The

Creates a new rating with comment and category scores. Done this by calling 2 functions in models to first create application_rating first with commen

Creates a new question for a campaign. This handler allows campaign admins to create questions. # Arguments `state` - The application state `campai

Creates a new application for a campaign. This handler allows authenticated users to apply to open campaigns. # Arguments `state` - The application

Creates a new application rating in ApplicationRating WITHOUT numerical rating score Ensures that the application rating must be unique for rater_id a

Creates availability slots in bulk for a given user-campaign. Designed to create in bulk to avoid multiple calls to the database # Arguments `availab

Creates a new campaign for an organisation. This handler allows organisation admins to create campaigns. # Arguments `id` - The ID of the organisat

Creates a new category for a campaign for rating # Arguments `new_category` - The category name that is created `campaign_id` - Campaign that is addi

Creates a new rating category for a campaign. # Arguments `state` - The application state `campaign_id` - The ID of the campaign `_admin` - The auth

Creates an ENTIRELY new application category rating in ApplicationCategoryRating WITH numerical rating score Ensures that the application category rat

Creates a new category rating for an existing application rating. # Arguments `rating_id` - The ID of the application rating `_admin` - The authenti

Creates a new comment on an application. # Arguments `state` - Application state (includes snowflake generator). `application_id` - ID of the applica

Creates a new email template for an organisation. This handler allows organisation admins to create email templates. # Arguments `id` - The ID of t

Creates a new offer for an application. This handler allows campaign admins to create offers for applications. # Arguments `id` - The ID of the cam

Creates a new application if it doesn't exist, otherwise returns the existing application ID. # Arguments `campaign_id` - ID of the campaign to appl

Creates a new application if it doesn't exist, otherwise returns the existing application ID. # Arguments `campaign_id` - ID of the campaign to appl

Creates or updates multiple attachments for a campaign. If an attachment already exists for the campaign, it will be updated. Otherwise, a new attach

Creates a new rating for an application with comment and category scores. This handler allows application reviewers to create ratings. First creates

Creates a new role in the campaign. Returns BadRequest if campaign is published.

Creates a new role in a campaign. This handler allows campaign admins to create new roles. # Arguments `transaction` - Database transaction `state`

Creates a User, This should only used for database seeding

Creates an ID for a user-campaign availability pair # Arguments `user_id` - ID of the interviewer `campaign_id` - ID of the campaign in which the use

Deletes an existing comment. The delete is scoped to both the comment ID and the author, so users can only delete their own comments. # Arguments `i

Deletes a campaign. # Arguments `id` - ID of the campaign to delete `transaction` - Database transaction to use # Returns `Result<(), ChaosError>`

Deletes an offer. # Arguments `id` - The ID of the offer to delete `transaction` - A mutable reference to the database transaction # Returns Returns

Deletes an answer. # Arguments `id` - ID of the answer to delete `transaction` - Database transaction to use # Returns `Result<(), ChaosError>` -

Deletes an organisation. # Arguments `id` - The ID of the organisation to delete `pool` - A reference to the database connection pool # Returns Retu

Deletes an email template. # Arguments `id` - The ID of the template to delete `pool` - A reference to the database connection pool # Returns Return

Deletes a role. This handler allows role admins to delete roles. # Arguments `state` - The application state `id` - The ID of the role to delete `_

Deletes a campaign. This handler allows campaign admins to delete campaigns. # Arguments `transaction` - Database transaction `id` - The ID of the

Deletes an offer. This handler allows offer admins to delete offers. # Arguments `transaction` - Database transaction `id` - The ID of the offer to

Deletes an answer. This handler allows answer owners to delete their answers. The application must be open and not already submitted. # Arguments `