sqlx_migrator 0.19.0

Migrator for writing sqlx migration using Rust instead of SQL
Documentation 
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
93
94
95
96
97
98
99
100
101
102

name: Build

on:
  push:
    branches:
      - master
  pull_request:

jobs:
  build:
    name: Build
    strategy:
      matrix:
        include:
          - os: "ubuntu-latest"
            rust-version: "stable"
          - os: "macos-latest"
            rust-version: "stable"
          - os: "windows-latest"
            rust-version: "stable"
          - os: "ubuntu-latest"
            rust-version: "beta"
          - os: "ubuntu-latest"
            rust-version: "nightly"
    runs-on: ${{ matrix.os }}
    defaults:
      run:
        shell: bash

    steps:
      - uses: actions/checkout@v4
      - name: Setup rust toolchain
        uses: dtolnay/rust-toolchain@master
        with:
          toolchain: ${{ matrix.rust-version }}
          components: rustfmt, clippy
      - name: Install just
        uses: extractions/setup-just@v3
      - name: Run all tests
        run: |
          just all

  run_example:
    name: Run Example
    runs-on: "ubuntu-latest"
    needs: build
    env:
      SQLITE_DATABASE_URL: "db.sqlite3"
      POSTGRES_DATABASE_URL: postgresql://postgres:postgres@127.0.0.1:5432/postgres
      MYSQL_DATABASE_URL: mysql://root:mysql@127.0.0.1:3306/default_db
    services:
      postgres:
        image: postgres
        env:
          POSTGRES_PASSWORD: postgres
        ports:
          - 5432:5432
        options: --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5
      mysql:
        image: mysql
        env:
          MYSQL_ROOT_PASSWORD: mysql
          MYSQL_DATABASE: default_db
        ports:
          - 3306:3306
        options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3

    steps:
      - uses: actions/checkout@v4
      - name: Setup rust toolchain
        uses: dtolnay/rust-toolchain@nightly
      - name: Install just
        uses: extractions/setup-just@v3
      - name: Print cli help message
        run: |
          just run-example postgres --help
          just run-example postgres apply --help
          just run-example postgres drop --help
          just run-example postgres list --help
          just run-example postgres revert --help
      - name: Run postgres example
        run: |
          just run-example postgres apply
          just run-example postgres list
          just run-example postgres revert --all --force
          just run-example postgres list
          just run-example postgres drop
      - name: Run sqlite example
        run: |
          touch db.sqlite3
          just run-example sqlite apply
          just run-example sqlite list
          just run-example sqlite revert --all --force
          just run-example sqlite list
          just run-example sqlite drop
      - name: Run mysql example
        run: |
          just run-example mysql apply
          just run-example mysql list
          just run-example mysql revert --all --force
          just run-example mysql list
          just run-example mysql drop