Combine Class Reference

Combine SQL statement - allows combining multiple select statements into one. More...

Public Member Functions
	__construct ($select=null, $type=self::COMBINE_UNION, $modifier= '')
	combine ($select, $type=self::COMBINE_UNION, $modifier= '')
	Create combine clause.
	union ($select, $modifier= '')
	Create union clause.
	except ($select, $modifier= '')
	Create except clause.
	intersect ($select, $modifier= '')
	Create intersect clause.
	alignColumns ()
	getRawState ($key=null)
	Get raw state.
Public Member Functions inherited from AbstractPreparableSql
	prepareStatement (AdapterInterface $adapter, StatementContainerInterface $statementContainer)
	Parameters AdapterInterface $adapter StatementContainerInterface $statementContainer Returns void
Public Member Functions inherited from AbstractSql
	getSqlString (PlatformInterface $adapterPlatform=null)
	Get SQL string for statement. Parameters null | PlatformInterface $adapterPlatform Returns string

Public Attributes
const	COLUMNS = 'columns'
const	COMBINE = 'combine'
const	COMBINE_UNION = 'union'
const	COMBINE_EXCEPT = 'except'
const	COMBINE_INTERSECT = 'intersect'

Protected Member Functions
	buildSqlString (PlatformInterface $platform, DriverInterface $driver=null, ParameterContainer $parameterContainer=null)
	Build sql string.

Protected Attributes
	$specifications

Detailed Description

Combine SQL statement - allows combining multiple select statements into one.

Constructor & Destructor Documentation

__construct	(		$select = null,
			$type = self::COMBINE_UNION,
			$modifier = ''
	)

Parameters

Select | array | null	$select
string	$type
string	$modifier

Member Function Documentation

alignColumns

(

)

Returns

$this

buildSqlString ( PlatformInterface  $platform, DriverInterface  $driver = null, ParameterContainer  $parameterContainer = null  )

protected

Build sql string.

Parameters

PlatformInterface	$platform
DriverInterface	$driver
ParameterContainer	$parameterContainer

Returns

string

combine	(		$select,
			$type = self::COMBINE_UNION,
			$modifier = ''
	)

Create combine clause.

Parameters

Select | array	$select
string	$type
string	$modifier

Returns

self

except	(		$select,
			$modifier = ''
	)

Create except clause.

Parameters

Select | array	$select
string	$modifier

Returns

self

getRawState

(

$key = null

)

Get raw state.

Parameters

string

$key

Returns

array

intersect	(		$select,
			$modifier = ''
	)

Create intersect clause.

Parameters

Select | array	$select
string	$modifier

Returns

self

union	(		$select,
			$modifier = ''
	)

Create union clause.

Parameters

Select | array	$select
string	$modifier

Returns

self

Member Data Documentation

$specifications

protected

Initial value:

= [
        self::COMBINE => '%1$s (%2$s) '

const COLUMNS = 'columns'

const COMBINE = 'combine'

const COMBINE_EXCEPT = 'except'

const COMBINE_INTERSECT = 'intersect'

const COMBINE_UNION = 'union'