liangway

SELECT 
   Flight.FlightNumber,
   (SELECT SUM(Passenger.BaggageWeight) 
    FROM Flight 
    INNER JOIN Passenger ON Flight.id = Passenger.FlightId )
FROM Flight
GROUP BY Flight.id;

liangway

// Example of http get
// 1_http_get.js
import http from 'k6/http';
import { sleep } from 'k6';

export default function() {
    http.get('http://test.k6.io');
    sleep(1);
}

liangway

# update key values in secrets or config
kubectl get secrets some-secrets -o yaml --export > some-secrets.yaml
echo AAAAAA | base64
kubectl apply –f some-secrets.yaml

liangway

minikube start

docker build . -t higo

# Start docker registry
docker run --rm -it --network=host alpine ash -c "apk add socat && socat TCP-LISTEN:5000,reuseaddr,fork TCP:$(minikube ip):5000"

docker run --rm -it -p 8080:8080 higo

liangway

#!/usr/bin/env bash

for j in $(kubectl get jobs -o custom-columns=:.metadata.name)
do
  if [[ $j == YOUR-JOB-PREFIX* ]] ; #Change the job prefix to delete other jobs
    then
        echo Delete job $j
        kubectl delete jobs $j &
    fi
done

liangway

apt-get update
apt-get install postgresql-client

Ref. https://www.compose.com/articles/postgresql-tips-installing-the-postgresql-client/

liangway

Ref. https://stackoverflow.com/questions/44918228/how-to-generate-html-report-in-jmeter

To generate Dashboard report follow the instruction below:

Generating Report Dashboard.

Generation from an existing sample CSV log file:

jmeter -g <log file> -o <Path to output folder>