-- generating audit logs 
create user user_audit_mul_x with password 'Gauss@123';
create user user_audit_mul_y with password 'Gauss@123';
create user user_audit_mul_z with password 'Gauss@123';

select type,result,object_name,detail_info from pg_query_audit('1111-1-1','2222-2-2') where detail_info like '%create user user_audit_mul%'order by time;

-- audit thread number change to 3
\! @abs_bindir@/gs_guc reload -D @abs_srcdir@/tmp_check/datanode1/ -c "audit_thread_num=3" > /dev/null 2>&1
\! @abs_bindir@/gs_guc reload -D @abs_srcdir@/tmp_check/datanode1/ -c "audit_system_object=6" > /dev/null 2>&1
\! @abs_bindir@/gs_guc reload -D @abs_srcdir@/tmp_check/datanode1/ -c "audit_set_parameter=0" > /dev/null 2>&1

select pg_sleep(1);
\! @abs_bindir@/gs_ctl stop -D @abs_srcdir@/tmp_check/datanode1  > /dev/null
\! @abs_bindir@/gs_ctl start -D @abs_srcdir@/tmp_check/datanode1  > /dev/null
\! sleep 5

-- generating audit items
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "select * from pg_delete_audit('0007-1-1','9999-12-31');";
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "create user user_audit_mul_001 with password 'Gauss@123'";
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "create user user_audit_mul_002 with password 'Gauss@123'";
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "create user user_audit_mul_003 with password 'Gauss@123'";


-- check audit logs
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "select type,result,object_name,detail_info from pg_query_audit('1111-1-1','2222-2-2') where detail_info like '%create user user_audit_mul%'order by time;";

-- audit thread number change to 1
\! @abs_bindir@/gs_guc reload -D @abs_srcdir@/tmp_check/datanode1/ -c "audit_thread_num=1" > /dev/null 2>&1


\! @abs_bindir@/gs_ctl stop -D @abs_srcdir@/tmp_check/datanode1  > /dev/null
\! @abs_bindir@/gs_ctl start -D @abs_srcdir@/tmp_check/datanode1  > /dev/null
\! sleep 5

\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "select * from pg_delete_audit('0007-1-1','9999-12-31');";
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "create user user_audit_mul_004 with password 'Gauss@123'";
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "create user user_audit_mul_005 with password 'Gauss@123'";
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "create user user_audit_mul_006 with password 'Gauss@123'";

-- check audit logs
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "select type,result,object_name,detail_info from pg_query_audit('1111-1-1','2222-2-2') where detail_info like '%create user user_audit_mul%'order by time;";

-- reset env
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "drop user user_audit_mul_001";
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "drop user user_audit_mul_002";
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "drop user user_audit_mul_003";
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "drop user user_audit_mul_004";
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "drop user user_audit_mul_005";
\! @abs_bindir@/gsql -r -p @portstring@ -d postgres -c "drop user user_audit_mul_006";

\! @abs_bindir@/gs_guc reload -D @abs_srcdir@/tmp_check/datanode1/ -c "audit_thread_num" > /dev/null 2>&1
\! @abs_bindir@/gs_guc reload -D @abs_srcdir@/tmp_check/datanode1/ -c "audit_system_object" > /dev/null 2>&1
\! @abs_bindir@/gs_guc reload -D @abs_srcdir@/tmp_check/datanode1/ -c "audit_set_parameter" > /dev/null 2>&1
\! @abs_bindir@/gs_ctl stop -D @abs_srcdir@/tmp_check/datanode1  > /dev/null
\! @abs_bindir@/gs_ctl start -D @abs_srcdir@/tmp_check/datanode1  > /dev/null
\! sleep 5