~singpolyma/jmp-schemas

jmp-schemas/.builds/debian-stable.yml -rw-r--r-- 1.2 KiB
395bb797Stephen Paul Weber Tag for notify on top up an expired account a month ago
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
image: debian/stable
sources:
- https://git.singpolyma.net/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