PHP DatabaseAdapter::Filter Beispiele

Beispiel #1

Datei: database_adapter.test.php Projekt: laiello/php-garden

 function test_Relation()
 {
     $this->assertEqual(DatabaseAdapter::Filter('name', ATTR_IS, 'foobar'), "(name = 'foobar')");
     $this->assertEqual(DatabaseAdapter::Filter('name', ATTR_IS_NOT, 'foobar'), "(name <> 'foobar')");
     $this->assertEqual(DatabaseAdapter::Filter('name', ATTR_HAS, 'bcd'), "(name = '%bcd%')");
     $this->assertEqual(DatabaseAdapter::Filter('name', ATTR_HAS_NO, 'bcd'), "(name <> '%bcd%')");
     $this->assertEqual(DatabaseAdapter::Filter('type', ATTR_IN, array('foo', 'bar', 'baz')), "(type IN ('foo', 'bar', 'baz'))");
     $this->assertEqual(DatabaseAdapter::Filter('type', ATTR_NOT_IN, array('foo', 'bar', 'baz')), "(type NOT IN ('foo', 'bar', 'baz'))");
     $this->assertEqual(DatabaseAdapter::Filter('volume', ATTR_BETWEEN, array(1, 5)), "(volume BETWEEN 1 AND 5)");
     $this->assertEqual(DatabaseAdapter::Filter('volume', ATTR_OUTSIDE, array(0, 5)), "(volume NOT BETWEEN 0 AND 5)");
 }

Beispiel #2

Datei: item-TODO.php Projekt: laiello/php-garden

 private function getConditions()
 {
     return DatabaseAdapter::Filter($this->conditions);
 }