8a 安装部署测试脚本2（vc）

此脚本能对VC进行创库建表测试。

#!/bin/bash

read -p "输入Linux用户名: " first last
 
 
stty -echo # 不显示用户输入
read -p "请输入密码：" last  
stty echo  # 恢复显示用户输入

echo  '*******'
read -p "请输入要测试的vc名（输入数字即可）：" num

aip=`ifconfig -a|grep inet|grep -v 127.0.0.1|grep -v inet6|grep -v 192.168.122.1| awk '{print $2}'|tr -d "addr:"  `


read -p "$aip IP是否正确？ Y/N" para

case $para in
        [yY])
                ip=$aip
                echo "$ip"
                ;;
        [nN])
                read -p "输入正确的IP：" a
                echo "$a"
                ip=$a
                ;;
        *)
                echo "Invalid input ......"
                read -p "Please enter any key to exit" exit
                exit 1
esac # end case



gcadmin

s322=`date +%T+%N`
echo "========用户权限管理测试===$s322========"
gccli -uroot -vvv  -e "create role role9;
grant all on vc$num.test.* to role9;
create user user9 identified by '111111';
grant role9 to user9;
"
gccli -uuser9 -p111111 -vvv -e "quit"
e322=`date +%T+%N`
echo "========用户权限管理测试结束===$e322========"




s323=`date +%T+%N`
echo "========创建hash分布表===$s323========"
gccli -uuser9 -p111111 -vvv -e "drop database if exists vc$num.test;
create database vc$num.test;
use vc$num.test;
create table student(
sno varchar(20) DEFAULT NULL COMMENT '学号',
sname varchar(20) DEFAULT NULL COMMENT '姓名',
ssex varchar(3) DEFAULT NULL COMMENT '性别（男、女）',
sage int(4) DEFAULT NULL COMMENT '年龄',
sdept varchar(20) DEFAULT NULL COMMENT '系')
distributed by ('sno');
desc student;
"
e323=`date +%T+%N`
echo "========创建hash分布表结束===$e323========"



s324=`date +%T+%N`
echo "========大对象存储开始===$s324========"
gccli -uuser9 -p111111 -vvv -e "use vc$num.test;
create table test.t_blob(a blob,b varchar(10));
insert into test.t_blob values('abc','test');
insert into test.t_blob values('abc1','test1');
select * from test.t_blob;
update test.t_blob set a='update' where b='test';
select * from test.t_blob;
delete from test.t_blob  where b='test';
select * from test.t_blob;
"
e324=`date +%T+%N`
echo "========大对象存储结束===$e324========"


s325=`date +%T+%N`
echo "========数据加载开始===$s325========"
cd /home/gbase/
touch bimeiqi.txt

cat>>bimeiqi.txt<<EOF
111|aaa|2019-03-23 13:33:18
222|bbb|2019-06-15 06:28:25
333|ccc|2020-02-13 10:23:28
EOF

cat /home/gbase/bimeiqi.txt

gccli -uroot -vvv -e "grant file on *.*.* to user9;"
gccli -uuser9 -p111111 -vvv -e "
create database if not exists vc$num.test;
use vc$num.test;
create table test.t1(col1 int,col2 varchar(10),col3 datetime);
LOAD DATA INFILE 'sftp://$first:$last@$ip//home/gbase/bimeiqi.txt' INTO TABLE test.t1 fields terminated by '|';
select count(*) from t1;select * from t1;"
e325=`date +%T+%N`
cd /home/gbase/
rm bimeiqi.txt
echo "========数据加载结束===$e325========"

s326=`date +%T+%N`
echo "========数据库测试===$s326========"
gccli -uroot -vvv -e "create database vc$num.test1;"
gccli -uroot -vvv -e "drop database  vc$num.test1;"
e326=`date +%T+%N`
echo "========数据库测试结束===$e326========"

s327=`date +%T+%N`
echo "========表测试开始===$s327========"
gccli -uuser9 -p111111 -vvv -e "use vc$num.test;
CREATE TABLE t8(a int , b varchar(50) NOT NULL DEFAULT 'gbase');
insert into t8(a,b) values(1,2);
select * from t8;
rename table t8 to t81;
drop table t81;"
e327=`date +%T+%N`
echo "========表测试结束===$e327========"

s328=`date +%T+%N`
echo "========视图测试开始===$s328========"
gccli -uuser9 -p111111 -vvv -e"
use vc$num.test;
CREATE TABLE t(name varchar(20),address varchar(20));
INSERT INTO t(name,address) VALUES('TOM','east street');
CREATE VIEW test.v_t AS SELECT name  AS name1 ,address FROM t;
select * from test.v_t;
drop view v_t;
"
e328=`date +%T+%N`
echo "========视图测试结束===$e328========"

s329=`date +%T+%N`
echo "========索引测试开始===$s329========"
gccli -uuser9 -p111111 -vvv -e "
use vc$num.test;
CREATE TABLE t6(a int,b varchar(10));
CREATE INDEX idx1 on t6(a);
SHOW CREATE TABLE t6;
drop INDEX idx1 on t6;
drop table t6;"
e329=`date +%T+%N`
echo "========索引测试结束===$e329========"

s3210=`date +%T+%N`
echo "========函数测试开始===$s3210========"
gccli -uuser9 -p111111 -vvv -e "
use vc$num.test;
DELIMITER //  
CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) RETURN CONCAT('Hello, ',s,'!');//
DELIMITER ;
SET @result = hello('world');
SELECT @result;
"
e3210=`date +%T+%N`
echo "========函数测试结束===$e3210========"

gccli -uroot -vvv -e "drop role role9;
drop user user9;"