从jenkins转到drone

version: '3.9'
networks:
  drone:
    name: drone
    driver: bridge
services:
  db:
    image: postgres:latest
    container_name: drone_db
    restart: always
    networks:
      - drone
    ports:
      - '5432:5432'
    environment:
      - POSTGRES_USER=drone
      - POSTGRES_PASSWORD=drone
      - POSTGRES_DB=drone
    volumes:
      - /volumes/drone/db:/var/lib/postgresql/data
  server:
    image: drone/drone:2
    container_name: drone_server
    restart: always
    networks:
      - drone
    ports:
      - '80:80'
      - '443:443'
    environment:
      - DRONE_TLS_AUTOCERT=true
      - DRONE_SERVER_PROTO=https
      - DRONE_SERVER_HOST=https://drone.your-domain.com
      - DRONE_RPC_SECRET=DRONE_RPC_SECRET
      - DRONE_WEBHOOK_ENDPOINT=http://webhook:3000
      - DRONE_WEBHOOK_SECRET=add8b88f1a7ff15cbcb5bdb6bd081b70
      - DRONE_DATABASE_DRIVER=postgres
      - DRONE_WEBHOOK_EVENTS=build:created,build:updated
      - DRONE_DATABASE_DATASOURCE=postgres://drone:drone@db/drone?sslmode=disable
      - DRONE_USER_CREATE=username:zzfn,admin:true
      - DRONE_USER_CREATE=username:prometheus,admin:true,machine:true,token:c576f2bd2d218d1ffd583c2db868d8c7
      - DRONE_GITHUB_CLIENT_ID=DRONE_GITHUB_CLIENT_ID
      - DRONE_USER_FILTER=zzfn,prometheus
      - DRONE_GITHUB_CLIENT_SECRET=DRONE_GITHUB_CLIENT_SECRET
    volumes:
      - /var/lib/drone:/data
    depends_on:
      - db
  runner:
    image: drone/drone-runner-docker:1
    container_name: drone_runner
    restart: always
    networks:
      - drone
    ports:
      - '3000:3000'
    environment:
      - DRONE_RUNNER_NAME=docker-runner
      - DRONE_RUNNER_CAPACITY=2
      - DRONE_RPC_PROTO=http
      - DRONE_RPC_HOST=server
      - DRONE_RPC_SECRET=DRONE_RPC_SECRET
    volumes:
      - /var/run/docker.sock:/var/run/docker.sock
    depends_on:
      - server
  webhook:
    image: registry.cn-shanghai.aliyuncs.com/zzf2001/drone-webhook:latest
    container_name: drone_webhook
    restart: always
    networks:
      - drone
    ports:
      - '6000:3000'
    environment:
      - DRONE_SECRET=DRONE_SECRET
      - PLUGIN_WEBHOOK=https://open.feishu.cn/open-apis/bot/v2/hook/xxxxxx
      - PLUGIN_SECRET=PLUGIN_SECRET
      - PLUGIN_BASE=https://drone.your-domain.com/

kind: pipeline
type: docker
name: default

steps:
  - name: webhook
    image: zzfn/webhook
    settings:
      url: http://hook.zzfn.com
      method: post
      body: |
        hello world

SELECT setval('orgsecrets_secret_id_seq', 100);
//找出最大值设置
SELECT setval('orgsecrets_secret_id_seq', COALESCE((SELECT MAX(secret_id)+1 FROM orgsecrets), 1), false);