PHP Titon\Db Query::intersect Examples

Programming Language: PHP

Namespace/Package Name: Titon\Db

Class/Type: Query

Method/Function: intersect

Examples at hotexamples.com: 1

PHP Titon\Db Query::intersect - 1 examples found. These are the top rated real world PHP examples of Titon\Db\Query::intersect extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

getType(7)

expr(6)

func(5)

getWhere(4)

where(3)

data(3)

fields(3)

from(3)

getRepository(2)

union(2)

raw(2)

leftJoin(2)

getJoins(2)

getFields(2)

getData(2)

getCompounds(2)

getLimit(1)

getOrderBy(1)

bindCallback(1)

getSchema(1)

getTable(1)

getGroupedBindings(1)

getAttributes(1)

intersect(1)

getAlias(1)

except(1)

schema(1)

subQuery(1)

cache(1)

attribute(1)

Example #1

Show file

File: DialectTest.php Project: titon/db

 public function testFormatCompounds()
 {
     // union
     $query = new Query(Query::INSERT, new User());
     $query->union($query->subQuery('id')->from('u1'));
     $this->assertRegExp('/UNION\\s+SELECT\\s+(`|\\")?id(`|\\")? FROM (`|\\")?u1(`|\\")?/', $this->object->formatCompounds($query->getCompounds()));
     // union all
     $query->union($query->subQuery('id')->from('u2'), 'all');
     $this->assertRegExp('/UNION\\s+SELECT\\s+(`|\\")?id(`|\\")? FROM (`|\\")?u1(`|\\")? UNION ALL SELECT\\s+(`|\\")?id(`|\\")? FROM (`|\\")?u2(`|\\")?/', $this->object->formatCompounds($query->getCompounds()));
     // union distinct
     $query = new Query(Query::INSERT, new User());
     $query->union($query->subQuery('id')->from('u1'), 'distinct');
     $this->assertRegExp('/UNION DISTINCT SELECT\\s+(`|\\")?id(`|\\")? FROM (`|\\")?u1(`|\\")?/', $this->object->formatCompounds($query->getCompounds()));
     // intersects
     $query = new Query(Query::INSERT, new User());
     $query->intersect($query->subQuery('id')->from('u1'));
     $this->assertRegExp('/INTERSECT\\s+SELECT\\s+(`|\\")?id(`|\\")? FROM (`|\\")?u1(`|\\")?/', $this->object->formatCompounds($query->getCompounds()));
     // intersects all
     $query->intersect($query->subQuery('id')->from('u2'), 'all');
     $this->assertRegExp('/INTERSECT\\s+SELECT\\s+(`|\\")?id(`|\\")? FROM (`|\\")?u1(`|\\")? INTERSECT ALL SELECT\\s+(`|\\")?id(`|\\")? FROM (`|\\")?u2(`|\\")?/', $this->object->formatCompounds($query->getCompounds()));
     // excepts
     $query = new Query(Query::INSERT, new User());
     $query->except($query->subQuery('id')->from('u1'));
     $this->assertRegExp('/EXCEPT\\s+SELECT\\s+(`|\\")?id(`|\\")? FROM (`|\\")?u1(`|\\")?/', $this->object->formatCompounds($query->getCompounds()));
     // excepts all
     $query->except($query->subQuery('id')->from('u2'), 'all');
     $this->assertRegExp('/EXCEPT\\s+SELECT\\s+(`|\\")?id(`|\\")? FROM (`|\\")?u1(`|\\")? EXCEPT ALL SELECT\\s+(`|\\")?id(`|\\")? FROM (`|\\")?u2(`|\\")?/', $this->object->formatCompounds($query->getCompounds()));
 }