p9vq4BXK

1#!/usr/bin/env bash
2
3set -euo pipefail
4
5key=${1-$(date)}
6
7function finish {
8  killall -9 cockroach
9}
10trap finish EXIT
11
12sudo ntpdate -u time.apple.com
13
14./cockroach start --insecure --background
15./cockroach sql --insecure <<EOF
16SET CLUSTER SETTING trace.debug.enable = true;
17CREATE DATABASE IF NOT EXISTS time;
18CREATE TABLE IF NOT EXISTS time.kv (id STRING PRIMARY KEY, v STRING);
19
20UPSERT INTO time.kv VALUES('${key}', '${key}');
21EOF
22
23./cockroach quit --insecure
24
25sleep 1
26
27sudo gdate -s '1 minute ago'
28
29#COCKROACH_SIMULATED_OFFSET=-20s
30./cockroach start --insecure --background --logtostderr=INFO --background
31
32out=$(echo "SELECT * FROM time.kv WHERE id = '${key}';" | ./cockroach sql --insecure --format=csv)
33
34echo "*****************************"
35echo "${out}"
36echo "*****************************"
37echo "${out}" | grep -F '1 row'