justinhennessy

=sum(
  indirect(
    "'sheet1'!B"&MATCH(query('sheet1'!A:A,"select A where A = '"&A2&"'"),'sheet1'!A:A,0)
  ):
  indirect(
    "'sheet1'!D"&MATCH(query('sheet1'!A:A,"select A where A = '"&A2&"'"),'sheet1'!A:A,0)
  )
)

justinhennessy

require 'aws-sdk'
require 'json'

file = File.open "example.json"
data = JSON.load file

table = ARGV.shift
data["table"] = table || data["table"]

client = Aws::Lambda::Client.new

justinhennessy

class buildkite::install(
  Pattern[/(\d+\.\d+\.\d+|installed)/] $agent_version = $buildkite::agent_version,
  $agent_count = 1
) {

  # more puppet code

  if $agent_count > 1 {
    range('2', String($agent_count)).each |$extra_agent| {
      file { "/usr/lib/systemd/system/buildkite-agent${extra_agent}.service":

justinhennessy

aws_xray_sdk
boto3
datadog
doubles
flask
flask_ask

justinhennessy

#!/bin/bash

rm -rf modules || true
pip install -r requirements.txt -t modules

justinhennessy

#!/bin/bash

echo "Generatating python modules directory ..."
echo "-----------------------------------------"
echo ""
docker run -v ${PWD}:/working -it python_builder

echo ""
echo "Create code artifact ..."
echo "------------------------"

justinhennessy

# Use an official centos
FROM centos:7
# Set the working directory to /working
WORKDIR /working
RUN yum -y update
RUN yum -y install yum-utils groupinstall development
RUN yum -y install https://centos7.iuscommunity.org/ius-release.rpm
RUN yum -y install python36u
RUN yum -y install python36u-pip
RUN yum -y install python36u-devel

justinhennessy

https://p.datadoghq.com/sb/c98e1bdd3-4dcfa46b4f

justinhennessy

---
steps:
  - type: "waiter"

  - name: "Compile themes"
    command: "bin/compile"
    agents:
      queue: design
      
  - type: "waiter"

justinhennessy

#!/bin/sh

while [ 1 ]; do
  mysql -e 'select count(id) from <table>;' -h <db host> -u admin -p<password> <db>

  TZ="Australia/Brisbane" echo "`date`"
  sleep 5
done