Create dynamically sqlx-data.json file from github actions

[arkanoider]

Hi,

maybe a noob question or yet answered. I am trying to create the offline file directly in github actions, but in the end it seems to me that sqlx tries to connect to db env variable, this is my simple yml file:

name: Rust

on:
  push:
    branches: [ "main" ]
  pull_request:
    branches: [ "main" ]

env:
  CARGO_TERM_COLOR: always
  SQLX_OFFLINE: true
  MIN_PAYMENT_AMT: 100
  INVOICE_EXPIRATION_WINDOW: 3600

jobs:
  tests:

    runs-on: ubuntu-latest

    steps:
    - uses: actions/checkout@v3
       
    - name: Create database offline
      run: |
        cargo install --version=0.6.0 sqlx-cli --no-default-features
        cargo sqlx prepare
    
    - name: Run tests
      run: cargo test --verbose

This will raise an error because is still trying connection to db.

Locally I can do everything offline and it works like a charm, but I would like to automate the process on github CI otherwise i have always to regenerate the file if db table is modified.

Thanks guys!