helper script for running jobs

1 files changed, 86 insertions, 0 deletions

diff --git a/please b/please
new file mode 100755
index 0000000..c5541b5
--- /dev/null
+++ b/please
@@ -0,0 +1,86 @@
+#!/usr/bin/env python3
+"""
+Helper script for running Sandcrawler (journal pipeline) tasks in production.
+
+This is basically a Makefile. Be sure to only use python3 standard library
+modules, so there are no dependencies.
+"""
+
+import sys
+import argparse
+import subprocess
+from datetime import datetime
+
+HDFS_OUT_DIR = "/user/bnewbold/sandcrawler/out"
+HBASE_HOST = "wbgrp-svc263.us.archive.org"
+
+def run_backfill(args):
+    output = "hdfs://{}/{}/{}-backfill".format(
+        HDFS_OUT_DIR,
+        args.env,
+        datetime.strftime(datetime.now(), "%Y-%m-%d-%H:%M:%S"))
+    cmd = """hadoop jar \
+        scalding/target/scala-2.11/sandcrawler-assembly-0.2.0-SNAPSHOT.jar \
+        com.twitter.scalding.Tool sandcrawler.HBaseRowCountJob --hdfs \
+        --app.conf.path scalding/ia_cluster.conf \
+        --output hdfs://{}""".format(output)
+
+
+    cmd = """cd mapreduce;
+        pipenv shell
+        export VENVSHORT=`basename $VIRTUAL_ENV`
+        ./backfill_hbase_from_cdx.py \
+            --hbase-host {HBASE_HOST} \
+            --hbase-table wbgrp-journal-extract-0-{args.env} \
+            -r hadoop \
+            -c mrjob.conf \
+            --archive $VENVSHORT.tar.gz#venv \
+            {args.input_cdx}
+            """.format()
+    subprocess.call(cmd, shell=True)
+
+def run_rowcount(args):
+    output = "hdfs://{}/{}/{}-rowcount".format(
+        HDFS_OUT_DIR,
+        args.env,
+        datetime.strftime(datetime.now(), "%Y-%m-%d-%H:%M:%S"))
+    cmd = """hadoop jar \
+        scalding/target/scala-2.11/sandcrawler-assembly-0.2.0-SNAPSHOT.jar \
+        com.twitter.scalding.Tool sandcrawler.HBaseRowCountJob --hdfs \
+        --app.conf.path scalding/ia_cluster.conf \
+        --output hdfs://{}""".format(output)
+    subprocess.call(cmd, shell=True)
+
+def main():
+    parser = argparse.ArgumentParser()
+
+    parser.add_argument('--prod',
+        help="run against prod HBase table",
+        action='store_true')
+    parser.add_argument('--qa',
+        help="run against qa HBase table",
+        action='store_true')
+    subparsers = parser.add_subparsers()
+
+    sub_backfill = subparsers.add_parser('backfill')
+    sub_backfill.set_defaults(func=run_backfill)
+    sub_backfill.add_argument('input_cdx',
+        help="full HDFS path of CDX file to backfill")
+
+    sub_rowcount = subparsers.add_parser('row-count')
+    sub_rowcount.set_defaults(func=run_rowcount)
+
+    args = parser.parse_args()
+    if not args.__dict__.get("func"):
+        print("tell me what to do! (try --help)")
+        sys.exit(-1)
+    if not (args.prod or args.qa) or (args.prod and args.qa):
+        print("must pass one of --prod or --qa")
+    if args.prod:
+        args.env = "prod"
+    if args.qa:
+        args.env = "qa"
+    args.func(args)
+
+if __name__ == '__main__':
+    main()