jc1518

---
apiVersion: v1
kind: ConfigMap
metadata:
  name: jira-postgres-config
  labels:
    app: jira-postgres
data:
  POSTGRES_DB: jira
  POSTGRES_USER: admin

jc1518

---
apiVersion: v1
kind: Service
metadata:
  name: jira
  labels:
    app: jira
spec:
  type: NodePort
  ports:

jc1518

---
apiVersion: apps/v1
kind: StatefulSet
metadata:
  name: jira
spec:
  serviceName: jira
  replicas: 3
  selector:
    matchLabels:

jc1518

---
kind: PersistentVolumeClaim
apiVersion: v1
metadata:
  name: jira-share-pvc
  labels:
    app: jira-share
spec:
  accessModes:
    - ReadWriteMany

jc1518

---
apiVersion: v1
kind: ConfigMap
metadata:
  name: jira-config
  labels:
    app: jira
data:
  JVM_MINIMUM_MEMORY: 2048m
  JVM_MAXIMUM_MEMORY: 2048m

jc1518

#!/bin/bash

# Define your ECR
MY_ECR='<account>.dkr.ecr.<region>.amazonaws.com'

# Sample for scanning atlassian/jira-software:8.3
aws ecr get-login --no-include-email | bash -
aws ecr create-repository --repository-name jira --image-tag-mutability IMMUTABLE --image-scanning-configuration scanOnPush=true
docker pull atlassian/jira-software:8.3
docker tag atlassian/jira-software:8.3 ${MY_ECR}/jira:8.3

jc1518

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Effect": "Allow",
            "Action": "s3:GetObject",
            "Resource": [
                "arn:aws:s3:::aws-ssm-<region>/*",
                "arn:aws:s3:::aws-windows-downloads-<region>/*",
                "arn:aws:s3:::amazon-ssm-<region>/*",

jc1518

/*
* Jira sprint query sample
* Find out current sprint and next sprint
*/

'use strict'

const Promise = require('promise')
const request = require('request')
const lodash = require('lodash')

jc1518

/**
 * Confluence CQL sample
 * Find all spaces (including archived ones) that are in Cloud category
 */

const request = require('request')

const options = {
    headers: { "Content-Type": "application/json" },
    auth: {

jc1518

SELECT SUM(a.bytes) as UNDO_SIZE
  FROM v$datafile a,
       v$tablespace b,
       dba_tablespaces c
 WHERE c.contents = 'UNDO'
   AND c.status = 'ONLINE'
   AND b.name = c.tablespace_name
   AND a.ts# = b.ts#;