{"action":"created","issue":{"url":"https://api.github.com/repos/wp-cli/db-command/issues/1","repository_url":"https://api.github.com/repos/wp-cli/db-command","labels_url":"https://api.github.com/repos/wp-cli/db-command/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/wp-cli/db-command/issues/1/comments","events_url":"https://api.github.com/repos/wp-cli/db-command/issues/1/events","html_url":"https://github.com/wp-cli/db-command/issues/1","id":211237600,"number":1,"title":"Introduce `wp db size`","user":{"login":"danielbachhuber","id":36432,"avatar_url":"https://avatars2.githubusercontent.com/u/36432?v=3","gravatar_id":"","url":"https://api.github.com/users/danielbachhuber","html_url":"https://github.com/danielbachhuber","followers_url":"https://api.github.com/users/danielbachhuber/followers","following_url":"https://api.github.com/users/danielbachhuber/following{/other_user}","gists_url":"https://api.github.com/users/danielbachhuber/gists{/gist_id}","starred_url":"https://api.github.com/users/danielbachhuber/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danielbachhuber/subscriptions","organizations_url":"https://api.github.com/users/danielbachhuber/orgs","repos_url":"https://api.github.com/users/danielbachhuber/repos","events_url":"https://api.github.com/users/danielbachhuber/events{/privacy}","received_events_url":"https://api.github.com/users/danielbachhuber/received_events","type":"User","site_admin":false},"labels":[{"id":559802820,"url":"https://api.github.com/repos/wp-cli/db-command/labels/command:db","name":"command:db","color":"c5def5","default":false},{"id":608202673,"url":"https://api.github.com/repos/wp-cli/db-command/labels/command:db-size","name":"command:db-size","color":"c5def5","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":11,"created_at":"2017-03-01T23:06:29Z","updated_at":"2017-05-18T18:39:57Z","closed_at":null,"body":"Indicate the total size of the database and sizes of each table, a la https://github.com/petenelson/wp-cli-size#usage"},"comment":{"url":"https://api.github.com/repos/wp-cli/db-command/issues/comments/302505446","html_url":"https://github.com/wp-cli/db-command/issues/1#issuecomment-302505446","issue_url":"https://api.github.com/repos/wp-cli/db-command/issues/1","id":302505446,"user":{"login":"petenelson","id":1757075,"avatar_url":"https://avatars3.githubusercontent.com/u/1757075?v=3","gravatar_id":"","url":"https://api.github.com/users/petenelson","html_url":"https://github.com/petenelson","followers_url":"https://api.github.com/users/petenelson/followers","following_url":"https://api.github.com/users/petenelson/following{/other_user}","gists_url":"https://api.github.com/users/petenelson/gists{/gist_id}","starred_url":"https://api.github.com/users/petenelson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/petenelson/subscriptions","organizations_url":"https://api.github.com/users/petenelson/orgs","repos_url":"https://api.github.com/users/petenelson/repos","events_url":"https://api.github.com/users/petenelson/events{/privacy}","received_events_url":"https://api.github.com/users/petenelson/received_events","type":"User","site_admin":false},"created_at":"2017-05-18T18:39:57Z","updated_at":"2017-05-18T18:39:57Z","body":"Cool, that was there to verify that it was including tables with the standard `db size` command, but I can remove that, or perhaps switch the logic to not include tables by default.  Do you want to look over the new command before I submit a PR?  \r\n\r\nSome sample output as it's currently written:\r\n```\r\nvagrant@vvv:/srv/www/wp-cli$ ./bin/wp --path=/srv/www/wordpress-default db size\r\n+-----------------------+--------+--------+\r\n| Name                  | Size   | Bytes  |\r\n+-----------------------+--------+--------+\r\n| wp_cli_test           | 624 KB | 638976 |\r\n| wp_users              | 64 KB  | 65536  |\r\n| wp_usermeta           | 48 KB  | 49152  |\r\n| wp_posts              | 80 KB  | 81920  |\r\n| wp_comments           | 96 KB  | 98304  |\r\n| wp_links              | 32 KB  | 32768  |\r\n| wp_options            | 32 KB  | 32768  |\r\n| wp_postmeta           | 48 KB  | 49152  |\r\n| wp_terms              | 48 KB  | 49152  |\r\n| wp_term_taxonomy      | 48 KB  | 49152  |\r\n| wp_term_relationships | 32 KB  | 32768  |\r\n| wp_termmeta           | 48 KB  | 49152  |\r\n| wp_commentmeta        | 48 KB  | 49152  |\r\n+-----------------------+--------+--------+\r\n```\r\n\r\n```\r\nvagrant@vvv:/srv/www/wp-cli$ ./bin/wp --path=/srv/www/wordpress-default db size --db-only\r\n+-------------+--------+--------+\r\n| Name        | Size   | Bytes  |\r\n+-------------+--------+--------+\r\n| wp_cli_test | 624 KB | 638976 |\r\n+-------------+--------+--------+\r\n```\r\n\r\n```\r\nvagrant@vvv:/srv/www/wp-cli$ ./bin/wp --path=/srv/www/wordpress-default db size --db-only --format=bytes\r\n638976\r\n```"}}
{"actor":{"display_login":"petenelson"}}