Jenkinsfile_prs_schema_migration_test_pgsql

#!/usr/bin/env groovy

// Configure the build properties
properties([
        buildDiscarder(logRotator(numToKeepStr: '500'))
])

pipeline {

    options {
        timeout(time: 30, unit: 'MINUTES') 
    }
    
    parameters {
        string(defaultValue: '', description: 'Gitarro PR', name: 'GITARRO_PR_NUMBER')
        string(defaultValue: '', description: 'SUSE Manager PR', name: 'PR_NUMBER')
        booleanParam(defaultValue: true, description: 'Clean up workspace after a successful execution.', name: 'cleanWorkspace')
    }

    environment {
        // specific psql conf
        repository = "SUSE/spacewalk"
        context = "schema_migration_test_pgsql"
        description = "schema migration test"
        filter = "schema/spacewalk"
        git_fs = "${env.WORKSPACE}"
        test = "susemanager-utils/testing/automation/schema-migration-test-pgsql.sh" 
        gitarro_cmd = 'gitarro.ruby2.5'
        gitarro_local = 'ruby gitarro.rb'
    // postgresql
        runtest_pg = "-r ${repository}" +
                " -c ${context} -d ${description} " +
                " -f ${filter} " +
                " -g ${git_fs} " +
                " -u \"${env.BUILD_URL}\"" +
                " -t ${test} "
    }

    // run only on specific hosts
    agent { label 'suse-manager-unit-tests' }

    stages {
        stage('Clean Up Workspace') {
            steps {
                echo 'Clean up previous workspace'
                cleanWs()
                echo 'Check out SCM'
                checkout scm
                script {
                    if (params.GITARRO_PR_NUMBER != '') {
                        echo 'Check out Gitarro PR'
                        checkout([$class           : 'GitSCM', branches: [[name: "FETCH_HEAD"]],
                                  extensions       : [[$class: 'LocalBranch']],
                                  userRemoteConfigs: [[refspec: "+refs/pull/${params.GITARRO_PR_NUMBER}/head:refs/remotes/origin/PR-${params.GITARRO_PR_NUMBER}", url: "https://git@github.com/openSUSE/gitarro"]]])
                    }
                }
            }
        }

        stage('Run schema tests postgresql') {
            steps {
                echo 'Run tests'
                script {
                    runtest_pg_cmd = "${gitarro_cmd} ${runtest_pg}"
                    if (params.GITARRO_PR_NUMBER != '') {
                            runtest_pg_cmd = "${gitarro_local} ${runtest_pg}"
                    }
                    if (params.PR_NUMBER != '') {
                        runtest_pg_cmd = "${runtest_pg_cmd} -P ${params.PR_NUMBER}"
                        currentBuild.displayName = "PR: ${params.PR_NUMBER}"
                    }     
                }
                sh "export PRODUCT=SUSE-Manager && ${runtest_pg_cmd}"
            }
        }

    }
    post {
        success {
            script {
                if (params.cleanWorkspace == true) {
                    echo 'Clean up current workspace, when job success.'
                    cleanWs()
                }
            }
        }
    }
}