Routines
class Routines (View source)
Functions for routine management.
Properties
| array<int,string> | $directions | ||
| array<int,string> | $sqlDataAccess | ||
| array<int,string> | $numericOptions |
Methods
Handle request to create or edit a routine
Create the routine
Flush privileges and get message
This function will generate the values that are required to complete the editor form. It is especially necessary to handle the 'Add another parameter', 'Remove last parameter' and 'Change routine type' functionalities when JS is disabled.
This function will generate the values that are required to complete the "Edit routine" form given the name of a routine.
Creates one row for the parameter table used in the routine editor.
Composes the query necessary to create a routine from an HTTP request.
No description
Creates the HTML code that shows the routine execution dialog.
returns details about the PROCEDUREs or FUNCTIONs for a specific database or details about a specific routine
No description
Details
__construct(DatabaseInterface $dbi)
No description
string
handleRequestCreateOrEdit(UserPrivileges $userPrivileges, string $db, ServerRequest $request)
Handle request to create or edit a routine
array
backupPrivileges(UserPrivileges $userPrivileges)
Backup the privileges
array
create(UserPrivileges $userPrivileges, string $routineQuery, string $createRoutine, array $privilegesBackup)
Create the routine
Message
flushPrivileges(bool $flushPrivileges)
Flush privileges and get message
array
getDataFromRequest()
This function will generate the values that are required to complete the editor form. It is especially necessary to handle the 'Add another parameter', 'Remove last parameter' and 'Change routine type' functionalities when JS is disabled.
array|null
getDataFromName(string $name, string $type, bool $all = true)
This function will generate the values that are required to complete the "Edit routine" form given the name of a routine.
array
getParameterRow(array $routine = [], mixed $index = null, string $class = '')
Creates one row for the parameter table used in the routine editor.
string
getQueryFromRequest(ServerRequest $request)
Composes the query necessary to create a routine from an HTTP request.
array
handleExecuteRoutine(array $routine)
No description
array
getExecuteForm(array $routine)
Creates the HTML code that shows the routine execution dialog.
array
getRow(Routine $routine, string $rowClass = '')
Creates the contents for a row in the list of routines
static array
getDetails(DatabaseInterface $dbi, string $db, RoutineType|null $which = null, string $name = '', int $limit = 0, int $offset = 0)
returns details about the PROCEDUREs or FUNCTIONs for a specific database or details about a specific routine
static int
getRoutineCount(DatabaseInterface $dbi, string $db, RoutineType|null $which = null)
No description
static string|null
getFunctionDefinition(DatabaseInterface $dbi, string $db, string $name)
No description
static string|null
getProcedureDefinition(DatabaseInterface $dbi, string $db, string $name)
No description
static array
getNames(DatabaseInterface $dbi, string $db, RoutineType $type)
No description
int
getErrorCount()
No description