steup-dxl.sh

#! /usr/bin/env bash

####
# Configuration
####

# Set me to the path of dart-cli you want to use
export DARTCLI=~/Downloads/dart-cli-1.0.0-alpha.2/bin/dart-cli;

# Specify mysql instance details you want to load up
export DBUSER='root';
export DBPASSWORD='root';
export DBHOST='localhost';

# The below gets all the data, loads up your mysql 
curl https://s3.amazonaws.com/data.mongodb.parts/dxl-oltpbench-data-04172018.zip \
  -o dxl-oltpbench-data-04172018.zip;

mkdir dxl-data;
unzip dxl-oltpbench-data-04172018.zip -d dxl-data;

cd dxl-data;

curl https://s3.amazonaws.com/data.mongodb.parts/wikipedia/mysql-data.sql \
  -o wikipedia/mysql-data.sql;

curl https://s3.amazonaws.com/data.mongodb.parts/auctionmark/mysql-data.sql \
  -o auctionmark/mysql-data.sql;

curl https://s3.amazonaws.com/data.mongodb.parts/tatp/mysql-data.sql \
  -o tatp/mysql-data.sql;


mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "auctionmark/mysql-ddl.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "auctionmark/mysql-data.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "epinions/mysql-ddl.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "epinions/mysql-data.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "seats/mysql-ddl.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "seats/mysql-data.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "smallbank/mysql-ddl.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "smallbank/mysql-data.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "tatp/mysql-ddl.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "tatp/mysql-data.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "tpcc/mysql-ddl.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "tpcc/mysql-data.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "tpch/mysql-ddl.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "tpch/mysql-data.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "twitter/mysql-ddl.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "twitter/mysql-data.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "voter/mysql-ddl.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "voter/mysql-data.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "wikipedia/mysql-ddl.sql";
mysql -h $DBHOST --user=$DBUSER --password=$DBPASSWORD < "wikipedia/mysql-data.sql";