azure-pipelines.db-schema-creation.yaml

trigger:
  branches:
    include:
    - release/*
    #- dev
  paths:
    include:
    - DotNet/*/Migrations
    - Java/validation/src/main/resources/database/migrations
    exclude:
    - '*'
    
pr: none

pool:
  vmImage: 'ubuntu-latest'

parameters:
- name: previous_release
  displayName: "What is the Tag of the Previous Release? (i.e. : v0.2.0-beta.1)"
  type: string

- name: current_release
  displayName: "What is the Tag of the Current Release? (i.e. : v0.2.0-beta.2)"
  type: string

#####################

stages:
- stage: Build
  jobs:
  - job: getChangedFiles
    displayName: Get Changes
    steps: 
      - checkout: self
        fetchDepth: 0
        persistCredentials: true
      - task: PowerShell@2
        name: setVariables
        inputs:
          targetType: 'inline'
          script: |
            Write-Host ${env:BYPASSCHANGEEVALUATION}
            
            # Get any changed files
            $prev = '${{ parameters.previous_release }}'
            $curr = '${{ parameters.current_release }}'

            # Define path to changedServices.txt
            $changedFilesFile = "$(Build.SourcesDirectory)/changedfiles.txt"
            $changedServicesFile = "$(Build.SourcesDirectory)/changedServices.txt"

            Write-Host "Previous Release: $prev"
            Write-Host "Current Release: $curr"

            git fetch --tags

            If ($prev && $curr) {
              $changedFiles = git diff $prev $curr --name-only
            } else {
              $changedFiles = git diff --name-status HEAD HEAD^
            }
            
            Write-Host "Changed files:"
            Write-Host $changedFiles

            # Save output to changedfiles.txt
            $changedFiles | Out-File -FilePath $changedFilesFile -Encoding utf8

            # List of DotNet services to check
            $dotnetServices = @("Account", "Audit", "Census", "Normalization", "QueryDispatch", "Report", "Submission", "Tenant" ) 
            $javaServices = @("validation" )
            $dataAcquisition = @("DataAcquisition" )

            # DotNet Services
            foreach ($service in $dotnetServices) {
              $path = "Dotnet/$service/migrations"
              $match = $changedFiles | Where-Object { $_ -like "$path*" }

              if ($match) {
                $message = "$service migration files have changed."
                Write-Host $message
                Add-Content -Path $changedServicesFile -Value $message
              } else {
                Write-Host "No changes in $service files."
                }
              }

            # dataAcquisition Services
            foreach ($service in $dataAcquisition) {
              $path = "Dotnet/$service.Domain/Migrations"
              $match = $changedFiles | Where-Object { $_ -like "$path*" }

              if ($match) {
                $message = "$service migration files have changed."
                Write-Host $message
                Add-Content -Path $changedServicesFile -Value $message
              } else {
                Write-Host "No changes in $service files."
                }
              }

            # Java Services
            foreach ($service in $javaServices) {
              $path = "Java/$service/src/main/resources/database/migrations"
              $match = $changedFiles | Where-Object { $_ -like "$path*" }

              if ($match) {
                $message = "$service migration files have changed."
                Write-Host $message
                Add-Content -Path $changedServicesFile -Value $message
              } else {
                Write-Host "No changes in $service files."
                }
              }

            Write-Host "##vso[task.setvariable variable=task.A.status]Success"

      # Publish Changed Services

      - task: PublishBuildArtifacts@1
        inputs:
          PathtoPublish: '$(Build.SourcesDirectory)/changedServices.txt'
          ArtifactName: 'changedServices'

      - task: PublishBuildArtifacts@1
        inputs:
          PathtoPublish: '$(Build.SourcesDirectory)/changedfiles.txt'
          ArtifactName: 'changedFiles'

  # Account
  - job: Account
    displayName: "Generate Account Schema Script"
    steps:
      - task: DotNetCoreCLI@2
        displayName: Install dotnet-ef
        inputs:
         command: 'custom'
         custom: 'tool'
         arguments: 'install --global dotnet-ef'
      - script: |
         dotnet ef migrations script --idempotent --verbose -c AccountDbContext -s $(build.sourcesdirectory)/DotNet/Account/Account.csproj -p $(build.sourcesdirectory)/DotNet/Account/Account.csproj -o $(build.artifactstagingdirectory)/DatabaseScripts/accountDb.sql
        displayName: Generate Account SQL Script
      - task: PublishBuildArtifacts@1
        inputs:
         PathtoPublish: '$(Build.ArtifactStagingDirectory)'
         ArtifactName: 'scripts'
         publishLocation: 'container'
        displayName: Generate Tenant SQL Script  
  ###
  # Audit
  - job: Audit
    displayName: "Generate Audit Schema Script"
    steps:
      - task: DotNetCoreCLI@2
        displayName: Install dotnet-ef
        inputs:
         command: 'custom'
         custom: 'tool'
         arguments: 'install --global dotnet-ef'
      - script: |
         dotnet ef migrations script --idempotent --verbose -c AuditDbContext -s $(build.sourcesdirectory)/DotNet/Audit/Audit.csproj -p $(build.sourcesdirectory)/DotNet/Audit/Audit.csproj -o $(build.artifactstagingdirectory)/DatabaseScripts/auditDb.sql
        displayName: Generate Audit SQL Script
      - task: PublishBuildArtifacts@1
        inputs:
         PathtoPublish: '$(Build.ArtifactStagingDirectory)'
         ArtifactName: 'scripts'
         publishLocation: 'container'
        displayName: Generate Tenant SQL Script  
  ###
  # Census
  - job: Census
    displayName: "Generate Census Schema Script"
    steps:
      - task: DotNetCoreCLI@2
        displayName: Install dotnet-ef
        inputs:
         command: 'custom'
         custom: 'tool'
         arguments: 'install --global dotnet-ef'
      - script: |
         dotnet ef migrations script --idempotent --verbose -c CensusContext -s $(build.sourcesdirectory)/DotNet/Census/Census.csproj -p $(build.sourcesdirectory)/DotNet/Census/Census.csproj -o $(build.artifactstagingdirectory)/DatabaseScripts/censusDb.sql
        displayName: Generate Census SQL Script
      - task: PublishBuildArtifacts@1
        inputs:
         PathtoPublish: '$(Build.ArtifactStagingDirectory)'
         ArtifactName: 'scripts'
         publishLocation: 'container'
        displayName: Generate Tenant SQL Script  
  ###
  # DataAcquisition
  - job: DataAcquisition
    displayName: "Generate Data Acquisition Schema Script"
    steps:
      - task: DotNetCoreCLI@2
        displayName: Install dotnet-ef
        inputs:
         command: 'custom'
         custom: 'tool'
         arguments: 'install --global dotnet-ef'
      - script: |
         dotnet ef migrations script --idempotent --verbose -c DataAcquisitionDbContext -s $(build.sourcesdirectory)/DotNet/DataAcquisition/DataAcquisition.csproj -p $(build.sourcesdirectory)/DotNet/DataAcquisition.Domain/DataAcquisition.Domain.csproj -o $(build.artifactstagingdirectory)/DatabaseScripts/dataDb.sql
        displayName: Generate DataAcquisition SQL Script
      - task: PublishBuildArtifacts@1
        inputs:
         PathtoPublish: '$(Build.ArtifactStagingDirectory)'
         ArtifactName: 'scripts'
         publishLocation: 'container'
        displayName: Generate Tenant SQL Script  
  ###
  # Normalization
  - job: Normalization
    displayName: "Generate Normalization Schema Script"
    steps:
      - task: DotNetCoreCLI@2
        displayName: Install dotnet-ef
        inputs:
         command: 'custom'
         custom: 'tool'
         arguments: 'install --global dotnet-ef'
      - script: |
           dotnet ef migrations script --idempotent --verbose -c NormalizationDbContext -s $(build.sourcesdirectory)/DotNet/Normalization/Normalization.csproj -p $(build.sourcesdirectory)/DotNet/Normalization/Normalization.csproj -o $(build.artifactstagingdirectory)/DatabaseScripts/normalizationDb.sql
        displayName: Generate Normalization SQL Script
      - task: PublishBuildArtifacts@1
        inputs:
         PathtoPublish: '$(Build.ArtifactStagingDirectory)'
         ArtifactName: 'scripts'
         publishLocation: 'container'
        displayName: Generate Tenant SQL Script  
  ###
  # QueryDispatch
  - job: QueryDispatch
    displayName: "Generate QueryDispatch Schema Script"
    steps:
    - task: DotNetCoreCLI@2
      displayName: Install dotnet-ef
      inputs:
       command: 'custom'
       custom: 'tool'
       arguments: 'install --global dotnet-ef'
    - script: |
         dotnet ef migrations script --idempotent --verbose -c QueryDispatchDbContext -s $(build.sourcesdirectory)/DotNet/QueryDispatch/QueryDispatch.csproj -p $(build.sourcesdirectory)/DotNet/QueryDispatch/QueryDispatch.csproj -o $(build.artifactstagingdirectory)/DatabaseScripts/queryDispatchDb.sql
      displayName: Generate QueryDispatch SQL Script
    - task: PublishBuildArtifacts@1
      inputs:
       PathtoPublish: '$(Build.ArtifactStagingDirectory)'
       ArtifactName: 'scripts'
       publishLocation: 'container'
      displayName: Generate Tenant SQL Script  
  ###
  # Submission
  - job: Submission
    displayName: "Generate Submission Schema Script"
    steps:
      - task: DotNetCoreCLI@2
        displayName: Install dotnet-ef
        inputs:
         command: 'custom'
         custom: 'tool'
         arguments: 'install --global dotnet-ef'
      - script: |
         dotnet ef migrations script --idempotent --verbose -c SubmissionContext -s $(build.sourcesdirectory)/DotNet/Submission/Submission.csproj -p $(build.sourcesdirectory)/DotNet/Submission.Data/Submission.Data.csproj -o $(build.artifactstagingdirectory)/DatabaseScripts/submissionDb.sql
        displayName: Generate Submission SQL Script
      - task: PublishBuildArtifacts@1
        inputs:
         PathtoPublish: '$(Build.ArtifactStagingDirectory)'
         ArtifactName: 'scripts'
         publishLocation: 'container'
        displayName: Generate Submission SQL Script  
  ###
  # Tenant
  - job: Tenant
    displayName: "Build Tenant"
    steps:
    - task: DotNetCoreCLI@2
      displayName: Install dotnet-ef
      inputs:
       command: 'custom'
       custom: 'tool'
       arguments: 'install --global dotnet-ef'
    - script: |
         dotnet ef migrations script --idempotent --verbose -c TenantDbContext -s $(build.sourcesdirectory)/DotNet/Tenant/Tenant.csproj -p $(build.sourcesdirectory)/DotNet/Tenant/Tenant.csproj -o $(build.artifactstagingdirectory)/DatabaseScripts/tenantDb.sql
      displayName: Generate Tenant SQL Script
    - task: PublishBuildArtifacts@1
      inputs:
       PathtoPublish: '$(Build.ArtifactStagingDirectory)'
       ArtifactName: 'scripts'
       publishLocation: 'container'
      displayName: Generate Tenant SQL Script  
    ###
  # Validation
  - job: Validation
    displayName: "Build Validation"
    steps:
    - task: CopyFiles@2
      displayName: Copy Validation SQL Scripts to Artifact Staging Directory
      inputs:
       SourceFolder: '$(build.sourcesdirectory)/Java/validation/src/main/resources/database/migrations/'
       TargetFolder: $(Build.ArtifactStagingDirectory)/DatabaseScripts
       Contents: '*.sql'
    - task: PublishBuildArtifacts@1
      inputs:
       PathtoPublish: '$(Build.ArtifactStagingDirectory)'
       ArtifactName: 'scripts'
       publishLocation: 'container'
      displayName: Generate Validation SQL Script  
  ###