lwodcollector

a tool that parses Scoot's wonderful Last Week on Destiny spreadsheets and saves the data to an SQLite DB, and also scans Destiny's channel for currently running livestreams and saves the data to an SQLite DB

Usage

1. Create a Google Cloud Platform project, enable the Drive, YouTube Data and Sheets APIs, setup a service account and get the .json creds file. Used this video a couple of years ago to guide me through the process, though it might be outdated.
2. cp .env.example .env
3. Change the .env how you see fit.
4. go build
5. lwodcollector

.env

GOOGLE_CRED

Sets the client secret file name.

LWOD_DB_FILE, YT_DB_FILE

Sets the SQLite DB file name.

LWOD_FOLDER

Sets the LWOD folder ID.

YT_DELAY, LWOD_DELAY

Sets the delay between making API requests.

LWOD_REFRESH, YT_REFRESH, YT_API_REFRESH (optional)

Sets the app to continuous mode and refreshes every set amount of minutes.

LWOD_HEALTHCHECK, YT_HEALTHCHECK (optional)

If the app is in continuous mode will send an HTTP request to the specified address every refresh.

Subcommands

continuous

Run the app every set amount of minutes (that is set with the *_REFRESH env vars).

youtube

Get the data about current and previous Destiny livestreams.

lwod

Parse the LWOD spreadsheets.

Flags

-a, --all

Process every single sheet/video (doesn't work with continuous mode).

-h, --help

Print help information.

-v, --verbose

Show debug messages.