\MocaBonita\tools\eloquentMbDatabaseManager

getInstance()

getInstance() : static

The singleton pattern is useful when we need to make sure that we only have a single instance of a class for the entire request lifecycle in a Web application. This usually occurs when we have global objects (such as a configuration class) or a resource (Such as an event queue).

Returns

__clone()

__clone() 

Clone Not allowed

Throws

\MocaBonita\tools\MbException

__wakeup()

__wakeup() 

WakeUp Not allowed.

Throws

\MocaBonita\tools\MbException

table()

table(string  $table) : \Illuminate\Database\Query\Builder

Begin a fluent query against a database table.

Parameters

Returns

raw()

raw(mixed  $value) : \Illuminate\Database\Query\Expression

Get a new raw query expression.

Parameters

Returns

selectOne()

selectOne(string  $query, array  $bindings = array()) : mixed

Run a select statement and return a single result.

Parameters

Throws

\Illuminate\Database\QueryException

Returns

select()

select(string  $query, array  $bindings = array()) : array

Run a select statement against the database.

Parameters

Throws

\Illuminate\Database\QueryException

Returns

bindAndRun()

bindAndRun(string  $query, array  $bindings = array()) : array

Bind and run the query

Parameters

Throws

\Illuminate\Database\QueryException

Returns

insert()

insert(string  $query, array  $bindings = array()) : boolean

Run an insert statement against the database.

Parameters

Returns

update()

update(string  $query, array  $bindings = array()) : integer

Run an update statement against the database.

Parameters

Returns

delete()

delete(string  $query, array  $bindings = array()) : integer

Run a delete statement against the database.

Parameters

Returns

statement()

statement(string  $query, array  $bindings = array()) : boolean

Execute an SQL statement and return the boolean result.

Parameters

Returns

affectingStatement()

affectingStatement(string  $query, array  $bindings = array()) : integer

Run an SQL statement and get the number of rows affected.

Parameters

Returns

unprepared()

unprepared(string  $query) : boolean

Run a raw, unprepared query against the PDO connection.

Parameters

Throws

\Illuminate\Database\QueryException

Returns

prepareBindings()

prepareBindings(array  $bindings) : array

Prepare the query bindings for execution.

Parameters

Returns

transaction()

transaction(\Closure  $callback, integer  $attempts = 1) : mixed

Execute a Closure within a transaction.

Parameters

Throws

\Exception

Returns

beginTransaction()

beginTransaction() : void

Start a new database transaction.

commit()

commit() : void

Commit the active database transaction.

rollBack()

rollBack() : void

Rollback the active database transaction.

transactionLevel()

transactionLevel() : integer

Get the number of active transactions.

Returns

pretend()

pretend(\Closure  $callback) : array|void

Execute the given callback in "dry run" mode.

Parameters

Returns

getPostProcessor()

getPostProcessor() : \Illuminate\Database\Query\Processors\Processor

Get post processor

Returns

getQueryGrammar()

getQueryGrammar() : \Illuminate\Database\Query\Grammars\Grammar

Get query grammar

Returns

getPdo()

getPdo() : \MocaBonita\tools\eloquent\MbDatabaseManager

Return self as PDO

Returns

lastInsertId()

lastInsertId() : integer

Return the last insert id

Returns

getWpdb()

getWpdb() : \wpdb

Get Wpdb

Returns

setWpdb()

setWpdb(\wpdb  $wpdb) : \MocaBonita\tools\eloquent\MbDatabaseManager

Set Wpdb

Parameters

Returns

getSchemaBuilder()

getSchemaBuilder() 

Get a schema builder instance for the connection.

Throws

\Exception

getName()

getName() : string

WpDb Name

Returns

logQuery()

logQuery(string  $query, array  $bindings, float|null  $time = null) : void

Log a query in the connection's query log.

Parameters

getQueryLog()

getQueryLog() : array

Get the connection query log.

Returns

flushQueryLog()

flushQueryLog() : void

Clear the query log.

enableQueryLog()

enableQueryLog() : void

Enable the query log on the connection.

disableQueryLog()

disableQueryLog() : void

Disable the query log on the connection.

logging()

logging() : boolean

Determine whether we're logging queries.

Returns

__construct()

__construct() 

Singleton construct

init()

init() : void

Method to be started

getElapsedTime()

getElapsedTime(integer  $start) : float

Get the elapsed time since a given starting point.

Parameters

Returns

getLogTime()

getLogTime() : float

Get the current time

Returns

bindParams()

bindParams(  $query,   $bindings, boolean  $update = false) : mixed

A hacky way to emulate bind parameters into SQL query

Parameters

Returns