/naovoce-dashboard

Statistics Dashboard for Na-ovoce.cz

Primary LanguagePythonMIT LicenseMIT

Na-ovoce.cz stats dashboard

Prerequisites

  • Python 3.11
  • Postgres
  • Node.js
  • Yarn

Development

# prepare database
psql -U postgres postgres -c "CREATE ROLE naovoce SUPERUSER"
psql -U postgres postgres -c "ALTER ROLE naovoce LOGIN"
psql -U postgres postgres -c "CREATE DATABASE naovoce_dashboard OWNER=naovoce"

# prepare and activate virtual environment
python3 -m venv venv
source venv/bin/activate

# install backend dependencies
pip install -r requirements-dev.txt

# prepare (+edit) and load env variables
cp .env.dev .env

# populate database
flask core init-db
flask auth create-user someuser@example.com somepassword

# load geo boundaries
shp2pgsql -s 4326 dashboard/resources/gis/cz_0.shp public.cz_0 | psql -U naovoce naovoce_dashboard
shp2pgsql -s 4326 dashboard/resources/gis/cz_1.shp public.cz_1 | psql -U naovoce naovoce_dashboard
shp2pgsql -s 4326 dashboard/resources/gis/cz_2.shp public.cz_2 | psql -U naovoce naovoce_dashboard

# install frontend dependencies
yarn

# run development servers
make dev