CodeWeek-TreasureHuntBot/Taskfile.yml at main · CodeMOOC/CodeWeek-TreasureHuntBot · GitHub

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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
version: '3'

dotenv: ['config.env']

vars:
  DC: docker compose -f docker-compose.yml -f docker-compose.deploy.yml -p {{.COMPOSE_PROJECT_NAME}}
  DC_RUN: '{{.DC}} run --rm'

tasks:
  cmd:
    desc: Show the docker-compose command
    cmds:
      - echo 'Docker-Compose command:'
      - echo '{{.DC}}'

  install:
    desc: Install the database schema
    cmds:
      - '{{.DC_RUN}} db-client mysql -h db -u {{.MYSQL_USER}} -p{{.MYSQL_PASSWORD}} {{.MYSQL_DATABASE}} < sql/treasurehuntbot.sql'

  mysql:
    desc: Open an interactive MySQL shell
    cmds:
      - '{{.DC_RUN}} db-client mysql -h db -u {{.MYSQL_USER}} -p{{.MYSQL_PASSWORD}} {{.MYSQL_DATABASE}}'
    interactive: true

  mysql-cmd:
    desc: Show the MySQL connection command
    cmds:
      - echo '{{.DC_RUN}} db-client mysql -h db -u {{.MYSQL_USER}} -p{{.MYSQL_PASSWORD}} {{.MYSQL_DATABASE}}'

  dump:
    desc: Export the database to dump.sql
    cmds:
      - '{{.DC_RUN}} db-client mysqldump -h db -u root -p{{.MYSQL_ROOT_PASSWORD}} {{.MYSQL_DATABASE}} --extended-insert=FALSE > dump.sql'
      - echo 'Database exported to dump.sql.'

  import-db:
    desc: Replace the database with contents from dump.sql
    prompt: Are you sure you want to replace the database?
    cmds:
      - test -f dump.sql
      - echo 'Replacing database with contents from file dump.sql...'
      - '{{.DC_RUN}} db-client mysqldump -h db -u {{.MYSQL_USER}} -p{{.MYSQL_PASSWORD}} {{.MYSQL_DATABASE}} > previous_dump.sql'
      - '{{.DC_RUN}} db-client mysql -h db -u {{.MYSQL_USER}} -p{{.MYSQL_PASSWORD}} {{.MYSQL_DATABASE}} < dump.sql'
      - echo 'Database replaced. Previous contents in previous_dump.sql.'

  up:
    desc: Start the proxy service
    cmds:
      - '{{.DC}} up -d proxy'
      - '{{.DC}} ps'

  ps:
    desc: Show container status
    cmds:
      - '{{.DC}} ps'

  rs:
    desc: Restart all services
    cmds:
      - '{{.DC}} restart'

  rebuild:
    desc: Rebuild and restart the webhook service
    cmds:
      - '{{.DC}} rm -sf proxy webhook'
      - '{{.DC}} build webhook'
      - '{{.DC}} up -d proxy'

  phpmyadmin:
    desc: Run phpMyAdmin (CTRL+C to stop)
    cmds:
      - echo 'Running phpMyAdmin, terminate with CTRL+C...'
      - '{{.DC}} up database-manager'

  stop:
    desc: Stop all services
    cmds:
      - '{{.DC}} stop'

  rm:
    desc: Stop and remove all containers
    aliases: [rmc]
    deps: [stop]
    cmds:
      - '{{.DC}} rm -f'

  logs:
    desc: Follow webhook logs
    cmds:
      - docker logs -f "$({{.DC}} ps -q webhook)"