scripts/migrate/dump-thing.sh

   1 #!/bin/bash
   2
   3 set -x
   4 set -e
   5
   6 THING=$1
   7
   8 cat <<DUMP_THING | ./run-query.sh
   9 SET enable_bitmapscan=false;
  10
  11 \\copy (SELECT thing_id, ups, downs, deleted, spam, EXTRACT(epoch FROM date) FROM reddit_thing_$THING) to 'input/$THING.dump';
  12 DUMP_THING
  13
  14 cat <<DUMP_THINGDATA | ./run-query.sh
  15 SET enable_bitmapscan=false;
  16
  17 \\copy (SELECT thing_id, key, value FROM reddit_data_$THING WHERE key IN ('author_id', 'reported', 'sr_id', 'url', 'verdict', 'link_id')) to 'input/$THING-data.dump';
  18 DUMP_THINGDATA