public function testDumpEchoEmptyQS()
{
$name = "Rob Halford";
Person::objects()->filter("name", "=", $name)->delete();
ob_start();
Person::objects()->filter("name", "=", $name)->dump();
$actual = ob_get_clean();
$this->assertSame("", $actual);
}
public function testCaseInsensitiveLike()
{
$qs = Person::objects()->filter('name', 'ilike', 'pero');
$qs->delete();
$this->assertFalse($qs->exists());
Person::fromArray(array('name' => "PERO"))->insert();
Person::fromArray(array('name' => "pero"))->insert();
Person::fromArray(array('name' => "Pero"))->insert();
Person::fromArray(array('name' => "pERO"))->insert();
$this->assertSame(4, $qs->count());
$this->assertCount(4, $qs->fetch());
}
function testQuerySet()
{
$condition = "lower(name) = ?";
$arguments = array('foo');
$qs = Person::objects()->filter($condition, $arguments);
$filter1 = $qs->getFilter();
$expected = "\\Phormium\\Filter\\CompositeFilter";
$this->assertInstanceOf($expected, $filter1);
$this->assertSame('AND', $filter1->getOperation());
$filters = $filter1->getFilters();
$this->assertCount(1, $filters);
$filter2 = $filters[0];
$expected = "\\Phormium\\Filter\\RawFilter";
$this->assertInstanceOf($expected, $filter2);
$this->assertSame($condition, $filter2->condition);
$this->assertSame($arguments, $filter2->arguments);
}
public function testAll()
{
Contact::objects()->delete();
Asset::objects()->delete();
Person::objects()->delete();
$actual = Person::all();
$this->assertInternalType('array', $actual);
$this->assertEmpty($actual);
Person::fromArray(array('name' => "Freddy Mercury"))->insert();
Person::fromArray(array('name' => "Brian May"))->insert();
Person::fromArray(array('name' => "Roger Taylor"))->insert();
$actual = Person::all();
$this->assertInternalType('array', $actual);
$this->assertCount(3, $actual);
}
public function testGetMeta()
{
// Just to improve code coverage
$meta1 = Person::getMeta();
$meta2 = Person::objects()->getMeta();
$this->assertSame($meta1, $meta2);
}
/**
* @expectedException \Exception
* @expectedExceptionMessage Offset must be an integer or null.
*/
public function testLimitedFetchWrongOffset2()
{
Person::objects()->limit(1, "a");
}
