Show the stored procedures source code using Pomm's API

show_sp_source.php

<?php

function help()
{
    printf("Get the stored procedures source code.\n");
    printf("Usage:\n");
    printf("show_sp_source schema name\n");
    printf("\nname is the stored procedure's name.\n");
    printf("schema is the database schema.\n");
    printf("environment set the database connection that will be used (default: dev).\n");
    exit(1);
}

if (PHP_SAPI !== 'cli') {
    throw new \Exception("This is a CLI tool that therefor needs to be launched in a terminal.");
}

if (count($argv) < 3 or ! preg_match("/^[a-z0-9_]+$/", $argv[1])) {
    help();
}

//$database = SET UP YOUR DATABASE HERE

$inspector = new Pomm\Tools\Inspector($database->createConnection());

foreach($inspector->getStoredProcedureSource($argv[1], $argv[2]) as $source)
{
    printf("==========\n%s\n============\n", $source);
}