PHP Class LazyRecord\ConnectionManager

$connManager = ConnectionManager::getInstance(); $conn = $connManager->create( '{{id}}', '' ); $conn = $connManager->default(); // return PDO connection object $result = $conn->query( ); $stm = $conn->prepare( ); $stm->execute( ); foreach( $connManager as $dataSourceId => $dataSourceConfig ) { }
Inheritance: implements ArrayAcces\ArrayAccess
显示文件 Open project: corneltek/lazyrecord Class Usage Examples

Protected Properties

Property Type Description
$conns contains PDO connection objects.
$datasources contains data source configurations

Public Methods

Method Description
__destruct ( )
add ( Connection $conn, string $id = 'default' ) Add connection.
addDataSource ( string $id, array $config ) Add custom data source:.
close ( $sourceId ) Close connection.
closeAll ( ) Close all connections.
free ( ) free connections, reset data sources.
get ( $dsId )
getConnection ( $sourceId ) Create connection.
getDataSource ( $id ) : array Get datasource config.
getDataSourceIdList ( ) : array Return datasource id(s).
getDefaultConnection ( ) : string Get default data source id.
getDriverType ( $id )
getInstance ( ) Get singleton instance.
getQueryDriver ( string $id ) : LazyRecord\QueryDriver Get SQLBuilder\QueryDriver by data source id.
has ( string $id ) Check if we have connected already.
hasDataSource ( $id = 'default' )
init ( ConfigLoader $config )
offsetExists ( string $name ) Check if a connection exists.
offsetGet ( string $name ) Get connection by data source id.
offsetSet ( string $name, Connection $value ) ArrayAccess interface.
offsetUnset ( $name )
prepareAndExecute ( $dsId, $sql, array $args = [] )
query ( $dsId, string $sql ) get pdo connetion and make a query.
removeDataSource ( $id )

Method Details

__destruct() public method

public __destruct ( )

add() public method

Add connection.
public add ( Connection $conn, string $id = 'default' )
$conn Connection pdo connection
$id string data source id

addDataSource() public method

source config:
public addDataSource ( string $id, array $config )
$id string data source id
$config array data source config

close() public method

Close connection.
public close ( $sourceId )

closeAll() public method

Close all connections.
public closeAll ( )

free() public method

free connections, reset data sources.
public free ( )

get() public method

public get ( $dsId )

getConnection() public method

$dbh = new Connection('mysql:host=localhost;dbname=test', $user, $pass); $pdo = new Connection( 'mysql:host=hostname;dbname=defaultDbName', 'username', 'password', array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") ); $dbh = new Connection('pgsql:dbname=$dbname; host=$host; username=$username; password=$password'); $pdo = new Connection( 'sqlite::memory:', null, null, array(PDO::ATTR_PERSISTENT => true) ); sqlite2:mydb.sq2
public getConnection ( $sourceId )

getDataSource() public method

Get datasource config.
public getDataSource ( $id ) : array
return array

getDataSourceIdList() public method

Return datasource id(s).
public getDataSourceIdList ( ) : array
return array key list

getDefaultConnection() public method

Get default data source id.
public getDefaultConnection ( ) : string
return string 'default'

getDriverType() public method

public getDriverType ( $id )

getInstance() public static method

Get singleton instance.
public static getInstance ( )

getQueryDriver() public method

Get SQLBuilder\QueryDriver by data source id.
public getQueryDriver ( string $id ) : LazyRecord\QueryDriver
$id string datasource name
return LazyRecord\QueryDriver

has() public method

Check if we have connected already.
public has ( string $id )
$id string data source id.

hasDataSource() public method

public hasDataSource ( $id = 'default' )

init() public method

public init ( ConfigLoader $config )
$config ConfigLoader

offsetExists() public method

Check if a connection exists.
public offsetExists ( string $name )
$name string

offsetGet() public method

Get connection by data source id.
public offsetGet ( string $name )
$name string

offsetSet() public method

ArrayAccess interface.
public offsetSet ( string $name, Connection $value )
$name string
$value Connection

offsetUnset() public method

public offsetUnset ( $name )

prepareAndExecute() public method

public prepareAndExecute ( $dsId, $sql, array $args = [] )
$args array

query() public method

get pdo connetion and make a query.
public query ( $dsId, string $sql )
$sql string SQL statement

removeDataSource() public method

public removeDataSource ( $id )

Property Details

$conns protected_oe property

contains PDO connection objects.
protected $conns

$datasources protected_oe property

contains data source configurations
protected $datasources