image: debian/stable
sources:
- https://git.sr.ht/~singpolyma/jmp-schemas
- https://github.com/singpolyma/redis_fdw.git#zset-with-scores-13
packages:
- redis
- libhiredis-dev
- postgresql-13
- postgresql-server-dev-13
- sqitch
environment:
  LANG: C.UTF-8
tasks:
- redis_fdw: |
    cd redis_fdw
    make
    sudo make install
- prep: |
    sudo -u postgres psql -c "CREATE ROLE $(id -un) LOGIN"
    sudo -u postgres psql -c "CREATE DATABASE jmp WITH OWNER $(id -un)"
    sudo -u postgres psql -d jmp -c "CREATE EXTENSION btree_gist"
    sudo -u postgres psql -d jmp -c "CREATE EXTENSION citext"
    sudo -u postgres psql -d jmp -c "CREATE EXTENSION pgcrypto"
    sudo -u postgres psql -d jmp -c "CREATE EXTENSION redis_fdw"
    sudo -u postgres psql -d jmp -c "CREATE SERVER redis_server FOREIGN DATA WRAPPER redis_fdw OPTIONS (address '127.0.0.1', port '6379')"
    sudo -u postgres psql -d jmp -c "CREATE USER MAPPING FOR PUBLIC server redis_server"
    sudo -u postgres psql -d jmp -c "GRANT ALL ON FOREIGN SERVER redis_server TO build"
- deploy: |
    cd jmp-schemas
    sqitch deploy
- verify: |
    cd jmp-schemas
    sqitch verify
- rebase: |
    cd jmp-schemas
    sqitch rebase -y