#!/bin/bash
DIR_PATH=$(cd `dirname $0`;pwd)
ROOT_PATH=$(cd ${DIR_PATH}/../../;pwd)
function help()
{
echo ""
echo "$0"
echo ""
echo "Usage: Dev_ograc_regress.sh {help} [--coverage --user]"
echo " --coverage run test with test coverage report"
echo " --user run test with user, if using docker/container.sh dev start container with different user,\n pass this user through --user, default is ogracdba"
echo " --core_dir run test with user, if using docker/container.sh dev start container with different coredir,
pass this core dir path through --core_dir, default is /home/core"
}
function collect_core()
{
collect_script=${ROOT_PATH}/CI/script/collect_corefile_ograc.sh
sh ${collect_script} ${CORE_DIR} ${TEMP_DIR} ${ROOT_PATH} ${TEST_DATA_DIR}/data ${RUN_TEST_USER}
}
stop_cms()
{
ps -fu ${RUN_TEST_USER} | grep -v grep | grep 'cms server -start' | awk '{print "kill -9 " $2}' | sh
}
function run_cms_test()
{
echo "========================= Run cms test ======================="
cd ${ROOT_PATH}
chmod 777 -R ${ROOT_PATH}/pkg/test/cms_test
if [ "${LCOV_ENABLE}" = TRUE ]; then
echo "make lcov report"
gen_lcov_report
else
echo "stop all cms"
stop_cms
fi
echo "Regress Success"
echo "=====test for cms restart db===="
su - ${RUN_TEST_USER} -c "cms res -stop db | grep -q succeed"
su - ${RUN_TEST_USER} -c "cms res -start db | grep -q succeed"
echo "cms restart db success"
}
function uninstall_ogracdb()
{
echo "========================= Uninstall ogracDB ======================="
chown -R ${RUN_TEST_USER}:${RUN_TEST_USER} /home/regress/ograc_data
su - ${RUN_TEST_USER} -c "python3 ${TEST_DATA_DIR}/install/bin/uninstall.py -U ${RUN_TEST_USER} -F -D ${TEST_DATA_DIR}/data -g withoutroot -d"
}
function install_ogracdb()
{
echo "========================= Install ogracDB ======================="
cd ${ROOT_PATH}/output/bin/oGRAC-DATABASE-LINUX-64bit
python3 install.py -U ${RUN_TEST_USER}:${RUN_TEST_USER} \
-R ${TEST_DATA_DIR}/install/ \
-D ${TEST_DATA_DIR}/data/ \
-l ${INSTALL_LOG_DIR}/install.log \
-Z SESSIONS=200 \
-Z BUF_POOL_NUM=1 \
-Z VARIANT_MEMORY_AREA_SIZE=32M \
-Z AUDIT_LEVEL=3 \
-Z USE_NATIVE_DATATYPE=TRUE \
-Z _SYS_PASSWORD=${SYS_PASSWD} \
-Z _LOG_LEVEL=255 \
-Z _LOG_MAX_FILE_SIZE=10M \
-Z STATS_LEVEL=TYPICAL \
-Z REACTOR_THREADS=1 \
-Z OPTIMIZED_WORKER_THREADS=100 \
-Z MAX_WORKER_THREADS=100 \
-Z UPPER_CASE_TABLE_NAMES=TRUE \
-Z SHARED_POOL_SIZE=1G \
-Z TEMP_BUFFER_SIZE=256M \
-Z DATA_BUFFER_SIZE=2G \
-Z _MAX_VM_FUNC_STACK_COUNT=10000 \
-Z MAX_COLUMN_COUNT=4096 \
-Z AUTO_INHERIT_USER=ON \
-Z PAGE_CHECKSUM=TYPICAL \
-g withoutroot -d -M ogracd -c
result=`cat ${TEST_DATA_DIR}/data/log/ogracstatus.log |grep 'instance started'|wc -l`
if [ $result -eq 0 ]; then
echo "Error: install ogracdba failed"
exit 1
fi
su - ${RUN_TEST_USER} -c "OGSQL_SSL_QUIET=TRUE ${TEST_DATA_DIR}/install/bin/ogsql sys/${SYS_PASSWD}@127.0.0.1:1611 -f ${ROOT_PATH}/pkg/test/ora-dialect.sql >> ${INSTALL_LOG_DIR}/install.log 2>&1"
if [ $? -ne 0 ]; then
echo "Error: create ora-dialect failed"
exit 1
fi
}
function compile_code()
{
echo "==================== Begin Rebuild ogracKernel ================="
lcov_build_flag=""
if [ "${LCOV_ENABLE}" = TRUE ]; then
lcov_build_flag="lcov=1"
cp -f ${ROOT_PATH}/pkg/src/cms/cms/cms_main.c ${ROOT_PATH}/pkg/src/cms/cms/cms_main.c.bak
tmp_hllt_code1="#include <signal.h>"
tmp_hllt_code2="void save_llt_data(int signo){\nprintf(\"cms_main get signal=%d\",signo);\nexit(0);\n}"
tmp_hllt_code3=" signal(35,save_llt_data);"
sed -i "/cms_interface.h/a${tmp_hllt_code1}" ${ROOT_PATH}/pkg/src/cms/cms/cms_main.c
sed -i "/${tmp_hllt_code1}/a${tmp_hllt_code2}" ${ROOT_PATH}/pkg/src/cms/cms/cms_main.c
sed -i "/return cmd_def->cmd_pro_func(argc, argv);/i${tmp_hllt_code3}" ${ROOT_PATH}/pkg/src/cms/cms/cms_main.c
echo "finish modify main function"
fi
cd ${ROOT_PATH}/build
sh Makefile.sh clean
echo "### Compile & Make ogracKernel and OGSQL, no errors and warnings are allowed"
sh Makefile.sh make_ograc_pkg_test ${lcov_build_flag} | tee -a ${COMPILE_LOG}
if [ "${LCOV_ENABLE}" = TRUE ]; then
mv -f ${ROOT_PATH}/pkg/src/cms/cms/cms_main.c.bak ${ROOT_PATH}/pkg/src/cms/cms/cms_main.c
echo "Restoring the cms_main.c file"
chown ${RUN_TEST_USER}:${RUN_TEST_USER} -R ${ROOT_PATH}/build
fi
echo "### Compile & Make ogracKernel and OGSQL success"
}
function parse_parameter()
{
ARGS=$(getopt -o c:u:d: --long coverage:,user:,core_dir:,og_schedule_list: -n "$0" -- "$@")
if [ $? != 0 ]; then
echo "Terminating..."
exit 1
fi
eval set -- "${ARGS}"
declare -g LCOV_ENABLE=FALSE
declare -g RUN_TEST_USER="ogracdba"
declare -g CORE_DIR="/home/core"
declare -g OG_SCHEDULE_LIST="og_schedule"
while true
do
case "$1" in
-c | --coverage)
LCOV_ENABLE=TRUE
shift 2
;;
-u | --user)
RUN_TEST_USER="$2"
shift 2
;;
-d | --core_dir)
CORE_DIR="$2"
shift 2
;;
-g | --og_schedule_list)
OG_SCHEDULE_LIST="$2"
shift 2
;;
--)
shift
break
;;
*)
help
exit 0
;;
esac
done
declare -g TEST_DATA_DIR="/home/${RUN_TEST_USER}/og_regress"
declare -g INSTALL_LOG_DIR=${TEST_DATA_DIR}/logs
declare -g TEMP_DIR=${TEST_DATA_DIR}/tmp
declare -g COMPILE_LOG=${TEST_DATA_DIR}/logs/compile_log
declare -g REGRESS_LOG=${TEST_DATA_DIR}/logs/regress_log
declare -g SYS_PASSWD=Huawei@123
}
function init_test_environment()
{
rm -rf ${TEST_DATA_DIR}
rm -rf ${INSTALL_LOG_DIR}
rm -rf ${TEMP_DIR}
rm -rf ${CORE_DIR}/*
mkdir -p ${TEST_DATA_DIR}
mkdir -p ${INSTALL_LOG_DIR}
mkdir -p ${TEMP_DIR}
mkdir -p ${CORE_DIR}
touch ${COMPILE_LOG}
touch ${REGRESS_LOG}
chown -R ${RUN_TEST_USER}:${RUN_TEST_USER} ${TEST_DATA_DIR}
chown -R ${RUN_TEST_USER}:${RUN_TEST_USER} ${CORE_DIR}
}
function check_old_install()
{
old_install=`ps -aux|grep ogracd|grep "${TEST_DATA_DIR}/data"|wc -l`
old_env_data=`cat /home/${RUN_TEST_USER}/.bashrc |grep "export OGDB_HOME="|wc -l`
if [ $old_install -ne 0 ] || [ $old_env_data -ne 0 ]; then
echo "existing install ogracdb, uninstall it first"
uninstall_ogracdb
fi
}
function gen_lcov_report()
{
pid=`ps aux | grep cms | grep -v grep | grep -v Dev_cms_test | awk '{print $2}'`
sleep 5
kill -35 $pid
if [[ ! -d "${ROOT_PATH}/lcov_output" ]]
then
mkdir -p ${ROOT_PATH}/lcov_output
echo "mkdir ${ROOT_PATH}/lcov_output"
fi
coverage_info_name="${ROOT_PATH}/lcov_output/Dev_cms_test_coverage.info"
coverage_report_name="${ROOT_PATH}/lcov_output/Dev_cms_test_coverage.report"
find ${ROOT_PATH}/ -name "*.gcno" | xargs touch
lcov --capture --directory ${ROOT_PATH}/ --rc lcov_branch_coverage=1 --output-file "${coverage_info_name}"
lcov -l --rc lcov_branch_coverage=1 "${coverage_info_name}" > "${coverage_report_name}"
lcov -d ./ -z
echo " Lcov report successfully "
}
main()
{
parse_parameter "$@"
check_old_install
init_test_environment
echo "Start compile, source code root path: ${ROOT_PATH}" > ${COMPILE_LOG}
compile_code
install_ogracdb
run_cms_test
uninstall_ogracdb
}
main "$@"
