sources.sp

dashboard "Sources" {

  tags = {
    service = "Hacker News"
  }

  container {
    
    text {
      width = 6
      value = <<EOT
[Home](http://${local.host}:9194/hackernews.dashboard.Home)
🞄
[People](http://${local.host}:9194/hackernews.dashboard.People)
🞄
[Posts](http://${local.host}:9194/hackernews.dashboard.Posts)
🞄
[Repos](http://${local.host}:9194/hackernews.dashboard.Repos)
🞄
[Search](http://${local.host}:9194/hackernews.dashboard.Search)
🞄
Sources
🞄
[Submissions](http://${local.host}:9194/hackernews.dashboard.Submissions?input.hn_user=none)
🞄
[Urls](http://${local.host}:9194/hackernews.dashboard.Urls)
      EOT
    }

  }


  table {
    width = 6
    query = query.domains
    column "domain" {
      href = "http://${local.host}:9194/hackernews.dashboard.Sources?input.domain={{.'domain'}}"
    }    
  }

  container {
    width = 6

    container  {
      
      container {
      
        input "domain" {
          width = 6
          placeholder = "search or choose domain"
          sql = <<EOQ
            with domains as (
              select distinct
                substring(url from 'http[s]*://([^/$]+)') as domain
              from
                hn_items_all
            )
            select
              domain as label,
              domain as value
            from
              domains
            where
              domain is not null
            order by
              domain
          EOQ    
        }

        text "source_examples" {
          width = 6
          value = <<EOT
Examples: 
[www.nytimes.com](http://${local.host}:9194/hackernews.dashboard.Sources?input.domain=www.nytimes.com),
[github.com](http://${local.host}:9194/hackernews.dashboard.Sources?input.domain=github.com),
[simonwillison.net](http://${local.host}:9194/hackernews.dashboard.Sources?input.domain=simonwillison.net)
        EOT
        }

      }

      chart {
        args = [
          self.input.domain
        ]
        query = query.domain_detail
        axes {
          y {
            title {
              value = "stories"
            }
          }
        }
      }

      table {
        args = [ self.input.domain  ]
        query = query.source_detail
        column "link" {
          href = "https://news.ycombinator.com/item?id={{.'link'}}"
        }
        column "url" {
          wrap = "all"
        } 
        column "title" {
          wrap = "all"
        } 
      }

    }

  }

}