module main

import time

struct Activity {
mut:
    id         int @[primary; sql: serial]
    user_id    int
    name       string
    created_at time.Time
}

fn (app App) add_activity(user_id int, name string) ! {
    activity := Activity{
        user_id:    user_id
        name:       name
        created_at: time.now()
    }

    sql app.db {
        insert activity into Activity
    }!
}

fn (mut app App) find_activities(user_id int) []Activity {
    return sql app.db {
        select from Activity where user_id == user_id order by created_at desc
    } or { []Activity{} }
}

fn (mut app App) has_activity(user_id int, name string) bool {
    activity_count := sql app.db {
        select count from Activity where user_id == user_id && name == name
    } or { 0 }

    return activity_count > 0
}