I have a script that crawls through a directory and pulls info from WP sites and builds a JSON array of objects that will eventually be fed into a visual dashboard. The script works perfectly but I can't seem to get the siteurl key to post in every object as it does in the first.

The key-pairs that have null need to be replaced with the corresponding siteurl within its array.

I feel I should be able to do this with jq and the --arg name value option but I clearly am doing something wrong. Not sure if I'm not passing the variables correctly or if it's an issue with WPCLI.

Output and script are below.

[
  {
    "eventType": "WordpressSite",
    "siteurl": "http://mytest1.com"
  },
  {
    "eventType": "WordpressPlugin",
    "plugin_name": "akismet",
    "plugin_status": "inactive",
    "plugin_update": "available",
    "plugin_version": "4.0.8",
    "siteurl": null
  },
  {
    "eventType": "WordpressPlugin",
    "plugin_name": "hello",
    "plugin_status": "inactive",
    "plugin_update": "none",
    "plugin_version": "1.7",
    "siteurl": null
  },
  {
    "eventType": "WordpressUser",
    "siteurl": null,
    "user_email": "example.user@email.com",
    "user_name": "testuser1",
    "user_registered": "2018-11-26 17:44:09",
    "user_role": "administrator"
  }
]
[
  {
    "eventType": "WordpressSite",
    "siteurl": "http://mytest2.com"
  },
  {
    "eventType": "WordpressPlugin",
    "plugin_name": "akismet",
    "plugin_status": "inactive",
    "plugin_update": "available",
    "plugin_version": "4.0.8",
    "siteurl": null
  },
  {
    "eventType": "WordpressPlugin",
    "plugin_name": "hello",
    "plugin_status": "inactive",
    "plugin_update": "none",
    "plugin_version": "1.7",
    "siteurl": null
  },
  {
    "eventType": "WordpressUser",
    "siteurl": null,
    "user_email": "example.user@email.com",
    "user_name": "testuser2",
    "user_registered": "2018-11-26 17:44:04",
    "user_role": "administrator"
  }
]

#!/bin/bash

#for d in /var/www/* ; do
#   echo "$d"
#done

for f in /var/www/*/public_html/; do
    if [[ -d $f ]]; then
                #echo "$f"

                cd $f;
                siteurl=$(wp option get siteurl)
                users=$(wp user list --fields=display_name,user_email,user_registered,roles --format=json | jq '.[] | .eventType = "WordpressUser"' | jq . --arg siteurl $(wp option get siteurl) | jq '. + {"user_name": .display_name, "user_role": .roles, "siteurl": ."$siteurl"} | del (.display_name, .roles)')
                plugins=$(wp plugin list --format=json | jq '.[] | .eventType = "WordpressPlugin"' | jq '. + {"plugin_name": .name, "plugin_status": .status, "plugin_version": .version, "plugin_update": .update, "siteurl": ."$siteurl"} | del(.name, .status, .version, .update)')


                {
                printf '{"eventType":"WordpressSite","siteurl":"%s"}\n' "$(wp option get siteurl)"
                echo "$plugins"
                echo "$users"
                } | jq -sS .
                cd ../..;
    fi
done

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.