class SQLAzureShardManager implements ShardManager (View source)

Sharding using the SQL Azure Federations support.

Methods

__construct(Connection $conn)

No description

string
getFederationName()

Get name of the federation

string
getDistributionKey()

Get the distribution key

string
getDistributionType()

Get the Doctrine Type name used for the distribution

void
setFilteringEnabled(bool $flag)

Enabled/Disable filtering on the fly.

void
selectGlobal()

Select global database with global data.

void
selectShard($distributionValue)

SELECT queries after this statement will be issued against the selected shard.

string
getCurrentDistributionValue()

Get the distribution value currently used for sharding.

array
getShards()

Get information about the amount of shards and other details.

array
queryAll(string $sql, array $params = array(), array $types = array())

Query all shards in undefined order and return the results appended to each other. Restore the previous distribution value after execution.

splitFederation(mixed $splitDistributionValue)

Split Federation at a given distribution value.

Details

__construct(Connection $conn)

Parameters

Connection $conn

string getFederationName()

Get name of the federation

Return Value

string

string getDistributionKey()

Get the distribution key

Return Value

string

string getDistributionType()

Get the Doctrine Type name used for the distribution

Return Value

string

void setFilteringEnabled(bool $flag)

Enabled/Disable filtering on the fly.

Parameters

bool $flag

Return Value

void

void selectGlobal()

Select global database with global data.

This is the default database that is connected when no shard is selected.

Return Value

void

void selectShard($distributionValue)

SELECT queries after this statement will be issued against the selected shard.

Parameters

$distributionValue

Return Value

void

Exceptions

ShardingException If no value is passed as shard identifier.

string getCurrentDistributionValue()

Get the distribution value currently used for sharding.

Return Value

string

array getShards()

Get information about the amount of shards and other details.

Format is implementation specific, each shard is one element and has a 'name' attribute at least.

Return Value

array

array queryAll(string $sql, array $params = array(), array $types = array())

Query all shards in undefined order and return the results appended to each other. Restore the previous distribution value after execution.

Using {@link Connection::fetchAll} to retrieve rows internally.

Parameters

string $sql
array $params
array $types

Return Value

array

splitFederation(mixed $splitDistributionValue)

Split Federation at a given distribution value.

Parameters

mixed $splitDistributionValue