105 lines
2.5 KiB
Plaintext
105 lines
2.5 KiB
Plaintext
|
|
--source include/have_example_plugin.inc
|
|
--source include/have_debug.inc
|
|
--source include/have_debug_sync.inc
|
|
|
|
connect(con1, localhost, root,,);
|
|
|
|
--connection default
|
|
|
|
--disable_result_log
|
|
SHOW PLUGINS;
|
|
--enable_result_log
|
|
|
|
SELECT PLUGIN_NAME, PLUGIN_STATUS, LOAD_OPTION from INFORMATION_SCHEMA.PLUGINS
|
|
WHERE PLUGIN_NAME like 'pfs_example%';
|
|
|
|
--connection con1
|
|
|
|
SET DEBUG_SYNC='in_plugin_initialize WAIT_FOR go_init';
|
|
|
|
--echo "con1 installing plugin ..."
|
|
--replace_regex /\.dll/.so/
|
|
--send_eval INSTALL PLUGIN pfs_example_plugin_employee SONAME '$PFS_EXAMPLE_PLUGIN_EMPLOYEE'
|
|
|
|
--connection default
|
|
|
|
# Wait for INSTALL PLUGIN to hit in_plugin_initialize
|
|
let $wait_condition= SELECT count(*) = 1 FROM INFORMATION_SCHEMA.PLUGINS
|
|
WHERE PLUGIN_NAME like 'pfs_example%' and
|
|
PLUGIN_STATUS='INACTIVE';
|
|
--source include/wait_condition.inc
|
|
|
|
# Observe the INACTIVE status
|
|
|
|
--disable_result_log
|
|
SHOW PLUGINS;
|
|
--enable_result_log
|
|
|
|
SELECT PLUGIN_NAME, PLUGIN_STATUS, LOAD_OPTION from INFORMATION_SCHEMA.PLUGINS
|
|
WHERE PLUGIN_NAME like 'pfs_example%';
|
|
|
|
SET DEBUG_SYNC='now SIGNAL go_init';
|
|
|
|
--connection con1
|
|
--reap
|
|
|
|
--connection default
|
|
|
|
# Wait for INSTALL PLUGIN to complete
|
|
let $wait_condition= SELECT count(*) = 1 FROM INFORMATION_SCHEMA.PLUGINS
|
|
WHERE PLUGIN_NAME like 'pfs_example%' and
|
|
PLUGIN_STATUS='ACTIVE';
|
|
--source include/wait_condition.inc
|
|
|
|
# Observe the ACTIVE status
|
|
|
|
--disable_result_log
|
|
SHOW PLUGINS;
|
|
--enable_result_log
|
|
|
|
SELECT PLUGIN_NAME, PLUGIN_STATUS, LOAD_OPTION from INFORMATION_SCHEMA.PLUGINS
|
|
WHERE PLUGIN_NAME like 'pfs_example%';
|
|
|
|
--connection con1
|
|
|
|
SET DEBUG_SYNC='in_plugin_check_uninstall WAIT_FOR go_deinit';
|
|
|
|
--send UNINSTALL PLUGIN pfs_example_plugin_employee;
|
|
|
|
--connection default
|
|
|
|
# Wait for UNINSTALL PLUGIN to hit in_plugin_check_uninstall
|
|
let $wait_condition= SELECT count(*) = 1 FROM INFORMATION_SCHEMA.PLUGINS
|
|
WHERE PLUGIN_NAME like 'pfs_example%' and
|
|
PLUGIN_STATUS ='DELETING';
|
|
--source include/wait_condition.inc
|
|
|
|
# Observe the DELETING status
|
|
|
|
--disable_result_log
|
|
SHOW PLUGINS;
|
|
--enable_result_log
|
|
|
|
SELECT PLUGIN_NAME, PLUGIN_STATUS, LOAD_OPTION from INFORMATION_SCHEMA.PLUGINS
|
|
WHERE PLUGIN_NAME like 'pfs_example%';
|
|
|
|
SET DEBUG_SYNC='now SIGNAL go_deinit';
|
|
|
|
--connection con1
|
|
--reap
|
|
|
|
--connection default
|
|
|
|
# Observe the plugin is gone
|
|
|
|
--disable_result_log
|
|
SHOW PLUGINS;
|
|
--enable_result_log
|
|
|
|
SELECT PLUGIN_NAME, PLUGIN_STATUS, LOAD_OPTION from INFORMATION_SCHEMA.PLUGINS
|
|
WHERE PLUGIN_NAME like 'pfs_example%';
|
|
|
|
--disconnect con1
|
|
|