Ubiquity 2.5.2
php rapid development framework
Loading...
Searching...
No Matches
PDOWrapper Class Reference
+ Inheritance diagram for PDOWrapper:

Public Member Functions

 __construct ($dbType='mysql')
 
 fetchAllColumn ($statement, array $values=null, string $column=null)
 
 lastInsertId ($name=null)
 
 fetchAll ($statement, array $values=null, $mode=null)
 
 fetchOne ($statement, array $values=null, $mode=null)
 
 prepareStatement (string $sql)
 
 fetchColumn ($statement, array $values=null, int $columnNumber=null)
 
 getStatement ($sql)
 
 execute ($sql)
 
 connect (string $dbType, $dbName, $serverName, string $port, string $user, string $password, array $options)
 
 getDSN (string $serverName, string $port, string $dbName, string $dbType='mysql')
 
 bindValueFromStatement ($statement, $parameter, $value)
 Used by DAO.
 
 query (string $sql)
 
 queryAll (string $sql, int $fetchStyle=null)
 
 queryColumn (string $sql, int $columnNumber=null)
 
 executeStatement ($statement, array $values=null)
 
 getTablesName ()
 
 statementRowCount ($statement)
 
 inTransaction ()
 
 commit ()
 
 rollBack ()
 
 beginTransaction ()
 
 savePoint ($level)
 
 releasePoint ($level)
 
 rollbackPoint ($level)
 
 nestable ()
 
 ping ()
 
 getPrimaryKeys ($tableName)
 
 getForeignKeys ($tableName, $pkName, $dbName=null)
 
 getFieldsInfos ($tableName)
 
 _optPrepareAndExecute ($sql, array $values=null, $one=false)
 
 _optExecuteAndFetch ($statement, array $values=null, $one=false)
 
 quoteValue ($value, $type=2)
 
 getRowNum (string $tableName, string $pkName, string $condition)
 
 groupConcat (string $fields, string $separator)
 
 toStringOperator ()
 
 migrateOperation (string $operation)
 Returns the SQL string for a migration operation.
 
 setIsolationLevel ($isolationLevel)
 Sets the isolation level for transactions.
 
- Public Member Functions inherited from AbstractDbWrapper
 _getStatement (string $sql)
 
 prepareNamedStatement (string $name, string $sql)
 
 getNamedStatement (string $name, ?string $sql=null)
 
 getStatement (string $sql)
 
 execute (string $sql)
 
 close ()
 
 getDbInstance ()
 
 setDbInstance ($dbInstance)
 
 getPHPType (string $dbType)
 

Static Public Member Functions

static getAvailableDrivers ()
 

Protected Member Functions

 getDriverMetaDatas ()
 

Protected Attributes

 $driversMetasClasses = [ 'mysql' => '\\Ubiquity\\db\\providers\\pdo\\drivers\\MysqlDriverMetas','pgsql' => '\\Ubiquity\\db\\providers\\pdo\\drivers\\PgsqlDriverMetas','sqlite' => '\\Ubiquity\\db\\providers\\pdo\\drivers\\SqliteDriverMetas' ]
 
 $transactionLevel = 0
 
 $dbType
 
 $driverMetaDatas
 
- Protected Attributes inherited from AbstractDbWrapper
 $dbInstance
 
 $statements
 
 $operations
 

Static Protected Attributes

static $savepointsDrivers = [ 'pgsql' => true,'mysql' => true,'sqlite' => true ]
 

Static Private Attributes

static $quotes = [ 'mysql' => '`','sqlite' => '"','pgsql' => '"' ]
 

Additional Inherited Members

- Data Fields inherited from AbstractDbWrapper
const PHP_TYPES = [ 'string' => true,'bool' => true,'float' => true,'int' => true ]
 
 $quote
 

Detailed Description

Definition at line 17 of file PDOWrapper.php.

Constructor & Destructor Documentation

◆ __construct()

__construct (   $dbType = 'mysql')

Definition at line 42 of file PDOWrapper.php.

Member Function Documentation

◆ _optExecuteAndFetch()

_optExecuteAndFetch (   $statement,
array  $values = null,
  $one = false 
)

