sql-agent-cli/.github/workflows/ci.yml at main · pseudosavant/sql-agent-cli · 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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
name: ci

on:
  push:
    branches:
      - main
  pull_request:

jobs:
  lint:
    runs-on: ubuntu-latest
    permissions:
      contents: read
    steps:
      - name: Checkout
        uses: actions/checkout@v7

      - name: Install uv
        uses: astral-sh/setup-uv@v9.0.0

      - name: Check lint
        run: uvx ruff==0.16.1 check .

      - name: Check formatting
        run: uvx ruff==0.16.1 format --check .

  test:
    runs-on: ${{ matrix.os }}
    permissions:
      contents: read
    strategy:
      fail-fast: false
      matrix:
        include:
          - os: ubuntu-latest
            python-version: "3.11"
          - os: ubuntu-latest
            python-version: "3.12"
          - os: ubuntu-latest
            python-version: "3.13"
          - os: windows-latest
            python-version: "3.13"
    steps:
      - name: Checkout
        uses: actions/checkout@v7

      - name: Set up Python
        uses: actions/setup-python@v7
        with:
          python-version: ${{ matrix.python-version }}

      - name: Install uv
        uses: astral-sh/setup-uv@v9.0.0

      - name: Run tests
        run: uv run --locked python -m unittest discover -v

  integration:
    runs-on: ubuntu-latest
    permissions:
      contents: read
    services:
      postgres:
        image: postgres:17
        env:
          POSTGRES_USER: sqlagent
          POSTGRES_PASSWORD: sqlagent-postgres
          POSTGRES_DB: sqlagent
        ports:
          - 5432:5432
        options: >-
          --health-cmd "pg_isready -U sqlagent -d sqlagent"
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
      mysql:
        image: mysql:8.4
        env:
          MYSQL_ROOT_PASSWORD: sqlagent-root
          MYSQL_DATABASE: sqlagent
          MYSQL_USER: sqlagent
          MYSQL_PASSWORD: sqlagent-mysql
        ports:
          - 3306:3306
        options: >-
          --health-cmd "mysqladmin ping -h localhost -u root -psqlagent-root"
          --health-interval 10s
          --health-timeout 5s
          --health-retries 10
    steps:
      - name: Checkout
        uses: actions/checkout@v7

      - name: Set up Python
        uses: actions/setup-python@v7
        with:
          python-version: "3.13"

      - name: Install uv
        uses: astral-sh/setup-uv@v9.0.0

      - name: Run PostgreSQL and MySQL integration tests
        env:
          SQL_AGENT_CLI_INTEGRATION: "1"
          SQL_AGENT_CLI_POSTGRES_HOST: 127.0.0.1
          SQL_AGENT_CLI_POSTGRES_PORT: "5432"
          SQL_AGENT_CLI_POSTGRES_DATABASE: sqlagent
          SQL_AGENT_CLI_POSTGRES_USER: sqlagent
          SQL_AGENT_CLI_POSTGRES_PASSWORD: sqlagent-postgres
          SQL_AGENT_CLI_MYSQL_HOST: 127.0.0.1
          SQL_AGENT_CLI_MYSQL_PORT: "3306"
          SQL_AGENT_CLI_MYSQL_DATABASE: sqlagent
          SQL_AGENT_CLI_MYSQL_USER: sqlagent
          SQL_AGENT_CLI_MYSQL_PASSWORD: sqlagent-mysql
        run: >-
          uv run --locked python -m unittest
          tests.test_network_integration
          tests.test_read_only_integration
          -v