Mock Routines

At some point, we will need Mock Stored Routines.

We can implement them throug a Macro (but yes, we need Macros first!):

SELECT @MOCK('my_func(1, 2)');

...will be translated into...

if @TEST Macro is NOT set:
SELECT my_func(1, 2);

if @TEST Macro is set:
SELECT mock.my_func(1, 2);

This means that a mock-version of my_func is called, from mock db.

When a mock is called an event is triggered.

Other important Routines:
-- mock.my_func() will return 10
CALL mock._set_return_value('my_func', 10);
-- mock.my_proc() 2nd param will return 10 (it's an OUT param)
CALL mock._set_return_parameter('my_proc', 2, 10);