Reimplemented from AbstractDbWrapper.

Definition at line 218 of file PDOWrapper.php.

◆ _optPrepareAndExecute()

_optPrepareAndExecute (   $sql,
array  $values = null,
  $one = false 
)

Reimplemented from AbstractDbWrapper.

Definition at line 204 of file PDOWrapper.php.

◆ beginTransaction()

beginTransaction ( )

Reimplemented from AbstractDbWrapper.

Definition at line 168 of file PDOWrapper.php.

◆ bindValueFromStatement()

bindValueFromStatement (   $statement,
  $parameter,
  $value 
)

Used by DAO.

Parameters
mixed$statement
string$parameter
mixed$value

Reimplemented from AbstractDbWrapper.

Definition at line 122 of file PDOWrapper.php.

◆ commit()

commit ( )

Reimplemented from AbstractDbWrapper.

Definition at line 154 of file PDOWrapper.php.

◆ connect()

connect ( string  $dbType,
  $dbName,
  $serverName,
string  $port,
string  $user,
string  $password,
array  $options 
)

Reimplemented from AbstractDbWrapper.

Definition at line 105 of file PDOWrapper.php.

◆ execute()

execute (   $sql)

Definition at line 101 of file PDOWrapper.php.

◆ executeStatement()

executeStatement (   $statement,
array  $values = null 
)

Reimplemented from AbstractDbWrapper.

Definition at line 138 of file PDOWrapper.php.

◆ fetchAll()

fetchAll (   $statement,
array  $values = null,
  $mode = null 
)

Reimplemented from AbstractDbWrapper.

Definition at line 60 of file PDOWrapper.php.

◆ fetchAllColumn()

fetchAllColumn (   $statement,
array  $values = null,
string  $column = null 
)

Reimplemented from AbstractDbWrapper.

Definition at line 47 of file PDOWrapper.php.

◆ fetchColumn()

fetchColumn (   $statement,
array  $values = null,
int  $columnNumber = null 
)

Reimplemented from AbstractDbWrapper.

Definition at line 88 of file PDOWrapper.php.

◆ fetchOne()

fetchOne (   $statement,
array  $values = null,
  $mode = null 
)

Reimplemented from AbstractDbWrapper.

Definition at line 70 of file PDOWrapper.php.

◆ getAvailableDrivers()

static getAvailableDrivers ( )
static

Reimplemented from AbstractDbWrapper.

Definition at line 80 of file PDOWrapper.php.

◆ getDriverMetaDatas()

getDriverMetaDatas ( )
protected
Exceptions
DBException
Returns
\Ubiquity\db\providers\pdo\drivers\AbstractDriverMetaDatas

Definition at line 30 of file PDOWrapper.php.

◆ getDSN()

getDSN ( string  $serverName,
string  $port,
string  $dbName,
string  $dbType = 'mysql' 
)

Reimplemented from AbstractDbWrapper.

Definition at line 114 of file PDOWrapper.php.

◆ getFieldsInfos()

getFieldsInfos (   $tableName)

Reimplemented from AbstractDbWrapper.

Definition at line 200 of file PDOWrapper.php.

◆ getForeignKeys()

getForeignKeys (   $tableName,
  $pkName,
  $dbName = null 
)

Reimplemented from AbstractDbWrapper.

Definition at line 196 of file PDOWrapper.php.

◆ getPrimaryKeys()

getPrimaryKeys (   $tableName)

Reimplemented from AbstractDbWrapper.

Definition at line 192 of file PDOWrapper.php.

◆ getRowNum()

getRowNum ( string  $tableName,
string  $pkName,
string  $condition 
)

Reimplemented from AbstractDbWrapper.

Definition at line 235 of file PDOWrapper.php.

◆ getStatement()

getStatement (   $sql)

Definition at line 95 of file PDOWrapper.php.

◆ getTablesName()

getTablesName ( )

Reimplemented from AbstractDbWrapper.

Definition at line 142 of file PDOWrapper.php.

◆ groupConcat()

groupConcat ( string  $fields,
string  $separator 
)

Reimplemented from AbstractDbWrapper.

Definition at line 239 of file PDOWrapper.php.

◆ inTransaction()

