Skip to content

Latest commit

 

History

History
126 lines (84 loc) · 2.89 KB

README.md

File metadata and controls

126 lines (84 loc) · 2.89 KB
Raw

tSQLt Installer Action

Windows Linux AzureSQL Lint

Description

A Github Action to install tSQLt on SQL Server and AzureSQL databases for unit testing.

Pull requests are welcome!

Action Type

Composite

Author

@lowlydba

Inputs

  • sql-instance:

    Description: Target SQL instance.

    Default: localhost

  • database:

    Description: Target database to install to.

    Default: master

  • user:

    Description: Optional user for SQL authentication.

  • password:

    Description: Optional password for SQL authentication.

  • version:

    Description: Version to install.

    Default: latest

  • create-database:

    Description: Create database if it doesn't exist.

    Default: false

  • update:

    Description: Uninstalls and reinstalls if tSQLt is already present.

    Default: false

Example Workflows

To install using Windows authentication:

on: [push]

jobs:
  windows-auth-tsqlt:
    name: Test installting tSQLt with Windows auth
    runs-on: windows-latest

  steps:
    - uses: actions/checkout@v2

    - name: Install SQL Server
      uses: potatoqualitee/mssqlsuite@v1.4
      with:
        install: sqlengine

    - name: Install tSQLt with Windows auth
      uses: lowlydba/tsqlt-installer@v1
      with:
        sql-instance: localhost
        database: master
        version: latest

To install using SQL authentication:

on: [push]

jobs:
 sql-auth-tsqlt:
  name: Test installting tSQLt with SQL auth
  runs-on: ubuntu-latest
  services:
    sqlserver:
      image: mcr.microsoft.com/mssql/server:2019-latest
      ports:
        - 1433:1433
      env:
        ACCEPT_EULA: Y
        SA_PASSWORD: verystrongindeed

    steps:
      - uses: actions/checkout@v2

      - name: Install tSQLt with SQL auth
        uses: lowlydba/tsqlt-installer@v1
        with:
          sql-instance: localhost
          database: master
          version: latest
          user: sa
          password: verystrongindeed

Notes

  • Any invalid version strings are equal to latest
  • Known version strings:
    • 1-0-5873-27393 - For SQL 2005 and Azure SQL.
  • Ensure firewall exceptions are in place for Azure SQL targets.