MySQL: dump posts.json from metasmoke

dump.sh

#!/bin/sh

mysql --silent --raw --user root -ppassword metasmoke -e "select json_object('id', id, 'title', title, 'body', body, 'link', link, 'post_creation_date', post_creation_date, 'created_at', created_at, 'updated_at', updated_at, 'site_id', site_id, 'user_link', user_link, 'username', username, 'why', why, 'user_reputation', user_reputation, 'score', score, 'upvote_count', upvote_count, 'downvote_count', downvote_count, 'stack_exchange_user_id', stack_exchange_user_id, 'is_tp', is_tp, 'is_fp', is_fp, 'is_naa', is_naa, 'revision_count', revision_count, 'deleted_at', deleted_at, 'smoke_detector_id', smoke_detector_id, 'autoflagged', autoflagged, 'tags', tags, 'feedbacks_count', feedbacks_count, 'native_id', native_id) from posts" >posts.json