test-definitions/blob/master/auto-test/cockroach/cockroachInsecureTest.sh

#! /bin/bash 

set -x
#获得脚本文件所在的路径
basedir=$(cd `dirname $0` ;pwd)
cd $basedir 
#用相对路径执行脚本文件
. ../../lib/sh-test-lib 

#安装包以及依赖的包
install_deps cockroach
#查看这个包是否安装成功
if [ `which cockroach`  ] ;then
    lava-test-case "cockroach install " --result pass 
	echo "cockrock install ok"
else
    lava-test-case "cockroach install" --result fail 
fi
#查看这个包的版本是否是v1.0.3
version=`cockroach version | grep "Build Tag:" | awk '{print $3}'`
if [ $version = "v1.0.3"  ];then
    lava-test-case "cockroach version" --result pass 
	echo "version ok"
else
    lava-test-case "cockroach version" --result fail 
fi
#-d 表示存在目录，则删除目录
if [ -d cockroach-data ];then
    rm -rf cockroach-data
fi
#执行命令
cockroach start --insecure --host localhost --background   
#查看上一个命令的进程是否已经启动
if [ `ps -ef | grep "cockroach start" | grep -v grep | wc -l` -eq 1 ];then
    lava-test-case "cockroach start node1" --result pass 
	echo "cockroach start ok ----------------"
else
    lava-test-case "cockroach start node1" --result fail 
fi
echo ----------------
#存在node2 这个目录的话，则删除
if [ -d node2 ];then
    rm -rf node2
fi
#执行命令，参数和之前不同
cockroach start --insecure --store=node2 --host=localhost --port=26258 --http-port=8081 --join=localhost:26257 --background
if [ -d node3 ];then
    rm -rf node3
fi
cockroach start --insecure --store=node3 --host=localhost --port=26259 --http-port=8082 --join=localhost:26257 --background
#检查上一个命令是否启动进程
if [ `ps -ef |grep "cockroach start"| grep -v grep | wc -l` = 3 ] ;then
    lava-test-case "cockroach cluster start" --result pass 
	echo "cockroach cluster start ok ------------------------"
else
    lava-test-case "cockroach cluster start" --result fail
    echo "cockroach cluster start failed"
    exit 1
fi
echo 
echo "cockroach insecure cluster start successed"
echo 
#要飘键保存命令执行的结果
nodestatus1=`cockroach node ls --insecure` 
nodestatus2=`cockroach node status --insecure`
if `echo $nodestatus1 | grep "3 rows"` && `echo $nodestatus2 | grep "3 rows"`;then
    lava-test-case "cockroach status " --result pass
	echo "cockroach status ok ------------------------" 
else
    lava-test-case "cockroach status" --result fail
fi

echo 
echo "cockroach status ok"
echo 

cockroach sql --insecure -e "DROP DATABASE IF EXISTS bank;"
res=`cockroach sql --insecure -e "CREATE DATABASE bank;
				  CREATE TABLE bank.accounts (id INT PRIMARY KEY , balance DECIMAL);
				  INSERT INTO bank.accounts VALUES (1 , 1000.50);
				  SELECT * FROM bank.accounts;"`
#用飘键得到命令执行的结果
if [ `echo $res | grep "1 row" -c` -ge 1 ] ;then
    lava-test-case "cockroach node1 executer sql statement" --result pass 
else
    lava-test-case "cockroach node1 executer sql statement" --result fail 
fi

node2res=`cockroach sql --insecure --port=26258 -e "SELECT * FROM bank.accounts"`

if [  `echo $node2res | grep "1 row" -c` -ge 1  ] ;then
    lava-test-case "cockroach node2 executer sql statement" --result pass 
else
    lava-test-case "cockroach node2 executer sql statement" --result fail 
fi

#ps -ef | grep cockroach | grep node2 | grep -v grep | awk '{print $2}' | xargs kill -9
cockroach quit --insecure --port 26258
noderes=`cockroach sql --insecure -e "SELECT * FROM bank.accounts"`

if [ `echo "$noderes"| grep "1 row" -c` -ge 1  ] ;then
    lava-test-case "cockroach single point failure" --result pass 
else
    lava-test-case "cockroach single point failure" --result fail 
fi

#ps -ef | grep cockroach | grep -v grep | awk '{print $2}'| xargs kill -9

cockroach start --insecure --store=node2 --host=localhost --port=26258 --http-port=8081 --join=localhost:26257 --background

if [ `ps -ef |grep "cockroach start" | grep -v grep | wc -l` -eq 3 ];then
    lava-test-case "cockroach restart" --result pass
else
    lava-test-case "cockroach restart" --result fail
fi

cockroach quit --insecure --port 26257
cockroach quit --insecure --port 26258
cockroach quit --insecure --port 26259

stopCluster=`ps -ef | grep "cockroach start" | grep -v grep`
if [ -z  "$stopCluster" ];then
    lava-test-case "cockroach stop cluster" --result pass
else
    lava-test-case "cockroach stop cluster" --result fail
fi

remove_deps cockroach
#-z 表示不存在这个命令，这里通过用飘键保存结果
if [ -z `which cockroach` ];then
    lava-test-case "cockroach uninstall" --result pass
else
    lava-test-case "cockroach uninstall" --result fail
fi
#删除目录
rm -rf cockroach-data node2 node3

set +x