Db
in package
Wrapper class for PDO library.
Table of Contents
Properties
- $activeDBConnections : array<string|int, mixed>
- $connFlags : array<string|int, mixed>
- $dbConnectionAlias : string|null
- $driver : string|null
- $finalMethods : mixed
- $reflectionPDO : PDO|null
- $reflectionPDOStatement : PDOStatement|null
- $stm : PDOStatement|null
Methods
- __call() : void
- Makes mathod calls to PDO connection.
- connect() : Db|PDO
- Generic method to handle diffrent DB drivers.
- lastInsertId() : int|bool
- Returns the last inserted id
- getMssqlPDO() : PDO
- Connects to MSSQL database.
- getMysqlPDO() : PDO
- Connects to MySQL database.
- getPostgresPDO() : PDO
- Connects to PostgreSQL database.
- getSqlitePDO() : void
- Connects to SQLite database.
- processReflection() : mixed
- Processes a reflection object and executes the requested method.
Properties
$activeDBConnections
private
array<string|int, mixed>
$activeDBConnections
= []
$connFlags
private
array<string|int, mixed>
$connFlags
= [\PDO::ATTR_PERSISTENT => true, \PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION, \PDO::ATTR_DEFAULT_FETCH_MODE => \PDO::FETCH_ASSOC, \PDO::ATTR_TIMEOUT => 1]
$dbConnectionAlias
private
string|null
$dbConnectionAlias
= null
$driver
private
string|null
$driver
= null
$finalMethods
private
mixed
$finalMethods
= ['getColumnMeta', 'columnCount', 'rowCount']
$reflectionPDO
private
PDO|null
$reflectionPDO
= null
$reflectionPDOStatement
private
PDOStatement|null
$reflectionPDOStatement
= null
$stm
private
PDOStatement|null
$stm
= null
Methods
__call()
Makes mathod calls to PDO connection.
public
__call(string $method, array<string|int, mixed> $arguments) : void
Parameters
- $method : string
- $arguments : array<string|int, mixed>
Tags
connect()
Generic method to handle diffrent DB drivers.
public
connect([string|null $driver = null ]) : Db|PDO
Parameters
- $driver : string|null = null
-
sqliteorsqlite:db_alias, if it's null, the driver will be get from config('db.default') field.
Return values
Db|PDOlastInsertId()
Returns the last inserted id
public
lastInsertId() : int|bool
Return values
int|boolgetMssqlPDO()
Connects to MSSQL database.
private
getMssqlPDO() : PDO
Return values
PDOgetMysqlPDO()
Connects to MySQL database.
private
getMysqlPDO() : PDO
Return values
PDOgetPostgresPDO()
Connects to PostgreSQL database.
private
getPostgresPDO() : PDO
Return values
PDOgetSqlitePDO()
Connects to SQLite database.
private
getSqlitePDO() : void
processReflection()
Processes a reflection object and executes the requested method.
private
processReflection(object $reflection, object $object, string $method, array<string|int, mixed> $arguments) : mixed
Parameters
- $reflection : object
- $object : object
- $method : string
- $arguments : array<string|int, mixed>