Routines
class Routines (View source)
Functions for routine management.
Methods
Handles editor requests for adding or editing an item
Handle request to create or edit a routine
Backup the privileges
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.
Displays a form used to add/edit a routine
Composes the query necessary to create a routine from an HTTP request.
Handles requests for executing a routine
Creates the HTML code that shows the routine execution dialog.
Creates the contents for a row in the list of routines
No description
returns details about the PROCEDUREs or FUNCTIONs for a specific database or details about a specific routine
Details
__construct(DatabaseInterface $dbi, Template $template, ResponseRenderer $response)
No description
void
handleEditor()
Handles editor requests for adding or editing an item
array
handleRequestCreateOrEdit(array $errors, string $db)
Handle request to create or edit a routine
array
backupPrivileges()
Backup the privileges
array
create(string $routine_query, string $create_routine, 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.
string
getParameterRow(array $routine = [], mixed $index = null, string $class = '')
Creates one row for the parameter table used in the routine editor.
string
getEditorForm(string $mode, string $operation, array $routine)
Displays a form used to add/edit a routine
string
getQueryFromRequest()
Composes the query necessary to create a routine from an HTTP request.
void
handleExecute()
Handles requests for executing a routine
string
getExecuteForm(array $routine)
Creates the HTML code that shows the routine execution dialog.
string
getRow(array $routine, string $rowClass = '')
Creates the contents for a row in the list of routines
void
export()
No description
static array
getDetails(DatabaseInterface $dbi, string $db, string|null $which = null, string $name = '')
returns details about the PROCEDUREs or FUNCTIONs for a specific database or details about a specific routine
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
getFunctionNames(DatabaseInterface $dbi, string $db)
No description
static array
getProcedureNames(DatabaseInterface $dbi, string $db)
No description