inTransaction ( )

Reimplemented from AbstractDbWrapper.

Definition at line 150 of file PDOWrapper.php.

◆ lastInsertId()

lastInsertId (   $name = null)

Reimplemented from AbstractDbWrapper.

Definition at line 56 of file PDOWrapper.php.

◆ migrateOperation()

migrateOperation ( string  $operation)

Returns the SQL string for a migration operation.

Parameters
string$operation
Returns
string

Reimplemented from AbstractDbWrapper.

Definition at line 252 of file PDOWrapper.php.

◆ nestable()

nestable ( )

Reimplemented from AbstractDbWrapper.

Definition at line 184 of file PDOWrapper.php.

◆ ping()

ping ( )

Reimplemented from AbstractDbWrapper.

Definition at line 188 of file PDOWrapper.php.

◆ prepareStatement()

prepareStatement ( string  $sql)

Reimplemented from AbstractDbWrapper.

Definition at line 84 of file PDOWrapper.php.

◆ query()

query ( string  $sql)

Reimplemented from AbstractDbWrapper.

Definition at line 126 of file PDOWrapper.php.

◆ queryAll()

queryAll ( string  $sql,
int  $fetchStyle = null 
)

Reimplemented from AbstractDbWrapper.

Definition at line 130 of file PDOWrapper.php.

◆ queryColumn()

queryColumn ( string  $sql,
int  $columnNumber = null 
)

Reimplemented from AbstractDbWrapper.

Definition at line 134 of file PDOWrapper.php.

◆ quoteValue()

quoteValue (   $value,
  $type = 2 
)

Reimplemented from AbstractDbWrapper.

Definition at line 231 of file PDOWrapper.php.

◆ releasePoint()

releasePoint (   $level)

Reimplemented from AbstractDbWrapper.

Definition at line 176 of file PDOWrapper.php.

◆ rollBack()

rollBack ( )

Reimplemented from AbstractDbWrapper.

Definition at line 161 of file PDOWrapper.php.

◆ rollbackPoint()

rollbackPoint (   $level)

Reimplemented from AbstractDbWrapper.

Definition at line 180 of file PDOWrapper.php.

◆ savePoint()

savePoint (   $level)

Reimplemented from AbstractDbWrapper.

Definition at line 172 of file PDOWrapper.php.

◆ setIsolationLevel()

setIsolationLevel (   $isolationLevel)

Sets the isolation level for transactions.

Parameters
$isolationLevel
Returns
mixed|void
Exceptions
DBException

Reimplemented from AbstractDbWrapper.

Definition at line 262 of file PDOWrapper.php.

◆ statementRowCount()

statementRowCount (   $statement)

Reimplemented from AbstractDbWrapper.

Definition at line 146 of file PDOWrapper.php.

◆ toStringOperator()

toStringOperator ( )

Reimplemented from AbstractDbWrapper.

Definition at line 243 of file PDOWrapper.php.

Field Documentation

◆ $dbType

$dbType
protected

Definition at line 22 of file PDOWrapper.php.

◆ $driverMetaDatas

$driverMetaDatas
protected

Definition at line 23 of file PDOWrapper.php.

◆ $driversMetasClasses

$driversMetasClasses = [ 'mysql' => '\\Ubiquity\\db\\providers\\pdo\\drivers\\MysqlDriverMetas','pgsql' => '\\Ubiquity\\db\\providers\\pdo\\drivers\\PgsqlDriverMetas','sqlite' => '\\Ubiquity\\db\\providers\\pdo\\drivers\\SqliteDriverMetas' ]
protected

Definition at line 20 of file PDOWrapper.php.

◆ $quotes

$quotes = [ 'mysql' => '`','sqlite' => '"','pgsql' => '"' ]
staticprivate

Definition at line 19 of file PDOWrapper.php.

◆ $savepointsDrivers

$savepointsDrivers = [ 'pgsql' => true,'mysql' => true,'sqlite' => true ]
staticprotected

Definition at line 18 of file PDOWrapper.php.

◆ $transactionLevel

$transactionLevel = 0
protected

Definition at line 21 of file PDOWrapper.php.


The documentation for this class was generated from the following file: