judell

# duckdb

with names as (
  select
    unnest(string_to_array(?, ',')) as name
),

# sqlite

WITH RECURSIVE names(name, remaining) AS (

judell

locals {
  joined_companies = join(",", local.companies)
  joined_languages = join(",", local.languages)
  joined_operating_systems = join(",", local.operating_systems)
  joined_clouds = join(",", local.clouds)
  joined_dbs = join(",", local.dbs)
  joined_editors = join(",", local.editors)
}

judell

query "mentions" {
  sql = <<EOQ
    with names as (
      select
        unnest( $1::text[] ) as name
    ),
    counts as (
      select
        name,
        (

judell

  languages = [
    "C#",
    "C\\+\\+",
    "Clojure",
    "CSS",
    "Erlang",
    "golang| go 1.| (in|with|using) go | go (.+)(compiler|template|monorepo|generic|interface|library|framework|garbage|module|range|source)",
    "Haskell",
    "HTML",
    "Java ",

judell

  container {

    chart {
      base = chart.languages_base
      width = 4
      type = "donut"
      title = "language mentions: last 24 hours"
      query = query.mentions
      args = [ local.languages, 0, 1440 ]
    }

judell

def create_calendar_weeks(year, month, grouped_events):
    cal = calendar.monthcalendar(year, month)
    calendar_weeks = []
    
    for week in cal:
        calendar_week = []
        for day in week:
            if day == 0:
                calendar_week.append((0, []))

judell

connection "all_wordpress" {
  plugin = "wordpress"
  type = "aggregator"
  connections = ["jon", "newstack"]
}

connection "jon" {
  plugin = "wordpress"
  endpoint = "https://blog.jonudell.net/wp-json/"
  username = "..."

judell

func listPosts(ctx context.Context, d *plugin.QueryData, _ *plugin.HydrateData) (interface{}, error) {
	conn, err := connect(ctx, d)
	if err != nil {
		return nil, err
	}

	plugin.Logger(ctx).Debug("WordPress listPosts author", "author", d.Quals["author"])
	plugin.Logger(ctx).Debug("WordPress listPosts date", "date", d.Quals["date"])

	options := &wordpress.PostListOptions{}

judell

type ListFunc func(context.Context, interface{}, int, int) (interface{}, *wordpress.Response, error)

func paginate(ctx context.Context, d *plugin.QueryData, listFunc ListFunc, options interface{}) error {
	perPage := 100
	offset := 0

	for {
		plugin.Logger(ctx).Debug("WordPress paginate", "offset", offset)

		// `listFunc`, the passed-in anonymous function, could call the go SDK's `Posts.List` (which wraps the API's

judell

module github.com/judell/steampipe-plugin-wordpress

go 1.21.4

require (
  github.com/sogko/go-wordpress v0.0.0-20190616154547-91556a5001c7
  github.com/turbot/steampipe-plugin-sdk/v5 v5.8.0
)

replace github.com/sogko/go-wordpress => github.com/robbiet480/go-wordpress v0.0.0-20180206201500-3b8369ffcef3