Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


...

  • This is a manual job only
  • Can deploy any service in any environment
  • Deploys the version in platform.yml

...

  • Run by other jenkins jobs
  • Creates JAR and Docker inages
  • Put them into the registry

...

  • This is the main job for esr
  • It is triggered by a push into github
  • It creates the JAR and Docker image by running service-pipeline
  • When FINALTAG is set, it deploys esr-etl into dev

...

  • This is the main job for esr
  • It is triggered by a push into github
  • It creates the JAR and Docker image by running service-pipeline
  • When FINALTAG is set, it deploys esr-etl into dev

...

  • This is for manual run only
  • One runs it to pass a parameter like the date or the type of load needed
  • It does not create any JAR file or docker image
  • It just deploys whatever is in platform.yml into the selected environment
  • One can pass any parameter to the job, unlike service-env-deploy

...


ProjectJenkins jobPurposeSCM triggeredcronenvironment
ANYservice-env-deploy
  • This is a manual job only
  • Can deploy any service in any environment
  • Deploys the version in platform.yml

noAny






ANYservice-pipeline
  • Run by other jenkins jobs
  • Creates JAR and Docker inages
  • Put them into the registry

noNone/Dev






ESResr
  • This is the main job for esr
  • It is triggered by a push into github
  • It creates the JAR and Docker image by running service-pipeline
  • When FINALTAG is set, it deploys esr-etl into dev

noNone/Dev






ESR-ETLtis-esr-etl
  • This is the main job for esr
  • It is triggered by a push into github
  • It creates the JAR and Docker image by running service-pipeline
  • When FINALTAG is set, it deploys esr-etl into dev

noNone/Dev

tis-esr-parameterized
  • This is for manual run only
  • One runs it to pass a parameter like the date or the type of load needed
  • It does not create any JAR file or docker image
  • It just deploys whatever is in platform.yml into the selected environment
  • One can pass any parameter to the job, unlike service-env-deploy

noAny

tis-esr-etl-param-cron

  • This is a cron job in jenkins
  • It runs ansible/esr-etl.yml with --extra-vars="LOAD_TYPE=${LOAD_TYPE}"
  • Depending on the time, the value of LOAD_TYPE varies
  • This deprecates the below tis-esr-param-XXXXX jenkins jobs

"yes"

tis-esr-etl-param-apc-import
  • This is a cron job in jenkins
  • It runs tis-esr-parameterized with LOAD_TYPE=apc-import
  • Disabled while tis-esr-etl-param-cron is being tested

  • 20h00
  • daily
stage

tis-esr-etl-param-applicant-load
  • This is a cron job in jenkins
  • It runs tis-esr-parameterized with LOAD_TYPE=applicant-load
  • Disabled while tis-esr-etl-param-cron is being tested

  • 15h00
  • daily
stage

tis-esr-etl-param-applicant-export
  • This is a cron job in jenkins
  • It runs tis-esr-parameterized with LOAD_TYPE=applicant-export
  • Disabled while tis-esr-etl-param-cron is being tested

  • 17h00
  • daily
stage

tis-esr-etl-param-notification-export
  • This is a cron job in jenkins
  • It runs tis-esr-parameterized with LOAD_TYPE=notification-export
  • Disabled while tis-esr-etl-param-cron is being tested

  • 17h00
  • daily
stage

tis-esr-etl-param-
cron
notification-daily-load
  • This is a cron job in jenkins
  • It
runs ansible/
  • runs tis-esr-
etl.yml with --extra-vars="
  • parameterized with LOAD_TYPE=
