op-tcg

Unofficial one piece tcg leaderboard with extended analytic features.

Application

The app is currently deployed in the community cloud of streamlit. PROD: https://optcg-leaderboard.streamlit.app/ DEV: https://optcg-leaderboard-dev.streamlit.app/

Local Setup

What you need:

• Google cloud cli
• Google Cloud IAM permission
• Populate .env file with help of .env.template

Environment System

Install pipx first

pipx install poetry

poetry install --with crawler,frontend

Access environment in your shell

poetry shell

Crawling

Get tournament data from limitless

optcg crawl limitless tournaments

Update Big Query Date

Push data to Google Cloud BigQuery (expects a dataset matches already existing)

optcg etl upload-matches

Start Local Frontend Server

optcg frontend start

Cloud Setup

The app is running in Google cloud and can be initialized by terraform.

Prerequisites

• Activate Cloud Functions API
• Activate Cloud Run API
• Activate Cloud Build API
• Activate Cloud Scheduler API
• Setup IAM service account with BigQuery read/write access