database CI job

1 files changed, 88 insertions, 0 deletions

diff --git a/jjb/yaml/openbook-database-pipeline.yaml b/jjb/yaml/openbook-database-pipeline.yaml
new file mode 100644
index 0000000..06d98c5
--- /dev/null
+++ b/jjb/yaml/openbook-database-pipeline.yaml
@@ -0,0 +1,88 @@
+---
+- job:
+    name: openbook-database-pipeline
+    project-type: pipeline
+    dsl: |
+      pipeline {
+          agent {
+              node {
+                label "master"
+              }
+          }
+          triggers {
+              pollSCM 'H/5 * * * *'
+          }
+          stages {
+              stage("docker-container") {
+                  agent {
+                      node {
+                          label "openbook_v4"
+                          customWorkspace "workspace/openbook-database"
+                      }
+                  }
+                  steps {
+                      checkout([
+                          scm: [
+                              $class: "GitSCM",
+                              branches: [
+                                  [name: "master"]
+                              ],
+                              userRemoteConfigs: [
+                                  [url: "git@github.com:Talligent/openbook-v4-ci.git"]
+                              ],
+                              poll: false,
+                              changelog: false
+                          ]
+                      ])
+                      sh(script: "./build-docker-containers.sh database")
+                  }
+              }
+              stage("fetch-ansible") {
+                  agent {
+                      node {
+                          label "openbook_v4"
+                          customWorkspace "workspace/openbook-v4-installer"
+                      }
+                  }
+                  steps {
+                      checkout([
+                          scm: [
+                              $class: "GitSCM",
+                              branches: [
+                                  [name: "master"]
+                              ],
+                              userRemoteConfigs: [
+                                  [url: "git@github.com:Talligent/openbook-v4-installer.git"]
+                              ],
+                              poll: false,
+                              changelog: false
+                          ]
+                      ])
+                  }
+              }
+              stage("sql-script") {
+                  agent {
+                      node {
+                          label "openbook_v4"
+                          customWorkspace "workspace/openbook-database"
+                      }
+                  }
+                  steps {
+                      checkout([
+                          scm: [
+                              $class: "GitSCM",
+                              branches: [
+                                  [name: "master"]
+                              ],
+                              userRemoteConfigs: [
+                                  [url: "git@github.com:Talligent/openbook-database.git"]
+                              ],
+                              poll: true,
+                              changelog: false
+                          ]
+                      ])
+                      sh(script: "./run-ansible-playbook.sh")
+                  }
+              }
+          }
+      }