${LOAD_TYPE}"
  • Depending on the time, the value of LOAD_TYPE varies
  • This deprecates the below
    • notification-export
    • Disabled while tis-esr-etl-param-
    XXXXX jenkins jobs"yes"
    • cron is being tested

    • 02h00
    • daily
    stage

    esr-etldisabled because tis-esr-etl
    -param-apc-import
    • This is a cron job in jenkins
    • It runs tis-esr-parameterized with LOAD_TYPE=apc-import
    • Disabled while tis-esr-etl-param-cron is being tested
    • 20h00
    • daily
    stagetis-esr-etl-param-applicant-load
    does the same thing








    NDW-ETLndw-etl
    • This is the main job for NDW-ETL
    • It is triggered by a push into github
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys esr-etl into dev

    noNone/Dev

    tis-ndw-etl-parameterized
    • This is a cron job in
    jenkins
  • It runs tis-esr-parameterized with LOAD_TYPE=applicant-load
  • Disabled while tis-esr-etl-param-cron is being tested
    • 15h00
    • daily
    stagetis-esr-etl-param-applicant-export
    • This is a cron job in jenkins
    • It runs tis-esr-parameterized with LOAD_TYPE=applicant-export
    • Disabled while tis-esr-etl-param-cron is being tested
    • 17h00
    • daily
    stagetis-esr-etl-param-notification-export
    • This is a cron job in jenkins
    • It runs tis-esr-parameterized with LOAD_TYPE=notification-export
    • Disabled while tis-esr-etl-param-cron is being tested
    • 17h00
    • daily
    stagetis-esr-etl-param-notification-daily-load
    • This is a cron job in jenkins
    • It runs tis-esr-parameterized with LOAD_TYPE=notification-export
    • Disabled while tis-esr-etl-param-cron is being tested
    • 02h00
    • daily
    stageesr-etldisabled because tis-esr-etl does the same thingNDW-ETLndw-etl
  • This is the main job for NDW-ETL
  • It is triggered by a push into github
    • Jenkins
    • It can take a parameter: the environment
    • It will by default run in prod

    • 07h00
    • daily
    Prod

    chris-tis-ndw
    • Uses jenkinsfile
    • Can run against all our github repositories
    • configured to use tis-ndw-etl github repo




    service-pipeline-ndw-etldisabled because this was a poor attempt to change service-pipeline








    Generic Uploadtis-generic-upload-parameterized
    • This is for manual run only
    • One runs it to pass a DEBUG parameter which allows one to attach to port 5005TCP
    • It does not create any JAR file or docker image
    • It just deploys whatever is in platform.yml into the selected environment
    • One can pass the debug parameter to the job, unlike service-env-deploy

    noAny

    tis-generic-upload
    • This is the main job for generic-upload
    • It is triggered by a push into github
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev

    noNone/Dev






    TCStcs
    • This is the main job for tcs
    • It is triggered by a push into github
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev




    tcs-paramameterizeddisabled because this was a poor attempt to change service-pipeline








    admins-uiadmins-ui
    • This is the main job for admins-ui
    • It is triggered by a push into TIS-ADMINS-UI github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev




    TIS-ADMINS-UI
    • Uses jenkinsfile
    • Can run against all our github repositories
    • configured to use ndw-etl github repo




    admins-ui-e2e



    admins-ui-uat
    • This is a clone of the main job for admins-ui
    • It used to be triggered by a push into TIS-ADMINS-UI github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys
    esr
    • generic-
    etl tis-ndw-etl-parameterized
    • This is a cron job in Jenkins
    • It can take a parameter: the environment
    • It will by default run in prod
    • 07h00
    • daily
    Prodchris-tis-ndw
    • upload into dev
    noNone/Dev
    • DECISION REQUIRED - last run was on 2018 March 7th




    chris-admins-ui
    • this is a different implementation of a pipeline
    • It uses groovy pipeline directly implemented in the GUI
    • It never succeded, last run was on 2018 March 18th
    • Last error: java.lang.NoSuchMethodError: No such DSL method 'post' found among steps
    • DECISION REQUIRED




    TIS-ADMINS-UI
    • Uses jenkinsfile
    • Can run against all our github repositories
    • configured to use
    tis
    ndw
    etl
    • UI github repo
    service-pipeline-ndw-etldisabled because this was a poor attempt to change service-pipelineGeneric Uploadtis-generic-upload-parameterized
    • This is for manual run only
    • One runs it to pass a DEBUG parameter which allows one to attach to port 5005TCP
    • It does not create any JAR file or docker image
    • It just deploys whatever is in platform.yml into the selected environment
    • One can pass the debug parameter to the job, unlike service-env-deploy
    noAnytis-generic-upload









    referencereference
    • This is the main job for reference
    • It is triggered by a push into TIS-REFERENCE github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev









    profileprofile
    • This is the main job for
    generic-upload
    • profile
    • It is triggered by a push into TIS-PROFILE github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev
    noNone/DevTCStcs




    profile-parent
    • This is the main job for
    tcsadmins-ui
    • profile
    • It is triggered by a push into TIS-PROFILE github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev
    tcs-paramameterizeddisabled because this was a poor attempt to change service-pipelineadmins-ui
    • DUPLICATE ???









    assessmentsassessments
    • This is the main job for
    admins-ui
    • assessments
    • It is triggered by a push into TIS-
    ADMINS-UI
    • ASSESSMENTS github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev
    TIS-ADMINS-UI
    • Uses jenkinsfile
    • Can run against all our github repositories
    • configured to use ndw-etl github repo
    admins-ui-e2eadmins-ui-uat
  • This is a clone of the main job for admins-ui
  • It used to be









    auditaudit-logs-backup-dev
    • runs ansible task tasks/audit-logs-backup.yml in dev
    • backs audt logs to azure storage container heetislogsbackup, container audit-logs-dev




    audit-logs-backup-prod
    • runs ansible task tasks/audit-logs-backup.yml in prod
    • backs audt logs to azure storage container heetislogsbackup, container audit-logs-prod









    revalidationrevalidation
    • This is the main job for revalidation
    • It is triggered by a push into TIS-
    ADMINS-UI
    • REVALIDATION github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev
  • DECISION REQUIRED - last run was on 2018 March 7th
  • chris-admins-ui
    • this is a different implementation of a pipeline
    • It uses groovy pipeline directly implemented in the GUI
    • It never succeded, last run was on 2018 March 18th
    • Last error: java.lang.NoSuchMethodError: No such DSL method 'post' found among steps
    • DECISION REQUIRED
    TIS-ADMINS-UI
    • Uses jenkinsfile
    • Can run against all our github repositories
    • configured to use TIS-ADMINS-UI github repo
    referencereference
    • This is the main job for reference
    • It is triggered by a push into TIS-REFERENCE github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev
    profileprofile
    • This is the main job for profile
    • It is triggered by a push into TIS-PROFILE github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev
    profile-parent
    • This is the main job for profile
    • It is triggered by a push into TIS-PROFILE github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev
    • DUPLICATE ???
    assessmentsassessments
    • This is the main job for assessments
    • It is triggered by a push into TIS-ASSESSMENTS github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev
    auditaudit-logs-backup-dev
    • runs ansible task tasks/audit-logs-backup.yml in dev
    • backs audt logs to azure storage container heetislogsbackup, container audit-logs-dev
    audit-logs-backup-prod
    • runs ansible task tasks/audit-logs-backup.yml in prod
    • backs audt logs to azure storage container heetislogsbackup, container audit-logs-prod
    revalidationrevalidationThis is the main job for revalidation
    yes


    intrepid-reval-etl-dev/stage/uidev
    • Runs ansible/tasks/intrepid-reval-etl-all.yml in dev, stage, uidev
    • creates docker instance intrepid-dr-etl:{{ versions['intrepid-reval-etl'] }}
    no


    intrepid-reval-etl-all-uat

    • Runs ansible/tasks/intrepid-reval-etl-all.yml in UAT
    • creates docker instance intrepid-dr-etl:{{ versions['intrepid-reval-etl'] }}
    no


    intrepid-reval-etl-all-prod
    • Runs ansible/tasks/intrepid-reval-etl-all.yml in prod with --limit 10.170.0.137
    • creates docker instance intrepid-dr-etl:{{ versions['intrepid-reval-etl'] }}
    • 5h30
    • daily



    intrepid-reval-etltype-schema-env

    • takes ETLTYPE and ENVIRONMENT parameters
    • Runs ansible/tasks/intrepid-reval-etl-all.yml --extra-vars="etl_type=${ETLTYPE}"
    • creates docker instance intrepid-dr-etl:{{ versions['intrepid-reval-etl'] }}









    ci_testci_test


    release-tagrelease-tag
    • is triggered by the likes of ci_test
    • takes the following parameters GIT_TAG_URL, GIT_TAG_BRANCH, GIT_TAG_VALUE
    • tags the repo GIT_TAG_URL with tag GIT_TAG_VALUE









    fayaz-plfayaz-pl
    • DECISION REQUIRED -  last run 2017 Feb 27
    • pipeline script
    • takes a git repo, runs maven on it then runs mvn2docker









    Trainee-UItrainee-ui
    • This is the main job for reference
    • It is triggered by a push into TIS-
    REVALIDATION
    , it deploys generic-upload into dev
  • triggers ci-test jenkins job 
  • yesintrepid-reval-etl-dev/stage/uidev
    • Runs ansible/tasks/intrepid-reval-etl-all.yml in dev, stage, uidev
    • creates docker instance intrepid-dr-etl:{{ versions['intrepid-reval-etl'] }}
    no

    intrepid-reval-etl-all-uat

    • Runs ansible/tasks/intrepid-reval-etl-all.yml in UAT
    • creates docker instance intrepid-dr-etl:{{ versions['intrepid-reval-etl'] }}
    nointrepid-reval-etl-all-prod
    • Runs ansible/tasks/intrepid-reval-etl-all.yml in prod with --limit 10.170.0.137
    • creates docker instance intrepid-dr-etl:{{ versions['intrepid-reval-etl'] }}
    • 5h30
    • daily

    intrepid-reval-etltype-schema-env

    • takes ETLTYPE and ENVIRONMENT parameters
    • Runs ansible/tasks/intrepid-reval-etl-all.yml --extra-vars="etl_type=${ETLTYPE}"
    • creates docker instance intrepid-dr-etl:{{ versions['intrepid-reval-etl'] }}
    ci_testci_testrelease-tagrelease-tag
    • is triggered by the likes of ci_test
    • takes the following parameters GIT_TAG_URL, GIT_TAG_BRANCH, GIT_TAG_VALUE
    • tags the repo GIT_TAG_URL with tag GIT_TAG_VALUE
    fayaz-plfayaz-pl
    • DECISION REQUIRED -  last run 2017 Feb 27
    • pipeline script
    • takes a git repo, runs maven on it then runs mvn2docker
    Trainee-UItrainee-ui
  • This is the main job for reference
    • , it deploys generic-upload into dev
    yes







    Notificationsnotifications
    • This is the main job for notifications
    • It is triggered by a push into TIS-NOTIFICATIONS github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev
    yes







    commoncommon
    • This is the main job for common
    • It is triggered by a push into TIS-COMMON github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev









    Intrepidintrepid-load
    • runs in PROD
    • runs ansible code ansible/tasks/intrepid-load.yml
    • does not use any git repo, apat from tis-devops
    • ansible/tasks/intrepid-load.yml: deploys docker image repository.tis.nhs.uk:5000/hee/csv-diff:{{ versions['intrepid-load'] }}




    intrepid-dr-modelyes


    intrepid-dr-tools
    • It is triggered by a push into TIS-
    TRAINEE
    UI
  • It creates the JAR and Docker image by running service-pipeline
  • When FINALTAG is set, it deploys generic-upload into dev
  • yesNotificationsnotifications
    • This is the main job for notifications
    • It is triggered by a push into TIS-NOTIFICATIONS github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev
    yescommoncommon
    • runs mvn clean install -e then mvn2docker
    yesno

    intrepid-load-etl
    • disabled, last run 2017 Nov 9th
    • runs ansible playbook ansible/tasks/intrepid-load.yml in PROD

    no

    intrepid-anonymizer
    • runs ansible code ansible/tasks/intrepid-anonymizer.yml against localhost
    • deploys docker image repository.tis.nhs.uk:5000/hee/anonymizer:{{ versions['intrepid-anonymizer'] }}
    nono

    intrepid-anonymizer-new

    • runs ansible/tasks/intrepid-anonymizer-new.yml in STAGE
    • never run




    intrepid-anonymizer-build


    Code Block
    Anonymise intrepid data to populate the anonymized mirror
    • This is the main job for
    common
    • intrepid-anonymizer
    • It is triggered by a push into TIS-DATA-
    COMMON
    • ANONYMIZER github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev
    Intrepidintrepid-dr
    yes
    intrepid-load
    • runs in PROD
    • runs ansible code ansible/tasks/intrepid-load.yml
    • does not use any git repo, apat from tis-devops
    • ansible/tasks/intrepid-load.yml: deploys docker image repository.tis.nhs.uk:5000/hee/csv-diff:{{ versions['intrepid-load'] }}
    no

    intrepid-core-model
    • last run 2017 January 9th
    • This is the main job for intrepid-core-model
    • It is triggered by a push into TIS-INTREPID-
    DRyes
  • runs mvn clean install -e
    • It creates the JAR and Docker image by running mvn2docker
    yesno

    intrepid-
    dr
    load-
    toolsyesnointrepid-core-model
    • last run 2017 January 9th
    • This is the main job for intrepid-core-model
    • It is triggered by a push into TIS-INTREPID-CORE-MODEL github repo
    • It creates the JAR and Docker image by running mvn2docker
    yesnointrepid-load-stageintrepid-etl-pipeine

    Quote:

    Code Block
    Runs intrepid-extract and load each morning. Intrepid extract: grabs data from intrepid places in into CSV files (db-to-csv). Intrepid remap: changes column names on CSV files (intrepid-remap-col-structure) - we could remove it Intrepid load: grabs CSV data and places it into the mirror (csv-diff) creates a delta file and then uploads to db Intrepid conosolidated etl: points to the mirror and populates the TIS system
    
    • pipeline script from SCM
    • SCM: TIS-DEVOPS
    • script: jenkins/intrepid-etl-prod.groovy
    • jenkins/intrepid-etl-prod.groovy can run intrepid-extract-all, intrepid-remapper-structure, intrepid-load, intrepid-extract-upload, intrepid-compare-stats

    intrepid-etl-pipeline-new

    • pipeline script from SCM
    • SCM: TIS-DEVOPS
    • script: jenkins/intrepid-etl-prod-new.groovy
    • jenkins/intrepid-etl-prod-new.groovy runs ansible/tasks/intrepid-extract-new.yml with intrepid_dr_settings=<dr2|mirror-prod> schema=R1 mirror_settings=mirror-prod
      batch_size=20

    no
    • 2h45
    • daily
    intrepid-extract-all
    stage
    • It is triggered by a push into TIS-INTREPID-DR-TOOLS github repo
    • runs mvn clean install -e then mvn2docker
    yesnointrepid-load-etl
    • disabled, last run 2017 Nov 9th
    • runs ansible playbook ansible/tasks/intrepid-load.yml in PROD
    nointrepid-anonymizer
    • runs ansible code ansible/tasks/intrepid-anonymizer.yml against localhost
    • deploys docker image repository.tis.nhs.uk:5000/hee/anonymizer:{{ versions['intrepid-anonymizer'] }}
    nono

    intrepid-anonymizer-new

    • runs ansible/tasks/intrepid-anonymizer-new.yml in STAGE
    • never run

    intrepid-anonymizer-build

    Code Block
    Anonymise intrepid data to populate the anonymized mirror
    • This is the main job for intrepid-anonymizer
    • It is triggered by a push into TIS-DATA-ANONYMIZER github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev




    intrepid-etl-pipeine

    Quote:

    Code Block
    Runs intrepid-extract and load each morning. Intrepid extract: grabs data from intrepid places in into CSV files (db-to-csv). Intrepid remap: changes column names on CSV files (intrepid-remap-col-structure) - we could remove it Intrepid load: grabs CSV data and places it into the mirror (csv-diff) creates a delta file and then uploads to db Intrepid conosolidated etl: points to the mirror and populates the TIS system
    
    • pipeline script from SCM
    • SCM: TIS-DEVOPS
    • script: jenkins/intrepid-etl-prod.groovy
    • jenkins/intrepid-etl-prod.groovy can run intrepid-extract-all, intrepid-remapper-structure, intrepid-load, intrepid-extract-upload, intrepid-compare-stats




    intrepid-etl-pipeline-new

    • pipeline script from SCM
    • SCM: TIS-DEVOPS
    • script: jenkins/intrepid-etl-prod-new.groovy
    • jenkins/intrepid-etl-prod-new.groovy runs ansible/tasks/intrepid-extract-new.yml with intrepid_dr_settings=<dr2|mirror-prod> schema=R1 mirror_settings=mirror-prod
      batch_size=20

    no
    • 2h45
    • daily


    intrepid-extract-all
    • runs ansible/tasks/intrepid-extract-all.yml in PROD
    • ansible/tasks/intrepid-extract-all.yml: deploys docker image repository.tis.nhs.uk:5000/hee/intrepid-extract:{{ versions['intrepid-extract'] }}
    nono

    intrepid-extract-dr2

    • disabled, last successful run 2017 Nov 30th
    • runs ansible/tasks/intrepid-extract-new.yml on ETL hosts in PROD
    no
    • midnight
    • daily


    intrepid-dr-etl-build

    • This is the main job for notifications
    • It is triggered by a push into TIS-INTREPID-DR-ETL github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev
    yesno

    intrepid-compare-stats

    • triggered by intrepid-etl-pipeine
    • runs ansible/tasks/intrepid-compare-stats.yml in PROD
    • runs mvn on ETL hosts to create jarfile, then java -jar jarfile
    • compares count of items in the prod dr against the mirror




    intrepid-compare-stats-etl

    • disabled, last run 2017 Nov 9th
    • runs ansible/tasks/intrepid-compare-stats.yml in PROD, with DEVOPS_BASE=/datadrive/data/fayaz/master/devops




    intrepid-extract-clean


    • runs ansible/tasks/intrepid-extract-
    all
    • clean.yml
    in PRODansible/tasks/intrepid
    • -
    extract-all.yml: deploys docker image repository.tis.nhs.uk:5000/hee/intrepid-extract:{{ versions['intrepid-extract'] }}nono

    intrepid-extract-dr2

  • disabled, last successful run 2017 Nov 30th
    • -limit 10.140.0.1 in PROD on ETL 
    • runs automatically
    • removes old files from /datadrive/data/intrepid
    no
    • midnight
    • daily


    intrepid-reval-etl-dev

    • runs ansible/tasks/intrepid-reval-
    extract
    • etl-
    new
    • all.yml
    on ETL hosts
    • in
    PROD
    • DEV
    no
    midnight
    no
  • daily


  • intrepid-
    dr
    reval-etl-
    build
    • This is the main job for notifications
    • It is triggered by a push into TIS-INTREPID-DR-ETL github repo
    • It creates the JAR and Docker image by running service-pipeline
    • When FINALTAG is set, it deploys generic-upload into dev
    yesno

    intrepid-compare-stats

    triggered by intrepid-etl-pipeine
    stage
    • runs ansible/tasks/intrepid-reval-etl-all.yml in STAGE
    nono

    intrepid-reval-etl-uidev
    • runs ansible/tasks/intrepid-
    compare
    • reval-etl-
    stats
    • all.yml in
    PROD
  • runs mvn on ETL hosts to create jarfile, then java -jar jarfile
  • compares count of items in the prod dr against the mirror
  • intrepid-compare-stats-etl

    • disabled, last run 2017 Nov 9th
    • runs ansible/tasks/intrepid-compare-stats.yml in PROD, with DEVOPS_BASE=/datadrive/data/fayaz/master/devops

    intrepid-extract-clean

    • runs ansible/tasks/intrepid-extract-clean.yml --limit 10.140.0.1 in PROD on ETL 
    • runs automatically
    • removes old files from /datadrive/data/intrepid
    no
    • midnight
    • daily

    intrepid-reval-etl-dev

    • runs ansible/tasks/intrepid-reval-etl-all.yml in DEV
    nonointrepid-reval-etl-stage
    • UIDEV
    nono

    db-to-csv-parent

    yesno

    intrepid-extract-docker

    • It is triggered by a push into TIS-DB-TO-CSV github repo
    • It can be triggered by db-to-csv-parent
    • It runs mvn clean install -e on TIS-DB-TO-CSV/db-to-csv pom.xml file
    • It runs ansible/tasks/spring-boot-build.yml in DEV on localhost
    • it runs mvn2docker to create an image named intrepid-extract
    • When FINALTAG is set, it deploys generic-upload into dev ????
    yesno

    intrepid-extract-upload

    • triggered by intrepid-etl-pipeine
    • compresses and uploads intrepid databases to azure blob storage ???
    • runs ansible/tasks/intrepid-
    reval
    • extract-
    etl-all
    • upload.yml in
    STAGEnonointrepid-reval-etl-uidev
    • runs ansible/tasks/intrepid-reval-etl-all.yml in UIDEV
    nono

    db-to-csv-parent

    yesno

    intrepid-extract-docker

    • It is triggered by a push into TIS-DB-TO-CSV github repo
    • It can be triggered by db-to-csv-parent
    • It runs mvn clean install -e on TIS-DB-TO-CSV/db-to-csv pom.xml file
    • It runs ansible/tasks/spring-boot-build.yml in DEV on localhost
    • it runs mvn2docker to create an image named intrepid-extract
    • When FINALTAG is set, it deploys generic-upload into dev ????
    yesno

    intrepid-extract-upload

    • triggered by intrepid-etl-pipeine
    • compresses and uploads intrepid databases to azure blob storage ???
    • runs ansible/tasks/intrepid-extract-upload.yml in PROD on ETL hosts

    intrepid-extract-all-etl

    • uses export DEVOPS_BASE=/datadrive/data/fayaz/master/devops in PROD
    • last run 2017 November 9th
    • deploys docker image repository.tis.nhs.uk:5000/hee/intrepid-extract:{{ versions['intrepid-extract'] }}
    • extracts intrepid databases

    intrepid-schema-validation

    Code Blockcompares the schema csv exports daily to make sure that the structure hasn't changed.
    • PROD on ETL hosts




    intrepid-extract-all-etl


    • uses export DEVOPS_BASE=/datadrive/data/fayaz/master/devops in PROD
    • last run 2017 November 9th
    • deploys docker image repository.tis.nhs.uk:5000/hee/intrepid-extract:{{ versions['intrepid-extract'] }}
    • extracts intrepid databases




    intrepid-schema-validation


    Code Block
    compares the schema csv exports daily to make sure that the structure hasn't changed.
    • watches intrepid-etl-pipeine as a trigger
    • runs ansible/tasks/intrepid-schema-validation.yml on Localhost
    • runs mvn on ETL hosts to create jarfile, then java -jar jarfile




    intrepid-etl-pipeline-stage


    Code Block
    Runs the second part of the pipeline for intrepid-etl on the mirror stage
    Intrepid data anonymizer - takes data from ssh hee-build-azure -> /datadrive/data/intrepid/prod/ (full+delta) anonymises it then places it into /datadrive/data/intrepid/stage/ (full+delta)
    Intepid Load Mirror -> takes data from /datadrive/data/intrepid/stage/ , creates a delta file then loads it into mirror stage
    Intrepid revalidation stage -> the reval etl on stage
  • runs ansible/tasks/intrepid-schema-validation.yml on Localhost
  • runs mvn on ETL hosts to create jarfile, then java -jar jarfile
    • pipeline script from SCM
    • SCM: TIS-DEVOPS
    • script: jenkins/intrepid-etl-stage.groovy
    • jenkins/intrepid-etl-stage.groovy runs jenkins jobs intrepid-anonymizer, intrepid-load-stage, intrepid-reval-etl-stage




    intrepid-etl-pipeline-stage-new



    Code Block
    Runs the second part of the pipeline for intrepid-etl on the mirror stage
    Intrepid data anonymizer - takes data from ssh hee-build-azure -> /datadrive/data/intrepid/prod/ (full+delta) anonymises it then places it into /datadrive/data/intrepid/stage/ (full+delta)
    Intepid Load Mirror -> takes data from /datadrive/data/intrepid/stage/ , creates a delta file then loads it into mirror stage
    Intrepid revalidation stage -> the reval etl on stage
    jenkins
    •  jenkins/intrepid-etl-stage-new.groovy
    • jenkins/intrepid-etl-stage-new.groovy
    runs jenkins jobs 
    • : runs ansible/tasks/intrepid-anonymizer
    intrepid-load-stage, intrepid-reval-etl-stage

    intrepid-etl-pipeline-stage-new

    Code Block
    Runs the second part of the pipeline for intrepid-etl on the mirror stage
    Intrepid data anonymizer - takes data from ssh hee-build-azure -> /datadrive/data/intrepid/prod/ (full+delta) anonymises it then places it into /datadrive/data/intrepid/stage/ (full+delta)
    Intepid Load Mirror -> takes data from /datadrive/data/intrepid/stage/ , creates a delta file then loads it into mirror stage
    Intrepid revalidation stage -> the reval etl on stage
    • watches intrepid-etl-pipeine as a trigger
    • pipeline script from SCM
    • SCM: TIS-DEVOPS
    • script: jenkins/intrepid-etl-stage-new.groovy
    • jenkins/intrepid-etl-stage-new.groovy: runs ansible/tasks/intrepid-anonymizer-new.yml --extra-vars='intrepid_dr_settings=dr2 mirror_settings=mirror-stage batch_size=20 in DEV by default

    intrepid-extract-upload-etl

    • disabled, last successful run 2017 Nov 9th
    Code Block
    compresses and uploads intrepid databases in azure
    runs ansible/tasks/intrepid-extract-upload.yml in PROD using DEVOPS
    • -new.yml --extra-vars='intrepid_dr_settings=dr2 mirror_settings=mirror-stage batch_size=20 in DEV by default




    intrepid-extract-upload-etl

    • disabled, last successful run 2017 Nov 9th
    Code Block
    compresses and uploads intrepid databases in azure
    • runs ansible/tasks/intrepid-extract-upload.yml in PROD using DEVOPS_BASE=/datadrive/data/fayaz/master/devops




    intrepid-remapper-structure


    Code Block
    Remaps the Intrepid DR structure
    • runs ansible/tasks/intrepid-remapper-structure.yml with inventory=localhost on ETL hosts
    • runs mvn on ETL hosts to create jarfile, then java -jar jarfile
    nonp


    intrepid-remapper-structure

    • runs ansible/tasks/intrepid-remapper-structure.yml with inventory localhost
    • ansible/tasks/intrepid-remapper-structure.yml: runs mvn on ETL hosts to create jarfile, then java -jar jarfile
    • can be run by  intrepid-etl-pipeine
    nono

    intrepid-extract-consolidated


    • runs ansible/tasks/intrepid-extract-consolidated.yml in PROD
    • ansible/tasks/intrepid-extract-consolidated.yml does not exist
    • last successfull run: 2017-07-23




    intrepid-remapper-structure-etl


    • disabled, last run 2017 Nov 9th
    • runs ansible/tasks/intrepid-remapper-structure.yml with DEVOPS_BASE=/datadrive/data/fayaz/master/devops




    intrepid

    -remapper-structure
    Code Block
    Remaps the Intrepid DR structure
    runs ansible

    -reval-etltype-schema-env


    • runs ansible/tasks/intrepid-reval-etl-all.yml --extra-vars="etl_type=${ETLTYPE}"
    • ETLTYPE= <arcp|connectionDiscrepancies|contactDetails|placements|revalidation|selfDeclaration|traineeCard>
    • ansible/tasks/intrepid-reval-
    remapper
    • etl-
    structure.yml with inventory=localhost on ETL hosts
  • runs mvn on ETL hosts to create jarfile, then java -jar jarfile
  • nonp

    intrepid-remapper-structure

    • runs ansible/tasks/intrepid-remapper-structure.yml with inventory localhost
    • ansible/tasks/intrepid-remapper-structure.yml: runs mvn on ETL hosts to create jarfile, then java -jar jarfile
    • can be run by  intrepid-etl-pipeine
    nono

    intrepid-extract-consolidated

    • runs ansible/tasks/intrepid-extract-consolidated.yml in PROD
    • ansible/tasks/intrepid-extract-consolidated.yml does not exist
    • last successfull run: 2017-07-23

    intrepid-remapper-structure-etl

    • disabled, last run 2017 Nov 9th
    • runs ansible/tasks/intrepid-remapper-structure.yml with DEVOPS_BASE=/datadrive/data/fayaz/master/devops

    intrepid-reval-etltype-schema-env

    • runs ansible/tasks/intrepid-reval-etl-all.yml --extra-vars="etl_type=${ETLTYPE}"
    • ETLTYPE= <arcp|connectionDiscrepancies|contactDetails|placements|revalidation|selfDeclaration|traineeCard>
    • ansible/tasks/intrepid-reval-etl-all.yml deploys repository.tis.nhs.uk:5000/hee/intrepid-dr-etl:{{ versions['intrepid-reval-etl'] }}

    test-intrepid-connection

    • disabled, last run 2017 March 13th
    • runs /opt/mssql-tools/bin/sqlcmd
    Consolidated-DR-ETLconsolidated-dr-etl-all-parameterised-dev




    test-intrepid-connection

    • disabled, last run 2017 March 13th
    • runs /opt/mssql-tools/bin/sqlcmd









    Consolidated-DR-ETL

    consolidated-dr-etl-all-parameterised-dev

    • pipeline script from SCM
    • SCM: TIS-DEVOPS
    • script: jenkins/consolidated-dr-etl.groovy
    • jenkins/consolidated-dr-etl.groovy: runs ansible/tasks/consolidated-dr-etl-old.yml or ansible/tasks/consolidated-dr-etl-all.yml

    nono

    consolidated-dr-etl-all-parameterised-dev-tisdev4305
    • disabled

    • Code Block
      This is to test a new parameter for consolidated-dr-etl-all-parameterised-dev 
      The new parameter is POST_PROGRAMME_STEP_ENABLED 
      We use a new branch named TISDEV-4305-POST_PROGRAMME_STEP_ENABLED of TIS-DEVOPS and a modified version of jenkins/consolidated-dr-etl.groovy
      






    consolidated-dr-etl-all-parameterised-stage
    • collects lots of parameters
    • runs jenkins/consolidated-dr-etl.groovy
    • jenkins/consolidated-dr-etl.groovy: runs ansible/tasks/consolidated-dr-etl-old.yml or ansible/tasks/consolidated-dr-etl-all.yml
    • by default, ENVIRONMENT=prod
    nono

    consolidated-dr-etl-all-parameterised-prod


    • collects lots of parameters
    • runs jenkins/consolidated-dr-etl.groovy
    • jenkins/consolidated-dr-etl.groovy: runs ansible/tasks/consolidated-dr-etl-old.yml or ansible/tasks/consolidated-dr-etl-all.yml
    • by default, ENVIRONMENT=prod
    no
    • 05h30
    • daily