\MatthiasWeb\RealMediaLibrary\comp\complexqueryResetNames

Reset names so slugs combined to a correct absolute path.

This class is not yet used.

Summary

Methods
Properties
Constants
__construct()
getResult()
singleQuery()
procedure()
fallback()
install()
hasProcedure()
isSingleQueriableWithUserDefinedVars()
isProcedurable()
_isProcedurable()
isMysqli()
getWpdb()
getDbh()
getCache()
getPluginConstantPrefix()
installProcedure()
No public properties found
CACHE_OPTION_NAME
getProcedureResults()
No protected properties found
N/A
No private methods found
$wpdb
$isProcedurable
$cache
N/A

Constants

CACHE_OPTION_NAME

CACHE_OPTION_NAME ='mw_complex_query'

Properties

$wpdb

$wpdb :

Type

$isProcedurable

$isProcedurable :

Type

$cache

$cache :

Type

Methods

__construct()

__construct(\wpdb  $wpdb)

C'tor.

Parameters

\wpdb $wpdb

getResult()

getResult(): mixed

Get the result from the three different result types: singleQuery, procedure or fallback.

Returns

mixed

singleQuery()

singleQuery(): array

Single query.

Returns

array

procedure()

procedure(): mixed

We do not need a procedure.

A procedure can for example write into a temporary table and reads from it again.

Returns

mixed

fallback()

fallback(): mixed

We do not need a fallback.

Returns

mixed

install()

install(callable  $callable)

Start an installer. Use this function in your procedure() method.

Parameters

callable $callable

The callable to install the procedure for example

hasProcedure()

hasProcedure(string  $procedure): boolean

Checks if a given procedure is available for the current user.

Parameters

string $procedure

Returns

boolean

isSingleQueriableWithUserDefinedVars()

isSingleQueriableWithUserDefinedVars(): boolean

Checks if a single query is allowed to use @vars. For example MariaDB does not resolve @vars in a single query when they are not declared before.

This method uses a cache (30 days).

Returns

boolean

isProcedurable()

isProcedurable(): boolean

Checks if procedures are allowed. This function uses a cache (30 days).

Returns

boolean

_isProcedurable()

_isProcedurable()

Installs a procedure and checks if it can be used.

isMysqli()

isMysqli(): boolean

Checks if the database handle is mysqli or not.

Returns

boolean

getWpdb()

getWpdb(): \wpdb

Getter.

Returns

\wpdb

getDbh()

getDbh(): string

Getter.

Returns

string

getCache()

getCache(): mixed

Get cache.

Returns

mixed

getPluginConstantPrefix()

getPluginConstantPrefix(): string

Get the prefix of this plugin so composer packages can dynamically build other constant values on it.

Returns

string

installProcedure()

installProcedure()

We do not need a procedure.

getProcedureResults()

getProcedureResults(string  $sql,boolean  $returnTrue = false): Array

Call a "CALL proc" SQL and parse the results.

Parameters

string $sql

The SQL string to execute

boolean $returnTrue

When the CALL is successfully and has no results then return true instead of an empty array

Returns

Array —

or false when an error occur