55 lines
1.3 KiB
PHP
55 lines
1.3 KiB
PHP
#
|
|
# Check if event exists for table
|
|
#
|
|
# Arguments:
|
|
# check_event_tabname - name of table
|
|
# check_event_dbname - db of table
|
|
# [check_event_full - expect a full event]
|
|
#
|
|
# NOTE: retrieve_event_list.inc must be used before
|
|
# this inc file can be sourced
|
|
#
|
|
|
|
if (!$check_event_tabname)
|
|
{
|
|
die Need the name of table to check event for;
|
|
}
|
|
|
|
if (!$check_event_dbname)
|
|
{
|
|
die Need the db of table to check event for;
|
|
}
|
|
|
|
#
|
|
# The name for an event has form REPL[F]$<db>/<table_name>
|
|
# - the additional F is used when table should be binlogged
|
|
# with "full" rows
|
|
#
|
|
let $event_prefix = REPL;
|
|
if ($check_event_full)
|
|
{
|
|
let $event_prefix = REPLF;
|
|
}
|
|
# Expected event name, includes extra escape for the dollar
|
|
# sign avoiding that mysqltest evaluates it before sending the query
|
|
let $expected_event_name =
|
|
$event_prefix\\\$$check_event_dbname/$check_event_tabname;
|
|
#echo expected_event_name: $expected_event_name;
|
|
let $found_event = `SELECT count(*) FROM test.event_list
|
|
WHERE event_name = '$expected_event_name'`;
|
|
if ($found_event)
|
|
{
|
|
echo Found event for '$check_event_dbname.$check_event_tabname';
|
|
}
|
|
if (!$found_event)
|
|
{
|
|
echo No event found for '$check_event_dbname.$check_event_tabname';
|
|
}
|
|
|
|
# Reset args
|
|
let $check_event_tabname = ;
|
|
let $check_event_dbname = ;
|
|
let $check_event_full = ;
|
|
|
|
--enable_query_log
|