Skip to content

Instantly share code, notes, and snippets.

@acmiyaguchi
Created May 28, 2020 22:18
Show Gist options
  • Select an option

  • Save acmiyaguchi/c6b7f7ccb803ff29c3fcecfe19dc3b51 to your computer and use it in GitHub Desktop.

Select an option

Save acmiyaguchi/c6b7f7ccb803ff29c3fcecfe19dc3b51 to your computer and use it in GitHub Desktop.
#!/bin/bash
set -ex
function ds_range {
DS_START=$1 DS_END=$2 python3 - <<EOD
from datetime import date, timedelta, datetime
from os import environ
def parse(ds):
return datetime.strptime(ds, "%Y-%m-%d")
start_date = parse(environ["DS_START"])
end_date = parse(environ["DS_END"])
dates = []
for i in range((end_date - start_date).days):
dt = start_date + timedelta(i)
dates.append(dt.strftime("%Y-%m-%d"))
print("\n".join(dates))
EOD
}
for ds in $(ds_range "2020-05-18" "2020-05-27"); do
echo $ds
BACKFILL_ONLY=true \
PRODUCT=org_mozilla_fenix_nightly \
SUBMISSION_DATE=$ds \
script/glam/run_glam_sql
done
EXPORT_ONLY=true PRODUCT=org_mozilla_fenix_nightly script/glam/run_glam_sql
PRODUCT=org_mozilla_fenix_nightly script/glam/export_csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment