module main

import time

// now only for commits
struct FeedItem {
    id          int
    author_name string
    created_at  time.Time
    repo_name   string
    repo_owner  string
    branch_name string
    message     string
}

const feed_items_per_page = 30

fn (mut app App) build_user_feed_as_page(user_id int, offset int) []FeedItem {
    mut feed := []FeedItem{}
    repo_ids := app.find_watching_repo_ids(user_id)
    if repo_ids.len == 0 {
        return []
    }
    where_repo_ids := repo_ids.map(it.str()).join(', ')

    commits := db_exec_values(app.db, '
        select author, hash, created_at, repo_id, branch_id, message from ${sql_table('Commit')}
            where repo_id in (${where_repo_ids}) order by created_at desc
            limit ${feed_items_per_page} offset ${offset}') or {
        return []
    }
    mut item_id := 0

    println(commits)

    for commit in commits {
        vals := commit
        author_name := vals[0]
        commit_hash := vals[1]
        created_at_unix := vals[2].int()
        repo_id := vals[3].int()
        branch_id := vals[4].int()
        commit_message := vals[5]

        repo := app.find_repo_by_id(repo_id) or { continue }
        repo_owner := app.get_username_by_id(repo.user_id) or { '' }
        branch := app.find_repo_branch_by_id(repo_id, branch_id)
        created_at := time.unix(created_at_unix)

        item := FeedItem{
            id:          item_id++
            author_name: author_name
            created_at:  created_at
            repo_name:   repo.name
            repo_owner:  repo_owner
            branch_name: branch.name
            message:     '${commit_message} (${commit_hash})'
        }

        feed << item
    }

    return feed
}

fn (mut app App) get_feed_items_count(user_id int) int {
    repo_ids := app.find_watching_repo_ids(user_id)
    if repo_ids.len == 0 {
        return 0
    }
    where_repo_ids := repo_ids.map(it.str()).join(', ')

    count_result := db_exec_values(app.db,
        'select count(id) from ${sql_table('Commit')} where repo_id in (${where_repo_ids})') or {
        return 0
    }

    return count_result.first().first().int()
}