struct

FruitJokes::JokeRepository

Constructors

new(db : DB::Database)

count_current_month

Get the count of jokes created in the current month

count_previous_month

Get the count of jokes created in the previous month

create(setup : String, punchline : String, fruit : String, comedian_id : Int64) : Int64

Create a new joke

delete(id : Int64) : Nil

Delete a joke

find(id : Int64) : JokeDetailRow | Nil

Find a joke by ID

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

Get the most recent jokes

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

Get a paginated list of jokes with comedian names

month_over_month_delta

Get the delta between current month and previous month

total_count

Get the total count of jokes

unique_fruits

Get all unique fruits from jokes

update(id : Int64, setup : String, punchline : String, fruit : String, comedian_id : Int64) : Nil

Update an existing joke