Example #1
0
 public function testIntegerToQueryNowWithNulls()
 {
     $db = $this->connectionFactory->get('R');
     $set = new Integer();
     $set->sqlIdentifierSet('n');
     $query = new Query("SELECT n FROM ( VALUES (NULL),(1),(2),(3),(4),(5),(6),(7),(8) ) AS _( n) WHERE %set:%", array('set' => $set));
     $set->none()->add('\\0,1');
     $result = $db->query($query)->fetch(Result::TYPE_DETECT);
     $this->assertSame($result, array(null, 1));
     $set->none()->add('1-8');
     $result = $db->query($query)->fetch(Result::TYPE_DETECT);
     $this->assertSame($result, range(1, 8));
     $set->all();
     $result = $db->query($query)->fetch(Result::TYPE_DETECT);
     $this->assertSame(count($result), 9);
 }
Example #2
0
 public function testInvert()
 {
     $set = new Integer(5);
     $this->assertSame((string) $set->invert(), '\\0,-4,6-');
     $set = new Integer('1,3');
     $this->assertSame((string) $set->invert(), '\\0,-0,2,4-');
     $set = new Integer('-');
     $this->assertSame((string) $set->invert(), '\\0');
     $set = new Integer('\\0');
     $this->assertSame((string) $set->invert(), '-');
     $set = new Integer('');
     $this->assertSame((string) $set->invert(), '\\0,-');
     $this->assertSame((string) $set->invert(), '');
     $set = new Integer('6-');
     $this->assertSame((string) $set->invert(), '\\0,-5');
     $set = new Integer('-6');
     $this->assertSame((string) $set->invert(), '\\0,7-');
 }