Universe.SqlServerJam/.github/workflows/Setup-SQL-Servers-IN-DOCKER.yml at 7ffbe6bab22deaf7e539d6357c53be0c8bbe4b7c · devizer/Universe.SqlServerJam · 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
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
name: Docker SQL Server Setup

env:
  DEBUG_CLEAN_UP_MY_TEMP_FOLDERS_AND_FILES_ON_EXIT: '1'
  THEIMAGE: 'devizervlad/iis-net4x-net35'

on:
  workflow_dispatch:
  push:
      branches: [ "master" ]
  schedule:
      - cron: "15 4 * * *"

defaults:
  run:
    shell: powershell


jobs:

  Setup:

    timeout-minutes: 360
    runs-on: ${{ matrix.OS }}
    strategy:
      fail-fast: false
      matrix:
         include:
             - TAG: ltsc2025
               ISOLATION: process
               OS: windows-2025
             - TAG: ltsc2025
               ISOLATION: hyperv
               OS: windows-2025

             - TAG: ltsc2022
               ISOLATION: process
               OS: windows-2022
             - TAG: ltsc2022
               ISOLATION: hyperv
               OS: windows-2022

             - TAG: ltsc2019
               ISOLATION: hyperv
               OS: windows-2025

             - TAG: ltsc2016
               ISOLATION: hyperv
               OS: windows-2025


    env:
      PS1_TROUBLE_SHOOT: On
      SQLSERVERS_MEDIA_FOLDER: 'C:\Sql-Media'
      SQLSERVERS_SETUP_FOLDER: 'C:\Sql-Setup'
      DEBUG_LOG_FOLDER: 'C:\Artifacts'

    steps:
    - name: Total Modules
      if: ${{ false }}
      run: 'Write-Host "Total Modules: $((get-module -ListAvailable).Count)"'

    - name: Bootstrap
      uses: devizer/devops-library@main

    - name: Bootstrap
      shell: bash
      run: |
         set -eu;
         nohup powershell -c "\$PSVersionTable" &
         wait
         # time powershell -c "Install-Module -Name SqlServer-Version-Management -Force"
         nohup powershell -c "Install-Module -Name SqlServer-Version-Management -Force" &
         # nohup cmd.exe /c "start https://devizer.github.io" &
         ls -la "/c/Program Files/Google/Chrome/Application/chrome.exe"
         nohup "/c/Program Files/Google/Chrome/Application/chrome.exe" --headless --disable-gpu https://devizer.github.io &
         echo FIRST; jobs
         sleep 3
         echo SECOND; jobs
         # find "/c/Program Files" -name chrome.exe

    - name: Accelerate Docker
      shell: bash
      run: |
         Run-Remote-Script https://raw.githubusercontent.com/devizer/glist/master/Move-Docker-to-SSD-for-Windows-On-Microsoft-Hosted-Build-Agent.ps1

    - name: Checkout
      uses: actions/checkout@v4
      with:
        fetch-depth: 888888

    - name: "Pull ${{ matrix.TAG }}"
      shell: bash
      run: 'try-and-retry docker pull ${{ env.THEIMAGE }}:${{ matrix.TAG }}'

    - name: Test ALL
      shell: pwsh
      run: |
          $ENV:ISOLATION="${{ matrix.ISOLATION }}"
          $env:TAG="${{ matrix.TAG }}"
          . ".\SQL-Server-in-Windows-Container\Setup-SQL-Server-Array.ps1"


    - name: Upload artifacts
      uses: actions/upload-artifact@v4
      if: always()
      with:
        name: 'Artifacts ${{ matrix.TAG }} ${{ matrix.ISOLATION }} ${{ matrix.OS }}'
        path: "${{ env.SYSTEM_ARTIFACTSDIRECTORY }}"
        overwrite: true

    - name: Upload artifacts
      uses: actions/upload-artifact@v4
      if: always()
      with:
        name: 'Workplace ${{ matrix.TAG }} ${{ matrix.ISOLATION }} ${{ matrix.OS }}'
        path: |
          ${{ github.workspace }}/**
          !${{ github.workspace }}/**/*.exe
        # path: "${{ github.workspace }}"
        overwrite: true


  Combine:
    runs-on: windows-latest
    needs: Setup
    if: always()
    timeout-minutes: 15
    steps:

    - name: Download all workflow run artifacts
      uses: actions/download-artifact@v4
      with:
         path: 'C:\Artifacts'

    - name: Upload artifacts
      uses: actions/upload-artifact@v4
      if: always()
      with:
        name: 'Combined SQL Server Setup Summary'
        path: |
          C:\Artifacts