struct

FruitJokes::ComedianRepository

Constructors

new(db : DB::Database)

count_current_month

Get the count of comedians created in the current month

count_previous_month

Get the count of comedians created in the previous month

create(name : String, specialty : String) : Int64

Create a new comedian

delete(id : Int64) : Nil

Delete a comedian

find(id : Int64) : SingleComedianRow | Nil

Find a comedian by ID

latest(limit : Int32 = 10) : Array(ComedianRow)

Get the most recent comedians with their joke counts

list(page : Int32 = 1, per_page : Int32 = 10) : Tuple(Array(ComedianRow), PaginationData)

Get a paginated list of comedians

list_by_specialty(specialty : String, page : Int32 = 1, per_page : Int32 = 10) : Tuple(Array(ComedianRow), PaginationData)

Get a paginated list of comedians filtered by specialty

month_over_month_delta

Get the delta between current month and previous month

total_count

Get the total count of comedians

total_count_by_specialty(specialty : String) : Int64

Get the total count of comedians filtered by specialty

unique_specialties

Get all unique specialties from comedians

update(id : Int64, name : String, specialty : String) : Nil

Update an existing comedian