Versions Compared

Key

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

...

Code Block
languagesql
scmactivity=# insert into scm_job (jobname, joblink, jobstatus, scmactivityid) values ('Build #101', 'http://jenkins', 'success', 1)
scmactivity=#


Result:


Schema (scm_activity):

Code Block
{
  "issuekey": {
    "type": "string"
  },
  "changeid": {
    "type": "string"
  },
  "changetype": { //Preferred format: ChangeType_Repo/Instance Name e.g. p4_engsw
    "type": "string"
  },
  "changeauthor": {
    "type": "string"
  },
  "changedate": { //UTC date time with format %Y-%m-%d %H:%M:%S
    "type": "string"
  },
  "changebranch": {
    "type": "string"
  },
  "changetag": {
    "type": "string"
  },
  "changestatus": {
    "type": "string"
  },
  "changelink": {
    "type": "string"
  }   
}

...