#!/bin/bash

id=$1
name=$2
mkdir /mnt/dump/$name
chown mysql.mysql /mnt/dump/$name
out_dir=/mnt/dump/$name

echo select \* from spaces  where id=\'$id\' INTO OUTFILE \'$out_dir/spaces.txt\' FIELDS TERMINATED BY \',\' OPTIONALLY ENCLOSED BY \'\"\' LINES TERMINATED BY \'\\n\' |mysql breakout_production
echo select \* from space_tools  where space_id=\'$id\' INTO OUTFILE \'$out_dir/space_tools.txt\' FIELDS TERMINATED BY \',\' OPTIONALLY ENCLOSED BY \'\"\' LINES TERMINATED BY \'\\n\' |mysql breakout_production
echo select \* from tickets  where space_id=\'$id\' INTO OUTFILE \'$out_dir/tickets.txt\' FIELDS TERMINATED BY \',\' OPTIONALLY ENCLOSED BY \'\"\' LINES TERMINATED BY \'\\n\' |mysql breakout_production
echo select \* from ticket_reports  where space_id=\'$id\' INTO OUTFILE \'$out_dir/ticket_reports.txt\' FIELDS TERMINATED BY \',\' OPTIONALLY ENCLOSED BY \'\"\' LINES TERMINATED BY \'\\n\' |mysql breakout_production
echo select \* from ticket_comments  where ticket_id in \(select id from tickets where space_id=\'$id\'\) INTO OUTFILE \'$out_dir/ticket_comments.txt\' FIELDS TERMINATED BY \',\' OPTIONALLY ENCLOSED BY \'\"\' LINES TERMINATED BY \'\\n\' |mysql breakout_production
echo select \* from milestones  where space_id=\'$id\' INTO OUTFILE \'$out_dir/milestones.txt\' FIELDS TERMINATED BY \',\' OPTIONALLY ENCLOSED BY \'\"\' LINES TERMINATED BY \'\\n\' |mysql breakout_production