tSQLt Installer Action

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/[email protected]
      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